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. Calling Cell Range within Loop Program
  2. Trouble with Excel Macro called from ASP
  3. How can I sort colums and rows when the rows always change?
  4. Print specific rows to a form
  5. orginizational charts in excel
  6. Condition Cell
  7. Encryption stopping UDFs
  8. Breaking out records based on qty
  9. macro to search 4 columns & plot them... eligantly...
  10. Compile error on variable (not defined)
  11. loop sort
  12. Data to appear directly after pivot table
  13. Could not access my macro
  14. Perform one task at a time
  15. Conditional Format for a Shape
  16. Vlookup in Macro
  17. Track Changes Advanced
  18. Subscript error
  19. Display Status of Locked Sheet
  20. how to process multiple files with a macro
  21. Email to update excel?
  22. Run-time error 1004
  23. vba-multiply a range with number(text_box) and format range
  24. Countif Looking for specific 2 numbers at start
  25. Formula for copying data from sheet to sheet
  26. extract records from file 1 that do not have a string match in file 2
  27. Updating of data between worksheets
  28. How do I search Strings and get an output?
  29. Random Numbers
  30. Add-In needs relinking?
  31. Macros consolidations &-#DIV/0!
  32. Writing formula to column using macro
  33. match data, then copy
  34. How to find max value of list of numbers?
  35. Combine muliple rows into one based on criteria
  36. Find blank rows and insert text
  37. Read-only error using Form Button with Assign Macro
  38. Accessing MANY Excel files
  39. How do I implement a frmCalendar?
  40. Paste disabled
  41. Open and Close Excel / Time Running
  42. Textbox control
  43. Naming Sheets
  44. Change Cell Colour Using in-cell If Statements?
  45. Select columns and add the content of the columns to a mail
  46. copy only certain rows
  47. Compile Error: Invalid Qualifier in column sum/cell naming program
  48. Macro to reference data from one sheet to another
  49. define save path for workbooks.add
  50. deleting text from cells
  51. Coding to reply to a warning popup?
  52. Defining Names in VBA (not in Excel)
  53. Edit Email Macro - Lotus Notes
  54. Create/Applay a macro to a column
  55. remove duplicates doesn't remove A1
  56. Use Text as Formula
  57. Finding an active cell in a row
  58. variable not capturing the "0" from user-entered info
  59. Value reference between cells
  60. Excel to outlook email. It was working
  61. Check to see if a file exists
  62. Finding a string in another string"
  63. Pick codes and colours from other sheet
  64. Data Base Entry
  65. CSV data manipulation in Excel - use a macro? equation? pivot table?
  66. Copy sheets and remove named range
  67. testing password
  68. MouseMove ???
  69. vba - delete rows if they do not fall within dates
  70. Problem with commas in exported text files
  71. Run code whenever any radio button is clicked
  72. Subject heading in CDO message
  73. Getting a range from an array formula contained in a cell
  74. Simple formula via VBA
  75. Compare & ... with VBA.
  76. Cell BG Color based on another worksheet
  77. How To List Recent Changes to Document?
  78. Compound range selection with R1C1
  79. User-defined variables in MS access query
  80. Advanced Track Changes
  81. Paste csv data into an xls sheet in the correct columns
  82. filling range criteria with variable data
  83. Importing external data
  84. iserror
  85. Save File as Current Date/Time
  86. How to retain date format when using ActiveCell.Offset().Value
  87. Pivot table: how to subtotal specific row fields
  88. Line Numbers needed
  89. Negative Time Values
  90. Macro to Copy/Paste Data from One Sheet to Another
  91. Deleting blank spaces in queried data
  92. Invalid procedure call or argument
  93. Copying a whole sheet from closed workbook
  94. If query additional values
  95. Making the user be able to format a text box
  96. Strange Textbox value problem
  97. Textbox 2 Value is formula based on Texbox 1
  98. Audio / Sound warnings / alerts
  99. list of cells with #NA
  100. xls to csv conversion
  101. macro to name a certain range
  102. Moving down cells of column A based on number of non-blancs at cell B
  103. Copy/Update data to another worksheet
  104. Ignoring common word
  105. Loop thru cells in same column
  106. Locating active cell
  107. Send email via Excel button.
  108. Macro to match and lookup
  109. collating data from Mutiple files, fields value not updating correctly
  110. VBA code for option box
  111. Defining Ranges
  112. Where to Place the macros???
  113. Clearing formulae from certain cells
  114. Connect to Oracle via ODBC without any Dialog for password
  115. Add IF(ISNA to existing formulas
  116. moving the 2nd word in a cell in front of the first word
  117. Multiple IF conditions and SYNTAX Error
  118. cant create simple macro for copping cells
  119. For Next doesn't find them all the first time
  120. open a path via button issue
  121. prompt to replace existing file
  122. Add Find Function to Spreadsheet object
  123. Find, Copy and Insert Copied Column
  124. Error Compiling code:
  125. Command button click code
  126. Right-Click to Paste Special Values
  127. Sample Rate
  128. Open worksheet
  129. Copy Excel Chart label Using VB!!!
  130. Code running slow
  131. Wrong times
  132. have a msgbox without waiting for user to click
  133. conditional format #N/A
  134. IF Error Then Exit Macro Help!
  135. How do I refer to the items in a combobox by their number in the list of items?
  136. VBA: Return the Column Letter Heading
  137. Subtotal clearing
  138. VLookUp Challenge
  139. setting column widths
  140. Hypertext link to external site automation
  141. Writing VBA Macro or Excel Function
  142. Userform text boxes and "Proper"
  143. macro to the next cell and repeat
  144. VBA and HTML Forms
  145. Connect to embedded Access Database?
  146. My code is jumping workbooks
  147. Find Last Empty Cell, Copy Data from Different Worksheets to One Main Worksheet
  148. Export Sheets Values to new Workbook
  149. Macro to Check if Cell Contains Data
  150. Kicking Inactive users by auto closing workbook
  151. Code to cut from one worksheet to another?
  152. VBA Lock
  153. Obtaining summary of a raw data set
  154. Read only...
  155. Excel or workbook close
  156. Inv Management - Comparing 2 worksheets
  157. Macro to delete row...
  158. Performance of VBA
  159. Inventory mgmt: macro to find compare 2 value on 2 different sheets
  160. Excel spreadsheet sheet tabs
  161. Run macro if a cell is empty
  162. Hiding Task bars etc
  163. Code to Export Excel Data to Text File
  164. Selective transpose in Excel through VBA
  165. vb code to delete macro before save file
  166. search method of range class failed
  167. Mag - Please change your title
  168. putting a chkbox caption onto a worksheet cell
  169. Sorting the dates in the combobox
  170. how to launch excel macro from desktop
  171. Macro to save a file as latest version
  172. Macro -Equal Interval Averaging
  173. Return the Name/Caption and Color of a Command Button
  174. Selective/Looping substraction function
  175. macros/vba forms
  176. Automating a macro to repeat itself
  177. Validate input of user, Integer required
  178. multiplies a range of values by (A1) in multiple sheets
  179. Macro Disabled.
  180. Drop down menu/data selection
  181. Web query refresh
  182. Run-Time error '438'
  183. vba- reset a sheet after printpreview
  184. Run-time Error 9 On Activate
  185. Size of pasted range, size of clipboard ?
  186. Error '1004' when adding sheets
  187. When Row Inserted - Popup
  188. control tip text for images
  189. range.formula
  190. SUMPRODUCT / COUNTIF problems
  191. Autofit Merged Cells
  192. Question about fonts
  193. List of files in folder
  194. Opening a Workbook
  195. Hyperlinks & Userforms
  196. Pivot table.... list of visible items
  197. Losing Custom Menu When Embedded Chart Selected
  198. Message Box to Prompt for Value
  199. Save As Code Not working correctly
  200. variable for row number?
  201. Using VBA to control Duplex, Color Mode and Print Quality
  202. Search within a recordset
  203. How to run Macro without seeing what it's doing?
  204. Group long indented bill of material
  205. Relative References in Array Formulas - VBA
  206. Worksheets not being added
  207. displaying a frame that is behind/embedded with another frame
  208. Can you link multiple files to a parent file...
  209. Caught in an Infinite Loop
  210. Code to transpose rows to colums
  211. Macro to hide rows with no sum in a particular cell ?
  212. if cell does not equal next insert row
  213. Compare names across different workbooks
  214. Macro to adjust values in columns
  215. Trouble with code in Excel 2007
  216. Amend code - February returning wrong dates
  217. Rules for using " " and & and other symbols in VBA?
  218. Writing a "If" before Exit choose to save as other file name
  219. Programming Excel to change colour of cells when clicked
  220. Pop-up message of total amount
  221. Update values in selected row Rather than Insert new row in 2nd sheet
  222. Unable to create message box based on the equal value of two cells
  223. Variables copied into worksheet cells?
  224. Counting Names In Multiple Columns
  225. Lookup
  226. CountA function and Subtotals
  227. using ListFillRange on sharable sheet bring error message
  228. copy a range of data from one worksheet to another worksheet
  229. How to pass CommandButton object ?
  230. Uncheck checkbox WITHOUT running code on Auto_Close
  231. connecting to custom command bar
  232. FIND - command button
  233. Range Issues
  234. Replace Text
  235. Saving to seperate workbooks without including formulas
  236. List box?
  237. Conditional Formatting to highlight particular types of numbers?
  238. Format Border color based on value
  239. VBA code to find cells with formulas and delete them
  240. trying to avoid looping
  241. Delete Row If 2 Columns Blank
  242. How do I obtain the column alphabet number if we know the row column number
  243. Hide_Unhide Rows based on cell value
  244. Inserting Rows with data
  245. ADO-Unable to retrieve type "Memo" field from Access DB
  246. hiding the column...errors coming
  247. Rounding Up Durations
  248. Using more than one input box in a sub procedure
  249. Simplify recorded code
  250. If next cell in a row is not blank then enter blank in that cell