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. copy sheets from closed workbook
  2. [SOLVED] File browsing in macro - how to change default start location?
  3. [SOLVED] Excell Cell referencing problem
  4. [SOLVED] delete whole column if 1:20 contains any one of 5 pieces of text
  5. [SOLVED] Conditional Formatting VBA issue
  6. Compile Error with a Userform
  7. link a checkbox to a conditional formattted cell
  8. Is this possible?
  9. Scenario summary as loop
  10. Changing button colours in VB
  11. Transfering data
  12. Forcing cells
  13. Chart with VBA data not shown properly
  14. Find Text on Web
  15. Auto open and close seperate workbook when current one is closed
  16. Compare names and higlight on second sheet
  17. Compare name in one list then
  18. Auto change drive letter
  19. How to delete the Excel icon?
  20. Call same code from multiple controls
  21. Button to add text and the end of doc
  22. After copying in Macro - come back to previous sheet
  23. Formula to Delete a Row
  24. Hiding Rows under the influence of multiple values.
  25. Hide Rows
  26. Automatically save excel worksheet in csv formate after 5 minute intervals
  27. [SOLVED] Delete duplicate and merge data in one row
  28. How to auto-protect a spreadsheet when opening
  29. Show Data Using Multiple Options
  30. Tax Calculator
  31. Linking VBA to a cell
  32. Active Input Box (Click Tab)
  33. Any Way to Unprotect worksheet to see macro code
  34. [SOLVED] Named Columns being movable without affecting VBA/Macro/Userform
  35. Using SQL or saved queries to retrieve data from db's?
  36. Can VBA Auto-select a choice from a dialog box?
  37. File Not Found in correct directory, but able to read file name
  38. Copy the value of the previous cell to another cell
  39. make UDF to open files
  40. Assigning one column of results to three equal
  41. One macro for multiple buttons
  42. Custom VBA function doesn't work
  43. Exporting values from a range to another sheet
  44. Select Highlight Copy
  45. validating the active cell of created drop down calender
  46. [SOLVED] Commenting code
  47. Hiding unwanted row fields from Pivot Table
  48. Advice on how to Start in VBA from Basic user to Advanced User
  49. vba code to save in excel raw
  50. UserForm to copy Worksheets
  51. Consolidating sheets from different files.
  52. Return index of value in array
  53. Corrupted Search Input
  54. [SOLVED] Spell check - VBA vs. Manual
  55. Creating Quotes
  56. Creating summary of list ( 5 days watchbill)
  57. function that will update worksheet names
  58. Excel to outlook
  59. Hiding Rows with Zero(Multiple Columns)
  60. Can I stop my Auto_Open macro from running?
  61. Spiliting one cell value into multiple cells
  62. Using the RefersTo property in a Range
  63. [SOLVED] Always open to top left corner
  64. Modify a text file (.txt)
  65. Making a match funtion with VBA
  66. Project Macro
  67. [SOLVED] Looping data entry macro
  68. Using String Value as ActiveX Object Name
  69. want to filter the data with 2 criterios.
  70. Subtracting Dates/Times
  71. Writing Function using vlookup
  72. [SOLVED] Clear command button
  73. Delete rows
  74. copying from one worksheet to another no longer working
  75. Copy Cells Matching ID from Diff. Column?
  76. [SOLVED] Stop timed macro on close
  77. Please write myself and other users a simple macro
  78. Stopping Macro from executing on all worksheets
  79. EXCEL 2007 - VBA addin: Set CurrentPageName of Pivottables in vba?!
  80. Using escape to exit manual calc iterations
  81. Find & Replace Macro
  82. Compressing List
  83. cut and Paste formulae from another sheet into column where row 4="Stat"
  84. Search multiple sheets
  85. Dynamic Image based on Cell Selection
  86. How to check cell isnt blank upon saving or closing
  87. Add series to Chart
  88. Run macro on multiple sheets at once, not one after another
  89. Rnd function
  90. mark Excel title bar for dirty documents
  91. [SOLVED] copying qualified data between worksheets
  92. Filtering Sheet based on criteria - removing duplicates
  93. [SOLVED] Emailing form excel
  94. sort cells by font color
  95. Help with 1 line of code:
  96. Horizontal Conditional Format
  97. How to kow the position of third comma in a cell
  98. Problems with offset function in VB
  99. White pages API
  100. [SOLVED] using macros for custom filter Giving 'Or" criteria and paste the data in sheet2
  101. File Contents Into Formula- How To Do It???
  102. Form controls vs. ActiveX controls
  103. Inserting indicator column into spreadsheet
  104. Use to Form to Hide Rows
  105. [SOLVED] VBA inputbox
  106. Import Text File Quicker
  107. New Sheet Inserting Before Template
  108. navigating through a filtered list
  109. Retrive information from one excel document and create a new document from form
  110. Vlookup loop
  111. How to stop the for loop?
  112. create macro to delete row with a date previous to current date
  113. Find all possible combinations of letters
  114. Relative path to Parent directory
  115. insert header value into formula
  116. [SOLVED] copying text from 1 text box to another
  117. Update Several Modules At Same Time???
  118. triggering any auto email
  119. Make List Box Interactive
  120. Automated Barcode & Data Input
  121. Getting data from a sheet without opening it
  122. Store radio button caption
  123. Adding a checkbox to a custom toolbar.
  124. Saving files as Date in another folder
  125. Copying data worksheet to worksheet
  126. CSV file not showing the db results properly
  127. getting data from many sheets into one
  128. Automatically Copy from one sheet to another
  129. Copying Charts from Excel to Word
  130. Excel to Outlook Link
  131. Use option button value to set custom view when closing
  132. Basic file save question
  133. Bug/compile error when referring to custom worksheet property. Excel 2002.
  134. Message Box Display A List
  135. How to change the Cell
  136. Macro in module not woking for all sheets
  137. Deleting Duplicates
  138. Autofill a column (Bottom up) while another column is non blank
  139. Excel Program to Open Pdf and Count Page Numbers
  140. Reduce Macro Time
  141. Automate email
  142. Closing Another Workbook With VBA
  143. Change date format when exporting Excel to Access
  144. search in multiple cells and sheets
  145. '1' for cells matching criteria, '0' otherwise
  146. Show image with text when a excel file opens.
  147. Using ComboBox to call another function
  148. PDF worksheets
  149. Adding Code to a Remote User's Personal Workbook
  150. Embed (View) Spreadsheet in VBA Form - Excel 2007
  151. positions changed from week before
  152. How to position a button correctly when a new row is inserted
  153. VBA to filter multiple sheets
  154. How to create a delay in VBA macro
  155. Current function is at the top of the stack
  156. Know if user has made changes to input sheet since last VBA calc
  157. webdata refresh
  158. Dividing Data in one column to three columns
  159. Writing Excel/VBA app in 2002 for use in 2003? Am I missing out?
  160. Change criteria in database query
  161. Count Unique within Group
  162. Adding lines, for loop, if statement question
  163. Finding my Range
  164. Open and Print excel file within another excel file
  165. If Statement (put 'IF formula' in cells)
  166. Help w/ macro and dynamic rows
  167. copy data of varying size to end of table
  168. New Sheet Autofilter Copy
  169. Modifying Macro
  170. [SOLVED] writing a macro to hide rows
  171. automatic email based on criteria
  172. Display Comments when mouse pass over a button
  173. Prevented paste button!
  174. How to read data from txt file to an array?
  175. VBA code to set pivot table row field in "next available" spot
  176. How to Use CELLS,RANGE,SELECT,SELECTION & OTHER BASIC EXCEL OBJECTS IN EXCEL VBA
  177. Toolbar buttons that only appear for a specific workbook.
  178. Excel Opens a PDF File
  179. Copy Formulas in last Row to New Last Row
  180. [SOLVED] a macro that uses a variable serial number
  181. How to use 'Column' name in VBA functions
  182. Append cell to previous row
  183. KeyPress in VBA
  184. Restrict Scroll Area to Visible Area
  185. Copy & Paste Special help
  186. Copy a variable number of rows
  187. [SOLVED] Days, hours, minutes and seconds
  188. Open pdf file selected from excel
  189. Set 10 cells to different random numbers
  190. Duplicating Data on a different sheet
  191. Automatically add new worksheet
  192. How to Reset a Spreadsheet with a macro
  193. Setting password to pdf through VB Macro
  194. Preview of other worksheet on same workbook
  195. Help required to change format when converted from excel to xml.
  196. Displaying Duplicates
  197. Number multipliers
  198. [SOLVED] How can I pop up a msg box when the computed sum exceeds certain value
  199. Macros Doesn't Work in Remote...
  200. Dynamic Field Name when Import into Access
  201. Filtering Dates (need all dates within the next 30 days)
  202. Copy data from worksheets to index list
  203. Excel-Sharepoint Authentication
  204. Merging Filtered data on another worksheet?? please help ^^
  205. Using Excel to create e-mail for Outlook Express
  206. Display variable cell value in Text Box
  207. Creating a Sharpe Ratio function using VBA
  208. VBA to remove all sub-totals in Pivot Table Fields
  209. Deleting Duplicate Rows???
  210. Populate Chart with Datasets
  211. Emailing an attachment where the subject = data in cells
  212. Custom Function w. 2 condition
  213. Randomize entries on spreadsheet
  214. macro - filter out every opportunity who doesn't have a placement
  215. Message box without required user action?
  216. [SOLVED] Opening a Powerpoint file from Excel
  217. tip of the day generator
  218. xla file
  219. Running two version of Excel
  220. Macros in Personal workbook
  221. Ending the macro when it reaches an empty row at the bottom of the column
  222. Copy cells from one workbook to the other
  223. Using Classes In Multiple Projects
  224. Check the value decimal
  225. Protect with VBA on top of regular protection.
  226. Solver + Loop
  227. How to insert criteria into the FILE-PROPERTIES box from cells in a workbook?
  228. How to Check all the rows and add to the end!
  229. [SOLVED] VBA code to email selected items
  230. How to save HTML source code from VBA?
  231. Added a button to insert a row, the code succeeding that is not working
  232. Display Week Dates based on a given Date
  233. Finding all dates in a column that are in the range today to a week from now
  234. Selecting a single column of a multi-dimensional array
  235. VBA to Create New Sheet
  236. Creating an Excel Worksheet
  237. [SOLVED] Copy & Select All command Buttons
  238. Search codes based on time range
  239. Ending application on time macro
  240. Search files in folder based on search string
  241. User form to display adjacent cell value and move to next blank cell
  242. Comments in VBA
  243. Code Inserts but Search Fails using Excel 2007
  244. Delete row of checked checkbox
  245. Place a File Path and File as a Variable
  246. using macro to sort 100 000 rows
  247. Delete a character in every cell
  248. Removing horizontal scrollbar in ComboBox
  249. Moving data from one sheet to another using a combobox
  250. Use Array for Find/Replace