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 combobox
  2. How to change Userform name
  3. Macro not returning any results
  4. "Time Machine"
  5. Macro to search Word Document
  6. Refresh All and Saving Workbook
  7. Stopping a loop when encountering an empty cell
  8. Stop selecting chart objects in worksheet
  9. print macro
  10. VBA Condotional Formatting
  11. Copying macros with small changes
  12. Values taken during run
  13. TextBox selection
  14. VBA autofilter between 2 dates
  15. date exceptions
  16. scientific calculator
  17. VBA to round answer up to nearest whole number
  18. how to automatic copy
  19. Searching Through Small Data Table
  20. Macro to Output Custom Text and File Name
  21. Searching, partial words
  22. automatic export of XLS data?
  23. Macro Vlookup
  24. exporting Excel info to Access table
  25. Code execution has been interrupted
  26. Run macro everytime cell content changes
  27. WordArt Fill Property assistance - Excel 2007
  28. How do I bypass the destination prompt for data that comes from a WebQuery?
  29. Setting integer variable to cell contents
  30. Compare Columns and Find Difference
  31. Applying a formula to different length columns
  32. Matrix Question
  33. Sum of only cells that are unhidden
  34. Find and Replace in multiple sheets
  35. Automatically calculate VBA code
  36. Linking cells to make it appear in other workbook
  37. Saving as stops macro working
  38. ROUNDING formula code
  39. Reset cell values
  40. Input Parameter or something like that?
  41. pick up data from a spreadsheet with a different name each week
  42. Generate MD5 Checksum
  43. opening another xls
  44. Automatic Replication
  45. 256 chars in pivot table
  46. problems with roster
  47. Using String as filename in Save As not recognised by Dir
  48. Question about how to deal with errors
  49. Code to add data into cells via button
  50. hide rows ?
  51. Macro for Seperate tab in excel
  52. Comparing multiple records and Deleting unnecessary ones
  53. building a matrix
  54. Getting Strange Automation Error in Copying the data
  55. Copy data from multiple sheets to single sheet
  56. Variable range code
  57. Find a row and make it bold and with a border
  58. Find selected cell
  59. Macro to move an image object
  60. how to delete rows not containing the criteria
  61. copying files from one folder to another, unknown filenames
  62. ComboBox code
  63. Output of Highlighted Rows to Text File
  64. Moving data based on a repetitive pattern
  65. Scaling WordArt in Excel 2007
  66. message box
  67. VLOOKUP Issue
  68. Macro to email a workbook
  69. Printing to PDF or TIF using VBA
  70. How to direct a path name in VBA
  71. User adds a new sheet by selecting date
  72. Formatting an automatically generated worksheet with varying lines of data
  73. Clear Contents in Specific Rows via condition
  74. count function
  75. Identifying all records associated with combo box selection
  76. Charactor recognition
  77. Pivot chart data option
  78. Email Tracking
  79. Excel Slowness in 2007 vs 2003
  80. Nesting Loops
  81. Values on Graphs
  82. Formating TextBox from Function
  83. VBA formula entering into a different cell or cell comments
  84. inputbox
  85. Update of worksheet using macro
  86. Small problem with Database example from RoyUK
  87. Refreshing formatting
  88. Number Rounding
  89. Protection
  90. Problem - ComboBox Population
  91. Monthly tables in macros
  92. Pattern Recognition in numbers
  93. Match IDs Across Spreadsheets By Corresponding Time Periods
  94. Move Caption In Textbox to Middle and bottom
  95. Conditional formatting macro
  96. Copy Superscript Formatting in Formula
  97. dynamic combobox
  98. Ignore Messageboxes in loop
  99. Open Print Dialogue box
  100. Remove Part of text string
  101. books and/or websites can you recommend
  102. Importing Excel spreadsheets
  103. Complex data parsing
  104. Copy & Paste
  105. print to file instead of default printer
  106. macro to reorder a cell.
  107. Sumproduct or something else
  108. macro to copy cells to text files
  109. Search Engine in Excel Question!
  110. macros and data collection
  111. copying values to respective dates
  112. name a sheet tab
  113. Dropdown lists and Macros...????
  114. Entering data from textbox in VB
  115. Set Print Area & Margins
  116. Using excel functions in VBA program
  117. Printing a sheet in Visual Basic
  118. Excel 2007: "Insert Copied Cells" (rows) broken
  119. macro that copies and paste info into another worksheet
  120. How do i connect to an file stored online?
  121. How do you add a help file to a user defined function
  122. Column Width
  123. using macros across a sheet
  124. macro -working out averages
  125. Copy Data to another sheet based on the Value
  126. Check if any cell in range fulfills required condition
  127. Naming dynamic ranges with VBA and INDIRECT
  128. Calclating a value from a data table
  129. Programatically leave Design mode?
  130. Creating an advanced search/find function
  131. Macro relative range selection
  132. Mouse - Highlight row?
  133. Outlook Task
  134. Is it possible to link a cell to a photograph?
  135. Ucase problem
  136. First time VBA (Date stamp)
  137. Turn Off Autocomplete
  138. updating multiple files, how do I track files that give errors?
  139. How to increment column?
  140. Macro stop working and create errors
  141. Dynamic addline with Auto Fill
  142. Macro formula in relative reference rather than in absolute
  143. backup file to another computer
  144. Changes to Multiple Sheets
  145. SubFolders Collection, Create from myString?
  146. DLL's explained?
  147. name dynamic ranges with VBA
  148. Difference between Macro and VBS Host script!!!
  149. Getting a list of file names into an Excel spreadsheet
  150. VBA to name new TAB and populate with Specific wanted information from Rows
  151. Changing "yyyy" to 1/1/yyyy
  152. VBA to show certain text when a number is entered into a cell
  153. Getting a column reference as a letter
  154. Automatically running a macro when cell value changes
  155. Insert signature image - password protected
  156. Filter from separate worksheet
  157. Macros 97 to 03
  158. capture the OLD value in the target
  159. IsNumber function in VBA
  160. Error while executing a procedure.
  161. Print Macro
  162. Case Stmt problem
  163. Basic Worksheet object creation
  164. Multi-user Access Problems
  165. Select First And Last Worksheet in a Workbook
  166. Oracle Data Exp into Excel
  167. open the userform with a password !
  168. ClearContents selectively
  169. Create Function To Change Date into Week Number
  170. Macro for Multiple Charts from table (sequential data ranges)
  171. opening files based on list
  172. Calendar Export
  173. if code amendment help
  174. Macro to cut rows based on NONBLANK cell and append to list in separate worksheet - x
  175. Code to open multiple excel files
  176. VBA; find string and copy
  177. adding values from a date to a time line.
  178. count and display the next number in a sequence
  179. Automatically sub-total a list and export to files
  180. Macro - Recording
  181. Loop to select range of cells representing a month....
  182. Reading/lookup Data from excel by giving a querry
  183. Assign macro to a hyperlink
  184. Copy an existing worksheet and carry totals to a master worksheet
  185. Add sheet reference to data
  186. Delete a specified line on a sheet
  187. Control of a Checkbox Value
  188. how do I search a word or pdf for a list of names in a CSV file?
  189. Bypassing Excel's FTP login/password dialog
  190. Copying Cells to other spreadsheets in different areas
  191. Pivot Tables
  192. unprotect pop-up prompt
  193. Convert a Graph to Picture
  194. Macro to submit expenditure total and then move down a row
  195. To change default behaviour of excel
  196. Nested MID function in VLOOKUP
  197. Renaming Tabs - Code Adjustments
  198. offsetting from rightclick "target" cell
  199. Macro to add new line with formatting
  200. viewing duplicated records
  201. emailing with outlook
  202. Set header and columns on all sheets
  203. VBA Code to Sheet Name Search
  204. Delete rows
  205. VBA Code - Open a File
  206. Pivot Table (Extra Data next to Pivot Table)
  207. update VBA code automatically when worksheet changes
  208. from userform to worksheet
  209. Creating a print button for certain values
  210. deleting rows without opening file...
  211. Locking VBA
  212. counting occurances and multiply each by a qty
  213. Comparing Maco
  214. Copy records with the same value in a column to a new sheet or workbook
  215. Appending multiple columns to end of one column for use in pivot
  216. users with access to folder
  217. Calculating a run-up....
  218. Worksheet.enablecalculation function does not function
  219. Unique Items
  220. Advice about UI-addons and database connection
  221. Modify excel table for import in SQL (Table conversion)
  222. creating two passwords
  223. Create Table from references
  224. Using IF function to display Null field
  225. Input data to different sheets with a UserForm
  226. Corrupted file ?
  227. Recurring Macro using Application.OnTime
  228. Use variable for file name in import
  229. My loops are too slow
  230. Using Macro on linked cells
  231. Listbox Query
  232. Run Macro When cell value is Changed
  233. Converting values from a set of rules
  234. Why is excel creating another workbook when I run this code
  235. Delete requested row with macro
  236. writing a macro to insert columns...
  237. Pull out uniqe Values.
  238. separate records into a new file according to a criteria
  239. Macro for copy/insert into expanding table
  240. Can a Collection object have Methods?
  241. If statement not working
  242. Looping a macro
  243. Macro to create Pivots
  244. multiply a value and replace
  245. Delete Last Line
  246. Compare Macro
  247. Windows Task Scheduler Question
  248. match not found - message
  249. if value exists
  250. Macro - Logical Order