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. help with user definded function.
  2. Pattern Matching with cells function
  3. "Are you sure" Prompt
  4. Problem Tracker
  5. Excel Form Issues...again :)
  6. Help With Counting
  7. Create folder with a macro
  8. Removing Leading Zeros from a String
  9. looping texboxes - possible or impossible?
  10. Protecting Formulas
  11. Form help
  12. Identifying Multiple Selected Worksheets
  13. Logging on to network drives automatically.
  14. Re: File already exists
  15. Adding space to VBA code
  16. Additional criteria for a countif statement
  17. = positioning
  18. Help Required With Snake Column
  19. Workbook Before_Close question
  20. Best way to protect sheets and document.
  21. Help Please
  22. Empty ThisWorkbook module, but Macro warning problem
  23. VBA instead of lookupformula
  24. Toolbar sub Menus
  25. Command Button run-time error
  26. Re: zero'n out table values
  27. Using dates in macros
  28. Importing Checkbox Values
  29. Number precision problem
  30. if statement is true, copy data to another location
  31. Re: Outlook attachment
  32. Open Folder from inputbox
  33. Adding text to the body of an e-mail
  34. Undo Macro
  35. Updating Custom VBA Functions
  36. Auto Open
  37. Lists within Combo Boxes
  38. Recalculation using filter
  39. Using .Replace
  40. formula arithmetic
  41. Re: Outlook attachment
  42. Re: Function to return font style
  43. Specifying a countif function within VB
  44. Copy cells when column contains data
  45. Excel VBA/macro problem; Export to csv
  46. Get Open File Name
  47. Macro Crashing Excel
  48. Excel takes long time to open
  49. Re: Make the first row to be fixed and to be printed in each page
  50. Dim / Redim of an Array
  51. vB code to analyse list
  52. Code Help
  53. Storing Macros
  54. OLE ListBox refresh
  55. check and/or create sheet "xxx"
  56. referencing a closed workbook
  57. Unhiding columns
  58. Excel crashes when editing chart
  59. Using VBA code when searching in a spreadsheet
  60. Preventing Writing in Combo Boxes
  61. Change PivotField Item with macro
  62. How to keep an Array 'alive'
  63. How to delete sheet that is referenced.
  64. Macro to delete Rows 1, 3 and 10
  65. Row Inserter Macro
  66. merging excel files in different sheets
  67. Excel 97 crashes ?!?
  68. Deleting Sheets based on checkboxes being unchecked
  69. SKIP EMPTY ROWS FROM IMPORT
  70. Dynamic Range
  71. Excel 97 crashes
  72. Recordset.Recordcount Returns -1!
  73. ListBox - Row Source problem
  74. interesting query problem
  75. Making Contents of a cell input for a Module
  76. ActiveCell.Formula and IF statement
  77. Pop-up function argument list
  78. Need help with VBA
  79. Excel forum not receiving answers.
  80. Need help with VBA
  81. size of user form
  82. Can it be done by marco?
  83. need help with vba
  84. multiple sheets
  85. I need help, if able.
  86. Query replace by VBA
  87. simply lost on hyperlinks
  88. Re: using VBA, incerting a row for alphabetical order
  89. Drop Downs- Validation
  90. Page Numbering
  91. using VBA, incerting a row for alphabetical order
  92. fairly basic excel question (i hope)
  93. Count maximum consecutive positive numbers
  94. Easy Listbox to Sheet?
  95. VBA newb needing help with an IF
  96. Like Operator
  97. VBA newb needing help with an IF
  98. display results of formula in different cell
  99. VBA noob help with an IF
  100. user form VBA
  101. Delete Rows if Certain Values are listed in a Range Name
  102. Control powerpoint and pdf writer from excel..?
  103. addinn list in excell
  104. ComboBox start condition
  105. If-Then statement with variable range
  106. Move files from one directory to another: if they are there
  107. Initialize textbox values
  108. Position/Size a MessageBow
  109. opentext
  110. using VBA to insert a column of pictures
  111. Worksheet_SelectionChange
  112. highlight entire row based on date
  113. Copy on condition and paste to last+2 row
  114. Button on a workshhet?
  115. How can I do convert letters on "*" using keypress on excel
  116. macro question
  117. Tools Bar
  118. HELP to apply a Workbook_Open event
  119. lookups in other worksheets....
  120. Excel VBA - ActiveX Data Objects (ado) Performance
  121. Print Preview
  122. Changing Column Order (Not Rows) with Sort Function
  123. Determining Start & End Points in Selected Cells
  124. Excel 400 and StarQuery
  125. trouble with combo box
  126. find problem
  127. How to separate fname and fname in cell in excel
  128. Execute a query from a macro
  129. Attn Alan Bedan re arrays
  130. Delete Rows and Parse Data
  131. entering formulas on a sheet
  132. Transpose Columns to Rows
  133. default value for Autofilter
  134. Creating Charts Using Data from another Workbook
  135. Chart help
  136. Re: Turning on Workbook Properties Statistics
  137. VBA Sort one sheet display another
  138. Increment a Template
  139. Variable Macro
  140. dialog for directories
  141. write two excel sheet
  142. Rounding Dates
  143. Treeview control and view of folders and files
  144. Make 2 radio boxes uncheckable if cell " has no value
  145. Opening a file through input of first 3 digits
  146. Dates in Excel
  147. start excel and decimal point
  148. Urgent Help needed on! Copy and Paste a Formula as Values using a Loop statement
  149. Re: User Forms - Max Me
  150. Re: Find and clearcontent
  151. Re: Checking for existence of excel
  152. Find row with matching cell and retrieve values (VBA)
  153. Sum unknown length column data in VBA
  154. User Forms
  155. Question
  156. Time and If...
  157. Displaying and Hiding Radio Boxes
  158. Updating Hyperlink with sheet name change?
  159. For Next loop problem
  160. function to print to PDF and save PDF file
  161. Check Boxes and Option Buttons
  162. Auto numbering new worksheet versions
  163. Help with arrays please
  164. Conditional Formatting Using VB
  165. Is this a feature new to Excel 2002?
  166. Newbie question on accessing data in xls
  167. Macro to add data
  168. filtered range
  169. Scorecard
  170. RE: activeworkbook.saveas
  171. How do I convert from a 'double' valued color to a System.Drawing.Color?
  172. Run time - % complete
  173. PDF Writer Error
  174. Working with page footers
  175. Get Macro on one Worksheet to Work on Others
  176. WorkBooks.add
  177. How do I approach this little Project, please?
  178. Export to CSV
  179. More Solver Problems
  180. Macro to delete duplicate data
  181. Workbook_Open Event questions
  182. VBA Match Error
  183. Protecting Macros -is it possible
  184. Appending Info
  185. Excel 2002 Hyperlinks and redundant rows
  186. Row/Column letters/numbers - how do you hide?
  187. Macros
  188. Programming Question
  189. warning message
  190. In need of some dire help...
  191. More efficient than copying and pasting
  192. Record to stay in one spot not matter how rest is sorted?
  193. Simple Code Help
  194. Re: Command to move down one row
  195. New to VBS and VBA
  196. Org Chart Diagrams
  197. Re: Initializing User Forms
  198. Dumb Dim Question
  199. PivotTable Columns
  200. listindex
  201. How do I delete a group of cells
  202. Re: Default to SaveAs
  203. Displaying a message in a message box without requiring user to click anything to proceed
  204. Remove blank rows from combobox
  205. csv info to excel
  206. Copy several range from all files in folder into several worksheets
  207. Excel 97 stuck in calculation loop - maximum cells problem?
  208. Union question
  209. Now Date Formula
  210. linking
  211. How to find a Chart embedded in a Sheet?
  212. Copy Formula to Last Needed Cell in Spreadsheet
  213. CurrentCell
  214. Are the macros allowed?
  215. Changing Values In A Cell
  216. diagram with 2 values
  217. Inserting Entire Rows
  218. Including Spreadsheet Date in a header
  219. Pie chart labels
  220. Why does this keep blowing chunks
  221. Wrong type of Listbox from VBA
  222. hyperlinks
  223. Test worksheet name
  224. changing column button in VBA, need help!
  225. Re: Exporting from Access to Excel
  226. 2 x Case // Error why ?
  227. Running a query based off values in col A
  228. Error 1004 using Shapes.Range().Align
  229. interesting pivot table questing
  230. adding rows and populating them with data from other columns
  231. insert HPageBreaks first instance occurance only - an example
  232. VBmodeless
  233. Need a macro to copy a range in one workbook and paste into another workbook
  234. i have some problem
  235. Border around Data Entered in Variable Rows
  236. Attaching macro to a pivot table drop down
  237. Delete duplicate Name but not the blank rows
  238. Web Query
  239. Re: Question on Linefeeds/Carriage returns
  240. Is It Possible?
  241. Reply For Ronny
  242. How do i insert "If function" in a macro?
  243. Counter & Loop tutorial website
  244. Edit Comment Box
  245. Forcing a date entry?
  246. Linking groups of cells in a row so they will sort together
  247. how do i send email from a macro
  248. Macro to save excel file
  249. How do I get events from a "Split Button Popup" control?
  250. Excel VBA - How to transpose every fifth row to same column on another sheet
  251. Logging on to network drives automatically.
  252. How to delete empty rows in a worksheet
  253. Selective configuration of Manual calculation
  254. Database link to worksheet!
  255. checking to see if a "shared" workbook is already open
  256. how to code factorial in Excel
  257. Save As dialog box in macro
  258. Data copying from WB to WB!
  259. Combo Box Losing List Items
  260. VB Pivot Table Refresh Excel 97
  261. Conditional statements
  262. Date created
  263. VBA Crashes Excel on Compile or Stop Debug
  264. Calculating Winning Percentages
  265. Copying from WB to WB!
  266. eliminating #value when computing average
  267. Question about print scaling and page header/footer
  268. VBA Code Interferring with User's Copy Action
  269. Chart numbering
  270. Re: Weird problem!
  271. How do I retrieve Chart Source (range) and PlotBy
  272. Required sum, need values to adapt with changes
  273. VB Code for MS Query
  274. Excel format
  275. Fill combobox from specified range
  276. Rows.Find question
  277. Deleting the leading character in a series of cells
  278. Cell-format and comparison
  279. Cell Value
  280. Finish one App before closing??
  281. Non text function in two workbooks
  282. naming a range
  283. naming a range
  284. naming a range
  285. naming a range
  286. naming a range
  287. Unable to set the Locked property of the range class
  288. Non text function
  289. VBA code for Autosum command
  290. Re: edit box
  291. How to write a VBA code to select certain rows based on certain conditions
  292. text search between workbooks, copy data
  293. Saving File automatically
  294. Help with simple(?) macro
  295. Re: creating a demo that expires after time
  296. Excel Splitting Up Data By Keyword
  297. fighting the type mismatch error
  298. Transparent problem with frame.
  299. Deleting duplicate rows.....there's more
  300. Creating 1 Single Module For Several Sheets.
  301. Re: Checking for existence of excel
  302. Re: Recommendations on where I can get help by month end
  303. Button fails to call macro when open an Excel file from web
  304. Grey Color
  305. Sorting a 2 column list with VBA using Worksheet change produces 1004 error
  306. Re: Exporting from Access to Excel
  307. Disable Command Button when File name begins with Customer?
  308. find row that contains certain values
  309. VBA Saving code causes SAVED file to be corrupt
  310. Message Box Execution
  311. Excel Data to Web Page
  312. tri dans un tableau
  313. Re: Macros for worksheets
  314. Show the excel filename
  315. Paste Selction In First Empty Cell
  316. Calculation w/ Filter
  317. Cell counting question
  318. Re: Class Instance Identifier
  319. notepad to excel spreadsheet
  320. From Excel to Access
  321. Macro help required!
  322. Excel expression "sumproduct" in Access
  323. Open Worksheet Macro
  324. Macro for Excel spreadsheet into Access table
  325. How do i declare a formula with prenamed variable
  326. Copying and pasting a worksheet to a blank and removing blank rows
  327. How to loop through the data to find the median?
  328. Re: Require cell entry
  329. Using Listbox to specify data in list to enter in textboxs
  330. Copy and paste ranges from a close book using Validation
  331. REad large txt files
  332. why it not writing to target files?
  333. Insert Todays Date - 3 in file name
  334. bound columns - listbox question
  335. Application coding in Web Browser
  336. compare data on 2 sheets
  337. Numbering of Charts
  338. Excel Macro code help - re pasting rows
  339. Error '1004' (Method 'Cells' of '_Global' Failed) On chart creation?
  340. Excel Frequency Function?
  341. Late Bind to Specific version of Application
  342. Array Formula in VBA
  343. Excel Function referencing another sheet
  344. Disable textboxes
  345. late binding onto Word problem
  346. excel queries
  347. Searching a spreadsheet using a vba form
  348. Dev tools (VSS) in XL2003
  349. no valuta sign in cell from combo box
  350. checking what day a date is?
  351. Application.InputBox with Default:=0 testing False
  352. Very challenging
  353. inserting a picture from an excel file into an access table
  354. Type in textbox display immediately in cell - need help on this
  355. looping through ranges: how to speed up?
  356. User function for returning several results
  357. Cancel button
  358. VBA search function
  359. SendMail with Excel VBA - Outlook
  360. setting up a Company ordering template
  361. value in the 1st col of a range
  362. Code error
  363. clearing pivot table field values
  364. SELECT, ERASE, EDIT items in listbox
  365. How To Finish pivot table refresh before cont. VBA code
  366. Excel Table Drawing Data from Access - security??
  367. Resizing Comment Box
  368. VB MACRO ?
  369. Outline.ShowLevels
  370. Combination Models
  371. make date BOLD
  372. Copy/Paste program error
  373. Reproducable Hard Crash in Excel 2003 (and earlier versions) with the following VBA code.
  374. Setting a range value to the last cell in active worksheet.
  375. Tips for optimising page setup .Zoom and .FitTo properties
  376. accessing data from other workbook
  377. Re: Autofit merged cells with wrapped text
  378. text over image
  379. Other way to use "Getpivotdata"?
  380. Populating a ListBox
  381. Help - desparate for an expanded history log without sharing a workbook
  382. copy insert problem
  383. Run an animated GIF in excel 2002
  384. Emailing my spreadsheet?
  385. trans-sheet copying
  386. Emailing my spreadsheet?
  387. How to copy entire row fm an xls file to another xls file?
  388. Name of shape giving VB run-time error
  389. Re: Excel C# AddIn
  390. Re: Problems with AddIn Installation
  391. Improving Calculations with the Excel Dependency Tree/Table
  392. Can't assign to Array .GetRows in Excel 97
  393. Can't assign to Array .GetRows in Excel 97
  394. How do you assign macro's to new menu with buttons on Auto_open?
  395. Displaying messages
  396. VBmodeless
  397. List box - how to uncheck box
  398. Macro Question
  399. LinkSources(xlOLElinks) address
  400. Adding new workbook!
  401. VBA Floor/Celing commands
  402. display in excel stays blank
  403. Problems with pasted HTML data
  404. Cell Data Types (Date vs. Double)
  405. Cant close Excel App from Power Point
  406. Re: Saving a workbook as PDF in Macro
  407. problem opening Huge XLs file
  408. Error number 1004
  409. Microsoft Certification for VBA
  410. Excel/Access Program
  411. Matching two sheets
  412. Naming cells using partial cell data
  413. Re: Open workbook - prevent macros
  414. Re: VBmodeless
  415. User defined function
  416. Random password gen - Excel VBA
  417. Quick! Help With Code Formatting!
  418. Setting a default profile when invoking Outlook in a Procedure
  419. Variable Macro
  420. Unable to Set LeftFooter Property Class PageSetup (ASP)
  421. Find according to sheet 2, Delete rows in COL A
  422. Copy Worksheet without VB code attached?
  423. Cancel error
  424. Changing the values of variables
  425. connection test
  426. Run-time error '1004' unable to get the ChartObjectsproperty of the Chart class
  427. Re: Saving a file via a Macro?
  428. Error msg for "ShowAll"?
  429. VBA Question: going through rows in a sheet via vba
  430. Using Countif in VBA
  431. Re: Multiple User Forms
  432. MS Excel 5.0 Dialog
  433. Intro to VBA
  434. RE: listbox and variables
  435. Simple Excel Question
  436. Excel VBA - determining range
  437. Macro selecting wrong cell range
  438. Populate a series of values
  439. Complex Numbers
  440. Stumped
  441. Transparent problem with frame.
  442. trying to combine cells with shortest equation
  443. Consolidating data using a macro - Help!!
  444. not found
  445. Retrieving the sheet names of another workbook
  446. Array difference?
  447. Increment array range
  448. Adding drawing to index, need to shift everything down
  449. Showing a Msgbox in the active application
  450. Command Prompt to a Directory
  451. Print Preview
  452. Phantom Links
  453. Setting Printer
  454. Calling a function in another project from within a cell formula
  455. Data exchange between vba and excel
  456. Calculated Formula
  457. GETSQL Is too slow
  458. Excel mouse functions?
  459. Delete line if value in column C = ""
  460. select multiple items in olap pivot table
  461. trouble removing rows
  462. Sheet Names
  463. Linked Excel Chart within hidden Word Application Visible
  464. How do I Copy data dynamically to a calculated cell
  465. Arrays as Arguments in Functions
  466. Create copy of spreadsheet
  467. Changing Cell Contents Based Upon User Input
  468. Debug issue with macros
  469. Macros that write data to a new spreadsheet?
  470. Run-time error from my code
  471. list of commands for excel? where?
  472. TextBox InputMask???
  473. Writing Excel Formula To A Cell
  474. Button Selection OnAction property
  475. Relative Position in VBA Array
  476. Using VBA to track changes in a worksheet - help! Event procedure??
  477. Re: Split method
  478. Detecting Excel 97 using VBA
  479. Autofit merged cells with wrapped text
  480. Is there an add-in or a utility for Excel Packaging?
  481. List of Excel DDE commands
  482. opening a shared workbook
  483. how to get the digital signature for my excel sheet?
  484. Disabling code using a button?
  485. Changing DataSource of a Chart
  486. Group/Ungroup Protected Sheets
  487. problem when drawing textboxes in excel using macro
  488. why doesn't excel97 winNT vba macro code work in excel2002 winXP???
  489. Can somone speed up this formula?
  490. Add-In needs to create CommandBar
  491. Set cell text direction (degrees property?) via visual basic
  492. xl2002 doesn't understand macro written under xl2000
  493. Macros and validation lists
  494. Newbie formula help required pls
  495. Creating Directories
  496. Advice about loop and cell action
  497. How do you assign macro's to new menu with buttons on Auto_open?
  498. Problem Dragging Formulas
  499. call VLOOKUP from Macro with Variables
  500. How to determine the length of a .prn file.
  501. PRoble with subtraction
  502. Reporting number of rows on a userform
  503. Excel assumes too much
  504. Multiple Access in Excel ???
  505. Using VB, how to check if Excel Row is grouped as well as the level?
  506. quick code request
  507. Code for new row and specific filling down
  508. Checking for a Task on windows?
  509. Removing Blank Rows?
  510. Excel VBA question
  511. Compare and replace values
  512. Changing field in Pivot Table with macro
  513. Formatting Excel worskheet
  514. Move to next cell
  515. graph with sevral datasource
  516. Changing the Mouse Pointer to Hand just like on Hyperlinks
  517. Keeping an Array Filled and running macro from other workbooks?
  518. macros and file security
  519. VB.NET to Excel
  520. how to delete all macros - save file with cell-name
  521. CommandBars
  522. ISERROR
  523. SETTING PRINT AREA IN VBA
  524. Excel VBA - loop code problem
  525. Emailing a selection
  526. training people with excel
  527. Extracting metatags from a web page and inserting them in a worksheet.
  528. Hiding Rows
  529. Conditional formatting formula
  530. VB for copy & paste values (not formula's)
  531. control advancing to cells
  532. move data between sheets & keep running total
  533. Case Statement error
  534. Saving from form into multiple sheets
  535. More HpageBreaks Strangeness
  536. Password format
  537. VBA Excel - Compile Error: Out of Memory
  538. Find Last Column, Select, and Bold
  539. Error 1004: Unable to set the XValues of the Series Class
  540. Getting Around Heading Restrictions
  541. Conditional Information on Printing
  542. Macro/function to indirectly reference table?
  543. Number of pages
  544. Import selected lines from an Ascii file
  545. Find a day and copy
  546. Excel 2000: Unprotected cells - how to prevent cursor from wrapping ???
  547. Excel 2000: Combo box cell link protection question
  548. Excel 2000: Unprotected cells - How to prevent cursor from wrapping?
  549. Changing values in formulas with VBA
  550. Adding a named range to a cell
  551. Select Range every 20 rows copy & paste special
  552. Selecting cell above a #N/A
  553. excel calculations
  554. What is the best VBA book out there for..
  555. Removing special characters and extra white space
  556. Variables
  557. Regarding the lstrlen
  558. User Form sites
  559. Clean Up Background While Running Macro
  560. AddIn installation problem
  561. More efficient way?
  562. How to execute an SQL insert/update from Excel for Mac
  563. Acos Function
  564. Trouble getting used to VBA
  565. error number to determine if shared file is open on "this" machine
  566. Cell data to a userform object
  567. Deactivate autofill
  568. Excel Troubles
  569. Re: Column Headings
  570. Nested loops??
  571. same workbook hyperlinks
  572. Excel VBA - Checking for inactive hyperlinks
  573. AddIn installation Problems
  574. AddIn installation Problems
  575. Better Way to Write This?
  576. Help Needed: Calculation error
  577. Anything I need to load or special tips for Ontime to work
  578. How to line a DropDwn w/a Named Range?
  579. Ontime run at a particular time
  580. Averaging a variable length column
  581. HLOOKUP Question
  582. Open a new Directory
  583. copy & paste to all Sheets to the same cells
  584. Can't get .value=.value to work
  585. Different versions Excel errors
  586. Re: Different Random Numbers
  587. Error in my code?
  588. Error in my code?
  589. Re: Different Random Numbers
  590. Repeat Error message
  591. Diff versions of Excel!
  592. Match (Fucntion, Script, or Macro)
  593. Pivot Table Macro to run in XL2000
  594. Iteration performance issue
  595. Paste values only
  596. List Range
  597. userform delete sheet
  598. Message box- Assign a file name to a variable, from user input
  599. RS-232 Serial Communication
  600. Protect ALL cells If Q
  601. Move ActiveCell down 12 then add up 11 above....
  602. Reading from TextBox
  603. macro problems with Workbooks.Add Template
  604. Convert value
  605. Multiple windows
  606. Custom function - argument description help
  607. Run code based on cell contents
  608. Unlock sheet
  609. Reference Help, please
  610. Change format of single word in cell
  611. createfolder
  612. select ranges of cells relative to location and then paste
  613. Text Wrapping Problem
  614. ODBC ControlSource
  615. Open up workbook but dont update links
  616. Running a Sub and exiting the current one.
  617. Check if value in list
  618. forcing 'macro enable' on open
  619. counting the rows that match in my loop
  620. Changing text to numberformat via textbox on a form
  621. Normal Days to business days
  622. Default Save Location
  623. I have trouble in the hidden sheet range
  624. script/macro that can compare data of two columns
  625. How to automatically adapt column width with XML format?
  626. un/protecting VBA project
  627. Field length in Cells
  628. Assigning a Macro to a Shockwave File
  629. Drop-down list in datavalidating dissapeares
  630. Excel 2003 and Application.Quit
  631. Query Tables
  632. VBA - Left Shift to be Activated when Sheet is selected.
  633. VBA- Counting the number of the sheets
  634. Can we create pivot table dynamically
  635. A few questions
  636. PowerPoint datasheet
  637. Charting in PowerPoint using Excel
  638. Advanced Filter - Help
  639. Recognise filter in macro and ignore.
  640. Actively update macro reference?
  641. efficiently copy values from a Range of cells to an array (in VB.N
  642. efficiently copy values from a Range of cells to an array (in VB.N
  643. not able to set a sheet name having two dots.
  644. Macro to make period visible in pivot table
  645. static commandbar Button
  646. minus
  647. Processing Overhead during Cut/Insert
  648. Enter a cell value from a VBA macro
  649. Moving through sheets
  650. DoEvent
  651. Loading Bar
  652. Creating menus manually without VBA?
  653. Textbox validation
  654. Dispalying A text in Commnadbar
  655. pivot table refresh
  656. Delete Temporary internet files
  657. Function or macro help
  658. Little bug in my userform
  659. Unexpected Internal error when calling a function (Excel/MapPoint)
  660. Is Relational Hierarchy Possible with Excel
  661. Run Macro when Cell changes
  662. Doing a find and replace in a text file
  663. Macro lock/unlock and Auto Filter script issues
  664. Communicate with Internet Explorer from Excel
  665. Trouble with filtering form - newbie
  666. Determining text in a cell
  667. Re: Open .txt, Save as .xls from command line
  668. still can't assign MACRO
  669. how to code for automatically sorting ?
  670. Macro as alternative to limitations of data table...
  671. using range in formula
  672. how to set macro using cell location
  673. Pressing "Enter" to run macro
  674. cell listbox
  675. External reference an entire worksheet
  676. Split a time entry into shifts
  677. Save as Web page in Excel 2002
  678. Page Breaks and Subtotals
  679. Incorrect formulaR1C1 when activesheet is chart
  680. Progress Meter during macro execution
  681. tricky Excel/VBA/Access needed
  682. ComboBox Format Problem
  683. Open with Macro
  684. Week Ending Formula
  685. Need help with Syntax
  686. Deleting a Column from a Workbook
  687. Re: Array is best?
  688. Excel 2000 formula recalc problem
  689. Hiding Labels
  690. Mid
  691. an excel dunce pleads for help
  692. One-line bar chart for %
  693. Import English Text and Convert to French
  694. Prevent drag copy
  695. Code to sort/delete rows
  696. Re: Another Late Binding Question
  697. entering data to develop a pie chart
  698. Adding Duplicates
  699. VBA help with Query
  700. Chart data series
  701. Subset Percentile Function
  702. Removing Macros
  703. help creating a macro
  704. BeforeClose Dilemma
  705. Macro to print to 1 pdf
  706. Re: Sum Product Formula Issue
  707. loop random number
  708. Combo Box code
  709. variable stored in Excel - read only from VBA
  710. workbook name (? function to return)
  711. Re: How to use combobox contents to get information for userform
  712. Newbie question: Importing modules (.bas) at startup?
  713. Querying Excel-Sheets with ADO using Inner Join
  714. getting the cursor to show in a textbox
  715. Re: Customizing the Locked Cell Warning Message Box
  716. Deleting minimized Rows in a group
  717. RE: convert today() to today's date
  718. Deleting a file, created by macro
  719. Game security code needed
  720. Re: Making add-in available
  721. Copying data from several worksheets and merging into a new worksheet
  722. Activating Worksheet Controls - "Excel VBA Problem"
  723. Wierd conditional formatting result (oops pressed send to soon!)
  724. Wierd conditional formatting result.
  725. Re: How come this range definition is invalid?
  726. UserForm label doesn't load?
  727. Changing Data Source
  728. Re: # of specific characters in a cell?
  729. Re: Looking for Solutions
  730. datagrid
  731. User Forms - passing data between them
  732. Filtering and Separating Data
  733. help with Msgbox
  734. incrementing on inserrt row
  735. Re: Thanks and Gratitude
  736. userform delete sheet
  737. Call vs. Run command
  738. Search Rows in a spreadsheet
  739. hiding row and column headings
  740. Logon information
  741. Locking and unlocking a workbook
  742. join blank rows
  743. Numbering files according to existing files
  744. Excel formatting
  745. [Group]
  746. probrem linking a chart
  747. Creating multiple folder levels
  748. userform CheckBox print
  749. Pivot Table Ordering
  750. Open with VBA - hide passwords in code?
  751. Formatting via VBA
  752. Select a value from one list, presents outcome from two lists
  753. Add Arrow to Form?
  754. Copy cell contents to another worksheet
  755. Office Web Component Licensing
  756. What control to use?
  757. Import from web using query-format problem
  758. Error accessing external object property vbe
  759. Excel and .NET
  760. Code to disable "paste" as an option
  761. PIVOT TABLE REFRESH PROBLEM
  762. create multilined invoice (subtotals on each page)
  763. Auto Re-Size Screen View
  764. Re: Reduce the stock when place order
  765. add date to a chart title?
  766. Resetting Combo Boxes
  767. Change buttoncolor on button on a sheet from VBA
  768. userform CheckBox print
  769. InputBox - Browse
  770. Lotus Notes Q: Copy'n paste from Excel AND place Excel attachment
  771. ComboBox & ListBox problem
  772. Make a Excel Chat through Visual Basic 6.0
  773. Paste Special atop original sheet in Macro
  774. Getting rid of macro warning window
  775. hide / unhide range
  776. Getting Data From ACCESS 2K
  777. DDE and scrolling
  778. Re: VB and Help Windows Maximized
  779. A Macro to autofind a value in a range
  780. Excel Macro
  781. programming a hyperlink
  782. Macro editor passwords
  783. Excel 97 crashes
  784. Personal.xls..2000vsXP
  785. Loop more efficient ?
  786. File Loading Problem
  787. dictionary keys
  788. how to make a chart from formula values? VBA
  789. Filtered Rows / Numeric Data - Automate Position of Total on Worksheet
  790. How can you do this?
  791. The old application.quit problem
  792. string problem
  793. Error Handling
  794. macro from General to This Workbook
  795. Copy and Paste to Bottom Row?
  796. Excel - web page interaction...is it possible?
  797. Newsgroup protocol question
  798. Displaying Excel charts in VB
  799. Re: How do delete every second Row
  800. Re: VB6 and Excel - 1004 error
  801. Opening and closing many spreadsheets from .NET
  802. arrays
  803. Re: The old application.quit problem
  804. Re: The old application.quit problem
  805. Create combo box in Excel using VB editor during run time
  806. How do you hide a row based upon cell criteria?
  807. creating workbooks(with macros and userforms) programmatically
  808. reformatting a table
  809. Import Text File
  810. Formats in Listbox?
  811. lookup source for Macro from a dynamic Range
  812. Converting Dates
  813. Excel VBA - Action if a cell holds a certain value?
  814. protection and macros
  815. two dataset comparison
  816. Function debuging help
  817. Excel VBA - Found last row number but can't select it
  818. Text color question?
  819. Printing 11" by 8.5"
  820. Increment value inside conditional format
  821. Other language
  822. Re: Hiding cells based on formula result
  823. Hiding cells based on formula result
  824. Shared Workbook grows bigger when saved
  825. Strange behavior Chart.SeriesCollection(n).Values property
  826. Hiding cells based on formula result
  827. Setting up deposit account
  828. using variable inside activeCell reference call
  829. loop through all named ranges
  830. Menumaker problem
  831. Deletion of rows according to background color
  832. Opening as Read Only
  833. Where would you like to save - Name?
  834. Open external book before updating links?
  835. "what triggered the event"
  836. Sorting columns with multiple rows
  837. Data import odbc
  838. Excel VBA - Capturing a checkbox caption into a worksheet.
  839. select all & copy in word from macro in excel
  840. vLookup to another open spreadsheet
  841. Can't check checkboxes in userform ... sometimes
  842. About the use of "Getpivotdata"
  843. Tracking Changes
  844. Sarbanes Oxley Question - tracking changes in macros
  845. closing form w/ Maco
  846. closing form semi permantly
  847. Sum the first 10 numbers in a 26 cell range
  848. Rename Files from Explorer
  849. Navigating To Find A File
  850. Double click funtionality
  851. convert whole excel file to vba (tough question?)
  852. Programming double click functionality
  853. Can not write string to a cell
  854. Creating Word Documents with an Excel Macro
  855. weird date issue
  856. Counting Fridays in a month
  857. ComboBox problems !!
  858. RE: macro does not sheet name
  859. Copy same data from all files in folder
  860. Autofit column width of all worksheets in active workbook - an example
  861. Newbie: Conditional question
  862. Delete everything after a certain character?
  863. application.Value(Variable)
  864. Two Different Columns of Dates
  865. MS Query
  866. Creating dynamic (formatted) tables
  867. Display a picture depending on a value in a specified cell?
  868. GUID of the Reference
  869. Copy a range of cells in an unopened workbook and paste it to the current workbook
  870. FileName
  871. HLOOKUP Question
  872. converting to excel file
  873. if cell empty hide row macro?
  874. locked cells
  875. Like Character?
  876. question on arrays in vba
  877. comandbars/toolbars
  878. Run Macro Upon Opening
  879. Copy And Paste Rows
  880. Variable File Name
  881. Tom Ogilvy - 'Snap to'
  882. SUM Function Yields Zero Result
  883. Unfilter
  884. Cell text format
  885. Using SUM with worksheet range selected by two combo boxes
  886. Formatting Header and/or Footer Dates
  887. VLookup
  888. Date Formats in Headers/Footers
  889. Re: Calling a function without starting with "Personal!"
  890. Application.ScreenUpdating malfunction
  891. autonumbering only when original file is opened
  892. deleting the last nine characters in a cell
  893. Excel VBA Format Row on Condition in Cell
  894. Sort list by color (makro)
  895. Excel No-Launch
  896. Newbie needs help with formula
  897. dynamic list to remove duplicates and spaces ?
  898. VLookup in VBA
  899. Same variable name in different projects
  900. automating delection of certain rows
  901. trouble displaying as text
  902. Deleting entire rows
  903. Selecting Variable Rows
  904. convert a number of seconds to HH:MM:SS?
  905. snap to from vba
  906. Using Validation list to copy from another Workbook
  907. Combine Closed Sheets
  908. Capturing Excel Opening
  909. Error in 2003 which is not in 2000
  910. Method of protection fault when sharing file!!
  911. How can i access a listbox?
  912. How access a listbox on a worksheet
  913. Need Help on Web Query - Thanks in Advance
  914. Telling MSGraph which cell I need
  915. Last valid value in array
  916. Conditional format cell ranges with loop?
  917. Why do i have to re-assign macro's all the time
  918. Replacement CD
  919. convert 400 word files to excel files fast?
  920. Runtime error with the sheet collection, which was not there in 20
  921. Can I "Save As..." an Excel Sheet to an Access Table?
  922. Address of Merged Cells
  923. Exel VBA - Sheets.Name
  924. formula help reqd please
  925. Pivot table change leaves MSQuery open
  926. switch on 'snap to' from vba
  927. Create a xls File on Server without Excel?
  928. How to schedule a Macro ?
  929. check folder event
  930. hiding the headers
  931. Trust and Signatures in VBA
  932. Equivalent ActiveCell.Id property for Excel97
  933. Question of Import Export Files
  934. Automatically Cut Row of Data and Paste to Other Sheet?
  935. Automatically define series of named ranges
  936. Query between worksheets
  937. creating new folder while saving document
  938. Hiding rows programmatically
  939. Enter Key behavior with Userforms
  940. Using different range names in same function
  941. Help - This macro converts my text numbers.
  942. Clearing Cell Contents
  943. problem with performance of excel macro, pls help
  944. Can't open Excel2003 workbook containing VBA macros with Excel2000.
  945. Compile error for macros
  946. What's Wrong with This?
  947. error (ComboBox-?)
  948. Import text wizard in a macro
  949. A macro to fill in the blank cells
  950. Filesearch in VB6
  951. macro and lookup in workbooks
  952. copy / paste without skipping blanks
  953. Batch Watermark Macro
  954. Mail Merge Programming????
  955. character limitations
  956. character limitations
  957. Advice wanted fromMVP's.
  958. searching for the first few characters in an active cell
  959. Deleting a Column
  960. Need to sort based on Check Boxes
  961. Re: Textbox ControlSource Property - Excel 97
  962. Write-Reserve problem...
  963. lookup problem..can you solve!??!
  964. Custom print macro
  965. A Macro to Edit Cell Content
  966. Macro to delete duplicate records
  967. range selection problem
  968. formula question for arrays
  969. Worksheet Event Code
  970. the "&" in buttons
  971. asking for a file
  972. Hide Columns
  973. Button controls on worksheets
  974. array values type mismatch?
  975. Solver automatically in the VBA Reference
  976. easy question on excel/outlook
  977. rnd
  978. Experts help needed
  979. Generate Excel files on server
  980. Consolidate
  981. userform txt box updates spreadsheet
  982. VBA Valadation xlBetween ERROR
  983. How does Solversolve Control Macro
  984. How to write macro for entering mm/yy where it fills to current mm/yy
  985. Listing Named Ranges
  986. Macro works once, not twice
  987. Solver 32.dll
  988. click functions
  989. Dynamic Print Ranges
  990. Aligning login logout times horizontally
  991. Aligning login logout times horizontally
  992. Delete a list of rows
  993. References to XLA files
  994. Excel
  995. Conditional Formula
  996. Increment cells only in filtered range?
  997. Macro VBA Code
  998. Counting Dates
  999. Re: CSV File format problem
  1000. Re: Remove password at the time of opening the workbook