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. access listbox on a different sheet
  2. Exporting Quickbooks data to excel
  3. Export results of formulas to list
  4. Call Code in One Module Into Another
  5. Overwrite when exporting (1004 error)
  6. Convert file adresses and names in a worksheet
  7. coloring cells as cursor moves?
  8. Row Number of Range
  9. Sum only highlighted fields - VBA
  10. Comment Box
  11. VBA Multiple Worksheet Change Events
  12. [SOLVED] AutoFilter 0's & Non-Blanks
  13. Single Use Comand Button
  14. Unhide rows
  15. returning the address of a named range in VBA
  16. Copying values to a text box
  17. VBA formula - If cells active multiply
  18. [SOLVED] Create new sheet at each change in value
  19. sumproduct problem
  20. need an adult keyword filter
  21. How do you enable Excel macros in Outlook?
  22. Assignment to User Defined Type problem
  23. Setting specific font and borders with VBA
  24. List with autocomplete
  25. Inserting a table in an email programatically
  26. Macro to check for changes in data
  27. Categorize Products based on IF/THEN conditions
  28. Calendar: Object does not support method error
  29. macro to log date sensitive information
  30. Lookup to check for anomaly in data
  31. External links to encrypted excel file
  32. Changing a button command
  33. create a column of hyperlinks in one shot
  34. Pasting a Formula in a Macro
  35. How to check a value in a column present in another column
  36. Range with if command
  37. Find & Replace
  38. Macros with Hidden Sheets
  39. Identify Cells with Negative Values
  40. Parsing hyphenated number ranges in a field
  41. Bill of Materials Comparison Macro
  42. sort alphabetically and numerically, then sort rows
  43. FTP via VBA
  44. Dynamic Worksheet Names
  45. Issues with the searching all Excel Files
  46. Search and Replace macro
  47. AUtomatically skipping a confirm box
  48. rename all the files in a folder based the names given in column A
  49. Create booking system in excel!
  50. Copying a cell colour - and use the format in a different cell.
  51. Running Stored Procedures from Excel
  52. Lock specific rows while inserting new rows
  53. Due Date ouput to be static
  54. Amend Proper case code
  55. Building a Hierarchical tree to paste text
  56. Run Form
  57. check data in column
  58. VBA to actvate Unfilter after Auto Filter
  59. Limit Automatic update in the worksheet
  60. Select Cells, Place Object, Create Sum Box
  61. VBA to get 2nd Tuesday of month
  62. Creating expanding dialog boxes
  63. Macro to hide lower priority projects
  64. Finding unique filter items
  65. create a macro to alert me if today's date is within 5 days of expected delivery date
  66. Improve code to delete cells with a value of 0
  67. unique record filter is not working only in this attached sheet
  68. Change value with buttons/arrows
  69. Creating a sheet from data in another sheet
  70. delete rows with "#N/A"
  71. Merge Excel with Powerpoint
  72. [SOLVED] Auto Email w. recipient
  73. Quick and Easy Script, But I need Help.
  74. Week tab to populate day sheets with a 1
  75. Macro to auto add header rows
  76. Macro to change drop down box selection
  77. Distance in points from top of sheet to selection
  78. Macro recorded to split cells - edit to allow for any cell to be clicked and separatd
  79. Access not Trusted
  80. select range based on a cell value
  81. Button Text Gets Smaller When Button Clicked On
  82. Setting Recalc flag - programatically
  83. Consolidate worksheets
  84. Macro that splits any cell not just the one recorded with the same numbers
  85. Command button code to write to worksheet and then open userform
  86. Populate ComboBox With Access Table
  87. Print Certain Sheets to Single PDF Macro
  88. Counting arguments and using multiple ranges
  89. Write to Columns from userform
  90. auto filename for PDF print
  91. how can i create a macro for creating a pivot table.
  92. Comparing Year on Year Data
  93. Class module question
  94. Return the first cell reference from a named list
  95. Macro that skips cells of a certain specification
  96. Dates as Numbers in Combo Box
  97. macro to copy cells beginning from a certain row and reformat
  98. Lookup closed workbook from UserForm
  99. Not sure what im doing
  100. Sort Data on Multiple sheets by single cell Entry
  101. Create a new sheet of each unique item
  102. Convert from table to a list
  103. Merging Excel Files
  104. Dynamic Custom Menu using VBA
  105. Changing Manually entered matrix values via macro
  106. Linking several sheets to one master sheet
  107. Cell character limit when merging workbooks in a folder?
  108. Macro to create new week spreadsheet
  109. Volitile functions
  110. Lost VBA Project in Excel 2007
  111. number combinations
  112. Sorting by Named Range
  113. IF statement comparing to a list
  114. Conditional Formatting
  115. Macro do modify format of the data
  116. Remove unused styles from workbook
  117. copy entire worksheet to current workbook
  118. Summing hourly data into daily data
  119. Message Box and Text Print
  120. Excel uses 100% CPU for 4 hours...
  121. Clear Public Variables Only?
  122. Storing "range" as variable
  123. Have a few problems with code, workbook merging
  124. Locking & Protecting Cells Affected by Macro
  125. [SOLVED] AutoFill more than one column
  126. Remove sheet
  127. Test if top of cell has a border
  128. 2007 Code - Cells(x,x).select
  129. Rounding Up
  130. add content by pushing a button
  131. Searching other files to import to specified cells in a master file
  132. Compare text with "<" or ">"
  133. Automatic Page Break Macro
  134. Search All
  135. Changing VBA code from Outlook to Lotus Notes
  136. Massive search / find / highlight function
  137. Using the "ColorFunction" and Conditional Formating
  138. Worksheet.Protection userinterfaceonly:=true problem
  139. Writing data submitted on userform to spreadsheet
  140. Macro Programming
  141. Need help with Filtering
  142. macro to sort sheets with exceptions
  143. ActiveX Control - Spreadsheet
  144. copy, paste, sort, macro
  145. macro causing me stress
  146. command button to open a window
  147. Macro - linking to worksheets
  148. add protection dialog box to macro in user form
  149. VBA code that analyzes an Excel chart, and then creates a Google Chart API
  150. AutoFill error
  151. Reverse Vlookup
  152. how to implement a NewWorkbook event?
  153. Finding starting point of chart plot area
  154. Draw an arrow equal the size of the selected cells
  155. Stop a running macro
  156. Run External Query (SAP)
  157. VBA for Formatting in the Same Row
  158. Help Optimizing Code
  159. OnError not working...
  160. Check box
  161. getting current cell location
  162. Pivot Table VBA Slow
  163. Paste Special Method Error
  164. Format header to file name from different sheet.
  165. listbox selection
  166. MS-Access to Excel - Columns vs. Rows
  167. Custom function to validate if cell contains URL
  168. Tab Colour change on value of Y/N Cell
  169. Copy-paste data from different workbooks
  170. VBA Searching Certain Number Formats, or String Function?
  171. Simple macro to cut and paste data from one cell to another
  172. Help with varables (Dim value As Integer)
  173. Sheet using absolute macro path
  174. Button to bring up window
  175. Sorting a list into columns
  176. Visual Basic Code Interruption Message
  177. Columns to rows between sheets with criteria
  178. Finding Cells In a Macro
  179. Counting colours and names
  180. How to turn off Filtering w/ Macros
  181. How to amend code to send specific worksheet
  182. Custom metadata shown in a cell
  183. Email macro
  184. Method 'Open' of object 'Workbooks' failed from within browser window
  185. Vba help vlookup
  186. Transform data in column to rows
  187. Programming a Copyright pop-up on opening
  188. data between files
  189. help with setting up my spreadsheet
  190. Counting Subtotals, and that which isnt in a group
  191. TextBox1_Change not working...
  192. Split Cell by Delimiter, Move to New Row...
  193. Preventing ActiveX Controls From Moving or Being Resized When Rows Deleted
  194. Understanding Automatic Transpose Excel 2003
  195. [SOLVED] How to select multiple columns
  196. Finding dates in with VBA in Excel
  197. Trouble pasting charts to Word
  198. Auto display range as upper case
  199. Erase contents in cell based on Strike through.
  200. Locking cells
  201. search part of file name and move file to folder
  202. Finding VBA Compiler Add-Ins
  203. Adding two IF formulas in one cell
  204. Macro to convert data
  205. Weird Button Behaviour
  206. message box - macro - message box
  207. Copy data and create new tab
  208. Word count and paste
  209. Changing Background Settings of Imbedded Frame
  210. Automatically cleaning database
  211. Extracting data from the same range, but user defined workbooks...
  212. Delete entire row if criteria cell is blank
  213. Interactive Pull downs
  214. Problem with shared network workbook
  215. Update cell based on string contained in another cell
  216. userform code
  217. Listbox non-updating/updating
  218. Updating lists
  219. setting up regular reports
  220. Comparing Cells
  221. Add hours to =Now
  222. add date+given text in the file name
  223. Creat Pivot Table with a Macro
  224. copying rows and inserting them between correct dates
  225. How to Change Drop Arrow Size
  226. [SOLVED] Code to open Shortcut files
  227. [SOLVED] Screen Updates
  228. Macro to Paste Special
  229. Insert Cells Until Data Matches Up
  230. VBA version 6.5: Stuff missing from object library
  231. Can't run Private procedure from Autoshape
  232. Auto Install Addin Add-In ?
  233. Paste function not working
  234. warning box macro
  235. Date Format Problems
  236. How to search multiple workbooks for a specific value in a specific cell
  237. Error in visual basic
  238. Save file into 2 folders using one command
  239. Refreshing Date or Now function
  240. Sheets(Array).Copy Dynamically
  241. Reference library for .net method
  242. code selection range
  243. Time Limit on information sort
  244. unhide row simultaneously
  245. Use Event Procedure and OnTime to Stop a Macro
  246. comparing values
  247. accounting Sheet
  248. String Character Length?
  249. insert rows with formulas
  250. Runing "Sample" add-in within a macro