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. Excel and Web Query Question?
  2. Last in Range
  3. Forced Upper Case
  4. Macro to Copy Data from a Pivot Table
  5. Converting VB to Excel VBA
  6. For each next statement error?
  7. Find the result by function or by vba code
  8. newbie query
  9. Loop array
  10. Declaring array through Inputbox
  11. Rename Excel File via FTP using macro
  12. Passing different value from combobox
  13. Change event macro - Select cell
  14. cell counting vba code?
  15. using a user defined function
  16. Repopulate to UserForm
  17. Preview function
  18. MSFlexgrid merge cells
  19. automatic message upon opening of file
  20. Sequential Numbering Macro
  21. Code for saving a back-up file
  22. Opening Correctly Dated Workbook Automatically
  23. trouble auto sending excel sheet via outlook
  24. 6 digit number (or more)
  25. Userform (Windows Exit Button)
  26. Replace underscore with hyphen
  27. Automation Error
  28. how to remove all the spaces behind the last character/digit
  29. copy chart to the right
  30. insert a blank column if a cell is blank...how?
  31. Tokenizing a Cell
  32. vba hyperlink
  33. Scanning into Excel
  34. Multiple Answers For A Cell
  35. Opening Hyperlinked File Under VB Control
  36. add a new row or column and it automatically adds it to the rest of the sheets
  37. Macro code to find and delete numbers
  38. Deleting Rows to compress data
  39. Check Workbook
  40. can't get macro to work as cmd button
  41. Count all but 0
  42. find and copy matched cell on other worksheet
  43. Open exlorer path from inside excel!!
  44. finding the greatest number
  45. Using Excel VB to control Internet
  46. Random number
  47. Shadow of range via vba
  48. Changing a single Char in a string to another ASCII char
  49. Advanced filter code not working correctly
  50. Button Referencing Macro that works on any file
  51. IF AND THEN ELSE (in UserForm)
  52. How to use this loop ?
  53. Creating a bar chart from scratch
  54. Sorting Columns
  55. Linking 13 workbooks problem
  56. Grouping the ranges
  57. Error 424 Object required
  58. User Form Won't Load
  59. Can you store a macro on the Desktop, G-drive or C-Drive
  60. How to display the last cell with data from an Access table
  61. Default data
  62. User Defined Function
  63. Removing Blank Cells in an Array and Condensing
  64. calling functions in another worksheet
  65. Automate the Adding of New Worksheets
  66. if statement - if A1 is blank then A2 to return zero
  67. How to include 3 cells left to the target cell using MAX?
  68. code with ambiguous name detected
  69. Partially Populating a form with a command button
  70. Right click network utilities
  71. Searching Data with Multiple Matches
  72. A specific Delete Macro
  73. Select entire row using a variable
  74. Delete Row Based on Cell of Another
  75. Excel Copy and Paste Macro based on criteria
  76. How to slow down a little a macro
  77. Trouble performing a lookup in VBA (by inserting a formula)
  78. Manipulating Data
  79. Rounding & formula error
  80. macro - pivot table
  81. How to synchronize two excel files
  82. auto shade cells
  83. Generating Lots of Random Numbers
  84. Answer Excel 'yes/no' question in Macro without user intervention?
  85. Cutting sheets from workbook and saving elsewhere using list?
  86. AutoFill cell from above macro
  87. Make macro exception if data in field
  88. Default Value in Combobox
  89. Global Array - How To Size
  90. Write VBA code through VBA
  91. Linking Object Size to Cell Value
  92. search 1 column then copy 14 rows
  93. Results being pasted into a row not a column?
  94. Sql SUM function problem
  95. rangename into combo (FillList)
  96. Filling last column outside a current region
  97. Limiting the no of times a macro can run
  98. Problem with macro containing Vlookup - error handling??
  99. Static Macro Buttons
  100. vba code to create a list from data in one field
  101. Advanced Filter + Several Macros
  102. If query adaptation
  103. Adding a macro button
  104. Code for Multiple If conditions
  105. Comparing multiple values and Conditional Formatting
  106. Arrays in Macros
  107. MsgBox
  108. classifying non adjacent lines and columns
  109. financial model
  110. Conditional Formatting
  111. Delete Hidden Name Ranges
  112. combobox issues
  113. Count specific characters with numbers or letters
  114. Looking for add-in to edit HTML code in select worksheet cells
  115. looping issues
  116. Control down with Macro
  117. Assign letters to #'s
  118. Extract unique items from a Table and place in a column
  119. Extract certain records based from list based on date
  120. prevent user moving form on screen
  121. UserForms staying functional
  122. Query worksheet
  123. pause macro until data has been selected then carry on
  124. Return the number of pages to print
  125. BeforeSave not working properly
  126. message box showed when in cell key or selected
  127. Textbox decimal numbers
  128. VBA Code required for deleting special characters
  129. compile error in hidden module
  130. Double click problem with command buttons on userform
  131. Clearing multiple textBoxes and listboxes
  132. Make a work book readonly on opening?
  133. Pop up dialog box and Filter data question
  134. Find Text Within Other Text and Then do vlookup
  135. TextBox OnKey Issue
  136. Data Grabbing from internet
  137. VBA Code for deleting contents of multiple lines
  138. Writing '0' to a particular range of cells
  139. Delete words with certain format
  140. insert a row every nth row and sum range
  141. Auto alert or auto print on due date
  142. Screen problems with forms
  143. Substitute text
  144. E-mail range
  145. ADO Macro Qeustion
  146. xml file?
  147. Enable Date Time using a check box
  148. Removing blank rows after importing
  149. Matching Products in Pivot Table
  150. If, then inside a for, next statement?
  151. Selecting multiple ranges with a macro
  152. Find Numeric
  153. NETWORKDAYS in 2003 and 2007
  154. Display names in MsgBox
  155. Perl script to create CSV files. How to add vba code ?
  156. Drop downs plus selected text
  157. Extract startdate and enddata based on week number
  158. Make Excel 'remember' filters?
  159. Attention nevrborn
  160. Macro to run once list box selection made
  161. Folder Hypertext editting
  162. Loading Worksheet Range to VBA Array
  163. Data Manipulation
  164. Running macro on all worksheets in a book
  165. Auto number code
  166. Creating flow charts in Visio from Excel
  167. Code to delete lines of text?
  168. Calendar object - Selecting more than one date
  169. save all data of various sheets in a text file
  170. Indirect formula - Closed workbook
  171. Macro is using 51% CPU and I don't know why.
  172. Suggestions for VBA books
  173. Merging rows cells
  174. Command button not working properly on different sheet
  175. Pathname - Delete everything before a /
  176. spread sheet calculations using visual basic
  177. Print area changing with input
  178. Macro to Delete if cell empty
  179. Hide text with asterisks
  180. Convert to UDF
  181. highlight the top four runners
  182. Deleting rows if xxx.....but do not if xxxx...
  183. Formatting Date
  184. duplicating rows based on one column
  185. Switching between textboxes
  186. sub cell drop down
  187. VBA Type Mismatch Error
  188. Running Macro Is Freezing Workbook
  189. Importing specific data from a Text file
  190. Running a subroutine at 10 min intervals
  191. Macro pulling data from separate file help
  192. Recovering a macro from a corrupt excel file
  193. number conversion in SAP->EXCEL transfer
  194. Creating a machro that search tag name
  195. Lengthy If_Then Statements in FormulaArray
  196. Deleting rows with a specific value in the first column
  197. Conditional Formatting Not Working In Macro
  198. Compare two columns
  199. Retrieve data from another sheet
  200. Error message - Method 'Select' of object 'Shape' failed
  201. Error trapping
  202. Question on "FreezePanel"
  203. #VALUE! Error - Unknown cause!
  204. Question about running workbook off usb stick
  205. Creating a Macro that hides part of your spreadsheet
  206. Error Saving after running Macro
  207. Copying Sheets, Moving to End
  208. Counting Time
  209. Trying to smooth the runtime...
  210. Userform question re: textbox/commandbutton
  211. Hiding rows
  212. network user access
  213. Copying macros from a file to Personal Workbook
  214. Title bar at the bottom
  215. check a row of data for a value return a boolean result
  216. Filling a column of cells outside a current region up till the last row in the region
  217. Delete rows?
  218. Pasting Formula Values After Calculation
  219. Converting a Formula to VBA statements
  220. VBA code runs slow until I push ESC
  221. Baisc Macro knowledge
  222. FormulaArray Which Delivers Text Instead of Formula
  223. VBA code to unlock multiple sheets
  224. Copy -> Paste Special -> Values (PROBLEM)
  225. Progress bar together with upload function.
  226. Combine Subtotal Macro
  227. worksheet Display size
  228. cell value based on another cell
  229. Sorting
  230. pages seem to mirror each other
  231. Using range names in VBA?
  232. Passing a string to Case statement
  233. Resolved >>> Checking Cells are empty before print macro
  234. Alert if Sheet is Unprotected
  235. send instant messages using excel list
  236. Extracting Numbers from rollbook entries
  237. Approach for Schedule Calculation Macro
  238. Error #48 "Error in loading DLL" when new Add-in runs
  239. Excel to Powerpoint
  240. list formulas
  241. Clearing Cells with Protection
  242. Reduce image size before inserting.
  243. joining the numbers from different cells conditionally
  244. Determine path to take based on program being called or not
  245. Running Macro based on Cell value
  246. Macro to insert lines and copy
  247. Error Changing PivotCache
  248. OnTime Method
  249. If And Or statement vs Vlookup
  250. Deleting in excel