PDA

View Full Version : Microsoft 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 176 177 178 179 180 181 182 183 184 185 186 187 188 [189] 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236

  1. Re: setting chart axes
  2. Open Unique excel.exe
  3. Re: Checking entire row for duplicates
  4. Display a range fullscreen
  5. Re: Inserting Formula
  6. Trigger Event
  7. [UserForm]: *.gif
  8. Tutorials?
  9. Getting data from several worsheet/books
  10. Key Identifier for Sheets?
  11. Initializing a Form with multiple forms embedded
  12. Re: Nursing shifts shift scheduling software
  13. Whats wrong?
  14. Updating of one file and prograte to others files
  15. Calling to a specific cell
  16. Re: adding Activex control through code works BUT... Cannot access ob
  17. Open then Close
  18. Comparing Two Cells in Excel
  19. when would you use "new workbook"
  20. Re: Deleting workbook
  21. ListBox.ColumnHeads Property
  22. Macro crashes excell from remote location
  23. password protect
  24. Excel VBA - How do I programmatically change source code in another file?
  25. Renaming Files: Take 2
  26. comparing values in excel with vb6
  27. Error
  28. What should I do when this has no data?
  29. Re: Createobject (repost)
  30. Calculations in a pivot table data set
  31. Traversing two named rages of unequal length
  32. Project Name vs. Workbook Name
  33. Outlining works in XP not in 2000
  34. save as...
  35. Renaming VB Form Causes Macro Corruption
  36. Protecting an Excel Sheet name from being changed
  37. Difference b/w 2 worksheet
  38. Cell contents in Excel??
  39. Array formula with =sum
  40. Iterative Macro
  41. VBA Auto Cell Formatting Uppercase
  42. Copy image of UserForm to a clipboard
  43. VBA
  44. creating Databases and tables
  45. Percentage code
  46. Combobox Value
  47. Improvement to sub: Detect data extent and convert to values
  48. creat and transfer data sheet1 to sheet2
  49. Can not open excel workbooks from the file manager
  50. Importing cell info from closed workbooks into new spreadsheet
  51. right click menu reset?
  52. setting chart axes
  53. Using macro to add data in specific cell within a table
  54. FAO : Bob Flannagan
  55. Lookup / Vlookup ??
  56. Calculations in a pivot table data set
  57. Calculations in a pivot table data set
  58. using one macro to set a variable in another
  59. Save .txt file as .xls format - HOW??
  60. block scrolling
  61. check if worksheet is protected using code
  62. excel vba.........
  63. Returning Dates - Lead Times
  64. Returning Dates - Lead Times
  65. VBA to copy
  66. Macro to sort Worksheets
  67. Newbie Question: Returning the value from a cell on another sheet
  68. Filesearch with disregard of Case
  69. Starting with command
  70. Ask for help of Excel
  71. Super Easy Question -- "
  72. ActiveX Property Pages are not visible
  73. Property Pages from my ActiveX are not visible
  74. Difference Between UserForm in Excel VBA and the Form in VB
  75. Increment array for debits and credits
  76. Coluring cells in a Range
  77. VBA - Drop down; list range
  78. Option Button Macro (Forms Toolbar)
  79. Moving Cursor once set number of characters are entered.
  80. Trying DROP TABLE in SQL from Excel
  81. Hyperlink
  82. Shrink Formula
  83. Pasting formulas without copying file ref.
  84. Color constants in VBA
  85. Help Me!!. can not set the string with len more than 255 character to the value cell
  86. Retain, restore selection?
  87. Question on Custom Sum Function
  88. loop
  89. 16 digit Credit Card #
  90. new to excel help me
  91. Re: Pivot Tables: counting columns and matching
  92. Range question in VB
  93. Find & Replace Macro from external spreadsheet/db?
  94. How to verify a cell is in a named range
  95. Error in code opening Outlook
  96. Deleting new control button on auto_close??
  97. counting device
  98. Loop expression to calculate return
  99. Naming a range versus formula in Excel
  100. Running a Command Button from a different sheet
  101. calculations in large data set and in pivot table
  102. Calling a sub with a variable...
  103. Swtiching the focus of Textboxes
  104. Workbook Open
  105. Database Query
  106. Re: minimum scale error code
  107. Rename Files
  108. Populating a cell with numbers without numbers being formula-based??
  109. Please help with vba code question
  110. Hiding the sheets my macro works with...
  111. Open pdf without converting
  112. Re: I want a msgbox when the contents of cell change
  113. How do I set a default path when using Application.GetOpenFilename
  114. Copy data from an external application into Excel
  115. Column question
  116. Internet printing problem using hyperlink from worksheet
  117. Wild Ideas
  118. How to check for password in an excel file.
  119. Why this 1004 Error message?
  120. Null?
  121. Data Validation
  122. Text Files
  123. Merging part of one field with another field
  124. Re: where is my record button?
  125. How do I add a Password?
  126. Modifying text files with VBA?
  127. converting architectural units
  128. Totals
  129. How do I set a default path when using Application.GetOpenFilename
  130. Office/Excel 2003 - Stop toolbars automatically opening
  131. Stacked Column VBA
  132. Numbers
  133. Re: Creating a custom toolbar in VBA
  134. Searching with Macros
  135. Excel VBA from Excel 97 to Excel 2000 errors
  136. Testing for content in Range
  137. Dynamic range
  138. run time error 13
  139. Count Pages
  140. Netsend or another type command
  141. To: Bob Phillips
  142. Bold certain text in textbox
  143. Inserting a line....
  144. Excel Macro - Save Function Problem
  145. Sending multiple emails using SendMail
  146. =sum formula using arrays
  147. VBE Custom menuitem not calling OnAction macro
  148. Control Toolbox
  149. Formula to name tabs in excel worksheet
  150. Re: rounding a formula in a cell, then replace the formula
  151. Global vars
  152. Re: rounding a formula in a cell, then replace the formula
  153. Creating Buttons and assigning code
  154. labels, comboboxes, etc
  155. Non-contiguous selection
  156. DragAndDrop_event doesn't exist - any substitute?
  157. Looping through to stop on pie charts
  158. Compare Current Date
  159. Yes No dropdown box
  160. Delete duplicate cells
  161. Connection to notes
  162. Avoid user to access first two rows in a sheet
  163. Relative path
  164. Altering Textbox Colour
  165. Can anybody help please? Urgent
  166. Active Workbook Properties - comments
  167. Forms and sheetranges
  168. To: Dave Peterson
  169. Hosting XLS files within IE 6
  170. Copy From Recordset
  171. Reference to a variable in windows(???).Activate
  172. Creating a worksheet with values based on a control cell
  173. How to make Excel feel switching application?
  174. change all instances of Queensland to QLD
  175. Variable Value
  176. Events and values and Ranges
  177. Error 1004 - Out of Memory
  178. Error 1004 - Out of Memory
  179. Auto refresh and DDE update is not work when running macro
  180. Is worksheet protected?
  181. Excel Vba - Comparing 2 ranges of data and displaying result in another worksheet
  182. Header & Footer
  183. Format of textbox on userform and correct result
  184. Using solver in macros - Help
  185. A simple question -- Evaluate()
  186. Look for numbers in a cell
  187. Unable to add user-defined data types to a collection
  188. Data transfer macro
  189. Range and Cells
  190. FileServer with GetOpenFilename
  191. Auto_Open and Workbook_Open
  192. Excel2000: How to copy data validation using VBA
  193. Help Me! Exporting Excel 97 to Excel 2000/2002
  194. Calling macros from a VB app
  195. Exporting Excel 97 to Excel 2000/2002
  196. Spaces in sheet names
  197. OnAction menu item property coding
  198. "AND" statments in Excell 2000
  199. Can you registrate a drag and drop event?
  200. ? about the VBA code
  201. Setting default values of user defined data type
  202. Removing AUTOSAVE.XLS(AUTOSAVE.XLA) from VBA editor???
  203. Importing a text file using ftp
  204. Making Worksheet Menu Bar button sink or raise???
  205. problem with 'flagging' monthly anniversary dates
  206. EXcel VBA - OnAction menu item property
  207. filter result box
  208. Delete Duplicate Records
  209. Jim Rech's Browse for Folder
  210. Saving the contents of the clipboard
  211. worksheet tab colouring
  212. Formatting CSV file
  213. How do I list all file names in a directory
  214. Click event unhiding sheet
  215. C++ SetEnableEvents(true) Question
  216. Referencing Multiple Cells with Nested IF statements?
  217. Deleting Worksheets Within A Macro
  218. Where do macros go?
  219. delete method arguments?
  220. worksheet events and referring to named ranges on other worksheets
  221. 2 VB questions
  222. Selecting a Range inside a range
  223. Macro to Autofill Row
  224. Calling procedures in .xla projects
  225. Excel-97 versus Excel2003
  226. Magic Moving VBA buttons
  227. Quick Question on Hyperlinks
  228. Getting file name from absolute-path
  229. Verifying a cell is in a named range
  230. Re: Excel Sheet Drop Down Menu Automation
  231. PSW for Macro & Codes
  232. keeping buttons from moving
  233. Hard Return in large textbox
  234. formulas in code error
  235. Re: page setup via code
  236. How do I Insert a row that includes copied formulas
  237. Color Code Duplicates
  238. Can I automatically populate my dropdown with all available macros
  239. Browse for folder
  240. Can I automatically populate my dropdown with all available macros
  241. Reading the contents of an inserted picture
  242. Copying Macro to Several Workbooks Fast
  243. Remove all Listbox items
  244. selecting a row by header row in VBA
  245. Clear a textbox
  246. dates
  247. Newbie Post - Clear All Button
  248. Re: How To: Page Fields
  249. Automation COM Addin with Excel
  250. bizarre "invalid procedure call" error
  251. Index or Match?
  252. Re: Digital Signature issue in Excel files
  253. How to access Excel-Sheets from outside Excel ?
  254. Excel97 (w/ VBA) Template won't open in Excel2003
  255. Dropdown box of macros
  256. Function unable to return Collection object
  257. Re: Activating Worksheets and Importing Data from them
  258. Find
  259. True/False Checkboxes
  260. Applicaition Default File Path
  261. Embedding of graphs/charts in forms possible?
  262. Print to .csv file
  263. Help with creating Excel Macro
  264. How do I find out my row number
  265. Macro won't execute when "For Each 'range' in 'range'" is added
  266. Probelme with coding...
  267. sql querries
  268. Changing range name in loop
  269. Searching for specific text
  270. Controlling java applet
  271. Deleting entire rows based on certain criteria
  272. Compile Error
  273. Returning From VBA Event Code Called From Excel 4.0 Macro
  274. Re: Run-time Error '1004' Unable to get the findnext property...
  275. Re: OPEN WORKBOOK WHEN EXCEL OPENS
  276. Opening File Browser
  277. Error Checking Option
  278. Certificate Problem need solution
  279. Automatically print in Excel
  280. Excel 2003 / IE 6 bug closing workbook
  281. excel to powerpoint via macro
  282. VBA ?
  283. Need help with creating a special copy and paste macro
  284. Display set range
  285. Doing it's own thing - Jim R - Check here
  286. disable mulitple select on pivot page field
  287. Override error code 214154 - max embedding
  288. sql querries
  289. Building COM Add-in in XL2003
  290. Docking windows in the IDE
  291. Re: Disable Format Painter?
  292. Date/Time Picker Event Won't Fire
  293. Printer Dialog Box
  294. Save= False Question
  295. Zip workbook
  296. Excel Crashes When Copying Multiple Sheets in VBA
  297. Counting a range of cells based on 2 dates?
  298. This Worksheet_Change sub doesn't work - why?
  299. Sum depending on cell background color
  300. Links from Word no longer updating
  301. Searching within excel
  302. Apllication.OnTime
  303. #NUM!
  304. Change and update contents of a dropdown combo ....
  305. Integration between VB and Excel
  306. Searching a column
  307. Find & replace with VBA
  308. Protecting VBA Project
  309. what is wrong with creating pivottable ?
  310. Deleting rows based on multiple criteria
  311. Excel200: Strange behaviour for Name when referred from VBA
  312. How to define a Range with variant?
  313. Protect/Unprotect function options
  314. UNDO in EXCEL97 macro
  315. Sheets Name into array for form dropdown
  316. Row Height for merged cells
  317. Macro to create worksheets base on name
  318. Dates
  319. creating a routine to help memorize
  320. Repost: ListBox Headings - customized! Class Module (warning: long post)"
  321. Analysis Services accelerator for Excel deployment
  322. Extra rows in csv file
  323. Multiple ComboBox Lists
  324. importing data from multiple excel spreadsheets
  325. From Excel to VBA and back?
  326. InputBox: Display Cell Content not Cell Ref ?
  327. Followhyperlink - How do I disable IE launch?
  328. An advanced email question.
  329. ADO & CopyFromRecordset performance
  330. Error handling
  331. save into file while user is entering values in cell
  332. Updating Access Database from Excel need help
  333. FORMATTING CELL CONTENT !
  334. Auto_Open and Workbook_Open in Addins
  335. Automatic Updating
  336. Macro link issue when saving as new filename.
  337. How do I solve this (Part II)
  338. Word Control in Excel
  339. Inserting Picture from Camera
  340. Capture Custom View in a Variable
  341. Attaching Custom Menus
  342. SaveAs works on one PC, not another. "Save" not really an option. What to do?
  343. Listbox 2
  344. #N/A
  345. creating a formula in textfield
  346. VBA Stmt Format to Get Contents of Cell in Another Book
  347. Simple way to convert UTM ED50 coordinates to decimal coordinates?
  348. Excel VBA - Win Lose Streaks
  349. inconsistent date conversion
  350. ListBox population from Excel range
  351. ActiveX Textbox question
  352. Program issue w/ VBA on next row
  353. SMS with Excel.
  354. Check to See ( Find ) if a Value is in a Table
  355. Need a function to keep track of total data.
  356. User selecting range from userform via dropdown menue
  357. looping and objects
  358. reading xml fields into excel
  359. "enter" event of activex combobox?
  360. VBA to Email Attachment
  361. DAO Excel to Access
  362. Range Selection
  363. Unable to Lock a Range
  364. Re: Running a macro in another workbook
  365. Storing Cell Values in Access
  366. List box to reference another workbook
  367. parsing HTML table into excel. How?
  368. Restoring Screen Resolutions
  369. Can Excel load data of volume 50 mb and analyse also by adding 25 mb more
  370. External data references in a userform control
  371. search worksheets in different workbooks
  372. download .csv file indirectly from website - long
  373. Changing filenames using theSaveAsCopy method
  374. Beginning forms
  375. dynamically changing chart y axis using spin buttons and worksheet_calculate event
  376. Sort Macro
  377. Help with VB and Excel
  378. Unprotecting worksheets with a macro
  379. Scramble password a little bit
  380. User/pass prompting code
  381. Conditional Row insertion problem
  382. Write to Output Type Formating
  383. Add menuitems to the VBE
  384. Re: hi I want to add the results on comparison with 2 fields.
  385. PageFields in 'Rows to repeat at top'
  386. Filtered Visible Rows & VBA Non-Filtered Rows Displayed
  387. Can You Re-Create this problem?
  388. ADO
  389. Applying the find fuction to a button
  390. Disable Format Painter?
  391. worksheet change event > error events disabled
  392. Help with VB and Excel
  393. Userform
  394. VBA for changing a defined name reference
  395. Re: Bad DLL
  396. Help! Please!
  397. To cut rows from a sheet with multiple blocks of data
  398. Workbook BeforeClose Bug
  399. MACRO TO EDIT CELL FORMULA !!
  400. count and sum of dynamic range ????
  401. Loop Problem
  402. How to keep excel from crashing?
  403. Network detects if Windows Username is online
  404. After GetSaveAsFileName question
  405. What Is "Me." in Visual Basic Coding?
  406. Print Last Page
  407. Edit points, how to show that view at the end of a macro execution
  408. Alternative to InputBox
  409. Icons
  410. Avoid error with simple subtraction function
  411. question
  412. Application.GetOpenFilename
  413. Re: Automatic Bolding and Background Coloring
  414. Re: Automatic Bolding and Background Coloring
  415. function to return positive number or zero
  416. Adding Code to the This_workbook module of a created workbook
  417. Saving variables in XLA's
  418. ComboBox text resizes on it's own
  419. xldialog
  420. Formula too long
  421. Forms
  422. Run Time Error
  423. Application onEntry with IF then statement
  424. Excel VBA - read a WS and show results on another
  425. CHANGING FORMULAS WITH VBA !
  426. FILTER SHEETS BY NAME
  427. Problems with reading files
  428. Error whil reading file
  429. Querying Password protetected Access DB with ADO
  430. Grater than or less than formula
  431. adding a month onto todays date
  432. Vlookup from a a different workbook with filters assistance please
  433. Re: Dynamic Range in Macro with R1C1
  434. Using the COUNT funciton to count cells with values
  435. Exceeding Max. (32,000) Data Points in a Series
  436. Re: Variables
  437. ADO Connection stopped working
  438. Re: Bad DLL
  439. Doing it's own thing
  440. Bypass Textbox Validation
  441. Conditional Formatting using VBA Code
  442. Pour ecrire dans une cellule
  443. How do I copy a Form from one VBAProject to another
  444. traversing through a filtered range based on another filtered range
  445. Newbie: Excel Macros and Personal.xls
  446. Hanging Instances Of EXCEL.EXE?
  447. save macro to personal.xls.
  448. Deleting Unneeded Records
  449. Averaging a dynamic range...Help ???
  450. VBE dark red highlight
  451. Weird macro mistakes or goof ups - copy of original post
  452. Conditional formulas
  453. E-mailing pivot tables
  454. Inputbox as Date
  455. activate unknown workbook
  456. Userform size limitation
  457. 'portable' UDFs???
  458. How to access ranges in closed workbooks in custom functions
  459. Re: Running a macro in another workbook
  460. Assign .value with the Mouse
  461. Can you implement a custom format with VB code?
  462. How do I run a macro from a .xlt file
  463. Date Time Picker Control autosize
  464. build POS system using MS Excel
  465. Replicate a macro program
  466. How do I select a range using VBA?
  467. copying values form one workbook to other
  468. Define an array with variable size
  469. Fill series in visible cells only
  470. Finding a Row and cut and copy
  471. Last Resort
  472. Keep Listbox values when closing workbook
  473. Check for Enter key and change focus?
  474. Macro Memory ( Paging File ) Problem
  475. Conditional Formatting question
  476. select workbook
  477. File input though some kind of windows interface
  478. Excel2000: Reading Named Range value from VBA
  479. Help: Election 2004 Project -- Iterative Operations, midmean
  480. After oledb inset in Excel, 'Cannot Access file' error on Excel
  481. Treeview/imagelist problem
  482. string manipulation
  483. How to: check if folder exist, if not, create
  484. Event procedures (and the temple of doom)
  485. Error
  486. Saving sheets with VBScript
  487. Defined Range Problem
  488. Count
  489. Find the table height?
  490. List Box Control out of control
  491. Issue with Excel Macro. Unable to insert quotes before and after the text.
  492. Variables
  493. Convert to a Parameter Query
  494. copy data from 4 worksheets to master?
  495. Template opened while being populated
  496. Solver Reference in Hidden Personal.XLS Crashes Excel 2003
  497. Single quote in a where clause
  498. 97 to 2000 Refresh pivot table
  499. About the Update statement difference between Excel97 and SQL Server2000
  500. Program question
  501. Different between Excel 97 & Excel 2000
  502. How to format a Date to a Real Numerical Date?
  503. call a vb function from a cell
  504. Variables to Comments
  505. Detecting Text Numbers
  506. Excel VBA Macro - parse data
  507. Runtime Error 1004 - Method Range of '_Global failed'
  508. Update Sheet from Formula.
  509. Re: Digital signature/certificate
  510. programmatically open VBE and go to a specified procedure in target module?
  511. Excel 2004 Can't Disable Auto_Open Macro. What Now?
  512. 2 column sort
  513. Install Addin in Excel
  514. Help with Error Message Box code
  515. Can you bypass excel generated pop ups.
  516. Formatting Repeated Values
  517. Is there a way to call selected sheet's name from on deactivate event?
  518. VBA Protection
  519. Re: VBA Question - How to print a frame within a template
  520. Sorry about the last ones...And statements with IF's
  521. Re: runtime error 9
  522. Excel 2003 Save as Bug
  523. Timer
  524. Excel Pop Up Code Required
  525. Excel.exe not terminated after spreadsheet saved
  526. Programming in VB
  527. Re: FileSearch inconsistencies between Office/Windows version combinat
  528. 0 with ADODB Recordset
  529. Weekly report help
  530. Re: Macro to email excel workbook with static recipient and auto subject
  531. MACRO: How to change cells to negative value
  532. Re: populating a cell with text w/ line breaks
  533. Printing Pivot Tables
  534. Solver not Using Constraints when called from VB
  535. Reset Variables
  536. Re: VBA Question - How to print a frame within a template
  537. Pivot Table
  538. Prevent copying sheet
  539. How to avoid excel adding a 0 for cells with a formula
  540. problem with Rows.Count and comparing cells
  541. Prevent formula from deletion?
  542. Re: disable close and shrink buttons
  543. defining an event procedure (lostfocus) that works on a column range
  544. Application.OnKey problem
  545. Excel VBA - getPosition UDF
  546. Excel VBA- Time delaying macro
  547. Database usage within Excel
  548. Query - SQL to Excel
  549. Re: UDFs and file sharing
  550. Help w/code
  551. Import of multiple .CSV files into Excel
  552. Re: "Radio" Button help
  553. auto name sheet w/ macro or function
  554. Combining Macro files
  555. METHOD "SELECT" OF OBJECT '_WORKSHEET' FAILED when opening a file
  556. File Path Class
  557. Macro virus prompt
  558. Error "Permission denied" when printing Web Browser control from button on userform,
  559. Running average without nonzero values or empty cells
  560. PivotCell class
  561. Re: Nursing shifts
  562. Draw lines in a userform
  563. excel - data merger in two cells
  564. excel - data merger in two cells
  565. Non-Modal InputBox?
  566. verify cell if is the same
  567. Keeping add-in private
  568. How to split column?
  569. Macro to add cumulative total
  570. Re: Loop including IF statement
  571. Macro to copy and paste
  572. Re: Addition to existing code
  573. Re: Creating a Directory from a user input
  574. Search and Replace
  575. Re: Default File Path
  576. Re: Referencing cells to VB
  577. Saving and returning to saved screen view? (Pan L/R U/D)
  578. Splash
  579. Re: Default File Path
  580. Excel \ Access Time issues
  581. Message box causing error in code
  582. clearing VBA worksheet names
  583. Adding Message to Spreadsheet
  584. Function to loop through a column and return a value based on an x
  585. Re: A VBA function to give serial date for date and time?
  586. I dont understand....
  587. Serching in document
  588. problem with macro for pivot tables
  589. Excel version reference problem
  590. Copying formating and function from one Column to another
  591. Excel VBA Access Database Error
  592. PasteSpecial
  593. Re: Macro virus prompt
  594. Re: Macro virus prompt
  595. Macro virus prompt
  596. Re: Events problem
  597. suspending-interacting-resuming
  598. Create combo box dynamically - one more doubt
  599. Undo stack
  600. text case
  601. "Application.Function.Text" doesn't work
  602. PROBLEM FINDING MINIMUM
  603. copying complete column incl. formating
  604. searching for a combobox.value and filling in textboxes from results
  605. Exporting Date to Text File
  606. Re: Apply a Macro to a FunctionKey... (again, but with correct email address)
  607. Combining Macro Files
  608. Re: Create combo box dynamically
  609. Named Range - Empty columns
  610. Need to calcualte depriciation
  611. Last open
  612. delete row or col
  613. Re: Updating Access from Excel Macro
  614. Re: Dr Watson is pushing my head under the poo....
  615. Re: Adding "And" clause in SQL string causing SQL Syntax error
  616. Re: Creating a monthly back up using Auto_close??
  617. Re: VB.Net DLL Using Excel Named Ranges
  618. Re: Create combo box dynamically
  619. Re: Alternate row highlighting with a difference
  620. Increasing the width/height of cells programatically
  621. Excel VBA - go to worksheet "name" based on a cell reference ="Name"
  622. Knoppen en werkbalken
  623. Access closed workbook range in Custom functions
  624. Formatting the linked cell when using a List Box User Form
  625. List Box Control
  626. Re: Array of Values from Worksheet Range - What does it 'look' like?
  627. Finding the last used cell in a column
  628. Re: program formula to ignore any cell displaying "N/A"
  629. Re: Array of Values from Worksheet Range - What does it 'look' like?
  630. Re: test cell for text string; return value if condition is true
  631. Re: Array of Values from Worksheet Range - What does it 'look' like?
  632. Re: Another FileSearch Problem
  633. Adding new worksheet using VBA
  634. Re: Another FileSearch Problem
  635. Re: FileSearch inconsistencies between Office/Windows version combinat
  636. Re: ActiveSheet.ShowAllData shows everything - way to have hidden _not_show up?
  637. Re: Update Links
  638. Backup macro running twice
  639. Line Interpolating from X-Y data set.
  640. return screen view
  641. How to save the workbook1 from workbook2
  642. Many users for an Excel file in the server
  643. Command Button Code to copy data
  644. Close where no password?
  645. Macro for unprotecting/protecting worksheets WITH passwords
  646. Write cells fro one file to a specific place in another
  647. Can I stop Excel program flashing on screen during run
  648. Enabling a menu item
  649. Find last empty row
  650. VB Code to stop cells being deleted
  651. RE: Custum Excel RMB Context Menu
  652. User function and Open Event
  653. Finding last row that is empty
  654. VBA Alternative to Vlookup
  655. Returning the value of a named formula
  656. SQL Combining Field Results
  657. html markup to specify data type of cells in Excel
  658. default mail program -activeworkbook.sendmail
  659. Auto Close and Save
  660. Including a variable number of columns in Excel Sum formula
  661. Online Resources for Speeding Up Code
  662. THIS IS A TEST EMAIL....IGNORE
  663. Searching Data
  664. Parallel Task (Threads) in VBa, is it possible?
  665. copy shape image into image control
  666. Group and Outline by marco?
  667. Determine start column/ end column of Merged Cell
  668. Call VBA Gurus - Help to Optimise two small UDF's
  669. Biff8 format documentation
  670. Macro crashing on different computer
  671. VBA help on one of Jon Peltier's Charting
  672. concatenating cell names?
  673. Excel equivalent of 'Keep lines together'
  674. Delete Row At Excel 97
  675. Copy sheets from A to B without reference
  676. Getting started programming a UDF.
  677. ListBox Headings - customized!
  678. Print sequence sheets
  679. Input Boxes & getting tied up in knots with strings!
  680. Disabling/enabling events with a button created by code??
  681. Import and Rename Files
  682. VBA Setting .Value to a date does not respect local system setting
  683. Embedding Command Buttons in a Text box or List box
  684. Deleting Row
  685. Disabling Save Pop-Up
  686. Shape names
  687. Textboxes
  688. Retrieve Macro description
  689. Refreshing a custom Function
  690. Insert Character - Built-In Excel Commands
  691. RE: Conditional Formatting Help Needed...
  692. hide
  693. Subtraction formula
  694. Limiting the scope of On Error
  695. Suppress add-in confirmation message
  696. custom command bar question
  697. conditional printing at top of page
  698. Upload/download a file
  699. Macro that changes Drop Down Box
  700. Excel Programming Help
  701. Specifying position of new Worksheets via C or VBA
  702. preventing input of illegal characters in an inputbox
  703. Updating Values (don't want to be prompted)
  704. Saving a file from a command button with user input
  705. Accessing MS Project from Excel
  706. Solution to Mouse Wheel Won't Scroll in Visual Basic Editor
  707. Excel formula
  708. Workbook Open Event
  709. Enable References
  710. Matching Values to Zero
  711. Generic Plot of a Bollywood Musical
  712. Sorting 2 Linked Arrays [Retry]
  713. Column and row references of range
  714. clipboard forgets on call back
  715. How to thread
  716. Editable Combobox?
  717. Excel Formulas to Clear/Match/Filter Entries
  718. Dynamic Chart Range and Chart Update
  719. formula calculation when cells are changed
  720. Re: Detecting Row Deletion
  721. Windows 2003 Hosting
  722. RE: Detecting Row Deletion
  723. Sync scrolling on two textboxes
  724. count value in column and VBA
  725. Counting specified words in a column - macro if possible
  726. Returning the correct value from a pricing grid
  727. Array Formula in VBA
  728. Excel via intranet Display Alerts problem
  729. conditional page set-up
  730. Command Button Question
  731. Prefix macro
  732. Re: Print Single Statement Help PLEASE!
  733. Startup
  734. I need "On Error" help
  735. Countif
  736. Remove multiple duplicate cells
  737. the best candidate gets its first choice
  738. "Copy Method of worksheet class failed"
  739. Macro to create pivot table/ chart
  740. FTP From Excel
  741. Drill-Down Pivot Macro
  742. Draw border above specific text string
  743. Excel VBA - Newbie: Auto deleting cell value
  744. Function to extract values
  745. VBA PROBLEM - Running Macros!
  746. Read variables from AutoCAD
  747. VB activates unwanted function
  748. "OnCancel" syntax?
  749. Calling Excel Macro From Vc++ via DDE
  750. Cumulative Year to Date Chart