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
  1. Sending Email by Selecting Names From a List
  2. [SOLVED] FORMAT issues
  3. Macro VBA for Automatic Row Coloring
  4. macro to increase a number
  5. Simple Vba to find a date
  6. Looping through worksheets
  7. Dynamic data - Export area
  8. create If Then Loop
  9. Dynamic Combobox
  10. Copy data and text from Sheet1 to Sheet2
  11. Running macro every 10 secs
  12. Conditional Format by Row in VBA
  13. Excel with Access
  14. Link between two files where one file name is dynamic
  15. [SOLVED] Setting multiple dynamic print ranges
  16. [SOLVED] Deleting Rows
  17. [SOLVED] Option button (active control) code to perform a calculation
  18. [SOLVED] selecting macro based on cell value
  19. time tracker
  20. Find numbers from a list that make a specific total
  21. [SOLVED] Unprotecting and Protecting Sheets
  22. Script that edits the text printed on the button that runs the script
  23. PivotTable query and overwriting existing data
  24. Variable data link
  25. Putting a clickable link in the body of email sent from Excel
  26. [SOLVED] Unhiding part of a range
  27. Import Data into Current Workbook
  28. Updating Multiple Series' on Chart
  29. [SOLVED] Check last 4 letter of a String
  30. if cell = "smooth" then clear a certain cell
  31. copying worksheet in same workbook
  32. Match Col A in 3 sheets and merge lines
  33. [SOLVED] Changing X axis value
  34. How to disassociate clusters of option buttons
  35. [SOLVED] running code
  36. [SOLVED] Macro -Delete decimal points & add 0's
  37. Todays date + 28 days + 2 week days
  38. Workbook Help
  39. Find a name in a row and delete the row
  40. Pasting one value a variable number of time
  41. Problem in Merging two sheets with different Data in Cells
  42. Clear all cells automatically?
  43. Export rows as individual files
  44. Applicat
  45. checking if shapes exist and grouping them
  46. Can I use more than 1 range of cells when writing a VBA Macro
  47. exchange rate download
  48. Number set in random order
  49. Excel 2003 VBA error 400
  50. change times to military time
  51. Consolidating data from different workbooks
  52. [SOLVED] Have macro wait while filling in auto-generated form
  53. [SOLVED] Radio button question
  54. Set array= range, and using a variable name for a worksheet
  55. [SOLVED] Copy and paste from one user form to another
  56. Save File Overide
  57. Browse file to add into listbox
  58. Emulate format painter in VBA
  59. [SOLVED] Increment text column reference ("AZ" -> "BA")
  60. from multiple to one column(s)
  61. Recalculating Figures with Currencies
  62. [SOLVED] Copying from userform into table on another workbook
  63. embedding user-defined hyperlink into auto-generated email
  64. Userform Coding Multiple Checkbox Conditions
  65. OnTime Method not working?
  66. [SOLVED] Excel Outlook interaction.
  67. VBE References/Slow save
  68. Excel Data Upload Changed and Need Rewrite
  69. Web Based Excel sheet
  70. Check for default values, Prompt for default values, Double click change default valu
  71. Macro to lookup many codes
  72. Saving file without code, problems
  73. Vlookup for 2 Separate Workbooks
  74. [SOLVED] using " in formula via VBA
  75. Problems with borders, and If statements
  76. macro which is able to access combobox
  77. Change textbox backcolor then save workbook?
  78. [SOLVED] cut+paste formulas+formats to other cells
  79. page numbers
  80. Strikethrough code to activate when end date is past.
  81. extending my my merger script
  82. Macros from C#
  83. Take value and add to a cell in another sheet
  84. Dynamic selection/count or rows in table format for each print page
  85. Add and subtract numbers with no carry or borrow
  86. Naming worksheets
  87. [SOLVED] Hiding controls
  88. Inserting Rows
  89. Change Evaluate Method to work in windows 97
  90. VBA Function Vlookup data from Hidden sheet in hidden workbook
  91. code to copy txt files from floppies
  92. inserting row in this row number of items and outstandings
  93. summary problems
  94. [SOLVED] Macro to sort dynamic list into table
  95. Storing and using objects in variables.
  96. [SOLVED] Copy database
  97. Difficult import issue?
  98. adjust my existing macro
  99. macro which allows only userinterace:="true" and not the users in shared worksheet
  100. [SOLVED] naming a worksheet with today's date
  101. [SOLVED] GetOpenFilename Properties
  102. Changing cell references in formulae?
  103. [SOLVED] Zip Excel File
  104. Running a macro on combo box selection
  105. [SOLVED] Macro to count rows
  106. Macro To Move Odd cells to another sheet
  107. [SOLVED] Looping through Auto filter data - VBA
  108. Flipping Column info to Rows
  109. Query Worksheet
  110. setfocus ok button on a msgbox
  111. Copy combobox object not updating!
  112. [SOLVED] Output text in different fonts
  113. [SOLVED] Name range is not saving when running macro
  114. [SOLVED] how to delete over 3000 rows in worksheet without a loop
  115. [SOLVED] Displaying cell values with Worksheet_Change by value if Target is in certain range
  116. [SOLVED] VBA/macro to unhide a sheet?
  117. Replicate/copy Rows based upon Another Cell
  118. Cell selection
  119. Vba nightmare
  120. Tally sheet, reseting parts once a week but keep running totals
  121. [SOLVED] schedule a macro to run
  122. [SOLVED] Basis SUM macro
  123. [SOLVED] Finding last cell in a column, select, copy/paste
  124. Search Column A in all protected sheets
  125. [SOLVED] Remove "TRUE" "FALSE" words from a linked checkbox
  126. [SOLVED] Prevent private sub macro from running
  127. Path to Folder on Desk for an open flle
  128. forgot password anyone have a crack?
  129. Start Macro at workbook open
  130. pass value of calendar form to textbox
  131. In need of beginner VB book
  132. Use Ontime Only Monday through Friday
  133. Search, Copy and Paste
  134. [SOLVED] Getting Last Row in a Range
  135. [SOLVED] 'Paste Special' problem with macro
  136. [SOLVED] keyword filtering
  137. [SOLVED] Finding bottom row of a range in VBA
  138. [SOLVED] Worksheet change event not responding to cell deletion
  139. [SOLVED] Summary Sheet of Data From Other Workbooks
  140. How do I call a UserForm from within a Macro?
  141. Average every four lines
  142. [SOLVED] deleting rows based on criteria
  143. Limiting Constraints in Solver
  144. [SOLVED] What's wrong with this simple ListBox code?
  145. [SOLVED] List Box Scroll Bar
  146. [SOLVED] Code to recognize where selection change active cell originates
  147. [SOLVED] Label Question
  148. [SOLVED] moving between 2 open workbooks
  149. [SOLVED] copy only certain columns
  150. Excel macro to copy and paste onto every nth cell
  151. [SOLVED] Make autofilter react based upon selection in drop box...
  152. Select all textfields in a document and calculate field INCLUDEPICTURE
  153. Hard page breaks being replaced by soft breaks in the wrong place
  154. Checkboxes with linked cell's
  155. Convert sale amounts ..
  156. Scrollbars on a multiline textbox
  157. vba for copy paste to blank cell
  158. linking a common unique value across multiple worksheets
  159. Macro to save file
  160. Search directory
  161. Converting date value to Day of Year
  162. [SOLVED] occurence /count of a cell value in a column/range
  163. [SOLVED] putting spinbuttons in a worksheet
  164. 'Button" Property window not getting displayed
  165. Code not working on windows97
  166. combining rows
  167. MapDrive Script Question
  168. cut and paste over referenced cells
  169. Why wont this macro stop?
  170. [SOLVED] How to create a User input dialog box?
  171. Huge Excel with Macro File Size
  172. [SOLVED] How do I macro 20,000+ series of data?
  173. Update hyperlink, update cell
  174. [SOLVED] Checkbox function to add +1 to cell in different sheet
  175. pivot table refresh - error 1004 - reference is not valid
  176. a macro which updates =now() formula for only blank cells
  177. Adding data from form
  178. Find Blank cell in column then Fill Up
  179. [SOLVED] Reversing Sign Based on Cell being Manually Coloured
  180. Create PDFs Using Excel VBA?
  181. [SOLVED] Not exiting For loop
  182. [SOLVED] How to Copy macro to bottom of same sheet
  183. date and then switch
  184. Trouble with macro and button
  185. locking page layout and header and footer options
  186. [SOLVED] Event macro error when selecting more than one cell
  187. [SOLVED] Worksheet change event not responding to cell deletion
  188. relative movement of the cursor
  189. Do Loop with Mulitple Sheet output
  190. Copy Paste section of macro not working in shared file
  191. excel code import
  192. Macro Creating Email formatting
  193. Better than loops
  194. [SOLVED] Trouble with Selection_Change Event
  195. Expanding an array....Interpolation?
  196. excel to oracle
  197. excel to thumb file
  198. Export Data to *.txt or *prn. Text file to have equal field spacing.
  199. Week Number in Month
  200. Display data from WorkSheet on List Box
  201. Macro to print before saving file
  202. Trouble moving worksheet to new location
  203. [SOLVED] Vlookup Problem
  204. Making PDF's using Excel Macros
  205. Auto Change Screen Resolution
  206. Text Box size programming help
  207. Formatting multiple cells based on cell values
  208. Executing an .exe program with parameters in VBA
  209. Create a button to Email file using LotusNotes
  210. External database query, shifts everything right!
  211. [SOLVED] Recorded macro missing paste commands
  212. Multiple CSV import
  213. Saving when displaying in SharePoint 2007 Page viewer
  214. Looping Through A Range Of Cells
  215. copy method of excel failed'
  216. repairing figures in a column
  217. Using cell as checkbox (add tick mark)
  218. change column data into row data
  219. Schedule Macro
  220. [SOLVED] Copy Database File And Save to Desktop
  221. Login to PC/Login Script
  222. retrieve title of a column
  223. FileSearch method and filenames with unicode characters
  224. Adding Checkbox functionality to working Userform
  225. ActiveX Excel Workbook Timeout Property?
  226. Delete rows with conditions
  227. Import Query in Access to Excel
  228. [SOLVED] Code Is Deleting Header
  229. Protect Sheet and Still Use Formatting ToolBar
  230. [SOLVED] Run Time Error 438
  231. Linking 2 spreadsheets without using vlookup or range lookup
  232. Macro to automate a tab value search
  233. [SOLVED] VBA- setting id of textbox in macro code
  234. [SOLVED] Opening an excel file from a cell reference
  235. [SOLVED] Folder Creation with a Macro
  236. [SOLVED] Generate Folder
  237. [SOLVED] Cannot eliminate Value Error
  238. Edit All Hyperlinks On A Worksheet
  239. Macro to Auto Update from Internet?
  240. [SOLVED] Can you change form button properties with a macro?
  241. looking for vba excel for comparing 2 columns and adding a formula in a third range
  242. Lose cursor after unloading form
  243. [SOLVED] Code loop through two tables checking and altering
  244. How to ignore strings that don't match a certian format?
  245. [SOLVED] Macro to combine Rows
  246. Display data entered on userform1 to userform2
  247. where is my Menu Strip in VBA?
  248. [SOLVED] How do I initialize a ComboBox?
  249. [SOLVED] Selectionchange event to protect cells
  250. [SOLVED] Excel caught looping script