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 to run as result of if statement
  2. Macro to sum numbers on variable rows
  3. Sumproduct, dynamic range
  4. Updating by multi-user from one workbook
  5. Requesting a simple counting function, pretty urgent (VBA)
  6. Have VBA delete spaces
  7. Ignore input prompt
  8. Deleting duplicate offsetting rows
  9. DDE updating
  10. Help with shortening code
  11. Error Moving Sheet from Network Drive
  12. [SOLVED] Conditional Dropdowns?
  13. Color Change
  14. Using Arrays for none numeric result
  15. Checkbox to hide & unhide worksheet
  16. Divided into Specific Numbers
  17. Best way to share a macro
  18. Scroll bars get stuck in push state
  19. Extract data from open workbook, varying name.
  20. Conditional Formatting - More than 3?
  21. Turn off automatic formatting in VBA editor
  22. Get Temp directory
  23. textbox to Cell date format issues
  24. Running Macro at regular intervals.
  25. Need help through VBA code
  26. routine to decipher where it was called
  27. External data updating macro
  28. Need help with Macro to run on activated sheet
  29. VBA Function Help
  30. IF equation within a subtraction equation?
  31. Macro moves out of Active WorkBook. Why?
  32. Hide pivot table rows with certain data values
  33. Code to look for a sheet on a Network Drive and Copy it into the Active workbbok
  34. Manipulating Excel sheet
  35. Delete empty cells and custom sort by group?
  36. Count Text & Unique numbers in Text Box
  37. Deleting duplicate rows
  38. mutiple reference question
  39. Conditional Formatting?
  40. Insert/Remove Column Macro
  41. FileFormat Compatibility Excel 2003 vs 2007
  42. Macro issues when I change my file name
  43. adding chart to userform1
  44. Restore Excel Menus
  45. Copy data from changing sheet names
  46. Need help to delete rows based on cell content
  47. Excel VBA help
  48. Skip Over Sheet# And Find the first Named
  49. Emailing a macro
  50. Code that will count sheets and route to sub scripts
  51. Debugging problem
  52. Auto Populate Fields
  53. Hiding commandbutton
  54. Import table data from .mdb in my web's root directory
  55. Tab name equal to cell contents
  56. Macro for copying specific rows to a new sheet.
  57. Splitting a large file into two and mining the data
  58. Adding Totals in a worksheet
  59. Create list based on Pivot Page Field List
  60. Macro problems related to file names
  61. Loop/Array to Determine average distance traveled
  62. Pie chart with "speedometer"
  63. Hiding Unecessary Columns
  64. Find and mark cell
  65. Query Tables Work In 2003 But Not 2007
  66. macro to find matching record in a different workbook
  67. Macro which will select certain tabs to print
  68. Connection String In Excel
  69. last day of month?
  70. Macro To Update Cells In Work Sheet
  71. Help w/Indexing code and cell data entry
  72. Script Looping and will not rename my sheet
  73. PivotTable partial data flag?
  74. IF/THEN formula to trigger macro?
  75. Lookup/search from input box?
  76. More Add-In integration problems
  77. havnig some trouble with Select Case syntax stuff
  78. focus on found name in list
  79. Print sheets with cell argument
  80. Code to check if cell is empty
  81. Simple Copy Cell and Paste into another sheet
  82. Trouble with RSq function in VBA
  83. Calculate TextBoxes
  84. Need to Extract Data from middle of cell
  85. Excel not recognizing Add-In Function names... sometimes
  86. Pivot Table: Combine data from 2 columns into 1
  87. join two columns....
  88. getting files' extensions?
  89. VBA: Scramble the letters within a word
  90. copy&paste not avail if an event is running
  91. VBA to send email from Excel through Outlook
  92. VBA Table Filtering (Excel 2007)
  93. Making VBA code(button) run every 10 mins
  94. e-mail question
  95. File name change.
  96. Merging two tables
  97. Input Current Date
  98. Auto filter depending on information entered into Inputbox
  99. Using macro's to translate text via the internet
  100. IF THEN over 7 help
  101. Loop to run through collumns
  102. Error with Loop
  103. Data structure?
  104. A Excel Table within a Userform
  105. How to sort a column depending on number of letters
  106. Macro and Adding Rows
  107. Conditional formatting in Excel 2000 using VBA
  108. Macro to print agreeable contents
  109. Deleting objects using Macro
  110. Edit Script not to look at one of my sheets
  111. For several rows: Copying all cells in a row until blank
  112. If Statement in 'For' Statement - What's wrong?
  113. insert new row based on dates
  114. End user to attach a PDF for review
  115. How do I delete a button from a macro
  116. Copying all cells in a row until blank
  117. Last Filtered Row Number
  118. Add new row to table
  119. Links to external sources and resource issue.
  120. Keeping Clipboard Data
  121. Weight Watchers Points Tracker
  122. Checking existing data for pairs and looping
  123. Selecting Text in 2.cells too give me 100%
  124. How do I find the cell(s) that are linking to another spreadsheet?
  125. Help with dates
  126. Problem with On Error
  127. How to Enable Redo Option Programatically
  128. copying from sheet to another
  129. Locking cells dependant on value
  130. validation / hyperlink help
  131. WORKDAY() Function Returning #NAME?
  132. Read Tab name into formula
  133. find and delete
  134. Can I do this with a class?
  135. Excel Macro HELP!
  136. Generate Email through a macro
  137. HLOOKUP Problem
  138. Scroll Bars picking up numbers
  139. Highlight Multiple Rows
  140. Macro to run mail merge?
  141. Creating an Installer for Excel Add-Ins
  142. Comments copied to Index from worksheets
  143. Macro To Select variable range
  144. Code for returning an "up arrow" from a formula
  145. To enable Redo edit button from vc++
  146. SelectionChange event on specific range only
  147. Turning On a Checkbox
  148. Special Code - Need Help
  149. Why do I get the error: "Runtime error 1004:
  150. Help with Efficiency - Code locking up
  151. Add/Subtract a certain word to a cell
  152. splitting data into columns
  153. Conditional Formatting problem
  154. Programming buttons to add/subtract
  155. Sealecting rows by value and copying to new sheet
  156. Macro to Move Visible Cells after Subtotaling
  157. Database VBA Autofilter Issue
  158. Listbox
  159. Copy and insert new row 5 rows up from bottom of sheet
  160. Need help in creating a survey questionnaire form
  161. Making a complaints database, PLEASE HELP NOOB
  162. Mark repeating data (specific conditions) in the column
  163. Merge Columns B,C,D,E and F, If duplicates exist in Column A
  164. Transposing Challenge
  165. Array formula limitations and projected inventory needs
  166. Offsetting Up or Down
  167. Excel Option Button refuses to work
  168. Excel game
  169. Basic Macro (Jump to Cell) erroring out
  170. ListBox date format
  171. Inventory worksheet
  172. File to do an Essbase retrieve on the hour
  173. Formatting Row Height
  174. Excel calendar in a userform
  175. Linking to Hyperlink in different workbook
  176. VBA to send email (possibly containing HTML) to multiple contacts in Lotus Notes
  177. print only rows in a range that contain data
  178. Checking To See If File Is Already Open
  179. COMMON PROBLEM split name, address, city, state and zip
  180. Problems Updating Modules
  181. Resizing Comment Boxes with Macros
  182. Creating a Shortcut menu but is not working!
  183. Instant message to a mobile from Excel
  184. Hyperlink to another cell
  185. Entering, formatting & manipulating data using Macros…
  186. Moving to and from lines within a Script (goto line)
  187. ScrollArea set to non-adjacent range???
  188. Updating links all at once.
  189. auto save to a file via macro or program?
  190. Move Tab Placements within a workbook
  191. Copy/Pasting from 1 sheet to another with VBA
  192. Enhance column A through column C allowing duplicates
  193. Retrieve and amend records from database
  194. Using ?ActiveCell.Formula
  195. Type Mismatch Error when deleting a cell
  196. VBA Error
  197. Format Cell and Column
  198. Progess bar in staus bar
  199. Conditional Formating
  200. Multiple versions of excel
  201. Setting Ranges With Union Method
  202. VB to check time
  203. Converting values >9 into 0
  204. Code for "Previuos WorkBook"?
  205. Hide sheet from macro
  206. Open Non-Excel File using ListBox_DblClick(...) Event
  207. Defining which data increments when pasting formula
  208. Range cells with content of another cell
  209. Exporting Data from Excel
  210. Sorting amounts in a column so when their sum will be the one i specified
  211. moving table data between worksheets
  212. Not all "Windows In Taskbar", just this one
  213. RATE() function with Visual Basic
  214. Best way to save macros?
  215. looping a search function
  216. Need help fixing code that causes one cell to change based on the entry in another ce
  217. Logic summing?
  218. pivot table drop down arrow colors
  219. Code to select entry in combobox
  220. Protecting columns, but still being able to cut and paste rows
  221. How to select part of row to copy and paste?
  222. Pop-up forumla
  223. Nested Loop/Check
  224. moving information between sheets with macros and inputbox
  225. Looking up values from many short lists.
  226. Protecting formats when pasting in.
  227. finding error values with VBA code
  228. VBA Brain Needed!
  229. Need to Insert down between sets then border sets
  230. alternative to .Select?
  231. Comparing two pivot tables
  232. Delete specific rows, creating range and criteria using inputbox
  233. Too many to update: Code for CTRL+SHIFT+ENTER
  234. how to update a userform after every use
  235. Filter values basis combo box values
  236. [SOLVED] Request for a macro to get average
  237. array filled from txt file error
  238. Copy Data From a Closed Workbook
  239. macro: copy data and create worbooks from a column
  240. Automatically changing which document is emailed in a Macro
  241. Save As
  242. Programmatically change the font size of Comments
  243. adding consecutive number to userform textbox
  244. Run macro when cells are not the same
  245. Deleting the rows with no data
  246. Macro Saves & Names File with Current Date & Range
  247. Simple way to use combo box from Control Toolbox?
  248. Finding integer within a total from array
  249. Certification spreadsheet
  250. Page Number Formula Required