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. PAStE SPECIAL
  2. link to other worksheets
  3. Question
  4. Detecting text fits into column
  5. Unable to figure out VBA Code needed
  6. CUSTOM PRINTING !
  7. HOW TO DISABLE CUT N PASTE OR HIGHLIGHT N DRAG IN VB
  8. getting msg box for no match!
  9. Unlock protected VBA
  10. More than one cell answers??????
  11. Solver with limit
  12. Using Code Editor Slows execution speed
  13. Help with vlookup with certain cell change
  14. Populating a cell with concatenated text...
  15. Selection Grid
  16. #DIV/0! Error
  17. remove outliers in a time series
  18. dynamic range and series
  19. Saving Macro - need help
  20. I don't want to repeat the same number
  21. Error in loading DLL
  22. Paste Column Width Language
  23. compare and compile nonblank data from seperate workbooks in an automated user form
  24. Place Thin Border around Cell
  25. Find duplicate range or cell ref (as precedents) in a cell's formula - an example
  26. procedural help lease
  27. How do I make a word in Excel flash?
  28. Worksheet Listbox Populate Problem
  29. How do I use looping and offsets thru 2 tables to generate a cash flow per week
  30. vba to delete rows
  31. SaveAs Dialog comes up twice???
  32. UserForm fill by Range
  33. If then VB statement
  34. Selecting a range of cells , how to ?
  35. Selecting a range of cells, how to ?
  36. Hide Row Per Value in Two Columns
  37. Run Two Macros from Same Button
  38. IF cell equals then help
  39. How to extract file name for use in a cell?
  40. SplashScreen
  41. Copy Range including Formats and Forumulas
  42. Pose questions to Microsoft when an answer is not forthcoming in g
  43. VBA code to import stacked text files
  44. iterate through chart series collection
  45. Pictures based on conditional and used more than one time
  46. Marking a range True or False based on a single Checkbox
  47. Worksheet to be saved in current directory
  48. C++ Access to Windowclass Excel<
  49. Opening a file and disabling open events
  50. Move cursor down one cell
  51. Show/hide details in pivot chart
  52. Time sheet totalization
  53. Determine delimiter in csv or txt file
  54. VBA Code...
  55. Closing Form and prevention
  56. MATCH NUMBER From another wooksheet Macro
  57. Macro to hide blank rows
  58. Assigning Formula to a Range
  59. Changing cell text color based on cell number
  60. spell check ranges in a do loop
  61. Setting CenterFooter on Multiple Worksheets
  62. Deleting Rows that Match/Contain Search Criteria
  63. calling a shared lib from VBA in Excel
  64. Excel vba loop?
  65. Multiple graphs
  66. Avoid "MK_E_UNAVAILABLE" with a COM in Excel
  67. Need an Excel Add-In.........
  68. validation
  69. Selecting 10 charcters on one cell and pasting to another cell
  70. using UsedRange.SpecialCells(xlCellTypeVisible).Areas(2)
  71. VBE Code
  72. CalculatedItem suppress running total
  73. deleting automatic links
  74. Source Code Control
  75. Pivot table - Hide the Data Sheet
  76. Make directory structure variable
  77. worksheet_change colour of a row on change of cell
  78. RE: worksheet_change colour of a row on change of cell
  79. Debugging suddenly stops...
  80. Debugging suddenly stops...
  81. collating/consolidating large amount of data in excel
  82. Aliases Cell formulas Convert to VBA
  83. Identifying rows selected by filter
  84. Script to Pull info from website into Excel
  85. Data of Sheet1 should gets autometically posted in Sheet2
  86. Rew Macro For Computation
  87. totalling dates
  88. Reducing Size of the file
  89. How to be notified when user changes cell value in selected column?
  90. how do i calculate a running payoff amount?
  91. Getting system OS language and then.....
  92. Close Button Removal
  93. Saving Forms
  94. Setting chart Xvalue errors
  95. How do I create a formula that will enter the most recent data?
  96. SUMPRODUCT #value! error
  97. How do I disable the right-click shortcut menu on charts
  98. Excel Not Entering Data
  99. Comparing Large Data Sets in Excel
  100. How to pen the Find dialog box with a macro
  101. How to validate that input was entered into Input Box
  102. Round off error
  103. Col alignment problem
  104. Go straight to next value in a For... Next loop
  105. Try Before You Buy Install
  106. Find specific column and copy row.
  107. turn off pivotfield sort
  108. Adding totals to columns where number of rows varies
  109. Do Multiple Regression with VBA Code
  110. Travelling cell values with filter in Excel macro.
  111. 'On Error' within 'For' loop
  112. Excel SaveAs not using specified FileFormat
  113. Pivot Table Calculations
  114. Have User select a column
  115. Calculating revenue over fiscal quarters
  116. multiple pivot tables from 1 pivot cache
  117. Randomly sorting a group of 5 values multiple times
  118. Check Mark appears when a letter is entered in a field
  119. continuing: Incorporating error handling to Bob's code
  120. Excel VBA as a programming language
  121. DisplayAlerts not working
  122. right click menu
  123. How do I get input from an edit box to a worksheet?
  124. Similar SaveAs
  125. Spash screen on a Mac?
  126. VB code in excel.
  127. Error using Application.WorksheetFunction
  128. Excel automation: are there some timing constraints?
  129. Block sheet entirely....
  130. Firstname Lastname Field, Split two cells
  131. Anouther loop question
  132. Creating Report
  133. Using the values in range of cells in an SQL query
  134. code for counting/shifting
  135. New Group in Menu
  136. help with loop to delete rows
  137. SaveAs Macro - Build filename from cell contents HOW?
  138. Automatic Sheet updating
  139. Recording macro to save file with name change
  140. multiple choices from pulldown... how to apply to several pulldown
  141. Search wildcard to limit only alpha characters
  142. VBA programming expert required
  143. Which Fires First?
  144. Layout troubles with VBA-generated OrgChart in Excel
  145. averaging arrays
  146. Saving takes soooo long
  147. Workbook_onChange that shows/hides rows crashes after printing?
  148. Do until loop
  149. different results when debugging
  150. pivot chart exclude rows
  151. setSourcedata
  152. exclude cells from calculation if custom format
  153. populate oracle database
  154. Setting Combo Box to display a blank
  155. Cut a range between 2 cells containing found data
  156. Clearing the keyboard buffer after sendkeys
  157. User Form
  158. Barcode reader - to store data in Excel
  159. DDEPoke only pushes the text contents from excel to word
  160. exit macro after test of cell value
  161. Merging selected fields from 4 worksheets to a Master Worksheet
  162. detecting formula containing a constant
  163. Column Chart with two axes
  164. copy several sheets from a workbook to a single sheet in a new wor
  165. can excel show due dates automatically?
  166. Reversing a filter using a checkbox
  167. Computer Name with VBA
  168. change event; return focus to original textbox
  169. Macro Required for Lookup Function
  170. Can you Click the "Enter" key to go to the next line in a Textbox without Exiting the Textbox ?
  171. How do I stop chart dialogs from appearing
  172. Copy variable sized range to single column...
  173. Transferring data in Excel
  174. I still have trouble with Date Formats. Why is it so ?
  175. Array copying to a filtered region
  176. Name checking
  177. Why does this code remove Duplicate Values, by showing only 1, but it does NOT show Unique values for some reason ?
  178. Refrence a workbook procedure from another workbook
  179. use vlook up function
  180. Opening some workbooks with a Macro renames them
  181. need to determine what named range a cell is in
  182. removing legend entries
  183. VBA Find & Replace Intelligently
  184. Cut/Paste - More problems
  185. Copy TextBox Text
  186. Unselect? Deselect?
  187. VLOOKUP and stopping at the last record
  188. averaging
  189. Select another Textbox After Selection
  190. Naming and saving a workbook
  191. Copy worksheets to new worksheet and add a worksheet name column to new sheet.
  192. Worksheet.Match the best way to go?
  193. Macro to move a cell to centre screen
  194. Macro and range names
  195. Templates in Add-in
  196. Help changing one line on a macro
  197. Create Phone List From HR Worksheet
  198. Excel VBA Program Won't Run After Auto-Save
  199. Userform Values into Excel sheet
  200. VBA - saving strings to a text file
  201. Taking data from multiple workbooks?
  202. pivot chart format recording & applying
  203. Insert UserForm Values into Excel sheet
  204. Userform Values into Excel sheet
  205. Wild Card for partial matches.
  206. cannot record macro
  207. Fixed Width
  208. Looping through buttons on a worksheet.
  209. Code to find and replace words inside of a text box
  210. Comma
  211. Counting Colours
  212. list separator
  213. Autofit for entire sheet?
  214. Check number of rows?
  215. password recovery
  216. How to discovery the color...
  217. Conditional Copy/Paste
  218. macro to subtract across columns
  219. Multiple Lists from Unique Data
  220. Excel Object in Word Document
  221. can't create excel add-in macro to use with other workbooks
  222. Macro stops part way through !
  223. Load Dll
  224. Code Works for Some Worksheets, But Not Others
  225. Macro works on one computer but not another
  226. Adding a button with Add-in
  227. ActiveWorkbook.Names.Add -- Problem
  228. Theoretical question: graph & trendlines in Excel
  229. Actualisation problem :(
  230. Customized toolbar button trigger macro in a different file
  231. Create dummy file structure?
  232. Date Format in a Userform Listbox
  233. File size keeps fluctuating wildly!
  234. send excel workbook as attachment to multiple users
  235. RE: Date Format in a Userform Listbox
  236. How to Change Worksheet Properties
  237. Need Help: Determine Equipment Capacity
  238. RE: Date Format in a Userform Listbox
  239. Programmatically Select Tab on Ribbon?
  240. Adding worksheets
  241. Object Error when VBa-ing Chart
  242. GetOpenFilename - with a difference
  243. Date format is not picked up correctly while filtering
  244. Gather data from multiple XML sheets?
  245. Searching for words used in VBA code
  246. My code fails
  247. Unique Listbox Scripting Dictionary
  248. Print area composed by more range
  249. Closing Files Opened Using the FileToOpen
  250. Adding a Value List to Combo Box
  251. Filtering Results in Excel & VBA
  252. Microsoft Internet Tools not accessable
  253. Conversion of WP12 file to Excel
  254. Conversion of WP12 file to Excel
  255. Printer Paper Source Setup
  256. Search Range for string, then copy that cell to another worksheet
  257. Runtime 1004
  258. macro with multiple csv
  259. Referencing a workbook in the same directory
  260. Linking to separate worksheet with 2 criteria
  261. not sure where to start
  262. Return Array from Function
  263. random assignments of workload to set # of people
  264. programatically creating worksheets
  265. if...color
  266. Duplicate chart on new sheets
  267. Let's try again: VBA Code stops randomly
  268. How do I set Up a random sports scheduler
  269. Scaling Graphs
  270. Userform direction
  271. Have a Big Question
  272. How can I link (not embed) to a graphic on the internet in Excel?
  273. renaming a query
  274. Digital certificate blocked
  275. Excel Camera Object
  276. Excel forms enters .exd in registry
  277. Determine Cells(5,4) IN SPITE of hidden rows/columns
  278. Question for Jim Thomlinson
  279. code to attach files
  280. Text Box Value
  281. Sum cells based on two criteria
  282. Trouble Creating Formula in a Macro
  283. Macro's checking for errors
  284. macro question
  285. Parsing after multiple selection in drop-down?
  286. more than 2 option buttons on a form
  287. RE: Merge/Join 2 Excel tables
  288. Selecting a Range with a Variable in VB
  289. Can I start the text import wizard automatically?
  290. Using cell row # in a VB macro
  291. Non unique records only
  292. Creating Macro/Formula
  293. Auto Calculate Question
  294. SaveAs AutoRecover error?
  295. VLOOKUP equation in VBA
  296. Re-Post: Sorting Listbox Source
  297. Copying Column in R1C convention
  298. insert copied cells to a different workbook
  299. convert string to integer
  300. How to hide a column in combobox?
  301. Method to get dates based on Month
  302. deleting "0" rows
  303. MsgBox repeated two times (Excel COM Add-in)
  304. Open Office Compatibility with Microsoft office
  305. Copy row formatting down
  306. Add break in macro
  307. Count only Mon-Thurs?
  308. program for dialog box
  309. Automatically use or update links between two sheets using VBA?
  310. Overcome "expected end of statement error"
  311. Opening Excel-files in several directories
  312. Macro for Inserting Rows
  313. ADO compatibility between Excel XP and 2003
  314. Execution comments
  315. Sheet Show
  316. Export Excel in Power Point
  317. Debugging Loop script
  318. Worksheet Open Event Q
  319. How to open Word from Excel with VBA (Office 2003)
  320. scanner twain
  321. Help with Macro that searches a Range for specified information
  322. insert a macro into a workbook using vba
  323. Is there a way to kill all files in a folder?
  324. Run macro when file is opened and closed
  325. date format change when opening file with vb
  326. Opening files by VBA
  327. Any api to Insert objects in Excel
  328. Import Outlook Journal Items into Excel
  329. add the addin in the Tools menu of Excel
  330. Formula doest work in Excel
  331. I get Subscript out of Range second time, not the first time
  332. Excel Colum and Rows Problem
  333. How find maximum top+height property of a collection of shapes
  334. Spin Button's What can they do?
  335. Re: Is there something wrong with my code?
  336. ListBox Selection to fire Macro
  337. Looking for DMEDIAN
  338. How To Quit Subroutine from a called subroutine
  339. Pasted values keep changing to time number format
  340. Maintaining Information in a Cell
  341. Saving a workbook to a specific directory
  342. clearing cells and checkboxes **ROOKIE HERE**
  343. Find Record in Access Using Excel
  344. Update current record in Access using Excel
  345. Is it possible? Does ANYone have ANY ideas?
  346. XML Web Imports
  347. How to Improve my "Vlookup" on Steroids function.....
  348. Freeze Panes C#
  349. Simple Find/Replace Question
  350. Can I count total lines of VBA Code Executed in a Series of Subs?
  351. Textbox in user form
  352. Formulas for multiple functions
  353. Calculation of Interest / How to find Monthly Payment w/ Offset First Payment More options
  354. Insert a formula into a cell
  355. Sorting ListBox Source
  356. Increase font size within my formula bar
  357. Copy from multiple workbooks, rename, and overwrite if exists
  358. Difference between Worksheets. and Sheets. is...?
  359. Tcl's Tcom meets Office 2003 - giving pre-.NET Visual Basic for Applications a small taste of introspection the long way round...
  360. subscript out of range
  361. Factorial Function
  362. File Save Macro as Cell content
  363. Measurements in VBA/Excel
  364. Connecting to Access Database from Excel
  365. Copying Formulas
  366. Incorporating error handling to Bob's code
  367. Strange listbox behavior in version 2003 after version 2007
  368. Access Table import
  369. Hyperlinks in Excel 97
  370. Hyperlinks in Excel 97
  371. Microsoft Office Document Imaging
  372. Excel 2007 Problem
  373. VBA Code and Checkboxes
  374. XL2003: Is it possible to sink a form's events in a class module ?
  375. Capturing conditional Interior Color of cell
  376. Copying Color Index + conditional Formats + validation
  377. Tickmark Macro
  378. wher to put the code
  379. Minimum value needs to be greater than zero
  380. Minimum value needs to be greater than zero
  381. Minimum value needs to be greater than zero
  382. Opening a link with Excels
  383. Help with Number To Words Code for Indian Currency
  384. Collecting data from other worksheets...
  385. how do I set up a scoring system in excel
  386. AutoFit Row Height
  387. VB for A conditional formatting exercise
  388. code won't run
  389. how do i use find in VB
  390. uk date comparisons
  391. Converting to late binding (for compatibility)
  392. Comparing text?
  393. Response times calculated in business hours
  394. VBA Formulae...
  395. How do I retrieve entire Revision Number on Excel 2007?
  396. Information Required on Insertion of series
  397. Change Settings in Find Dialog Box
  398. How to Set a Reference to a Copied Worksheet?
  399. Can you Sort Listbox Values Alphabetically by code?
  400. Will pay for need help and occasional advise on using excel ....
  401. Not ALL values are populating to Combobox for some reason. Why ?
  402. Is there something wrong with my code?
  403. solver ranges
  404. Auto-filter. Cursor on first row in new list
  405. Still stuck removing duplicate values
  406. Macro for Editing Data
  407. Discontinuous range of X Values
  408. Export from Excel to text file with a twist
  409. Counting records
  410. counting records
  411. Userform Initialize & Command Button, Excel 2000 & 2003
  412. Run time '429' : ActveX component can't create object
  413. Cancel Button in User Form does not rever to original state
  414. Excel VBA Expand/Collapse with Subtotals
  415. Project- planning tempate? Where to find, how to start.
  416. IIF Function
  417. More than 3 Conditional Formats with VBA - Not Working
  418. copy template to master spreadsheet
  419. Summing
  420. updates in wrong workbook
  421. Re: Vista bug (?) regarding Excel 2007
  422. Adding cell locations to a word form
  423. -PLS CONSIDER THIS AS URGENT! HOW TO PUT SUM FORMULA IN VB FOR A CHANGING MULTI CATEGORY OR GROUP
  424. Cell data change formatting
  425. worksheet function with two ranges
  426. Can I use the result of an array calculation inside a regular formula?
  427. find an exact number in a different sheet and use the cell containing the number to output information
  428. Excel alarms
  429. Increasing the value of a cell by one per worksheet?
  430. Application-Defined or object defined error 1004 When ran on exel97 but not 2003
  431. Compile error macro is 111K. how do I fix macro
  432. HOW TO SEE/EXTRACT LOWEST PRICE OF MULTIPLE PARTS IN ONE PAGE
  433. Need help with Excel VB
  434. Need VBA code for a custom function?
  435. log trendline formula
  436. Can anyone help?
  437. "Variable not defined" error for form that does not initially exist...
  438. Simple question - help please and thank you.
  439. Indexing or Ignore Blank rows
  440. Rule to recall collection lower bound index ?
  441. Add or Less data automatically.
  442. HOW CAN I HAVE THE SHEET TO BE PROTECTED, FORMULAS HIDDEN AND YET GIVE AN OPTION IN VB TO HAVE A TOGGLE TO PROTECT/ UNPROTECT/HIDE/UNHIDE CELLS
  443. HAVE ONE REPORT SHEET WITH LINKS FROM VARIOUS SHEETS. ON COPYING THIS LINKED SHEET FOR EXPORTING IT TO THE OFFICE GET ERRORS IN CELLS. HOW TO RESOLVE THIS?
  444. Runtime Error '-2147417848 (80010108)'
  445. Workbook_SheetSelectionChange in going infinite
  446. Need formulas for finding text strings
  447. Excel services problem
  448. looking for logic guidance
  449. Excel Dashboard - How was this done ?
  450. Multiple Columns in Columns Property?
  451. Function condition statement
  452. Flowing Row Display When Query from Access
  453. Re: 2007 EC Excel / Access User Conference
  454. Specify location of X Values
  455. ListObject -> XML question
  456. Consuming Web Services From Excel 2007
  457. How to run an Excel 2007 macro from a VB program ?
  458. Help! Macro needs tuning...
  459. clear option buttons **MACRO TWEAK**
  460. blank worksheet menu bar on top
  461. Time Date Stamp when range changes
  462. Setting alignment in excel via vb .net
  463. Interior color
  464. Using Excel templates with GetObject/CreateObject
  465. how to do a "check for updates" over the internet
  466. Selecting a workbook to copy data from
  467. copy Excel charts to PowerPoint and Word
  468. Select Shape in activerow
  469. Insert copied row at cursor position
  470. Drag & Drop file onto Userform control possible?
  471. Search a Range take Action
  472. text file from url referring site
  473. Help! Macro to send email from Excel and add other attachments
  474. Is Date Odd or Even?
  475. Excel 2007. How to Get Microsoft's Attention
  476. Thank you.
  477. CUSTOM COMMAND BAR DOES NOT SHOW SOMETIMES-- WHAT COULD BE THE REASON
  478. Variant
  479. how to format rows by groups
  480. lastrow function
  481. edit chart datapoint tooltip
  482. Library issues
  483. Outer join with 3 tables using MS Query
  484. Outer join with 3 tables using MS Query
  485. Hidden Columns
  486. ASSIGNING THE VALUE TO A NAMED RANGE GIVING OBJECT DEFINED ERROR
  487. Alternative way to refer to a row to hide or unhide...
  488. Access custom chart autoformats
  489. Send excel contents to POP3 mail server such as Yahoo
  490. problem:Structure with Object reference (TYPE...END TYPE)
  491. Index function with quotes and '&' sign in reference section
  492. How to make the dot in different size depend on the data in a scatter chart?
  493. VBA Training
  494. Is it possible run code when a cell is doubleclicked?
  495. Creating a Loop that looks for the word "Total"
  496. adding alternate columns
  497. New Email Details to Excel...
  498. generate a list from a single row of data
  499. Comparing Cell values in two sheets within the same workbook
  500. file notifcation table
  501. Clearing RAM
  502. Force external application to remain 'above' excel sheet
  503. copy from one workbook to another
  504. Correct code
  505. ??? Public Sub code jump to Private Sub Code
  506. Importing an image in VBA
  507. How do you delete all buttons in a worksheet, but not all shapes
  508. Copy and Paste Charts as Picture in Different Workbook
  509. Macro Help
  510. Assigning an array to range object?
  511. excel data link refresh
  512. Sheet became suggish. Why?
  513. Remove Duplicate Values
  514. Importing from a text file
  515. Excel Services external data sources - Kerberos or SSO required??
  516. Value NOT adding 1 ??
  517. Calculations using the last available figure in a column
  518. Copying Excel tables into Word
  519. Beginners Question
  520. How Do I Copy Only Select Data?
  521. Some problems with shared workbooks
  522. Recurring Problem in Excel 2007
  523. Hyperlink Construction and Execution
  524. Macro: Select visible cells only
  525. PasteSpecial Method of Range Class Failed Error a Different Versio
  526. Creating mulitple workbooks from single workbook - *Macro tweaking needed*
  527. Modify Print Macro,,, is it possible.
  528. MS Query refresh changes column order - Help! (Pretty please?)
  529. add info to excel feilds
  530. Calling a Macro within a Macro
  531. Copying rows with radio buttons and drop downs
  532. Compare cell values on different worksheets
  533. HIDING A VARIABLE NUMBER OF COLUMNS
  534. Cell Blank if duplicate value in previous cell
  535. Binding data from database to excel drop down
  536. Data Validation Using Radio Buttons
  537. Move from one cell to another
  538. Macro does not populate later rows
  539. Running code when a worksheet opens
  540. Deleting unwanted files
  541. Buffer overflow in FileSearch?
  542. Converting 0 to a Dash without using Currency
  543. Creating Reports in Excel
  544. ODBC Run-Time Error Handling Help
  545. Is color indexing dependent upon the display
  546. How to automate a cumulative total for multiple entries?
  547. How I auto send e-mail from excel with predefined subject and tex
  548. Stop Event
  549. IF statement
  550. Disable Password Dialog Close Workbook
  551. killform - VBA not Macro!
  552. Macro to replace file name in linking formula
  553. What command after then statement?
  554. How do I set initial Excel workbook name?
  555. Create List from Multiple Worksheets
  556. Request advice on Split(sFile, "\")
  557. subtracting serial dates
  558. How do I append the same text to multiple cells?
  559. replace character in txt file before import to excel
  560. Column index returned - how to get the Letter
  561. Licensing for Excel ActiveX
  562. Toggle Calculation Status
  563. help with code
  564. Excel 2007 bug?
  565. Paste to active Cell
  566. Paste to active Cell
  567. Help with IF Else:IF statement
  568. Renaming data fields used in Row Area
  569. copy rows and paste in another workbook
  570. For each objcht in ...
  571. RE: Help with IF Else:IF statement
  572. RE: For each objcht in ...
  573. Protecting VB
  574. For Each advance conflict
  575. Suggestions...
  576. Cell and Sheet references
  577. Extracting Words from Cells
  578. Need to flag numbers over a certain value
  579. Reflections, getting info from Excel
  580. Can't run macro as normal user
  581. RE: Need to flag numbers over a certain value
  582. time format
  583. select rows and delete based on criteria
  584. personal2.xls appears and now all my triggers point to it
  585. RE: Can't run macro as normal user
  586. General Names and Links question
  587. RE: Can't run macro as normal user
  588. Hyperlink History
  589. Save as new file without changing existing file
  590. How to create/embed table or existing Excel spreadsheet into Lotus Notes 6.5 email
  591. Commandbar
  592. populate conditional formating on a spreadsheet via VBA
  593. Open DBF files in XL2007
  594. VBA Variables....
  595. Handling library references when distributing worksheets
  596. VBA Range Variables...
  597. variable or propertie 'name' for self written sub or function
  598. Udfs and eventhandler for excel in managed code
  599. Worksheet Focus gets changed while changing the cell value
  600. Worksheet Focus gets changed while changing the cell value
  601. Worksheet Focus gets changed while changing the cell value
  602. Vlookup question
  603. convert culomn letter from number
  604. Print visible sheets - ordering
  605. COPYnPASTE from one workbook to multiple workbooks in the same fol
  606. Functions 101 The basics
  607. function for ranking ?
  608. Get value form a cell in a loop
  609. Can I... (trying to be clever with pivot tables)
  610. Using the Return Key without exiting Textbox
  611. Sum
  612. Value NOT being input
  613. Date Change macro
  614. viewing
  615. Copy workbook without Macros
  616. variables in formulas
  617. Excel 2007 Design Mode
  618. conditional format: looking for formated
  619. VBA errors when doing "File -- Save As"
  620. Excel - Read-Only
  621. Making a planning sheet
  622. Values don't behave when converting text to values in userform
  623. VBA help: Using user's selection to copy entire row
  624. Renaming Folders
  625. If command with 3 options
  626. Can result of formula not display if =0
  627. Reading each cell in a selected row.
  628. Hiding a macro button
  629. save worksheet with chinese characters as text
  630. Opening a shortcut in a macro.
  631. Linear Interpolation in excel
  632. Help with Debra Dalgleish's Code
  633. Copy/Paste within AutoFilter
  634. password protected
  635. XLDialogPrint - PrintWhat- Selection Option
  636. Need help with VB Excel statement
  637. Delete duplicate rows based on part of cell.
  638. Is there any regexp and hashtable management in Excel VBA?
  639. how can I insert a space every three characters?
  640. Label on User Form visible
  641. Populate a Multicolumn ComboBox with filtered range
  642. MACRO HELP
  643. MS Query does not quote identifiers in the generated SQL
  644. syntax correction
  645. Greater than, less than statement
  646. XL 2003: ListBox ListCount (and other) properties missing from Local Variables window
  647. Inserting Excel Data Range into Access Table
  648. Quick .End(xlUp) Question
  649. subscript out of range - how to determine
  650. Hours
  651. VBA question: adding a row to worksheet from recordset row
  652. Text to Row automation
  653. How to preset password for editing for new files generated in exce
  654. window to enter a number
  655. newbie q: how to run one sub after another
  656. Executing custom MDX queries in Excel'2007
  657. Format of calculated member in VBA
  658. Face id on custom menu bar.
  659. Launch non-office applications through VBA
  660. Size of Row
  661. Excel interop from c#
  662. Combining Variables Into A Single Output Cell
  663. Call a menu item
  664. When Saving As
  665. disabling tool bar
  666. Change Page Field in a Pivot Table and Print Chart + Data
  667. Is FIle Open
  668. Transform positive numbers into negative
  669. VB code to compare/validate and delete as required
  670. Dynamic range with VBA
  671. How do I use a Userforn TextBox with Autofilter
  672. How to Determine the 3 of days between two dates
  673. set range
  674. Columns collection Address
  675. Run Part of a Code If Q
  676. Problem with Workbook not shutting down properly
  677. ScreenUpdating not working
  678. Hyperlink question
  679. Optimising vba programming in Excel
  680. overflow problem and variable declaration
  681. programming button again
  682. Substitute in Excel VBA
  683. VBA, change 'copy line' into 'copy range'
  684. Find and Paste Loop
  685. Macro to Automate Text Import for Multiple Files
  686. EXPORTING DATA FROM EXCEL TO WORD
  687. Cut/Paste using Left(), Excel 2000 & 2003
  688. Sorting Query
  689. Can I use code/macro to change code/macro in an existing file?
  690. worksheet name store in a variable
  691. Publish Chart not supported in Office 2007?
  692. USA-NY/NJ - VBA Programmer/Consultant - Immediate
  693. Ignore #N/A in formula
  694. How Do I Set A Timer in VBA?
  695. Sorting w/Macros
  696. How to export a range of cells on a worksheet to a text file
  697. Office Web Component
  698. Deleting extra rows
  699. Excel 2003 Command bars
  700. Error 429 VBA.Interaccion.Createobject("Scripting.FileSystemObject
  701. RE: Pivot Table - filter by a cell reference
  702. RE: Pivot Table - filter by a cell reference
  703. Can't set pivot table object variable
  704. VB Code + Runtime error 91
  705. Allowing for Grouping and Ungrouping while Sheet is Protected
  706. TEXT DATE Format Conversion
  707. Loop Thru Values in a Column
  708. VBA help- Do While and If statements
  709. Retrieving chart series range data
  710. Getting coordinates of an Hyperlink using range get_Top(), get_Lef
  711. changing colors of a cell
  712. File list - list filenames in excel
  713. form object doesn't have a show method ?
  714. Date addition/format
  715. Windows Scripting Host popup method has stopped timing out
  716. How to export data from SAP to Excel ?
  717. EXCEL Sving Formats
  718. Dropdown list to return different value
  719. macro language
  720. Excel.Interop Not Saving Column Width Changes
  721. Excel losing focus, but remains active !
  722. Removal of External Links -incl script
  723. Comparing Data in a worksheet and access.
  724. VBA question
  725. VBA-generated Hyperlink problem
  726. Referencing a Dynamic Named Range in VBA
  727. Dumping data to .pdf, taking screenshots, mirroring a sheet, or other report type?
  728. Moving colC to colA
  729. Range.Subtotal different than menu function
  730. Formula Help
  731. Running Code on Hidden Worksheet
  732. Newbie Questions
  733. Track Date Created & Last Modified Dates
  734. Access Memo field to Excel Textbox
  735. Multiple If Statement
  736. macro on exit of field
  737. Using Macros to ask the user to enter a date
  738. Replacing values in formulae with links
  739. how to dynamically import a text file
  740. Boolean Misread
  741. Need help removing items from combobox
  742. Help needed with connected worksheets
  743. How to extract data without opening Excel
  744. browsing filter
  745. removing links to external workbooks
  746. Conditional Formatting
  747. Create Shortcut in VBA
  748. why stepping thru works differently module vs. worksheet
  749. Print Worksheet to PDF Files
  750. OleDBConnection.Open() blocks with 100% CPU