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. Selecting the first empty row
  2. Reorganizing rows into groups
  3. changing cell formula part of macro
  4. Excel add-in password prompt and Act!
  5. "Window Trails" showing with Dialogs
  6. Use ADO to add or update date in Access
  7. Change cell fill color from function
  8. mouse pointer question
  9. Looping a loop?
  10. NoFill range of cells
  11. Arrange a list in ComboBox
  12. Buttons won't work
  13. String array issues. Need help...
  14. ActiveCell.Address question
  15. sum if dates conditional
  16. Excel: how do I set page3 to be locked until page 1, 2 are solved
  17. Error:Can't find project or library
  18. Getting rid of extra space after cell contents?
  19. how do I rearrange a column into a series of columns?
  20. UserForm for each Worksheet
  21. How do you capture events?
  22. Should Be Easy
  23. What different between "sheets" and "worksheets"
  24. Add-In - OnAction Can't Find Macro & Subs Doesn't Affect Current Wkb
  25. Hyperlink target should equal parent
  26. Referencing previous worksheets in formula
  27. Excel VBA If statement question
  28. Create a Window without a Form ... !!!
  29. Help on combining declared variable and cell formula
  30. Help on combining declared variable and cell formula
  31. Protecting Specific Cells In Excel
  32. Create a subtotal if either of 2 chg
  33. How to use variables to define range
  34. application run problem?
  35. Have empty cell unless result of formula isn't value of "0"?
  36. Auto Fill
  37. Pivot Tables and Cells.Find
  38. Selection.End(xlToLeft).Select
  39. delete rows if value in column D is repeated
  40. Faster Way of looping through cells
  41. HOW TO ASSIGN 2 DIMENSION ARRAY VALUES FROM 2 COLUMNS?
  42. What have I done wrong with this Macro???
  43. How can I paste formulas only an not values
  44. Customized VBA Editor Format Save Location
  45. how to create sub menu items in Excel?
  46. Find out WHO has a file opened for editing
  47. Values assigned to variables staying in memory when procedure stop
  48. Use a keyboard button to run a macro
  49. Disable Shortcut Menus / Alt-F8
  50. value between min and max
  51. Charts not updating in 2002,2003 but working in 2000
  52. Make a Trial Date Macro ?
  53. my saveas macro date problem
  54. To clear apostrophes
  55. Macros in excel 2000
  56. Using EXCEL with .NET
  57. Trouble sorting data by cell value
  58. Ignore values in a particular row for Grand Total
  59. Two menus appears in commandbar(Cells)
  60. Indication outside an defined area
  61. Closing a spreadsheet?! Please HELP!
  62. Last Saved Date and Time
  63. numbers contain hyphens(norman jones)
  64. sideways sort
  65. detect and remove apostrophe
  66. Find function in VBA
  67. Run a .xla as a independent application
  68. is this vba code correct or is there a more simple way to do this ?
  69. keeping a toolbar attached to a workbook
  70. Formula Help Needed
  71. Macro to add a variable list
  72. +++Help me with a loop... I have no idea what code I need!
  73. VBA - Counting Characters in Cell
  74. Select cells based on named Range and a column heading
  75. an excel template to split costs on a group outing
  76. Code to get a Range RECTangle or PT
  77. add pages in a multipages programming error 217417418
  78. Macro to create chart
  79. Exclude blank cells from a range?
  80. run time error 1004 on protected worksheet when I try to run macro
  81. Do anyone know how to implement the function?
  82. mouse pointer as a hand
  83. Help with defining a Range
  84. Accessing the Desktop
  85. Does Range("A1,B2,C3,etc") have a max number of cells?
  86. Trouble with copy of xlSheetVeryHidden
  87. Control Break in Excel
  88. Refresh spreadsheet from database through ODBC
  89. saving sheet as new workbook
  90. I don'T know how to code in VBA
  91. Please HELP
  92. Control disabled
  93. Selection order problem with code for shapes connection
  94. Removing Empty Rows and selecting Specific Rows
  95. Copy Sheet Values to new WB
  96. scroll with wheel mouse
  97. #N/A - 2 options
  98. restrict scrolling
  99. What should my calculation settings be?
  100. Changing order of embedded charts
  101. setting print areas, and not printing 'hidden' cells
  102. Problems using Application.IgnoreRemoteReferences
  103. Rows & Cols - copy formulas in Col A to # rows in Col B
  104. Inserting a row in all sheets at the same time
  105. use Excel2000 as web interface to collect user input?
  106. Exporting xml problems
  107. IF Statement not Displaying FILLDOWN results Automatically
  108. Pass value from form to form
  109. How do I sum variable rows in a macro?
  110. How protect with password the access of a spreadsheet ?
  111. Emailing Workbooks
  112. Saving Excel file w/o any data
  113. How to add new sheet with certain name?
  114. Scrollbar
  115. Adding a new function to values in the status bar
  116. Update Code to work between 2 files
  117. GetObject Function On Text Files
  118. very hard deleting rows issue
  119. paste method of worksheet class failed
  120. XMLData\Mapping
  121. custom help files
  122. A MACRO ON SUBTOTAL
  123. WAV FILE
  124. Microsoft CDO 1.21 library
  125. Cell color
  126. worksheet saveas workbook
  127. Printing at certain times of a day
  128. Data Validation
  129. Macro: MonthName Function, runtime error 424
  130. Network Drives
  131. Array error
  132. Only a genius can help with this 7 Nested If that doesn't fill down
  133. problem assigning range returned by function, to combobox rowsource
  134. Currency Amounts
  135. Selecting and copying a dynamic range of cells
  136. Check spelling in a single cell AND spellchecking values only
  137. pass workbook name to sub
  138. matrixed table out of pivot
  139. How to find specific subfolders
  140. Saving Data for future use
  141. ToggleFormsDesign
  142. copy passbook data into new worksheet
  143. Filter Total
  144. Can I get a hyperlink to run a macro?
  145. Delete duplicate headings
  146. Copying ranges
  147. Macro to import data
  148. O componente ActiveX não foi registrado corretamente (Erro 336)
  149. open copy paste
  150. exit excel within vba
  151. how to insert a + sign permanently??
  152. Re: Help with returning a Range
  153. cells that start with "Slot"
  154. Help with returning a Range
  155. pls reply Patrick Molly
  156. second line
  157. BeforeSave Problem
  158. BeforeSave Event Question
  159. need macro for renaming bunch of excel files
  160. request code for right align and percentage
  161. Combo Boxes built with Control Toolbox on a Worksheet
  162. Converting Excel Worksheet to PDF using VBA
  163. Excel97: Show UserForm while running code?
  164. cell color adjustment using vba
  165. Launch Web Query from Macro
  166. Suspend Execution
  167. Paste Array into worksheet
  168. no way to import user form into vb6?
  169. Weekday() result differs from one computer to another ???
  170. Macro to copy text upon entry into cell
  171. For each next
  172. how to sum a complete colum on another sheet in VBA
  173. Can you use VBA forms in different applications (VB app and Excel)???
  174. How export all Names to another workbook?
  175. Concatinating cells
  176. VBA - VLookup ?
  177. Copy Data into new worksheet
  178. Retrieve the key (strings) in a Collection
  179. Macro to force Excel to close after a given timeframe of inactivit
  180. Excel XML - Formating Dates
  181. Reinstalled excel, macros broken
  182. numbers contain hyphens to dates
  183. How can enable and disable menuitems based on the type of sheet.
  184. If-then font bold language
  185. Excel Bug Moves Cmd Buttons When Print
  186. Error 13 with combobox
  187. How to use row and column number instead of "E1" designation?
  188. Code occurrences between rows
  189. [Help Needed] Custom Lookup Function
  190. macro that calculates average
  191. Pivot Table Refresh
  192. Compare 2 lists and merge
  193. generating a whole random # from a list
  194. Insert Quatation Mark "
  195. Row Conditional Formatting
  196. what is "\" standard for
  197. Web Page Printing
  198. command disabling
  199. Writing a macro to copy first cell down until next cell has data
  200. Error Handle
  201. Alternative to Copy and paste values in VBA
  202. Drop down - required field
  203. Tab name matches cell
  204. Cell strings as cells
  205. check active cell column
  206. Insert a number of rows based on a value in a cell on active row
  207. Changing Macro Security settings does not work
  208. Forms > Combo Box > Invalid Propery Error
  209. check if worksheet exists
  210. Deleting menu (xla)
  211. macro help for subtotal at top of column
  212. Find Match and count order
  213. RE: Regression
  214. no duplication please
  215. reporting based on spreadsheet data
  216. Using arrays to create Combobox items
  217. checking data
  218. Filtering a Date Range
  219. Not to display Macro list
  220. Application.Transpose and Range of dates/data
  221. Copying worksheet error
  222. Proportional Chart
  223. run-time error '1004': Application-defined or object-deifined error
  224. opening an excel page without the toolbars
  225. IF statement with formula
  226. Is there any way we cna clear everything..
  227. Excel Conditional Combo Box
  228. testing whether the ActiveCell is in a given range
  229. Cannot paste Toolfaces
  230. Macro help
  231. Is there any way we can clear everything..
  232. Advanced Filter - Unique Values
  233. Macro help?
  234. Re: Using a collection as a property
  235. Re: Automatically Send E-Mail
  236. FileName
  237. Finding values in hidden cells?
  238. Using a drop down list -- Autojump to first letter
  239. DropDown rephrased
  240. Send Mail - Code to test whether Lotus Notes / Outlook is used
  241. !! Can you do this !!
  242. Macro freezes up Excel
  243. Run a macro on exit
  244. Filter With VB Code
  245. using this forum...bookmarks? misc??
  246. Array for clearing checkboxes
  247. adding a formula in macro
  248. Macro Error 3
  249. Excel print area size
  250. troubles not bringing in the first row of a ado query to another spreadsheet...
  251. Help writting a macro
  252. Remove addin available from list
  253. Getting chart templates
  254. Goto Specific Textbox in Userform
  255. open as read only
  256. CLOSE ALL macro for XL2K (but with prompt to save for each file)?
  257. DropDown
  258. Help !! - Create files using VBA code
  259. Question of updates
  260. Copy range from loop
  261. References remembered
  262. References remembered
  263. Excel process doesn't close?
  264. How to display current row number in fixed cell?
  265. user form export
  266. Using an Array instead of a Vlookup to improve speed
  267. Snap Object to cell borders
  268. line charts - error in series should not plot (empty)
  269. Sudoku Program Help
  270. Control Array Help...
  271. Help With Forms
  272. Color of worksheet Tab
  273. On Error Resume Next ?
  274. Re: spellnumber twice
  275. On Error Resume Next
  276. Update Format of cells in multiple worksheets
  277. Undo Borders
  278. Macro creates additional datafiles when saving copies of workbook
  279. Is COM over? - what are my options?
  280. CSV File - Date Formats
  281. Combobox with a dynamic list
  282. Unusual Sharing Error???
  283. Unusual Sharing Error???
  284. Using "Find" in a macro
  285. Newbie - Input Form Question
  286. macro password
  287. lookup for repeated PN
  288. Question
  289. Select row by first cell's contents, then past in values.
  290. Looking up a country name and copying to column 2
  291. Runtime error with sheets.add
  292. Embedding Excel in IE and Firefox
  293. What is fastest for this? Small VBA or many worksheet formulas...?
  294. Code to show current hour minute and seconds in a cell
  295. Avoid Control Cell changing.
  296. Re: Migrating to Excel 2002
  297. Sorting Data before close in shared workbook?
  298. Thank you for sharing - VLOOKUP array
  299. Dynamic PageField Items
  300. Linking to an active cell
  301. Interpret HTML in excel worksheet
  302. How do I,implement a recurssive loop using Microsoft Excel ?
  303. Populating listbox based on two (or more) criteria
  304. combing cells with same data
  305. Help on Coumting Unique records
  306. Lables that Change with Names for Games...
  307. Write Line problem when writing simplified chinese characters
  308. adding & Subtracting date & time in VBA
  309. VB code for Moving Rows up and down
  310. auto Refresh MS Query SQL Server
  311. Replace characters from cell values
  312. used range between two cells...
  313. Dynamic Selection Find Function
  314. Newbie : Oracle to Excel Part 2. RDO or ADO?
  315. question about ClearContents
  316. a weird question
  317. LeadingZeros\CSV
  318. How to specify a tab character in excel vba...
  319. Cell Types
  320. displaying yy instead of yyyy
  321. Re: "Compile Error Can't find project or library."
  322. cell splitting
  323. Load UserForm1 on sheet tab selection
  324. Re: Phantom Of The Open workbook.
  325. Re: Using If and Validation to turn a cell on one way or another
  326. Re: how do i start excel and have it use a template automatically?
  327. Re: Save workbook needs to be added Please
  328. Question
  329. call a VBA function for data validation?
  330. Newbie : Oracle Data to Excel
  331. Number of elements in an array
  332. VBA to Adjust an Excel Chart Embedded into PPT while in SlideShow
  333. Populating Userform ComboBox with worksheet names in XL2003
  334. xl2003/vba and Acrobat 6.0
  335. Compare two sets of data
  336. Publishing to web..Macro issue
  337. lists without listbox
  338. Detect Value change of a Cell
  339. Transpose Function not Working with Long Array Elements
  340. InStr
  341. How do I restore the LookIn, LookAt, SearchOrder in FIND
  342. A rude awakening to STATIC variable
  343. opentext command
  344. Excel VBA Help Gripe
  345. Query from ms sql server question
  346. User Interface in VBA
  347. Autofilter - Applying changes
  348. copy from one workbook to another?
  349. Code to Delete Empty Rows in a Word Table
  350. How to Advance a For Next Loop prior to the Next Statement
  351. Compact
  352. there is any limitation for text field when using ADO +SQL
  353. thanks very much
  354. How to attach a code module to a group of workbooks?
  355. How to stop template worksheet visibility
  356. Define Page Setup for whole workbook
  357. Create Summary Sheet
  358. Checking for changes.
  359. Display message: Processing....
  360. Copy range from one wksheet to another
  361. color row based on table
  362. Copying Range Names and values from one tab to another
  363. Macro error 2
  364. Filecopy - Do you need to specify Destination Filename?
  365. there is any limitation for text field when using ADO +SQL
  366. How to set formula with cell reference with a variable
  367. Check for date
  368. Retrieving Exchange Rate Data from a Website
  369. Disabling the personal Workbook?
  370. Problems returning Collection object
  371. Can't set cell value with VBA
  372. intersection with linear range as true argument
  373. Run a MS Access Procedure from Excel
  374. OT -Google group support
  375. excel cell placement by cursor
  376. Copy range from one wksheet to another
  377. Apply LEN result to string?
  378. Table Intersection
  379. Deleting a sheet
  380. Calender problem
  381. optimization
  382. button with hyperlink properties
  383. Copy and paste from ie to excel using macro
  384. Insert a new row with data from previous row
  385. Strikethrough Red and Underline Blue Macro
  386. Protection property of the VBA project
  387. Re: macro_change font style
  388. dialog box for active cell task to speed repeditive task
  389. macro_change font style
  390. Please Help With Chart Code
  391. Splash screen
  392. Update VB refs on insert cells
  393. How do I embed a commandbutton from VisualBasic into Excel
  394. sayı biçimlendirme
  395. toggle box print if value is true
  396. Error 57
  397. how to using Function update cell value
  398. Optimising portfolios with solver?
  399. Formatting text of Forms.OptionButton (radio button)
  400. work with ADO or DAO
  401. update older workbook
  402. Run macro automatically when a cell in a dynamic range changes
  403. Copy conditional formatting
  404. formula for inserting rows
  405. Excel macro takes focus from other programs
  406. Help: VB Excel Problem
  407. League Ladder refinement of Sorting.
  408. Link problem with named range
  409. Add Next and Previous methods to CustomViews collection
  410. Update data at other sheet
  411. Daily Interest Calculator
  412. How to ascertain path of file in adjacent directory hierarchy
  413. VBE(Visual Basic Editor) Keep focus in VBE
  414. vba: Loop to load webpage
  415. Text to Columns
  416. Excel control layout
  417. Reading to a 1-D array...Error
  418. Why my selection is lost with MsgBox?
  419. send group emails
  420. Use same On Error twice
  421. vlookup question
  422. Excel Browser Hidden
  423. Lab Management Program
  424. Hide a series
  425. Code does a continous loop
  426. Tab name = Referenced Cell
  427. String concatenation
  428. Weird result
  429. Macro keyboard shortcuts
  430. Is there a way to do this on a worksheet?
  431. RefEdit control
  432. Microsoft Calendar Control French
  433. Delete Entire Row - Date
  434. RefEdit control
  435. Macro Help - Bolding info
  436. Regional options support for currency
  437. "one time" Link Cell
  438. Nesting Find and FindNext
  439. html form to update excel file on server.
  440. Copy range from one wksheet to another
  441. Macro help to move around spreadsheet
  442. Full path in taskbar
  443. Help: Nested If/And Function formula to VB code
  444. Excel's ODBC driver's field limit
  445. SheetSelectionChange Event find out previosly selected cell
  446. SheetChange event restore old value
  447. PivotTable CurrentPage
  448. difficulty with permutations, please help!
  449. Remove ThisWorkbook code via VBA
  450. Concatenation in VB
  451. get a list of sheet names onto a listbox on a form
  452. assining a varaible to the value in another sheet.
  453. automated print to pdf
  454. Form.Show problem
  455. Help with a Macro
  456. come on, somebody must know how to do this
  457. Re: Get macro to copy one row from excel to a text file. Possible?
  458. read data element from XML file
  459. VBA - averaging the difference of 2 arrays, ignoring blanks
  460. .find =< function
  461. Macro inside of Macro
  462. ComboBox to show a range
  463. Macro fails when not performing "step into"
  464. Looping with Hidden and Protected Sheets/Ranges
  465. How create a nonblank source for a verification list with a mix of filled & empty cells?
  466. Excel is RightToLeft?
  467. Missing Command Buttons
  468. Macros inside of Macros
  469. Capturing timed Data with RSLinx
  470. Anchor chart source data?
  471. Copy via code from a dynamic range using offeset
  472. Looping issue
  473. Use Excel as DCOM object
  474. Time Formating
  475. extract parameter VALUE form a user-defined function..
  476. Changing the comma for a semicolon when creating a CSV file
  477. Auto_Close() not running
  478. find a value
  479. select a range through last cell question
  480. Please help. I beg!!
  481. Download broken
  482. Command help
  483. How to give escape sequence in Excel string literals...
  484. Registered Type Libraries
  485. Insert SUM Formula using VBA (Range Varies)
  486. Hide/Unhide column based on cell value
  487. User proofing an entry
  488. Hide row loop
  489. Looking for an event
  490. Undo Acting Weird
  491. poulating multiple fields
  492. ExcelCharts with c#
  493. interfacing Excel to nonOffice application via DDE
  494. Find Text File Import Cell
  495. FORMAT CELLS
  496. Type mismatch on If rng.Value < "0" Then
  497. New Object - programm code
  498. Programming code to new object
  499. Protecting New File
  500. Displaying date/time!
  501. Counting cells with a specific range
  502. Auto filling using macros
  503. MERGE CELLS
  504. Pivot Table Events
  505. Excel Objects error in ASP pages
  506. Selection Data from a Range
  507. Checking for blank rows in database - with apologies to Norman Jon
  508. find specific data in row and select and copy entirerow
  509. Range Object Misunderstanding
  510. toggle button text colour
  511. Help needed to solve printing error
  512. how to display a found xml's and its bytes on its rows?
  513. Finding the last row in a sheet in a closed workbook.
  514. Help with a copy function
  515. logic problem: help needed
  516. Creating a new Excel chart type
  517. Chart option to suppress zero values??
  518. using excel with asp.net
  519. Read SourceData from Chart
  520. Excel Forms-Can i set the modal property?
  521. Security Signing of VBA Code
  522. edit certain hyperlink after a worksheet is protected
  523. how to get the formula shown in linked cell's names
  524. Password Setting
  525. How to get the name of a range i deternimed
  526. Negative Currency
  527. can I use WorksheetFunctions ON arrays from VBA??
  528. Show picture with transparencies in Image
  529. Changing Series Name
  530. Need help with complicated use of count background color of Cell
  531. run code on opening workbook and apply code to certain sheets
  532. Code to delete a Line in a another code
  533. Parsing a text file to a excel or word form
  534. Auto Open
  535. smart tag tutorial
  536. Looping Checkboxes on Worksheet
  537. How do you look for two distinct patterns (RegExp)
  538. Help in writing an Excel equation
  539. get subtotals results as a variable
  540. Combobox ctrl on worksheet
  541. Excel Form annoyance
  542. Progress Indicator
  543. Programmatically add shapes to a selection
  544. Stop Excel from updating external links when copying in VBA
  545. How to test if a DLL (library) exists
  546. Vlookup but also consider equal to or greater than a valu
  547. Header and Heading Problems
  548. Waiting...
  549. Multiple Lookups
  550. VBA output to text editor
  551. Variable problem
  552. smart & tidy code for many checkBox_Change()
  553. Two Feilds in a combo box
  554. code loops 1024 times not what i ask
  555. What is wrong with this?
  556. Newbie Q: What does "On error goto 0" mean?
  557. newbie question
  558. Select row (with offset) from VB formula result
  559. Gridline Question
  560. Identifying the selected Shape
  561. Export/Import Question
  562. if condition is true than send info to another work sheet
  563. VBA - Selecting Based on Criteria
  564. VBA - Set
  565. Loop Training: Password Finder
  566. Moving a Variant to Array
  567. Excel conditional formating
  568. Personal workbook opens and messes up workbooks(i)
  569. Send Keys
  570. Combo Box or List Box colour
  571. colorindex = xlnone on condition of month of year
  572. web query
  573. Test for first time a workbook is opened
  574. Automatic tab name change
  575. graph function
  576. Merged Cells Value
  577. sumproduct indirect
  578. Patse Rows from one Sheet to another with a Twist
  579. Unable to sum range variable
  580. Changing text size in option buttons on a userform
  581. Purge file of VBA code and macros.
  582. Dialogs SaveAs with different directory
  583. Concatenate
  584. how do i activate tabstop on excel?
  585. Making sure that cells within a row in a database aren't blank
  586. Don't display row if cell value is greater than zero
  587. Can't paste the second time around
  588. VBA to change Button Macro assignment
  589. Compare,copy and paste if true
  590. Scope of Subs?
  591. excel / word problem
  592. Showing criteria in custom filter
  593. Sort a multi column listbox in userform
  594. One Excel Form for All worksheets Lists
  595. Substring check within VBA
  596. VB simple Questions
  597. 2 small problems
  598. Vlookup and date format problem
  599. Worksheet menu bar
  600. Help with Count Function
  601. Repost Excel Server Problem
  602. How to change the font size of Validation List?
  603. Validation List - Word and Numeric Association
  604. Defined Names
  605. Reading RGB background color from cell
  606. Array Formulas. Hardest Question Ever. PLEASE HELP
  607. How to sum PNs/Quantities overmultiple worksheets
  608. Vlookup
  609. How to run an ADD IN using VBA
  610. Problems with For Each
  611. copy website to worksheet
  612. ADO / Excel & Access: User ID and Password
  613. Running Excel macros through DOS
  614. Invoke exclusive excel process on opening this file
  615. Msg Box - User Entry Validation
  616. Error when closing workbooks after running .net code
  617. Add to a cell if a row has a date and a column has a department
  618. Countif
  619. Macro Use Counter
  620. Combine Columns in Macro
  621. Combing and Adding Data in Multiple Rows (Macro Needed)
  622. Visual Basic Macro(VBA) for a password protected file?
  623. Checkcell macro problem XL97
  624. Get External Data Macro
  625. run time error '424' when I run this code
  626. can we get the cell address from the name.
  627. combobox
  628. Pop up warning message!
  629. # of letters in a string
  630. Macro to replace a VBA module?
  631. Iserror change cell color
  632. Group values and sum using loop
  633. Copy Row and row above to new sheet
  634. Problem when hitting an empty cell
  635. save sheet as "sheetname.txt"
  636. RefEdit updating Current Cell location
  637. Finding a string within a cell value
  638. worksheetfunction.vlookup error
  639. Combing and Adding Data in Multiple Rows
  640. moving to next worksheet
  641. VB backwards compatability
  642. Sumproduct Problem
  643. Delete from named range based on Combo Box selection
  644. Pivot Table - Trigger event on drill down
  645. unzipping files
  646. Reposting to get some answers......
  647. Passing Strucutres from VBA to DLL and back
  648. User Defined Function
  649. UsedRange Count for each column
  650. Date in VBA Code Printout
  651. macros or input box
  652. Error in Formula
  653. Error in Formula
  654. Incorrect Formual
  655. Workbook_BeforeClose change event not running correctly
  656. Qusetion about the function
  657. Help please with coding a macro
  658. Function which adds all green cells
  659. Need help importing a text file
  660. Checkbox macro
  661. Conditional Format? - color if cell is modified by user
  662. Send Email from Excel
  663. Printing Problems with Spreadsheet
  664. Using VB6.0, check if Excel / Specific Excel Programmes are open
  665. compile error problem
  666. Selection as String
  667. VBA to extract web data
  668. Get macro to copy one row from excel to a text file. Possible?
  669. RemoveLeadingSpace
  670. Online reference available for x-fering functions into VB?
  671. Copy table information and paste sorted based on specific field.
  672. SendKeys command to select an OptionButton
  673. Running updates reports automatically
  674. Registry Key for Macro Security Level?
  675. Find a specific text item and manipulate cells surrounding
  676. Really Easy But having a mental Blank
  677. csv file with special separator
  678. speed up printing job
  679. Sorting with variable number of sort fields
  680. Custome menu question
  681. Range Manupilation
  682. Macro Errors
  683. Get Stock Quotes Via Cell Look Up
  684. Conditional Formatting
  685. collect data from some files
  686. Macro Help!! 10 mins of your time need PLEASE!
  687. vbok caption
  688. chart help please
  689. Nesting Problems
  690. Running Excel with VBA on server and calculate
  691. Macro to call a file that has a auto open macro in the file itself
  692. code to add a name to the names collection and assign a reference
  693. How to check whether cell has #REF ! error?
  694. Help Needed w/ IF statement using dates
  695. Find keyword and insert hyperlink to cell
  696. vba webbrowser HELP!
  697. Application.GetOpenFilename vs Application.Dialogs(xlDialogsOpen)
  698. To Delete the specific rows when blank is found on column A
  699. Print to PDF Driver
  700. in Excel, how do I set up an alert popup when the file is opened?
  701. function need to return value and update one cell value
  702. macro for import of csv .txt file?
  703. ParseCellData\Copy
  704. Disable 3rd party macros at startup?
  705. calling all pro's!!! macro that can modify dates in odbc connection to mysql
  706. How to batch create / generate and print invoices from Excel data?
  707. How do I set up an APR calculation in Excel?
  708. Clear cells with #N/A
  709. What function in a formula will pull the text used in a Tab name?
  710. Query Refresh message box on opening
  711. Closing a workbook and printing a non-active page
  712. VB simple questions
  713. Automatically overwriting files
  714. Error inserting formulas into a range object
  715. formula
  716. macro only prints out first and last line of document
  717. excel chart export error runtime 1004
  718. how to move the pointer in a filtered selection
  719. Re: Formula Help Needed - Tracking Responses.xls (1/1)
  720. I want to use a oleDragDrop in an Excel VBA Userform
  721. VBA programs
  722. Range issue...
  723. Data Validation: items in one list relate to items in another
  724. Moving files between folders using VBA in Excel
  725. Macro - worksheets to new workbook
  726. replacing help
  727. Launching a macro by double-clicking on active cell
  728. copy heading to each row
  729. Toolbars not appearing
  730. Mod Function Returning Long
  731. Range manipulation
  732. temporarily disable on-load virus scan
  733. Arrays and cell values
  734. copy heading to row
  735. Create logical custom drop down list
  736. portable code...
  737. create detail from summary data
  738. Database maintenance and Database Administration?
  739. New project, not sure where to start
  740. should I use Excel or Access fo this?
  741. Where's the Documentation for the APIs?
  742. offset?
  743. goto function
  744. operator statements, shorting when reusing one of the statements?
  745. password protect
  746. Macro which inserts a column and cut and pastes data
  747. Macro which inserts a column and cut and pastes data
  748. Range as a database
  749. validation - how to show the second column
  750. Selecting the active row
  751. Basic Error Checking in Excel VB
  752. Turn filters on in multiple sheets
  753. Need help setting a range
  754. How do I merge multiple worksheets in excel ?
  755. PageSetup Class
  756. HorizontalAlignment Error in Excel 97
  757. Combo Boxes
  758. Calling in data from a selected cell
  759. Automatically update all worksheets
  760. Save failure after VBA macro
  761. Specify Start Location for GetOpenFileName box
  762. Evaluate and execute a string
  763. Enduring Variables
  764. find first cell not equal to current cell
  765. ADODB SQL help
  766. User name button access.
  767. custom function
  768. Looping until empty column
  769. Odd numbered Range Names ?
  770. Forms: Radio buttons
  771. Macro to apply several conditional formatting criteria
  772. prevent all addin loads on start?
  773. How to get custom dialog box when exiting Excel Spreadsheet
  774. Multiple Deliminators
  775. Orientation of Axis Lable in Pivot Chart
  776. using Text to columns in a macro
  777. ADO Internet Recordset Retrieval
  778. Macro to add cells from unknown number of files
  779. Accessing Property of Custom Type
  780. Deleting Menu
  781. exchanging X and Y in a plot
  782. How can I set Custom DOC Properties in Word from Excel
  783. Remove not required sheets
  784. Office Web Components 11 - Excel 2003
  785. work with two maps
  786. Protect current VBA Project?
  787. Help with an Indirect formula to reference sheet names
  788. Version Incompatibility
  789. Dynamic validation list
  790. VBA code to check if a custom chart exists
  791. Excell cuts string when copying
  792. Page breaks
  793. Webqueries and variables problem
  794. Formula Help Needed - Tracking Responses.xls (0/1)
  795. Need Help with marco and autofilter
  796. Filtering a database then copying visible cells based on CurrentRe
  797. How to past formulas without updating external links
  798. VBA form basics
  799. VBA form basics
  800. Open file, copy field and paste into an Excel doc! - Pl help ..
  801. Open file, Copy a column and paste this into a new Excel doc - Pl
  802. Fill down formulas without activating the sheet
  803. Copying named ranges from one sheet to another
  804. Challenge to pro's
  805. globally catching any error event?
  806. Carriage Return from HTML file
  807. Second window open as a sort of dialog
  808. time specific macros
  809. vba routine for sorting an array
  810. Macro syntax difficulties (long post)
  811. stop excel file opened as read only if already opened by another u
  812. Remove text from Comment and paste into cell
  813. Macros for Protect/Unprotect all sheets in a workbook
  814. Excel VBA to email a hyperlink from a textbox
  815. Conditional Message Box
  816. xla written in C#
  817. Intercepting Save and Exit menu command in Excel
  818. Delete Rows when Blanks are found in Column A:A
  819. button for changing language???
  820. addin and main menu disappears
  821. VB dll, Excell and matlab
  822. Inserting 10 rows after a specific row
  823. Pivot Tables & not printing blank rows (revisited)
  824. EXCEL+DATABASE_M3-LITE-Free
  825. Display formula in all worksheets
  826. como encuentro un valor de una tabla dinamica con buscarv?
  827. Data Entry Form
  828. MsgBox in Access Automate Excel
  829. Re: How to open comma delimeted files automatically
  830. Enable OLAP Pivot Table in Protected Excel 2003 Worksheet
  831. Can you schedule a workbook to open?
  832. Help pulling data from web page
  833. filesystemobject not defined??
  834. Capturing Unknown Subfolder Name
  835. Code fix need help please
  836. Looping through control
  837. Find&Replace text in Comments
  838. Loop through rows using a wildcard.
  839. Re: Pass switch to Main procedure
  840. Slow macro
  841. Attaching an Outlook Library programatically
  842. How to got the position of a cell/range in pixels (from the left-top corner) ?
  843. Getting data from web page
  844. Code to write out all lines of code
  845. Calling a cdecl DLL from VBA
  846. Run a stopwatch for time then execute code
  847. Msgbox in Excel from Access (Correct)
  848. Out of memory
  849. Msgbox in Excel from Access
  850. Convert "Month" to 1, 2, 3...12
  851. After Entry - Lock and Go to Certain Cell
  852. Re: my code is adding single quotes
  853. Using a timer
  854. change column width based on concatenated cells
  855. Re: my code is adding single quotes
  856. Protecting or Hiding VBa Code In a Workbook
  857. Re: Please help.. VLookup Macro
  858. Re: how to update a Batabase with data from another database
  859. square chart with excaclty defined dimensions
  860. Problem opening Excel file > 1 time with embedded Word objects
  861. can a macro imitate autofilter
  862. Saving File with information from Text Box
  863. invalid sheet name problems
  864. short cut keys work- run macro does not
  865. How do I run WMP as an ActiveX object from Excel-VBA
  866. Macro for creating a chart
  867. Functions not working in Excel 2000
  868. Delete a module
  869. For Next help? I can't figure this out.
  870. Removing rows via macro/VBS script
  871. Application.Undo failing with specific order of events
  872. Excel - Copy and append Data
  873. Need macro to updated column C's width on 1000+ workbooks.
  874. Working with and adding Menus?
  875. Jump to next line in box...
  876. Error Message: Serious Error
  877. Addin loads but functions don't work
  878. Can I create a add-in in Visual Basic.net Standard 2003?
  879. Require password to execute macro
  880. Formula to reference sheet number base on cell
  881. Find and Several Sheets
  882. Pull down menu in grid
  883. How to get formula type in VBA
  884. Re: square chart with excaclty defined dimensions
  885. Performance long/single comparison vs converting single to long
  886. Conditional Formating
  887. calling a macro
  888. Dynamic Range Offset causing problem with this code
  889. Event Listeners on a protected chart
  890. Automatic update of Financial Spreadsheets
  891. Did user Save?
  892. Alter data or start macro from a date formula
  893. First MsgBox. Need help
  894. Real Time Macro
  895. Is there a workbook open in Excel?
  896. "running" page
  897. Repost Excel Crashes on Workbook close!!
  898. VB macro - Nested Calls ( Parameter Passing )
  899. Can protect worksheet then workbook but not Protect and Share in code
  900. How To Run VB Macro from C/C++ exe
  901. Passing objects by value instead of by reference
  902. I cannot do the oopy paste command in multiple selections in the .
  903. Re: Please help.. VLookup Macro
  904. Date stamped comment box
  905. "Save As" VBA code errors
  906. Project is Unviewable
  907. selecting column down to variant cell
  908. Incorporating DATE into formula
  909. Push the button
  910. Data Valiation and Excel Data Forms
  911. Minimizing a workbook or worksheet
  912. Listbox data disappearing (from screen only)
  913. VLOOKUP in another workbook/Access database
  914. Paste code running extremely slowly...
  915. Excel to Access using VBA
  916. Msg Box Help
  917. Interactive web page
  918. Calculate Rating
  919. Using classes to store user credentials
  920. Converting Text to Values
  921. Code needed to print multiple workbooks
  922. Saving different files based upon data in particular column
  923. Userform and screen resolution
  924. VBA - Large Arrays
  925. Combine Two vba Lines(If Condition + Vlookup)
  926. Environment Variable
  927. extract filename from full path
  928. whats wrong with my macros
  929. Array in VBA
  930. Excel XP VBA Array formula
  931. Show and Hide Forms
  932. writing a formular into one cell of an excel sheet
  933. macro to save a values of a cell in a new sheet as a new row
  934. User Form
  935. Bizarre macro problem
  936. Excel and the web
  937. HOW DO YOU SET UP A CONTENTS PAGE OF EXCEL DATA
  938. Macro to copy filtered list to new workbook.
  939. Should we use VB.net or VB6 to create an add-in?
  940. MousePointer
  941. Worksheet names to variant arrays
  942. Crystal report loading problem
  943. Private Sub SendMessage ...
  944. Unhiding hidden rows in a worksheet
  945. General ?? regarding Macro or Module size in a spreadsheet
  946. Find and write
  947. TextToColumns Method - Delimited by Double Spaces
  948. Data From Excel Range To Existing Access Table
  949. Names Problems
  950. DIM problem
  951. Workbook Names
  952. Shell function and error trap
  953. VBA type mismatch error
  954. How can I include a " in my string?
  955. Enable OLAP Pivot Table in Protected Excel 2003 Worksheet
  956. runtime error '1004' object '_Global' failed
  957. Worksheets Names
  958. Calender Problem
  959. How to process selected rows
  960. Changed location of Add-In file--can't be found error
  961. Hide worksheets on Workbook_Open
  962. copying data from Powerpoint to Excel
  963. MultiColumn ComboBox
  964. How to lookup and sum multiple values based on multple columns
  965. Extract line and copy
  966. Change hyperlink address
  967. VBA equivalent of match
  968. using strDb to connect Excel to an FTP site w/password
  969. adding a cell to a cell keeping a running total please help
  970. Macro Help
  971. Run Excel Macro through Batch file
  972. combobox from forms toolbar
  973. How do I open a file from a Network drive using Excel VBA?
  974. Button on Chart
  975. Help with activex listbox control
  976. ActiveX Listbox Control
  977. Auto Fill Entries in a column
  978. Putting a formula in place one time for the entire spreadsheet
  979. Need VBA macro to return active cell address (R1C1)
  980. Make a macro run on rows/columns only if data is present?
  981. Shuffle the cells!
  982. Incorrect formula created
  983. Arrow right code?
  984. Concatenate with Underscore in formula
  985. trouble with advancedfilter of date column
  986. data find and add for summary
  987. how to code variable reference?
  988. Find in a loop
  989. Created another spread sheet if SSN is not match
  990. how do i write and implement "pop-up" help for a user defined func
  991. Retrieve Excel Cell Range into SAFEARRAY (VC++)
  992. Importing file handle name with pasted data
  993. Error trying to select a cell
  994. Computer Time Zone
  995. how to select current range
  996. file folder macro's
  997. excel - On hyperlink click find what cell or cell value is
  998. Changing icon
  999. Error Handling
  1000. Excel crashes after closing workbook