PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 [95] 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163

  1. Excel manual subtotals
  2. Solved: Save as date
  3. Solved: UserForm event 2
  4. Macros in Excel
  5. Find column (in Excel address) of matching value in array
  6. Copy Images within Selected Cells
  7. Solved: Before Close
  8. Solved: Keep the only Sheet
  9. Security Level change
  10. problem with running event-based macro
  11. Retain Contents of Clipboard
  12. Missing Sequential Number In Station Column
  13. Pivot - Removing Calculated Field
  14. Solved: delete from nth character
  15. Function to count values but not formulae
  16. Edit cells from listbox with userform
  17. Solved: Return a value into a textbox when selecting a worksheet name from a combobox
  18. Help to update data repeatedly by VBA
  19. Solved: Loop through two worksheets
  20. Solved: countif function
  21. Concatenate VBA that Keeps Applied Formatting
  22. Solved: Selecting an Empty Row and range naming the selected cells
  23. Solved: Formatting a Multi-Conditional If,Then Statement
  24. Solved: Worksheet Problem
  25. SendInput() in Excel 64Bit
  26. Accessing records in Recorset
  27. Solved: Syntax error: please help
  28. Changing cell references to activecell reference
  29. Search UserForm
  30. Similar change, multiple worksheets
  31. Solved: Dynamic Pivot Table contents
  32. Select the first two similar values
  33. Importing .html file into Sheet in Excel in VBA
  34. Solved: Can this code be shorten vba
  35. Shape Fill by Clipboard
  36. Need Excel VBA Help
  37. Solved: help on workbook connection vba
  38. Exporting worksheet and overwriting
  39. Compiling data
  40. Solved: returning cursor to incomplete textbox within userform
  41. Problem finding ranges without using Selection
  42. Solved: autocomplete in a cell
  43. UserForm_QueryClose vs Unload Me
  44. Unprotect then protect after Workbook is opened
  45. Distinguish between two similar values
  46. Using conditional FormatConditions Method
  47. Open another workbook and search for cusips
  48. VBA reading multiline textbox line by line
  49. Creating Links
  50. Linking Sheets
  51. Duplicating macros across worksheets
  52. If two geographical data match in two sheets, then add/copy/replicate unique id/code
  53. Solved: Selection code is not accepted
  54. a named range with more than seperated range
  55. Searching for items in another excel sheet
  56. Elimination of things in a cell
  57. Excel VBA/Macro - Search against Multiple Criteria
  58. Solved: on open show combobox with 10 choices
  59. Solved: Add Caption problem
  60. Solved: Activate the Add-In Screen with VBA
  61. Solved: Application.Visible = False
  62. Scrollbar for list of Labels
  63. Filling cells with a formula
  64. text display
  65. File name in cell
  66. selcting then hiding
  67. Solved: Who opened my workbook?
  68. Trying to get a False result from DTPicker
  69. How can I speed up my RemoveAt procedure?
  70. To identify the duplicate rows and copy the unique rows alone from sheet1 to sheet2
  71. Solved: How to fix a formula value without vba
  72. Sheets
  73. Remove words
  74. call a sub from another sub
  75. Simple way to know Control Panel status
  76. Solved: Errors with date functions
  77. multiple text file import in single excel sheet
  78. check if a value is in a recordset
  79. Hide Macro code
  80. how to add my company logo as footer on every sheet vba.
  81. Can't find project or library
  82. Active Directory Query with Macro
  83. VBA CODE FOR PIVOT TABLE
  84. Select the MIN value in a data range
  85. VBA Excel 2007
  86. Pivot Table Autoformat XL2003
  87. Check if cells is empty
  88. Solved: VBA to exclude Public Holidays
  89. Password protected Workbook
  90. Solved: Select Cooresponding Cell Fron Listbox
  91. Duplicate values
  92. Delete empty rows
  93. Solved: Disable "save changes" pop up when closing
  94. Solved: ComboBox (SOLVED)
  95. locking cells without sheet protection
  96. Solved: loop in a loop
  97. Applying formulas to certain cells
  98. Need help altering Planner VBA
  99. Solved: Deleting rows based on column content.
  100. Solved: refer to value in a cell in a macro
  101. veiw variable/ array values during debug
  102. macro to find and replace #ref errors with actual cell values, and stop at last sheet
  103. Runtime error 1004
  104. How to add formula and value to cell VBA
  105. Help to generate week ending from days as per financial new
  106. Solved: Excel VBA comparison wierdness / challenge
  107. Solved: Vba debugging Run-time error '1044':
  108. VBA: selecting data to be outputted to new sheet
  109. Solved: removing part of string
  110. Select OLEobject checkbox PROGRAMMATICALLY???
  111. Drop down boxes and forms
  112. Cell references
  113. Problem with Interactive Graph with Rollover Hyperlinks and UDFs
  114. referencing information between userforms
  115. Making a workbook visible again
  116. Problem with my search/replace macro
  117. Error in expression
  118. Moving rows from one spreadsheet to another
  119. Solved: Filling a formula
  120. VBA: Selecting and Copying Columns [more complex than it sounds]
  121. Solved: Can these 2 VBA codes be merged in to 1
  122. Solved: If Or Statements with VLookup
  123. Solved: Dates as X-Axis for multi-series line or xy chart
  124. Solved: Select defined range
  125. Solved: Data Validation Macro Problem
  126. Solved: Need help to change column to comma style
  127. Solved: copy data fom 1 workbook to another, where itneeds to go to 2 different worksheets
  128. Solved: Finding and highlighting duplicate names
  129. VLOOKUP - works on 1 form but not on another
  130. Solved: vba help to automate report.
  131. VLOOKUP error codes in VB
  132. VBA: Selecting Sheet via Input Box or other way
  133. Solved: commandbutton that "follows" cursor
  134. Solved: Search Range of numbers and return missing
  135. Copying Multiple worksheets in Multiple workbooks to one single workbook
  136. Solved: Application display alert question
  137. Solved: VLOOKUP
  138. Solved: Colour Cells
  139. Best use of memory
  140. Solved: Footer Capation
  141. Solved: Drive Letter
  142. Solved: Can these 2 VBA's be combined
  143. Extracting Model Numbers
  144. Solved: Onaction property
  145. Solved: Select End Row
  146. Solved: Paint next three columns
  147. VBA script doesn't run
  148. Check port is up from VBA (Excel)
  149. Adding header data during data extraction
  150. Combo/List Box populated by user form entries
  151. Solved: Filling a formula
  152. When file is open Automatically run VBA
  153. Help Understanding Code Dealing with Creating New Spreadsheets
  154. Solved: Inserting cells in between entries
  155. Tabs to different work books.
  156. If there is no chart on activesheet, then go to NoChart.
  157. Hide CMD window that script shows.
  158. Solved: Tweeking formula
  159. Solved: Moving row to another space
  160. Solved: Cells with zero or no value - amend
  161. Limiting array size
  162. Solved: Bold last row of spreadsheet
  163. Solved: Apply formula to all cells in a column
  164. Solved: Mark as XXXXX
  165. Copying data from one sheet to a specific range of cells in a different workbook
  166. Copy data from first workbook to a different workbook based on cell value in first
  167. Manipulating recordset
  168. conversion of VBA to vb.net
  169. Simple Supply and Demand Model using Solver
  170. SEPARATE ROWS WHEN CONDITIONS MET
  171. Solved: Apply code to second to last line of spreadsheet
  172. Solved: Can't manage to rename updated version
  173. Solved: Range("e1").Row = 5 not e
  174. Solved: Placing text in a next empty Cell with VBA
  175. Ask: Pull data from another sheet with macro (excel 2003)
  176. Solved: Counting account numbers
  177. Create sheets from master but copy them to new book
  178. problem:filter pivotable with 2 text cells
  179. Solved: Word to excel & 'clip'
  180. Solved: Dealing with dates in macros
  181. Solved: Moving rows from one sheet to another using vlookup
  182. Unable to set the XValues property of the Series class
  183. Solved: Copy and pasting selection of data
  184. Solved: Accessing The Reference Cell Contained In The Excel VLookUp() Function From VBA !!
  185. Locking the name of a range
  186. Getting a total copied set of rows in VBA and storing it in a variable
  187. Solved: Copy and past in next available row
  188. Create a date entry for each day of the month
  189. Update everyday at 2:30
  190. Solved: Activating sub from another workbook
  191. Search and copy data (Macro)
  192. Multithreading Excel and Word
  193. Solved: Hidding button on worksheet depending on password
  194. how to close a workbook on network when its open by another user.
  195. Searching an array using two criterias
  196. Excel sending emails from a worksheet
  197. Event macro for auto-fit row height of merged cells
  198. List all files in a folder or import filenames into a merged document
  199. Solved: Multiple values using SUMPRODUCT
  200. Solved: Multiple files
  201. Solved: multiple Regular expressions on one cell to extract to new cells
  202. pivot table filters problem
  203. How to display updated process on userform for user
  204. Solved: Search box on an user form
  205. Help to calculate end date for each Dept VBA
  206. auto run a macro upon text entry into cell
  207. Solved: Problem with macro
  208. DELETE ROWS BASED ON DATE RANGE
  209. Solved: Help needed
  210. Combobox linked to Listbox
  211. Solved: VBA: Values on Sheet
  212. Exceldiet deletes entire worksheet
  213. Simple way to reduce the size of the Excel file
  214. Solved: Write in Col J just Before close
  215. Prevent various functions in document
  216. Solved: Delete empty rows
  217. Data Portal Design Requires Advanced Coding
  218. Solved: Delete Menu if exists
  219. Solved: Find unique values
  220. Solved: Combining Dynamic Ranges
  221. vba form check against text file
  222. Solved: Write function in forms
  223. Solved: Can anyone confirm the destructive effect of Exceldiet in the following case?
  224. How to open speadsheet on server populate with data then save and close it
  225. Post excel cell data to Ms Publisher
  226. Solved: Extracting required information
  227. Solved: Dynamic Sum Macro
  228. compare values and paste in another woksheet
  229. Internet Form Submission
  230. Solved: button that follows by click unables copying
  231. Add an HTML file as body of email
  232. KB Article: Creating multiple word tables from excel data
  233. Run-time error 457
  234. Solved: Renaming cells
  235. Solved: Copy and pasting ONLY selected cells
  236. Event macro does not run until I leave and return to a cell
  237. Sum if function
  238. Solved: Class Member
  239. Deleting a row that has certain characteristics
  240. macro for pivot
  241. Help exporting values to text file
  242. Solved: Filtered report issues.
  243. Using if then else in excel 2007
  244. Solved: Need Macro to Replace ## with the Column Heading Name
  245. Generate Unique Reference Numbers on a userform
  246. Solved: fixing code - automaticaly handling with many of combobox, labels...
  247. Transpose help.
  248. webquery macro for website with drop down menus
  249. Forms vba excel 2007
  250. Solved: Date format problem