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. Select Row 1 through "X" and Delete
  2. Adding a variable
  3. [SOLVED] Compare two email lists and output non-matching
  4. VBA Vlookup row and column variables
  5. [SOLVED] Textboxes, data arrays and vlookup functionality
  6. Sort of loop happening with calling macros
  7. cleaning 2 series of data
  8. A macro to automatically fill down...
  9. print filtered columns
  10. drop-down list in msg box
  11. difficulty with SetFocus in data validation for textbox
  12. Add sheet. Copy Code & Paste in new Module
  13. Can't change the range in VBA code
  14. Digital signature (username and date)
  15. Using find_matches across different worksheets within a single workbook
  16. new Your help
  17. [SOLVED] Adding a variable range
  18. VBA Code to link to external sheet
  19. Trying to open worksheet to 1st blank row
  20. Macro Help
  21. A bit complex relation searching macro
  22. Duplicate Declaration error
  23. [SOLVED] Clear the clipboard
  24. [SOLVED] (x) on a userform
  25. Searching for data across multiple sheets and copying to one main sheet
  26. Macro to Print Selection
  27. Formating the drill down sheet when double clicking on a pivot table.
  28. Unusual Macro Call
  29. my vba graph problem
  30. [SOLVED] RESOLVED:Removing border of Group Box
  31. Macro - Drop Down Free Text / Time-Date Function
  32. checking data before it is pasted
  33. Macro to write a macro on a different Workbook?
  34. Copying cells from one workbook to another.
  35. Adding Value With Code To Sheet
  36. Appending data at the end of existing data
  37. [SOLVED] Loop through rows in a listbox and remove
  38. Paste special code
  39. [SOLVED] Dynamic Array Problems
  40. Userform: Dont want all data to be cleared when submitted
  41. [SOLVED] Look up a value and find the highest date associated with it
  42. Input boxes
  43. [SOLVED] Splash Screen Question
  44. VBA lookup from another workbook
  45. If condition is <=0 then exit sub or return
  46. Msgbox
  47. [SOLVED] Delete All Rows/Data above this Line
  48. keep formula referencing sheet when sheet is removed
  49. loop/repeat copy/paste Macro
  50. Reprotect after macro exits.
  51. AutoFill question
  52. Import multiple .csv files from folder that updates each day
  53. select whole cells in sheet
  54. How do you Parse the contents of a cell into a macro goto?
  55. Check for identical cell and do something
  56. separating values in comma delimited cells
  57. How to use Select Case in a loop
  58. [SOLVED] Find and Replace on every worksheet
  59. Output Variable as a comma seperated Number
  60. Screentip
  61. save to desktop macro
  62. Columns to rows issue...
  63. Assigning a variable and pasting variable to last unused column.
  64. [SOLVED] VBA autofilter between 2 dates
  65. [SOLVED] Changing Excel Macro to Excel Custom Function
  66. Marking columns/rows
  67. [SOLVED] same code not working in different workbook
  68. [SOLVED] Using Labels in VBA Code
  69. Pulling only the number out of a string
  70. Testing Different Scenarios
  71. Set three expire dates for a workbook
  72. Multiple macros to maintain balances and attendance
  73. Auto update
  74. Capture Only Numbers in a string
  75. Move Data to One Column
  76. where is my thread
  77. VBA, Excel and SQL
  78. [SOLVED] Help With Loop
  79. Reference a Column letter from a number
  80. How to force toolbar view options when opening and closing
  81. I need a vba solution for my currence rate -problem.
  82. Is it possible to make an excel file unusable after a certain number of days?
  83. Excel to Open PDF file
  84. Insert 10 templates sheets with formulas to 1000 workbooks in a folder
  85. Finding next blank row and pasting problem
  86. Text to Columns Question
  87. Deleting Multiple Criteria Rows / Data manipulation
  88. Cell changes viewed easily
  89. macro to fill all cells with formula
  90. [SOLVED] Getting macro to run all the time
  91. running tracker
  92. Using a Calendar in a Form
  93. emailing from excel filenames
  94. [SOLVED] Select which worksheet to run macro on...
  95. Formula VBA Code
  96. protecting/unprotecting sheets
  97. Quick Syntax Problem
  98. [SOLVED] Can't Find Project or Library
  99. Assistance required for Automatically moving data to another worksheet
  100. Excel 2003 VBA Run-time Error '5987' The Disk Is Full
  101. Problem with null, empty, "", 00:00:00
  102. [SOLVED] Autofit Rows Using Macro
  103. How to compare and copy data from one xls-file to another xls-file
  104. [SOLVED] Task List
  105. Range/copy migration issue from 2003 to 2007
  106. Same page printed but with changing sequential number on it
  107. Name X and Y axis in scatter
  108. Excel to Access using ADO
  109. Time capturing
  110. Copy data into another sheet
  111. Does an if then apply here?
  112. [SOLVED] creation of message box as per mentioned condition
  113. Sending Email by Selecting Names From a List
  114. [SOLVED] FORMAT issues
  115. Macro VBA for Automatic Row Coloring
  116. [SOLVED] macro to increase a number
  117. Simple Vba to find a date
  118. Looping through worksheets
  119. Dynamic data - Export area
  120. [SOLVED] create If Then Loop
  121. [SOLVED] Dynamic Combobox
  122. Copy data and text from Sheet1 to Sheet2
  123. Running macro every 10 secs
  124. Conditional Format by Row in VBA
  125. Excel with Access
  126. Link between two files where one file name is dynamic
  127. [SOLVED] Setting multiple dynamic print ranges
  128. [SOLVED] Deleting Rows
  129. [SOLVED] Option button (active control) code to perform a calculation
  130. [SOLVED] selecting macro based on cell value
  131. time tracker
  132. [SOLVED] Find numbers from a list that make a specific total
  133. [SOLVED] Unprotecting and Protecting Sheets
  134. Script that edits the text printed on the button that runs the script
  135. PivotTable query and overwriting existing data
  136. [SOLVED] Variable data link
  137. [SOLVED] Putting a clickable link in the body of email sent from Excel
  138. [SOLVED] Unhiding part of a range
  139. [SOLVED] Import Data into Current Workbook
  140. [SOLVED] Updating Multiple Series' on Chart
  141. [SOLVED] Check last 4 letter of a String
  142. if cell = "smooth" then clear a certain cell
  143. [SOLVED] copying worksheet in same workbook
  144. Match Col A in 3 sheets and merge lines
  145. [SOLVED] Changing X axis value
  146. SOLVED:How to disassociate clusters of option buttons
  147. [SOLVED] running code
  148. [SOLVED] Macro -Delete decimal points & add 0's
  149. Todays date + 28 days + 2 week days
  150. Workbook Help
  151. Find a name in a row and delete the row
  152. Pasting one value a variable number of time
  153. Problem in Merging two sheets with different Data in Cells
  154. Clear all cells automatically?
  155. Export rows as individual files
  156. Applicat
  157. checking if shapes exist and grouping them
  158. [SOLVED] Can I use more than 1 range of cells when writing a VBA Macro
  159. exchange rate download
  160. Number set in random order
  161. [SOLVED] Excel 2003 VBA error 400
  162. change times to military time
  163. Consolidating data from different workbooks
  164. [SOLVED] Have macro wait while filling in auto-generated form
  165. [SOLVED] Radio button question
  166. Set array= range, and using a variable name for a worksheet
  167. [SOLVED] Copy and paste from one user form to another
  168. Save File Overide
  169. Browse file to add into listbox
  170. Emulate format painter in VBA
  171. [SOLVED] Increment text column reference ("AZ" -> "BA")
  172. from multiple to one column(s)
  173. Recalculating Figures with Currencies
  174. [SOLVED] Copying from userform into table on another workbook
  175. [SOLVED] embedding user-defined hyperlink into auto-generated email
  176. Userform Coding Multiple Checkbox Conditions
  177. OnTime Method not working?
  178. [SOLVED] Excel Outlook interaction.
  179. VBE References/Slow save
  180. Excel Data Upload Changed and Need Rewrite
  181. [SOLVED] Web Based Excel sheet
  182. Check for default values, Prompt for default values, Double click change default valu
  183. [SOLVED] Macro to lookup many codes
  184. Saving file without code, problems
  185. [SOLVED] Vlookup for 2 Separate Workbooks
  186. [SOLVED] using " in formula via VBA
  187. Problems with borders, and If statements
  188. macro which is able to access combobox
  189. Change textbox backcolor then save workbook?
  190. [SOLVED] cut+paste formulas+formats to other cells
  191. page numbers
  192. [SOLVED] Strikethrough code to activate when end date is past.
  193. extending my my merger script
  194. Macros from C#
  195. Take value and add to a cell in another sheet
  196. [SOLVED] Indicate the row number for each last row in each new page printed
  197. Add and subtract numbers with no carry or borrow
  198. [SOLVED] Naming worksheets
  199. [SOLVED] Hiding controls
  200. Inserting Rows
  201. [SOLVED] Change Evaluate Method to work in windows 97
  202. VBA Function Vlookup data from Hidden sheet in hidden workbook
  203. code to copy txt files from floppies
  204. inserting row in this row number of items and outstandings
  205. [SOLVED] summary problems
  206. [SOLVED] Macro to sort dynamic list into table
  207. Storing and using objects in variables.
  208. [SOLVED] Copy database
  209. Difficult import issue?
  210. adjust my existing macro
  211. macro which allows only userinterace:="true" and not the users in shared worksheet
  212. [SOLVED] naming a worksheet with today's date
  213. [SOLVED] GetOpenFilename Properties
  214. Changing cell references in formulae?
  215. [SOLVED] Zip Excel File
  216. Running a macro on combo box selection
  217. [SOLVED] Macro to count rows
  218. Macro To Move Odd cells to another sheet
  219. [SOLVED] Looping through Auto filter data - VBA
  220. Flipping Column info to Rows
  221. Query Worksheet
  222. setfocus ok button on a msgbox
  223. Copy combobox object not updating!
  224. [SOLVED] Output text in different fonts
  225. [SOLVED] Name range is not saving when running macro
  226. [SOLVED] how to delete over 3000 rows in worksheet without a loop
  227. [SOLVED] Displaying cell values with Worksheet_Change by value if Target is in certain range
  228. [SOLVED] VBA/macro to unhide a sheet?
  229. Replicate/copy Rows based upon Another Cell
  230. Cell selection
  231. Vba nightmare
  232. Tally sheet, reseting parts once a week but keep running totals
  233. [SOLVED] schedule a macro to run
  234. [SOLVED] Basis SUM macro
  235. [SOLVED] Finding last cell in a column, select, copy/paste
  236. Search Column A in all protected sheets
  237. [SOLVED] Remove "TRUE" "FALSE" words from a linked checkbox
  238. [SOLVED] Prevent private sub macro from running
  239. Path to Folder on Desk for an open flle
  240. forgot password anyone have a crack?
  241. [SOLVED] Start Macro at workbook open
  242. pass value of calendar form to textbox
  243. In need of beginner VB book
  244. Use Ontime Only Monday through Friday
  245. [SOLVED] Search, Copy and Paste
  246. [SOLVED] Getting Last Row in a Range
  247. [SOLVED] 'Paste Special' problem with macro
  248. [SOLVED] keyword filtering
  249. [SOLVED] Finding bottom row of a range in VBA
  250. [SOLVED] Worksheet change event not responding to cell deletion