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. size of file
  2. Can I "sign" my own macros? or some other fix for the message about security and macros?
  3. text to values
  4. RE: Programming Excel in Windows 98 Second Edition
  5. 50 workbooks
  6. Passing data between spreadsheets
  7. Identify Forms DropDown as it is triggered
  8. Macro selecting the last used cell does not work
  9. Link a macro to a cell value
  10. getting the Weekday from serial
  11. Use of the "OR" function
  12. Find active Windows()
  13. formatting a worksheet
  14. Random function
  15. Minutes vs Hours
  16. determinate if pop up menu exists
  17. Differences between Excel 97 and XP
  18. User form trouble
  19. problem with selection when calling macro externally from VB6
  20. Button, Button, which Button?
  21. Testing Closed Files
  22. Transferring data from on excel spreadsheet to another
  23. automation macro
  24. Setting Spreadsheet control data source to Excel file
  25. SaveAs syntax when using a variable
  26. how do i ignore cells with font color?
  27. how do i ignore cells with font color?
  28. how do i ignore cells with font color?
  29. how do i ignore cells with font color?
  30. how do i ignore cells with font color?
  31. how do i ignore cells with font color?
  32. how do i ignore cells with font color?
  33. Remove a reference
  34. how do i ignore cells with font color?
  35. how do i ignore cells with font color?
  36. how do i ignore cells with font color?
  37. how do i ignore cells with font color?
  38. how do i ignore cells with font color?
  39. how do i ignore cells with font color?
  40. Duplicate Rows
  41. how do i ignore cells with font color?
  42. Re: PasteSpecial problem
  43. how do i ignore cells with font color?
  44. how do i ignore cells with font color?
  45. how do i ignore cells with font color?
  46. Excel - add to "Worksheet Menu Bar"
  47. Combo Box addItem question
  48. Excel Writing speed
  49. Copy and Paste to New Workbook
  50. access X ecel
  51. Open files in directory
  52. data validation vs. locked cells
  53. Create an Input Box in Assistant
  54. NT Domain Logon
  55. Timed Automatic Refresh of Cells
  56. Change Printer
  57. Formating Macro
  58. Run-time error on command button
  59. Copy Worksheet Help?
  60. Logical Functions
  61. Logical Functions
  62. Grouping & collasping in a protected worksheet
  63. Adding reference in code
  64. My Autofilter is overzealous!
  65. converting a number to a date
  66. "Each Row from there to here"?
  67. Run Time Error 1004
  68. FillRight
  69. Assign code to shape
  70. Copy rows to different worksheet destinations
  71. Count Function in Date Field
  72. How to hide row range from code?
  73. Responding to cell events in Excel
  74. Worksheet name in order
  75. On Enter and On Exit events of MSFORMS controls?
  76. Need help with algorithm
  77. Run-Time code refuses to work in Windows XP
  78. secure a sheet
  79. OCX Error in Excel
  80. Com Port and VBA from Excel
  81. extracting a stringvalue from filename
  82. Get external data not working properly
  83. command buttons
  84. Can I create in VBA a class with instancing type different from 1 and 2?
  85. Global value does not retain value when UserForm is hide
  86. Deleting rows with specific value from row 1 to 200
  87. EnableEvents and DisplayAlerts problems
  88. VBA Object (External) for EXCEL
  89. Help needed coding a macro to adjust the source of information each time it is run
  90. VBA Copy Worksheets
  91. Excel Custom Function with Select Case
  92. Delete cells - auto move
  93. Books Excel
  94. Tom Ogilvys Code
  95. Leading characters
  96. Sheet Name
  97. Sending Emails according to sheet name
  98. Repeated application of AutoFilter
  99. Code Modification(From previous post)
  100. copying and pasting loop
  101. Protecting Sheet
  102. Inserting and arranging sheets
  103. Time a sub routine in thousanths of a second
  104. How to find the first blank cell in a range
  105. How to find a value then select that column
  106. Change Font Type
  107. MIME multiple Excel spreadsheets
  108. Detecting if a userform is loaded
  109. query info based on dates
  110. Using variables for row index
  111. Sending print commands to the printer
  112. Cell limitations?
  113. Hiding a hyperlink!
  114. Merging 2 Excel Documents
  115. how to delete empty row in vba
  116. Change to existing macro
  117. Linking cells to a field on a website
  118. Custom Footer using ThisWorkbook.Path?
  119. Range of Cells to populate in a text box on a userform
  120. Disable Excel Prompt
  121. Replace ActiveCell w/Query Results?
  122. Email Array
  123. Best practices pivot using SQL-sourced table?
  124. User Form
  125. "This macro calls that macro, which calls .."-how many?
  126. Worksheet Protection
  127. Hidden worksheets
  128. Hiding macros
  129. Re: Delete records using excel Macro
  130. Get external data with password
  131. Make a file read only
  132. Making a macro references relative
  133. Re: Delete records using excel Macro
  134. Indirect addressing
  135. Once criteria has been met, delet the same row.
  136. EXIF information
  137. cells in a diagonal range
  138. $6 to $6000
  139. Dynamically changing a calculated field in Pivot Table
  140. Enable/Disable Worksheet Change Event code
  141. Requesting return reciept in Outlook 2002 from Excel
  142. Copy & PasteSpecial
  143. Help with unprotecting worksheet in Excel 97
  144. delete record using Macro in excel spreed sheet
  145. Cancel Exit on duplicate
  146. Animated gif
  147. Array Formula (I think)
  148. Re: Help with calculating elapsed times and formulas
  149. Writing a formula in a variable
  150. Re: Looking for VB code to test for "RING" , "BUSY" disconnects or other signals
  151. HyperLink
  152. Can Excel support Multiple Users
  153. Excel 2003 not compatible with Office 2k Web Components -- HELP!
  154. echo off?
  155. Access AutoFilter list for use with input box?
  156. Excel "integrated" in VB6
  157. Pull Down Menu's
  158. CommandBarButton click event
  159. Cell Formatting - Continued
  160. Count Down in Cell
  161. How to sort pivot table?
  162. Shortcut menu on worksheet tab
  163. Analyzing code speed
  164. CHIP PEARSON - THANX
  165. Non Contiguous range and loops
  166. Help on the Assistant Balloon
  167. Balloon Assistant
  168. Change "relative" to "absolute" (database)
  169. populating a combobox on a worksheet
  170. Backup file in folder
  171. delayed worksheet.activate
  172. Cell Formatting
  173. Min Max function
  174. show a value of X in worksheet
  175. HOW ? Running a different Macro if value reached
  176. Deleting worksheets in a procedure
  177. Accessing document properties of non-Microsoft product files
  178. Preventing use of buttons on the taskbar
  179. Returning a date as a serial umber
  180. Input from Text file
  181. How to export a picture or chart from Excel to PowerPoint?
  182. Excel Security
  183. Problem while fetching Excel records?
  184. Excel Visualbasic
  185. Need lookup formula
  186. Trim Special Characters (Japanese Environment)
  187. How to get data from pivot table with multiple column fields?
  188. How to sum value from master worksheet taking value from other close worksheet
  189. More Visual Basic Syntax
  190. Help: Visual Basic Syntax
  191. Updating data automatically using macro
  192. How to show only 1 series in pivot chart?
  193. How to hide filter buttons in pivot tables?
  194. File Read-Only Status
  195. Creating new sheets (more detailed)
  196. Another simple little problem
  197. Sort command
  198. paste as values syntax
  199. XLODBC
  200. Macro to Play Wave File
  201. Excel macro to get stock quotes off the www
  202. Dynamically Creating Sheets
  203. How to locate a cell in the absolute A1 position
  204. Unhiding Rows: bug in Excel?
  205. Set Expiry Date in exel file
  206. Percent progress
  207. Global file reference change
  208. Problems with permutation
  209. automated macro's? and macro limitation to a worksheet
  210. Change Numbers to Dates
  211. Positioning the cursor programatically
  212. Writing 2 macros to sort names and numbers in excel 97
  213. Trying to limit .Find to a specific range
  214. Combobox in a Message box
  215. Copying Variables in VB Editor In Excel
  216. Copy and Paste part II
  217. Cut and Paste macro based on criteria then delete empty rows
  218. Pop up messages
  219. Sending files by e-mail
  220. A real challenge...can anyone solve this !??!?
  221. listbox
  222. index
  223. Customised Interface
  224. Help on subscript out of range error (VB6/VBA)
  225. checking if worksheet is blank
  226. Copy & Paste values macro...almost there?
  227. Excel hangs on close when using Web services in add-in
  228. Fill Color each Row based on a Condition
  229. Can anyone recommend a good book?
  230. How to get Formula Tips to appear?
  231. Query & Write
  232. How to get Formula Tips to appear?
  233. Sheet event doesn't work in '97
  234. returning cell value based upon 3 criteria
  235. My code replace the data by the line number
  236. where is References dialog box?
  237. Selecting multiple rows from listbox for reporting
  238. Import File with browse and select (even from Pocket PC?)
  239. Calling a sub from a addin in vba
  240. Way to automate adding pictures in a series in Excel?
  241. For Each Loop
  242. Making a media library for movies, cd, book, so on
  243. Background color for 50,000 odd-numbered rows
  244. Excel97 versus Excel95
  245. macro to copy and paste between 2 workbooks
  246. dissallow characters
  247. Recalculation of a spreadsheet
  248. CodePane
  249. Conver text to number in VBA
  250. Transparently updating another workbook from the current workbook
  251. Screen Flicker
  252. Locking/Unlocking a VBA Project in 2000 vs '97 - Difference?
  253. Export each worksheet to csv
  254. Rookie question: placing a value into one cell based on a forrmula in another
  255. create gif of selected area that is not a chart
  256. Detecting VBA code
  257. Worksheet Change event and Links?
  258. find columns
  259. Selection of the range filled in
  260. function "count if color"
  261. generic data entry form
  262. can variables pass values
  263. Detection of VBA code
  264. QUESTION ON "OFFSET" !
  265. Sample workbook
  266. Simplified Help
  267. Substitute Range Question?
  268. protect / unprotect worksheets using VBA
  269. userforms and worksheet help
  270. use find twice to find cell on a specific row
  271. Altering UI Programatically
  272. find row
  273. Sheet Event
  274. display statusbar, scrollbars and formulabar
  275. Read/Write data to/from text files from a spreadsheet.
  276. Selecting a file path in Excel VBA using FileOpen dialog
  277. How Can i sum hectars ?
  278. Testing for open workbook
  279. Please Correct the mistake
  280. Pivot Chart - how to hide buttons?
  281. How to add images to custom toolbar buttons?
  282. Problem with custom toolbar
  283. Changing a range number to a variable
  284. VBA Row(line) No Syntax?
  285. Removing an Item From a Collection
  286. Excel no longer allows new formulas with division "/" operator
  287. Re: Hiding a Combo Box.
  288. Re: toolbars
  289. Function to create a collection
  290. Changing Data order in Cells
  291. Returning the Number of Rows in a Recordset
  292. OLE2 problem with the "formula bar"
  293. UserForms setting radio buttons
  294. Outlook
  295. AutoSum button
  296. More to Error in code
  297. Error in Code
  298. How Many Arguments?
  299. controlling date entry in a text box
  300. Need a method to extract the Date from a cell to a new cel
  301. Finding if a cell is within a Range
  302. Hiding a Combo Box.
  303. Find and Replace - Auto Cell Formats
  304. random numbers
  305. Excel spreadsheet sort
  306. VBA - Protecting from Save
  307. Macro to use find command
  308. VB and Excel in win98
  309. Looping
  310. Remove empty rows
  311. Automatic next number in a series
  312. File folder dialog
  313. Combobox
  314. Add event code through a macro
  315. Finding Function
  316. Dynamic range in graphing macro
  317. Handling Excel Events in a Designer form in an ActiveX DLL
  318. Excel Macro Problem, Add-in need to work in every workbook & Error:9 Subscript out of range
  319. Controlling the position of attachments and Body Text in Outlook
  320. Hyperlinks from UserForm Controls
  321. duplicate #'s
  322. Exporting Charts as GIFs
  323. Problems deleting custom menu => double entries
  324. Using Macro to update formula
  325. Cut & Paste
  326. An Add-in question
  327. Need a function that finds a value in a table range and returns the cell number
  328. Protection
  329. Export values in a text file
  330. Display a Recordset in Excel
  331. Excel-Microsoft Visual Basic File Not Found
  332. Import Text File Location
  333. target address
  334. Delete rows w/o criteria
  335. Strip Modules from Workbook - Code Organization
  336. Finding Excel Macros
  337. Paste Values
  338. Delete Cells in Workbook
  339. Cell formats keep changing
  340. Macro
  341. Repeat the contents of a cell
  342. Cell Address
  343. Find a value a post data to another worksheet
  344. Word doc opens, but not in visible window?
  345. macros across multiple worksheets ...
  346. Program a combobox/dropdownlist to create
  347. Moving CommandBar using VBA or C#
  348. How to Avoid Printing Blank Rows
  349. Range.cells.calculate give error 1004 only in XP
  350. Assigning add-in function to custom button
  351. Checking if worksheet is blank
  352. Create a Acrobat PDF file from VBA
  353. Excel Crash
  354. Font and Fill ColorIndex
  355. 2 Questions ?
  356. copy sheet1 from all open workbooks to one workbook
  357. Merge Cells
  358. CALENDAR
  359. How to make it a Concurrent (Multi-user) spreadsheet
  360. Excel data recovery
  361. Merging two och more recordsets
  362. Code for locking windows
  363. Saving one specific worksheet in a workbook
  364. Spreadsheet opened by user or programme
  365. Taking a subset of a string
  366. secura a macro
  367. Using Drop Down List Then Creating Saved File (with formulas intact)
  368. Error 1004: Method 'Cells' of object '_Global' failed
  369. a Formula for a culomn in all recors
  370. For/Each iteration for collection class
  371. How to change type of the cell?
  372. urgent: no connection to excel
  373. getting the column name
  374. using vba copy data from .csv file into an excel spreadsheet
  375. events
  376. workbook open()
  377. Anybody translate VB for PC to VB for Mac?
  378. "like" string
  379. vba macro for getting external data
  380. Gathering info from a set of excel files
  381. Count occurances of text in a cell
  382. Problem with drawing graphs
  383. Returning an array from a UDF to a column range
  384. Filter
  385. ComboBox
  386. Subotal feature without labels?
  387. Jet Ole DB With Excel
  388. hex conversion
  389. Calculating Elapsed time in a macro
  390. LastRow issue
  391. Send mail with attachment
  392. Re: recherche et affichage d'une image
  393. Filling alternating rows in a worksheet with color backgroud
  394. HyperLink problem
  395. Use code to cancel printing
  396. Multi-variable Equation Solving
  397. Lost File
  398. Macro's scip Files!!!
  399. Dynamiclly generating PDFs from Excel
  400. Program a combobox/dropdownlist to create textboxes dynamically
  401. Queries and Macros
  402. Calculate years between two dates more precisely
  403. Option Buttons on User Forms
  404. Invoking Mail Merge from Excel
  405. Increment sheet names
  406. Excel Code Module
  407. Turning off macro disabled pop-up
  408. Disable Change Event in Form
  409. XLA and strong typing
  410. Data validation in a MSG box
  411. Formatting Cells
  412. Update Links
  413. Excel 2003 and Peachtree
  414. Unique Tag for Printed Excel Spreadsheet
  415. Macro to convert date cells
  416. Macro to convert date cells
  417. Macro to convert date cells
  418. Macro to convert date cells
  419. Macro to convert date cells
  420. Some simple code
  421. Excel, VB DLL and Macros
  422. selecting cells
  423. How to create a message box to keep track of progress
  424. XlPivotFormatType ???
  425. Keep large numbers from truncating?????
  426. Mining an array
  427. Program a drop down list to show a specific response depending on the selction
  428. Function that emulates FIND(find_text,within_text,start_num)
  429. Assigning Macro To Shape
  430. Unpaid overtime?
  431. variable that refernces the values in a text box
  432. Personal.xls
  433. oops!!!
  434. Generate XLS on server without Microsoft Excel
  435. How do I protect my hidden Excel.Application object from unwanted user interaction.
  436. flashing screen driving me bonkers!
  437. creating a hyperlink in a shared workbook
  438. how many combinations in a list equal a certain total
  439. Deleting sheets
  440. MACRO TO UPDATE DATES !
  441. .net, excel, extended properties and dbnull
  442. insert validation in sheet
  443. How can I hide the code??
  444. Deleting Many Cells on a Sheet
  445. Circular References, what a nightmare.
  446. Hide rows if formula result is zero
  447. Delete #N/A rows Formula
  448. Re: Selecting cells with a particular formula
  449. Re: Selecting cells with a particular formula
  450. Re: Selecting cells with a particular formula
  451. default printer
  452. Easiest way to automate spreadsheet merge?
  453. In Excel VBA, open .txt with Word?
  454. program activation
  455. Name field value
  456. date extraction howto?
  457. print form orientation
  458. Date Validation
  459. Selecting cells with a particular formula
  460. Zoom problem
  461. dates in dropdown
  462. edit default excel template
  463. [excel 97 vba ] Reading ranges into an array
  464. Report Question?
  465. setting up a workdirectory
  466. Error 50290: Error writing to Worksheet while using an ActiveX Control
  467. Empty toolbars
  468. Calling macros width arguments in winxp
  469. ByRef not passing address
  470. start a macro when file opens??
  471. Using Find & Replace in macro
  472. Protected worksheet and macro
  473. Find "." (Full Stop) in cell then all text after colour blue
  474. extracting string from value in cell
  475. Paste Cells in Column A to Columns B-K
  476. Dir() limited to 48 files?
  477. xlDialogSendMail Error
  478. Replacing a value within a string using a formula
  479. extract a foldername with a formula-update formula does not work
  480. Code security
  481. extract a foldername with a formula
  482. SaveAs,csv
  483. autorun userform from worksheet
  484. Excel cannot update web page
  485. Programming Xml Source Pane of Excel 2003
  486. Saving a graph as .jpg
  487. Add-in auto updating
  488. copying rows
  489. no connection to excel
  490. file extension problem
  491. Macro run slow when turn on ScreenSaver
  492. question on button event
  493. Text Box for Numeric Data
  494. Delete rows after used cell?
  495. Convert Excel to PDF via VB code
  496. Changing color of cells
  497. Countdown to Retirement
  498. Closing a Window
  499. Point of departure...
  500. XLA & COM files
  501. Import Text file into multiple columns
  502. Copy insert rows
  503. Menu commands - overruling with macro - How to do it?
  504. Detecting non-supported files using Excel.Open
  505. Proper method for Excel/Query/Macro reporting
  506. Re: Looping
  507. determinate if a range is empty
  508. Excel error message in protected sheets
  509. Referencing other workbooks
  510. removing unwanted characters in a cell
  511. Re: Looping
  512. how can I lock a file after some days of using it??
  513. Sum of cells spanning several worksheets
  514. Workbook references
  515. merging templates into workbook
  516. xlDialogTextToColumns arguments
  517. excel control button
  518. Sorting 100 rows of 6 records horizontally
  519. Re: recherche et affichage d'une image
  520. application.worksheetfunction.mmult help
  521. Replace return of line by a space in VBA
  522. Run time error '1004'
  523. next avaliable range
  524. Visible Rows Indexing
  525. Closing Excel
  526. File List Creation
  527. Control IE popup from excel VBA instantiation
  528. Accessing External Data
  529. Macros
  530. work schedule formla's
  531. Setting Excel toolbar or menu icon in C# WITHOUT using builtin icons
  532. protection sheet and code ???
  533. Unable to suppress warning message...
  534. recherche et affichage d'une image
  535. Add-Ins and Pocket Excel CE
  536. How to Retrieve Last Used Cell In Column
  537. Range.Select with variable cells ?
  538. Exporting to Excel, Then Formatting Columns/Cells
  539. Excel to Access
  540. embedded objects
  541. Changing Event Subs of Controls On Air
  542. Open Menu item "Print" from VBA
  543. Re: Access to Excel
  544. Re: Display a message whilst a macro runs
  545. Adding toolbar/menu command to Excel using C#
  546. Preventing opening workbook inside active workbook.
  547. counting occurance of a name in a cell
  548. Pie chart programming
  549. Help with a macro. Let's eliminate a loop...
  550. Creating Boolean Functions
  551. Protect macro code from viewing/editing
  552. makro that sums every new number entered in cell
  553. WEB BASED EXCEL REPORTING
  554. TCD Format du Tableau xl???
  555. Auto Open won't die or go away
  556. Uploading Problem
  557. User form question
  558. unprotecting a combobox in your spreadsheet
  559. check font colour
  560. VBA code to open a specific worksheet
  561. Case sensitive data
  562. worksheetfunction.vlookup?
  563. xlDialogSendMail problem
  564. Delete #N/A rows
  565. Button
  566. Improving code.....For Next
  567. Moving Vertical Page Breaks in Excel via VB
  568. Minimize the VB form
  569. Copying a named range of cells
  570. 'Floating' UserForm
  571. Add control at run time.
  572. Open workbook without activating it
  573. Minimize the VB form
  574. Searching unknown number of cells for a value
  575. Toggle Button
  576. access function description from c
  577. access function description from c++
  578. access the function description
  579. Print Excel Workbook When Open
  580. Automated Printing
  581. spreadsheet calc
  582. deleting variable number of rows
  583. Renaming files
  584. Disconnect a spreadsheet from its datasource
  585. Compile Error in Code
  586. Excel Test Formula
  587. Stock quotes:Excel
  588. How to update pivot table items?
  589. Need FASTEST way to get data from a large closed Excel File
  590. Reading specific digits from a numeric variable
  591. Using "Find"
  592. Delete columns
  593. Determining range
  594. Application Process-Shell Command
  595. Re: Display a message whilst a macro runs
  596. file name
  597. worksheetfunction
  598. Print multiple worksheets
  599. events
  600. How to change image by function?
  601. ASSISTANT FILENAME
  602. Macro to play wave file
  603. autofilter using macro
  604. Yes_No
  605. Excel and preparing email
  606. macro & combobox
  607. copying and pasting not adjecent cells
  608. Code slows on subsequent run
  609. assigning a formule to each cel in a column
  610. Path Not Found Error
  611. In a Cell, How Can I Make The Cursor Go to The End?!
  612. vba multi threading
  613. Get Last Row
  614. CONVERTING A LOTUS MACRO
  615. VBA code to insert images in excel sheet
  616. multilple sheets using days of curr month!
  617. Conditional IF statement
  618. Auto Refresh/Format a PivoTable
  619. Ontime questions
  620. Macro execution refers not to the active sheet/excel file
  621. VBA Code to convert Excel to PDF
  622. How Can I Use SendKeys in MAC EXCEL?
  623. Templates and CreateObject
  624. Assigning formula using a macro
  625. code lost after saving
  626. Updating form labels from code in a module
  627. Application Size and Location
  628. Excel Marcos and Programs
  629. proprietary protection
  630. Transferring data entered into a Text box to another Cell/Sheet?
  631. hlookup in VBA
  632. list worksheet names within a notebook
  633. Need Looping Help
  634. followhyperlink failure
  635. How would I modify the following?
  636. Worksheet value to user forms
  637. Setting attributes for controls
  638. Automating Excel (XL2002)
  639. Form Resize
  640. Worksheets.Add method
  641. ONACTION macro tries to open another workbook
  642. How do I use a Combo Box to change values in a Cell.
  643. Disabling Toolbar Buttons with no open Workbook
  644. PRINTAREA
  645. detect worksheet
  646. copy a mocro to another pc. HELP!!!!!!!!!!!!!!!!!!!!
  647. Open WinZip from Excel
  648. Selecting single column with merged cell at top
  649. Looping Find
  650. Delete Rows below a certain cell
  651. Set variable = nothing?
  652. Creating a Dynamic Function
  653. TextToColumns Dialog
  654. Saving VBA Toolbar Customisation
  655. Help with Macro
  656. MESSAGE ALERT
  657. Random Number Formulas
  658. Printing Mutiple workbooks....
  659. Printing to Generic / Text printer
  660. Visual Basic to reference value in Excel cell
  661. MACROS
  662. Help Excel for Second Edition Windowns 98
  663. UserForm remembering Settings
  664. Listbox9 does not support saving.....
  665. Executing a Script on an Oracle DB
  666. Counting files using Loop
  667. Counting files using Loop
  668. Counting files using Loop
  669. menu in excel
  670. Start recording macro
  671. Anomaly, can't format cell
  672. Changing cell formulas with a macro or VBA
  673. Load Macro at start up?
  674. Re: @ Round Formulas
  675. What is InBufferCount?
  676. Re: Delete Rows above a certain point
  677. Conditional find
  678. Re: @ Round Formulas
  679. Linking Excel to the Internet..
  680. List Box Visible Rows Only
  681. Maintain Target Porperties in MS Excel
  682. Insert rows
  683. Sort to Various Sheets in Workbook
  684. Send file automatically
  685. Tuning Off Toolbars
  686. sumif
  687. Loop through sheets, deselect charts
  688. adding a listbox to a spreadsheet
  689. code Help - Routing Recipients
  690. Comm 1
  691. Can anyone solve this!?
  692. Comm1 not opening
  693. Help Retrieving Cell Values
  694. Paste a Range from a variable
  695. Printing to Adobe without getting promt for name
  696. macro & comobox
  697. Web service reference Tool 2.0 -
  698. VBA code slows to a snails crawl when screen saver activated
  699. Revised Question on Page Numbering
  700. Offset Formula Question
  701. excel 2000, vba and msquery(sql)
  702. Annoying "virus" alert when using code to send mail
  703. Excel 97 automatic cell format
  704. how to trigger macro or force autofit
  705. Calling Macros oustide current module
  706. Holloween Mystery: ghostly blank cells
  707. Email from Excel..please help!!
  708. Formatting a date as a serial number
  709. For Next with step
  710. Re: Page number question
  711. Re: Page number question
  712. Re: sheet collection
  713. Check activate sheet
  714. formatting ques...
  715. How to force a recalculation of values based on custom function
  716. How to write an importer/exporter for excel
  717. Another Tuesday Task
  718. Tuesday Treachery
  719. Creating a Master Sheet
  720. Pb en VBA Excel
  721. Problem with Legends in chart
  722. Cheque Writer in Excel
  723. Before DoubleClick
  724. OLE
  725. toolbars
  726. Insufficient memory Caused by Pivots.
  727. Compare Worksheet's
  728. Autofilter hides totals I want to see
  729. Problems with ungroup
  730. SQL Multiple table joins in VBA
  731. Problem hiding/unhiding columns using combo control
  732. Create customs define event
  733. Making arrays outside cells
  734. ActiveWorkbook keyword seems to fail
  735. Specify a folder for saving to?!?!
  736. Cell format
  737. Excel formula
  738. Format column auto. to "hidden"
  739. VBA code 'find next'
  740. Rounddown problem in VBA
  741. question on the definition of refer to
  742. vba or function
  743. Difficulties in VBA ( User form and option button)
  744. Running Access MAcros or VB modules in Excel
  745. Flickering of the Screen when the Macro runs.
  746. Adding Modules
  747. Userform question
  748. Global variable
  749. Pointing to the Correct Directory
  750. Pivot Table: Hide Items Poperty
  751. Custom Menu
  752. Form question
  753. Import External Data incomplete
  754. Help with a Combo Box Change Event
  755. Over ride double-click handler?
  756. Run-time error '430' / Class doesn't support Automation
  757. References in VBA macros ?
  758. Help - Change Event triggered on File Save As
  759. Any difference between Sheets Activate and Select?
  760. Using Excel through COM
  761. using mappoint in Excel VB
  762. ATTN: VASANT
  763. How to display contents of a cell in UserForm and take input
  764. ranking the bottom of the table
  765. Automation
  766. List of GUIDs and other properties for future references
  767. Create named range
  768. Getting to the Function Explanation Programmatically
  769. Opening a CSV file
  770. delete rows
  771. Copying Cells
  772. message when saving workbook
  773. Automaticaly Emailing A S/Sheet ??
  774. Nedd help on my function in VBA
  775. Templates
  776. Still Stuck
  777. SQL Statement
  778. converting 16 digit number to text
  779. Re: Macro 'Automation error' with ChemOffice Excel macro
  780. Changing a cell color....
  781. Excel 2002 and Excel 2003 VBA help screens
  782. Collectiong data from SQL server / Repeat!
  783. SP3 removed Macro Security option in Excel 2000
  784. How to set a time for the next 1/4 hour
  785. Operation Is Not Allowed When The Object Is Closed
  786. Add columns of data in Excel workbook to fields in MS Access
  787. My Macro keeps stopping??
  788. Filtering
  789. vba programming
  790. Detect workbook events from .XLA
  791. How to conditionally sum values depending on values in other colums
  792. storing numbers within the macro
  793. Date/Time - String or Number!
  794. Re: vb to copy conditional info.
  795. Using Excel to generate Word macros
  796. Connecting to comm 1
  797. On Error
  798. Connecting to comm1
  799. restrict entry in a textbox to a range of values
  800. Is there a better option than Getobject to access a .xls?
  801. programming font color on select items
  802. Conditional number format of cell
  803. Using VBA with Shared Workbooks
  804. Pivot Table Macro in Excel 2002
  805. run a DOS .bat files under an excel macro
  806. Excel vba printout method
  807. Importing data from text files
  808. User Defined Addin - Urgent Please Help!
  809. Macro Monday Blues
  810. Determine active file size
  811. Linking Cell Comments!
  812. Using VB to fill a formula down
  813. Associating a macro with a button
  814. Emptying the copy buffer
  815. ActiveWorkbook reference fails
  816. Maximize minimize and restore button
  817. Run command when hitting ENTER on list box item
  818. Modify generic dialogue
  819. Print data from FlexGrid
  820. argh, can't get it to work
  821. Msgbox help
  822. how can i copy a macro to another pc
  823. Sum Function
  824. Range.column
  825. variable range: l just can't get there!
  826. Populating combo box with a function
  827. AutoComplete in a List
  828. calculation multiple row & colums
  829. User access to the VBE
  830. Ending a routine
  831. VBA code to change the Print - "Number of copies" to 3
  832. Prevent users from using AutoFilter
  833. Excel help + VB
  834. #DIV/0! criteria
  835. worksheetname in a cell
  836. Spreadsheet documentation
  837. Option Button and forms
  838. MACRO QUESTION
  839. Sendmail Macro
  840. Working between Worksheets of the same workbook
  841. Excel on the Web
  842. Why doesn't this work...??
  843. link a cell into a vba form
  844. Worksheets.Add
  845. looping with formula inside
  846. Stopping a macro without using Ctrl Break
  847. VBA: how to force another instance of VB to run
  848. Difficulty hiding check boxes
  849. Formula
  850. Shapes.. trying to print a square square
  851. How many CR's in a multi line texbox
  852. Array Formula
  853. Restricting use of menus and toolbars
  854. Re: Publicising Benefits of VBA
  855. Use VBA to open an Excel cell for Edit
  856. Last question I promise
  857. Disable ALT KEY
  858. UsedRange & Formatting of Cells
  859. tabbing round a userform, whole field is selected
  860. Userform Textbox Currency Format Problems
  861. How do I remove toolbars and specific menus items to restrict use?
  862. Formulas
  863. REQ: I need help working out this function.
  864. AutoFill Method
  865. Looped process
  866. Changing cells temp.
  867. ActiveX Warning Message
  868. Wordwrap wont!!!!
  869. Resizeable Rectangle
  870. Add & Delete Records in Excel using a form showing a scrollbar also!
  871. refedit query
  872. Too Basic A Question
  873. Using Solver within Macro
  874. Creating a Function that references cells to other cells...
  875. Run time error 1004
  876. handicap predictions
  877. Sum at point of change
  878. Row Heights
  879. true 3D bar charts possible?
  880. Is it possible to set a class member to be another class member?
  881. Re: Customisation of Chart Dialog
  882. "Run Time Error 1004 Application Defined or Object Defined Error."
  883. Windows Media Control and VB6
  884. Newbie : Combo box on cell ?
  885. MACRO TO REPEAT FORMULA
  886. Page Setup for multiple sheets
  887. Excel Data Sort - doesn't. HELP please
  888. How to make a sheet the active sheet?
  889. Missing Security option in Macros
  890. Assign a variables value to a TextBox
  891. How can I avoid a BLANK cell being interpreted as a ZERO?
  892. setting tab order by code
  893. Printing with reference to current PC
  894. Let me have another try
  895. Determine range with VBA
  896. Macro slowing down after a while...
  897. Inputbox to return address of cell selected by mouse
  898. Inputbox used to return value of selected cell
  899. Sum
  900. Array Help Needed
  901. Reliably get sheet 1 of the active workbook
  902. Append new row of data to range
  903. Create Excel Macros
  904. In unten stehendem Prozedurausschnitt soll an Stelle des Feldes 'name' jenes Feld eingesetzt werden, das in der Variablen sortierKriterium steht.
  905. Ambiguous Name Detected
  906. Comment Box
  907. A very simple question....
  908. Disabling Minimise/Restore Down buttons
  909. Format text in Outlook from Excel
  910. Code for modify a column
  911. can we start form by clicking hiperlink ?
  912. How do I use Workbook.Add
  913. Attention: Leo Heuser
  914. queryinterface error in vb.net
  915. Disable "Save" &/or "Close"
  916. Not sure how to tackle this
  917. RE: C# and OLEFormat.Object
  918. Count Cells containing Text only
  919. Is this NewsGroup Operational
  920. How to return a XL97 spreadsheet info to the requested web page?
  921. my script wont post, unless i hit a key..
  922. auto open a workbook
  923. making a cell fixed number to a input number
  924. Opening a workbook minimized...
  925. ReDim an Array
  926. Export to text with custom delimination
  927. Code For Expiration Date
  928. Basic VBA question
  929. Add-in installation on Excel 2002
  930. How to uninstall XP PIAs
  931. Grouping Option Buttons
  932. VBA: Userform Access
  933. Cell Edit
  934. unwanted concatenation
  935. Pausing a macro for user input
  936. Excel/Windows 98 second edition
  937. Activating workbook with variable Name
  938. Changing PivotTable source
  939. Maintaining Column Widths in CSV Format File
  940. relative reference
  941. How to keep Excel sheets on a database?
  942. DataCombo control...
  943. Tab Stop Broken
  944. macro for conditional formatting
  945. test
  946. Publicising Benefits of VBA
  947. "Not Enough Memory" new macros problem
  948. Changing the Hyperlink in a cell
  949. Open all linked files and close them.
  950. Selecting Rows by Column Value
  951. Dialogue Boxe
  952. Excel outline showlevel
  953. Error 1004 - unable to set the orientation of the page setup class
  954. More Macro Madness
  955. VB backwards compatability to 97
  956. Copying sheets
  957. SPSS Excel
  958. Excel Compiler - is one available?
  959. skipping text formats
  960. Wish to parse through a text string to find data
  961. How to Insert Picture in Excel?
  962. Can anyone find what is wrong with the following?
  963. Modifications to Permutation Macro
  964. Macro warning when no macros in workbook
  965. offset property to define range
  966. utility
  967. Link .xls cell formula to .xla function
  968. Autocomplete (?) in code not working
  969. Parsing Full Names of varying lenths and parts
  970. Library missing..
  971. Excel won't quit
  972. Proteting against a button press
  973. Combo Box - Can I Concatenate the list?
  974. macro for timestamp option button
  975. DATEPICKER CONTROL
  976. How Do I...
  977. Parsing Shell Command with Parenthesis
  978. Delete rows if they are empty
  979. Simple macro - help please!!
  980. macros disabled after apply SP -3 to excel 2000
  981. Dropdown Rowsource
  982. Disabling/Enabling Macros
  983. I need to validate with a formula
  984. Having trouble with formula to automaticly enter data
  985. MS QUERY w/out querytable
  986. Saving CSV files in Excel macros
  987. MS QUERY
  988. Gray background is shown when loading a workbook
  989. Documentation & testing
  990. Path
  991. text in listbox
  992. "TEXT" numbers - count problem
  993. Referencing Cells in Macros
  994. Combo Box becomes blurred
  995. If value betwenn 0% and 50% than yes
  996. excel problem
  997. How do I use Workbooks.Add
  998. repost: Listbox text align
  999. Msgbox
  1000. Formula using VBA