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

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