PDA

View Full Version : Excel Programming


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 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309

  1. Modifing code to attach files to email
  2. Print Macro
  3. Recording a macro
  4. running macro deletes non designated cells
  5. Splitting a string with a hyphen in it
  6. SaveCopyAs
  7. Changing VBA code to return data range, appending to prior data
  8. macro to alter a formula
  9. Filtered Data in userform
  10. Workbook Save - Corrupt the VBA Code (VBE6.dll error)
  11. worksheet change not working
  12. Adding more than one column field to a pivot
  13. Hide All sheets
  14. Cells.find and .findnext
  15. Finding highest number in a range of cells
  16. Updates
  17. Writing an "insert page break" macro
  18. Automatically Clear Cell in Drop Down List
  19. Open 2 userforms
  20. VBA color fill black
  21. How to disable Hyperlinks from cells
  22. Stop column delete
  23. Edit worksheets from single worksheet
  24. experience run time error 11 on one computer not but another
  25. Dialog box "xlDialogOpenText" don't work
  26. Auto import & AutoRepublish
  27. Matching Two sets of Data and Get a New Output Sheet
  28. Match/IF formula
  29. Importing Consecutive CSVs
  30. how to edit result of web query?
  31. Placement of a particular line of code
  32. Disappearing form buttons + sticking autofilter arrows
  33. Choosing to develop in VBA - researching options
  34. excel vba question
  35. Macro - Fill Series Requires Two Rows of Data!?
  36. Select Unlocked Cells
  37. Hide/Unhide Tabs VBA
  38. Macro - Button to Insert new Row
  39. Rename tabs in a template to specific weeks.
  40. Cell values on a User Form
  41. VBA - Compare one column in two sheets & copy unmatched to one sheet
  42. Speeding up VBA
  43. Show a cell value on a form?
  44. Macro Insert Row
  45. Data from workbook to another workbook
  46. Problems in mail merge with attachment in Execel 2003
  47. VBA Program or Formulas ??
  48. macro to display formatting of an individual cell
  49. TextBox to display contents of any cell user selects
  50. Loading Email Templates from Excel
  51. Macro that can copy from external table
  52. Runtime error '13'
  53. Larger drop down boxes
  54. Turning on Relative Reference
  55. Macro Help. Creating a source sheet to pull information from.
  56. Combo Box - Display Unique Items in List
  57. auto fill in of excel invoice from outside database
  58. Navigate to Named Range from DropDown List
  59. how to over come limit of 7 imbedded if's
  60. #REF Results
  61. Edit
  62. Nested IF(OR....AND Statements
  63. YAVLQ - Yet Another VLookup Question
  64. Adding the units ordered for each unique seller
  65. Looping problem
  66. Vlookup question
  67. Application.SendKeys stopped working
  68. Cmd.exe linked to excel
  69. Deal or no deal
  70. Drop Down Arrow
  71. Excel Macro example needed
  72. Declaring errors
  73. Capital letter problem
  74. Type Mismatch Error
  75. Formatting the date
  76. PrintFile
  77. Save specific sheet
  78. Paste method of worksheet class failed
  79. vlookup problem
  80. Working with mileages
  81. Drop downs in excel 2007
  82. Login ID Unhides specific sheets!!
  83. Updating list of names each week
  84. Clever comment box
  85. Unhiding cells based on cell contents above
  86. Trim all Zero's
  87. VBA based conditional formatting (>3 formats needed)
  88. Bit of VB help please
  89. How to improve web query speed
  90. How to add filename for Acrobat printout?
  91. Macro for emailing attachments through Outlook
  92. Which Function?
  93. Macro that reqeats to end of a list
  94. Useing Access VBA code in Excel !
  95. Custom Toolbar Office Wide
  96. Macro to search and replace a macro
  97. macros - relative and absolute
  98. Cell content comparison
  99. Method 'SaveAs' failure
  100. Large .csv file VBA speed
  101. convert sumproduct copy/paste to MACRO
  102. Help with a counter
  103. Macro for Filtering in a Pivot Table
  104. If Worksheet function not working correctly
  105. I need faster code
  106. VB Loop in a Loop
  107. Problem with UDF and iteration
  108. Change from text to numbers
  109. Help with formula
  110. Userform textbox refresh data
  111. Changing source of PivotTables in XL2003
  112. Virtual AutoFill Macro
  113. Vlookup - Help!!!!
  114. Data storage in Excel
  115. CountIf?
  116. Count or Countif help needed
  117. Open Multiple Files
  118. 'If' Macro
  119. Refer to cells in array
  120. Overwriting problem.
  121. Form in Excel and saving records
  122. Problem moving data to new workbooks
  123. testing/debugging a UDF
  124. Disable "Move or Copy sheet" action
  125. Greying out some cells ?
  126. Data Analysis Add-In not working on specific workbook only
  127. creating if forumula - with drop down menu
  128. Fixed width txt file Macro
  129. Run-time error 1004 Copy formatted cells 2 excel applications
  130. How to combine multiple macros into one
  131. Stamp Username, Time & Date
  132. Populate combobox with Range names - xl2003
  133. Saving
  134. Populate combobox with Range names - xl2003
  135. Table of contents for contents of 1 sheet
  136. Emailing an Object macro
  137. Drop down/combo box help
  138. macro for multiple pivot tables
  139. Macro not performing correctly
  140. Dependent Drop Down lists (multiple drop down)
  141. Why is this Do Loop not working right?
  142. Examining alpha numeric data ?
  143. VBA match, index, lookup... confused
  144. Excel and XML: what is this combination good for?
  145. Vlookup only returns 1st match!
  146. Automatinf CSV Import
  147. Open database via password automation
  148. Insert Date and Time Picker value into Active Cell
  149. Probably easy one...hlp
  150. Select area to display
  151. Pulling data from source files
  152. Copying range from one workbook to another
  153. Roll over cell
  154. Trying to import multiple text files using "fixed width"
  155. vlookup with Name Ranges
  156. "Project is unviewable" when closing a shared workbook
  157. How to create a macro that will choose the last sheet on the right and...
  158. "IF" function in VB
  159. Macro suddenly quit working
  160. Filling a combo box via macro
  161. Using code with changing cell references
  162. Checking if file name already exists
  163. macro sorting drop down boxes
  164. Error 438 while accessing a range
  165. UserForm TexBox formating
  166. Check to see if outlook is open
  167. Finding the rownumber in excel sheet
  168. Dropdown menu (printing issue)
  169. Emailing Spreadsheet
  170. Copying and pasting entire rows
  171. Running a Macro behind the scene
  172. Logging
  173. named ranges over multiple sheets
  174. Sorting
  175. Updating data references across multiple books and sheets
  176. Error in Len() command
  177. Syntax Error adding Date Picker to a range
  178. Change linking using a list/combo box
  179. Highlighting multiple cells in multiple locked worksheets
  180. Add Condition to Macro
  181. show 2 userforms
  182. Macro wont run
  183. ComboBox on a Toolbar (msoControlComboBox)
  184. Copying Cell Data From Multiple Worksheets to One Worksheet
  185. Shortcuts key won't run entire macro
  186. How to Turn CAPS LOCK off / on?
  187. Cannot get Book to open with Excel
  188. Macro to open Windows directory
  189. Creating an outlook task from vba
  190. insert row when required
  191. My code try to open other workbooks.
  192. Offsetting variable
  193. Macro for Message until macro not ended
  194. Ordering system using macro
  195. Copy TextBox Value to a range in Excel
  196. Adding same items to more than one combo box
  197. How to save web query including timestamp
  198. Excel crashes when doing VLOOKUP
  199. duplicate and unqiue
  200. Replace Entire cell content
  201. Vlookup in VBA
  202. Trap Keystrokes
  203. Printing Filter Results
  204. Macro and not print a blank page?
  205. ActiveWorkbook.FollowHyperlink Question
  206. Picture search
  207. Warning override
  208. Cant figure out Macro Error
  209. VBA Vlookup Problem
  210. Querying a remote PH server?
  211. Save Option
  212. Problem with a sub trying to write in a locked cell.
  213. Complicated Combo Box creation
  214. Question about ranges
  215. Problem with a sub that autosave a workbook.
  216. Vlookup - Code Problem
  217. Checkbox Updating
  218. Sub to return ranking of numeric data with special rules
  219. How excel handles names in multiple sheets
  220. use function and sub from personal.xla
  221. Passing a worksheet into a subroutine
  222. Way to insert a Count Stmt inside an IF stmt without using RC References.
  223. Clearing all Check Boxes on Sheet
  224. COUNTIF help, just a quicky...
  225. calling variable from Userform
  226. simple macro help
  227. Excel not accepting Object & its dataType
  228. Selected cell move one column to the right
  229. Date Planner
  230. Macro to change the number cells in a average calculation.
  231. Excel Macro Questions
  232. Range of the ActiveCell
  233. make A1 the fist active cell in a spreadsheet
  234. Directory Listing code - Mod?
  235. Export messes up data type
  236. Any guru knows how to solve the problem?
  237. Custom Toolbar Help Needed!
  238. Trying to make a simple macro, need help...
  239. How do I return a cell address in a variable
  240. vba query simple variable
  241. Cell Formatting
  242. running subroutines concurrently
  243. Loop through rows, bind two cells
  244. Removing spaces in specific cells given certain criterias.
  245. Named Ranges and Memory Usage
  246. Offset References When Recording Macros
  247. Tab moving to new work books
  248. Macro copy wb1 to wb2 match date
  249. how to sort 2 column
  250. Detecting wrap around in a cell