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. error handling on worksheet functions
  2. VBA Syntax for PDF
  3. Copying rows of data to separate worksheets....
  4. Where can I find the 'open file' switches?
  5. having a problem with if then elseif
  6. Descending Counting
  7. How to put more than 255 characters in a string ???
  8. Convert a Value to Sequential Numbering of Rows
  9. Attach File as Zip
  10. Transpose data returned from external source
  11. Select method of Range class failure
  12. Input Box Prompt for password
  13. Find, and replace but copy cells before replace
  14. Auto-save file after check that cells have data
  15. "Please Wait" Userform
  16. Copy Table To comment
  17. Current User who has Workbook Locked
  18. stop user to copy the file
  19. Hide Show columns
  20. Move all sheets to a new workbook
  21. How to convert excel to power point
  22. Text File Written Event?
  23. matching macro
  24. Send data from Excel in email from specific email account
  25. Dynamic Search?!
  26. workbook before close for error checking
  27. Show me the difference
  28. Checking for Add-in
  29. index number of row and column
  30. how to set RGB colors ?
  31. VBA:Printing Sequential Invoices
  32. Collapsing Rows based on cell Values
  33. worksheet creation
  34. How to minimize the Excel window while the Macro is running ?
  35. How to change links
  36. Function to return Cell Addresses
  37. Create a hyperlink based on a hyperlink
  38. Dropdown List Macro activate
  39. Return to org active cell
  40. Calculating Amount based two input boxes
  41. userforms and subroutines
  42. Delete ranges after duplicate is found
  43. Variable passing of parameters in a macro
  44. Range.("a4").select not working
  45. Ignore Type mismatch error
  46. VBA macro to convert decimal to hex and back
  47. conditional formatting for duplicates
  48. import specify sheet index number not name
  49. Resresh DB import within a macro
  50. Converting old code to new code
  51. AutoFit on visible data only
  52. Toolbars/Menu Display - 1 Workbook only
  53. Print todays Report using todays date
  54. How to Hyperlink Worksheets
  55. Moving data into ONE Sheet from several others
  56. save file based on cell value
  57. Extracting values (?)
  58. Graph Creation Problems
  59. Deleting certain words in all cells in one go
  60. Locking the cells another question.
  61. Conditionally Emptying cells
  62. 2 Private Subs merged but 1st needs to complete before 2nd
  63. Using VBA to create mails with multiple attachments (Syntax Query)
  64. Size a cell depending on a TextBox size.
  65. Conditional Formatting - 4 conditions
  66. Activate workbook before close event when excel is closed
  67. Instead of IF and ELSE
  68. Sorting even numbers
  69. Combine value into a string
  70. Removing all text except numbers and letters
  71. Synchronizing and filtering data to be used by another program!!!
  72. quotes within quotes in VBA
  73. Marco to convert table to single Row
  74. merging 2 of the same subs
  75. Use a checkbox to hide a row
  76. Can some one direct me to a "interest add on" template
  77. Auto Extract Data
  78. Change Event problem
  79. Macro to save all open workbooks
  80. Moving Macro
  81. error - Object doesn't suppot this property or method
  82. Insert, shift cells down and populate
  83. How to make Excel NonInteractive
  84. OnTime Method Question
  85. if Activesheets is protected, do X, Else, do Y ?
  86. macro horizontal count after filter
  87. What statement(s) is used to select the next empty row?
  88. Fill Every Other Row
  89. last non empty cell...
  90. highlight active row
  91. passing values
  92. comparing and changing add in 2 work sheets
  93. Codes for counting
  94. button previous to go to previous
  95. create a Desktop shortcut
  96. Excel formulas for checking contents within a cell.?
  97. Macro to total values with certain criteria...
  98. Equation Not Updating
  99. "dynamic" input and worksheet structure
  100. Testing my spreadhseet
  101. Saving sheets to seperate filenames using current workbook filename
  102. finding the column ID
  103. Save a cell as a text file
  104. count of multiple sheets
  105. selecting worksheet
  106. Flitering out dupplicated data
  107. macro problems
  108. paste from 1 sheet into another based on a reference cell
  109. Locking cell after inputting data in selected columns
  110. saving file
  111. Auto-save a new file with data from 3 cells
  112. Multipages on a form
  113. dynamic graph
  114. Dates on a Schedule
  115. Update cell from another dependent on date and then keep
  116. Closing excel using VBA
  117. Prevent save unless all cells or certain cells are filled in
  118. Copy data to an individual file based on drop down list
  119. Re: Button on worksheet to hide columns/rows
  120. How to get min and max of date
  121. Sorting by Color, Font, Ect
  122. inputbox and data validation
  123. List of Clolors with their numbers
  124. vba to change macro file name
  125. How to Zero worksheet count in Workbook
  126. Worksheet count and reference issue
  127. Check the position of an image in relation to a cell
  128. AutoFilter & Selecting Range
  129. full screen form
  130. Extremely elementary question re: macros, VB
  131. VBA jump from one worksheet to another
  132. Problem importing text file using macro
  133. Remember Selected Range
  134. How to properly store cells values and formats for undo function
  135. trim range/column on particular sheet
  136. Displaying a "%" in a msgbox
  137. cell blank if answer to formula is 0
  138. Getting OS User name in excel
  139. A button on the spreadsheet to hide cells??
  140. Merge Macro Excel 2007
  141. Time breakdown function in Excel
  142. Advanced Filter based on variable.
  143. Set Variable in Range
  144. Search and Enter Number
  145. Cross post >> Copying data from one workbook to another
  146. Macro needed to move sheets to folders
  147. Userform to Export Certain Data
  148. How can I use more than 3 conditional formats with VBA?
  149. create a Named Range via VBA based on cell content
  150. Populate list box from a range of cells?
  151. VB to copy variable amounts of data and paste to another workbook
  152. Updating files automatically using data from another workbook
  153. Saving information from form on Spreadsheet
  154. find and return cell contents in another worksheet
  155. Change the Name of a Temporary File
  156. macro - copy range to selectable column
  157. Display Picture in worksheet
  158. Searching a range
  159. Moving text to another cell dynamically with macro
  160. Move to Column d on the active row
  161. Email from excel
  162. filling out a playing feild grid with co-ords etc
  163. Bold a portion of text in a cell
  164. cell content is divided by 100 defaulty ...how to over come this?
  165. Userform with 2 combo boxes
  166. Close workbook if form is closed
  167. Select range, email quit
  168. Refering to another file
  169. Select Active row
  170. Refreshing Values in Worksheet
  171. Conditional formating
  172. Unrecoverable Password
  173. Populating information in a series of Tabs
  174. Trying to autofill to end and getting run time error
  175. multi-line output on msgbox
  176. default error handling mechanism
  177. Check that pivot page value exists
  178. Enable controls in userform
  179. how to delet specific signs or letter at the END of a column?
  180. how to delete specific signs or letter in the beginning of a column?
  181. vba/macro code to total up all occurrences of a value?
  182. NCAA Algorithm
  183. Updating links nightmare
  184. Open Workbooks Behind the Scene
  185. RunAutoMacros
  186. Relative links between workbooks
  187. Stop columns resizing when Pivots auto refresh on open?
  188. Delete rows
  189. macro not finishing task
  190. Printing Multiple Cells on One Sheet
  191. Protect my modules
  192. sumproduct
  193. Copy and cut
  194. insert dynamic formula in active row via vba
  195. CopyFromRecordset method - ADO recordset is empty - XL auto from Access
  196. Userform buttons not working on dynamic form
  197. Sort
  198. Transfering text from a cell to a shape
  199. Switch back to previous workbook
  200. Macro for giving wordlist a dictionary layout/ Preparing for publishing!
  201. Copy Cell To New Workbook & Compute Sum
  202. Delete rows with a value less than 5
  203. macro - autofill formula to end of data rows
  204. VLOOKUP with multiple sheets
  205. Move rows only does the first one
  206. unix type csv file
  207. How can use round in a macro to get rid of the decimals???
  208. Put value in a cell not on current sheet
  209. public function returning value error
  210. Run If statement based on SheetName
  211. SheetExists Function on Closed File
  212. Set print Area
  213. building a formula
  214. DDE Excel
  215. Autofill dates in successive worksheets
  216. Setting apointment start time
  217. Forms for Excel Data Base
  218. Find & update
  219. code not stopping when it should
  220. Copy data using VBA
  221. Side MENU
  222. Excel Add values to userform from workbook
  223. Pasting into pivot database causing duplication
  224. For Each Loop
  225. Excel format settings for multiple users??
  226. Saving a backup
  227. update links on a sheet
  228. Macro Error Detection
  229. Exclude toprow from autofiltered range
  230. Create a Template to run on a Server
  231. Naming ranges in macros
  232. Run macro based on current date
  233. Macro on Drop Down Box Change
  234. Find if values are between ranges and return code and values
  235. Finding the Highest value among a set of numbers
  236. understanding a progress bar
  237. Compatibility problems between Excel 2003 SP3 and earlier versions
  238. Locked screen !
  239. If a record exists on a different worksheet....
  240. copy data and search
  241. Efficient formulas (naming cells)
  242. Unhide Rows when printing
  243. I'm Trying To Isolate Capitalised Surnames From a String
  244. add days using networkdays
  245. if numbers range from this then equals this??
  246. Automatically Generated Average Sheet
  247. key controlled macros vs auto vba macros
  248. Combine 3 sheets of data
  249. Comparing values in a range
  250. Macro Autofill