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. Using the last row in a non-A column to combine sheets
  2. how to close a workbook without saving a individual worksheet?
  3. Delete Rows Based On Cell Contents
  4. Need Help On Listbox/combobox
  5. simple macro
  6. Extending color fill to the left in VBA
  7. Extending color fill to the left in VBA
  8. Allowing Tab Selection of Separate Combo Boxes?
  9. using cell content to reference a worksheet tab name in second workbook
  10. SendKeys not working
  11. Copy data to invoice sheet if cell = YES
  12. Can this be done ?
  13. Variables with spaces problem
  14. Data Manipulation
  15. conditional copy/paste
  16. Sequential numbers in different workbooks
  17. Vlookup then add copied data to cell on the right
  18. Conditional formatting w/ > 3 variables
  19. Error Handling whilst using routing slip
  20. Selecting the next blank cell in a range
  21. Running Total Highlight ???
  22. .csv file analysis question
  23. Organisation of a Table
  24. When open File A, runs macro in File B
  25. Using an ampersand to create a variable
  26. Warning message in excel vba
  27. Combobox on Userform
  28. A complicated "COUNTIF" question...
  29. Incorrect rendering of JPG image when zooming
  30. VBA Editing Problem
  31. Selecting cells in a one line array
  32. Best way to print to pdf file
  33. How to return blanks for $0.00 cells?
  34. Hidding Rows
  35. In case Run-time error '13' do this...
  36. P & L Calculation
  37. Shipping Marco
  38. VBA code for multiple formats
  39. Macro Sorts In Wrong Order
  40. vb code to return files giving too many files error message
  41. macro recording
  42. Copy and Transpose Repeating Data
  43. Hyperlink If statement
  44. Macro to select offset range
  45. Macro to filter based on identical column data as opposed to entire record
  46. Excel VBA Code
  47. Reseting the Result of a Macro?
  48. how to prevent user from clicking a button on error
  49. DblClick event does not work with combobox?
  50. Print Preview Lost
  51. Macro to copy columns in excel
  52. Validation on insert of special symbols
  53. Counting Completed Combo Boxes
  54. Auto-dating text boxes
  55. Embeded Combobox value to cell
  56. Formula with multiple if statement
  57. Cell Reference
  58. Data validation based on several fields
  59. Highlight winners in a list.
  60. searching a column
  61. Name Search in Excel User Sheet / Boolean?
  62. How do I assign a code to a button
  63. VBA compare with more than one result
  64. loop, matching data between ws
  65. Printing Multiple Sheets AND a range from within a separate sheet
  66. when do you use "SET" ?
  67. UserForm list population
  68. Watch window question
  69. Need Macro to detect cell range
  70. Macro looks for previous filename
  71. Deleting a range
  72. worksheet variable
  73. Autofill up to last cell of Range
  74. Application-defined or object-defined error
  75. Restricting Cell Contents
  76. Searching Worksheets By Name
  77. Progress Bar Help
  78. Paste link limitations, might need code.
  79. Print Macro
  80. Thank you everyone for always helping me
  81. Vlookup returns the #N/A when nothing is input in the source cell
  82. find the average of B correspond to their A
  83. does excel have the capability to react to the simple act of clicking a cell?
  84. macro for arranging data
  85. Macro Time Clock
  86. Autofilter VBA code
  87. Changing bolded text to quoted text
  88. Input box not collecting range object
  89. Sorting data by a predefined List
  90. How to use Standard Excel function in VBA
  91. Excel Database Command Help
  92. Refresh Subtotal's Button
  93. Hyperlinked Drop Down Menu
  94. Something simple for the programmers
  95. Returning Error Line Number
  96. Advanced Filter VBA - Adding More Criteria
  97. Check if variable is a member of an array
  98. Some doubts...
  99. Combo Box Crisis!
  100. "Contains" within an IF()
  101. Conditional saving in a given directory, with always changing file name
  102. network printer
  103. New entry in a Combobox
  104. Input Box Macro
  105. Any way to have gridlines in a list box ?
  106. msgbox vbcancel
  107. Problem with data retrieval from Access with ADO
  108. VBA Macro to export to Outlook
  109. Conditional Formatting
  110. Sum a column using VB with criteria
  111. .FindNext loop
  112. Open Workbook, Sheet Minimized VBA
  113. Final Program Tuneup and suggestions
  114. Assignment to Constant not Permitted
  115. Assignment to Constant not Permited
  116. form on network not working
  117. Contain Condition
  118. Run a macro from a drop down list
  119. user form data search
  120. Wildcard or "Begins With" in a Workbooks.open filename directory?
  121. Multipage control help
  122. Help with a Print Macro!!
  123. Macro for Organizing Production Data
  124. decimal places
  125. Formatting Without Selecting Range
  126. VBA - Freeze Panes on a NON Active Sheet
  127. The Final Bit Of Code Req. Please
  128. Using CDO.Message to email all files in a folder?
  129. run-time error 1004: Cannot change this part of a PivotTable report
  130. Runtime error '9'. Subscripts out of range - Dynamic array
  131. Data validation, Non-useable item
  132. Loop question
  133. Date formulae problem.
  134. Unusual error-handling results in previously working code written for Excel 2002
  135. accessing file created in different macro within the same project
  136. Opening a workbook, and how to reference it
  137. Conditional formatting Macro whole table at once
  138. Using macros within macros
  139. error Content created date format
  140. E-mail Subject via hyperlink
  141. advanced filtering
  142. Open Dialogue – filefilter:=
  143. run macro within macro
  144. Left function in a Select Case Macro
  145. run macro 'n' times
  146. Excel download
  147. How to use Range.Dependents ?
  148. Data caching in Excel 2007
  149. unable to excute query
  150. Logic Involved with the Macro - Last Row/Column
  151. programming error in office 2007 - object library
  152. Splash Screen opens after document
  153. Exporting/Importing modules between two workbooks
  154. How to code SUMIF function in a Macro
  155. find/replace text in multiple hyperlinks
  156. Macro to insert blank rows based on data above
  157. Need to follow hyperlinks in selection
  158. Emailing attachments macro
  159. Passing a Cell value to a Macro Sub
  160. Want to save a file with part of the name derived from an inputbox
  161. Adding a range then subtracting.....
  162. Excel xmlHTTP object error message - system/runtime error
  163. Separating data with similar characteristics
  164. Highlighting intersecting values in two tables
  165. Extracting 3 Arrays from 1 Array
  166. Time sheet problem
  167. How can I find the Tabs index
  168. Cell address
  169. A logical OR with more than choices
  170. Selecting sheets via a list.
  171. Best way to match time values to the nearest second
  172. Conditional formatting multiple rows
  173. Need help in Macro
  174. Balance of Year Macro?
  175. check checkbox
  176. Populate a combobox in a userform with a dynamic range.
  177. Deleting rows with a specific value
  178. Updating workbook_open from workbook_open
  179. Conditional Format a Row (Macro)
  180. Moving Linked Files
  181. How to insert a row in last data entry?
  182. Combobox populate textbox
  183. How to choose the next sheet on th right
  184. Module call problem
  185. Textbox value decimal problem
  186. ranking numbers in ascending order
  187. Populating form text box on combobox selection.
  188. Process Multiple Files at Once
  189. Immediate Window: How to increase its buffer size ?
  190. Connecting Excel With database Oracle - Inserting Record
  191. Assigning macro to SmartArt
  192. Highlight row(s) based on column value
  193. calculate
  194. Excel could not save...
  195. copying worksheet using VBA
  196. Use a Calendar to Autofill Date in Form
  197. Looping and Incrementing in Excel Macro/VBA
  198. Syntax
  199. xla files
  200. Matching two spreadsheets by time of day
  201. Copy a formula to specific number of cells to the right
  202. How to Stop a Macro Safely?
  203. Is this possible
  204. The "Next Cell" command in a "For Each ___ In ___" loop
  205. is it to only reposition
  206. Combo Box populate column
  207. Insert rows anywhere in existing spreadsheet.
  208. Add value to each cell
  209. Printing in word
  210. Variable - Rows("x:x").Select
  211. Circular Reference
  212. What do you Do: Overwriting?
  213. Copying rows to another worksheet
  214. More than one Worksheet_Change on a worksheet
  215. Finding a Value using a ComboBox
  216. climate project
  217. Custom Search and Replace Macro - Please help
  218. climate project
  219. Minimize workbook window
  220. Yes/No change cell function
  221. If Statement dependant on 2 cells
  222. Macro that copies from multiple sheets to one column
  223. Run Time Error 424
  224. combobox and for
  225. MSFlexgrid decimal places
  226. Population of a master workbook from several other workbooks
  227. excels material .pdf or .doc
  228. Conditional formatting code please
  229. MSFlexgrid colalignment
  230. measuring time between Change and Sheet Updated
  231. Getting postcode 4 digits from a line of text
  232. Count function and users hitting space bar
  233. Run-time error 1004
  234. Resize question
  235. Using sequential numbers
  236. commandbutton_click based on cell contents
  237. Macro to form Buttons or Appear/Disappear
  238. Not finding string error fix in macro find command
  239. Complicated Search Macro
  240. How to loop through worksheet and delete rows based on criteria
  241. ShowDataForm Method - Ready for Data Entry?
  242. Compare Two Columns In Two Worksheets To Copy And Paste A Third Column
  243. Working named ranges in multiple sheets from vba
  244. How to select all rows with same text
  245. Modifing code to attach files to email
  246. Print Macro
  247. Recording a macro
  248. running macro deletes non designated cells
  249. Splitting a string with a hyphen in it
  250. SaveCopyAs