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. Problem with scientific notation.
  2. Still stuck on this code clleanup
  3. variable for dynamic cell
  4. Multiplying Time by rate
  5. Import data into new tabs
  6. How Do I Check To See If A Number Is In A Certain Format?
  7. Outlook email & excel
  8. Deleting Empty Rows in Excel
  9. VBA to graph in excel, from BO - troubleshoot type mismatch
  10. Return File Name
  11. Transfer a variable
  12. dealing with many columns
  13. xls visual basic combobox date display help
  14. VBA : Switching from one Excel instance to another
  15. Selecting a File to use
  16. excel into word
  17. Copy and paste
  18. worksheet change for different cells
  19. Find/Replace Using Alt-Enter
  20. Chart Animation
  21. .Formula = "=sum(rc...
  22. Addin that needs an Outlook reference
  23. Saving to PDF and then emailing macro needed!
  24. error on escape key from popup
  25. Window scroll issue
  26. Connection:="TEXT; followed by a parameter for the filepath ???
  27. Vlookup in VBA for a beginner
  28. Looping headache
  29. Code cleanup help required
  30. mirror arrays
  31. User-Defined Marco / VBA - Substitute Function
  32. create multiple worksheets from sort selection
  33. Text Box Issue
  34. Code help appreciated
  35. Remove Leading Spaces
  36. Trust Access to Visual Basic Project
  37. Subtracting...
  38. how to make it count correctly?
  39. Find and append
  40. Creating a stamp of who opened a file in directory
  41. count
  42. Pulling apart rows
  43. Multiple Worksheet Estimating
  44. Dao
  45. Find and Replace Macro
  46. sum cells
  47. Remove certain text from cell?
  48. How to prevent users from deleting tabs
  49. Using code and apply to other spreadsheet?
  50. Assign current cell to a variable and re-select
  51. Compare data and delete cell
  52. Code help appreciated
  53. VBA Coding HELP
  54. Error when trying to locate the cell pointer in a particular cell
  55. i need help with this error
  56. i need help with this error
  57. Assign macro to picture at runtime
  58. [Macro] Deleting Columns Based on Multiple Conditions
  59. M.i.a. Macros!!!
  60. Sorting and Deleting Empty Cell Ranges
  61. setting picture backgrounds on labels
  62. Statement to color code columns
  63. worksheet.countif function from outside workbook
  64. Macro - VBA
  65. My macro gives various answers
  66. need paste special value code
  67. Generating Charts with VBA
  68. Using a cell's content to open a specific image
  69. Loop Until Issues
  70. Help with two columns
  71. Merging Excel data from 2 spreadsheets
  72. Extract year
  73. Extracting Data From General Ledger Download
  74. Is It Possiable??
  75. frame question in a user form
  76. Excel Pivot Table
  77. Amend Code help
  78. If - Elseif question
  79. Help with LOG function
  80. Simple Userform question
  81. Calendar control on userform
  82. error trapping issue
  83. Find and Replace Carriage Return in Excel with VBA
  84. problem to normalize data
  85. Changing cells based on content
  86. Need major help...
  87. Cutting/Pasting Rows based on content PT 2
  88. Flash Background Color when Cell Link Changes
  89. Hung up on a sheet name
  90. Declaring the type of a bunch of variables
  91. Need some help with a simple (but challening) Macro
  92. Advanced IF-THEN... Help Please
  93. Macro to cut and paste based on cell content?
  94. beginner needs help
  95. Control Box Question
  96. sort the contents of my worksheet without making each cells of the same size
  97. Custom Toolbar and button with macro
  98. Cell reference
  99. Ron De Bruin code
  100. Dynamic Range within sumproduct formula
  101. Hiding Blank Rows in All Sheets
  102. Error 13 Type Mismatch
  103. Copy Rows in VB.
  104. Check parts of worksheet name
  105. Custom Toolbar Positioning
  106. Help with definig variables
  107. Truncate cell content after a certain character
  108. Macro to Paste Formula
  109. Compare cells to delete lines?
  110. Find and delete loop question
  111. Prevent users from opening VB editor.
  112. basic vba homework assignment
  113. .protect userinterfaceonly:=true not working?
  114. Rearrange Data
  115. Format label captions
  116. Import data from another workbook
  117. loading dates into array problem
  118. &-character in macro text
  119. Deleting Duplicate Account Numbers
  120. automatic BGcolor according to value?
  121. column in worksheet as range of combobox??
  122. Defining Find Function
  123. Making Copy and Paste Code more efficient
  124. Just a little bit of function help
  125. Problem inserting a function from VBA
  126. Timed Macros
  127. Sheet Calculation in a macro
  128. Date format
  129. find cell index at a click
  130. Replace
  131. problem with read in data in excel
  132. Need help to modify the follwing code
  133. Target.Value - Must be a number
  134. VBA for Excel service provider(s)
  135. Macro to hide columns based on contents of two cells
  136. interactive input
  137. run an access make table command
  138. Running multiple timers
  139. Combine a Matching Column Headings' data in 2 Worksheets to 1
  140. loops...
  141. a simple question
  142. Where do i add this
  143. Selecting the last value in a list
  144. Run-time error '6': Overflow
  145. type mismatch
  146. Range command, does it work ?
  147. Simple automatic sort of range
  148. Tab/space alignment/organization with Arial font
  149. How to run a commandbar controled module inside a Macro
  150. Pulling a worksheet name from cell value (custom function needing help)
  151. How do i do this, please help
  152. ComboBox Change Function
  153. Use of Macro to count number
  154. Simple question about copying cells (?)
  155. Copying/Pasting Rows/Columns based on content
  156. make a "find" box
  157. Help with Macro
  158. File size after runnign macro
  159. Need help in creating rule
  160. Strange pastespecial texttocolumns behavior
  161. Data Validation
  162. formula
  163. "Object required" error
  164. Run time error '1004':
  165. Macro assigned to a button
  166. using vba from Access to change Excel worksheet
  167. Conditonal formating code
  168. Listbox selection auto deletes from cell. Help
  169. Separate column after first space
  170. Sharing a Workbook
  171. Open Workbooks
  172. rowHeight
  173. Creating a directory
  174. RxC9?
  175. filter_option
  176. Identifying Decimal within String
  177. copying rows if something is true
  178. Swapping rows
  179. Beforesave problems....
  180. Need help formatting this please
  181. New to Userforms - need help on the output
  182. Paste to sheet
  183. All Caps For Date
  184. Random Macro Failures
  185. finding top of column
  186. Freezepanes
  187. ForeColor
  188. Simple question
  189. Calling my function in VBA
  190. Worksheet copy problem
  191. Data validation macro
  192. Help with codemodule error
  193. Pass down parameter from Web
  194. macro in xml
  195. Copying the first row of a sheet to a new sheet?
  196. Form Hyperlink Question
  197. Icon in title bar
  198. linking 2 sheets to the web....
  199. Msgbox position on top of sheet
  200. macros to insert text
  201. Macro clears contents and my formula references
  202. Matching and then adding to bottom of col
  203. what formalue should I use instead of counta?
  204. Matching Values from different columns
  205. InputMask
  206. Check if the first sheet is the selected sheet
  207. formula change
  208. Printing Macro
  209. macro for dates
  210. For-next loop problem
  211. Track Deleted rows and columns
  212. Processing Delimited Data from a Web Query
  213. how to use if then with macro?
  214. copying cells based on a value in another cell
  215. Concatenate string variables in VB
  216. Next month problem
  217. Need to extract random data using set criteria...
  218. Help with dialogs
  219. Need some VB help
  220. Need some VB help
  221. Returning information from SQL Server to Excel Using VBA
  222. An IF statement in Excel
  223. Row Height
  224. Filtering
  225. bar chart
  226. Database with Excel VBA
  227. Mouse clicks and list control
  228. remove / and flip
  229. setting selection in marco
  230. How to populate excel combo box with access database?
  231. modifying boaders from marcos
  232. Scheduler and Conditional Formatting
  233. Adding data in rows
  234. Macro help
  235. Scan each CHR in a string
  236. File names...
  237. File names...
  238. Find a value, delete cell and next cell
  239. Replace Method Changes Date Formatting
  240. Replacement for loop
  241. how to solve this problem
  242. Loop not running
  243. saving and exporting excel macros help
  244. coma not diaplayed in formula bar!!
  245. Generating Word Docs
  246. Problem with passing a cell reference
  247. Linksources
  248. What does "400" mean?
  249. Tab as Date
  250. need help populating a table using a macro