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 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381

  1. Search User Form not working -vb reference? pls hlp
  2. Macro not working correctly, what did I do wrong?
  3. [SOLVED] Prevent excel from closing
  4. Combo Box help
  5. Placing brackets around numbers in one cell when another cell changes
  6. How to change QBasic "If Then" code to VBA code?
  7. Vba code for grocery checklist help needed ?
  8. Optimising row selection
  9. Can't Get Loop to Stop at Specific Range
  10. HELP-Error "Out of stack space macro!"
  11. [SOLVED] Networkday Formula not working
  12. [SOLVED] Count Instances, with a Twist
  13. *.CSV files copied into 1 existing XL File
  14. re-sizing image
  15. VBA code to count non blank cells in a range
  16. Macro for copying everything left of - and placing in other cells
  17. Formula help
  18. VBA to Filter Excel Data to a Different Sheet
  19. Calculating time logged in
  20. drop down menu to select and hide certain rows and columns
  21. Macro for current date
  22. [SOLVED] VBA code for an IF(AND...statement
  23. [SOLVED] Combining some sheets into another sheet
  24. Macro which creates a Hyperlink on the next available blank row?
  25. Excel is changing the date format when it shouldn't
  26. If fill colur is green enter text into listbox
  27. Delete rows based on column value
  28. Advanced Find and Replace
  29. [SOLVED] Alter code to reference different worksheet
  30. Copying formulas down in a sheet, using VBA
  31. [SOLVED] Excel 2007 VBA limits
  32. Copy and Paste between worksheets on ID match
  33. [SOLVED] Macro to rearrange different amounts of data
  34. Writing a macro to sum different length rows
  35. Formulae for multi spreadsheets
  36. list from many workbooks and file open
  37. Add delete row by macro
  38. Workbook changes, Lock Combobox
  39. How to return error code
  40. Count with 2 criteria
  41. 1004 This selection is not valid.
  42. Disabling command bars on worksheet activate event
  43. Maintain Formatting when referencing cells from other sheets
  44. Renaming new worksheet using date and name
  45. Data Filter problems,,
  46. renaming worksheet and moving data based on date
  47. Split my data into separate worksheets
  48. How to Copying data from master file to other Spreadsheet
  49. Macro that reads cell values
  50. Need to insert double-quotes to preserve commas in cells
  51. Custom function #VALUE error
  52. Foreign (non-English) characters in VBA
  53. Calculations slowing performance
  54. lookup and create summary sheet from data in existing workbook using vba
  55. Working with Sub function with Excel in background
  56. overide conditional formatting with VBA
  57. AdvancedFilter Sub
  58. Consolidate
  59. if Cell is full then move to next cell
  60. Date Picker Control will not display Current Date
  61. File opening Macro
  62. Count If?
  63. [SOLVED] Replace every other space in a string with "|"
  64. Index match with multiple criteria
  65. XML Export macro not working...
  66. Formatting numbers in userform
  67. Problem with Copy and PasteSpecial
  68. Automation Error in Excel VBA Macro
  69. Tooltip for Excel picture button
  70. Remove Filters on close
  71. Macro for available worksheets
  72. Listbox vba
  73. Copy data from sheet1 to sheet2
  74. Macro to separate data
  75. Copying named worksheet from a workbook to a new workbook
  76. [SOLVED] String Creating Function
  77. [SOLVED] change the word acceding to data
  78. Macro to copy certain cells in row
  79. Find and Replace with multiple conditions problem.
  80. Find & Replace/Formula Too Long
  81. Highlight a selected row
  82. Transferring Data between Worksheets, in Corresponding Datablocks
  83. macro for extracting certain columns
  84. export excel columns to TXT file, only if there is data
  85. runtime error "1004", no data selected to parse
  86. Dynamic Combobox
  87. Conditionally Hide Columns
  88. Standard Deviation Formula
  89. Help needed sending worksheets by email
  90. [SOLVED] How to automatically Open Workbook at particular time...???
  91. Displaying Binomial trees in excel
  92. Highlighting Macro
  93. [SOLVED] Generate a "Workbook Open" Macro in new worksheet Programmaticly
  94. Automatically insert row & Transpose
  95. Calculating relationships in a table
  96. Macro to create workbooks with key field name and automatic email
  97. [SOLVED] Problem with Aggregate Function ADO SQL
  98. Copying worksheet with macro
  99. Value Counting Problem
  100. Exproting info from Lotus files to spreadsheet
  101. Missing phrase
  102. [SOLVED] How to reference cell properties where function is written?
  103. How to remove tooltip to hyperlink
  104. Is it possible (lotus notes)VBA
  105. How to use Oracle stored procedure in Excel
  106. [SOLVED] 2 variables to create result
  107. [SOLVED] unable to read cell text data
  108. List box hide column
  109. Delete data with only 1 expiration date
  110. Help w/my macro in Excel 03 Appending
  111. Find * Column A and Paste Special Values
  112. #REF errors when using paste link in database
  113. automatic mailer to a certain id
  114. Prefix number with '
  115. VBA programming
  116. Print box with multiple criteria
  117. [SOLVED] Specifying Arguments in Run ([Macro], [arg1],[arg2]...)
  118. Repeat function on multiple columns
  119. Using a cell contents to construct a formula?
  120. Input two cell references into Excel Solver
  121. For-Next loop in 0.1 incriments
  122. Copying worksheet to new excel instance
  123. Create listbox w/ checkboxes in VBA?
  124. [SOLVED] Sub won't work on change event
  125. [SOLVED] Delete All Macros In Workbook
  126. Spreadsheet control in Excel 2007?
  127. Multiple Function issue
  128. if check box is marked that it also checks another cell
  129. [SOLVED] Problem averaging every other cell without 0's
  130. sending a worksheet by email using vba
  131. Saving Active Workbook as Variable
  132. [SOLVED] Autosum
  133. [SOLVED] Macro on multiple files and save in other fileformat
  134. Macro To Group Data From WorkBook With Exceptions
  135. VBA code to populate a table
  136. [SOLVED] Vlookup value from sheet1, copy past value to sheet2
  137. [SOLVED] Completed Projects
  138. Import a macro (module) into the active Excel workbook
  139. [SOLVED] Allow Free Form with Double Validation List
  140. [SOLVED] Macro to insert rows within a specified range
  141. Hide rows based on value in one column
  142. [SOLVED] Duplication data every time macro is run, instead of updating newly found data only
  143. Splitting cells, rearranging columns and rows, cleaning up data
  144. Macro to clean empty cells
  145. Restricting/directing tabs
  146. Poisson distribution - simulation
  147. VBA code in excel 07 to refresh web imported data.
  148. [SOLVED] 3 dynamic comboboxes, 2nd dependent on 1st and 3rd dependant on 2nd in VBA
  149. [SOLVED] Creating blank rows between different values in a column
  150. [SOLVED] Findall function doesnt do anything
  151. Linking worksheet to command button
  152. [SOLVED] Worksheet Change Event
  153. [SOLVED] What to use to change cellvalues - do..loop or for...next
  154. [SOLVED] Worksheets and Windows
  155. [SOLVED] Macro - Match prefix and paste in matching tab
  156. [SOLVED] Weekday function into VBA
  157. Macro for conditional formatting
  158. Superscript Code
  159. Userform to allow 2 X data entry and validation
  160. Late Binding of Excel object
  161. Protecting a worksheet that has macros in
  162. Spin Button / Macro
  163. Macro for hyperterminal
  164. Array formulas and blank cells
  165. Payslip Loading Formula
  166. [SOLVED] controlsource property for userform
  167. Autofit Merged Rows
  168. VBA InputBox
  169. [SOLVED] Saving Excel Files to Correct Format with Macro
  170. Help plz..
  171. How to handle errors (error 1004 i think...) in VBA Vlookup?
  172. [SOLVED] How to find out the networkday...???
  173. Code for automatically resuming after a message box.
  174. [SOLVED] Hide Cell(s) in list based on Color.
  175. Updating the nos that starts with 2 alone
  176. insert image - lookup in different worksheet
  177. Requesting Help with Macro
  178. Error when saving to file
  179. [SOLVED] Create Hyperlinks In Folders
  180. Macro to convert 1 column to a 13 column x N row matrix
  181. File opening through VBA
  182. SQL query via Excel VBA
  183. Read & Write Title Property of txt file
  184. [SOLVED] Trying to transpose when pasting, getting an error
  185. creating a report based on date ranges
  186. #value!
  187. Find Running Average of Daily Totals
  188. Date function agruments
  189. Run doesn't work in reference workbook
  190. [SOLVED] How to change the number of decimal places in a variable cell reference...
  191. unique values into an array?
  192. Opening excel - disable open option
  193. FTP files using VBA
  194. Selection & Sorting
  195. [SOLVED] Using Find() in VBA
  196. macro to change in a cell contenaing lot of data some part
  197. Adding Signature to send mail
  198. VBA Wait code
  199. Add specific cells in row next to active cell
  200. [SOLVED] Search filtering macro stopped working
  201. [SOLVED] trying to change a cells value to negative based on another cell input
  202. Selecting a range and sorting
  203. For without next error
  204. Blank cell if formula result is zero
  205. Changing the date with macro
  206. Go to different cells using a formula
  207. Variable Size Workbook Spell Check
  208. [SOLVED] User form with listbox that will list the contents of a folder
  209. Run Time Error '13'. Type Mismatch
  210. How do I convert a formula in a cell from "$A$3" to "A3"
  211. Excel to PDF Through Macro
  212. Problem in excel 2007 macro
  213. [SOLVED] Calculating Year to Date returns
  214. Speedo Graph (Rev it)
  215. Hide sheet based on yes/no cell
  216. Autofilter help
  217. Getting Access data in excel
  218. Form - vba to choose which label to show
  219. [SOLVED] Automatic Chart has 3 anomalies.
  220. [SOLVED] e-mail list management and cleanup of bad names.
  221. Copying worktabs from w/sheet to w/sheet
  222. Can flash be an appropriate user interface for excel macro ?
  223. Convert text to Formula
  224. Save as cell + date macro
  225. Help with This MAcro please
  226. [SOLVED] macro to look up oldest date in a column
  227. Insert Picture Macro
  228. [SOLVED] Array used as a Data Validation List
  229. Insert Text Box
  230. Evaluate function in VBA
  231. How to insert a row and fill in missing data with macro
  232. [SOLVED] Inserting rows and filling missing entries in a series
  233. [SOLVED] Currency Calculations
  234. [SOLVED] Dynamic Ranking of Yearly Totals
  235. Split data in cells
  236. Modify .FormulaR1C1
  237. Delete All Worksheets in a Workbook without the names
  238. looping formulas heeellllpppp!!!!!!!
  239. Excel To PowerPoint
  240. Stopping code execution completely
  241. Protection
  242. [SOLVED] Searching & Displaying data
  243. [SOLVED] Vlookup macro based on 2 values returning msgbox
  244. [SOLVED] Hide/Unhide rows
  245. Count user inputted values
  246. Make new worksheets from data in workbook
  247. Automated e-mail help
  248. [SOLVED] Insert new row into invoice and retain formulas and formatting
  249. Working with random numbers
  250. Need tScript Needs to Skip Names If They are Not Present in Both Worksheets