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. Code to concat "Jo Smith" and "Ja Smith" if there are multiple "J Smiths"
  2. txtBox/VLOOKUP
  3. getting the sum of the last 20 cells
  4. Adding positive and negative
  5. How To Update Formulas Without Refreshing Links Each Time
  6. How do I plot a 45 degree line in EXCEL VBA?
  7. error 1004, method of class/object failed
  8. Vlookup Mutiple Values
  9. Updating cell values on sheet based on selected combo box value
  10. A Serious Round-Off Problem !!
  11. Query retrieving data from the web - excel 2003
  12. Merge 2 workbooks into 1
  13. Trouble with emailling in XP
  14. Need help with email code (PLEASE)
  15. Finding the last used row in a specific column...
  16. If Then Loop....
  17. comment change trigger
  18. Application.Run (WorkBook.Name & "!MacroName")
  19. Avoiding the triangle (formula error checker)
  20. Combo Box Drop Down with a Protected Sheet
  21. not necessarily a code question, but
  22. string comparasion
  23. Protect Worksheet While Allowing Autofilter
  24. Need help programming charts
  25. ftp ---> VBA
  26. Expunge cell from memory when late binding involved
  27. Deleting exact duplicates in a database
  28. If then statement
  29. Change default in input box from "20" to "000000"? Have macro continue on to name sheet tab?
  30. adding worksheet name to a named range with VBA?
  31. Redim Preserve form a userform?
  32. DataObject
  33. get the value of a formula in cell B1 into cell A1 without changing my current cell selection
  34. getting an average of No of Days on board verses month departed.
  35. copy specific cells in workbook to new workbook
  36. Approach for lookups
  37. Transpose problem
  38. Add Sheet Name to Cell in Worksheet
  39. Application-defined or object -defined error continually haunting me
  40. Check for open workbook
  41. F1 help for ChartObjects
  42. Open all excel files in the "volatile" folder
  43. Copy Cell Formatting
  44. Change the "Labels in Formulas" function to an add-in.
  45. Excel VB - WHERE syntax error in Access web query.
  46. MAX in VBA not working
  47. Code Cleaner (Rob Bovey): Compile? Means what?
  48. Wild Character in String
  49. warning signal
  50. Make visual basic truely visual!
  51. Workbook_Open Event not firing
  52. capture only part of inputBox or of cell contents
  53. Pivot tables
  54. RE: Sorting an Address list - 1 attachment
  55. Drop Down menu in a Cell
  56. Toggle Button Caption
  57. Event code to continuously monitor change
  58. Dynamic Charting
  59. VLOOKUP error 1004
  60. Modified "For Each wbk In Application.Workbooks"
  61. ReDim ArrayXY
  62. Combo Box Print issue
  63. Do Until syntax problem
  64. When is it necessary to "calculate cells" - Relocated post
  65. AppSentinel
  66. Assistance with VBA code on MAC
  67. File open and close, get some data
  68. Update worksheet formula
  69. Excel VBA putting text from textbox into SQL statement
  70. Copy/paste macro blocking
  71. Sheet Criteria
  72. Instead of opening Solver Excel starts up a sub from the VBA project
  73. stake space
  74. coding an anagram function
  75. Problem: keyboard shortcuts get changed unintentionally
  76. Web Publish Pivot Table: Enable NoDragToHide using OWC
  77. [QueryTables] showing results on a per row basis
  78. copy from multicolumn .txt document
  79. comparing 2 columns of numbers
  80. Error when saving Excel output file
  81. Howcome the workbook opened by VBA library reference changes?
  82. Excel Programmer in Brisbane, Australia
  83. Select noncontiguous multiple columns by column number?
  84. Formulas Are Displayed and are not calculating
  85. Don't unhide my worksheets
  86. Password reused
  87. Returning values based on a cell
  88. Refresh / Update URL
  89. union of RangeName
  90. Using Excel 2003 with Vantive CRM
  91. False 'Document is already open' error
  92. VBA corpus?
  93. paste info to all open workbooks (first free line can vary)
  94. Sorting rows (left to right) programmatically
  95. Processing...Please Wait Message Box
  96. How do I use workbook.sheets.count
  97. i'd like some help using an array
  98. Parsing a Text file into worksheet with VBA
  99. Combobox userform help please
  100. Linking multiple scripts by user OK
  101. .Formula Property returning or setting inconsistent results?
  102. Use Advanced Filter to Detect non blank rows
  103. identify first row after subtotals
  104. removing hard coding from code
  105. Seeting up repetitive code
  106. How to stop a scrollbar from blinking?
  107. Cannot Find Object "Lock Picture Aspect Ratio"
  108. Finds date but won't change cell
  109. path and file name
  110. Macro not showing up/missing under TOOLS>MACRO or VBE
  111. Use SUM and FREQUENCY functions to count unique items
  112. Use SUM and FREQUENCY functions to count unique items
  113. Sequential numbering
  114. VB subroutine
  115. ADODB
  116. Duplicate rows a given number of times in Excel?
  117. Cut and Paste Macro.
  118. how to format numeric click up/down for a cell on tablet pc?
  119. How do I get gold stars?
  120. New to Microsoft Treeview Control
  121. Macro creates two graphs instead of one?
  122. Hide or protect hidden rows/columns - macro help
  123. Indirect & Round Functions
  124. Save copy of workbook
  125. Disable Drag & Drop
  126. Multiple Charts
  127. codenames
  128. Worksheet name changes on external reference
  129. autocorrect question
  130. prefixing a cell?
  131. Checkboxes
  132. Date and time entry on button click
  133. Hiding Rows and Columns
  134. Help with creating a search engine in excel vba
  135. Allow spreadsheet scrolling behind userform
  136. insert fields
  137. Removing Objects
  138. can textboxes let users format text or cut and paste
  139. select text in cell based on text from another cell, paste the text at the begining of a thrid cell, etc...
  140. If target.count > 1
  141. force Excel to open in Internet Explorer
  142. Need help with Range object in Macro programming
  143. Is "" the same as NULL?
  144. open word macro from excel
  145. Convert column letter to number?
  146. Macro Save with Worksheet as file Name
  147. Error from repeated chart copying
  148. Automate Menu item with VBA?
  149. Using AdvancedFilter on range of data
  150. Print Message Box
  151. Creating CSV Comma Delimited File
  152. Need to delete last value in column but not delete entire row
  153. Turning numbers into days, hours and minutes
  154. Loading Macros at Runtime
  155. Return column letter, rather than number?
  156. Click event not working
  157. run-time error 1004 - VBA Gurus Please Help
  158. Automatic Macros
  159. Code seems to stop, but no error messages show up
  160. Adjust Row height to FONT
  161. Referenz to running excel application
  162. multithreading / distributing excel code
  163. Default Header/Footer values
  164. Macro Excel
  165. Macro Question - Excel to Access and back again
  166. Help needed with Vlookup & copy row to new sheet
  167. Check a column for correct type of data
  168. Assistance with error message on CELLS
  169. ComboBoxes
  170. VBA Save
  171. Object Variable Not Set
  172. Data is added in 1 column instaed of 4 columns (in listbox)
  173. non-contiguous range
  174. Error msg - the object invoked has disconnected from its clients
  175. SET A CONDITION
  176. help designing a speedometer/fuel guage type chart
  177. a question about diagrams.
  178. International Issues
  179. Find and Replace
  180. Calculate the number of hours between two dates and times
  181. UserFrom Back Color
  182. Selection.sort Run-time error '1004'
  183. Setting VBA reference programmatically
  184. frozen panes question
  185. Change Addin File Access to Readonly?
  186. Sorting a List Box
  187. Pivot Table Range Address, Row & Column numbers
  188. Late Binding for Excel CommandBar and CommandBarControl
  189. Pixel position of cell
  190. Remove Module not working
  191. Identifying Excel Version
  192. cut rows from worksheet based on cell isdate value
  193. Copy rows to multiple sheets based off column value
  194. Issues finding date in range of data
  195. Cell result must be a minimum of $1; way to round up to that for amounts between $0-$0.99?
  196. Excel emailing from spreadsheet
  197. Access popup window from IE object.
  198. help with adding list box to userform
  199. Export Import Modules File Name error
  200. Using an index with a class module?
  201. text to excel-2nd request
  202. Help Please: Run Excel based sub from Access using GetObject
  203. How to connect to a Unix box from Windows and execute a script?
  204. text to excel -Help
  205. Repost of Listbox Headers
  206. Chart Source Data
  207. find replace
  208. Advanced VBA Question: Copy data to another sheet to make Validation List
  209. Using a Defined Name Value in a Pivot Table
  210. Inserting static times into cells using command buttons
  211. HELP: Web Query does not seem to get the data
  212. time card program
  213. Can someone recommend an Excel VBA Book?
  214. OK Button in UserForm
  215. Don't Give Up!
  216. Userform initializing problem when opening
  217. Trying to ceate an event tracker: linked to dates on a calendar?
  218. What does double quotes signify?
  219. status update during program run -- DoEvents doesn't always work
  220. Setting a Worksheets Codename to a variable programmatically
  221. Code to delete rows where cell value is zero
  222. Insert columns copied to clipboard results in vaues not forumlas
  223. Select All Shapes
  224. display the name in a list with the maximun salary
  225. Displaying Number Only Once in a New List
  226. Deactivate workbook commandbar for one sheet?
  227. Functions
  228. Combo Box: Vlookup Multiple Cells by referencing to Text Box
  229. How do I write a VBA for 3 consecutive dates?
  230. more find help please
  231. Manipulating a Pivot table....HELP!!...
  232. Assign name to chart object?
  233. adding row from userfrom and copying formulas
  234. Adding Headers to a listbox
  235. Loss of data in very large calculations (vba in excell)
  236. Create popup alert based on date match
  237. Excel formatting saved in a database?
  238. More information on Method 'Open' of object 'Workbooks' failed
  239. any clue why this won't work?
  240. Installation and Solution Update Question
  241. I need to get the integer value from the address R[4]C, any ideas ?
  242. How to get row number from R[4]C
  243. auto copy from one sheet to another
  244. Index Match Lookup
  245. Help with filter Range & delete rows
  246. Finding Row Numbers Within the RangeName
  247. Save new file in same directory
  248. userforms
  249. Creating default values in Excel
  250. name checking or cross-referencing spreadsheet
  251. VBA to read "form"
  252. Form Object Difficulties.
  253. IF Activecell
  254. List Shortcut Assignments
  255. Using VBA to insert a multiple-row title in the CenterHeader
  256. data sorting according to the date
  257. Can I add a Calendar/ date picker graphic to an excel doc?
  258. How to stop search / replace prosess in large excel worksheets
  259. Date Format
  260. The Infamous Aaron Kempf.....
  261. FIND DATE xlLastRow and searchdirection
  262. Adding 1
  263. AutoFit Visible Rows
  264. creatin new sheet macro
  265. R/T 438
  266. NamedRange Column Names
  267. Clearing all values in range that aren't formulas
  268. Dates
  269. Help with Loops is my guess
  270. Referring to non constant columns
  271. Struggling
  272. Colour of multipage textlabel
  273. Using VBA to set Excel Data Validation
  274. Protection - Hyperlinks
  275. Arabic / Hindi Numerals
  276. Sheet Selection without using the sheet name
  277. When to use With - End With?
  278. Help with VBA
  279. Calculating percentages
  280. How do i export selected columns from excel to an Oracle database
  281. Insert macro
  282. Inserting Rows, but keeping row size
  283. Opening html versions of workbooks
  284. REPEATED VALUES!
  285. Screenupdating
  286. Checking some values in Workbook
  287. How to activate a worksheet when a macro is running in the sheet m
  288. Memory Leak
  289. Place rectangle and define its height?
  290. conditional row hide
  291. change event for drop down
  292. how do i set up auto invoice numbering in excel2000?
  293. Doing a "print preview" slows down an Excel 2003 COM addin.
  294. Make a number flash on and off
  295. Copy VB code from one worksheet to another using VBE
  296. Input box function in 2007
  297. listbox assistance
  298. Small grid control on User Form?
  299. Getting printers list to put in userform
  300. variable given by user
  301. Option button and Highlighting an area
  302. Finding Source of Chart Data
  303. Userform doesn't react on enter
  304. e-mail address via outlook address book
  305. working with hours in xs of 24
  306. User form caption automatically populate with excel file name
  307. find syntax help please
  308. Last saved By in the footer of a print
  309. Run Time Error 1004: Application or Object Defined Error
  310. Run Time 1004 Error: Application or Object Difine Error
  311. If Worbook Name = "X" then Prevent Macro From Running
  312. VLookup
  313. What does # mean in front of IF statements
  314. Retaining Changing Font Color in Cell
  315. auto e-mail to numerous people
  316. Help with finding a row number
  317. Compare Two Lists
  318. Excel Macro binding
  319. Merge two text lines into one? Macro help needed
  320. Dynamically adding data after the last column
  321. excel formula
  322. Calling an XLL from VB?
  323. Need help in a hurry
  324. Sort Scenarios in List manually or programatically
  325. Recursive procedure
  326. Help with creating an Excel equation similar to a database
  327. Extracting comments from all worksheets in workbook
  328. variable scope question in user-defined function
  329. Using VB6 and OLE to add a new column to an existing Excel worksheet
  330. Calling JJ re generate form at runtime
  331. links
  332. US date needs reformatting but not recognised by my UK computer
  333. Global Password Change
  334. excel 2000 fails to open excel 2003 file
  335. Public array
  336. Can't find file
  337. Help with Problem code needed
  338. defign a function in one workbook and use it in another workbook
  339. using a user form to add data
  340. inserting line break within a row
  341. referencing another worksheet in a formula
  342. pop up message
  343. Label with randomly selected text from cells
  344. Automatically Move to a cell
  345. copy data from several workbooks to a master workbook
  346. Excel locks up - reloads in SAFE mode
  347. Offset issue
  348. Calculating cells
  349. previous day
  350. Existing Code to loop thru all w.sheets in wb
  351. Start a macro when a clock goes down to zero
  352. rounding to .5
  353. Searchable database
  354. Combo Headache
  355. format many rows depending on record type
  356. generate a form at runtime?
  357. Combo Box Loading
  358. Switching Between 2 workbooks using VBA
  359. New row
  360. thisworkbook.saveAs triggers change event?
  361. Form label not showing
  362. Preventing Recalculate on open
  363. detect validation list
  364. Logging what procedures are executed
  365. Help with code problem
  366. Determining All Instances of Excel
  367. Accessing value of drop-down
  368. Converting excel speardsheets/macro into a database system
  369. Picture on Form
  370. Using Postscript in a WebQuery Accessing a Russian Website
  371. Retrieval from a Web site
  372. how to paste a fomulae cell in a protected sheet
  373. how to get commandbutton name
  374. data validation list does not trigger worksheet_change event
  375. Unload User Form
  376. Need help with modify this macro to copy.
  377. loop through cells in a range and pick up corresponding cell values in another range
  378. Assign a 2D array of constant values to a range
  379. VBA to set value of a cell
  380. Place 6-cell row in another folder when cell #3 is verified
  381. Enable/Disable CommandBar Buttons Based on Events
  382. named range in conditional formatting
  383. Detecting Cancel in an InputBox Method
  384. Changing string input in a query within a macro
  385. Enumerating PivotItems collection fails to display duplicate values
  386. Is there an AfterUpdate event for excel combobox?
  387. format last row on sheet with VBA macro
  388. Range Replace
  389. Variables in Declaring an Array
  390. macro to create CSV from Wave File
  391. Use of Intersect: Place Value in one cell AND remove from another
  392. Remove unwanted values
  393. Need help. Simple check box then print the next cell.
  394. Download File From URL
  395. Cancel Hyperlink Click
  396. Problem making a spreadsheet writable
  397. Sorting Ranges of Data
  398. Program Buttons in EXCEL
  399. Sorting Issue
  400. Open Multiple Queries in New Tabs
  401. Send to mail recipient( as attachment)
  402. inserting line break with find and replace.
  403. copying field names from Access query
  404. Attach password to Button?
  405. Hyperlinkingto an Intranet
  406. Create chart shaped like a clock
  407. Search for active file name (modified), then....
  408. Help:option buttons custom views and Private Sub btnPrint_Click
  409. copy all rows before empty row
  410. VBA error with Open for Output / Append: File not Found
  411. Load Data into userform
  412. range selection help needed
  413. Locate number within range, copy number below it to another cell
  414. Using Counta with a range
  415. Display MsgBox wait for 10 seconds then click on yes automatically
  416. Ctrl+Shift+Down in a macro - doesn't re-run
  417. copying worksheets to a new workbook without formulae referencing original workbook
  418. why won't this vba work, when this one does...
  419. Search and Move - Cannot Figure This Out - Please Help
  420. How to send specific cell ranges to multiple e-mail addresses
  421. How to send different ranges to multiple e-mail recipients
  422. Drop-down box automation - cell duplication.
  423. Issues with saving to USB drive
  424. RTD server in C#
  425. Changing the Format of a Graph Legend...
  426. Copying DataList Rows
  427. Newb Q: XLL and XLA?
  428. Random Clears
  429. macro to hide columns and/or worksheets
  430. Range Question
  431. simple for each
  432. simple for each problem
  433. Help
  434. E-Mail attachments
  435. CommandButton and a variable
  436. Macro for Breaking out Rows
  437. .Paste not working everytime
  438. Code, is user form open
  439. Form is open ?
  440. Aggregating data from various file in one.
  441. Displaying data in user form from active worksheet
  442. Run a UserForm in the middle of a Macro
  443. Loop not returning to original workbook
  444. Conditional replacements with VBA
  445. User Form issues
  446. FaceID (icons) for Excel ToolBar
  447. Clipboard Message
  448. Workbook Protection
  449. Disable mouse scroll wheel
  450. can anybody speed up this macro
  451. Delete ROW if COLUMN = data
  452. Delete ROW if COLUMN = data
  453. Accessing selection list within a user form
  454. Command boxes not appearing
  455. Copy data from .txt to .xls
  456. Range Selection
  457. Macro for Frequency Data
  458. Msgbox with randomly picked text
  459. Excel macro using email - Security warning from Outlook
  460. comprae cells
  461. Example form Book
  462. macros in excel application object
  463. excel application object
  464. Date file created
  465. Parsing Excel documents with C#
  466. combobox increment
  467. Excell and changing cell colour
  468. Pictures/Graphics in/out Excel-cells
  469. test if a character in a string is alpha
  470. Pivot table header that changes everytime
  471. Start macro automatic
  472. Array formulas - too slow
  473. Deselecting active cells after pasting
  474. Dynamic menus
  475. How to start recording a Macro & Retrieve the contents via Atomati
  476. Recording Macro & trapping its contents via Automation
  477. Sockets programming in Excel
  478. Collection VS Scripting.Dictionary
  479. autofilter, command to select filtered range?
  480. TIMING EXECUTION DURATION!
  481. Deployment problem with Excel WorkbookProject written in C#
  482. check box
  483. research data between 2 sheets
  484. A query in continuation to the nested bordering - To TOM, JIM and others....
  485. Show method of dialog class failed
  486. import data from web site
  487. On Error Command
  488. Need suggestions to build Excel/VB Interface to select/view MS Access Data
  489. Select by format
  490. Save Extension
  491. 'Open File' Functionality
  492. '1004' - Application defined or Object defined
  493. Button on custom toolbar appears only after mouse hovered over it
  494. Finding last cell and insert line
  495. autofilter with variable criteria
  496. Cycle through Pivot Tables with Pivot Items
  497. Why doesn't OnKey work?
  498. Missing Assign Macro Command
  499. excel vba to save a page
  500. Help with data Comparison
  501. Format Time
  502. Hyperlinks
  503. Print Frame1
  504. This Hyperlink formula doesnt work
  505. Vlookup on second WorkBook
  506. Setting Forms controls from outside
  507. VBA Range error - How does this work and what am I doing wrong?
  508. Identifying toolbars.
  509. how can i get duplicate data on excel sread sheet
  510. Change color of title bar on user form
  511. Determine the number of outline levels using vba
  512. Determine the number of outline levels using vba
  513. Decimal Places in TextBox
  514. Find in multiple sheet...
  515. Show Form and Hide Worksheet on Load
  516. macro to edit cell contents
  517. Group Shapes
  518. Merge & Match 2 Excel Data Tables
  519. Automation and lack of resources (error)
  520. refresh web quiries when workbook is opened
  521. Formula for historic pay rate
  522. Time align New Product Launches
  523. Macro Help for Simple function Please
  524. problem with fetching data from excel
  525. Calculation total not to exceed a specified number.
  526. Copy cells in active row
  527. Looking for a Utility with Multi Line REM conversion
  528. Time Comparison
  529. Userform + listbox question
  530. Selecting frame in Internet Explorer from Excel
  531. application.inputbox
  532. X-axis labels in charts
  533. X-axis labels in charts
  534. Transparency Discrepency
  535. Sorting issue
  536. Intersect Code too slow HELP
  537. URGENT! Expunge Excel from Memory
  538. Modify macro code to export multiple cell contents to multiple Text Files
  539. Need help taking values from List box to spreadsheet
  540. Delete A Macro
  541. VBA Column Conversion
  542. Getting compile error: out of memory in VBA How do I fix this?
  543. Code to calulate percent of total in column
  544. Find next blank cell via macro
  545. Force Input when opening file
  546. Combo Box Drop down & Sheet Protection
  547. TOP - Justify and Autofilter the Data in Excel
  548. Array slowing down event procedure
  549. how to program the equal filling out of an individual selction of fields?
  550. split text into rows and have the first clumn information repeated
  551. Need to search a string for numbers
  552. Help with 1004 Error
  553. Can I make "Option Compare Text" the default
  554. UserForm Question Need Help!
  555. Importing .PRN files into Excel spreadsheet
  556. Importing .PRN files into Excel spreadsheet
  557. VSTO 2005 - How to use ThisWorkbook as an Excel.Workbook
  558. Date Entry Issue
  559. vlookup cannot see value for some cells
  560. Run Time Error '1004'
  561. Is VBA Class have Constructor like java ?
  562. clear results when any input box changes
  563. ActiveSheet header including a named range
  564. external data
  565. Calculating Growth Rate
  566. Array's, Calculations and Results
  567. Finding Number Within Range Then Copying Data Below Number to Cells
  568. .Net Automation Add-In - Execution Always Ends in Edit Mode
  569. .Net Automation Add-In - Execution Always Ends in Edit Mode
  570. Textbox in Userform - data destination
  571. passing parameters to function assigned to button property onAction??
  572. Disable a new paste button
  573. AutoFill down a varying Range
  574. filter listbox on Userform
  575. Best practise XLA add-in
  576. Formulas
  577. Copy and Paste Updating HELP needed
  578. help
  579. Checking for non-blank cells in named range
  580. Checking for non-blank cells in named range
  581. Checking for non blank cells in named range
  582. Query data within a PivotCache programmatically
  583. macro to move contents and delete existing row
  584. Checking for nonblank cells in ranges
  585. Checking range of cells for entry then checking for total
  586. macro to move contents and delete existing row
  587. macro to move and delete contents
  588. Variable in a textbox reference?
  589. Part 3, Formula help
  590. DATA SORTING MACRO
  591. suppressing "do you want to save changes..."
  592. Error with Goto command
  593. Add Day to Date
  594. delete cells with a value of 2
  595. How do i covert a number to its text value i.e 1 to one
  596. create xl workbook
  597. Paste Range to New Workbook
  598. MS Query Error Message
  599. MS Query Error Message
  600. ADODB.Connection
  601. For Each...Next not working
  602. if statement
  603. Excel to Word
  604. Cell update formula
  605. How to start template with connected workbook
  606. How to open connected workbook with template
  607. csv file not recognised with ms-office 2003
  608. For all guru's. Can this be done?
  609. VBA - Save with new filename
  610. VBA - Save with New Filename
  611. Formula help
  612. Forumla question
  613. RANK
  614. How active office 2006
  615. Re-Post - hard formula (Bob Phillips out there anywhere?...)
  616. macro to copy numbers based on criterias
  617. Macro Shortcut Key Conflicts with Application Shortcut Keys
  618. Macro Shortcut Key Conflicts with Application Shortcut Keys
  619. X-Axis labels
  620. Find in a dynamic column...
  621. SendKeys to emulate ALT+TAB, TAB, TAB
  622. Find a string in a range and return two values based on offsets
  623. Format results of Macro
  624. hyperlink URL forced to localhost
  625. VLOOKUP - Multiple Worksheets
  626. VLOOKUP - Multiple Worksheets
  627. Database record add
  628. Descreption Seperation
  629. How to change the default Command Button
  630. How do i unfreeze excel formulas to work
  631. Can somebody help me with a slow macro problem.
  632. Count number of files in a folder
  633. Message Box Prompt
  634. Need more than Sendkeys. What is the tool for the job?
  635. Creating a hyperlink to a webpage
  636. Combo Box Code
  637. Copy and Paste Values not picking up on cells with formulas
  638. Text file db where record already exists conundrum
  639. Print sub returns
  640. Password Protect Worksheet
  641. Toolbar Images
  642. PivotTables and Changing the FileName
  643. How to set range for charts?
  644. Return to excel from vbe
  645. How do I run code when exiting a cell
  646. Offset and Merged cells
  647. Paste Special Formula
  648. X-Axis labels
  649. Displaying something within a range name in an Excel Header
  650. Macro with eayfilter
  651. Automation Error
  652. macro to move cell contents and then delete the row
  653. macro to move cell contents and then delete the row
  654. toggling between 2 workbooks
  655. Convert Columns of Sensitive Information, and then convert back...
  656. Calculating Date Ranges and Weight Totals
  657. Paste Graphics in a specific Loacation
  658. GetUserName help
  659. Protected VB code - Run-time error
  660. Error when creating menu item on command bar
  661. BMPS stored in a Resource Editor File
  662. Help with auto Fill
  663. Copy Data on Row Change
  664. Retrieve Data from a Serial Port
  665. Hide Pivot Table Column if Total Sum is Zero
  666. how do you turn off overwrite?
  667. Workbook Reference Problem
  668. HTML for Excel Question
  669. Using Range name in Header
  670. Using named range value during Workbook_BeforePrint event
  671. Complicated formula.......
  672. User Form texbox insert text in cell - excel 2003
  673. Question about User Defined Functions
  674. Help with auto Fill
  675. formate date by month & day & ignore year
  676. Need to run auto_open before user disables macros at startup
  677. DAO issue : Data source name not found
  678. Copy and paste code
  679. Re: VBA Chart Problem
  680. Deleting Sheet with No Data
  681. How do I make a commandbutton in Excel 'launch' a custom form?
  682. Recorded Macro
  683. MACROS: Protect a cell depending on the value of another cell
  684. Is workbook beforeclose event the best place to do this?
  685. Arrays
  686. Reading TSv files in Excel
  687. VBA to VBA Script Function
  688. Accessing pasted pictures
  689. Loop and delete
  690. Urgent - how to run textbox exit sub?
  691. Set sourceRange
  692. Inserting a line in a database - alternative colours
  693. coding greenbar
  694. PublishObjects(x).Publish fails
  695. Adding a macro to all new workbooks
  696. Making a Tricky formula even trickier!
  697. Updating a validation list macro
  698. creating an event of pressing 'enter' using VB
  699. Excel Chart
  700. Identifying Userform Control Type
  701. Auto refresh for VB script to take effect.
  702. Multiple line
  703. Count & Select Window
  704. Scripting.Dictionary
  705. Scripting.Dictionary question
  706. using excel wizard for file download which contain many fields
  707. Help with this
  708. Word and Excel should be more identical in their features
  709. Using Code from another workbook
  710. How do I perform a partial word search in a cell ?
  711. object on RHS when there is a type-mismatch
  712. Getting a type-mismatch no matter what I do.
  713. Passing Data to a Line in a VBA Script
  714. Hidding Columns with R1C1
  715. Hide Column Based on Partial Text Match in Header
  716. Asigning code to Button with Macro
  717. Recording who last saved a workbook
  718. Run-time error '7'
  719. Run-time error '7'
  720. [OT] Internal file structure
  721. cell referencing
  722. looping thru range extracting data based on character
  723. Check box format
  724. find and delete a character from multiple columns
  725. Pull a set number of characters from a cell without cutting off a
  726. Pull whole words from a cell up to a set number of characters.
  727. Hide Option Button Control
  728. Why does adding columns slow down processing speed?
  729. lookup or some other type of similar function
  730. Setting sheet tab order based on sheet name
  731. Maximum number of hidden columns
  732. get data from one file and put into another
  733. Trouble Removing a value from a ListBox
  734. Adding IF statement to custom function (VBA)?
  735. Vlookup
  736. Created SplashScreen but workbook opens before SplashScreen
  737. combobox problam
  738. Removing a value question
  739. vba to detect if column contains partially hidden text
  740. row number and column number of cell
  741. Removal of VBA from Excel not working
  742. printing track changes with vba
  743. Type mismatch error on Find
  744. Simple Problem?
  745. How to change the colour of a cell continually?
  746. VBA Code problem
  747. Merging Cells from C# and Interop
  748. Check for file in folder
  749. How do i fix this macro?
  750. Evenly dividng records