PDA

View Full Version : Excel Programming


Pages : 1 |  2 |  3 |  4 |  5 |  6 |  7 |  8 |  9 |  10 |  11 |  12 |  13 |  14 |  15 |  16 |  17 |  18 |  19 |  20 |  21 |  22 |  23 |  24 |  25 |  26 |  27 |  28 |  29 |  30 |  31 |  32 |  33 |  34 |  35 |  36 |  37 |  38 |  39 |  40 |  41 |  42 |  43 |  44 |  45 |  46 |  47 |  48 |  49 |  50 |  51 |  52 |  53 |  54 |  55 |  56 |  57 |  58 |  59 |  60 |  61 |  62 |  63 |  64 |  65 |  66 |  67 |  68 |  69 |  70 |  71 |  72 |  73 |  74 |  75 |  76 |  77 |  78 |  79 |  80 |  81 |  82 |  83 |  84 |  85 |  86 |  87 |  88 |  89 |  90 |  91 |  92 |  93 |  94 |  95 |  96 |  97 |  98 |  99 |  100 |  101 |  102 |  103 |  104 |  105 |  106 |  107 |  108 |  109 |  110 |  111 |  112 |  113 |  114 |  115 |  116 |  117 |  118 |  119 |  120 |  121 |  122 |  123 |  124 |  125 |  126 |  127 |  128 |  129 |  130 |  131 |  132 |  133 |  134 |  135 |  136 |  137 |  138 |  139 |  140 |  141 |  142 |  143 |  144 |  145 |  146 |  147 |  148 |  149 |  150 |  151 |  152 |  153 |  154 |  155 |  156 |  157 |  158 |  159 |  160 |  161 |  162 |  163 |  164 |  165 |  [166] 167 |  168 |  169 |  170 |  171 |  172 |  173 |  174 |  175 | 

  1. minipops_quiz logoquiz - cheats
  2. ActiveX as picture
  3. Program timing
  4. EntireRow.Hidden
  5. class range...select...(reserved for expert)
  6. function CELL( )
  7. Combobox
  8. Re: Button for wave file
  9. Checkbox Control to Hide/Unhide Worksheet
  10. Re: create multiple rows using a variable in a cell as source
  11. Re: extend list or database
  12. Date only to appear if text is added to previous cell
  13. open outlook email from excel?
  14. Loop thru files in DIR, delete worksheets & reset worksheet Name property??
  15. Loop thru multiple files - Modify worksheet visible property
  16. variable calling in different modules.
  17. Excel97 SDK: How to build a multi-lever menu using Excel SDK?
  18. MACRO TO COPY AND PASTE!
  19. Close file without Save Changes dialog box
  20. Is it possible to permutate in Excel
  21. one line macro to enter password for workbook
  22. ActiveX Error w/Calendar Control
  23. Referencing a new worksheet
  24. macro - security issue
  25. Custom Autofill
  26. countif(and) problem
  27. Paste Down
  28. where are my VB codes
  29. Re: Sorting referenced cells
  30. Vlookup
  31. copying cells to another workbook if the contain spacific words
  32. Excel VBA talking to Excel COM Add-in
  33. Excel Changes File Name During Code Execution
  34. Trapping the Enter Icon
  35. Grab Password Name
  36. Application-defined or object-defined error
  37. Sorting referenced cells
  38. Problems with SendMail ?
  39. Moving cells
  40. launching macro on workbook loading
  41. to STEVE from CAROL
  42. Delete Rows
  43. How do I draw lines..??
  44. Excel 97 VBA on Win98 Out of Memory Error
  45. Grouping and Hiding of columns functionality
  46. Printer Object
  47. HELP - simple VBA property causes Excel to crash
  48. Renaming Worksheets with For Each Loop
  49. flip an autoshape using VBA- recorded macro doesn't work
  50. enable spell check
  51. Creating Custom Function: TRIMSTDEV
  52. Using Macro To Merge Two Columns
  53. question on setting Range
  54. Read data from ascii file
  55. Passing Userform as an argument to a procedure
  56. Excel over HTTP or SOAP question.
  57. Create matrix data from two columns?
  58. Target cell - unexplainable results
  59. Re: Hide (visible+AD0-false) all open applications?
  60. EOF Range
  61. Clearing Dropdowns In A Worksheet
  62. Subtotals in Excel object model
  63. Response to Steve for Formulas not "saving"
  64. How to sum selected values from a table?
  65. need help adding named range as new series to a graph
  66. Amend form code to allow an option
  67. Macro help
  68. VBA - BeforeSave - NEED HELP
  69. vbCancel
  70. Count Spaces In A String
  71. Apply a function to the entire column
  72. how to remove a reference from Excel project?
  73. IsError() Not Working
  74. Loop hits Row 8 and goes to End Sub??
  75. accessing SQL server from Excel/VBA (instead of ODBC)
  76. Fail if macros are not enabled?
  77. Parsing the directional out of addresses using nested IF .
  78. Re: removing special characters
  79. Data Anaylisis does not work in Embedded Excel Table in Word
  80. How do I get Hyperlink from a cell
  81. Parse raw data
  82. Determining end of user-selected range
  83. Saving Documents from templates to specific places
  84. Macros not appearing in the Tools > Macro > Macros list
  85. Dropdowns
  86. mso-page-orientation asp excel
  87. Formulas not "saving"
  88. how sendKeys to Acrobat Reader
  89. copying macros
  90. Column Code
  91. Sub From Yesterday
  92. DOH!!!! I'm a BONEHEAD
  93. Active X
  94. Re: What's Wrong With This Function?
  95. Excel code to Wait until Word finishes printing before closing
  96. Subject: Re: Opening a PDF document from Visual basic
  97. How to fill adjacent column using a table lookup...
  98. adding blank rows
  99. Adding Ranges, increasing worksheets
  100. Opening a PDF document from Visual basic
  101. Forms - Set Control Source to insert data in next blank row
  102. Can This Be Done With A Macro?
  103. creating an "inferface-table" into one cell
  104. Getting the previous cell value after changing a cell
  105. pls help: short cut menu doesn't show when right click mouse
  106. Selecting all Cells with Data?
  107. Where's the !@#$%^&*() manual?
  108. Checking if file exists in VBA
  109. sum up range
  110. The end of VBA?
  111. VBA code to scroll all the way to the top
  112. pls help!! copy -paste to another sheet. getting the sum
  113. Checkbox BackStyle Bug or Not?
  114. Using UsedRange as limits in a For Each loop but for cells on another sheet ?
  115. csv file into vb.array
  116. Excel and colours
  117. Detect any Volatile UDF
  118. saving excel file as tab delimited text programmatically
  119. Code Changes Not Executing
  120. Good VBA reference guide
  121. Formula to change Negative numbers to positive
  122. type variable as argument of a sub
  123. How to call the TextImportWizard?
  124. Execute a command line app but i want a string returned.
  125. Array size limitation?
  126. Html in Excel
  127. Html in Excel !
  128. Excel to Word document
  129. Screen Updating
  130. Moving chart window in macro
  131. user form
  132. Problems Attaching Macros to Command Button
  133. Disabled Enabled
  134. How do I change a function's otional parameter default values programmically
  135. Deleting shapes crashes for me. (Excel 97 vba)
  136. Worksheet name = cell value
  137. Re: Hide (visible+AD0-false) all open applications?
  138. Menu problem
  139. Docs for Excel object model with p/e/m
  140. Workbook_Open event and combobox state storage question
  141. Exel not loading every 2 days
  142. dynamic substitution of worksheet reference
  143. Msgbox question
  144. Refresh rate in getting external data from file
  145. looping formula - r1c1 problem - Con't
  146. Populating multicolumn listbox the wrong way
  147. Help Copying from Outlook to Excel
  148. Re: Print Preview Question
  149. Re: Hide (visible+AD0-false) all open applications?
  150. file path
  151. Just learning VBA..
  152. continued combox frustration
  153. auth data not passed to "transferring file..." dialog
  154. Help with a project. Help me please.
  155. Macro Polo
  156. excel 97: linking 2 combo boxes
  157. References In Excel
  158. Copy contents of Range to other cell
  159. Macro or Script???
  160. Hide (visible=false) all open applications?
  161. Combining Excel Workbooks and worksheets
  162. Fonts for E-Mail Addresses
  163. Excel Cells to specific fields in word document
  164. Can I Choose a Font for an InputBox?
  165. Pivot table field formatting
  166. Help files for Excel 2000
  167. Send Data to Access
  168. Circle Invalid
  169. Full Screen Mode
  170. Excel stealing focus
  171. Excel Spreadsheet into .exe
  172. Thanks!
  173. Listbox on click
  174. How would I create a routine that runs every 15 mins?
  175. User Defined Function Not Available In Other Worksheets
  176. If .,AND ... Then failure
  177. Convert Excel to text in VB6
  178. XL2003 Add Ins
  179. I lost all my excel files along with the excel program, how do I get it back
  180. Referencing the secondary y axis scale values
  181. Help exporting worksheets/data to a workbook.
  182. vb macro
  183. emailing Spreadsheet?
  184. Merging Worksheets in Excel
  185. TextImportWizard & VBA
  186. error trap
  187. can the following be put in an array
  188. Formula
  189. obtaining data from Access
  190. Extractind Data (Updated Emaple)
  191. CheckBox controling a ComboBox
  192. User-Defined Excel Functions
  193. Simple Excel Macro - Please Help
  194. XL2000: Shape object events
  195. Detect Group mode
  196. Formula, I almost have it
  197. end of month to 24th
  198. dropdown list that take data dynamiclly
  199. Re: Looking for code to browse Dir & Files
  200. Merged Cells Autofit - code amendment
  201. Data Input Execl Form
  202. Macro recording does not work properly
  203. Determining Cell Types in Excel - exceptions
  204. Compatibility
  205. Help me out!
  206. Unorthidox error messages in macros
  207. Recording Software recommendation
  208. Unloading User Forms?
  209. Automatic sheet naming
  210. Default month
  211. excell 2000 to access 2000
  212. macro stops copying sheets into a book after the 11th sheet
  213. variables in row and cell functions
  214. excel 2000 VBA Password
  215. Extracting Data (Updated)
  216. Constant
  217. Recalculating with a new total
  218. maximixe and minimize
  219. Function Max
  220. Conditional find
  221. looping formula - r1c1 problem
  222. text to columns
  223. Detect when Active Cell Changes
  224. purchasing Excel
  225. Charts to Word
  226. Scope of Public Variable
  227. printing
  228. Refresh & backup tuning!
  229. Re: Print Additive to file
  230. Can I use this Outlook control in Excel?
  231. Forgot to paste!
  232. Column property in MultiListbox
  233. Extracting Data
  234. No Buttons on message box
  235. Using Word and Excel in one Macro
  236. Cell change
  237. Nested with structure
  238. Excel and Colours
  239. From VBA-GUI textbox to cells
  240. from end of month to 24th of the month
  241. Open external program
  242. O2OLAP Market Comments - October 2003
  243. Countif Function ">75%"
  244. path user defined chart
  245. What data type?
  246. Cannot get appropriate Event fired with WinSock control
  247. Attributes of a cell
  248. Error no. 1004
  249. Macros stripped out of a file
  250. Web Query address parameter
  251. Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN
  252. Hide Formulas.
  253. Application file search error in Office XP
  254. Named Ranges
  255. Stop macro when open excel from VBA
  256. Changing consistent Cells
  257. looping Ranking formula - R[1]C[1]
  258. Multiselect Boxes
  259. Web Query address parameter
  260. Where do I paste this Code?
  261. pivotTable and filtered list
  262. Save a file and send as an email - written into macro
  263. Counting Formated Cells
  264. excel scheduler
  265. listbox.value not equal to listbox.list(listbox.listindex,0)
  266. Hyperlinking to an Autoshape?
  267. activate PublicConst
  268. Pretty basic VBA help....if you know how!!
  269. excel manual reference
  270. testing the value of a cell
  271. Excel Error
  272. VBA Forms in Excel (viewing a list of data via a form)
  273. Help Please! Thanks in advance.
  274. Code to make graph invisible / invisisble
  275. Cell Change
  276. Subtotals in object model?
  277. looping through a range
  278. MS query
  279. Re: Driving me crazy!
  280. C++ Client for RTD Server
  281. Re: Input Box won't show when Application windowstate minimised
  282. GetSaveAsFilename
  283. Error Loading dll
  284. is there a way of saving a filter?
  285. Excel 2000 and 2002
  286. A '.Select' question
  287. AVI FPS
  288. slider code
  289. Copying and then reselecting a workbook with VBA
  290. Format multiple sheets in VBA
  291. exporting/coverting excel to pdf?
  292. Newbie Help
  293. Conditional Statement-w/Objects
  294. Color Chart Axis
  295. VBA
  296. New excel file with VB
  297. Problem with Saving format of the Excel
  298. Looping question for 2 columns
  299. userform textboxes again
  300. Is there a method for refreshing an object variable?
  301. Reading Data From Series of External Workbooks
  302. Macro to Define Range Name
  303. userform textboxes
  304. Change the value of a cell
  305. forcing complete calculation
  306. Looking for code to browse Dir & Files
  307. Insert SUM function for range
  308. Multipage TransitionPeriod
  309. filtration of worksheets tallying 2 million seperate phone numbers
  310. 2 questions - Creating a TimeBomb - Securing Code
  311. Userfrom textboxes
  312. Userfrom textboxes
  313. Reason for calculation...
  314. formating multiple excel .csv files ?
  315. Help Creating a Macro
  316. Page setup for multiple pages
  317. CDbl function
  318. getting cell values from worksheet
  319. Opening Excel via Access
  320. Spam is a big problem
  321. print preview menu
  322. Conditional Formating
  323. Activating A Query from An Input Box
  324. Conditional formatting
  325. Select range using criteria
  326. Load Macro at start up?
  327. Need A Formula
  328. problem in excel 2002 and windows xp
  329. Re: Load Macro at start up?
  330. Re: Load Macro at start up?
  331. Inserting Rows
  332. MsgBox carriage return
  333. Lotus123 to Excel
  334. Re: Convert a negative result to a positive result
  335. Re: Convert a negative result to a positive result
  336. Length of Used Column
  337. Re: Convert a negative result to a positive result
  338. Publishing A Web Page
  339. Sorting a Work sheet - using drop down box ??
  340. Operating on a Selected Range
  341. Macro drops date formatting to csv file
  342. AutoFilter Custom Conditions
  343. count # of elemnts in a column
  344. Comparing Values Needs Correction
  345. Keypress nest
  346. How I disable a command button until cell has value?
  347. How to Copy Formulas not Values ...
  348. Batch printing
  349. Create Message Box without buttons
  350. Sort Dialog Arguments
  351. Activating a workbook help
  352. short cut menu doesn't show when right click on mouse
  353. Batch printing
  354. Newbie Q : With VBA Read cells from unopened sheet
  355. Workbooks.OpenText
  356. get path - save new file - same sub-directory as existing file
  357. UserForm Problems
  358. Programatically retrieve a list of public functions.
  359. How to select a certain item of LisVview control?
  360. Excel's built-in dialogs
  361. data from excel to access
  362. Carriage Returns - Detecting
  363. TRIM function - for the whole sheet
  364. Formatting in a Message Box
  365. Excel VBA
  366. Search for hexadecimal values
  367. Update links and SaveAs?
  368. sequential number generator
  369. Using SUMIF with linked sheets
  370. Shell Command to initiate Linux program
  371. Filtering dates in two different columns
  372. Customising the Task Pane in Excel Office XP
  373. After using Acrobat Distiller object, certain formatting causes error
  374. Creating Multiple ODBC System DSNs from an Excel Spreadsheet
  375. Excel Expert
  376. Re: Input Box won't show when Application windowstate minimised
  377. DTpicker problem
  378. Find size of array passed to user-defined function
  379. How do I highlight a cell?
  380. Removing Checkboxes Programmatically
  381. Search an array
  382. Selecting paper source
  383. Repost: Dop to next visible row when filtered?
  384. Color of selection in combo box
  385. Autofit on rows within a specifed range
  386. Using CreateEventProc fails when used with a Worksheet.
  387. VB 6 Toolbar and Microsoft Excel Object 9.0
  388. What language can XLL be written in?
  389. Continuous Time/Date Updates
  390. Date problem from code to text box to spreadsheet
  391. Excel macro
  392. Input Box won't show when Application windowstate minimised
  393. Print Preview Question
  394. Need help on How to programatically Import VBA Project Excel Objects, Forms, Modules
  395. User sets range
  396. Passing array to a function
  397. opening & writing to Word from Excel
  398. Easy Question
  399. encoding Today's date
  400. Using Microsoft Query to Extract Data
  401. reading xls from asp
  402. Select a range
  403. date validation
  404. Re: Copying Variable Ranges
  405. Format -Time Error on Excel 97
  406. Enumerating Printers
  407. Lookup Across Multiple Lists
  408. Do Event
  409. Strange Problem: Opening Excel using VB appends 1
  410. Creating/modifing Outlook Rules from Excel
  411. Complicated formula
  412. Re: Removing and Applying protection in VBA
  413. How do I make a macro present (like an add-in) on opening Excel?
  414. Multi-Users and VBA
  415. changing chart title via vba?
  416. changing chart title via vba?
  417. Macro to create folder
  418. Please Help
  419. change event/after update event??
  420. Minimum value location
  421. A pointer or two needed using userform
  422. Freelance
  423. Where Clause Errors
  424. Function that returns decimals only
  425. Activation combobox problem.
  426. Next in Series
  427. ODBC import screws up fx
  428. VBA and ActiveX Licensing .. ?
  429. Select Data only
  430. Office97 controls seems different on Office2000/XP
  431. Removing decimal from a cells value
  432. Selecting Rows in Pivot Table
  433. Copy cell with individual formatting
  434. ODBC System DSN Connection
  435. Irregular VBA error with data validation
  436. Can excel make a phonecall from a cell?
  437. Data analysis Regression in vba
  438. Protect Cell automatically
  439. copy 3 sheets & save them into new workbook
  440. Printing a Word doc from Excel
  441. Mailing in Excel
  442. combobox change event
  443. "Run-time error '1004'" Method 'Range' of object '_global' failed.
  444. Copy Until Blank
  445. Extract a cells format and apply to a variable
  446. Excel properties
  447. RefEdit control bug
  448. Solver in VBA
  449. detecting the state of filters
  450. "Programmatic Access to be Denied" displays when running macro on excel in XP
  451. Tricky Formel (counting days in combination with lookup)
  452. Addins - calling functions
  453. Cell to dialer script with win xp
  454. Automation and Diagrams
  455. Addressing the Excel file in which the macro is present.
  456. For Each with Range object in Excel 97 SR-2
  457. find if there is a particular folder in a path
  458. Use only VBA - request for experts
  459. Copying a range to the row below
  460. VBA's Future
  461. Urgent: Object Explicit Error
  462. Copying Functions & Worksheet
  463. Freelance
  464. Adding Items To Active X ComboBox on Sheet
  465. opening files from explorer with startup file and addin
  466. add-in absolute path
  467. variable counter/total
  468. EXCEL "EntireColumn.AutoFit" Help!
  469. open sheet on workbook open
  470. please help
  471. activating workbooks
  472. Macro does nothing if ran in certain worksheet?
  473. Sorting Excel combo box list
  474. inserting page number in cell
  475. macro to hide rows based on formula?
  476. Dynamically set Sort keys
  477. help
  478. Can Excel dial a phonenumber from a cell?
  479. Oracle data to excel
  480. protect - macro?
  481. using odbc in excel
  482. programing reference worksheet
  483. Current row/record shown when opening data/form
  484. Delete sheet code
  485. Setting printer paper
  486. Spell checker
  487. Display sheet upon exit
  488. hyperlink is not working
  489. VBA 6.0 vs. 6.3 Help THIS SUCKS!!!
  490. Get items in ListView in columns
  491. Print Preview Input Range or From List
  492. On going onto a sheet run a macro?
  493. dynamic variables
  494. start a macro from a func
  495. Ghetto script - need help! one last thing
  496. Running For Each-Next on Visible Cells Only
  497. VBA - hiding rows
  498. vba..finding first non-zero value in a row
  499. VB Macro
  500. ControlSource Compatibility VBA - VB6
  501. formula problem
  502. howto_find _values_in_sum?
  503. Naming a variable in a file path
  504. automate find & replace
  505. Determining selected worksheet
  506. PivotTables' name? And the PivotChart
  507. Add text to a rectangle in VBA
  508. Excel worksheet startup
  509. LINK TO OPEN EXCEL FILE !
  510. LINK TO OPEN EXCEL FILE !
  511. Re: Copy only bumbers from cells
  512. Bogus Excel 2002 Macro Security Message
  513. margins do not fit page size error
  514. Sub: Help needed!!!
  515. custom paper size
  516. Another Speed Problem!
  517. excel macro
  518. Data form with multiple records
  519. copy sheets to another file
  520. Re: macro adding a number to a number already in a cell
  521. Re: You don't have to be rude
  522. check if file is in particular folder
  523. insert excel vb script
  524. macro to disable the printpreview menu
  525. align text in the center of a range of cells
  526. ActiveX Control Button
  527. You don't have to be rude
  528. OnTime Problem
  529. SUNPRODUCT
  530. Need Macro To Copy & Sort
  531. Need Macro To Copy & Sort
  532. How to load another XLL in the XLL?
  533. Show image
  534. Applying protection to an Excel Expense Report
  535. Case statement
  536. How disabling sounds when calling a shell program?
  537. Recognising Text formatted cells in code
  538. Excel File format List
  539. Speed?
  540. changing the caption of a label
  541. "Too Many Different Cell Formats"
  542. how to make macro not dependent on datafile which has date as its part.
  543. How to print 25 rows on each page in Excel
  544. IP Addesses
  545. Limiting decimals text box
  546. dealing with multiple named worksheets with one macro
  547. Timer
  548. ComboBox Question
  549. trending data from a csv file with one macro with changing worksheet name.
  550. difference between 2000 and 2002?
  551. VBA question
  552. How do i change the graph source data to a variable dependent on the value in a cell
  553. operations on ranges
  554. Beginner Books
  555. How to download: "Microsoft Forms 2.0 Library"?
  556. how2 paste into a userform text box?
  557. Re: CommandText Property
  558. how to find cell?
  559. Reluctant Macro
  560. View Row Data in UserForm / Edit
  561. user changes sheet1 - have the macro xyz run on sheet3
  562. listing items from listbox
  563. Here we go again.
  564. Anyone mastered RTD techonology yet?
  565. Formula needed
  566. Problème avec Range(x).Select
  567. Menu question + FaceId questions
  568. Microsoft Query - Excel - Compute BY
  569. Finding first non-blank cell
  570. graphic converter?
  571. Saving a file with VBA that references current file name
  572. Auto fill?? Help??
  573. SumProduct Formula
  574. Copying macros
  575. sorting questions
  576. Delete Rows above keyword
  577. macro to expdite editing cell
  578. No success deleting modules
  579. Save Excel to CSV with Quotes?
  580. Setting TopMargin Property in VBA
  581. Shorter and faster?
  582. All Possible Combo's ?
  583. Development Tools Available for Excel
  584. Delete rows if they are empty
  585. Append to open CSV
  586. Re: macro adding a number to a number already in a cell
  587. Another Date problem
  588. Unlocking in 97
  589. Accelerator Keys
  590. Re: macro adding a number to a number already in a cell
  591. If/Then Macro
  592. Workbook.Open Event Procedure not firing
  593. What's wrong with this picture? VBA Date code..
  594. VBA version
  595. Why doesn't this work in Windows NT & MS Office 97
  596. Formulae for Macro based files
  597. vlookup function in excel
  598. Max Number of Sheets
  599. Excel Reports Wrong Border Color
  600. Dynamic input for Chart gives error9 but seems to do his job to...
  601. Moving active cell after copy
  602. Pivot tables and loop
  603. Ctl-X activation of macros
  604. Using variables with ROWs
  605. Print Preview
  606. Macro to return to previous worksheet
  607. Macro to jump from the find box to found item
  608. Array formulas are not valid in merged cells.
  609. Sumif for countif?
  610. HELP! Do While...Loop slower as it proceeds???
  611. Copying Page SetUp
  612. Zoom property error
  613. Print to File: In Excel?
  614. Using object Range dynamic???
  615. Please help!!!
  616. If/Then Formula
  617. Add validation using sheet code
  618. Excel 97 VBA: Binding a combo to a named range
  619. Simple VBA question
  620. copy 3 sheets & save them into new workbook
  621. Transfer Excel data to Word
  622. Sum Formula in Excel
  623. How do you call one Sub from another Sub ?
  624. selecting a cell relative to activecell in an excel macro
  625. Screen Updates on a userform
  626. Need Help - Copy/Paste & Header Row
  627. Timer
  628. Compile Errors
  629. Exporting Excel to Access
  630. Conditional Formats
  631. Worksheet Selected Names
  632. Opening multiple .xls files with a macro
  633. Refreshing an external query on a protected sheet
  634. SHELL command
  635. select particular cells
  636. use only VBA - help
  637. VBA code to display the "Find" (Ctrl+F) dialog box
  638. Storing string in names
  639. How to prevent resetting of Excel Toolbars
  640. How to sum the number of pictures in a column?
  641. Re: Events with cell link
  642. Manipulating Pivot Tables With Macros
  643. e-mail macros: MS Outlook
  644. VBA to ShutDown PC
  645. Re: MACRO TO RENAME SHEET !
  646. Re: VBA - programming months
  647. How to accsees excel file from ODBC if file has no tablename?
  648. Highlighting text in text box
  649. A Challenge To All!!!!
  650. Show one range in a combobox and write the 2nd range!
  651. OnTime problem
  652. How? Force Sheet1 to display each time the workbook is opened.
  653. _CodeName usage
  654. Need to know how to obtain this...please
  655. Re: Workbook Open Event
  656. Re: Workbook Open Event
  657. Re: Application.Calculation=xlCalculationManual causing run time error?
  658. Need help with a macro
  659. make labels (increasing number) in Excel
  660. make labels in excel
  661. how can I change the size of each cell consistency?
  662. Re: Running a macro at a certain time
  663. Re: Manipulating DOS from VBA
  664. counting a highlighted cell
  665. VBA - programming months
  666. combo box, index formula problems
  667. Turn off Screen Saver by Macro
  668. Data Validation slowing down workbook
  669. ComboBox ProperTies
  670. repost: convert +/- on text value
  671. Open PDF & RTF files from Excel
  672. active worksheet
  673. Does excel have a global template i could add a vb macro to?
  674. selecting unique and random values
  675. disable Subtotals Outline Symbols
  676. Vb code to print a page #
  677. I need a formula that equals a given #
  678. Date entry in userform help
  679. Calculate weekdays from two dates
  680. Run-time error '1004' running to excel objects at once
  681. Storing macros outside of Excel VB
  682. How can I make cell A1 a "Y" or "N" depending upon cell A2's font color? Please help.
  683. Clear Textboxes, Labels, and Checkboxes
  684. Using a variable string in a file save path
  685. Import Data
  686. Problems running a sub having arguments
  687. Copying specific rows from one sheet to another
  688. Lock up with Arrays
  689. How to Isolate macros from different Workbooks?
  690. copy/inserting rows at specific intervals
  691. Forms: Group Boxes and Option Buttons
  692. Selecting Rows
  693. somebody please email me Rob Bovey's code cleaner
  694. Sorting two columns of data
  695. Simple Filter Question
  696. Re: Call an Excel Macro when a Sheet is selected
  697. dynamically controlling number of lines on a graph
  698. campare list too slow
  699. Macro Using VLookups
  700. convert excell form to web form
  701. Sheet Event?
  702. keypress
  703. Variables
  704. Macro to Delete a Spreadsheet
  705. Hiding everey n-th row
  706. Pointing search function to "This Drive"?
  707. Opening Files
  708. Converting to UserForm
  709. VBA Code Question
  710. Excel VBA
  711. validation of cells
  712. Concatenating Variables into file path name
  713. Lag functions or faster code
  714. Range properties
  715. excel clock
  716. Timer function
  717. How to SUM
  718. Printing Word doc from Excel
  719. XP running out of memory when using macro
  720. grid references to pushpins on a map
  721. Dynamically finding the last empty row
  722. Open files from specific directory
  723. Dont allow use of VBE
  724. PowerPoint Shapes in userforms/dialogs
  725. Double Lookups - Death by #N/A !!!
  726. text box size problem
  727. Cubic Root
  728. =IF(ISERROR) doesn't work
  729. If...then statements?
  730. Faceid 2003.
  731. Question on MS Query in Excel 2000
  732. Deleting ActiveX Controls
  733. How to read Excel Spread Sheet in VB
  734. Single excel instance + VBE disabling
  735. Running Program on a Mac
  736. Magical appearance of single quotes.
  737. Status Bar Calculating Cells 50%
  738. worksheet copy problem
  739. Custom List Number
  740. insert a new row
  741. find largest data (part2) hard work..
  742. Autofilter returns
  743. Screen Updates not working ?
  744. How to know the address of the last cell
  745. Change language
  746. Lines fo code
  747. Forced recalculation in Excel
  748. disable keyboard/mouse from vba for all programs?
  749. On click, copy cell contents to another sheet?
  750. ActiveCell.FormulaR1C1
  751. PMT Function
  752. Disable AutoOpen macro's
  753. autorun macro
  754. Excel Searching and Wildcards
  755. need help with macro -move cursor down then home
  756. Add in label to the category axis on Chart
  757. conditional formatting highlight the cell today's date
  758. How to get file's current directory path to a string in VBA?
  759. How to get the list of files in a folder
  760. Macros in a template
  761. Web Query
  762. variables
  763. Excel time out query
  764. Copy sets of ranges
  765. Sort (in Excel) from code in MSProject
  766. Excel/VBA - month dates
  767. In code be able to turn on/off Track Changes feature?
  768. Am I Range? ... I object!!!
  769. multipul lines in a cell
  770. VBA splash screen
  771. DLL Call
  772. Excel OLAP/ Pivot Table Sorting
  773. ms project popup calendar in excel?
  774. how to trap a event coming from a dll
  775. quest re VBA: how to Input mode?
  776. UsedRange on blank sheet?
  777. running macros on hidden sheets?
  778. Change_Event
  779. Linking worksheets
  780. Windows versions diff
  781. Recording macro
  782. using macro to save worksheet with unique file name
  783. VBA code: how to invoke data entry mode
  784. Automatic numbering
  785. Insert new row after hitting enter
  786. Use relative reference to change column link??
  787. combobox
  788. Parse Text File
  789. Print vs. Print Preview
  790. VBA Code
  791. combobox row source
  792. add multiple checkboxes to userform at runtime
  793. focus policy
  794. Before I lose any more hair: Run-time error '9'
  795. number format
  796. Excel to PDF
  797. Extract pivot table info
  798. Toolbar's shape remains on the screen
  799. Intersect Formula???
  800. Excel macro to loop through worksheets and graph data from each worksheet
  801. invalid picture error
  802. Control the Text in Text Box
  803. Data Type
  804. Disable macro through automation
  805. Cell comparison to change color on a third cell.
  806. Printing worksheets in excel spreadsheet
  807. Restore Macro Speed
  808. sequentially assign a single number to each worksheet
  809. Msg: TesAddCreated.xla is not a valid add-in
  810. Is it possible to require that a KEY NUMBER be imputed in a workbook 1 before workbook 2 can be opened?
  811. Help with code or formula
  812. Transfer data from EXCEL to WORD
  813. Populate Drop-Down from Database Using VBA
  814. Runinng excel in the "background"? Help!
  815. Absolute cell formula
  816. Highlight selected cells if text is in certain column
  817. Excel Macro Help
  818. Convert Nulls in Microsoft Query 2002
  819. A Form's Rowsourse Format
  820. naming a range in excel
  821. Open a file that is already open
  822. Coninuted Intersection Problem
  823. Macros/Tracking/WorkBook Sharing Help Please
  824. Macros/Tracking/WorkBook Sharing Help Please
  825. VBA mailmerge from Excel
  826. Office XP chart component
  827. I am looking to see if anybody has an equivalant user form to Outlooks CONTACT form
  828. VBA how can I stop a Save
  829. Problems with Find and Date Fields in Excel macro
  830. Copying block (range of cells) based on a value of a specific cell-VBA
  831. DDEInitiate with Notepad
  832. Application.sendkeys
  833. Excel 97 and Excel 2000 run time error
  834. HELP! Macros point to wrong file!
  835. Send email using Netscape
  836. Steve Bullen's form resizer
  837. What am I doing wrong?
  838. How do I display an Excel add in in my Menu
  839. Transfer data from EXCEL to WORD
  840. Code for runnning macros created in XP in older excel versions
  841. Intersect Formula VBA Help
  842. Changing Data Source Driver
  843. disable the msgbox beep?
  844. sound only soundcard second output pair or voicemodem-speaker?
  845. Screen co-ordinates
  846. copying non-adjacent cells
  847. Apply Colour to cell & blink
  848. VB code needed for running newer excel version macros in older excel versions
  849. Change In Date Format to weeknumber automatically
  850. run macro on close & open
  851. Dynamically declaring variables with composite name
  852. freeze cell B1
  853. Add a worksheet with a name as a date
  854. Dynamic Creation of borders
  855. Zoom
  856. Multiple checkboxes 1 macro
  857. Custom Menus in Personal.xls
  858. Refreshing charts
  859. VBA Help files - examples missing?
  860. Screen Coordinates of a given cell in XL
  861. Visual Studio Tools for Office
  862. Display a warning msg if count is over 10. How?
  863. Removing Certain Format Conditions
  864. Modifying the design in web page saved from excel
  865. InputBox options
  866. Macro to format date
  867. If then help required for joint places in a rank
  868. Formatting Date Macro
  869. too fast word exit
  870. Date PopUps
  871. Unloading A Form
  872. prueba news
  873. Row deleting script problem
  874. MEET & DATE MORE LADIES EASILY (Proven) ssssssssssssssssssssssssssssssssssssssssssssssssss ssssssssssssssssssssssssssssssssssssssssssssssssss sssssssssssssssssssssssssssssssssss 1002 [1/7]
  875. Type of textbox on userform
  876. SWhowing a data form using macro's
  877. UserForm Update on the Fly
  878. detecting shape clicked on
  879. convert +/- on text value
  880. SELECT stmt using a range name?
  881. how to change range in VBA?
  882. downloading charts from internet URLs using Excel VBA
  883. VBA for EXCEL and Average
  884. How to write vba to check the last digit of hong kong ID card number
  885. How to not display the $.
  886. Opening and Closing workbooks
  887. Automate Adobe Acrobat?
  888. email new message
  889. Copying a range of cells
  890. Macro Help for Newbie
  891. ActiveWorkbook.RefreshAll
  892. pivot table by macro
  893. Need Help - Copy a Cell
  894. Making Command Buttons
  895. Excel
  896. Listbox
  897. cyclic redundancy check
  898. VBA : xlDialogPrint function
  899. Anand clique tributes Legendary Chicago KTQ4X8
  900. OPEN A FILE
  901. linking Outlook appointments and contacts from Excel
  902. Prompt to overwrite
  903. how not close both Outlooks?
  904. Reducing Spam Associated with Posting to Newsgroups
  905. Sort Rows in order and re-align cross table
  906. Problems with numeric formatting in cells
  907. Adding cells that are calculated with formula's
  908. To macro or validate, or can what I want be done?
  909. Inserting selected range into Word document
  910. VBA code to invoke the Print dialog box.
  911. HELP - How do I know if a spreadsheet has been modified
  912. Pure "Read Only"
  913. Creating excel backup files
  914. Nested Looping with Tests, Row Copying Macro
  915. Cannot double-click to open file
  916. Embedding an Image into a cell
  917. How do I determine the Acrobat Distiller codename?
  918. Listbox
  919. VBA
  920. delete tab
  921. Seperate row to Column.
  922. triggering different macros from list box?
  923. query system username
  924. Question on MS Query in Excel
  925. Which data have been entered into a cell ?
  926. List box question
  927. VB controls don't work in web saved Excel workbook
  928. How do I call a VBA function from a cell?
  929. Pivot Table NewSheet Event Hide Columns
  930. Index page
  931. Index Page
  932. calling sub from another workbook
  933. Reducing Code
  934. Messgae Box on Exit Application
  935. Is this right
  936. error
  937. Changing the cursor
  938. Advanced Filters in Web Page
  939. Adding a reference under VBA
  940. Trace Precedents / Dependents
  941. Client using 97 & XP
  942. Button event clicked problem
  943. Variable from a sheet module in a class module in XL XP
  944. Removing VBA routines
  945. Using Excel 97's Conditional Formatting Form
  946. Start editing point in a TextBox
  947. Reducing Code
  948. Outlook Contact Info
  949. WinZip extract
  950. Create another form using macro?
  951. Renaming worksheet tabs
  952. Visio 2000 broke Excel (Office XP Pro)
  953. Sheet protection bug??
  954. Hyperlinks with variables
  955. Excel bug with sheet protection, user interface only??
  956. MS Query - STANDARD DATE to YEAR-MONTH
  957. Mousewheel wont function
  958. Excel 2002 files attached to Outlook 2002 EMails change size
  959. using visual basic controls in a excel web page saved spreadsheet
  960. PocketPC: Excel and VB
  961. INKEY and VBA
  962. Pivot + VBA question
  963. Possible? find string and put in next cell...
  964. Minimize and Maximize Forms continued
  965. Nested COUNTIF
  966. Visual Studio Tools for Office- Excel
  967. Sorting macro
  968. How do make cells F9:R1999 READ-ONLY ?
  969. get the program id of an excel application from the task manager
  970. How to Compare Workbook VBA modules
  971. Low Security and this runs, Medium it doesn't - Why?
  972. Navigating between worksheets
  973. How to copy header/footer info?
  974. Format textbox for dates
  975. Auto_Close
  976. VBA code for sending cells B6:J10 to text file.
  977. Error code=2
  978. trigonometric function
  979. Naming Current Region
  980. Changing the font size of the row and column headers
  981. Count Conditional Formatting
  982. Line break in cell, char(10) square settings?
  983. detect the Excel Update exc0901
  984. Selecting every fourth cell in a coloumn
  985. download and open excel file from outlook
  986. VBA code for selecting and copying rows to another sheet.
  987. How to pass valve in combobox object to cell
  988. Download files with excel
  989. Office97
  990. Default value in Listbox
  991. Trim function in Excel Doesn't work for certain cells
  992. Download messages to outlook express
  993. Scrolling TextBox...?
  994. how to start from varible row
  995. getting rid of of a pop-up massage box
  996. find largest data
  997. Members in a PageField
  998. fooked
  999. Searching text in cells
  1000. set time limit before closing sheet