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 164 165

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