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. Applying macro within a custom macro button to all workbooks
  2. emailing spreadsheet at the same time each day?
  3. subtracting button
  4. Excel 2007 vba
  5. Use Autofilter in Protected sheet
  6. Copy/Paste from three sheets into one?
  7. How to open Windows Explorer
  8. Apostrophe added during code
  9. Altering fields in MS Access based on contents of xls file
  10. Specify image size when loading into word bookmark
  11. Sending Mail
  12. dealing with too many textboxes
  13. Show Column Automatically
  14. VBA: Trying to set a forumula in a cell
  15. Closing without saving
  16. Keeping formulas in inserted rows
  17. Expected macro runtime
  18. How to know if an MS Access file is yet open?
  19. Reference part of a macro so it runs from that point
  20. Use VBA to change a filename while using SaveAs
  21. Counting
  22. Deleting certain rows
  23. Radio Buttons Selecting Other Radio Buttons
  24. Indirect formula
  25. Tracking Daily, Weekly and YTD sales in a PivotTable
  26. Sheet Management
  27. Add Months
  28. text, number and click?
  29. Runtime error '-2147217887(80040e21)'
  30. VBA input Box
  31. search a workbook, regardless of No of sheets and then run a comparision b
  32. Not enough system resources
  33. Copying formula into specific cells
  34. macro to dynamically add rows
  35. subs to translate a series of hex numbers
  36. Dynamic population of data validation field range
  37. VBA Schools
  38. Code to delete all rows that have 0
  39. Calculating Unrealised P&L
  40. Pivot Table Autofilters Not Clearing On Refresh
  41. Macro to filter every tab from a user entered date range
  42. Modify ODBC Output field for Use in Another Prog
  43. Procedure too Large !!!
  44. removing rows
  45. Loop macro through a list of workbooks
  46. Inserting a formula into a range of cells using VBA
  47. Delete external links but keep formula in cell
  48. Function that returns an array
  49. not having a macro open the worksheet in which it was written
  50. clear a dashed line
  51. Subscript out of range
  52. Code Vs Formula
  53. different Column visible & invisble
  54. select paste
  55. CheckBox
  56. Pulling the last number from a column of
  57. Duplicate entries on userforms
  58. Create a list of duplicated numbers in a worksheet
  59. Display Workbook Path and Name in a cell
  60. Updating cells
  61. Worksheet_change with editable result
  62. Reformat Name Column
  63. comparing data from 2 ws coping to third
  64. Linking Option Buttons
  65. VBA code for dynamic name range
  66. Check cells for contents
  67. command to close word
  68. Form w/ Radio Buttons
  69. No update links when open
  70. loop issue
  71. Button and Hyperlink
  72. Checkbox
  73. Msgbox to test for valid entry B-4 continuing
  74. Copy paste Text Box
  75. Modify Imported Data in Spreadsheet
  76. Event Type
  77. Question about pictures in commandbuttons
  78. Enter name & row fills with data
  79. Excel Model to Web-based (Flash) Deliverable
  80. No save and close
  81. Search, Find and Change
  82. How to use a variable to set a charts name and data range??
  83. Collection vs Dictionary
  84. Fill 10 comboboxes with a loop
  85. Fill row with different colors
  86. Optionbutton
  87. goto column in same row
  88. Command button to email the current spreadsheet
  89. Scrolling Text
  90. Comparing 2 tables
  91. Date Formatting Problems in VBA
  92. DataGrid
  93. Programmitcally Selecting a Drop-Down
  94. Update Chart table programmatically
  95. Combo Box doesn't drop down when chart in other pane is selected
  96. Combo Box
  97. Macro to match lines
  98. .csv files to .xls workbook worksheets
  99. MSN Stock Quote Add-In
  100. Read a named range into an array
  101. Dynamic Data Update
  102. How do I insert cells at certain parts of rows
  103. Formatting text in a Macro
  104. adding a loop to my code to get more data
  105. Hide/Unhide a button using a macro
  106. Excel Posting & Gathering Information From MS Exchange
  107. Macro That Filters by Currently Selected Cell
  108. Code to open a Access file from excel?
  109. Updating Cells using VBA
  110. INSTR for a case statement
  111. Querying Worksheet Data using Macro
  112. Net send command via excel
  113. Creating a pivot table in VBA
  114. Running a dos command in VBA
  115. Convert Word file to Excel database
  116. &color - How to specify the hexidecimal value
  117. Unknown code
  118. Listbox Nothing Selected
  119. Looking for any value in 4 different cells simultaneously
  120. DDE Live Data for stock quotes (cell reference concatenate)
  121. I'm looking for some tutorials
  122. VB application behind Lable Click on Worksheet
  123. Copy from sheet to sheet Vlookup???
  124. if Index
  125. Cell List Search
  126. Auto insert of columns
  127. Combining Customers data into a final worksheet using MACRO
  128. Creating formula through macro...
  129. adding a range in a cell via if loop?
  130. Macro to compare text
  131. Converting an HTML Table to Excel Rows / Columns
  132. Open sheets at specific cell
  133. SumIf
  134. Mode function using variable range
  135. Check if sheet exists problem
  136. Multiple conditional formats and priorities
  137. Trial Version Counter
  138. Left function
  139. macro for multiple tabs from a data set
  140. Copy Data from File A to File B
  141. Executing a stored procedure in ORACLE from an EXCEL Macro thru ODBC.
  142. RGB colors from object ?
  143. Flag changes highlighted in coloured text
  144. Save As Macro
  145. Intermittent problem with Macro
  146. File saved history log
  147. Select certain columns based on date
  148. Open a folder location with VBA?
  149. Using VBA to construct XML and call an application
  150. selection.end(x1Down) feature
  151. sorting data Macro...
  152. Headers and footers on all sheets except the 1st sheet
  153. Load image into word bookmark - or another solution?
  154. Advice on Shared workbook
  155. Edit Form in excel
  156. Adding new sheet with User Input
  157. Sumif problem with four rows of data
  158. 'Active' Cells Issue When Running Macro
  159. Add a column and Update formulas
  160. Finding Last Row through a macro
  161. Word Frequency Code
  162. Open New Instance Of Excel With Named File
  163. Coding colors
  164. copy(or cut)/paste from column to row
  165. Change date to word "present" change to red
  166. Filtering data
  167. making show + numbers only
  168. Changing the text colour on a button
  169. copy formula from previos cell to next cell when i enter something
  170. color range in VBA
  171. Get index of a button added to worksheet
  172. Splash Screen Fadeout Time
  173. referencing shapes
  174. Number combinations
  175. Macro to move data into a seperate worksheet in order
  176. Prevent Pop-ups in Macro
  177. Advance Code or macro
  178. Dates as Numbers in Combo Box
  179. Sorting a list
  180. Macro Tidy
  181. Unable to Display a Userform from an ActiveX Control
  182. Populate current date when data changes within a row
  183. Msgbox format the size
  184. how to delete indivudal cells
  185. Formula Functions
  186. Auto format on worksheet open
  187. ScreenUpdating dilemma
  188. Open mail merged doc from VBA not working
  189. Wrap Text in a Cell
  190. Hide everything except the sheet?
  191. Trying to pull off a custom address mail merge process!
  192. copy and paste problem
  193. Count over 5 rows from active cell?
  194. Overwriting the old value in column C with the new value.
  195. Runtime error '91'
  196. using vlookup with vba difficulty
  197. undoing alt-enter
  198. Vlookup with VBA
  199. hide ranges as per list selection?
  200. If Index
  201. Error Trapping
  202. Unreliable macro to create pivot table
  203. Picture for background
  204. Delete code after macro has run
  205. How to remove dotted lines around option buttons?
  206. Macro sheet naming and referencing
  207. locking the VB window of a sheet
  208. Find and combine duplicate rows
  209. Thanks for the help
  210. Excel to Word Save
  211. Add 2nd Condition to rngFound
  212. hide rows before printing
  213. Making the cancel on an inputbox work
  214. Automatic formatting
  215. program status is blank
  216. Copy / Paste macro simplification
  217. Select a column using the number from a input box?
  218. Compile Error
  219. Mail sheet(s) to one or more people using VBA in Microsoft Excel
  220. CountA - Dynamic Range - Macro
  221. macro to open out pivot table results?
  222. Data sorting question
  223. export worksheets to Word (Vista)
  224. updating VB code
  225. similar text matching in vlookup
  226. Efficient way to filter and delete junk records
  227. eliminate message on workbook close
  228. Cells.Find Specifics
  229. Excel ListBox strange behaviour
  230. combobox - lock text
  231. Calculate number of business days excluding weekends and holidays?
  232. images show based of file names for adjucent cells
  233. Anagram Code
  234. convert excel to .xml
  235. Excel undo stack
  236. array function
  237. Excel 97 Memory Leak
  238. determine if a cell is empty
  239. How to search/filter data in Excel dropdown having large number of values
  240. Save A Cell Location
  241. Creating VBA ranges in code
  242. select occupied cells in range
  243. Userforms remembering values
  244. Formatting number
  245. Drop_Down list box (Programmig?)
  246. Correct naming of sorted data
  247. reading text from a webpage using VBA
  248. automatic graph creation
  249. does sorting based on a large filter list require a macro?
  250. Menus from macros using Excel 2003_Is it Possible?