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. hiding the column...errors coming
  2. Rounding Up Durations
  3. Using more than one input box in a sub procedure
  4. Simplify recorded code
  5. If next cell in a row is not blank then enter blank in that cell
  6. Macro to split cells into inserted new row and copy the rest of the row into it.
  7. How to open a Word.doc using VBA and count the words in the word.doc?
  8. additional option to an existing macro
  9. how can i use wildcard parameter
  10. Interactive .htm resize
  11. Any recommendations on a good VBA Excel book?
  12. lookup from one document to another and paste in adjacent cell
  13. PIVOT TABLE: Hide All Fields (without specific criteria)
  14. array initialization
  15. Counting events on a given day
  16. Macro to hide rows if 0 is in cells
  17. Module name in Macro name problem
  18. Complex Conditional Formatting
  19. Is a workbook password protected?
  20. find last non blank cell in a column and copy paste in next row
  21. Named range in VBA Vlookup?
  22. Populate listbox using vlookup or index,match?
  23. Sort range if cells change
  24. How do i loop from column 2 to the column that has data
  25. List with missing links!!!
  26. Data sorting
  27. Read time from Excel Sheet give strange result
  28. dynamic naming cells
  29. Select method class range failed
  30. Trying to trim a trailing space char and the Trim function isn't working
  31. Launch Email with a dropdown List
  32. copy & paste issue
  33. Mail Merge with ONLY Excel?
  34. Formula Acting On Specific Workbooks
  35. with...end with statement
  36. Subject: Delete All Worksheets Apart From Some With Particular Name
  37. macro that puts a formula in a group of cells then goes and values those cells
  38. Delete HTML tags
  39. Subject: Create Worksheet BUT If It Already Exists...
  40. Copy and Paste based on cell color index
  41. order of execution?
  42. Looking to Cleanup my Code
  43. Macro that will open array of workbooks
  44. Find and copy macro
  45. Disable functions for workbook only?
  46. Kicking Inactive users by auto closing workbook
  47. Insert multiple rows in specific sections of sheet?
  48. Buttons to move cells from one sheet to another (back and forth)
  49. Calling btn_Click event from different sheets
  50. Allow autofilter on protected sheet (via vba)
  51. Username required on each row
  52. Check if file is open
  53. Easy option button question
  54. Scroll Multiple Sheets to the Same Position Simultaneously
  55. Network filepath
  56. Labels at the Top Row???
  57. import file problem
  58. Object Required?
  59. How to open files
  60. Using a macro to put a function in a certain cell (runtime error 1004)
  61. Outlook Tasks
  62. Count Number of Columns
  63. vba script to generate files based on an data from an Excel sheet
  64. understand workbook_beforeprint
  65. make db call to pull one additional column
  66. How to make add-in macros available in Excel
  67. Locking Tools, Options for Excel File
  68. Cells don't show up online until cell is selected.
  69. Manuver through a webpage using frames
  70. Error - automating mail merge through word
  71. OnTime Problem
  72. Copy ListBox contents to a Worksheet
  73. Multiple IF/Then assignments
  74. Save Workbook using name and path in a cell
  75. How to control/pause SQL Query Execution?
  76. Not allowing cancel on save as
  77. Fill color in Range between specified value
  78. Assign a password to a macro button?
  79. Mysterious "sumif" result
  80. Adapt macro to format large data set
  81. Data Validation in a table
  82. Change Multiple ranges in one go
  83. Automated Cell Replication
  84. Running Java code from excel
  85. Find files in a directory using excel VBA
  86. copy-paste from one xl wbook in to another and then save it as a .txt file.
  87. Date ranges between date ranges
  88. how to retain formulas when cell data is deleted
  89. Macro to delete alternative rows
  90. Highlighting referenced cells within a formula
  91. Lock a project using a macro
  92. Loop to see if checkboxes is True
  93. Date and Time Stamp with Check Boxes
  94. Hlookup identical cells
  95. Text Encoding
  96. macro for multiple tabs from a data set 2
  97. create a vba msgbox if
  98. populate listbox based on selection in previous listbox
  99. used from another user
  100. Listing text values
  101. toggle taskbar
  102. macro to hide rows if equal to zero
  103. Rogue modules & data transfer problems
  104. Networking Printers
  105. Clearcontents of range on multiple worksheets
  106. Horse Racing system
  107. Copy to the next available empty cell
  108. Copy values to template & creating new sheet
  109. copy matching data between worksheets using macro???
  110. Processing/separating data with VBA
  111. Double Click cell to jump to sheet
  112. Windows Options - Columns and Rows Headers
  113. Freeze Panes issue
  114. Data Validation
  115. question setfocus on a userform
  116. Mod macro recorded code
  117. On a Carlog worksheet how do I do this?
  118. Receiving error when trying to copy a worksheet from one workbook to another in VB
  119. Printing worksheets with a click of a button?
  120. Print / don't print pictures
  121. Excel Add-In: how to position custom toolbar
  122. Pause until key is pressed
  123. filename cell updated with the filename inputed in the dialogue box
  124. sytax to select next row
  125. Match / Combo Box
  126. select, copy, paste into new row
  127. How I can protect my sheet.
  128. macro to save sheet with new name/fixed values
  129. Numbering a column and Dating a Header
  130. Event Driven Code
  131. Scrolling text in a Cell
  132. Inserting valuse visual basic in excel?
  133. Messagebox triggers before the Focus gets to object
  134. arrays in VBA
  135. Date converting YYMMDD
  136. Filter change triggers event?
  137. macro dialogue box.
  138. Resolved >>> Hide blank rows within a range
  139. Capture Data from Cell
  140. Change Positive to Negative
  141. copy manual selection, then paste
  142. finding last row
  143. generate reports via VBA
  144. Combobox change
  145. Removing rows based on duplicates?
  146. Unstable Macros - Errors
  147. Loop if one column value next column?
  148. Creating a serach-database for various input
  149. Deleting rows automatically
  150. How to ask excel to look for a specific header then do something with the column?
  151. Macro/auotshape/sound
  152. Runtime Error '1004' - but different
  153. Insert If formula in cell via macro?
  154. Working with Multiple Tabs/Windows
  155. ByRef problem in VBA
  156. How To Set Yes/No Boxes in Excel?
  157. How to store a value
  158. Amending code
  159. Sheet Management - Protected Workbook Structure
  160. How to catch when the user clicks a cell?
  161. Get workbook filepath
  162. VBA Stopped Working!
  163. check sum value 2 sheets up
  164. creating formula in macro
  165. Restoring Save functions after Workbook_BeforeSave
  166. Combo Box VBA
  167. switching fields automatically
  168. how to copy matching data between worksheets
  169. Adjusting master volume
  170. Copy Sheet & Graphs to a new sheet
  171. Macro to change the view of a pivot chart/table
  172. Option Button in a Frame
  173. Pivot table macro
  174. Filter from custom drop down list
  175. If...Then Conditional: Range Match
  176. Resolved >>> prevent hyperlink from showing
  177. auto alignment of Frame on a userform
  178. VBA lookup
  179. Massive Sorting question.
  180. Function Works from VBA, but Not from Spreadsheet
  181. Delete sheet based on name
  182. Custom Function to Add New Formatted Rows
  183. 'OR' operator
  184. Trying to determine if worksheet exists, subscript out of range error
  185. Macro To Change Pivot Table Page Field
  186. Can anyone recommend a good introduction to VBA?
  187. Macro to extract records from a list
  188. Resolved >>> Adjust code to include sorting employee sheets a-z?
  189. Replace part of formulae - Macro
  190. Visual Basic coding for excel database
  191. Extract unique values from block of data
  192. Macro to remove items from spreadsheet
  193. Excel file opens twice when started from web link
  194. Updating a worksheet based on the presence of a particular data
  195. Range variable question
  196. File Open Dialog
  197. VBA sort data on different sheets
  198. Remove Any Pagebreaks
  199. problems with ontime method
  200. Adjust chart size
  201. Resolved >>> Comma separated values in a cell
  202. Excel 2003 Query Table Deleted on Refresh
  203. Simple Drop Down List Box with Sub-Categories
  204. Custon Function to Interpolate Table Error
  205. Amend VLOOKUP across multiple sheets for anothet wbook
  206. make macros available in intranet
  207. Solved >>> Finding Last Column in Row
  208. Concatenating Columns values
  209. eigenvectors of a 5x5 real matrix
  210. Reading from Registry
  211. Resolved >>> FIltering Non blank Rows
  212. Beginner dealing with variables
  213. Ref a cell with a hyperlink from multiple worksheets
  214. Excel Button from PC to Mac
  215. closing a workbook without saving and closing a workbook with saving enabled
  216. Comparing worksheets
  217. Number conversion on import
  218. MSFlexgrid alternative
  219. Custom tool tip for custom functions
  220. Error/Warning message when accessing outlook
  221. Resolved >>> filter based on cell refernce
  222. Resolved >>> password protect a macro
  223. Hyperlinks
  224. Problems opening other workbooks from UDFs
  225. how to get created/modified date ?
  226. Website/books/Ways to learn VBA
  227. Resolved >>>For Loop not finishing.
  228. Macro Modifcation to get data from named sheet
  229. Copying a Cell and Keeping Macros Linked to Button
  230. How conditionally replace values in a range
  231. Run-time error 1004 - application-defined or object-defined error
  232. Solver question
  233. Automatically Launch Macro on Open Once Only
  234. Print box macro
  235. VBA to control web page and scrape data
  236. Protection - Trial Version
  237. Form Checkboxes
  238. Resolved >>> Specifying (other) Worksheet w Function
  239. launch a video when the workbook opens
  240. Make a comment's box autofit to the text
  241. Autofilter - Tell if activecell is filtered or not
  242. Resolved >>> Hide Blank rows within a range:
  243. On mouse over comment
  244. Remove Numbers From Alphanumeric Cell
  245. Importing Data from Google Finance
  246. Opening file with poup window in vba
  247. Disable Excel Close button (X) on Menu
  248. A script that satisfies a condition, to change the input column
  249. Resolved >>> Track if user press cancel in save as dialog box
  250. Clear protected cells