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

  1. Use ADO to add or update date in Access
  2. "Window Trails" showing with Dialogs
  3. Excel add-in password prompt and Act!
  4. changing cell formula part of macro
  5. Reorganizing rows into groups
  6. Selecting the first empty row
  7. UPDATE DATA FROM ONE FILE WITH DATA FROM ANOTHER
  8. Current page method of pivot field failed
  9. creating/manipulating form controls placed on a spreadsheet in excel using vba
  10. Error while controlling Word from Excel
  11. Open/Import ASCII file
  12. Algorithm Problem
  13. Help with a crashing Macro needed
  14. Moving Data Between Worksheets
  15. How do i timestamp comment fields
  16. Running a Powerpoint Macro from Excel
  17. Formula in macro help
  18. Saving with Today's date as part of the string
  19. length Calcs
  20. Excel Error Help!
  21. hightlighting rows
  22. pls reply Parick Molloy
  23. Macro that runs entered value through "low" and "high" range
  24. empty cell = above cell
  25. conditional formating
  26. detect invalid cell reference
  27. RefersToRange.Parent gives back an error(from book written by Bove
  28. Create Add-ins
  29. Cannot get Excel to Quit correctly
  30. Re: Selecting the first empty row
  31. Removing characters
  32. DTPicker calendar control
  33. Multiplying a row with the verticle sum of other rows
  34. Code to query data
  35. Merge two Excel files
  36. how are formulas created and why are they the power behind workshe
  37. Saving VBA Code
  38. Separate data into 2 output ranges
  39. HTML versus MHTML pages
  40. largest factorial that can be computed
  41. copying unique values to different cell
  42. Adding Columns in Excel Sheet
  43. Run worksheet module code from workbook module?
  44. Sort Datas by 4 columns, Day, Hr, Min, Sec
  45. Merging data
  46. testing whether a sheet is present
  47. textbox setfocus and select current contents
  48. Excel VBA AUtofilter arrow (blue) on wrong column
  49. SheetsInNewWorkbook
  50. Worksheet Change help please
  51. Autofill method of Range class failed
  52. Copying sheet and generating name of new sheet
  53. Queries from web sites that require login
  54. Moving files in Netscape
  55. NoPrompt
  56. userform?
  57. IF statement
  58. OWC need help loading and saving with javascript
  59. Another very difficult question; sorry!
  60. Object required error
  61. Recording a macro
  62. Dynamic Dropdown list During Data Entry
  63. Add In Questions
  64. automatically change the order of fields in a sheet
  65. Can you use QueryTables & iqy file to post web data?
  66. VBA to simulate the enter button?
  67. Outlook Automation Error Problem - Can't locate Outlook Module
  68. How can I use a Macro to set a Page break after a character.
  69. Can a template be copy protected?
  70. Is active content in an excel workbook (embedded object, not VBA) a security risk?
  71. Comparing 3 lists
  72. Parse Directory Filenames
  73. if else statement
  74. Using Find & FindNext in a form
  75. Trigger "Worksheet_Change" for specific column?
  76. Simple for you hard for me (newbie alert)
  77. excel to access and back
  78. Ascertaining the directory name (2 levels up)
  79. Why can't you use this VBA w. array & cell value instead of copy paste?
  80. Sub "Fill cells using file name" ()
  81. Delete broken named ranges in sheet
  82. Visual Sourcesafe and VBA
  83. Help on Macros, Excel, Visual Basic at Yahoo group Bawatchers
  84. How to add leading zero's to number to make char count = 6 ?
  85. Filesearch for hidden files
  86. work roster setup
  87. Cell with Dynamic Multiple choice pop up
  88. inserting variables in code????
  89. Combobox Value
  90. Loading JPEG to Excel
  91. Ghost Links which force Excel to update on File Open
  92. preventing endless loops
  93. File opening via Macro with varying file name
  94. Newbie problem :(
  95. Counting blanks in range using VBA Offset
  96. Does Userform exist?
  97. Sort data and move to next column
  98. how can call up solver with a button
  99. XLL and "New Form" command error
  100. pivottable: how to change source
  101. VBA keyboard action, formatt no, no info windows
  102. validating input in textbox
  103. Attribute in "hidden" header of macro: MyMacro.VB_ProcData.VB_Invoke_Func
  104. Do Loop until empty row (column "A")
  105. Is it possible to expand the formula bar in excel?
  106. Excell Database Seach By Drawing Number
  107. Slight problem - routine to add quotes to a column
  108. How to get a calculated value on a userform
  109. How to print a page of a multipage userform
  110. How do I add up row sums in a systematic manner?
  111. Pivot Table Drop Lists Out of Order
  112. Splash Screen Causing Problems
  113. Renamed EditBoxes keep reverting to their old names in UserForm
  114. Workbook::SaveAs() in MFC - Please help!
  115. Using a variable in formula
  116. keep menus in excel macros that are copied to another computer
  117. Dynamically Change Row Count Using SeriesCollection(n).Values
  118. Filling an Array with a "For Next" Statement
  119. Drag Attachment file from Outlook to OLE Object
  120. emtpy cell
  121. copy row to another open workbook
  122. how do i delete rows when cells meet certain criteria?
  123. Pivot table field settings
  124. button caption font shrinking
  125. customer database
  126. Advancing outer Loop Based on criteria of inner loop
  127. mouse pointer . . . again!
  128. NUF schedule
  129. A Macro to replace a string in a cell with a string from another cell???
  130. Problems calling macros in addin from within macros
  131. custom icon buttons
  132. custom icon buttons
  133. Select range fails
  134. Insert Row into MS Word Table
  135. return cardinal number from ordinal number function - an example
  136. Formulas not filling in without F2+enter
  137. Efficent way of setting sparse array of formulas?
  138. So Close Yet So Far!!!!!
  139. Data Import and Filter
  140. WHERE DO I START?
  141. Cell reference question
  142. If formulas when text is used
  143. check is input textboxes is numeric on userform
  144. Capture Auto-Filter Change
  145. Finding y-values in budget curve app w/ Excel & VBA
  146. Transposing Data in rows to columns (complex)
  147. How can VBA retrieve user's IP Address
  148. Setting a CheckBox Value to False
  149. Stuffing Numeric Variable Values into Footnote with formatting
  150. Values vs. Formulas
  151. How to insert Excel sheet to a DB2 database
  152. Summary Page Macro
  153. sum, not count money column in between date columns
  154. Copy Row based on Column
  155. change the number of rows to a variable
  156. User Form Error
  157. Re: change the number of rows to a variable
  158. Suppress 'Printing page' popup
  159. Collapsing Code
  160. Help on Excel-Word project
  161. Alignment
  162. Pasting to Cells from TextBox User Control
  163. FILTER PARTNUMBER Where it match all 3 Regions
  164. Pasting Blanks using a macro
  165. Declarations variables, Dim, some guidance please
  166. extract time from text import
  167. Getting row height to change to match word wrap
  168. Importing Excel worksheet in VC++ w/out ODBC driver
  169. How to use ADO to issue query that more than 250 characters?
  170. Need Help Using cards.dll with Excel VBA
  171. Worksheet Revision Date update only once in the same day
  172. Cell Validation "Ingnore Blanks" doesn't work
  173. Dynamic userform at runtime
  174. Undesired change of active workbook
  175. How to realize "enable macro" by VBA when opening a file with macr
  176. copy variable length cells to a new sheets
  177. copy range cells to a new spreadsheet
  178. Trying to count text in a filtered array using this function
  179. Curing #DIV/0!????
  180. Empty cells after assigning C# .NET strings
  181. empty cells
  182. If-then statement that checks for existence of series 2
  183. Why do Labels added to bottom of Chart Area disappear?
  184. Saving Excel in more than one location
  185. Copy Rows To desinated Sheet Please. But First Creating Them.
  186. Question on Text to Column Function
  187. Trying to count text for filtered column based on formula
  188. Calculate Summary dynamic name range
  189. Where can I save Excel templates .XLT files?
  190. VBA Code to check formulas in a range
  191. User Defined Function (UDF) Tooltip
  192. Disable CommandBar buttons while editing the cell
  193. Sort data and move to next 5 column
  194. Macro for changing path in macro
  195. Adapting some code
  196. How to keep an instance of Excel away from the user?
  197. Syntax error found in vba vlookup
  198. Application.Goto reference:="MyCell"
  199. code for hiding rows-(coloured)
  200. Excel with Outlook Express
  201. Merge and print
  202. Re: Excel with Outlook Express
  203. Problem opening a file
  204. Do you want to replace it?
  205. Using VB to get only those records that match values from a long(2000)list
  206. Code runs in 2002 but not in 97!?
  207. The application SendKeys
  208. Super piece of code..At least for me!!
  209. Disabling ALL commands on CELL Shortcut menu
  210. Print a WordArt in a Frontpage
  211. Need Help On My codes
  212. SendKeys from Numeric keyboard
  213. Apply same template to other sheet
  214. TextBox copying not like windows copying, heh?
  215. How do I execute other application(*.exe) from VBA(Excel) ?
  216. searching function
  217. preparing data for statistical analysis
  218. Pasting Personality issues
  219. Array Values and Methods
  220. The best way to specify time interval ...
  221. Adding a function to strip the address from a hyperlink
  222. Hyperlinks to other Sheets
  223. Newbie Q - outlook & Excel
  224. Looping through a column
  225. Determining Excel Version
  226. Simple looping question
  227. Simple looping question
  228. How to use Object.Copy(Destination) method PasteSpecial(xlPasteVal
  229. Error:Unable to set the visible property of the PivotItem class.
  230. Where is the best place to learn about excel programing?
  231. SQL Query - only applying to one where statement!!!!
  232. Unloading a form using the ESC key
  233. Help on VBA Page Breaks
  234. Getting rid of update links popup?
  235. using find with variant?
  236. Text box linked to excel
  237. Look up sheet name determined in cell
  238. workbook events
  239. Re: Text box linked to excel
  240. Is the active worksheet protected?
  241. Repeating Reformatting Macro
  242. Insert Blank row and paste information
  243. insert formula
  244. Excel ignoring legitimate code, AGAIN!
  245. Excel ignoring legitimate code, AGAIN!
  246. Excel ignoring legitimate code, AGAIN!
  247. Excel ignoring legitimate code, AGAIN!
  248. Excel ignoring legitimate code, AGAIN!
  249. Excel ignoring legitimate code, AGAIN!
  250. Excel bug - date and currency fields converted to text
  251. Inconsistency in how Range object is accepted?
  252. count and limit radio button selections
  253. UBound of multi-dimensional array?
  254. Different way of selecting range
  255. Autoshape Macro
  256. Replacing Formulas with Values
  257. Help with bolding and copying text to anf from sheets!
  258. Adding a new Worksheet
  259. Want add color to the cell depending on the value selected from th
  260. Excel volatil functions questions
  261. Offset
  262. Making a C++ like if statment case for excel in VBA
  263. 2 instances of excel
  264. hide excel...but not quite...
  265. Macros for Navigation
  266. Macros-How To ?
  267. Using ColumnNumber in Range syntax
  268. Automatically Updating Cell Links On A Shared Workbook
  269. Working with protected Databases Access through Excel
  270. ComboBox question
  271. Formatting
  272. Offset with variable
  273. a button to open up "My Computer" on an excel sheet
  274. open work book
  275. Showing Group Delimiter in text field
  276. Reading complete Excel using DDE code
  277. Looping through named ranges
  278. access query to excel
  279. Creating a formula with a hyperlink
  280. Referencing Embedded Worksheet in Visio?
  281. Retain cell number formatting in Word Mail Merge
  282. Problems with implementing onKey
  283. Restore a deleted Excel Workbook?
  284. vba timer
  285. Formulas withing Formulas
  286. Macros in personal.xls not all showing up in Tools|Macro List
  287. current toolbar file path?
  288. Repeating a task automaticaly on each file on a floppy drive.
  289. Loop through all files on a floppy drive
  290. UserInterfaceOnly in 2000 versus 2002
  291. ActiveChart.Axes(xlValue).Crosses = xlMinimum
  292. Logic Programming
  293. 2005 Excel User Conference - Sept 16/17 - Ft Worth, Texas
  294. Create 2nd, 3rd , 4th worksheet and so on
  295. XlDown: Go to next blank row
  296. Making functions
  297. Determining if a Solution was Found Using VB & Solver
  298. Save Variable Values even after the macro has ended
  299. Out of Memory
  300. excel and dates
  301. vba and antispyware
  302. Microsoft Visual Basic File not found (error 53)
  303. get current directory
  304. Put in respective worksheets
  305. re : Help Need on my codes
  306. Need some Help
  307. write a formula to a cell using VBA
  308. Field value from Function.
  309. VBA - ODBC database access help?
  310. Excel Macro cannot Run at Internet Explorer 6
  311. To delete the rows if certain cells contain the following
  312. VB.net/Excel/MSSQL Solution - Help!
  313. Local excel file to update website
  314. Event Macro Calculate Does Not Work
  315. Excel crashes when programming to the VBA Editor
  316. DLOOKUP AND VLOOKUP IN VBA
  317. BUTTON CAPTION CHINESE CHARACTERS
  318. Text to speech nuisance
  319. IF(VLOOKUP("MYDATA", MYNAME, 4) = 0, "TRUE", "FALSE")
  320. VBA in Excel & ADO: some problems
  321. why can i use 3 conditions in SQL statement only?
  322. MAX FUNCTION
  323. Exit Workbook
  324. Conditional Formationg Macro
  325. Reference a cell as part of a file name
  326. Help to improve macro
  327. Disable and enable auto calculation
  328. Can I unprotect / protect a shared workbook?
  329. Extract only non-matching data
  330. Hi All, need urgent help please.
  331. cell format text
  332. function malfunctioning using countif and a variable
  333. multiple worksheet and copying data from one to another for use in a formula
  334. Kind of embedded macro
  335. excel code tweak for outlook - confusing
  336. multiple criteria in one column VBA urgent need!
  337. Variable Type and Speed in Updateing Status Bar
  338. selecting a dynamic range
  339. Financial workshops on Optimisation
  340. Problem with UDF
  341. Get UDF to Re-calculate without entering cell
  342. Hilight The Currently Active Cell
  343. Control Index Numbers
  344. Selecting only unlocked cells to clear
  345. Before workbook close
  346. Delete empty rows
  347. no menu's
  348. disableing a macro after it saves workbook
  349. Api to console application
  350. Panes sequence. Pane Index 2 & 3 depend on how panes are created
  351. how to sum a column using vb
  352. Find emty cell in column and insert value
  353. Insert value in cell if another cell contains specified value
  354. Custom buton for macro in an Addin file.
  355. formula to gather non-empty cell info?
  356. help - How do you program many pivots to sink to same page field
  357. Workbook Protect/Unprotect Strategy question
  358. Vlookup more result
  359. new sheet
  360. Deleting macros with automation
  361. User control-> Out of control!
  362. extracting a single char from a string of chars
  363. Global macro hotkey
  364. sorting by sector and find largest 3 number each macro help needed
  365. setfocus on control works on some computers and not others
  366. Using Vlookup to add values to a spreadsheet
  367. Sort method from Javascript automation
  368. TimeStamp Conversion
  369. Help with Coding a Formula Please
  370. Refresh Pivot Table Crashes
  371. Using VBA to copy range of cells
  372. Activate code in cell
  373. Generating Code in Excel / Macro Recorder Manipulation
  374. Add a new Sheet in a Add-In
  375. Function arguments dialog box
  376. excel file format
  377. Pay Stub Problem help PLEASE
  378. email from cells to outlook - code not working
  379. WB before save event problem
  380. Returning array ...
  381. Save As - changes worksheet name
  382. VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox)
  383. Linking two cells
  384. Change Caption of Button
  385. combo box not showing selected item..
  386. How can I format an Excel cell with a "save" or other command?
  387. Object library feature not supported....
  388. write to external workbook from userform
  389. DoEvents??
  390. disable and enable macro execution using VBA in another workbook?
  391. Finding data in another workbook
  392. Password protected
  393. pausing vba for refresh
  394. In VBA set Slection.AutoFilter show all
  395. Read Only Workbook
  396. VBA combo box
  397. Check cell formula
  398. Unprocteting a Workbook
  399. hourglass remains after macro runs???
  400. % of Running Total to Grand Total in Pivot Table
  401. add in questions
  402. array and CTRL+SHIFT+ENTER
  403. Code Stops Prematurely
  404. PrintPreview Zoom
  405. detect cell change
  406. problems defining a global variable
  407. Save Sheet and Remove from Workbook
  408. printing multiple print areas with a print dialog box
  409. Macro Crashes
  410. Combobox_change event problem
  411. Generate a unique form number
  412. Macro won't execute from a Command Button
  413. Line in Macro doesn't work.
  414. Change Directory Help!
  415. Column letter
  416. AttachDispatch?
  417. web interface for excel
  418. Setting # of Spaces for vbTab
  419. object does not source automation events
  420. Can I Somehow load a Spread Sheet thru a Scanner
  421. Help Please
  422. Access Array by index
  423. "Sum only the colored cells" custom function
  424. macro's and data analysis add in problems
  425. VBA to show or hide columns in one worksheet conditioned on value in other worksheet
  426. adding controls to userform at runtime
  427. Confirming password
  428. Restore all formatting in one step back to a cell?
  429. Syntax help please
  430. PERSONAL.XLS won't take custom functions
  431. Deleting selected macro buttons
  432. Fixing Excel Pivot Table Crashes
  433. Searcing throught using part of string
  434. Cell Data Validation with dynamic Range
  435. Mouse Over and Back Function in Excel
  436. Sort Data and copy to next coulmn when sort data changes
  437. Coloring row
  438. active cells in range
  439. macro that uses data on diff. worksheet
  440. Formula string OK, formula not OK
  441. Two UserForm Questions
  442. multicolumn listbox - 2002 to 97
  443. And once again: X and Y Screen Coordinates of a Range
  444. how to do this?
  445. copy and paste matching by using ID's
  446. How to remove characters from a cell
  447. Conditional Hide/Print Worksheet
  448. Copy a userform to a different workbook with VBA
  449. Smart Documents - XSD and Namespace
  450. Email
  451. Choosing Only One Of Three OptionButtons
  452. Can select range of sheet
  453. VBA/SQL date variable problem
  454. Separating Words From a Text String
  455. Delete row if certain column of that row doesn't contain value
  456. which is excel web server
  457. Name sheets in VB and Selecting them.
  458. Using formuals to combine worksheets
  459. Error Handling of system codes
  460. Opening in a new book
  461. Possible for users to open file at the same time?
  462. File already in use by another user
  463. On error resume next and cdate problem
  464. Items Added to Right-Click Menu Only Visible From Some Sheets
  465. Items Added to Right-Click Menu Only Visible From Some Sheets
  466. Setting .OnAction of a command button terminates my macro.....
  467. copy rows based on cell value
  468. Returning Array ...
  469. Sort Data and copy to next coulmn when sort data changes
  470. Marcro does not work when original workbook is deleted
  471. Updating Pivot Table Column Date Data
  472. Silencing Excel popup messages
  473. Searching an array and finding sum
  474. Getting values from anotjer workbook
  475. How do you extract the VB name for a sheet in another file?
  476. Disable Save Workbook popup
  477. setfocus sometimes gets error 2110
  478. How to generate ms word doc files from excel sheet.
  479. Capturing Data from a Com Port or Printer Port
  480. Pivot Table Macro Help
  481. Help finding data from userform
  482. Update Spreadsheet off hours
  483. Color Pallette
  484. selecting coloums problem???
  485. How do I change the paper tray from an Excel macro / vba module?
  486. match text and add up from rows and columns
  487. Excel automation from C++ and big numbers
  488. Contitional copying of cells from one tab to another
  489. Use a macro to create a new list using another worksheet
  490. Help with the following code
  491. Trying to repeat a procedure
  492. Copy format of a referenced cell
  493. a question regarding cell format
  494. question on formulas
  495. simplify SUMIF stmts
  496. Grabbing data from diff window w/o activating it
  497. Customized components
  498. cells property
  499. grabbing data from MS Word
  500. link_location from contents of cells
  501. macro pauses
  502. Help needed with VBA cut & paste & copy
  503. Protecting VBA Macros
  504. To named Sheets
  505. copying files
  506. opening file
  507. How-Import 41 CSV files into 41 sheets?
  508. Clearing text in TextBoxes
  509. comparing text in if statement
  510. Scrolling an Excel worksheet embedded in a Visio diagram with VBA
  511. zoom
  512. Maintaining cell 'variable' values even after the the macro has en
  513. Locating end of coloumn to add more data
  514. Looping through a range of cells
  515. Adding .xla button for Toggle Calculation Button
  516. Typecasting Range from excel to work
  517. Typecasting Range from excel to work
  518. Calculating Time
  519. VBA for selecting continuous cells from relative starting point?
  520. How can i bring data from one sheet to another:
  521. Using function keys in macros
  522. URGENT, Stuck Smart Indenter
  523. Size of array
  524. Color Codes: Localizing a number format string
  525. Testing for Hyperlink
  526. emailing problem
  527. Copying a Userform within the same project
  528. Hide Empty Rows When Printing
  529. Excel Embeded In Ie
  530. Combine 2 macros into 1 Please.
  531. timing a sub procedure
  532. relative cell address
  533. sharing a workbook hosted in a server
  534. Wrong date-formating while using data fields?
  535. Short Description in my Excel VBA Function Dialog Box
  536. Help - Deleting Rows on Text Criteria
  537. rounding formula
  538. Runtime Error 380 – Could not set the list property. Invalid property value
  539. Toggle Calc button - working, but want it showing "depressed"
  540. how do I set up a cell to choose a number from a pop-up calculato
  541. Use of LOOKUP in VBA
  542. How to disable Macros in VBA code
  543. Excel Ref to a cell, relative to a 'label'
  544. Running Userform Procedure
  545. Re: Help required in the Macro for extracting the track changes and comments
  546. How do i use VBA script to control macro security level
  547. Pls. reply Sort Data and copy to next coulmn when sort order chang
  548. Status Bar Reset
  549. Re: Make selected row visible to user when out of screen view
  550. Re: checking input on a textbox in userform to be a %
  551. Re: Lookup up active cell value in passed range
  552. Re: Lookup up active cell value in passed range
  553. Toggle Calc Button - how to make it work OK at startup
  554. Re: Need an easy way to remove all commandbars
  555. find blank row
  556. Help with mscal.ocx XL2002 vs XL2003
  557. Validation rules
  558. Re: Using Offset on Variable Dinensioneds Object
  559. Re: How to create a formula in VBA to assign to a cell
  560. Re: Creating custom face ID's
  561. Re: Lookup an email address in Outlook based on Username (newbie q
  562. Re: Trouble with Sheet Deactivate macro
  563. Sorting sheet problem
  564. VBA buttons shift around when using Print/Print Preview
  565. how forrmating
  566. Selecting Sheets
  567. Re: Extracting items from Autofilter drop down
  568. defined name ranges
  569. Text parsing in Excel VBA
  570. Re: Working with Access Dabatabases through VBA Codes in Excel
  571. Need help with cell parsing in Excel VBA
  572. Re: Code won't execute...
  573. Writing Excel to Access
  574. Creating an array of sheets to print
  575. Re: xlCellTypeBlank Problem
  576. I need a liitle help please
  577. Loop thru some worksheets
  578. Re: Passing more than 255 characters
  579. Re: count only the visible rows in a data table
  580. Re: Range names
  581. Re: Multiple large .NewSeries lead to Run-time error 1004
  582. Having a macro recognize when an option button has been selected
  583. Problem with Range.Cells.Offset and Range.Cells( row + offset, column)
  584. Re: load/unload userform
  585. Re: subtracting AD and BC dates
  586. Re: User Upgrade Procedures
  587. Re: Addressing a UserForm sub in a VB dll
  588. Search Facility
  589. Re: Run a macro when updating a cell
  590. Re: i need a quick answer.
  591. Re: Application
  592. Need to force unshare of workbook
  593. Re: Excell automation - How to move sheet using late binding and VB.NET
  594. Re: Select variably-sized range which contains empty cells
  595. Re: Select variably-sized range which contains empty cells
  596. GREP in VBA
  597. Re: Listbox Problem
  598. Re: paste
  599. Can't pass publically defined variable to a function
  600. Re: Can't Get Match Function to Use on Array
  601. Re: Error with a For loop with arrays
  602. Re: Web Query
  603. rounding to the nearest half ( .5)
  604. RE: Combo boxes
  605. Object Required Error
  606. Re: Flow chart of code? Is there a way to produce a graphical flow chart?
  607. Declaration problem
  608. Re: Record Merge Macro
  609. Re: Reference cell address of Hyperlink
  610. Re: Record Merge Macro
  611. RE: How can I use VBA ADO to check if a table exists in an Access DB?
  612. Re: Checking whether a field is bold.
  613. Re: What is the Status Bar used for
  614. Re: refering to worksheet cell under shaoe object
  615. Re: want AutoFilter to default "on" for all columns
  616. Re: Passing Values
  617. Re: Drive, Dir and File list boxes?
  618. Call GoalSeek from a user-defined-function
  619. Re: Magnificent Problem
  620. Re: Writing to An Array or Collection
  621. CountIF
  622. Re: HELP! Problem with combinations
  623. Re: Page breaks
  624. Re: get reference to cell from mousedown event
  625. Re: Count conditional formatting
  626. Data Validation Formula and Offset
  627. Re: Using Named Ranges to Lookup Data in External Workbook
  628. RE: Delete all visible sheets in workbook...
  629. Re: Delete all visible sheets in workbook...
  630. Return file from a path string
  631. Re: File truncation with VBA
  632. RE: error 400...
  633. Procedure similar to VLookup - need help!
  634. Re: $
  635. Re: Copy Formula with a Macro
  636. Re: Workbook Loop Headache
  637. RE: Saving to a netword folder without mapping drive
  638. Pull info from access to template in excel?????
  639. RE: Assignment to Constant Not Permited
  640. Re: Form 2 Form data transfer
  641. Reloading values in optionbuttons or checkboxes
  642. Re: How active the tab's color menu ?
  643. Re: validation all cells different format
  644. Goalseek "may not have found a solution"
  645. Excel Forms
  646. Re: Opening excel spreadsheets via excel.application object w/o prompts
  647. Re: Another invalid or unqualified reference
  648. Self Cert Signature now has problem?
  649. RE: Opening excel spreadsheets via excel.application object w/o prompt
  650. RE: Combo boxes
  651. Re: Pull a list from a box
  652. Re: Help with dropdown menus
  653. Security Certificate Question
  654. RE: help with cell compare in two worksheets
  655. Re: Problem running macros in Excel filenames containing specialcharacters like []
  656. Email from Excel useing FollowHyperLink
  657. Re: Application.enable
  658. Deleting Rows using a range in Column A
  659. Re: Stoping the Link
  660. Select all cell with the same format
  661. Searching for a specific cell using a variable.
  662. Re: Help needed with Macro
  663. RE: Help needed with Macro
  664. Re: International Language Functions
  665. Pivot table to launch Macro
  666. RE: Please Help!
  667. Re: Run-time error '1004' on Range.Activate
  668. VLOOKUP with LARGE
  669. Re: Failed userform loading and cause application crash
  670. Brake in a loop
  671. Assign macro to right click menu ?
  672. Iwould like to change Excel 97 to Excel 2000 for Windows ME?
  673. Re: Evaluating an expression...
  674. Re: Is there a Dialog box constant for the format cells DG?
  675. Programming header/footer strings with line feed
  676. Re: Need help for sure
  677. Help, Copy Cell, using VB
  678. Re: copying values in range
  679. Re: CommonDialog control issue
  680. change colour of disabled textbox text
  681. red row
  682. Re: Error 2147352567 (80020009) Could not proxy for user
  683. Re: difficulty with conversion program
  684. Creating Macros to work with ranges of varying sizes
  685. Re: Search range add value
  686. Using the Find method with formulas
  687. Re: Error 1004 when programming DataLabels.Position
  688. How do I write an Excel Macro to run Solver repeatedly?
  689. Re: Select Method from Combo Box
  690. Re: show filter criteria
  691. Re: TextBox Macro - Is there an easier way ?
  692. How to create excel add-ins
  693. Re: Duplicate remover
  694. Re: Calling macro on cell change
  695. Re: value of any cell in row 1 = 8 then colour the whole row
  696. Re: copy events... help...
  697. Unicode Help
  698. VBA ComboBox Highlighting
  699. How do I sum multiple columns counting including blanks and dates
  700. Re: Ok I have to be difficult
  701. Multiple fonts in one cell
  702. Problem getting solver to work in macro
  703. How to Edit Cell Text
  704. If Statement with multiple qualifiers
  705. Re: Determining A Cell If it contain A string value
  706. Re: Determining A Cell If it contain A string value
  707. Re: Determining A Cell If it contain A string value
  708. Re: Is there are 'sendkey' statement to activate the spacebar?
  709. Re: Opening a list of workbooks
  710. Re: Printing Anomaly
  711. Re: xla programming
  712. vba problem dialogue box and cell in sheet
  713. I need a macro that will reset cells to zero
  714. Re: Function program
  715. Run or Call
  716. RE: Date Format
  717. Re: Last user to make a change
  718. Re: separate each sort order ?
  719. Adding buttons while looping through files Question
  720. Re: Userforms
  721. Re: run time error '5'
  722. RE: Combobox to range
  723. Re: Fast way to clear Listbox selection
  724. Re: VBA Find Issue
  725. Re: Help with Transposing Macro
  726. Complex focus problem
  727. Re: Differebnce betwen VB and VB,.net
  728. Re: sort button,macro, or ?
  729. currency rates
  730. Re: Returning to last cell in a do until loop
  731. Re: copy data if data exists
  732. Re: User defined function to count pay days in current month.
  733. how to use percentages
  734. Offset
  735. Run Macro on close
  736. Re: Navigate Sheets - better way.
  737. Re: Hide one sheet tab
  738. RE: Hide one sheet tab
  739. Re: Find Text within Text String
  740. Re: Write Data from Sheet1 to sheet2 Until
  741. Save file queries
  742. RE: Find Text within Text String
  743. Re: Find Text within Text String
  744. Hyperlink probelm
  745. End Of Records
  746. Re: This weeks Monday
  747. Formatting Data Columns of various length with Macros
  748. re : Finding the datas and deleting datas which are not found.
  749. insert the name of sheets inti a column A
  750. Re: Find criteria and return name with VB
224