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. Need help tracking points for a poker tournament.
  2. Macro Coding Help
  3. Find & Insert
  4. Deleting all vba code after savecopyas
  5. Help modifying existing VBA code
  6. Problem creating a progress bar
  7. How can I execute a windows batch file
  8. Compare and Update between 2 worksheets
  9. Conditionally format columns
  10. Creating pivot table to Existing worksheet
  11. Same program, different CPU, different results
  12. Excel automatically restores down
  13. How to quickly save several tabs as files?
  14. Excel list to match to file name
  15. macro to apply a formula which contains a self-populating reference
  16. Find constant in table when variable changes
  17. Retriving information from different workbooks
  18. Scheduling monthly Print jobs
  19. Not able to retrieve value from listbox.
  20. Subscript out of range error when using nested if statement
  21. If ActiveCell is a distinct cell
  22. more email help
  23. Dynamic Sheets
  24. VBA to read column selection
  25. Error in 2003 - Runs OK in 2007
  26. VBA Editor Options for Excel 2007
  27. Auto open &cloesd with backup file
  28. Find Macro
  29. Programming hyperlink into pulldown menu
  30. defining names in macros
  31. Add Worksheet Names to an Array
  32. Finding string Text
  33. macro to suit
  34. Execute code from auto generated buttons in a userform
  35. Separate monthly payments in Cash Flow statement
  36. Excel Automation Errors
  37. Runtime error when sheet not active
  38. Textbox - allow only numeric or empty entry
  39. dynamic list box creation
  40. writing a hyperlink into a cell
  41. how do I expire a spreadsheet?
  42. Variable reference in macro formula
  43. macro to email on save
  44. Referencing cells based on a corresponding cell value
  45. Reduce File Size
  46. Website autofill
  47. minimum values between two tables
  48. VBA Listbox
  49. Create list of unique descriptions for each term
  50. Autofilter with custom Dates
  51. web query - fill col K with a value based on parameters from Col A,C & D
  52. has a row been grouped
  53. duration calculator (in minutes)
  54. Problem with cell.Find
  55. Auto Filter Paste Error
  56. Forms Check/Uncheck CheckBoxes
  57. Move Cells to another Worksheet
  58. for i = 1 to 18
  59. Looping Problem
  60. move rows between spreadsheets
  61. Is there a quicker way to do this
  62. How to check if a worksheet is existing or not
  63. Need Truth on Shared workbook & VB
  64. macros assigned to list box items
  65. Macro with pull down window
  66. Checking Font Color with VBA
  67. Running a macro daily
  68. Extending the range of an existing VBA based worksheet
  69. Simple matching of cells?
  70. .xls tp .pdf
  71. Multiple Users on network
  72. Filling listbox with strings from data sheet
  73. VBA loops: conditional copy to another worksheet
  74. Close if macros disabled
  75. Speed up cell deleting process
  76. find common occurrence of numbers
  77. Retrieve table data with a name match
  78. Custom menu appears twice
  79. userform won't unload properly!
  80. Ungroup causes Run-time 1004 error
  81. Using a macro to tell when info starts and ends.
  82. If Statement Code
  83. Dynamic path for a file used in the vbscript
  84. Checkbox Can I do This
  85. VBA - Copy and Paste to a different worksheet
  86. Excel property needed
  87. macro runs on sheet that starts it, not top sheet.
  88. Worbook_Open error
  89. atpvbaen.xls Apps won't execute from UserForm
  90. Error when accessing VBIDE object
  91. European # format
  92. Sort, Filter and then auto number sequentially
  93. commond button transfer values to new worksheet
  94. Sum of Two Sheets
  95. Macro to count non-blank rows in worksheets
  96. How to reference VBIDE objects
  97. if not numeric and letter then replace character help
  98. Imported VBA code not working....
  99. paste method of worksheet failed
  100. Code to replace null and not null strings
  101. [SOLVED] code for selecting sheets from combo box
  102. macro code required
  103. need help with creating macro for saving date
  104. Move to next txtbox
  105. VBA 2003 vs 2007
  106. Text macro not working properly
  107. Making Form Remember Selection
  108. getting "full form" from "short form"
  109. Understanding Class Modules
  110. Show two UserForms and transfer data
  111. digital certificate questions
  112. Name sheet as next month...
  113. Restrict user from over-writing workbook
  114. Sorting, On Third Character In a name
  115. Update modules in VBA environment
  116. Sorting data from one sheet to another
  117. Update Screen Location based on cell address
  118. Saving a Module
  119. Copy data from a worksheet to another one
  120. Copy data from a worksheet to another one
  121. Refresh on open
  122. Macros on other computers....
  123. Deleting cell no value by clear Content
  124. Find first value
  125. Printing Macro
  126. Running a macro at certain times
  127. Changing Data in another Worksheet
  128. Text File for creating report
  129. Excel Macro/VBA Program That Converts To CSV
  130. Automatic sheet update
  131. VBA refuses to change cells
  132. Cell Color
  133. Validating Input
  134. Count cell avarage from selected sheets
  135. data selected by validation 2 list
  136. real time countdown timer function with ticker
  137. Problem with copy/paste to empty cell
  138. Syntax for Input Box
  139. Macro to save emailed file in Lotus Notes with changing filename
  140. Data Type, VBA
  141. Add total count
  142. Find a header and loop until the last header
  143. Macros stopped working on one server only
  144. Visual Basic changes?
  145. Order Summary Page
  146. Import Text Using ADO to excel
  147. Refreshing Time
  148. Auto Subtotal
  149. Macro/command button to reset all filters in pivot table
  150. search for date, copy that row and the 40 rows below it
  151. Add to Total and Clear Macro
  152. Processing/Calculating Range Of Cells
  153. creating clear contents button
  154. Function to grab info in middle of string
  155. jumping to the next row
  156. insert text if criteria met
  157. the object invoked has disconnected from its clients
  158. Comparing the same cells in two worksheets.
  159. Send notification from Excel
  160. Compile Error
  161. Challenging List & Vlookup
  162. Running a macro in another workbook
  163. Before Update of Cell
  164. Vlookup UDF with concatenated lookUpVal in tableArray
  165. attempting to automate an import with variable data
  166. receive email automatically when excel file is updated
  167. help editing validation codes
  168. email "FROM"
  169. Copy from One Worksheet to Another Automatically
  170. [SOLVED] Need to apply 4 conditional formatting rules.
  171. Macro for defining a range
  172. Review my code and help me write it better
  173. Macro for 'n x n' Matrix formation based on user inputs
  174. Having the user specify a column when running a macro
  175. Changing True/False Data depending on another cells value
  176. Subdivide worksheets and send with macros
  177. [SOLVED] 4.0 Macro in Excel 2003
  178. Is there any way for me to automatically align corresponding data?
  179. One Button for Hide_Unhide
  180. Message box for specific user
  181. Protection stops VB code?
  182. Problems creating 50+ new sheets
  183. Multi Import - Fixed Width
  184. calendar popup from active cell selection
  185. Identifying Bold text and copying value
  186. Delete rows based on fill color
  187. Update cell once the Button is clicked
  188. VBA Code to Sort/Add/Highlight
  189. copy data from other sheets that within same row and column.
  190. Setting a Reminder in Outlook via Excel
  191. VBA Script Help Needed & Formula Error
  192. using VBA to create user forms
  193. Step through rows of data resulting from a filter
  194. Running a batch file from Excel
  195. Opening files from a list
  196. integers and variable values
  197. Need to modify current vlookallsheets function
  198. Add-In with Button and Sub-buttons
  199. copy table contents
  200. VBA to copy and paste values for all sheets in a workbook
  201. error to list data into listbox
  202. copy and paste special values
  203. Sometimes error sumetimes ok
  204. Change cell color based on two values
  205. Page Break Macro
  206. Change Value in Same Cell
  207. storing username and password data in .txt file
  208. Hyperlinks (Passing to UserForm)
  209. loop throught all the sheets without selecting them
  210. Visual Basic - Not allowing cell entry
  211. Need help with adding Command button
  212. Referencing cells in other worksheets within the same workbook.
  213. Display Cell Value on UserForm Label
  214. Macro to add a row to subtotal
  215. Rearranging Data Set by a Table
  216. macro to add cell values
  217. Error programming Logarithmic Values for Y axes
  218. How to creat a sheet in Excel when the sheetname include space?
  219. Error 1004 runtime and messagebox?
  220. Export *.txt to 'current_filename'.txt in Current Working Folder
  221. Making a consistent time sheet
  222. Check the beginning of the value in a cell and replace the value
  223. [SOLVED] Toolbar Command Button
  224. How to stop form, if it has been already sent?
  225. advanced transpose
  226. sum the same model + same side + same #
  227. Insert Row Based Upon Cell Value
  228. Copy cell value to list with command button click
  229. removing duplicate rows
  230. Using a formula to arrange items based on table
  231. Automatically set min & max scale for y-axis
  232. Using Solver With Another Iterative Routine
  233. Macro to color bacground of the cell and log time if cells content changed
  234. TextBox Details transfered into Cell.
  235. Lock columns after text is entered
  236. insertig definite cell reference from another workbook
  237. Conditional Trigger
  238. How to get all the sheetname in Excel via COM?
  239. Adaptation of code to delete data
  240. Find Data
  241. Add subtotal to rows based on the format of cells.
  242. cascading comboboxes
  243. Password protect 1 sheet
  244. multiple users
  245. Using Variables and calling subs
  246. Create mail with body from clipboard
  247. Frequency Table
  248. copy range of cells between spreadsheets
  249. Matrix formation based on user input conditions?? - Kindly help
  250. FIND funtion VBA Equivalent