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

  1. Excel VBA, Loop, array, cut and paste
  2. insert blank row when cell changes
  3. Excel VBA with outlook
  4. Closing Hidden Workbook when Active Workbook is Closed
  5. First & Last
  6. Copy highlighter
  7. Assigning set of range names
  8. declarations
  9. Assigning numeric value to text in drop-down menu
  10. Is this possible......?
  11. VBA to Concatenate and Autofill??
  12. Excel Combo Box
  13. For you JIM, 19/09/05
  14. Run-Time Error 462
  15. Clear unactive combo boxes
  16. Auto Open file VBA Refresh MS Query Save Close
  17. File Saving
  18. Help. Find in sheetB a variable value from sheetA
  19. Re: VBA to zip excel spreadsheet using xp's compression system
  20. Excel 12 - Information Released
  21. Syntax to select all data
  22. Set MyPath variable as workbook.path
  23. excel vbe scroll range - how to save?
  24. Complicated sorting
  25. sequential number breaks
  26. Problem with calculating
  27. Rounding Up For Retail Pricing
  28. Can you paste file *NAMES* into Excel to form a database of them?
  29. Code Question
  30. matching multiple rows
  31. My guess it's a simple quesion, but I'm a beginner
  32. Syntax of hide/unhide personal.xls toggle
  33. Sum if in VBA
  34. Navigate a worksheet when under control of a macro....
  35. sheet builder macro
  36. Close Workbook if Macros not enabled
  37. Drop down box
  38. Lookup Ques - finding value within a string to lookup
  39. Charting Problem
  40. Different Returns
  41. Sum If in VBA
  42. ScreenUpdating function not working?
  43. Popup commandbar and Setfocus
  44. My variable always says False when I set it to True?
  45. Resetting Page Number in Excell
  46. Will using a "personal macro workbook" slow down my other VBA code
  47. Testing 2 conditions on an IF statement
  48. Crrection Help for a macro to locate max value cell
  49. Please Help!!!! If statement, lock and unlock cells
  50. I instruction to move to a different Worksheet
  51. Controlling WORD from Excel
  52. Question rather than a query
  53. SQL practice with Excel?
  54. Max number of sheets in workbook
  55. Hiding scrollbars in active sheet
  56. Problem with the Web Query
  57. Drag And Drop Implementation in excel
  58. Save Changes with no change to save
  59. Formula: How to write.."if A2 is blank then b2=today's date?
  60. How to assign value using a Char Codes?
  61. Re: Please Help!!!! If statement, lock and unlock cells
  62. How To replace If Q
  63. Indirect equivalent in VBA code
  64. Re: Please Help!!!! If statement, lock and unlock cells
  65. validation list with comma values?
  66. Excel's VBA Help Topics
  67. Re: Is This Possible?
  68. number formatting based on cell value
  69. Re: upload data from a dbf file
  70. database query to upload a dbf file
  71. Copy certain columns to another sheet using a macro
  72. trouble with row selection
  73. Toolbars Disable/Enable
  74. Re: Please Help!!!! If statement, lock and unlock cells
  75. Reposting: Drag And Drop Implementation in excel
  76. Can I convert Lotus macros to Excel?
  77. How to assign 2 letters to automatically input a sentence / excel
  78. search question
  79. startup
  80. PESONAL WORKBOOK PLEASE HELP
  81. where do i find a list of macro keywords
  82. Emailing with EXCEL
  83. create a macro for a combo box to change a pivot table
  84. Looping macro
  85. Refreshing Object Properties after "Set"
  86. Re: Please Help!!!! If statement, lock and unlock cells
  87. dropdownmenu with additem
  88. cell color
  89. VBA
  90. Clearing Checkbox
  91. Moving display of comments closer to parent cell
  92. userName
  93. Delete Comment if contents = "HIDDEN FORMULA"
  94. excel formula to recognize overtime in a day as you prep schedule
  95. Can you test for a range (Q16:19) any cell is ISBLANK
  96. Add Time in Filename
  97. VBA - Open Folder Where .xls Resides
  98. How to create a variable from a calculation
  99. Macros from German excel don't work with English version
  100. To populate a column with a date
  101. Shift data from row to row
  102. outlook express email question
  103. Checking for valid dates on entry
  104. Re: Please Help!!!! If statement, lock and unlock cells
  105. league table from results
  106. consecutive cells
  107. Round variable to 4 decimal places
  108. Permutation in excel
  109. VBA - Line Numbers ?
  110. Is it Possible Q
  111. Stupid, stupid question....
  112. RE: Input for TextBox having a mask for date or $ amount
  113. Inputbox question
  114. Q: Open VB - Editor from macro...?
  115. List Box Question
  116. Create a formula to fill in a date series without using
  117. VBA - Identify Begin/End of Cell Ranges
  118. Display a message in a worksheet
  119. Clear Combobox from forms toolbar
  120. Password Protect Running of Macro
  121. Can't set Chart's SeriesCollection XValues
  122. Detection of Macro Code
  123. Replacing Non Printable Characters
  124. Locked Property Error
  125. Loading a calendar (user form) from another project (personal.xls)
  126. Run-time Error'91: Object variable or With block variable not set
  127. Detect when a Cell value has changed. Working too well :-(
  128. Residential Builder Gantt Chart in Excel
  129. Chart is Upside Down
  130. User form and hiding worksheets
  131. Copying Cells
  132. Call to Re-Named Module [to match Sub() name] fails ?
  133. Populating a dialogbox
  134. Duplex Printing
  135. Avoiding page breaks across merged cells - Code not working as expected
  136. Select a Cell - Move Row to the Top of the screen
  137. Help with VBA Macro to automatically copy/paste as Values
  138. Create Charts using VBA with different X and Y values
  139. Opened Workbook
  140. Need to insert formula to a variable number of rows
  141. Automatic nameing of ranges based on a label
  142. Import data using macro recorder
  143. My Data Table
  144. Problem with a date using Mail Merge
  145. Macro for Control ListBox
  146. How to prevent datalabels overlaping each other?
  147. Dropdownlist in a Cell
  148. Remove the module
  149. Calendar Control 9
  150. Simple Error Checking
  151. How to pass FieldInfo parameter to Workbooks::OpenText(...) in VC+
  152. why VBA. ?
  153. Importing a text file
  154. XLA makes XL2003 crash
  155. XLA makes XL2003 crash
  156. Pivot table marco problem!
  157. Running & maintaining macros remotely
  158. issue with pivot-tables
  159. RTD server performance
  160. CodeModule utilization problem
  161. How to set a column to accept only a specified number of digits
  162. Copy problem with cells which have Wrap Text property specified
  163. make email add forward the work sheet
  164. Can i get rid of an error message
  165. Code needed to test if user clicked a button
  166. Code Only works when sheet is in focus
  167. xxxxxx
  168. dienstrooster
  169. Rebuild Array-formulas
  170. problem with coding
  171. I keep hitting F1 by mistake
  172. Cell reference dependency
  173. Countif cell has shading
  174. Copying across multiple files
  175. ISBLANK for a Range
  176. MACRO TO TRANSFER DATA IN EXCEL 2000 PRO TO ACCES
  177. Macro to select various cells
  178. Re: UpdateLinks
  179. stock level teaser
  180. flashing text in Excel
  181. referencing last non-empty cell...
  182. Copying values from one file to another
  183. Calling Edit Buttom Image?
  184. Getting info from word using macros
  185. Excel VBA connection to SQL Server using ADO
  186. Calculate active sheet on sheet selection
  187. SendKeys problem
  188. Check if unicode was installed.
  189. move cursor
  190. 3 Questions - No Answers - Help me please
  191. Select case statement - it will not work and i dont understand why! :o(
  192. Re: Incremental Numbering: Compile Error - Variable not defined
  193. Command Bar & Workbook Deactivate
  194. Copy Cell Routine (FAO Tom Ogilvie)
  195. Toggle Code
  196. Calculation problem
  197. Is there a more efficient way to do this?
  198. how do I put in 2**X
  199. functions
  200. Run Time Error 5 - Invalid Procedure Call or Argument Q
  201. Programatically control a shapes TextBox
  202. Advanced issue; second instance of Excel will not go away!
  203. Months
  204. Horizontal Cells changed to Vertical cells
  205. Dynamic Grouping
  206. returning values from columns to another sheet, based on conditions
  207. Code Signing of Excel VBA projects
  208. Can I lock the selection in the pivot table?
  209. Calculation / Iteration
  210. creating a function
  211. CHOOSE TO STOP A MACRO OR NOT
  212. Looking for range values in another range/sheet
  213. How to make a button VBA code reference other VBA code subroutines???
  214. Crossing Applications - Possible?
  215. Why isn't my pivot table formula working?
  216. .FaceID
  217. Using macro to do same task with different cells
  218. Change event - checking dates
  219. Macro for aligning duplicates in XL97
  220. Reference drive letter that can change
  221. Set-up Automatic E-Mail
  222. Focus after combobox
  223. setting FaceID problem
  224. macro to insert row, copy cells and keep hidden columns
  225. Close form instead of hide
  226. Launching a batch file
  227. This query cannot be edited by the Query Wizard
  228. Finding read-only & pwd protection attibutes of Word & Excel files
  229. copy data to master sheet
  230. 'Loop within a Loop'
  231. issue with concatonating string exporting to excel through C#
  232. Password protecting sheets through VBA
  233. # of sheets in a new workbook
  234. VBA module/function to generate random numbers with specified mean and SD
  235. Create/copy combo boxes in one range if condition is met in a different range
  236. Autofilter/xlVisible problem when counting rows
  237. How to protect VBA code in Excel through C#
  238. Retrieve MS Access DDB Property in Excel VBA
  239. Please Help - "SOS"
  240. Target.Address Doesn't Work in Excel 97?
  241. Worksheet_Change or Worksheet_SelectionChange
  242. Global variables - where do you place them?
  243. Change dollar amount to a negative if another colum has a "P"
  244. Excel PageSetup failure when not logged onto server
  245. Help - old code inherited with project
  246. Test cells within Range("S16:S19) are NOT Numbers
  247. Q: copying PageSetup properties from one worksheet to another
  248. Code for scrollbar to go to top
  249. conditional format with hex2dec
  250. Sudoku puzzle template
  251. Worksheet Data Sorting
  252. Missing library or project
  253. check contain value with macro
  254. Documentation for Investment and Trading Systems including Excel V
  255. Adding extra email address to a single Worksheet
  256. range copy question
  257. To complete Progress Bar indicator level to 100%
  258. Placing a code before Save & Save As
  259. Re: delete hyperlinks from graphical objects in excel sheet
  260. Formatting for Degrees Minutes and Seconds
  261. Switching to a tab in the worksheet
  262. Full recalculation when opening a workbook
  263. Launch "Browser URL" when Cell clicked
  264. Using code from custom menu bar to a Command button
  265. Can you Lookup/Match then copy formating?
  266. how do I edit a record in database
  267. testing for open workbook
  268. Help with ROUND
  269. Code mistake
  270. Protect file name
  271. SOS-How to pass array parameter to Workbooks.OpenText(...) in VC++
  272. Code to pull the value of a Cell of the next Worksheet to the left
  273. use somebody else's self certificate to sign a macro
  274. Reference Class Module in Access from Excel
  275. delete dulipate rows by checking each and every cell in a row till end.
  276. Textboxes
  277. Interesting Office 12 information
  278. search a string and strip out ONLY the capital letters
  279. Delete Blank rows
  280. Excel VBA ".value" / Strange Behaviour!!!
  281. Calculation mode retention
  282. mergercell problem
  283. Activecell offset value with formula?
  284. private sub- which procedure called it
  285. Accept Cell Edit
  286. i want to delete duplicate items in a list using code.
  287. streaming excel read only
  288. User form and send mail
  289. Sheets("sheet1").Range command between workbooks
  290. Getting value of Option button
  291. web query peculiar problem
  292. ListBox Selected Items into an Array
  293. bassfisher
  294. Help with - Get File dialoge code
  295. 2nd try --Macro to transfer data in an Excel sheet (2000) in Access 2000 ( code to replace what wizard do)
  296. part of a code not being executed
  297. Paste Special Values VBA
  298. Linking word and Excel
  299. combo box transparency
  300. new sheets..?
  301. Deleting Named Ranges
  302. excel loop in cell formula
  303. autocomplete
  304. search 2 spreadsheets and compare a value.
  305. Com add-in
  306. Calling a Sheet
  307. delete duplicates macro to color instead of delete
  308. cicling sheets
  309. "Open With" external application macro
  310. Insert Row Macro with Hidden Columns
  311. MID STATEMENT vs MID FUNCTION
  312. How do I automatically copy cell values from one sheet to another?
  313. Top Ranked Opportunities
  314. How can I use a variable as cell address?
  315. Date Question
  316. Expanding Menu items in VBA
  317. Importing a macro programatically
  318. MICOSOFT GIF FILES: patent issue
  319. how change formula with this code?
  320. set focus on txt field
  321. Excel Charts & VBA
  322. Combo Box and Recordset
  323. How To Get A Named Range To Grow
  324. Email
  325. Use VBA to allow you to select a file name from a directory (public drive/server)
  326. Changing embedded file name
  327. Email with notes
  328. Emial with notes
  329. How to automate web login?
  330. Call procedure from another Excel File?
  331. Simple yet wrong
  332. Count depth of Colored Cell
  333. Help with VBA code, making it spacific to one workbook
  334. Re: VBA Array Function
  335. Creating "records" in UserForm
  336. Selective Deleting
  337. How to copy data from several worksheets into one
  338. Rotate a text box?
  339. Need function for dd/mm/yy hh:mm + X working days
  340. resizing a range
  341. reference vsto Excel ListObject in Vb.Net 2005 project/app
  342. lookup value then clear some cells
  343. Use VBA to automatically email from Excel
  344. StatusBar fails to update
  345. Getting data off a form onto a worksheet
  346. Cannot get the parameter option to work in Excel query
  347. Suppress Alerts - Update Links
  348. Retrieving all worksheet names into a new worksheet
  349. Totalling Range Values
  350. spreadsheet locks after display of msgbox
  351. Create sequential file name for uploaded template
  352. VERY Basic Define Variables Help Needed
  353. Issues with Hyperlinks in XL97
  354. Report Criteria
  355. Question about filename formula ..
  356. Visual Studio Tools for Office - CountIf, Ctrl-Shift-Enter, Array
  357. ADO connection question
  358. Allow user select file to copy data from "Application.GetOpenFilen
  359. Update Values as soon as a Worksheet becomes active?
  360. Re: Great Documentation for Investment and Trading Systems
  361. Shapes.AddNodes Error on adding next point <0.25 away from prev po
  362. random sort
  363. Determining End Of data
  364. Remove Macro
  365. sorting columns
  366. Listbox Column Heading Help
  367. can't close files opened in an excel application??
  368. Passing Parameters to Word from Excel
  369. "Rotating" / Pivoting / tranforming Data
  370. Is there a command in visual basic to move down one space, e.g. m.
  371. Need formulas
  372. unable to copy sheets
  373. Excel Color
  374. how to reset the activesheet usedrange value
  375. worksheet data filter
  376. Find/Lookup data within hidden cells
  377. if anyone wants office 2k3 sp2
  378. Importing external data
  379. Search text & record number of times it appears
  380. Referencing cells that array covers
  381. Hyperlinks
  382. What was the default name for the Auto_Open() module?
  383. Use a variable anywhere in the workbook - How to create?
  384. Change Options under Tools>Optioons>View Tab When User Opens Workbook
  385. change reference for 'visual basic for application' in VBA editor?
  386. picking a userform to show
  387. Schedule table
  388. retrieve data from spreadsheet using combobox in dialoguebox
  389. Won't Work with Excel'97 - What Will Q
  390. using worksheet in same workbook for query
  391. COM Add-in - Simple Function
  392. Combo box background colour
  393. Change links/reference a new file
  394. VBA in Excel 2003
  395. Limit number of entries in quiz sheet
  396. Gain access to Email
  397. Check if Shortcut created
  398. Insert/delete rows
  399. Print "Landscape" in explorer
  400. Help with error code
  401. Transfer Data from Excel 2000 to the Access data base
  402. Cell Codes
  403. macro to save wookbook add 1 to to a ref No. clear cells
  404. Closing Excel - no save prompt
  405. Search option
  406. Macro to return to Current Sheet and Cell
  407. If statement to stop Macro
  408. Search & Extraction of Cells in a Workbook without opening it?
  409. proper way to create a userform
  410. SumByColor Macro...
  411. Calculation Problem
  412. Copy formulas using input box value
  413. Simple Macro, works in Excel 2002, 2003 but won't work in 2000
  414. How to avoid counting blanks in a list
  415. Re: Distribution loop
  416. can I insert a Sort "Button" in a cell within Excel
  417. Runtime Error Msg: "Cannot empty the Clipboard"
  418. Copying list values
  419. problem vba dialoguebox and database in excel
  420. How do I Advancing to next column/cell in a Sheet.range(x)?
  421. Automated range selection
  422. Compare strings of data
  423. How can I delete unprintable characters using VBA in Excel?
  424. Change the Value of cell to Whole Number
  425. can you add a shortcut to a macro after it's been made
  426. Combining VBA code for columns
  427. From MMDDYY to YYMMDD
  428. Prevent virus scan of Excel workbook
  429. VBA Find and Replace (Tidy Up)
  430. Macros are disabled
  431. Select a column based on a cell entry
  432. Add to Shortcut Menu
  433. How do I write an IF function to accomodate equal to or more than
  434. How to locate a new outlook folder
  435. Call Statement and Return Value
  436. Sort on close - Possible?
  437. Opening a PDF from Excel
  438. Programming for a Dynamic 'Where' clause
  439. Excel and Outlook
  440. Need Help ASAP
  441. loops
  442. Changing path of button macro assignment
  443. Printing -- Page Number Continuity
  444. Range.ListHeaderRows
  445. Can you create a macro to hide rows with zero values?
  446. offset problems
  447. Program to make cell a formula
  448. use variable in Workbooks("book1").Worksheets("sheet1").Range("a1"
  449. VBA code for Internet User ID & Password
  450. Copy Worksheet with Code
  451. big problem selecting and saving data
  452. Outlining with condition? part 2
  453. Open to Worksheet
  454. User form
  455. copying dynamic range based on cell outside of range
  456. Block the cut option
  457. can anyone suggest a good tutorial?
  458. file save problem
  459. Vlookup in multiple arrays
  460. Populating an array from a integers values column rows
  461. Getting readonly & password properties without opening file
  462. Cell jump
  463. How do I change format
  464. Creating a labor proforma.
  465. HELP!! Change formulas programmatically -- all I get is text!
  466. Changing text in a Text Box
  467. Selection.Interior.ColorIndex = 0 Error
  468. question about debug.print
  469. AdvancedFilter with VBA
  470. Return results based on multiple criteria
  471. Values and Formulas - Problem - High Importance
  472. Build an excel application
  473. Need help programming some variable ranges
  474. Re: Argument for contain instead of equals
  475. Passing array from Access to Excel function
  476. Using VBA to colour a cell
  477. Spreadsheet save using a macro
  478. Limit characters in a word/text box in excel
  479. Move a workbook from one instance of excel applicaiton to another
  480. Move Records from Sheet1 to Sheet2
  481. transfer spread sheet
  482. time and auto macro run by setting time
  483. Checkbox problem
  484. Checkbox problem
  485. Textbox Question
  486. Run/Execute string expression
  487. sort and tally routine
  488. totally newbie to VBA need help
  489. Hidden Cells Text Revealed - Bug?
  490. OptionBox error checking
  491. creating a summary from a data dump
  492. Please Help Wth Cell shading
  493. Setting Row to be = to another Worksheet?
  494. SuDoku
  495. Picture in Cell of Active Sheet
  496. filtering out data using other worksheet
  497. Inserting Rows with the change event active
  498. Runnings SQL Queries from excel
  499. Error: Object required
  500. columns hidden
  501. Counting number of identical values (or text) in a range
  502. Harmonize date format
  503. Context Menu
  504. Add Toolbar to workbook
  505. Highlight wrong entries in SuDoKu
  506. Event Procedure - Extending code
  507. How to store text to variable
  508. Invoice
  509. data validation list arrow style
  510. formula with text string
  511. Pause code, wait for input, no input received, carry on with the code
  512. Match Date Search
  513. Daily updates of pivot tables
  514. Run time error '91
  515. counting everytime red cells turn white per column
  516. How do I set the rowsource for a ComboBox for a dynamic list?
  517. how to execute macro from vb 6.0 code?
  518. Change property of comments only
  519. Groups in Excel VBA
  520. Tough One - Return output from Dos Process without writing to file
  521. Conditionallly formatting a textbox
  522. inserting page breaks automtically
  523. Combo Box
  524. vlooukp horizzaontal...
  525. Tab names
  526. create a folder using a macro
  527. PASSWORD PROTECTED DOCUMENT
  528. Running Standard Module Code from Dataform
  529. Help on Workbook close and workbook save events
  530. Show all dependents
  531. Need Help Setting Cell Values
  532. Charts and VS2005 B2
  533. Security and Macro Enable help
  534. Traying something new
  535. trivial summary diagrams
  536. Excel macro ~ open form ~ new record
  537. Repeat Macro until Empty Cell Reached
  538. defining a range of cells in excel using cell content
  539. Read,Show,Update,Format & Save a text file.
  540. occasions
  541. FormulaR1C1 - autoconverting strings to numerics
  542. Auto Filter Delete Rows by Criteria Doesn't Work Range To Complicated
  543. Excell HELp PLSSSS
  544. Printing Macro?
  545. Hyperlink Code
  546. determine the active workbook containing a specific sheet
  547. it works, it doesn work, its works....and so on.
  548. Form or Spreadsheet?
  549. continual updating
  550. Test if cell has diagonal borders
  551. Much difference between VBA in XL2002 and XL2003?
  552. macro
  553. How do I set up a macro to automatically delete certain cells?
  554. Allow only numeric data in certain cells & only text strings in others
  555. Make Table Query limitation
  556. Problem with downloading data in Excel 2003
  557. Insert Template Sheet?
  558. Replace "." to ","
  559. Dynamic Cell Nameing
  560. Find an existing file.
  561. Getting a count of formula results only.
  562. Excel 2003: Grabbing a dataset from a webservice and then sending to a webservice?
  563. Is it possible to create a custom Task Pane view?
  564. Comparing data of two sheets
  565. Conditionally Formatting a Cell
  566. VBA module not responding!??
  567. copy/paste
  568. Is there a SUB like "Sub Worksheet_De-Activate()"?
  569. Creating an excel macro to open and save sheets to a different directory
  570. Automation Error
  571. Can you use a Range $N$xx:$Q$xx in Target.Address?
  572. Loop???
  573. Identify Load Drive
  574. count down timer in text box
  575. Get Values from Closed Excel
  576. using a go to the last row in a formula
  577. Set formatting variable
  578. Waiting for the calculation to be completed
  579. Calendar Control - limiting min & max
  580. dynamic ranges
  581. Public declare for Set....
  582. Calling Excel macro from web link
  583. WorksheetFunctions
  584. Filtering data to a userform listbox
  585. Macro for Custom Header
  586. Who has this (shared) workbook open
  587. Showing form
  588. References keep becoming unchecked
  589. How to get ActiveCell's address?
  590. Insert A Row
  591. Delete Row IF
  592. Blocked e-mail attachments
  593. Repeat: Active Cell's Address
  594. If syntax to test if command button exists
  595. How can I force my code to wait
  596. Question on autonumber
  597. How MsgBox can show address?
  598. lock a range question
  599. Displaying AutoFilter criteria
  600. move contact name for specific Company
  601. macro
  602. Counting Positions
  603. Form Input, with (listbox) review then copy to worksheet
  604. Automatically save report to new file name each month
  605. How to get text in cell into variable
  606. PivotTable controlled by more than one page field item
  607. generate all subsets (2^n array)
  608. How do you get a row number is a Cell?
  609. find row number
  610. Changing Pivot Table Field Name
  611. Sorting/Searching & returning data
  612. Copy "active"
  613. shared on/off, read only off/on
  614. conditional format for rows according to the result of a formula
  615. do anybody have a sample code for executing excel macro from vb code?<eom>
  616. Free ebook - excel vba programming
  617. end call macro
  618. Win XP Logon Name
  619. Compile error on "Right", missing Library
  620. IF statement to add data when blank
  621. Database Connection
  622. How cell ranges are handled by worksheet functions/row column matc
  623. "Folder Select" Dialogue - Opening multiple files from selected folder
  624. Rename multiple sheets
  625. after refresh query
  626. Totaling range help needed
  627. shell in synchrone mode
  628. Setting a range on a particular sheet
  629. Protect workbook & keep change history
  630. Text File error message
  631. VBA to run queries in 5 different worksheets
  632. Problems Setting properties of class module
  633. Excel to Word
  634. run-time error '9': Subscript out of range
  635. Client Authentication
  636. Formatting Cell Ranges
  637. Change event causes program to freeze
  638. VBA controlled conditional format
  639. GIF, JPEG, TNF -format
  640. Finding Cells
  641. Cells updating - can it be stopped?
  642. How To Print the contents of a TextBox
  643. How do I get beyond the upper limit of 65,500 records on Excel?
  644. Re: Application
  645. lookup cell value
  646. Run-Time error 13 on a FileOpen command
  647. Monitor Changes
  648. Export excel table to acess table using VBA Code
  649. Unable to Set XValues property of the Series class
  650. Determining weather a macro will run or not
  651. Custom Function #Name Problem
  652. Calling excel macro from VB 6 app problem
  653. Find Character & Highlight Cell
  654. Sudden Excel Problem after XP SP2 install
  655. compare string to column
  656. Repeating macro with dynamic range
  657. help please..... can this be done
  658. Column..._Global failed error
  659. "Can't move focus..."
  660. Auto expanding Range
  661. Search by filter using macro
  662. looping for a condition
  663. Brainstorming possible file errors/problems
  664. very urgent macro problem
  665. macro for processing one excel file and saving it to other
  666. Unselect range
  667. ADO recordset problem with stored procedure
  668. Need help: how to semi-automatically replace an empty value in a row with a row average?
  669. Change AutoShape Text Color in VBA?
  670. Check for value before printing...
  671. Can VBA process messages posted to its main form?
  672. Past Special changes results for macros... how to prevent this
  673. ADD A BUTTON
  674. Log Workbook
  675. 2 different fonts in one cell .....Possible??
  676. Match
  677. checking if an url exists
  678. .OnAction points to wrong file.module.procedure
  679. Help me please
  680. XLodbc.xla to ADO
  681. How do I :
  682. Conditional Format on returned value
  683. Deleting graphs (if existing)
  684. Can a Macro contain an IF statement? How?
  685. How to use a opened web page for web querry
  686. recognize USB drive
  687. Select individual cells only?
  688. Help with a complex formula
  689. background
  690. Copy data from sheet 1 to sheet 2 based on day/date
  691. Extract data from an old Quattro file
  692. Excel programming- VERY VERY URGET
  693. sub total
  694. Excel Vba Programming
  695. unique text additem combobox
  696. date in combo formatted as number
  697. Opening XML files using Office 2000 or VB6
  698. macro for copying
  699. Array function, two dimensions??
  700. ReferencesEvents
  701. Array function, two dimensions?? and worksheet arrays
  702. 2 dimensional array and freq function?
  703. Suggestions/Codes on Data Transfer
  704. cursor behavious when restricting selection to unlocked cells
  705. Open Worbook and Disable Macros
  706. VB6, How do i open (instead of edit) an excel OLE doc when it is double clicked?
  707. stop from running everytime a cell is changed
  708. Verify if a workbook exist with a macro
  709. Trouble returning to original active cell
  710. Ensuring Macros are running
  711. Trouble turning off sheet updating and returning to original active cell
  712. How do I relegate the curser movement in a formula?
  713. disable unhiding columns
  714. DialogBox Layout
  715. Custom Keypad
  716. email on condition from "import external data"
  717. Invoke macro for workbook from web link
  718. Compile error
  719. Class Events
  720. Picture control in Excel/VBA ?
  721. How to view properties of a cell
  722. Advanced topic: Communicate via IP address
  723. text import inhibit required
  724. Retrieve or extract cell formatting information using VBA
  725. Execute code after printing with the BeforePrint event
  726. Deleting lines with a variable.
  727. Looping folder changing - Save Preview Picture
  728. Worksheet_SelectionChange(ByVal Target As Range) questions
  729. Working with ranges
  730. sort colums
  731. Using Offset with Autofilter data
  732. Error 1004
  733. Hiding rows - Excel 2000, 2002 vs 2003
  734. Another approach - Program Command Button
  735. xlDialogOpen get it to return Path
  736. Adding a menu
  737. starting another program
  738. FTP from Excel
  739. Run time error '-2147467259 (80004005) adding icon
  740. when I download from the web a "date"...
  741. How do I edit sheet while a macro is running?
  742. code for hiding formulas
  743. Transposing text in text file to Excel Sheet.
  744. Import n .csv data
  745. SP2 & Self signed Digital Certificate
  746. Copying values from one Workbook to Another
  747. Help using form as menu
  748. VBA functions - faster than worksheet formulas?
  749. Support Article: 305342 - Workarounds provided DO NOt work as expe
  750. skip automatic update question to excel
224