Log in

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