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. Copying Filtered Data Columns to new spreadsheet
  2. [SOLVED] Copying Filtered Data Columns to new spreadsheet
  3. [SOLVED] cell protection & clear macro
  4. Print Sheets Identified by Checkbox
  5. How to prevent comments from moving when rows grouped?
  6. Autofill columns and rows simultaneously
  7. [SOLVED] Need relative but changes to absolute while running...
  8. Execute stored procedure using ms query & vba
  9. Intricate Paste/Transpose VBA
  10. [SOLVED] Changing cell content based on button
  11. [SOLVED] Date problem
  12. Auto delete a column when a date is reached
  13. duplicate macros 2 versions of a workbook problem
  14. [SOLVED] Using For-Next to fill Cells
  15. send just the row of information to the e-mail address in the row of a worksheet
  16. Workbook_open Event Not Working
  17. Cell formats not working
  18. [SOLVED] BeforeClose and Deactivate events not running?
  19. Linking to MS Project
  20. Creating PDF file from Excel
  21. How to prepare Testdata in a generic way?
  22. [SOLVED] Drop down list for hiding lines
  23. [SOLVED] Posting from spreadsheet to another
  24. [SOLVED] Ranges, Column and changing values automatically
  25. [SOLVED] Referencing a Sheet from an inputbox
  26. [SOLVED] Create a drop down list based on the value in a cell
  27. Remove macro Excel 2004 Mac
  28. [SOLVED] Form Countdown
  29. Look into a directory for a zip, delete, and repeat until directory is empty.
  30. [SOLVED] Workbook_Open() in separate file
  31. How to Convert a formula into VBA
  32. Screentip / Hyperlink & Button/Shape
  33. Print a VBA form
  34. [SOLVED] Class Modules?
  35. Current month to file name by saving
  36. Help in VB Form in Excel
  37. Macro help
  38. [SOLVED] How to open more than 1 hyperlink ???
  39. [SOLVED] to check whether an ocx is already registered
  40. [SOLVED] Looping through worksheets
  41. [SOLVED] Sorting Column data
  42. How to read "file names" from a folder using excel vba macro
  43. copy multiple sheets
  44. [SOLVED] Prepping data for merge in InDesign
  45. Combo Box - Can't see control tab
  46. [SOLVED] Lookup and return value
  47. Need Protecting/locking of headers from overwrite by userform.
  48. Merging records having duplicate data
  49. [SOLVED] Start/Stop & Abs/Rel box
  50. Avoid slow recalc for PivotItems.Visible in VBA
  51. Display Comments when mouse pass over a button
  52. Testing Hyperlinks?
  53. [SOLVED] Lock Sheet Tabs Using VBA
  54. [SOLVED] inserting data at currentlly selected cells
  55. [SOLVED] SQL statement
  56. [SOLVED] The Sort reference is not valid - run time error
  57. Group rows Macro?
  58. [SOLVED] problem with multiple PivotTables on a PivotCache
  59. [SOLVED] Delete Worksheets Using Checkboxes Macro
  60. macro aid waiting for input
  61. User Defined Function
  62. [SOLVED] Parsing Pasted Data
  63. [SOLVED] Spell check (Post2) via VBA
  64. Spell check - VBA vs. Manual (Post2)
  65. [SOLVED] Macro Hyperlink issues
  66. build If statement condition dynamically
  67. Comparing values & delete
  68. Cannot edit macro in hidden workbook
  69. Contact list the will automatically add a contact
  70. [SOLVED] Any way to do it with less code...?
  71. [SOLVED] timed message box
  72. [SOLVED] Find the next Empty Cell
  73. [SOLVED] using Right(A1, 28,3)
  74. Dynamic Pivot Table Range
  75. Run-time error '13'. Type mismatch
  76. insert Pop Menu's by Macro
  77. Range.columns.count property returns wrong count after union operation
  78. copy multiple files into one file
  79. [SOLVED] Complex data parsing
  80. Macro required to delete rows based on date
  81. Run a Macro for a selection
  82. macro to combine rows and add numbers
  83. Filter Sheets
  84. [SOLVED] Importing selected cells into VBA
  85. [SOLVED] Case issues in VBA
  86. [SOLVED] Warning msgbox when closing a userform
  87. [SOLVED] Drop Down forces calculate
  88. [SOLVED] inputting dependant on cell
  89. Macro for calculate, copy, paste loop
  90. Want to use a function rather than VBA
  91. [SOLVED] Changing Referenced Directory
  92. How to set autoprint base on monthly date
  93. [SOLVED] Error handling using cells.find
  94. Macro to change date to next day.
  95. [SOLVED] Need macro to update graphs
  96. Highlight cells/row with data only!
  97. How to automatically unhide a row based on time
  98. [SOLVED] Changing "save in" Directory
  99. Dynamic range
  100. Are my variables off?
  101. Double click event
  102. [SOLVED] Hiding and Unhiding two sets of worksheets
  103. Removing a value from one sheet and replacing it onto another.
  104. [SOLVED] Date Range Help
  105. macro for next cell down
  106. [SOLVED] Writing batch file to remove spaces from filenames
  107. How to sort a selection of rows?
  108. [SOLVED] Compare data with different workbooks
  109. [SOLVED] Add blank row between different values
  110. Run macro on multiple sheets at once, not one after another
  111. If statement user created function
  112. Can I attach a macro to a drop down list selection
  113. Importing Naming Conventions
  114. [SOLVED] Data Validation in TextBox
  115. Recommend the best free online resource for learning VB?
  116. [SOLVED] Listing folders with VBA
  117. [SOLVED] Conditional "clear contents" of cells
  118. Rearranging Cells Based on Letter Case
  119. [SOLVED] Calendar pop up query
  120. Background Macro with userform
  121. [SOLVED] Search along a Column and scroll to it
  122. [SOLVED] Copy partial text within a cell to a new cell
  123. OP has reposted question
  124. Moving within a specified range after User Input
  125. [SOLVED] Conditional locking of cell based on another cell
  126. [SOLVED] Macs do not work with .RowSource
  127. Pasting Offset-Match Value in Macro
  128. [SOLVED] Holiday program - export to ms outlook
  129. [SOLVED] Multiple Conditional Formats (4+) using VBA
  130. Passsword Protecting a Command Button
  131. [SOLVED] Copy from Workbook to Another
  132. [SOLVED] on error goto
  133. Calendar to Pop Up in a specified place
  134. [SOLVED] Handling Expected Errors
  135. [SOLVED] Add a row after last row with data
  136. Adding a row - how hard can it be?
  137. Add worksheet from UserForm
  138. Move one cell down in VBA
  139. [SOLVED] Help adapting an existing macro.
  140. Count the colors in the dynamic range
  141. Summing the values of a generated array.
  142. Please check this spreed sheets macros
  143. [SOLVED] Problems with Next.
  144. [SOLVED] Change multiple columns into multiple rows
  145. [SOLVED] Remove Close X from user form
  146. How to make a macro available to any workbooks that may be opened.
  147. macro to copy Wks selected using a userform
  148. Need HELP to make a macro
  149. check if input box data is numeric
  150. A text box that formats a date
  151. [SOLVED] separate Name into two columns
  152. [SOLVED] Using a combobox without overwriting existing data
  153. comparing data in Columns of different worksheets
  154. VBA Output based on what's typed into Cell.
  155. Finding Text In MS Word
  156. [SOLVED] Leap year
  157. [SOLVED] Userform not "hiding" immediately?
  158. [SOLVED] Sorting by variable keys
  159. Script or Macro to export data to another spreadsheet
  160. Excel Macros for find and replace
  161. scaling font size in headers and footers
  162. [SOLVED] can .End(xlToRight) skip blank cells?
  163. [SOLVED] Combo Box - No choices!
  164. Command Button Caption distortion
  165. [SOLVED] VBA bold selection code
  166. [SOLVED] Using "Like" with conditional formatting
  167. Does XML file have to be saved locally?
  168. Looping input boxes in a UserForm
  169. [SOLVED] Offset Entire Row
  170. Deleting Rows using data from other workbook/sheet
  171. [SOLVED] Printing too many copies problem
  172. [SOLVED] Mismatch Debbuging
  173. [SOLVED] Code to Copy and Paste
  174. Controlling Location Userform Opens
  175. [SOLVED] Values of combo box dependent on selection in another combo box
  176. How to copying text from one column to another
  177. Out of Memory Error when creating Pivot Table
  178. macro that copies selected rows from one list to other
  179. OnClick Event Macro
  180. [SOLVED] Add names to blocks
  181. Updating excel spreadsheets based on lookup
  182. How to add Text type input vaule into SQL
  183. [SOLVED] Datestamp an adjacent cell & not allow later alteration
  184. Show or hide several lines depending on 1 cell.
  185. Automatic copying of Cell Contents & insertion of new worksheets
  186. Concatenation of differing variable types
  187. [SOLVED] Filldown macro for 2 sets of inputs
  188. [SOLVED] Conditionally hide rows in Excel
  189. [SOLVED] Run-time error '91' when 'On error goto' and cells.find
  190. [SOLVED] VB/Macro Protection
  191. Listing .jpg filenames
  192. Pulling numbers and sum
  193. Web queries, Macros, Stop auto-running, Userforms
  194. Checkmark to show worksheet
  195. Code Under Button Not Recongnizing New Sheet When Copying
  196. [SOLVED] ActiveChart Location Problem
  197. [SOLVED] Instruction to copy rows from one file to another.
  198. Select Sheetname if checked
  199. [SOLVED] Running macro every 20mins.
  200. [SOLVED] Workbook_BeforeClose Event - passing arguments
  201. [SOLVED] Converting Data To columnar(sp?) data
  202. [SOLVED] For Each Next
  203. [SOLVED] Conditional Formatting based on value of last cell
  204. Hardcode Folder Path
  205. [SOLVED] How to create a Loop
  206. Cross referencing large spreadsheets for overlap
  207. Creating a Random Timer Script
  208. Updating Link eats my memory
  209. MS Excel Re-Opening Spreadsheet
  210. [SOLVED] VB Calendar Macro to highlight current date
  211. [SOLVED] VBA Created Pivot Table Doesn't Show Data
  212. Drop down list disapearing
  213. macro to copy Workbook to Workbooks
  214. Delete Rows Using Inputbox
  215. Opening data files within zip files automatically
  216. copy whole (selected) rows in another table with different labels
  217. Shared Workbook Conflicts
  218. [SOLVED] Getting macro to save in folder specified on worksheet
  219. worksheetfunction through vba
  220. [SOLVED] Changing the colours of a userform
  221. Missing Line of data for a Macro
  222. Conditional format based on VBA
  223. Macro extracting data from one table to another
  224. macro for subgrouping
  225. Excel Stopwatch to record bike laps
  226. [SOLVED] VB Macro for Proper Case to Ignore "/" & "-"
  227. [SOLVED] Conditional Formatting Based on Time Window
  228. Compare data in 2 columns
  229. [SOLVED] Including sort function in command button code
  230. [SOLVED] Selected Excel Range to Power Point Kinda...
  231. [SOLVED] Pausing and referencing in VBA
  232. [SOLVED] break 1 cell up into invidual cells..
  233. Pop up Box
  234. Add-in to saving groups of worksheets as a single workbook
  235. [SOLVED] Assign results to an array
  236. Using cell reference to pass paramater
  237. [SOLVED] looping through an array
  238. Find a value and delete rows
  239. [SOLVED] Conditional locking of cell based on another cell
  240. Create Table; Update Table: MS Query
  241. [SOLVED] Calculate BiWeekly Pay Periods
  242. Adding to a list
  243. Summing up saved worksheets
  244. Add, view & update function
  245. Delete Rows
  246. GotFocus event for Frames
  247. [SOLVED] Delete empty cells and shift remaining left
  248. [SOLVED] Adding two rows together if they have the same value in Column A
  249. [SOLVED] Macro to extract Data
  250. Is there any Macro exctracting zero values from a number