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. Print All Sheets Except 1
  2. Pivot Table Items
  3. Adding a column in 5000 excel file at a time
  4. Functions / Macros - Array question
  5. Delete all given values gives wrong select?
  6. Copy columns does not work?
  7. Userform Radio Buttons
  8. Message Box
  9. How to calculate moving averages with a complicated requirement
  10. How to use userform as information window
  11. Macro insert from 2 cells to one.
  12. Copying macro
  13. Making few cells uineditable using VBA
  14. hightlight question
  15. Selecting row number in loop
  16. How to split first and last name in macro
  17. Excel dislikes February, 2002 or the second day...
  18. looping over combobox names
  19. wierd userform question
  20. Querying Access from Excel Using VBA
  21. When Sheet is Unshared
  22. Searching an entire column for all the values existing in a nother column
  23. Marcro to open text file
  24. Copying values on update
  25. Hide Zero rows
  26. Create a Looping macro which copies and inserts rows
  27. Updating stock with macro
  28. Looking for a macro that copies a formula from column to column as I change the month
  29. Making a Excel File Demo Version
  30. designing a tape measure
  31. Creating Button to duplicate cells
  32. code to list page breaks
  33. copy value if cells match
  34. Paste contents of a random cell to a callout
  35. Creating a hyperlink with a macro
  36. macro buttons
  37. Macro Code In A Different Color
  38. Code to List all worksheet names (tab names)
  39. Inserting Date and copy to other worksheets
  40. Show cell value(text) in comment box text, or mouse tool tip on an gif icon
  41. Simple Problem - Type Mismatch
  42. cell selection in a given column range ?
  43. Automatic deletion of rows and a formula question
  44. tall calculation
  45. Making the Tools>Options...Calculation "Manua"l Vs "Automatic" a Button.
  46. what is value of intCounter with this code?
  47. cmdbutton and subprocedure in message box
  48. Hiding macro passwords??
  49. understanding code .cells().resize() ect.
  50. Pausing macro until .xla function completes
  51. Inserting a picture, keeping sheet protected
  52. Hyperlink sheets dropdown list
  53. worksheets("sheet1").range
  54. drop down menu result calls macro
  55. Use Macro instead of Vlookup Function
  56. getting a macro to effect all columns
  57. VBA optimization of code
  58. ActiveChart.Name wont work.....
  59. counting rows
  60. insert worksheet in all workbooks in folder
  61. Microsoft Query-Chg parameters using VBA
  62. Cleaning up an imported txt file
  63. code use to convert pdf to word and excel
  64. Plotting a graph using Macro
  65. Get just file name from file path
  66. Date format mask
  67. exporting to word
  68. Code to add blank timesheet
  69. form to update links
  70. Displaying data in a custom built user form
  71. VBA- Can I change Header after a manual pagebreak?
  72. Summary table not using pivot table
  73. Range(selection.......formula
  74. Open function View only or reasd only
  75. Scenario Analysis
  76. Email CDO
  77. Getting data from Webpage onto Excel worksheet
  78. Another UserForm activation issue
  79. Copy hyperlink from one workbook based off user defined selection on another.
  80. Userform Search and Delete data
  81. Using VB code to graph data
  82. Separating Area Codes
  83. Chart Ticklabel Orientation question
  84. Fill formula with code
  85. Macro Protection?
  86. Hide Row if Column B=0
  87. Showing object size in a cell
  88. add simple hyperlink
  89. Putting Words into Excel using VBA
  90. import excel module
  91. Searching Excel Sheets
  92. Match and Not Match report
  93. Importing Data From A Closed Workbook
  94. Validating Date with While
  95. reading excel files
  96. Program to Get Price from Web
  97. Adding a scroll Bar to a worksheet
  98. Link data between Report Sheet and Form Sheet
  99. Opening File
  100. Save As cell format problem
  101. Maximize Excel
  102. ActiveChart.SeriesCollection(1).Name = "=Sheet1!R15C11"--error
  103. Open file/folder dialog box
  104. take same number from Sheet1 colum A:A and Sheet2 colum A:A
  105. Copy data from one location to another
  106. Open workbook macro
  107. Query a table and return results into my Excel Form
  108. Hyperlink and IF combined
  109. Message name does not exsit in list
  110. Quick Question about references
  111. Creating a log in screen with user name and password
  112. Delete rows in worksheet1 which are not listed in worksheet2
  113. error 91 with selection
  114. Comparing Quantity between worksheets
  115. openin csv file in excel
  116. Custom Properties/Auto Linking
  117. Copy/paste loop
  118. Copying macro coding across many workbooks
  119. class structures
  120. validating excel data against a mysql db?
  121. Rounding time to nearest 5 minutes Macro
  122. Calculating Percentage of Attainment/Active
  123. updating links in command
  124. ActiveCell.Formula incorrect value
  125. Print cells with data populated
  126. Code - how to switch from one worsheet to another
  127. Programming multiple filter conditions with autofilter
  128. Code for data sorting
  129. running an event macro when selecting a certain sheet
  130. Assign activesheet name to string variable?
  131. Warning dialog box
  132. Cell Format not working within Text
  133. Unhiding Multiple Sheets
  134. Converting Text String to Date Format
  135. Concatenated sorting
  136. compare values and copy new values to clipboard
  137. expanding size ranges to known increments
  138. Empty cells with criteria
  139. Condional Formatting
  140. Code to search PDF file
  141. ActiveSheet.ChartObjects ("MyChart")-- error
  142. Cell data and file name
  143. select a range
  144. Code to save file
  145. 'macro's are dissabled' pop-up although al macro's in the workbook have been removed
  146. Separate Data list into sections
  147. Password to protect page on Multipage userform
  148. Absolute references
  149. sort by custom list macro
  150. Buttons to add lines
  151. Creating a budgeting price list/menu
  152. Calculating Markup For Retail Price
  153. Print preview causes my app to stall
  154. Understand code
  155. Loop issue
  156. delete Row when specific value is inserted in a cell
  157. Macro to hide rows and columns depending on the values of different ranges
  158. moving duplicate shape
  159. Abbreviating path displayed in textbox
  160. Question about condition format
  161. Re-running code based off the updating of a cell
  162. Transfer figures from workbook to master
  163. How to identify which macro a button is using?
  164. Amend Code - Hyperlink Delete
  165. Loop Program to Copy/Paste from One Sheet to Another
  166. Capture data
  167. disable warning boxes
  168. Using data from different module
  169. Assigning Exchange stores in AD
  170. Sorting problems caused by macro
  171. Insert Row Macro
  172. GetOpenFilename, .xls And .txt
  173. Beginner at macro needs help
  174. Combobox on Userform Restrictions
  175. Text as Date
  176. Defined Name area has disappeared but works!
  177. Re: Macro to split cells into inserted new row...
  178. Printing multiple worksheet with one button
  179. How to Interchange two Columns? How to speed up an existing macro?
  180. Merge Rows into Columns with more than one variable
  181. OpenTextFile error
  182. Create a new workbook with a selected title.
  183. Check Number of Files in Directory
  184. Count the number of users who use the worksheet
  185. Excel change directory/file open macro
  186. MS Query
  187. VBA: Highlight Duplicate Entries Within a Group
  188. Duplicate Defined Names ?
  189. Function that will pull the unique values out of a column?
  190. disallow changing the active workbook
  191. Problem getting the macro to loop
  192. How to change the value of a cell based on value in some other cell
  193. Creating cmdbuttons
  194. wanting ROWRSOURCE to use cell format
  195. Auto Email
  196. Macro to loop through all sheets
  197. Macro to Sort Active Sheet and Set Page Breaks on Columns?
  198. Program 25+ checkboxes
  199. Use Vlookup to change cells?
  200. Import XML into Sheet1
  201. *Accounting system*
  202. copying cell values to specific area in sheet
  203. hyperlink from folder - problem
  204. Carrying the same text format to another cell
  205. Creating Input Box within a Macro
  206. How to merge two worksheets?
  207. VBA: Finding row to start at
  208. Web page content to transfer in Excel
  209. Formatting Macro
  210. Function to Find and Return an Image
  211. How to specify non-default date format for a textbox
  212. Finding and copying data from one sheet to another
  213. Using Macro on Multiple Workbooks
  214. Conditional locking of a cell??
  215. Find File Create Date and Time
  216. force macros to be active on file open event
  217. Excel 2007 ribbon and data exchange with vba
  218. Omit right upper corner X
  219. Convert Array formula to VBA to speed up worksheet
  220. Assigning VB code to graphic
  221. pivot tables - set up one pivot cache, and then create tables
  222. Input box - trouble with converting to date
  223. how to stop workbook events during macros?
  224. how to run macros using set variable
  225. Generating a series of hyperlinks?
  226. For each next logic. How to end?
  227. Using strings as arguments in a range reference
  228. Auto adding a date and replicating rows of input
  229. Running Macro to copy Rows of Formulas
  230. File Open Dialog Box Open at Set Folder
  231. filling a form combobox
  232. merge multiple same-format Outlook files into one Excel spreadsheet?
  233. CommandBarComboBox : AddItem - procedure to attach routine. in excel.programming
  234. Filling in a cell based on Checkbox true/false
  235. protecting userform
  236. vba- how pass a range into the function ?
  237. Import & Export Excel as XML
  238. Multiple charts over multiple sets of data over multiple worksheets.
  239. Search and paste unique values
  240. date on the userform
  241. find error in my Validate-function (that validates a textbox)
  242. match not being found, when it is there
  243. Search & Delete Data
  244. Quicker VBA
  245. Inserting a number of rows from cell value
  246. subroutine modification and testing
  247. Copy from IE & Paste to excel
  248. Close previously opened worksheet
  249. macro for matching date and changing cell color and merging like cells
  250. Always open workbook to default sheet and cell