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. How do you sum values in a coloumn when it contains #N/A in a ran.
  2. Re: Code instead of foumula.
  3. RE: How do you sum values in a coloumn when it contains #N/A in a ran.
  4. COPY EXCEL FILE
  5. Re: How do you sum values in a coloumn when it contains #N/A in a ran.
  6. Writting to tables in Access
  7. RE: How do you sum values in a coloumn when it contains #N/A in a ran.
  8. RE: Code instead of foumula.
  9. please help simplify
  10. How do you sum values in a coloumn when it contains #N/A in a ran.
  11. RE: Exponential Growth
  12. Update SQL db directly from Excel
  13. Re: VB solver
  14. Excel Freezes
  15. Code instead of foumula.
  16. Replace XLA with XLL function
  17. Exponential Growth
  18. FileConverters property
  19. Batch files auto unzip
  20. RE: Can I use ISERROR with VLOOKUP function?
  21. Parse Data
  22. Re: Exporting excel worksheet to access table
  23. Filtering Data
  24. hyperlink
  25. countif syntax VBA
  26. Is this right (open for write access)
  27. Adjacent Cell Value Theorem Help
  28. please help simplify
  29. delete entire row based on value
  30. Exporting excel worksheet to access table
  31. select from a range only some cells
  32. transposing data from multiple tabs
  33. Different options to hide tabs in Excel
  34. form wont show?
  35. formula array problem
  36. Excel Macro - Can this be done ?
  37. Autorun Add-In
  38. Defining paths of files
  39. finding type
  40. Save As Web Page Automation Help
  41. Re: Exit when its a Mac
  42. Re: Different options to hide tabs in Excel
  43. Opening a workbook at a specific sheet
  44. Very simple ? on setting up tab order
  45. Different options to hide tabs in Excel
  46. Excel Tabs
  47. random
  48. ADD 1 TO CELL UPON PRINT
  49. User functions and the Insert-Function dialogue
  50. Macro problems in XP
  51. Lookup... round up
  52. Working with VBA classes via WSH possible?
  53. Help please - worksheet reverts back to grid
  54. Re: Multipage Query
  55. Writing bitmap to Excel Spreadsheet
  56. select from a range only some cells
  57. Lookup... round up
  58. random
  59. Re: Help please - worksheet reverts back to grid
  60. Looping through text
  61. Multipage Query
  62. Change the name of column heads from A,B, C etc to something else
  63. Re: Microsoft Solver
  64. Query Table problem
  65. Changing spreadsheet cell through UDF
  66. Re: make addin portable
  67. split cell content
  68. Double Click
  69. Wildcards In VBA Macros
  70. GCSE Student in a spot of trouble
  71. Combo box Add To List
  72. WorkbookOpen event unpredictable
  73. Find and Replace everywhere
  74. Problem closing a workbook using a macro
  75. Help please - worksheet reverts back to grid
  76. texttospeech
  77. Lookup... round up
  78. Can you fix this?? vbreadonly
  79. Creating Tree Views in Excel
  80. Lookup... round up
  81. Deleting a File
  82. rand function is repeating
  83. urgent - changing a range
  84. xlCellTypeLastCell
  85. save button in excel to save one of the worksheets with a cell value as its name
  86. Microsoft Solver
  87. Can you fix this?? vbreadonly
  88. How to improve visuality?
  89. How can I ...
  90. rand function is repeating
  91. find holders name
  92. Excel2003 and xlListSeparator...
  93. Displaying a Combo box in powerpoint
  94. Auto execute macro when open excel
  95. listbox header row
  96. error to excute cut or copy in vba programming
  97. with files
  98. Enter simulation-related HLOOKUP formula in cells
  99. Mailto / Attach... Button to do so?
  100. fill cells, merge cells
  101. Fill column with color
  102. How access/query/update Excel using VC?
  103. Web query question
  104. Font to simulate a tickmark/checkmark
  105. Comparing rows on one sheet to list on other
  106. Draw Buttons
  107. Which Events Fire When I Delete A Row, and How Many Times?
  108. Using VBA to convert file to Excel
  109. Fill column with color
  110. Maximize Form
  111. Application.WorksheetFunction.Correl
  112. fill cells, merge cells
  113. Ability to change the Excel comment indicator color
  114. odd behavior
  115. Excel VBA and SQL Server 2000 UDF
  116. Userform.Show after sendkeys
  117. GUI in Excel Macro
  118. Amend code
  119. Preserve Formatting of pivot table crashing
  120. outlook draft email
  121. Draw Buttons
  122. Comparing rows on one sheet to list on other
  123. macros and pivot tables... help please!
  124. sending HTML content with Excel MIME type
  125. Re: cell protection
  126. Importing/Exporting text files and string editing
  127. Re: Shared Worksheets w/VBA
  128. Pivot table - time dimension problem
  129. MsgBox Contents
  130. Change Data Source
  131. Re: using round to increase decimal ?
  132. Re: using round to increase decimal ?
  133. Changing Form Button Background Color
  134. using round to increase decimal ?
  135. Exit when its a Mac
  136. Changing Form Button Background Color
  137. A simple maco for someone, but not for me.
  138. Re: using round to format
  139. Sending e-mail - Ron deBruin
  140. Pasting in a unique row for each unique date
  141. Trouble with exit
  142. Is it possible?
  143. using round to format
  144. Excel check list to select pages
  145. Excel check list to select pages
  146. Index Sheet which summarizes all cells with hard coded data.
  147. Copying Text from cell to add to text in another cell
  148. finding type
  149. Best way to do this?
  150. Changing Form Button Background Color
  151. Trouble with exit
  152. Supress author's name in displayed comment?
  153. "rabc0011" = "abc0011" ????
  154. Controlling Tab order
  155. Arranging data for Pivot table creation?????
  156. Event/Method for Unprotecting worksheet
  157. Unhide rows
  158. Excel VBA to print a chart as a pdf file
  159. convert to number format
  160. Loading xll file from vbscript only works if my associated dlls are in the path
  161. Custom View in a Protected Sheet
  162. CommandButton Caption change via macro
  163. Excel VBA to print a chart as a pdf file
  164. Autosize TextBox Height
  165. VB solver
  166. Trouble with exit
  167. Delete Empty Rows
  168. Userform Rev
  169. Re: What do these characters mean?
  170. prevent pivot items being renamed
  171. Event/Method for Unprotecting worksheet
  172. QueryTable Memory Leak
  173. Re: Retrieve Data from closed workbooks - Ron de Bruin
  174. Re: Retrieven data from closed workbooks - Ron de Bruin
  175. Comparing rows on one sheet to list on other
  176. Excel 2k3 Macro Problem
  177. List files from a direcotry
  178. r=number of rows
  179. Binary Files
  180. PivotFields
  181. RE: What do these characters mean?
  182. Re: cell protection
  183. Re: Querying whether workbook was opened from inside or outside of exc
  184. Retrieven data from closed workbooks - Ron de Bruin
  185. Trouble with exit
  186. Re: What do these characters mean?
  187. Retrieve Data from closed workbooks - Ron de Bruin
  188. What do these characters mean?
  189. Querying whether workbook was opened from inside or outside of exc
  190. Re: CheckBox (unclicking) Question
  191. VBA Error 800a01a8
  192. help! Width of column
  193. embedded enter key
  194. IF?
  195. Accessing workbook info from a different workbook macro
  196. Excel VBA - submenu in a short cut
  197. Re: make addin portable
  198. Comparing rows on one sheet to list on other
  199. "rabc0011" = "abc0011" ????
  200. RE: How to turn off dragging for a Pivot Table field
  201. Double Click
  202. make addin portable
  203. Do Loop doesn't process
  204. multiple sheets - IF statement?
  205. embedded enter key
  206. delete code needed
  207. Re: Corrupt formula?
  208. Corrupt formula?
  209. how to change the range
  210. Working within a workbook without activating it?
  211. Mailto / Attach... Button to do so?
  212. Click event on combobox in a loop
  213. Mailto / Attach... Button to do so?
  214. Location data to grid
  215. cell protection
  216. Shared Worksheets w/VBA
  217. Can I use ISERROR with VLOOKUP function?
  218. Count Highlighted cells
  219. Qn: How to show a date and time with a ' in it???
  220. writing to excel sheet
  221. format cells
  222. Click event on combobox in a loop
  223. For OZDOC 1050 Peter Young - Still trying to delete
  224. Option Button open template false
  225. help with resume
  226. Copying Text from cell to add to text in another cell
  227. References and Microsoft Scripting Runtime library
  228. User Form
  229. Running Macros
  230. OWC.Spreadsheet
  231. Can I use ISERROR with VLOOKUP function?
  232. Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below
  233. highlighting rows and columns using a condition
  234. help with resume
  235. Worksheet Change Event - not working in XP
  236. format cells
  237. Displaying a Tif image in the Image Control
  238. Can you fix this?? vbreadonly
  239. How to turn off dragging for a Pivot Table field
  240. opening NEW excel file
  241. Location data to grid
  242. How to Show HourGlass?
  243. Import Data
  244. Conditional Formatting, more than three?
  245. Slow Printing using VBA after changing to WinXP/Excel2003
  246. Formatting Worksheet
  247. Shared Worksheets w/VBA
  248. question about scrollbars and embedded charts
  249. Text File Problem
  250. Getting error in code
  251. Help with an If statement VBA
  252. Validation-List created with VBA
  253. Lotus Notes
  254. Still trying to delete...
  255. Working within a workbook without activating it?
  256. Change Font Color
  257. function wil not update sheet
  258. Validation-List created with VBA
  259. Help with an If statement VBA
  260. How can I extract cells address in OnCahnge event
  261. support needed on .CSV file
  262. Cell with limits
  263. Can you fix this?? vbreadonly
  264. Failing to assign expression to FormulaR1C1, what am I doing wrong?
  265. Normal Use of a Worksheet With a UserForm Showing?
  266. Normal Use of a Worksheet With a UserForm Showing?
  267. Find time
  268. Normal Use of a Worksheet With a UserForm Showing?
  269. If statement..Please help
  270. 2 below first entry in row
  271. Inputbox and Application.InputBox
  272. Displaying HTML code in .CSV file Excel 2002
  273. Failing to assign expression to FormulaR1C1, what am I doing wrong?
  274. Range of columns
  275. code to remove row duplications
  276. can I send authentication data i.e. username & pword from an exce.
  277. Mailto / Attach... Button to do so?
  278. Disable Edit Query
  279. Disable Edit Query
  280. Comparing Doubles
  281. Can we create/run macros in Shared excel file. How?
  282. Concatenate excel files in one with seperate worksheets
  283. How do I update contents of activeX combobox?
  284. moving excel objects pasted as an image in Powerpoint
  285. Fill column with color
  286. Scrollbar
  287. Draw Buttons
  288. dcount of unique values
  289. in msg
  290. in msg
  291. how do i convert numbers to words ex 100 = one hundred?thanks!
  292. fill random cells
  293. turn a spreadsheet calculation into a function
  294. Error on closing a hidden workbook
  295. Need birth date 3/27/91 to calculate cronological age in excel
  296. How to: text color depend on value
  297. Night Vision Goggle Tracker
  298. Different Views Printing macro
  299. test for formula result
  300. Can't copy & paste row inside a protected worksheet
  301. Night Vision Goggle Tracker
  302. UserForm Questtion
  303. Add a combobox to an Excel spreadsheet and reference value in VBA
  304. Copy formula relative to left cell?
  305. search a column
  306. Userform Question
  307. Copy range excluding group data
  308. search a column
  309. vba just seems to stop running when I open a file...
  310. Storing Bitmap Images (Drawing Objects) in an Add-In
  311. Copy???
  312. Deleteing Rows
  313. Re: How do I Remove bullets from text data in Excel cell with macro?
  314. search a column
  315. Can't Find Correct Value
  316. search a column
  317. auto updating cell values
  318. How to Show HourGlass?
  319. This one is readable, please help me!
  320. Matching rows for differences
  321. matching entire rows
  322. fill random cells
  323. remove "ask a question box" programatically
  324. mailing labels
  325. Bolding problem on Subtotals
  326. multiple pages
  327. Time Zones
  328. how do I print comments
  329. Qn: How to Append???
  330. Find and transfer
  331. Retaining Formula
  332. search a column
  333. search a column
  334. String Not Longer Than 255 Characters in VBA?
  335. create a standalone app from workbook
  336. Referencing comboboxes in VBA
  337. Refreshing a ActiveX combo box
  338. macro icon
  339. Run Macro Only If 4 Cells Are Filled In By User In VBA
  340. change text in FormatButton
  341. Method or data member not found
  342. Why Wont This Work? VBA Help Needed!
  343. how to label a column in excel 2003 ?
  344. Multiple files created from 1 sheet are corrupt - Excel 2000
  345. Run Macro Only If 4 Cells Are Filled In By User In VBA
  346. Re:Tom Ogilvy again
  347. Print Dialog Box
  348. Run Macro Only If 4 Cells Are Filled In By User In VBA
  349. How to rearrange data
  350. Re: comparing identical rows in different sheets
  351. Simple?? sort question
  352. Run Macro If Save Is Canceled On SaveAs Window In VBA
  353. comparing identical rows in different sheets
  354. VBA Excel - Generating Sounds
  355. RE: how do i get stock value in a cell automatically through a hyperl.
  356. RE: how do i get stock value in a cell automatically through a hyperl.
  357. Msg Box to Appear??
  358. excel database program
  359. Is there a faster way
  360. array in VBA
  361. Run Macro If Save Is Canceled On SaveAs Window In VBA
  362. Error proofing automatic updating a cell
  363. OnSheetActivate or something...
  364. UserForm_Layout code Me.Move 0, 0 don't work
  365. Adding Cells After they've Been Found
  366. Need Help With Code Quick!!
  367. Need Help With Code Quick!!
  368. dynamic financials
  369. controlling from xls , word events
  370. Do While Vs Do Until
  371. auto updating cell values
  372. Auto Close A Workbook...With Two Twists!
  373. How to write this correctly?
  374. how to rearrange data
  375. proper syntax in code needed
  376. thanks
  377. .insert difference between 97 and 00
  378. Dialogue Box Wont Dissapear In Time: VBA Help Needed
  379. Excel data to a web page
  380. Pasting from a specific Workbook to another workbook without having to name it.
  381. Dialogue Box Wont Dissapear In Time: VBA Help Needed
  382. beginning programming: stop when last column in sheet
  383. Excessive time loading/saving file
  384. Re: MENU Problem
  385. Macro code to page down
  386. how do I remove as read only ?
  387. search a workbook
  388. convert lotus 123w macros to excel macros
  389. Msg Box to Appear??
  390. Why does this not work?
  391. Macro run if and cell in range is selected in VBA
  392. Excel VBA
  393. activeX
  394. Code Help Needed
  395. RE: Plus range of cells from different sheets if not empty
  396. MENU Problem
  397. Macro run if and cell in range is selected in VBA
  398. Scroll Area
  399. WORKBOOKS.OPEN (URL) - How to trap a connection-lost/ timeout erro
  400. convert lotus 123w macros to excel macros
  401. External data range
  402. auto updating cell values
  403. Selecting 2 cells together
  404. Automatic Language-Bar Selection
  405. What do you use for a quotation template?
  406. Can't edit toolbar icons
  407. Find and tranfere values
  408. Run Workbook_Open only if called
  409. File count
  410. Auto Close A Workbook...With Two Twists!
  411. Another test msg from Sairaj
  412. extracting unique items
  413. optimization-selecting a group with constraints
  414. Counting Range Data From Different Sheet
  415. Mouse over Record Display
  416. Re: Find Lowest Column Among Several
  417. Excel and the Web
  418. Enter a specific date thats falls between two other dates.
  419. files opening from hard drive without prompt,
  420. How to determine if Workbook has been opened exclusively
  421. Get value of last cell in column A from a closed workbook
  422. to open up a link
  423. masking
  424. Re: Counting cells with data in them
  425. Hiding Shapes When Not WordArt , or When WordArt Text <> "Draft"
  426. Don't save before close event?
  427. User form browsing for a range on a sheet?
  428. Re: Counting cells with data in them
  429. Macro to Delete - repost
  430. Re: scope/ lifetime of variable
  431. Re: ? Day Planner address book
  432. Re: Find Lowest Column Among Several
  433. Re: ? Day Planner address book
  434. scope/ lifetime of variable
  435. making a time series
  436. extraction VB code
  437. ROWS Property question
  438. EASIER WAY THAN FILLING A RECORDSET?
  439. MS Forms ListBox no longer accessible???
  440. Create a "running" message
  441. Get next empty Column?
  442. Counting cells with data in them
  443. Re: Counting cells in a macro
  444. RE: Code works with Excel 2000 but not with Excel 2002
  445. Counting cells in a macro
  446. Help understanding default formatting differences in excel 2000 a.
  447. Re: Code works with Excel 2000 but not with Excel 2002
  448. Re: VBA method to detect state of CAPSLOCK key?
  449. ? Day Planner address book
  450. RE:Tom Ogilvy
  451. identify and move specific values
  452. macro so no option button chosen
  453. Average Valid Values
  454. Code works with Excel 2000 but not with Excel 2002
  455. Re: Find Lowest Column Among Several
  456. Re: PivotTable Source & Destination
  457. VBA method to detect state of CAPSLOCK key?
  458. Re: Formulas
  459. Re: paste special background colored cells
  460. Selection Lists and other
  461. macro so no option button chosen
  462. Array question
  463. auto updating cell values help
  464. Find Lowest Column Among Several
  465. PivotTable Source & Destination
  466. Named Range
  467. Delete some rows at the end of the file
  468. Error Checking Assistance
  469. paste special background colored cells
  470. Formulas
  471. Macro help
  472. Addin / Library Reference question
  473. Image Edit and WebBrowser controls
  474. Toolbar macros
  475. Image and WebBrowser Controls
  476. Can a hyperlink run a macro?
  477. execution of code takes very long
  478. auto updating cell values
  479. Using the addin solver inside a macro
  480. regarding: Trouble Drawing shapes with macros in Excel
  481. Return text in textButton from cell
  482. RE: HOW TO: CONVERT CSV DELIMITED FILES TO XLS
  483. Drop down list reliant on condition
  484. Re: set value of activex control group
  485. set value of activex control group
  486. RE: Line position in code
  487. Converting from Row to Columns
  488. Re: Replacing code at runtime
  489. INDEX with 2 criteria search . . .
  490. SaveAs Error
  491. Need Help With Code Quick!!
  492. "rabc0011" = "abc0011" ????
  493. Re: Deleting data but not formula
  494. continued help needed
  495. Replacing code at runtime
  496. Changes with Excel 2003
  497. Why do other apps - particularly IE interupt excel VBA
  498. Opposite of Intersect function - an example
  499. 'Server-side' apps
  500. Manually assigning Macros to Buttons w/o File Dependence
  501. Need help with code
  502. Limitations of shared workbooks
  503. Deleting data but not formula
  504. Imitating Pivot table's context awareness
  505. Manually assigning Macros to Buttons w/o File Dependence
  506. Re: Passing Excel Objects As Parameters
  507. Passing Excel Objects As Parameters
  508. Reading Entire Range
  509. cell reference help
  510. Create Next and Previous Buttons on Userform
  511. Re: Using dll with a dynamic link in VB
  512. Trouble Drawing shapes with macros in Excel
  513. Line position in code
  514. Worksheet Change Event
  515. Re: Table Lookup (VLookup, Index, Match)
  516. Table Lookup (VLookup, Index, Match)
  517. Calculate accuracy of original estimate
  518. additional cell address help
  519. Re: Can Excel take advantage of multiple processors and hypherthreadin
  520. MS Exchange Macro
  521. Other Basic conversion to vb
  522. Excel VBA clipboard problem
  523. Links not working an Excel spreadsheet with VBA buttons on it.
  524. Methodology Question
  525. cell address
  526. Can Excel take advantage of multiple processors and hypherthreadin
  527. Variabilized Variable
  528. Run Workbook_Open only if called
  529. changing a piece of code
  530. macro so no option button chosen
  531. Using the addin solver inside a macro
  532. Re: Error in formula =YEAR(B4)-YEAR(A4) gives me #Value
  533. Error in formula =YEAR(B4)-YEAR(A4) gives me #Value
  534. If B1 = 0 then D1= True - I need to write this in a macro
  535. return textfrom cell into textbutton/commandbutton
  536. Re: Display two sheets at once
  537. Re: Display two sheets at once
  538. Re: Overwrite existing file without prompt
  539. How to set in XLA calculation on xlCalculationManual
  540. Display two sheets at once
  541. Overwrite existing file without prompt
  542. MarkerBackgroundColorIndex = xlAutomatic
  543. VBA Compatibility Problems
  544. Transform the E notation (5.41603241874481E-02 )
  545. UserForm code help needed.
  546. Open workbook-macros enabled, opening another with macros
  547. Copy cells to new worksheet but only IF
  548. Is this possible?
  549. RE: Using dll with a dynamic link in VB
  550. Excel object model
  551. Using dll with a dynamic link in VB
  552. pivot table question
  553. Balk (record new macro) does not appear
  554. pivot table question
  555. test for formula result
  556. legacy dll and excel
  557. Date to Text
  558. need help finding unique numbers ( to 2.d.p).
  559. referring to a chart without using its name??
  560. More Beginners help!
  561. show value
  562. problem calculating rate of return
  563. Find & Replace ~
  564. Excel file cannot open
  565. Faster copy-paste macro - easiest way?
  566. Need Help Copying cells into another workbook
  567. Macro's doesn't work (in potected Sheets)
  568. Auto Close A Workbook...With Two Twists!
  569. EXCEL MACRO - fill column with color
  570. fomatting issue
  571. Manipulating a data file with some sort of Macro
  572. Re: Size & Position charts on Sheet
  573. Not sure what I did (HELP)
  574. Code not working after worksheet change.
  575. how can i change the default sort order in excel?
  576. Limitation of Find and Replace Text in Excel
  577. Macros are not working in Excel 2003
  578. Reading from a .xls spreadsheet based on a cell name
  579. tom ogilvy? somebody?
  580. Re: How to subtract weekend days?
  581. Excel Macro Question
  582. help with find and copy
  583. Re: using a macro to delete duplicate data (cells)
  584. Re: How do I copy a hyperlink path to another cell?
  585. How Do I Run Subroutines in .xla files from VBA Code in Spreadshee
  586. Assigning a value to an array cell
  587. SaveAs without prompt
  588. FileSystemObject: object.Name [= newname] = Permission denied(Erro
  589. do loop help
  590. Disable Print Screen Round 2 . . .
  591. Microsoft Excel Macro
  592. MID$ error in excel 2003
  593. simple question
  594. How to add a column without "=SUM(R10C2:R15C2)"
  595. Conditional Row Delete
  596. Copy range excluding group data
  597. programmatically open excel from asp with web query url loaded
  598. Storing data between sessions
  599. Is there a way to create a Wizard type of program to auto populat.
  600. Display Worksheet If It Exists
  601. how do i unlock a file
  602. Can you tell how Excel is launched?
  603. Pocket Excel Default Margins Change
  604. Tom Ogilvy
  605. losing variable after "unload me"
  606. Re: I have a challenge for all you VBA experts out there!
  607. go to question
  608. search and copy
  609. removing first three characters
  610. Filtering Data
  611. find a value in a row
  612. Security in Quattro Pro .wb3 conversion?
  613. Comparing rows on one sheet to list on other
  614. Excel VBA - Cursor disappears when validating content of a TextBox
  615. Remember a cell
  616. Using R[1]C[1]
  617. Restricting VBA macros
  618. select range textbox limitations
  619. Calling VBA add-in functions/subs from another Excel file.
  620. Re: How to subtract weekend days?
  621. Followup to Excel OLE Error
  622. Name Tab With Date
  623. first empty row (visual c++)
  624. Looping Web Query
  625. Copy excel file to subfolder
  626. Macro to move first name to last position in cell
  627. Transfering dynamic data
  628. Re: Conditional formatting of a column of values
  629. How to subtract weekend days?
  630. How to subtract weekend days?
  631. I have a challenge for all you VBA experts out there!
  632. Round-Robin Scheduling
  633. Placement of graphical object on screen
  634. Conditional formatting of a column of values
  635. open new excel sheet
  636. How to subtract weekend days?
  637. "Delay" function in Excel
  638. vba code to cycle through each column in a sheet
  639. Re: vba code to cycle through each column in a sheet
  640. Macro Pathnames
  641. export excel data to a field in a pdf.
  642. Variable problem
  643. vba code to cycle through each column in a sheet
  644. question for Ron de Bruin
  645. Accessing workbook info from a different workbook macro
  646. Duplicates across tabs
  647. combobx help!
  648. Form's design change
  649. Lookup table value
  650. Image contol
  651. Placement of graphical object on screen
  652. Better way to apply change to column of values
  653. Round-Robin Scheduling
  654. copy and paste from a grid
  655. Hide a form button
  656. Modifying many cells with find/replace without losing unique data. pls help
  657. Variable drop down list
  658. Grab Server Time
  659. Excel 2000: Points vs. Pixels
  660. launching excel, a file, and a macro automatically
  661. Custom faces for custom menus/commandbars
  662. Works but...
  663. RGB Colours in Excel 2003
  664. Conditional Formatting -
  665. Wrong data format?
  666. Dropbox Question:
  667. One workbook at a time . . .
  668. Sum Cells and assign to variable
  669. Color whole row
  670. code that can distinguish between alpha and numeric characters
  671. Loop through objects/controls on worksheet
  672. Re: How do I use ActiveX calendar in an excel?
  673. Slow printing from Excel 2003 VBA
  674. Error trapping after Dir statement
  675. date last saved
  676. Create a Loop to check cells between workbooks
  677. Set Path for GetOpenFilename
  678. Getting Range of CurrentArray In Formula
  679. How do I use ActiveX calendar in an excel?
  680. VBA help to output a file
  681. Where to locate reference
  682. Help!
  683. Storing generic objects in workbook via automation
  684. using a macro to delete duplicate data (cells)
  685. code problem
  686. Hiding columns in another Worksheet
  687. dim a String A="2+3+5" A=cdbl(A)???
  688. How do I copy a hyperlink path to another cell?
  689. why the value in the column X is cleared
  690. Form Exit Event
  691. UserForm
  692. Working offline
  693. Re: How to move cursor from one textbox control to another textbox con
  694. print from listbox
  695. why the value in the column X is cleared
  696. Parse Data
  697. Automated Series for X,Y point diagrams
  698. File size
  699. how do I create greenbar paper simulation in Excel?
  700. How to move cursor from one textbox control to another textbox con
  701. Re: HOW TO: CONVERT CSV DELIMITED FILES TO XLS
  702. Set cell formulas in another workbook.
  703. Validation from another sheet
  704. how do I create greenbar paper simulation in Excel?
  705. Is it possible?
  706. Is it possible to disable two or more controls from the same toolbar, when those cont
  707. language version excel
  708. Disable Print Screen Challenge
  709. Easy newbie question
  710. Help w/ CheckBox ?????
  711. How do i input data into a 2nd column in a listbox?
  712. DLL in C with function returnung string
  713. Running windows command from a VB code
  714. UsedRange and CurrentRegion
  715. Re: Can run-time 1004 be trapped ?
  716. Using formulas to filter information
  717. Slower run with many sheets
  718. Excel problem - why won't my macro work?
  719. Macro convert CSV -to- XLS without parsing line by line
  720. Can run-time 1004 be trapped ?
  721. Recursive directory listing
  722. Macro help in capturing server time
  723. Problem with focusing on Application.Inputbox type:= 8
  724. Talking to a class or type between 2 sheets
  725. Where to put the sub-programm, GetOpenFile
  726. Re: Using Excel in construction drawing
  727. Categorising figures
  728. Referencing worksheet question
  729. Setting properties to combobox
  730. return 0 for error value #N/A in microsoft excel?
  731. Cell Comments - Can they be 'very' locked programmatically
  732. Copied empty cells, give sorting problem in Data sheet
  733. safely open file
  734. Disable a few commandbars, but when duplicates?
  735. Macro using Excel & Outlook
  736. Re: HELP! - Closing form
  737. VBA question
  738. Re: HELP! - Closing form
  739. code problem
  740. urgent help needed to clean up code
  741. List Box Column Headings
  742. FIFO method calculations
  743. Licensing question: Microsoft Excel ODBC driver and MDAC 2.8
  744. Quick way of copying Range to (sub)Array ?
  745. Please help (need someone smart/nice)
  746. Help with SumProduct or Sum Array Formulas
  747. how can I Break a raw into two ??
  748. Macro Question
  749. Re: I'm missing something here....
  750. Open a Template/CSV-File from the command line
  751. Using workbooks.open after new instance of excel application
  752. Save As Overwrite
  753. AutoSave Funtion In VBA
  754. Querytable naming cells
  755. Text AND dates in the same cell
  756. Macro Help......
  757. Save workbook
  758. Run a macro each time a workbook is saved
  759. Sorting From Macro in another workbook
  760. How to invoke spellchecker in VBA to check a string?
  761. Left hanging
  762. cmbx question 5 or 6
  763. combx for T Ogilvy
  764. For To Next loop
  765. Protect chartobjects, allow copy paste but NOT CUT (or delete)
  766. named ranges at workbook and worksheet levels
  767. Macro Pathnames?
  768. Protecting Sheet with Password
  769. Re: vlookup using a variable
  770. Re: How can I double-space in an Excel cell?
  771. combx problem
  772. Re: Need help with automating adding Names ranges
  773. How to view Pocket Excel files in Windows
  774. Re: what does #### mean in an Excel worksheet?
  775. Re: Getting excell to see a info bit from the outside
  776. How to parse a csv string with text qualifiers
  777. Open File
  778. Re: Help- REMOVING SHORTCUTS.
  779. Macro's not working on different pc. Help!
  780. Getting excell to see a info bit from the outside
  781. How do I link cells?
  782. Run worksheet level macro in a macro
  783. Selecting A Range
  784. Delete leading or trailing blank spaces in cell - an example
  785. Warning
  786. Dynamic data
  787. GetOpenFilename Question
  788. additional help
  789. How to programmatically check if a workbook is protected t?
  790. Re: Formatting a date in a macro
  791. delete sheet
  792. Microsoft Internet Transfer control with excel 2003
  793. removing duplicates
  794. Please help with referencing!
  795. Cleaning Sheets
  796. Re: Copying Worksheet to Another Open Workbook
  797. intersect and combo box
  798. How to hide the content of a cell?
  799. Re: Compare two text files
  800. Re: Subscript out of range problem
  801. Subscript out of range problem
  802. Re: Subscript out of range problem
  803. Re: Disable Saveas Dialog
  804. Re: EXCEL 97: Count Conditional Formatting?
  805. Re: EXCEL 97: Count Conditional Formatting?
  806. Re: How do I set up an Excel template to generate a new number every .
  807. MS Excel 2000 & VS .NET 2003
  808. Excell 2003 Page Setup Slow
  809. segregating passed range by rows and columns
  810. Re: Saveas Dialog Box
  811. Re: Compare two text files
  812. Excel locks when trying to unlock a password protected project (in VBA).
  813. Re: HOW TO: CONVERT CSV DELIMITED FILES TO XLS
  814. VB.NET
  815. Access
  816. conditional formatting
  817. automate sending graph/pivot report in body of email
  818. Select First Worksheet
  819. delete multiple pagebreaks
  820. Do not know even whare to start on this one!
  821. Looping and Comparing values in two workbooks
  822. Menu item created w/ add-in removed due other add-in
  823. Database Setup
  824. Sendmail
  825. Deploy a vba application over an intranet
  826. Zoom Function
  827. Re: what does #### mean in an Excel worksheet?
  828. Re: what does #### mean in an Excel worksheet?
  829. Insert row
  830. Re: RowHeight automatically change when user does ALT+ENTER for linefe
  831. Restoring the current result of failing user-defined functions
  832. Code Question
  833. Add additional criteria.
  834. Re: Can I count multiple parameters?
  835. Background colour using VB
  836. It's posible to change security level from VBA?
  837. Using ComboBoxes to get range of values
  838. Re: Background colour using VB
  839. How can I change the source of my extern source database in an ex.
  840. Macro to copy cell data to word document based on an active row?
  841. Re: How do I choose to only add the first 3 numbers in a range?
  842. How to kill Excel Instance
  843. Copy columns if cell row has a value
  844. Adding a macro to an option button
  845. Selecting rows
  846. transposing data from multiple tabs
  847. Saving a file with a name generated by cell values
  848. Re: Printing only rows with values - newbie question
  849. Re: Printing only rows with values - newbie question
  850. Error or Unexpected Behavior with Office Automation when you use early binding
  851. find duplicate data and copy to a third worksheet
  852. Load a Combo Box Object upon workbook open
  853. Re: save format & data to new workbook
  854. Excell & Outlook Express
  855. Identifying the active cell
  856. How can I export a Pivot Table with saved data created by OWC?
  857. How can I export the Pivot Table with saved data created by OWC?
  858. 2 dimension lookup
  859. R1C1 Property in VBA module
  860. Password
  861. How to view other's reply in search mode...
  862. How to use User-defined-functions in other workbooks?
  863. Excel on the web
  864. VBA - speed up macro, working with array?
  865. Excel 2003 - "interesting" feature when running macros
  866. Only allow specified strings in a range
  867. Visual Basic/Excel Changing font olor index in part of a string
  868. excel version and servicepack
  869. ODBC Syntax Problem
  870. how to hide the characters in the cell
  871. exclusion list in code
  872. Unprotecting a VBA Project
  873. run a macro in another macro
  874. Custom Functions in C/C++ against in VBA
  875. Re: Copying Worksheet to Another Open Workbook
  876. Re: Copying Worksheet to Another Open Workbook
  877. Re: Copying Worksheet to Another Open Workbook
  878. Re: Copying Worksheet to Another Open Workbook
  879. Re: Copying Worksheet to Another Open Workbook
  880. Re: Copying Worksheet to Another Open Workbook
  881. Re: Copying Worksheet to Another Open Workbook
  882. Re: Annotating Cell/Value in Cell
  883. Re: Auto Recovery?
  884. Re: Copying Worksheet to Another Open Workbook
  885. How to write a macro to count clicks in Excel?
  886. Copying Worksheet to Another Open Workbook
  887. how make two if conditions on the same cell in excel
  888. Re: Auto Recovery?
  889. Can reciept of an email in outlook express be used to trigger an even in excell
  890. finding coordinates for cells
  891. How to stop a macro while it is running ?
  892. Initializing Combobox in a Userform
  893. reading a data file
  894. Error 424 with inputbox method after OK
  895. Move data to different sheets
  896. Re: Auto Recovery?
  897. *** Tom Ogilvy *** Re: Return to Cell After Sort - Continued
  898. How Can I hide sheets when closing the app?
  899. Re: CUSTOM MENU DESIGN
  900. Re: Toolbar from workbook to workbook
  901. Convert Column Letters to Number
  902. Delete Hidden Data
  903. Help w/ Left, Right, Mid String
  904. VBA or VB.Net? Book recommendations??
  905. Run macro based on cell value
  906. Is it just me (or my ISP)?
  907. How do I set VB to Break on All Errors?
  908. Re: Supress "delete sheets" warning
  909. Re: Supress "delete sheets" warning
  910. Creating a database in Excel
  911. Re: Deleting Names
  912. cells control like hyperlink?
  913. Subtotal for median
  914. New window blues in Excel
  915. Row Heights
  916. Different date behaviour in different computers
  917. Userform-allow numerical input?
  918. Excel VBA Error Message
  919. Variable Scope
  920. Re: Promlems with DAO
  921. Find and Replace
  922. Application.vlookup problem
  923. hours converted to Days hours and minutes
  924. Re: Visual Studio
  925. Excel Screen Issue - Bizarre!!
  926. New Folder, Workbook, and Worksheet
  927. Re: Excel Open
  928. Command Button to submit
  929. Re: Multiple cell referencing
  930. How to I Avoid the Auto-Email Security Warning
  931. Calculate Number Of Sheets To Print In VBA
  932. Cells( rowNumber, colName ) doesn't work
  933. Re: Excel should take a range of numbers and calculate different num..
  934. Re: lookup, intersect, find ?
  935. change links
  936. Running autocad from excel
  937. Re: How do I remove [GROUP] from top of the page in a formulated spre.
  938. Convert an Excel file into a text file.
  939. vba replaced by .net
  940. Get address of Cell
  941. Re: timecode calculator
  942. Re: Finding a particular character in a string using VBA
  943. VBA problem repeat task for each colum?
  944. Not sending a Worksheet with SendMail
  945. Dialog not displayed to the front
  946. Next Friday's Date Using Cell Formulae
  947. Hide/show sheets by first part of sheet name
  948. Macro: Row transposing; event on open vs. shortcut key
  949. Data bound VBA forms
  950. Date type mismatch
  951. Next Firday Date Calculation in VBA
  952. Creating a Word Document from Excel Data
  953. Cell borders
  954. Re: Problems merging an excel file due to code or file problems?
  955. VBA cannot see data in Range("G1").select - but its there!!
  956. combo boxes
  957. Number in string manipulation, obtained by a cells().value
  958. Is there an image?
  959. COM Addin doesn't link to workbook
  960. Calendar Control-- Center the numbers?
  961. Re: Interactive Data entry
  962. Workbook Deactivate
  963. Word VB Problem - Is it possible to create a menu
  964. the usage of boardkey shortcuts in excel
  965. AddOLEObject
  966. "Could not decrypt file." error on non-password protected file
  967. maximum likelihood estimation of weibull parameters
  968. Redefining a new Range area - Thanks Nick Hodge and Norman
  969. Input box
  970. Launch Excel vba macro from Access?
  971. IS THERE A FORMULA FOR AUTODATE?
  972. How to add my button or menu item in Excel using VC++ 6.0
  973. Re: Calculations and significant digits
  974. Specify a default file name in VB when the Save / Save As command.
  975. Help needed from Tom Ogilvy
  976. Message Box
  977. matching data in VBA
  978. Refreshing External Data on File Open
  979. VBA - vlookup
  980. Re: Calculations and significant digits
  981. workbook or worrksheet event procedure
  982. Re: Calculations and significant digits
  983. reading workbooks across multiple excel applications
  984. combobox format
  985. Setup Spell Checking on Userform textboxes
  986. list o installed printers
  987. RefEdit - get range from another workbook
  988. Copy figures to text
  989. Drop list in cell
  990. excel 2002 build version and servicepack information needed
  991. an OLE Action
  992. Pivot Table Refresh
  993. 2003 save workseet as
  994. Summary sheet
  995. problem in seek value in recordset with index.
  996. copy formula, VLOOKUP
  997. This function unknown
  998. Shortcut key to display change the display from displaying cell values to cell formulae
  999. I donīt want to let them run in a Mac
  1000. Create toolbar-help