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. Split Up Excel Table
  2. VBA help please !
  3. Problems closing Excel correctly by code
  4. How to Capture Edit Cell Event?
  5. Linking Data
  6. Opening a file without the macro start menu
  7. Override excel's printing dpi setting
  8. autosave
  9. Worksheet Custom Properties
  10. Using VBA Replace function for single quote
  11. Protect multiple sheets in one time
  12. setting format plot area in charts to white(automatic)
  13. Exporting data from Crystal Report to Excel - Need soln
  14. seprate and store string in arrays
  15. Changing Chart Colors
  16. Insert Rows
  17. Break all links in the workbook
  18. Declaring Constants that can be used throughout the Workbook :)
  19. VBA
  20. How do you add 1 to an invoice number in Excel. Formula for this?
  21. Can I disable Worksheet_activate???
  22. Best Way To Install Add-Ins
  23. clock control
  24. How do I use an Intellimouse to scroll listbox enteries in ExceL?
  25. creating function with multiple arrays in arguments
  26. sumif / countif question
  27. How do make it a connection of Access Database from Excel?
  28. Timing Issue??
  29. Need Help with copying and pasting with var.
  30. Need Help With Export Code
  31. Passwords
  32. can't update chart series unless its activated
  33. Looping Through Charts / ChartObjects
  34. Runtime Error on Simple Sort
  35. More used range Q's
  36. Delete Rows based on an external list
  37. Dealing with old higher versions in registry
  38. help again function >vector>function
  39. run-time error ‘13’
  40. Abort recursion
  41. How do I set a comment in a cell with VBA?
  42. Duplicate a picture image into multiple cells
  43. Suppress sub totals on pivot table
  44. How do I generate a list of 5-digit numbers in Excel?
  45. Copy data from 3rd worksheets and pasting to active worksheet
  46. advanced filter
  47. Printing
  48. Help with Macro
  49. Combinations
  50. Concatenate VBA results and an * in a cell
  51. IsNumeric("121d1") = True ??
  52. Help needed - seriously (looping? macros? formulas?)
  53. Yet another error
  54. Combinations
  55. Disable Paste Special
  56. array formula help please
  57. writing information from a userform to an excel sheet
  58. Macros with hidden sheets!
  59. I need Help - Importing name files to datasheet
  60. Creating First UDF
  61. Data Entered in Multiple Rows to One Column
  62. Error message for Imporint External Data
  63. Inputbox Question
  64. Microsoft Script Editor?
  65. VLOOKUP statement too long
  66. Create Microsoft Outlook CalenderEvents from data in Excel Spreads
  67. Copy Worksheet to specific row in another workbook
  68. Using LEFT in a Conditional Format
  69. Worksheet specific code
  70. Creating a hyperlink shortcut in the spreadsheet.
  71. Macro Error
  72. Export from Access to Excel
  73. ActiveX button on sheet too big
  74. Referring to Values in a seperate Worksheet
  75. Cut, Paste and Move to next Row
  76. NOVICE :!! PLS help calling function!!!!
  77. Declare at application level
  78. find next? urgent
  79. deleting rows, endless loop maybe ?
  80. Macros Written in Excel 2000
  81. Userforms Question
  82. Having troubles using visual basic to paste info from one workbook to another
  83. HLookUp
  84. Comments
  85. msg box
  86. Re: Blinking Cell (Worksheet restarts)
  87. Excel 2000 : Error 1004
  88. Financial Quarter from dd/mm/yyyy
  89. auto expand row hieght of merged cells
  90. During filling Excel Sheet copy/paste in Explorer does not work
  91. Else without if?
  92. create named range specific to worksheet
  93. while macro is running...
  94. Invalid watch expression
  95. Howto prevent automatic calculation when open a CSV file
  96. How to "update" SpecialCells(xlLastCell)
  97. Problem in compiling code containing "$" char
  98. Setting zoom of 2 sheets equal
  99. Working on interactive worksheet (need help with highlighting and blinking cell)
  100. Re: Blinking Cell (Worksheet restarts)
  101. Macro updates
  102. Enumerate form items
  103. Controlling dialog programatically
  104. Replacing Formulae With Values.....Continuation
  105. Print Selectd Rows
  106. how to run macro after changes in a cell?
  107. Late Binding to Word Variables
  108. Workbook/Macro/Worksheet Protection...
  109. Possible to see which user is editting/using file?
  110. InStr function question
  111. referencing a checkbox cell address in a worksheet
  112. Hide columns in a group on after VBA-procedure
  113. declaring a certain value
  114. If find is true then.....
  115. lock cells for editing-pawan
  116. Filtering by Cell Background Color
  117. Open Lotus 123 file
  118. Listbox navigation
  119. Module 1 - Subscript out of range error
  120. Linking files with variable directory path
  121. Last row as value
  122. Windows NT - Templates - UDF - Links
  123. Module1 vs Thisworkbook for Macro
  124. Detect if a file is in use or being modified
  125. Database
  126. Tabular to CSV style layout
  127. Creating a function call from from
  128. Problem of Crystal Reports in .NET 2002
  129. can we shrink images to fit?
  130. Passing Worksheet Names as Variables
  131. Difference between XIRR and YIELD
  132. Put items in combobox using VBA and toolbox
  133. send msg same as netsend
  134. Flashing command button
  135. What type of Array is this?
  136. Run macro from an excel file from another one
  137. Need help for a loop
  138. AutoFilter
  139. Using a custom format on the clipboard
  140. Menu-Item and worksheet deletion questions
  141. switching from one window to another
  142. vlookup for an approximat lookup value
  143. Problem with Remove Subtotal in Macro
  144. type mismatch
  145. Clearing a userform
  146. extract information from a spreadsheet
  147. How do i set up a rank function on a list of results?
  148. Union, intersection, join
  149. copy used range across books
  150. Speeding up a Data Validation macro
  151. COM and threading in VBA
  152. Activating the last active worksheet
  153. Do loop skipping
  154. F keys don't work, help
  155. calander control and copy command problem
  156. writing a formula to a cell
  157. Consultant In Atlanta
  158. Compare between String and Value using VBA
  159. Addding a combobox to a workbook?
  160. End Of Month Data Only
  161. Hide/Show Shapes on Worksheet??
  162. How do I run a macro program for multiple workbooks at one time?
  163. Something wrong in one line of VBA code
  164. Replacing VBA code strings by using VBA code?
  165. Align Right footer text to Left
  166. Print only desired rows
  167. Marco for Picuture
  168. Now()
  169. Confirming a deletion
  170. delete record based on a value
  171. SELECT CASE - Which Row am I on?
  172. Excel macro to name ranges.
  173. Trap a checkbox click
  174. prevent event procedure under condition
  175. TOC in Excel
  176. iValue Stops after 10 cells of data
  177. Intptr & Int32
  178. Download image in Source.xls and save it as result.xls
  179. Macro Still Won't Run in Excel 2003
  180. macros or code
  181. Switch names in cell
  182. After Save Event help
  183. Save and Save as Function gone
  184. Combo box problem
  185. I Know I'm Missing Something...but what?
  186. Home Stretch! *
  187. Max numbers of characters in userform textbox and cell
  188. ClearContent & 'Cannot change part of a merged cell' error
  189. keyboard event in user form
  190. More effective code
  191. Object Browser does what?
  192. Code Help ^
  193. Nesting problem?
  194. How to return rangename of selection with VBA
  195. If then and 2 cell values
  196. Converting String numbers into real numbers
  197. Converting String numbers into real numbers
  198. Count number of times a specific number is displayed in cells
  199. Count if with multiple criteria
  200. Macro Help
  201. automatically go to last worksheet inserted in a workbook.
  202. I need help with combo box
  203. Copying
  204. command button to calculate two cell values?
  205. paste in next availible column?
  206. SELECT CASE "Jan-03" confusion
  207. About NUM to CHAR
  208. How do I enable the spellchecker in a protected worksheet?
  209. press button "entra" in web page
  210. active cell in row
  211. Use of Interior.ColorIndex
  212. Cell contain default value of cell above it
  213. How to handle error 8007000e Memory Error
  214. Another way with cell comments.
  215. Removal of standard Delete msg from within VBA
  216. Re: Blinking Cell (Worksheet restarts)
  217. 2005 Excel User Conference
  218. Copy to next blank row
  219. Check for existing sheet in book
  220. Disable Copy
  221. Strange Cell Behaviour...?
  222. Create/Update Excel Objects in Power Point
  223. how entries in a column can be put into a row
  224. how entries in a column can be put into a row
  225. How to supply your own web query
  226. Keeping Prying eyes out
  227. "counting" through the alphabet
  228. CountIF on Filtered data
  229. how entries in a column can be put into a row
  230. renaming text in cell
  231. How not number ?
  232. To Display a figure while excel is ready to GO!
  233. Re: Checking if not equal
  234. Checking if not equal
  235. Naming worksheets
  236. Text replacement with VBA Excel in several files
  237. Tekst in een tekstfile wijzigen met VBA Excel
  238. Num convert to Char.
  239. selecting values form multiple excel files into an excel worksheet
  240. Controls on form disappear
  241. Default Printer
  242. adjust range size??
  243. Adding new columns from one sheet to another
  244. copying data
  245. Please help: Coding Problem
  246. Restrictoin of xp windows feature
  247. columnshead with listbox
  248. completely Locked Out
  249. Vary formula based on what another cell contains
  250. Search a Range for a phrase and Format cell if found
  251. treeview node tag hold array?
  252. RE: Create Macro using VBA / Macro
  253. return colmn number + index
  254. Copy web query across sheets
  255. Addin Issue
  256. Duplicates?
  257. Phone Dialer in XP
  258. Button that creates a back up in Excel
  259. time error
  260. Cell Value
  261. textbox character limits
  262. Page Selection
  263. Off Topic a bit... but to this newsgroup
  264. AddressOf Nightmare
  265. Runtime Error
  266. How to do it...
  267. Print - Userform Multipage selection
  268. Sum Columns
  269. How do I stop a macro from running within a macro?
  270. ActiveWorkbook.Protect password:=range("rangename") does not work
  271. MSCAL.Calendar Excel Cannot change Properties Using Macro
  272. Load data into a listbox
  273. Can you print user forms
  274. Re: Another error message
  275. Limit the Loop to 500 Rows
  276. Is there a way to cross data types?
  277. Dim mySheet As New Worksheet
  278. Create scenarios using macro and data in cells
  279. Memory In Excel?
  280. Can one use excel like a chat
  281. message scroll bar in excel
  282. make pivottable dropdown work like the filter.
  283. Insert cell anywhere
  284. On Cell change call
  285. Anyone know of a way, or have a script, to read a TOC from CD's?
  286. incrementing rows for matching debits/credits
  287. Input box and carriage return for chart title
  288. Variables- Multiple forms
  289. Drop list affected by previous choice
  290. looking for a way to make a form Txtbox only visable on Mondays
  291. EnableEvents=False doesn't work? or does it?
  292. Need to identify a column within a range that meets criteria
  293. Don't understand why this formula is not working - Help Please!
  294. How to get a return value from a user defined function
  295. treeView -- multiple selection
  296. row location....hopefully simple answer :-)
  297. How can I Write this to a CSV File Please
  298. Save As "something" then date
  299. Excel-Form to file.txt
  300. Another Error Message
  301. Combining Modules
  302. Control disappears from form
  303. need some formula help please
  304. Pivot Table Macro
  305. form in excel to be attached to the emails address in the form upon sumission
  306. Find Within Workbook using VBA
  307. Excel Dialog Box/Sheet
  308. I get #VALUE in the cell - sometimes
  309. Toggle change control button face id & caption
  310. Reference to ActiveX control on worksheet requires full worksheet name
  311. incrementing every two rows--the sequel
  312. -Help- Sigh...
  313. Enter current time into cell hh:mm:ss
  314. incrementing every two rows
  315. New to Excel Programming
  316. Convert '6/23/2005' to '062305'
  317. VBA code for IF statement with OR?
  318. Copying Chart with Chart Series from Worksheet Name
  319. Code Problem
  320. Recording Changes Made to Worksheet
  321. sendkeys and the "+"
  322. Open Specific Sheet in Workbook
  323. How can you update an array formula using VBA?
  324. Message Box
  325. Lacking in Macro Building Skill...
  326. Extracting parts of a cell
  327. Transfer data from XL into Access: best practice
  328. Getting excel to show mm/yy in Funcation bar like it does in the c
  329. vba for hiding rows
  330. formating military time
  331. deleting rows
  332. Capturing a file path
  333. Re: working with two sheets
  334. Re: Static variable
  335. Problem with running macro on Mac computer
  336. Adding to acurrent Excel menu
  337. numeric calculation in logical formula
  338. active cell issue...
  339. Deleting all dropdowns...
  340. Re: Linking a Summary Workbook
  341. Skipping cells in a Do Until loop
  342. Find & Replace / Loop & Vlookup
  343. export cell value - Date Format
  344. Re: Linking a Summary Workbook
  345. Re: working with two sheets
  346. "Object Variable or With Block Variable Not Set" error help request
  347. Blinking Cell (Worksheet restarts)
  348. Changing Windows Registry from Excel
  349. Removing cell borders on any cell
  350. Sum ? / Numbers with Text
  351. Step 1: EOMONTH Function
  352. VBA Function results in #NAME?
  353. VBA to proctect locked cells in sheet
  354. open pdf files with a certain bookmark or page number
  355. HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE
  356. copying row information in a table to another location w/criteria
  357. Run-time error -2147319784 (80028018) when executing a simple macr
  358. If Then Statement in VBA
  359. dynamic pull down menu
  360. removing word for column
  361. Link Increments
  362. SendKeys in VBA
  363. Error 91 on Second Error
  364. Size a check box
  365. Excel seems to hang and cause asp script to timeout.
  366. Efficient Code
  367. Excel not updating
  368. Redirecting macros ...
  369. locking check boxes using a macro
  370. Transfering data to external application
  371. Show / Hide Columns in multiple sheets
  372. IDing cells in one worksheet, find them in another, and copying respective data
  373. C++ to Excel
  374. Hiding Tabs
  375. Cope worksheets and save to location
  376. Time Stamp for specific macro..
  377. Activating / Closing workbook using part name and a wild character
  378. Continue line of VBA code on the next line
  379. Macro for hyperlink -pawan
  380. Date format problem on export to CSV
  381. Pivot Table Selections
  382. calculatedfields
  383. Excel Queries
  384. Macros available to several workbooks
  385. Control Word through Excel
  386. Currency Formating
  387. Moving range to array
  388. can not restor FormulaBar when i close yhe file
  389. wrong date returned on ws.Cells(r,c).value
  390. I'm loosing it: rows in filter
  391. Excel limitation or bug or what?
  392. Show/Hide Columns
  393. Select Case on different worksheet?
  394. printing vba code in color
  395. removal of circular reference error on excel workbook load
  396. Another Question Concerning Replacing Formulae With Values !
  397. Macro-pawan
  398. Multi Sheet select and hiderows
  399. Macro which finds data? help?
  400. Incremental number field with User ID
  401. How to search a value with two criteria from a database?
  402. Custom save as pathname and filename
  403. Getting series name
  404. 2 if statements
  405. loading com addins with automation
  406. VBA Error setting Font.ColorIndex
  407. Pivot table autoformat info
  408. Validation from list in different worksheet/workbook
  409. getting rows out of a data base
  410. commands button
  411. colour text in validation lists
  412. Progress Bar in Cell
  413. Adding a Trendline or similar to a 3D Column Graph
  414. Merged cells text > 255 chars causes "#" to be displayed
  415. Graphs
  416. Combobox Change On Save As
  417. Deactivating all events in ThisWorkbook
  418. Data Validation from a database query ?
  419. copy and paste graphics into comment boxes
  420. Bundling Solver with Excel File
  421. outline...hide levels
  422. macro security
  423. macro works differently when using the Step Into (F8) feature
  424. HELP!!! I give up!!! Help with formula
  425. Sumif problem
  426. vlookup relative reference?!!??!!
  427. How to set range
  428. dee
  429. scrolling in VBA Edotor
  430. VB worksheet function parms
  431. Running an external Macro
  432. XMLSS href attribute
  433. Copy data from excel to a defined table in another spreadsheet
  434. Macro Copy and Pasting
  435. Conditional Formatting Not showing without editing cell
  436. Want row to stay hidden
  437. Help files
  438. VBA acting weird, advice plse.
  439. Hidden Row in seperate worksheet.
  440. Retrieving Active Directory "Full Names"
  441. How to Kill a vba macro from a Function//
  442. Userform always visible
  443. Need VBA code to terminate a find loop
  444. Writing Single Dimension Array to Active Sheet
  445. Creating a search button
  446. Help with a macro
  447. How to Open txt File and Import it to excel
  448. Connection with SQL Server generate "Timeout expired"
  449. Working on the wrong sheet
  450. opposite of IsNumeric
  451. range property of range object
  452. Connection with SQL Server - "time exceed"
  453. While ... Wend
  454. A Simply ComboBox Selection returns value to TextBox
  455. Run-Time error 57121
  456. Retrieving Web Data
  457. Need Help for Help!
  458. Need Help for Help!
  459. maintaining a link
  460. Copying range from another file
  461. Private Sub - Hot key?
  462. Getting Month Name
  463. Macro with manual file selection?
  464. What does "\" do in VBA
  465. making cells bold
  466. time format
  467. VB Help does not display Excel information
  468. Page Break Automation
  469. Working with data from several worksheets
  470. Excel command line
  471. How many hyperlinks can be in collection?
  472. Autofill Function
  473. Msgbox if Inputbox entry contains character
  474. Help with totaling a columns in VBA
  475. Adobe to Excel
  476. Blank lines
  477. Toggle command buttons
  478. Microsoft Office Web Components 9.0
  479. sorting worksheets and charts together
  480. Hidden Row
  481. format partial formula
  482. How to get Autocorrect Listing out of Excel
  483. Open excel and workbook with VB6
  484. Format portion of formula
  485. command button for vba module
  486. Tranferring Text from Excel to a Header in Word
  487. Create and write XLS using OleDB
  488. Open a VBA Macro when Excel Opens
  489. how error-trap "no cells were found error"
  490. Enable - Disable Macro Dialog Box
  491. Control disappears from form
  492. Inserting a Row after a name
  493. Email Single WorkSheets from a Workbook
  494. Variable List Box Range
  495. Loadin ADD-IN programarically
  496. Schedule a Macro To Run on cartain day
  497. printing excel worksheet
  498. Calls from sheet module to ThisWorkbook module
  499. Lookup from multiple columns....pls help...urgent...thanx
  500. List of Unique Values
  501. XML Files
  502. Saving excel files as jpeg
  503. Open a file with a macro
  504. Selecting text
  505. Return Current Column Letter and Row Number
  506. Creating a PivotTable with VBA
  507. Import grafic
  508. Working with XML Files
  509. fill cells with colour if content of another cell has CR
  510. ADO Connection Help
  511. How to scroll data in a chart?
  512. Excel 2002
  513. form in fullscreen v.s Screen resolution
  514. how do I remove quotation marks from .CSV file
  515. vba for lookup and autofill
  516. Cut - Paste in xls file (c++ code)
  517. onAction with parameters
  518. Another coping and pasting macro
  519. text is deleted when cell is edited
  520. worksheets feeding to other worksheets
  521. How to represent an empty cell in excel formulae?
  522. Using Dialog to select a Workbook, Worksheet and Range
  523. Code Help
  524. Listbox Help
  525. Stopwatch query
  526. Indirect and Offset argument
  527. Autoexec Macro
  528. Can you use worksheet names in macros
  529. Spreadsheet Performance
  530. AutoFilter: Loop Thru Visible Rows?
  531. Help with code...
  532. Help needed on program
  533. Controls auto resizing with scree resolution
  534. Worksheet Change code not running when you just delete data in cells.
  535. I need to return the name of a worksheet in another worksheet cell?
  536. Storing column references in a variable
  537. Find a Value Pass Row 99
  538. Loop
  539. scroll bars in comment boxes
  540. Please help / Named range help
  541. Data Validation Drop-down List Limt?
  542. Can this be done? If bn=b(n+1) and cn=c(n+1) then delete row (n+1)?
  543. VBA Program to Email-able Toolbar
  544. VBA Excel Macro - One File Auto Create Multiple Excel Worksheets!
  545. Autofilter and Listbox how to acomplish?
  546. Re: VBA/XP/2000 On Error Resume Next problem.
  547. Controls on form disappear
  548. Help with find and replace macro
  549. set up a command button or macro for open file to "save as"
  550. 13 type mismatch help
  551. Web publishing question
  552. How 2 Execute Sheet1 Button_Click Code from a module function
  553. Textbox question
  554. Range value cells with Sumif
  555. Newbie
  556. how to Detect paragraph in cell in string?
  557. Ojbect required error msg
  558. Printing a Report
  559. autofilter
  560. Safely automating any language version of Excel
  561. Parameter in Macro Call?
  562. Publish method failing, can't understand why
  563. Text to Value
  564. Re: Splitting fields from commas
  565. Macro problem
  566. Splitting fields from commas
  567. On Error GoTo If
  568. move down 23 lines and make the 23rd line height 92.25
  569. Highlighter
  570. Solver GUI works fine, but the VBA macro won't return any results
  571. Query on Date range does not qualify the Year
  572. Excel in VB.Net code
  573. Microsoft Excel Expert ????
  574. Slow Performance Hiding Rows
  575. objectos
  576. Closing Excel from Script
  577. ScreenUpdating Question
  578. The case of the missing buttons
  579. Sheet / Hide & Unhide for editing only
  580. Virtual Memory Macro
  581. Memory Management
  582. Disallow Paste
  583. Coding problem
  584. Page Breaks when data is NOT on column "A"
  585. Modify VB for a Runnning Total
  586. Programming to delet padded spaces
  587. Changing the Colour of an Auto Shape (Line)
  588. Display "Does not exist" upon search no results
  589. form
  590. Problem adding a range in Sumif function.
  591. Password
  592. Insert column
  593. macro problem
  594. Make a button disappear
  595. Totals
  596. workbooks.open without triggering event
  597. Comparing 2 workbooks
  598. How do I add help info to a user defined function?
  599. refer to cell using the value in Row 1 and column A
  600. Help required to run simple macro...
  601. deleting objects
  602. Hiding and unhiding columns
  603. vba help
  604. AdvancedFilter in VB
  605. Skip blank cells on transpose in a macro
  606. Using excel as a database
  607. Reg: Incorrect RecordCount when opened a Excel sheet in ADO Recordset
  608. i have problim with my excel VBA
  609. close excel without saving
  610. Launching Excel wb from Lotus Notes document
  611. How do I get the address of the cell that is being calculated right now?
  612. Have Excel VB Read from two sheets
  613. Cutcopymode problem
  614. Delete Sheets
  615. Self destructing code
  616. Searching 1 column for data
  617. Filter Excel bases on the current user
  618. Omit page with no data when use "show page"
  619. Copy command
  620. Screen Positioning of a Dialogue Box !
  621. Assign a macro to create a pivot table
  622. Worksheet SelectionChange event
  623. Formula for timecode duration
  624. Code to list users that have changed a spreadsheet
  625. Input two cells with one selection
  626. Problem programming the Sort command
  627. Get Range, that user marked
  628. Pointers??
  629. Accessing Menu Options from VB Code
  630. how to filter first column only in range
  631. good book
  632. Send Email from Excel
  633. Way to Link Tab Names
  634. VB Code Location; sheet, workbook, module
  635. Quit without saving
  636. How to search a range for a suburb in a large range
  637. Excel Function Help
  638. How do I use the ActiveCell's contents as a string for a web query
  639. VBA Security
  640. copy cell after resize method in VBA
  641. Bad File error: Need Help
  642. In search of VBA script
  643. excel problem...help!!!
  644. Copy Code needed
  645. Activating/De-activating buttons
  646. Help with named ranges
  647. Help with Named ranges
  648. C# worksheet function poor performance
  649. 2005 Excel User Conference
  650. SaveAs Crashes
  651. Combo Box to return a value
  652. copy data to each worksheet
  653. Header Font size
  654. Creating an Autoexpand in Excel Combo Box
  655. How to delete cells ?
  656. Could You Explain the difference?
  657. VBA newbie needs a little help
  658. remove Worksheet using Sh.Delete without prompt
  659. Re: base formula calculation on whether different cell has formula
  660. Creating Excel Addin
  661. Selecting more than one sheet
  662. MAX in conditional formatting
  663. Table Help
  664. Use Excel Macro in Access
  665. Help with following code creating chart
  666. Macro to move text from one field to another
  667. Trouble with ActiveControls and Forms
  668. macro to find if the Excel file is using by other user
  669. Count If, criteria is greater than
  670. Simple Cut & Paste Macro needed :)
  671. Row Selection or Column Selection or other ?
  672. export excel spreasheet into a text file
  673. changing variables?
  674. Screen size
  675. Copy information down specific cells
  676. How do I use the AutoSum?
  677. Delete PivotCache
  678. Determining Which Page of MultiPage Initially Shows
  679. lock and unlock cells programatically
  680. GroupWise integration
  681. Send Mail Script Help
  682. Hyperlinks
  683. Screen size
  684. Copy from two files
  685. Delete a workbook
  686. How do I track frequency of occurance in data table?
  687. Can an Array Formula Solve This?
  688. VLOOKUP
  689. How to make user forms FULL SCREEN?
  690. selecting cell range in other worksheet without switching to worksheet
  691. VBScripting syntax for Autoformat
  692. Information about ATL functions
  693. Code that can't be seen/modified by users
  694. Userform - ComboBox fills TextBox not working
  695. Inconsistent macro behavior
  696. Max value in 1 column when all values format are text
  697. Re: Close file without saving
  698. Re: Macro to delete sheets and saves remaining file does not properly delete module
  699. Hiding Tabs
  700. Re: Macro to delete sheets and saves remaining file does not properly delete module
  701. Is there a way to programatically resort the sheets in a workbook
  702. Auto Adjust the Width of a Column
  703. Re: Macro to delete sheets and saves remaining file does not properly delete module
  704. Re: Macro to delete sheets and saves remaining file does not properly delete module
  705. Re: Macro to delete sheets and saves remaining file does not properly delete module
  706. Re: Macro to delete sheets and saves remaining file does not properly delete module
  707. Linking List Boxes and Textboxes
  708. Re: Macro to delete sheets and saves remaining file does not properly delete module
  709. Read Only Problem
  710. Auto-Enable Macro's
  711. Re: Macro to delete sheets and saves remaining file does not properly delete module
  712. Visual Basic Tool Bar
  713. Summing a range depending on cell background colour
  714. Having difficulties with For If Next loops
  715. Re: Accessing personal macro's all the time
  716. Macro to delete sheets and saves remaining file does not properly delete module
  717. command to show top of worksheet?
  718. Saving Multiple Sheets to Another Spreadsheet Without Leaving the Initial Workbook
  719. Formula Help
  720. Help for ATL functions
  721. Select the last Cell of a selected Cellarea
  722. Problem with xlCenterAcrossSelection
  723. Excel 2002 Workbooks.Open failed.
  724. Need vb application to print first Worksheet in excel files
  725. Does some one has a golfscore in excel sheet format
  726. Select range -- convert formulas to values
  727. Alignment
  728. how to stop a macro
  729. Determine last row in columns 1-4 to copy a formula in column 5
  730. trying to get a row to break....
  731. searching on more than one field in VB
  732. searching on more than one column in VB code
  733. i losst my VBA excel Passwerd
  734. How to add an entry in the Excel Right-Click Menu
  735. Combo box control Drop down list moving
  736. Print splitting...
  737. Populating List Box from SQL Server
  738. forget my passwerd
  739. Workbook Bigger and Bigger
  740. how tot open VBA Protectoin
  741. wrong positioning of data in sheet after clearcontents()
  742. Why!!!!!!!
  743. Object variable error
  744. Drawing Objects with duplicate names problem
  745. problem when inserting or deleting cells
  746. Find the last row
  747. Dating Problem
  748. Formatting Y axis values based on other chart
  749. after clearcontents() new data is positioned below the cleared ran
  750. Re: return text not index for property
  751. Page Setup Macro
  752. How to open new instance of excel if excel is already open?
  753. Summing a range if a certain background colour
  754. Copy/Paste charts
  755. Flexgrid Control
  756. Macro to copy columns from 1st sheet to 2nd according to mapping-p
  757. Merging Pivot Table Data
  758. return text not index for property
  759. Sort and Specify that you have a header row
  760. Print 3 Worksheets
  761. Textbox Format
  762. Max number of worksheets in a workbook?
  763. Report for Conditionally Formatted Cells
  764. Anyone in a really good mood?
  765. Macro to find text in all worksheets -pawan
  766. reliability of macro results
  767. Excel VBA: Move Userform Based on Active Cell?
  768. Find and change external links to point to the same workbook instead
  769. Help me migrate
  770. How can I use values in two separate cells to select a new cell?
  771. excluding text entries in calculations
  772. Code for Conditional Formatting with Five Conditions
  773. Timed loop
  774. Save to sheet 2 in workbook
  775. Re: Accessing personal macro's all the time
  776. savings files with the use of variables
  777. protection
  778. Search a text file for a string
  779. Have chart lines take up full area of chart from left to right
  780. Using List Boxes and returning Value to cells
  781. Deleting Pictures
  782. Help w/Insert
  783. How to force Excel to complete one statement before executing othe
  784. Worksheet has to set to visible as it is not visible after saving and closing Excel by VB.
  785. Opening item from Listbox... Need Help :P
  786. functions
  787. names of areas
  788. how do i chk is sheet exists my attempt included
  789. opening a file
  790. A math/algorithm puzzle!
  791. Importing Data from the Web
  792. Personal file slows navigation
  793. problem with text from macro?
  794. Countif for a string
  795. Maximum value of two variable
  796. ADO connection retrieving data to Excel using EXCEL-VBA
  797. How reference columns numerically (not Cells() )
  798. Help with If/then macro in VBA
  799. Wrong result returned by UsedRange.Rows.Count
  800. Mouse-over content in bubblecharts
  801. Throwing an error ... on purpose!
  802. Loading array into list box
  803. Automatically transfer selected data to another sheet on print
  804. Inclusive/Exclusive List
  805. Worksheet too big
  806. Subtracting Dates VBA
  807. Subtracting Dates VBA
  808. Invalid qualifer
  809. ms query - from statement
  810. multiple line two accumulators
  811. How to check for an open network connection?
  812. Help using a cell ref. to go to another page for data
  813. textbox scrollbars disappear
  814. macro for formatting
  815. Group cells and sort
  816. Looking for a 'Contains' Formula in Excel
  817. XL 2003 TOOLS/Macro/security level inactive
  818. can i use formulas in calendars in excel?
  819. If condition
  820. Userform retain data after closing and reopening
  821. how do i convert a number stored as text to a numb in a vba loop
  822. Macro works for me but not user group
  823. notify drop event of excel/word in C# add-in
  824. Which control is the one selected?
  825. Excel Application Level Global Variable
  826. Delete Row if text or empty
  827. delete row base the value of certain column
  828. SAVE AS MACRO
  829. Unprotect workbook without password
  830. Split() method
  831. Macros problem with XP
  832. incomplete code
  833. MyRow error
  834. Link cell show zero when source cell is blank
  835. Static variables
  836. offset function
  837. Application.Mode
  838. HYPERLINK link problem in Excel sheet using VC++
  839. Executing a macro in a closed workbook
  840. What formula can I use to compare items in two columns
  841. Read Only
  842. Data extraction... (Pls Help)
  843. searching cells for a string of text
  844. help with code
  845. time line
  846. RowSourceProperty
  847. normal distribution of random no.'s
  848. Textbox values
  849. fao patrick molloy
  850. MACRO
  851. "Can't find project or library" error message
  852. Autofill formula to last row with data when rows will be dynamic
  853. import fixed width text file
  854. how to attach macros to excel permanently - pawan
  855. How do you generate random numbers in a normal distribution?
  856. macros
  857. How to use Tools, Data Analysis, Regression in Macros
  858. Automatically starting a macro
  859. send email from button
  860. macro to paste data in alternate cells-pawan
  861. Restricting access to ceratian cells
  862. Steam Leaf Plot in Excel
  863. TextBox Color Change
  864. telnet without sendkeys
  865. X and Y Screen Coordinates of a Range !!!
  866. help again, last line required
  867. fast range copy (without clipboard and with formatting)
  868. Out of Memory Error 7
  869. Checking for empty cells in a range
  870. Checking for empty cells in a range
  871. &quot... whats this??? am puzzled
  872. Word Mail Merge and Personal.xls problem
  873. Automatic Printing
  874. Macro for delete row with "vlookup"
  875. PictureBox in Excel VBA
  876. Passing a Sub's name as parameter
  877. Data copy from a seperate sheet to data sheet
  878. Re: eliminate header&footer for spesific pace
  879. Reading mail attachements
  880. Get value from combobox
  881. Very Basic Excel Object Questions
  882. how to create chart by VBA coding?
  883. Macro Won't Run in Excel 2003
  884. Coping numbers only in cells to other worksheets.
  885. Solver rounding
  886. Re: vlookup with closed workbook
  887. Do Until
  888. In desperate need of assistance
  889. international excel issues
  890. copy a worksheet - but not the value (text)
  891. Variance formula - is this correct?
  892. Re: Problem with Pearson Code
  893. base formula calculation on whether different cell has formula
  894. Pushing results HELP!
  895. Histogram Bins Created From Sum Of Two Cells
  896. Sending email from Excel vba problem
  897. Re: Simple Moves
  898. Re: Combining data from multiple workboods into one
  899. Re: Combining data from multiple workboods into one
  900. Advanced Filter
  901. Save File with Date and Time Stamp
  902. Macro ?
  903. works in Xl2000 but notXl97 - help required
  904. Named ranges and variables
  905. working with data from several worksheets.
  906. copy equation to new row
  907. command button question
  908. Removing & Importing a macro module
  909. I refuse to be let down by the experts
  910. Running macros from shortcut keys
  911. command button
  912. Advice on three dimensional array (difficult?)
  913. How can I query the 'indent' level of text in a cell?
  914. ToolTipText
  915. 2 values in 1 cell
  916. Help needed to consolidate variable ranges in excel vba
  917. hyperlink a cell to an email message
  918. Re: Matching values in 1 column to data in another
  919. Matching values in 1 column to data in another
  920. Find specific cells
  921. excel in the foreground
  922. Switch board
  923. Ping - Bernie (or any other sage)
  924. List Box or combo box into a cell
  925. cell locking via VBA
  926. Named ranges and variables
  927. Repeat Entries
  928. Finding the last non bank cell in a column
  929. Looping with Excel Forms
  930. copy the drop down list value and paste to next column
  931. excel auto-formatting - help
  932. XP Styles on Excel Form
  933. Update on Worksheet_change with data from other sheets?
  934. Capturing Excel Copy/Paste/Cut events
  935. How to check for an open Network connection in Excel VBA?
  936. Excel and .NET
  937. vb dummy - two routines
  938. Comparing values in 2 columns - Help needed
  939. How do I call this function?
  940. can I compile excel as a stand alone programme like access
  941. can't copy a sheet within same workbook
  942. Automatically run macro on sheet change
  943. Auto Row Height for Merged Cells
  944. Problem with Named Cells
  945. is there any way to create a formula in excel for amortizing
  946. .NET, CAS and Excel Development
  947. stop web query
  948. Vlookup in VBA - Driving me crazy
  949. Making Cells Automatically Add #'s Instead of being written over
  950. Data Validation Listbox and the Worksheet Change Event
  951. I'm trying to disable a clip board
  952. Print Macro..
  953. specifying ranges using cells
  954. Add a Range to an existing Range in a loop?
  955. HELP-- Filtering and copying data to a new sheet (w/ macro)
  956. Print Macro..
  957. redo CommandBar("cell")
  958. Publishing Workbook or Worksheet (HTML)
  959. Copy columns to free space in diff wrkbk
  960. Removing Duplicates
  961. Event to trigger when form is scrolled
  962. Referencing an opened Workbook
  963. Validation help
  964. Range for a single cell
  965. Excel -> Word: Problems copying/pasting shapes
  966. get data from one sheet list in another
  967. Run Access Macro from within Excel
  968. Extract Data From Multiple Excel Files -> One File
  969. percent of total with partial items
  970. Procedure not working, and I do not know why
  971. Rounding Ranges
  972. Selecting cols and doing a formula using variable offsets
  973. SheetActivate
  974. where put code for automatic execution upon opening workbook?
  975. Saved seems not to work
  976. Buttons Moving around page or shrink in size on Excel Worksheets
  977. ExecuteExcel4Macro Problem
  978. displaying times in combo boxes
  979. Excel 2003 - Error Running Macro
  980. count a value in cell if the cell to the left has a certain Value
  981. Numerical Breakdown
  982. Save from a template to XLS only visible sheets
  983. displaying time in a combo box
  984. How can i get autoformat name of range in excelsheet?
  985. Copy columns to last populated rows
  986. Chart Objects
  987. Multiple line, two cell accumulators
  988. EZ Formula Syntax Question
  989. formulas are not working on my spreadsheet
  990. How can I disable the save function depending on one cell?
  991. Deleting Shapes in a worksheet
  992. Finding a value
  993. data entry to next blank TextBox
  994. User form and text boxes on charts
  995. saving to two folders by selecting one
  996. formulas and colorindex don't work after opentext
  997. Macro copying macro code
  998. saving to two places by selecting one (VBA)
  999. Quick Formula question..
  1000. Fixing SSN's with a macro