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. Change Event to change Font to bold and colour Index
  2. pull data from url
  3. Macro Code that adjusts each time it's run?
  4. Sum Row Macro
  5. How do I separate cell contents into 2 cells using a comma as the marker?
  6. Search and sum
  7. Assign menu action to userform button
  8. Repeat part of the macro
  9. Delete entire row based on criterias in range?
  10. Disable Manual Calc in Options
  11. Locate the word and autocomment
  12. Delete rows with the same entry in column A and I
  13. Dynamic variables
  14. VBA code to extract graph from a table
  15. Extract specific text in Cell A1 and display in A2
  16. Error Code 91 Object Variable or With Block variable Not Set
  17. Deleting brackets and numbers of varied length.
  18. textbox1 set focus
  19. vba popup message code
  20. a macro for deleting checkboxes
  21. Excel to Word Problem
  22. Change varchar to float b4 inserting into database
  23. Get macro to sort dates properly
  24. Convert string dates to proper numerical date format
  25. Moving/Deleting rows based on criteria
  26. Header for different data in rows
  27. Alternative for IF-Then-Else function
  28. Copy rows when column matches a user input from another workbook
  29. Auto Save & Disable/Enable CutCopyPaste MACROS - Make ineffective once file is closed
  30. Row, Col value off by one row
  31. turn a few columns into basic HTML.
  32. VBA - maximum and minimum extraction
  33. Setting listbox items selected
  34. Best Information on VBA Code for Excel
  35. Macro Question: Copy a word from a column to another automaticly
  36. Checking for User Form loaded
  37. Copy selection by colour to another workbook
  38. Bars in Gantt chart showing values of certain cells?
  39. VBA Searching
  40. search column and select rows
  41. "No more instances found"
  42. Pivot table-update the element in the array and stop other elements changing
  43. vlookup question
  44. variable color coding
  45. Hyperlinking and Naming Multiple PDFs
  46. Code To Go To Last Tab In Workbook
  47. Highlight based on two criteria
  48. PDF print file
  49. How to unlock specific cells when data is entered?
  50. combining routines
  51. Save "Dynamic" sheet in workbook If cell = . To another location
  52. Excel 2007 error when adding custom help file to user defined function
  53. Macro for a beginner making a mileage tracker
  54. [SOLVED] Pop-up mini-workbook...
  55. Delete shapes from active sheet cell range:Resolved
  56. Automatically Copy Data into Worksheet from Different Excel File
  57. Assign Multiple Macros to Drop Down List
  58. Figuring percentages
  59. VBA reference
  60. Keep code in template, do not transfer to new file
  61. ZeroPadding Mixed Number, Text, Number Content in Cell
  62. Enum type mismatch problem
  63. Macro Check Box Question
  64. Edit A Line to Include Variations
  65. macro/vba using address function paste values
  66. how to Ignore formula Error Checking?
  67. Ending a Sub if textbox is blank
  68. User forum, do nothing if blank entry
  69. Need an iterative cell entry and print for entire list of values.
  70. IF statements
  71. Avoid Run Time Error 9 When Closing Multiple Workbooks
  72. 'dynamic named ranges'
  73. Macro that takes existing data into consideration
  74. Defining letters as numbers
  75. make userform move with command button
  76. Extracting data from pivot table??
  77. VBA code to find a cell
  78. Deleting rows NOT containing defined values
  79. Pause macro, select file, continue macro
  80. problem to add items to an array
  81. Find & Replace (*) Symbol
  82. Run dos command with macro
  83. creating a calendar entry in outlook
  84. Saving clipboard when closing window
  85. Macro for removing specific colums
  86. Hyperlink to cell in different worksheet:indicating cell through integer variables?
  87. Passing a query URL string to email
  88. Open folder in Explorer
  89. modify code so that it runs on a different sheet
  90. Navigation Bar
  91. Problem with Combo Box
  92. Selfcert.exe
  93. save it as today's date and to a given directory
  94. Create a macro (module?) that activates in my userform code?
  95. Using Find to replace cells.
  96. Excel gives error when opening book
  97. Userform Textboxes showing wrong values?
  98. conditional formatting macro
  99. Is a Master list of unique records just a pipe dream?
  100. Deleting VBA Personal.XLS File
  101. Selecting/inserting columns with numbers
  102. Help with simple macro...
  103. Finding file names in a directory
  104. generate date ranges
  105. Using a macro to create hyperlinks
  106. Resolved: Using InputBox to add cell comment
  107. Automated e-mail from macro button in Excel
  108. Problem executing sub within a sub
  109. Point Macro to an .xla workbook
  110. Storing previous value in cell when data is changed
  111. Find doesn't work w/ merged cells
  112. Loop through worksheets
  113. Macro Error when File Name Changes
  114. autofilter various criteria:="=**"
  115. Only works for whole numbers !!
  116. PasteSpecial from Excel and Non-Excel
  117. Opening zipped Word document from Excel hyperlink
  118. userform: trasnferring textbox value to label field in next userform
  119. UserForm Retreval, Amend and Return
  120. Macros giving Run-time error '9' on all machines except mine
  121. Updating a range of values in a mySQL database
  122. Excel to access file on the internet and run macro if found
  123. exchanging Add-in's and related spreadsheets
  124. Need help on a way to sum
  125. My Dynamic Named Range brings up blank rows?!
  126. Copy formula x rows down based on counta
  127. Storing Record As String Macro
  128. InputBox to enter file
  129. combo box with reference name on the worksheet
  130. Hyperlink to a cell in different wsheet but in same workbook
  131. Using VBA to copy and paste the content of multiple worksheets to a new files
  132. Create PDFs Using Excel VBA?
  133. How to tick check box with macro?
  134. automate data entry by linking data
  135. Copy a range and paste into another workbook - files are password protected.
  136. Excel macros slow in Vista
  137. Need to condense code
  138. Multiple Timestamps
  139. repeating macro wont let me close workbook
  140. Unable to paste from w/book to w/book
  141. Execute code from the Worksheet_Change event
  142. How to Highlighting duplicate ALL cells on A:A column with red ?
  143. this formula for selecting cells isnt working
  144. splitting cell data at carriage return points
  145. Unlocking cells meeting certain conditions
  146. How can I speed up this slow macro?
  147. Waiting for updates when retrieving data from another workbook
  148. 3 dropdown list, update on each other respectively...
  149. Pulling data out of a table
  150. UserForm: Initialize a ListBox
  151. Comparing two rows of Data
  152. Code that changes a cell reference value taken from a user
  153. Out of stack space error
  154. ontime stop question
  155. VB Help.
  156. find the last used column on an INACTIVE sheet
  157. moving between workbooks
  158. 'Type mismatch' error with autofill and VBA
  159. Compare data between worksheets
  160. Entering values automatically based on another cell
  161. Clear row when duplicate found 1st column
  162. Extracting data from a column
  163. Printing Groups of Worksheets
  164. Run a macro based on changing Cell Value
  165. Row Delete and formula population
  166. Error # 1004 was generated by Microsoft office Excel
  167. Opening a webpage with VBA
  168. loop formula to occur "N" times
  169. Math help
  170. LOOP on this macro.
  171. drawing a border around a list of data
  172. Automatic date entry in cell?
  173. A macro that stops the machine from logging off
  174. Pop-up Calendar When Cell is Clicked
  175. Reconciliation
  176. Macro to strikethrough row dependent of cell value in dropdown list
  177. access or Excel
  178. Editing a macro to change the row height in a merged cell
  179. Drop-down list at login.
  180. Autorun AutoFit macro on cell exit?
  181. Macro to pull specific data out and place in a seperate worksheet
  182. Conditional Formatting comparing 2 clmns - one is deleted, setting new refernce clmn
  183. Find first empty row and paste into it
  184. find next blank cell within range
  185. Prevent multiple cells selection & Lock Cell
  186. VBA exercises tasks for newbees?
  187. Hidden Excel
  188. Basic macro syntax error. What is wrong?
  189. Populate a cell with URL retrieved from Google?
  190. how hide a Row / Column
  191. Macro Recording Question...
  192. Excel VBA: Can I refer to a textbox as a variable?
  193. Directing Excel to cells by relation to others
  194. Macro to Adjust Print Area
  195. Advanced "Watch" ?
  196. Auto Saving a file in a macro to a shared drive
  197. How to create a control array of textboxes
  198. Can Excel 2k3 do fuzzy logic?
  199. Test whether date is within range
  200. Auto save code - Clear Timers: Workbook_Beforeclose Event
  201. Sorting Using Associated Values
  202. Find, Resize, Sort and Paste data in other columns
  203. Identifying the highest value displayed from a cell
  204. Force file name format
  205. Dynamic Web Queries
  206. Text Cuts Off at Comma
  207. Modifying code for copying and pasting between sheets
  208. VBA Drawing Objects
  209. Referencing Other Documents and Triggering Macro
  210. How to export userform and remove it before closing workbook
  211. Format cells
  212. value of a cell into a text box
  213. Inserting sub-total after change in values in three columns
  214. Macro to COUNT for Pivot and Refresh Pivots
  215. Problem with Find macro
  216. Macro question re: concatenate two columns
  217. Count blank cells within a range not including fully blank rows
  218. Open a workbook from cell reference
  219. Macro - Creation of Graphs
  220. Show Symbol Dialog
  221. Show Symbol Dialog
  222. checkbox size is not fixed - size decreased
  223. Sorting Date Strings
  224. How to Open Sheets.
  225. combo box population
  226. Problem copying array values to worksheet cells
  227. Web site for learning
  228. Textbox if empty validation code
  229. Naming a TempFileName from cell value
  230. Help with programming a macro...
  231. Selecting Items in a comboBox
  232. Linefeed-delimited data extraction
  233. Declaring 2 dimensional array
  234. Count Down or count up
  235. Cell population Help
  236. Importing website source code into excel
  237. Where and how to open a configuration file
  238. Macro-driven workbooks for download
  239. how to make pop-up w/ drop-down list?
  240. Efficiency Cut List
  241. Macro's in a Template
  242. Rollout Report
  243. Save file as
  244. Find Value and Copy/Paste Row from One Worksheet to Another
  245. Importing Data
  246. To get the count of cells which meets multiple conditions
  247. Combo Box Code
  248. Creating a macro for Excel using InputBox
  249. Bug Changing Directory on Server
  250. CSV file separators