PDA

View Full Version : Microsoft 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

  1. Querytables refresh gives Subscript out of Range Error
  2. Importing LargeTextfiles Over 65,563 lines Error
  3. Reset conditional color VB
  4. Value or Text
  5. How to enable macro later
  6. When first displaying a sheet -List box is not filled in.
  7. User forms - How do I...?
  8. find differences between two columns
  9. Transpose
  10. fullscreen changes corrupt display of listbox control
  11. Range Delete Not working completely
  12. Visual Basic as a Tool for Financial Modeling in Excel
  13. VBA for deleting duplicate rows
  14. Unlocking a Locked File
  15. Chart Legend Names
  16. 4 conditional formats
  17. sending emails using thunderbird as email client
  18. Print sheets in order 'x' times
  19. Copy text with more than 65,536 lines into Excel
  20. Excel crashes when VBA window is closed
  21. Help please!
  22. Hyperlinks change on publish as webpage
  23. AutoFilter can't work after the worksheet is being protected!!!
  24. empty cell
  25. find format of cell
  26. PLEASE HELP - query results to multiple rows.
  27. Webpage Navigation
  28. Reference to adodb.connection (or objects in general)
  29. Input Boxes on Web Pages
  30. Edit within a cell to select parts
  31. Truncation of string problem
  32. Warnings on Web Pages
  33. Chart Auto-Size Behavior
  34. Get Parent directory
  35. dynamic Range in ADO
  36. Drop down list - most frequently used
  37. Listbox in a form
  38. export data to an existing and open workbook without knowing the f
  39. DTPicker Bug
  40. Registering UDFs
  41. Copyingand pasting
  42. Checkbox - Source types
  43. Excel manual calculation probs
  44. Saving emails sent by Lotus Notes through Excel
  45. Handling dates in VBA
  46. How to save with a name in a particular cell?
  47. Struggling with a loop problem!
  48. Same name - multiple data - how to combine
  49. How do I create a new work book with selected worksheets
  50. counting repeats of data
  51. formula and offset
  52. Collecting data from excel forms into one spread sheet
  53. Perform FIND Starting from the beginning of the Range
  54. Highlighting Found Cells
  55. ADO while being used
  56. Range of Days in a month
  57. scroll a few columns at a time
  58. How do I unhide the subtotals in a pivot?
  59. Code to Insert rows and copy formulas
  60. Pictures in Footers (again!)
  61. To reset the Interior.ColorIndex function
  62. COMPARE TODAY WITH DATE IN COLUMN
  63. VB for Applications
  64. How to get Leading Zero's passed
  65. Local formula evaluate
  66. Toolbar buttons how do show and change the status
  67. clearing an array
  68. Multiple External Data Returns
  69. How to control the page break
  70. Automating new line items for worksheets that will be added?
  71. How to terminate an object that's in a collection
  72. macro security
  73. Is it possible to remove the Select method in this case?
  74. Is it possible to remove the Select method in this case?
  75. How to obtain the Row number of next visible cell Down?
  76. Security - Setting
  77. Set current cell to a specific value
  78. Need Code to SaveAs under different Menu.
  79. Looking up data in a large sheet
  80. inverse fourier
  81. Get Open File NAme
  82. Storing/Finding Info Trees
  83. Pop up Clock?
  84. Exotic Menu Controls
  85. Insert an row without using select
  86. Keeping empty values empty (not zero)
  87. Returning reference of frozen cell
  88. Argument List; Arguments Passed to the Procedure
  89. Option Buttons
  90. button disappears when column is hidden
  91. Query fails, requiring excel to be closed and restarted
  92. Need help to make date comparison work, please?
  93. Attendance Tracking
  94. Time Sheet Macro
  95. Column Cut/Paste possible?
  96. How to import data into multiple worksheets from seperate text fil
  97. Run-time error '438': Object doesn't support this property of meth
  98. Updating 20k+ rows from Excel to access. vbscript? VBA? SQL?
  99. macro count date
  100. ComboBox, linking cells, vba, worksheetchange function, and overal frustration
  101. ActiveWindow.Width
  102. Command button code to include worksheets_SC
  103. VBA memory allocation
  104. Changing order of conditional formats
  105. finding conditional formatting cells
  106. Exporting from worksheets into new workbooks
  107. Looping Issues
  108. Optimizing Excel Code
  109. Dynamic ComboBox Reference
  110. show and hide a text box
  111. Userform Label Click
  112. count number of sql query result
  113. draw chart
  114. Find value then offset, to set variables
  115. Date Range of Week
  116. Insert module automatically
  117. Program design question...
  118. Why need to use Selection.PasteSpecial vs myRange.PasteSpecial
  119. Updating a coumn in Excel based on new entry data
  120. Checking a database/excel sheet for new entries
  121. Copy comment to another cell
  122. Checking a database/excel sheet for new entries
  123. Timesheet
  124. Using msxml2.xmlhttp to automate downloads
  125. Merging two different excel spreadsheets
  126. macro to call up sheets
  127. If Statement Help!!
  128. Help - Update a SQL table from a specific range in Excel
  129. Error in CommandBars
  130. ListBox data validation
  131. Auto expanding x axis of a chart.
  132. NEED HELP - results to row???
  133. Writing own formula 2
  134. Multipage - default to particular page
  135. Dynamic Charts
  136. Excel / Access User Conference - Oct 24-26, St Loiuis
  137. Paste not working in With statement - do I have too many 'With's?
  138. Reading Excel data using Java Jakarata POI HSSF
  139. How to create crosstabs in a table?????
  140. Export from XL to Access via ADO
  141. Open Excel
  142. Application-defined or object-defined error
  143. screen capture
  144. refering to a variable in a cell.formula
  145. VBA moving a worksheet to another Workbook
  146. Selecting cells by colour
  147. Set reference to different versions of AutoCAD from Excel VBA
  148. Execute command in Right Click through VBA
  149. Getting the row from a range
  150. Add-in with IDTExtensibility2 and worksheet formulae
  151. Use of COUNTA
  152. Name and save files with current date & time
  153. Help needed for sorting the data and plotting graph
  154. Activate the solver witin a macro
  155. answer to Rick
  156. Hyperlinks?
  157. strip out < sign and then calculate
  158. cell has decimal value returns whole number, why?
  159. find data another workbook
  160. help with macro
  161. define name
  162. Using ADO and Late Binding
  163. Searching for code for insertion of dynamic excel formulas
  164. UNLOAD ADD-INS utility?
  165. Hide names of columns and rows by code.
  166. Retrive Data in Userform [from Shahzad]
  167. Help wanted with Code, Please
  168. pass parameter to Query
  169. VB6 component does'nt exist
  170. Boxes in my text
  171. initial value in a cell with validation
  172. Compass Heading drawing from an angles list
  173. Problems loading user form
  174. Code for getting Access recordset into Excel
  175. SendMail Problem
  176. Loop problems
  177. Selecting listbox items programmatically by using stored parameter
  178. How to turn on the pop-up "alternatives" while editing in the VBA Editor
  179. Need help with a % or $ value formula for excel
  180. Edit Listbox in Userform
  181. Loop Unitl with timer
  182. Problem with setting value in validated range
  183. Copy a selected Range to a Workbook
  184. Excel template with VBA Code intact
  185. edit and forward mails
  186. Taskbar and applications
  187. re-post as still need help!
  188. Can you change linked Excel file to Access path with Excel VBA
  189. How to include a Dynamic cell reference in a Fomula?
  190. Average
  191. Columnwidth change not correct
  192. Search Formula
  193. Dynamically named Ranges?
  194. How to force all of the cells in a worksheet to recalculate?
  195. Can I get Excel to call my macro for number formatting?
  196. how to use reference cell in VB?
  197. Not finding file to print
  198. typed character sensitive listbox
  199. Running a Check prior to crating tabs.
  200. CCP Uses Executed Prisoners to Dodge Allegations of Organ Harvesting
  201. CCP Uses Executed Prisoners to Dodge Allegations of Organ Harvesting
  202. Pivot table - How to create dynamic filters
  203. Application object missing?
  204. Stop users from inserting new lines and columns?
  205. Sheets.Add
  206. command button to save
  207. Picking a random number from data
  208. Now Function Question
  209. determining array with no bounds set?
  210. Sub(), Modules, and Private/ Global variables
  211. How much Can Programming do to Excel Printing?
  212. run time error 1004 : application defined or object defined error
  213. Which Sheet Is Named Range On?
  214. Looping Through Public Collections
  215. Save As problem
  216. Scroll Area Problem
  217. Freezepanes odd behavior
  218. Copying code behind from a sheet to a sheet in another workbook.
  219. hyperlink to individual files?
  220. Return Partial File Name to Cell
  221. Need help with a Macro Procedure
  222. UserForm question
  223. MATCH multiple values
  224. HELP! Someon's gotta know this
  225. query results to row
  226. Window Message to Verify Data Already typed
  227. Problem accessing binary data from mysql data base
  228. cant seem to get a function to reference a variable cell?
  229. Warning Message to Prevent Overwritting
  230. Error Handling question
  231. Add in to spreadsheet
  232. Forms
  233. create a dropdown list for data input
  234. Going Crazy
  235. Finding Newest File
  236. How to put footer's page number into a cell
  237. Folder Tree
  238. Copy a range of information to a worksheet in a specific file
  239. Check for specific email in Outlook
  240. how to compare two columns on two sheets and copy associated data from one sheet to the other?
  241. change =NOW() to permanent date string
  242. Copy and paste sheets between workbook
  243. Syntax
  244. Excel does not quit
  245. Call an ADDIN function from VBA code
  246. Zero divided by Zero
  247. ActiveX Combo Box ListFillRange = Worksheet Named Range
  248. Cell formula that captures name of the file's folder
  249. If/And Greater than or Less Than
  250. Trapping expansion or collapse of outlines
  251. now function
  252. Help please! I'm confusing myself.....
  253. Move Multiple Sheets - Name Variable
  254. Importing text files asa group
  255. Add a filtered range to a multicolumn ListBox
  256. Enable/Disable ComboBox
  257. Count open workbooks before closing
  258. macro to save current excel sheet only without losing formatting
  259. Upload file without user interaction - VBA
  260. Saved Web Page into Excel
  261. Exporting graphs causes unwanted resizement!
  262. Capturing a row being inserted
  263. how to crerat star rating in a cell
  264. problems using printout method in excel 2007
  265. Excel 2007, VBA/VB6: Read the different colors defined for a workbook...
  266. match two worksheets
  267. Code to import data based on selection in two listboxes
  268. need help macros excel 2003
  269. Making Changes in a Group of Workbooks
  270. macros
  271. Help with Application.Match and it's funkiness
  272. file not found ...\local~\temp\vb514.tmp
  273. BeforeClose event help
  274. two worksheets - matching macro
  275. Challenging Problem
  276. BorderAround won't go away
  277. inporting data from website where website address frequently chang
  278. catch event
  279. Go to next line
  280. Differente .xls files generated when VBE window closed vs open
  281. Need the code for a simple macro
  282. Link Excel form to Access query result or any other ADO
  283. Possible BUG (Listbox item selection)
  284. Setting a range?
  285. Link form to Access query result
  286. VBA to Make Check Box Entry
  287. Finding a "Min" value
  288. Update access DB record when finished running macro
  289. Combo box Row source
  290. Text with leading zeros being converted to numbers
  291. Variable arrays & checkboxes
  292. Gather info from two workbooks to make a third workbook..
  293. Macro to perform action based on value in cell
  294. Extracting Text from a text string
  295. UDF not updating
  296. run excel macros from shared drive
  297. !@#$ Query with Joins???
  298. dropdown - accessing values
  299. Opening pdf's from Excel
  300. Conditional formatting
  301. Runtime error "1004" on this code, help pls
  302. clipboard in excel
  303. How do i import excel tabs in access with Docmd
  304. Semi-Automated Copy and Insert
  305. Listbox has some items selected when userform containing it opens.
  306. Check Input, into Input box question
  307. E-Mailing an existing file to a specific e-mail address
  308. Importing files
  309. using Frequency in Excel 2002 VBA
  310. Remote Assistance
  311. Problem with ComboBox, dynamic range and change event
  312. Conditional formatting error
  313. Excel Macro to Copy Word Text into an Email
  314. Find print area when no print area set
  315. deleting sheets
  316. width of combo box control on toolbar
  317. Inconsistent Sort
  318. Find an value and clear contents of that row
  319. Macro
  320. Extra space with vbNewLine
  321. Combo drop-down edit box
  322. Absolute External Link?
  323. Select Method of Range Class Failed
  324. Setting Macro Hotkeys Programmatically
  325. Formula to find a value in a list that doesnt match another list
  326. excel function
  327. Adding to a ListBox
  328. Newsreader Question
  329. Filter and immediately overwrite same sheet with results
  330. QueryTable causes Heisenbug (difference between running and debugging code) [SOLVED]
  331. Please help!!!
  332. lookup in 1 workbook to get data for another workbook
  333. Urgent!!! VB Developers for UAE
  334. Do while
  335. Update user form labels
  336. Check if file on intranet exists
  337. reorder information
  338. XL2002 - Select All Objects in an Array...
  339. Can I have a temporary message window appear during code execution
  340. Comparing a range of values against a cell
  341. Chart2JPG and export to webpage directory
  342. Code to kill all modal dialogs
  343. Macro - Please Help
  344. export location
  345. Query Refresh Error
  346. Trying to stream back data into Excel from ASP.NET - charset issue
  347. Close Message box after 3 seconds
  348. Why does my sumif criteria appear as RC[-2] instead of B4 etc?
  349. Button tip
  350. Macro: search word, select row, copy.
  351. New Filesearch & Foldersearch functions
  352. Enable / Disable User Form Fields Based on Input.
  353. Triggering an event whenever a new shape is added in a sheet
  354. filling sheets with Oracle ????
  355. Counts of Find/Copy Lines
  356. Running Excel macro
  357. Changing the format of a cell after a time limit
  358. Combine Comments
  359. Passing Query String into MS Excel
  360. copying data into a file with a modify pw & read-only recommended
  361. Loop
  362. Hard Returns
  363. Getting links from other Columns
  364. Loop
  365. Print Range
  366. VBA - Edit Procedure from Excel Userform??
  367. Links From another Column
  368. Checking a database/excel sheet for new entries
  369. Setting string based on conditions
  370. Office 2003 update problem - Please Help!
  371. Best way to manage product database
  372. help with vlookup or similar
  373. combine two workbooks
  374. Change cell color if...
  375. Help with msgbox showing cell values
  376. matching macro - very compicated....please see eact details inside
  377. excel macro missing worksheets
  378. Inverse Fourier Transform
  379. Exchange Rates
  380. Dynamically enable combo box if check box is checked
  381. Combo Box Default
  382. Array keeps returning Null Values
  383. Find Next Blank Row
  384. getting data from an array of varying amounts of comboboxes
  385. Retrieve pivotitem range
  386. Apostrophe's apearing in range address
  387. Adding columns based on new worksheets
  388. Conditional Formatting > 3 Conditions
  389. Vb code help needed
  390. Changing Chart Size with Excel 2007
  391. extracting data from different excel sheets
  392. Pivot Table with Quarter Subtotals across the top
  393. Make Excel know 1M is 1,000,000
  394. Test if a Cell contains either of 12 different words
  395. Help!!! Form Controls & DB Query's
  396. Copy Sheet with dynamic chart?
  397. Is there a better way to enter data than Data Validation
  398. Kill specific MODULES
  399. Aligning comments
  400. chart sizing and titling
  401. Creating a spreadsheet to calculate probailities of winning raffles
  402. Way beyond me: Calculate ROI of home energy improvements... while also taking into account increases in energy prices
  403. Popup Window
  404. Loop ?
  405. DT Picker
  406. select next
  407. Excel Drop Down Lists
  408. excel report
  409. Highlight the cells referenced in the active cell formula
  410. macro filter column for most recent date
  411. convert text file to excel
  412. Program editing to copy in text format
  413. Code for duplicate rows?
  414. Center Userform Controls
  415. next object selection
  416. Help with copying range btw workbooks (advanced example)
  417. Sort a Record Structure within a Report Routine
  418. Excel database
  419. Namespace Microsoft.Office.Interop
  420. send the data to lotus notes by email
  421. Further help on cell highlighting if change to contents
  422. How to Copy entire Worksheet from Workbook S to Workbook D
  423. how to use vlookup in this case
  424. Unprotect WS on clicking Group
  425. problem with excel??
  426. workbook Book1 missing on Exel start
  427. Info Box that disappears by itself
  428. Creating a collection in a class
  429. save html
  430. Strange Problem
  431. Help with this challenging VBA coding
  432. Capture multiple sourcefile filenames
  433. Creating and displaying an email in lotus notes thorugh excel Options
  434. HELP for coding?
  435. text or numeral
  436. AutoColoring
  437. Option Button?? Help
  438. Excel Lookup to Exchange Global Address List
  439. Option Buttons Added at Run Time
  440. Array Problem
  441. combobox - default value
  442. Option Button Size
  443. Macro copying an array and pasting to a Word bookmark
  444. selecting non-contiguous blocks of cells in vb
  445. PivotChart with DataTable cropped when copied to PowerPoint
  446. Cell formatting -- why so slow?
  447. Identity on Database Fields
  448. recalculate page breaks after setting Zoom in pagesetup
  449. early beginner, simple question about End(xlUp)
  450. Creating a macro that opens and runs multiple workbooks and macros
  451. Data Validation based on data to left but several columns dependen
  452. Custom Toolbar/Menu for UserForm
  453. kpi display in excel 2007
  454. Delete key casue a litte trouble
  455. Copy and Paste seperate ranges in excel
  456. Setting Chart Range
  457. Change Format of Only Some Text in Cell
  458. create a file, put a excel sheet in and a icon
  459. Excel template link to table
  460. VBA with Linest non-equal observations
  461. Confirm Data from Other Cells
  462. MORE combobox questions
  463. Read from source of a Website to Excel
  464. Ribbon command idMso for "Insert Cells"?
  465. Help with code for selecting pivot table field by typing in a cell
  466. Choose a macro from within a macro
  467. code to save as webpage
  468. format all sheets
  469. target.offset(0,-1) does not work as assumed
  470. Prevent Repeating Data Entry
  471. Timer to lock spreadsheet?
  472. workbook_open no longer occurs
  473. Decimal Symbol
  474. ODBC bridge to oracle with vbs
  475. Sleep Mode
  476. Have macro ignore error
  477. Concatenate list of cell values into one cell
  478. Excel / Access User Conference
  479. Form Click event...
  480. Cell pattern-style and color in Excel 2007
  481. Query Error? (Works in mySQL)
  482. close workbook/pdf conversion
  483. Help setting chart series values with non-continuous range
  484. how to consolidate two ranges in a new workbook
  485. "Catastrophic Failure" error using ADO to query Excel Workbook...
  486. Return to module after userform
  487. Loop works correctly but takes extremely long to execute
  488. Vista Registry Entries
  489. Excel conditional formatting - how to make exceptions?
  490. Combine data in rows based on two citeria
  491. How to get a date stamp whenever a value is changed?
  492. Workbook reference
  493. Pause while user clicks on chart series
  494. Add-in version check
  495. determine if cell is #N/A
  496. Double Double Quotes
  497. passing objects
  498. Excel Calander code changes
  499. Loop through range and open files
  500. Capture OLE Error
  501. Formula Programming
  502. myRow = Cells(Rows.Count, 2).End(xlUp).Row
  503. Two columns combined into one dropdownlist
  504. Programing a button to copy and email
  505. PivotCharts On The Same Sheet
  506. Re: Highlighting when a cells contents has changed
  507. Highlighting when a cells contents has changed
  508. Hyperlink or Command Button Program
  509. Theory behind passing workbook
  510. "%^{F9}" doesn't cause calcaulation
  511. Program a cell to add its contents to another cell
  512. Test on Username
  513. re-asking for help
  514. Excel 2007 - Crash
  515. VBA FEatures Not Working
  516. Vlookup error
  517. Tricky chart axes synchronising question
  518. Setting Autofilter using code
  519. Convert Excel file to Txt file
  520. Filling Lists with Workbook_Open
  521. Reversing bytes
  522. Sorting product row with header result
  523. edit and Forward email
  524. Any way to use R1C1 notation to access an online spreadsheet in a ZIP file??
  525. Re-size active window
  526. Close Shell
  527. Macro for opening and copying
  528. Populating One Listbox from a second listbox
  529. running code only in selected module
  530. SORT: Is it possible to supply operands via function / vba sub?
  531. Application.match - apparent error?
  532. Format problem
  533. PivotTable.columnfields(index) vs Pivotcell.columnitem(index)
  534. Keep formating from old sheet in the new sheet
  535. Querytable Class Module
  536. Listbox ColumnCount = 3
  537. If statement to call module based on cell value
  538. Display ONLY the LEFT Most 6 Charaters
  539. Restore an invisible commandbutton on open?
  540. RE: Gaining the correct Listbox Column value
  541. Avoid Window Message while deleting a sheet
  542. Method 'Union' of object '_Application' failed (Runtime Error 1004
  543. UCase Column BH in a Sheet
  544. converting cell formulas to into VB
  545. sent as attachment
  546. Pause While User Clicks on Chart Series
  547. Script works very slow!
  548. chart formatting
  549. Text string to a number
  550. Cell pattern-style and color in Excel 2007
  551. Interview test questions?
  552. First Time VBA user- really easy question :-)
  553. Program Pivot Table Buttons
  554. Program so that clicking on a cell will copy that cell to another
  555. Call and list Specific Files Under One Directory
  556. chart formatting
  557. create a folder
  558. 2002 Vs 2003
  559. Using Goal Seek without a macro
  560. Call Macro
  561. Tab color, Font color
  562. Find and Replace
  563. active Printer
  564. adding ComboBox programitacally
  565. dont confirm save with yes/no/cancell
  566. Selecting the item in combobox in excel file through C# application
  567. taborder excel
  568. Sub to check & force open Parent.xls
  569. Rows Group -looping issue
  570. Deleting Workbook
  571. Browse to Network Share
  572. Passing Excel Values back to a SQL Table
  573. code to run once on first open after save
  574. Programing a button in excel
  575. merge sheets based on common id with VBA
  576. ADO Error Handling
  577. Data Validation Unique List & Alphabetized
  578. Minimum/Maximum Dates in Range
  579. Updating a datasheet without all the blinking
  580. "Code Page" ??
  581. Workbook.Open Question
  582. VBA editor problem
  583. Macro not exiting correctly
  584. Can I write a macro to ask for a specific number?
  585. Copy a Range of Data to another Work Sheet
  586. Adding event when sheet created
  587. Deploying an Excel 2003 Automation addin (C#)
  588. extracting data in an array
  589. Radio Buttons
  590. Two problems with Application.Run "ATPVBAEN.XLA!Random"
  591. Searching for values in a given range and then prepending a formula
  592. date created on picture files
  593. Rental fees
  594. Menu add-in
  595. Countif type thingy...
  596. changing font colour
  597. SheetBeforeDoubleClick and merged cells
  598. send to command/ e-mail and attachments
  599. send information to word
  600. Hide Scrollbars
  601. update multiple cells by a percentage
  602. Writing own formula
  603. Open "xlDialogChangeLink" Dialog with VBA/VB.Net
  604. Is it possible to get data from several word files having static format to one excel worksheet.
  605. Macro or VBA Code to un tick CheckBox
  606. HELP ListBox Save Data to Hidden Sheet, and ReLoad It upon opening
  607. Opening a file
  608. Very simple...early vba learner - range name in excel and in vba...
  609. No sound with display
  610. Accessing a Remote Server
  611. macro to run on first open after save and close
  612. Print form from other application
  613. macro from desktop
  614. refreshing web queries
  615. Populating Cells From Dropdown Lists Aimed At Other Worksheets?
  616. Day calculator form Given Date
  617. VBA Converters Excel 2000 to Excel 2007
  618. auto safe macro for workbook
  619. Help with Copy based on dates code!
  620. Paste Problem
  621. paste macro to a workbook code
  622. VBScript from VBA excel / wshShell.Run failed, error 80070483
  623. export a workbook to specific loc on other computer via internet
  624. Old VBA code in MS office 2007?
  625. .activate on hidden sheet
  626. auto save code for vb in excell
  627. Is it feasible to use Excel as a database front-end?
  628. Hiding the Insert New Worksheet tab in Excel 2007
  629. if a cell equal to zero how can it delete entire row
  630. Autofill in Database problem
  631. excel prob - cant save worksheet if someone has it open in a veiwe
  632. Generate sheet names from list, assign data to summary sheet.
  633. Macros in Excel that work with Word - 2003
  634. pivot tables long string formula for calculated field
  635. Strange userform activate behavior
  636. how to create a new workbook based on a template...
  637. VBA code store address with areas separated with "," and I need it sometimes with ";" instead
  638. Faster way to find what part of a range (actually addresses) not intersect with another one?
  639. Embedding Data From MS Access Table?
  640. Partitions in Short Cut menues
  641. VBA reference via code
  642. Help in highlighting and displaying found data.
  643. problem with With, End with...
  644. VBA Run time error 91
  645. Return blank cell from conditional
  646. how do i get system id to a excel sheet
  647. Delete All VBA
  648. Arrays and Loops
  649. Sendkeys in Visual Basic
  650. restricting data entry to non-times
  651. controls in excel
  652. data validation
  653. Total Value of a Range
  654. Breaking the data of column A into two columns First Name & Last name.
  655. Who launched Excell?
  656. Change Case for Names
  657. Lost Important data
  658. Launch external file based on cell value
  659. How to delete selected columns?
  660. data entry restricted to non-times
  661. Combine like rows
  662. Unable to open file
  663. Unable to Open Excel File
  664. Use VB to move to adjacent cell
  665. Testing for and ungrouping grouped sheets
  666. Sort Runtime Erroe 1004
  667. Unhide 1 column at a time from named range
  668. Print Charts
  669. Formula will not evaluate in VBA
  670. Macro - how to
  671. Need help with an excel macro im trying to make
  672. VB Code for saving PDF Print File
  673. Macro to delete rows with different data
  674. TextToColumns Method: How to use xlFixedWidth?
  675. VBA userform troubles... adding to database no problem....updating modifying info = :(
  676. Exit All Sub Command?
  677. Help: Unprotect Sheet Re-Protect Permitting 1 row Deletion
  678. macro to locate picture
  679. Need help with multi-row filter/sort
  680. Excel VBA cause Word to Crash
  681. Not existing procedure correctly
  682. How can I download from the web thru VBA
  683. referencing file paths
  684. How to Use a ListBox to Print Files in a particular order
  685. Color Palette
  686. Prompt for user information at startup
  687. summing groups in a column
  688. Need an explanation
  689. How I calculate an integral in VBA for excel
  690. animated image in user form
  691. Code to check if word doc is already open
  692. Adding to rows - sign issue??
  693. For...Next Loop
  694. Chart Events...
  695. Find the last cell in a selected range?
  696. I Dunno
  697. Setting a user's "Regional Options - Short Date" from Excel?
  698. Having "Or" in If statements in VB doesn't work?
  699. If blank cell continue macro
  700. Range Syntax for Script
  701. grab values from a range
  702. Creating VBA Functions When Creating Spreadsheet Via VBA?
  703. Help with VBA
  704. Trying to write macro to combine data in multiple tabs into a single tab.
  705. How to sort in most effcient way?
  706. Getting data from IE
  707. automatically numbering cells for large data from other sheets
  708. auto count-if with subtotal's autofiltered layout
  709. Most efficient code to "flip" a range of values + vs -
  710. Set Focus on dialog box
  711. Equating page filter value to a cell drop-down value
  712. Highlighting cells when errors occur
  713. Download text file from website
  714. Beta distribution t test
  715. Applying a macro to a range of cells
  716. Merging excel worksheets
  717. File Name
  718. MS Query
  719. Disable only the Insert Column option in Right Click
  720. early beginner not satisfied with simple macro
  721. stringed userforms won't hide
  722. Manual created in Lotus
  723. Excel 2007 builtin dialogs
  724. general query about reporting of procedures
  725. Convert Date/time to date only in vba
  726. HOW CAN I do"T0 C0NVERT TIMEING IN TO MONEY WITH 'IF' CONDITION"
  727. Data from Access using ADO
  728. Help! Plotting to scatter graph
  729. Last Entry
  730. Tree View; selecting and pasting data to cell
  731. change format of dropdown list in combo box
  732. Gaining the correct Listbox Column value
  733. Combine similiar rows
  734. Using a Macro Button to Move to a Different Cell
  735. Finding the first instance of a name or partial name in a list of names
  736. setting up library check out
  737. Best position in VBA code line for
  738. Hiding/Restoring Built-In CommandBars?
  739. Range and non contiguous cells
  740. Creating a Pivot Table with VBA
  741. combobox in userform
  742. check to ensure all files in folder
  743. Documenting a macro
  744. VBA Find and Replace isn't working on apostrophe within cell value
  745. [Excel 2007] Set Focus on Dialog
  746. Updating a SQL table with information entered in an Excel Database
  747. Input Color Scheme for Date Column
  748. Combobox drop down
  749. Need to loop
  750. Random Number Array