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. macro script to collect pivot data
  2. Macro to Remove "Seconds" From Timestamp
  3. jump to the next row with macro
  4. Adding Time
  5. Macro to copy cell comments to a new cell?
  6. Finding the column End and naming that
  7. Macro with UserForm
  8. Copy to Another Tab
  9. Slow Down A Script
  10. Thanks Again!!
  11. Combobox.dropdown question
  12. Deleting Rows NOT EQUAL to multiple criterion
  13. What is VBA code to find end of row?
  14. Extracting a value from a cell
  15. pivot table within macro
  16. Help with data validation and autofit
  17. Dates VBA Problem
  18. Macro Difficulties
  19. Format Colour of Row based on Value In Cell J
  20. Change font color of Application.StatusBar
  21. add row
  22. make new page and transfer totals
  23. Search button
  24. Progress Bar
  25. Help needed in pulling info across from several Word docs
  26. calling a url from macro
  27. Activate a column of hyperlinks using a macro
  28. How do you make a form
  29. Need solution to overrite and add sheet name to row
  30. VB challenge
  31. How to create Advanced Search Criteria
  32. Multiple Checkboxes and VB - help please
  33. Macro to Split Text Contained in a Single Cell
  34. Macro to work on any cell?
  35. Data to be ranked Groupwise and then TOP 5 of Each Group to be pasted in other sheet.
  36. Set series formula with names gives 1004 error
  37. selected cell value to appear in another specified cell
  38. match and find cell contents on another worksheet
  39. Creating Find Tool for Directory
  40. moving formuals
  41. filter certain cells within a Subsecion
  42. Step function in "for" loop
  43. Formatting Form Buttons
  44. copying and pasting ranges
  45. Execute code via curser position?
  46. auto shapes : lines
  47. Issues with conditional message box
  48. Having trouble accessing PERSONAL.XLS.
  49. Input Parameter to set a limit
  50. Advanced search criteria using Find and FindNext
  51. copy multiple cells using dorpdown list
  52. Searching and Sorting a list of data (numbers and letters) in excel
  53. Accounting Help Total Sum Finder
  54. How to copy rows by row number?
  55. Populate combo box
  56. Conditional Message Box
  57. Add data to range using MsgBox
  58. summarizing data from multiple workbooks into one workbook
  59. controlled cell formatting
  60. Copying data between sheets & add timestamp
  61. Copy data from excel into a web page
  62. Use a command button to activate a hyperlink
  63. search directory, list files containing certain txt
  64. UnHide Sheets in Order
  65. Help with sumproduct, I think?
  66. Excel 2000 vs Excel 2003
  67. Clear cell contents by text
  68. Copying Specific Data To Another Sheet
  69. Templet Macro
  70. Difference between "Office.Interop" and "Office.Tools"
  71. Code for "not to save"
  72. calculate selection
  73. Saving sheet
  74. Vlookup for all the values by Adding rows
  75. ActiveWorkbook.SaveAs
  76. Bold Macro
  77. [C#] Why does Range.Group() method crash after 7 calls?
  78. Prevent a macro being run twice in one day!
  79. Generate Sum of cells on Mouse select!
  80. To change the icon of repeat edit menu option
  81. userform with frame and option buttons
  82. contrast 2 columns to give a new column
  83. Please help necessary
  84. Activating Workbook
  85. Pivot Table Layout Screen
  86. Selecting multiple columns
  87. Excel VBA
  88. Picture Properties VBA
  89. Macro VBA for find, copy and replace
  90. Slow workbook response until code break & reset
  91. Copy values between work sheets
  92. Code to take me directly to a specified worksheet??
  93. Code to work with two open workbooks
  94. WorksheetFunction
  95. Interaction between macros
  96. Macro to average specific times during a month
  97. Macro for Text to columns
  98. Lookup and copy
  99. Searching for a string value in a column, and then creating a Sheet with that value
  100. tip for speeding up this simple soubroutine
  101. Remove cell fill option
  102. Activeworkbook.saveas question
  103. code to remove subtotals from pivot table
  104. Parameter Queryusing Dates
  105. Using Goal Seek in Macro to automatically change a cell value in multiple columns
  106. Automatically Add Comments
  107. Macro to replace Fill Series
  108. Input Box Valdation
  109. Calling Wrong Workbook
  110. countif in userforms
  111. Hiding Only Select sheets
  112. Compare user input with range (with an if statement)
  113. Macro to help sort date - times and average similar times.
  114. inserting formula through VBA
  115. Macro Experts Please Help A Destitute Man!
  116. Macro to total multiple data...
  117. Clearing drop-down menus with a macro
  118. Covert Space Delimited string to array
  119. Inserting rows whilst executing a “For” loop
  120. [[2003] From specific sheet range into listbox items?
  121. Help with IF and VLOOKUP Combo
  122. Pivot Table Macro
  123. Excel 2007 Macro
  124. How to find duplicates in a list of data?
  125. How to change values in one column based upon values in another column
  126. mark data repeated in consecutive cell in a column
  127. copy some data to different workbook
  128. ARRAY in visual basic
  129. Cell click Event
  130. Common Dialog Box doesn't show up
  131. Consolidating sheets w/o calculating?
  132. For loop with Textbox in userform
  133. Make A Script Repeat
  134. VBA Macro not working when workbook is protected
  135. Data validation - when copied & pasted validation overlooked.
  136. Unwanted Macro Breaks
  137. Create average in Macro
  138. Inserting Loop In Code
  139. Activate different workbook
  140. Searching for a string value in a column, and then creating a Sheet for that value
  141. Clear Contents of "Blank" Rows
  142. Looping Calculated Data and Pasting to Another Location
  143. Inserting loop in code
  144. Auto shapes : areas
  145. Complicated macro to copy and sort data
  146. Excel2000 macro doesn't work in Excel2003
  147. Trendline Direction
  148. A question regarding
  149. Have a new copy of excel open a new file
  150. Copy random row's to another sheet.
  151. RPC Disconnected error after changin file access in Office 2007
  152. How to create user form that displays values from cells
  153. Highlighting Specfic Cells
  154. Custom botton and userform
  155. Populate cell with user name
  156. Problem with macro
  157. upper to lower case
  158. search and highlighting
  159. command button that changes colour of selected cells
  160. DoEvents not working
  161. Lost "properties" window.How can it be recovered?
  162. Populate Data Correctly When Cell Changes
  163. Stopping automatic calculation then restarting
  164. Automated entry in one field to change values in another instead of manual entry
  165. macro to run after paste?
  166. To Open excel in the Selected Sheet
  167. First Letter in a Range runs a Macro
  168. Getting a string from a col
  169. Unprotecting multiple passworded sheets
  170. sequentially number multiple copies of the same page
  171. Can I assign a macro to a cell?
  172. If Statement To Check Pivot Table
  173. How to adress columns
  174. Pasting ONLY values from AutoFilter
  175. Buttons Needed To Insert Symbols
  176. Searching for a string in a cell, and then creating a Sheet for that string
  177. Deleting multiple rows of data
  178. Muliple tabs, summarized on 1 tab.
  179. Create a Toolbar of Macros through Add-in///
  180. VBA - VLookup on different sheet
  181. Pivot Table VBA - Data Field - Original (source) field name
  182. Consolidating data from other sheets
  183. If statement issue
  184. Code not copying and pasting data - basic error?
  185. Advanced Filter - Blank Rows
  186. Add text to multiple range of cells
  187. How to move or copy worksheet from one xls to another.
  188. Shutdown Macro
  189. retrieve value from one sheet to another using Multiple criteria
  190. Messages box as warning for changes withing a range
  191. List of files into Combo - Dir(path) function
  192. Find command at workbook opening
  193. Loading from another excel file
  194. How to make button in user form call a module
  195. Macro for opening an external Batch file and closing the same at regular intervals.
  196. Change the colour of a row if a cell contains a specific value
  197. Naming a Column
  198. pair up data from consecutive cells in a column
  199. Assign macro to external device???
  200. open certain rows when row clicked
  201. Help with Rounding
  202. comments read/write speed
  203. Create a daily calendar for 1698 - 1900
  204. How to select empty cells in a column?
  205. Naming a sheet
  206. Command button to find a cell with a specific value in it
  207. Loop macro to delete and copy text
  208. If anything in col B>1 then move that row.
  209. Find Top 10 or 5 from a list (with conditions)
  210. Dynamic Worksheet Name
  211. Macro to Filter Data
  212. merging cells gives error---urgent
  213. Closing Workbook After Macro Completed
  214. CheckBox update slow
  215. Macro to access/edit/save a text file
  216. certain row amount print area
  217. Find 1st cell with numeral, then offset.
  218. "IF" sheet is protected with password
  219. scan down, create new sheet, copy,paste
  220. Match and align cells
  221. Macro to Open File & Copy Data
  222. Loop through workbooks copy sheet to master
  223. excel functions similar/the same as VBA functions
  224. Problem with the character '
  225. Selecting multiple ranges
  226. number as value instead of date
  227. how to detect a user <cr> into vba?
  228. Making Packing Slips With Excel Data
  229. Delete a row if a cell contains a specific value
  230. Calling Routine by Variable Name
  231. Macro "IF" to insert a row.
  232. Returning worksheet "Home"
  233. Condensing similiar rows into one row
  234. macro to transpose col A every 4 rows to Col B,C etc
  235. How to set directory for workbook automatically?
  236. pasting data using Excel 2007
  237. macro to attain information about cell input
  238. macro to shrink text when too much info in one cell
  239. Protect/Lock specific cells independently through button
  240. Problem with RunAutoMacro running more than once
  241. Closing/Re-sizing userform by selecting a sheet tab
  242. Macro to Click on Popup message option "Delete"
  243. Incredibly Cumbersome Code!
  244. Reference another xls file
  245. Select Printer Macro
  246. How to save data with button
  247. manipulating text files before importing
  248. Preparation of Engagement sheet
  249. Parse Excel worksheet by font size?
  250. merging data from two columns into one