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