PDA

View Full Version : Excel Programming


Pages : 1 |  2 |  3 |  4 |  5 |  6 |  7 |  8 |  9 |  10 |  11 |  12 |  13 |  14 |  15 |  16 |  17 |  18 |  19 |  20 |  21 |  22 |  23 |  24 |  25 |  26 |  27 |  28 |  29 |  30 |  31 |  32 |  33 |  34 |  35 |  36 |  37 |  38 |  39 |  40 |  41 |  42 |  43 |  [44] 45 |  46 |  47 |  48 |  49 |  50 |  51 |  52 |  53 |  54 |  55 |  56 |  57 |  58 |  59 |  60 |  61 |  62 |  63 |  64 |  65 |  66 |  67 |  68 |  69 |  70 |  71 |  72 |  73 |  74 |  75 |  76 |  77 |  78 |  79 |  80 |  81 |  82 |  83 |  84 |  85 |  86 |  87 |  88 |  89 |  90 |  91 |  92 |  93 |  94 |  95 |  96 |  97 |  98 |  99 |  100 |  101 |  102 |  103 |  104 |  105 |  106 |  107 |  108 |  109 |  110 |  111 |  112 |  113 |  114 |  115 |  116 |  117 |  118 |  119 |  120 |  121 |  122 |  123 |  124 |  125 |  126 |  127 |  128 |  129 |  130 |  131 |  132 |  133 |  134 |  135 |  136 |  137 |  138 |  139 |  140 |  141 |  142 |  143 |  144 |  145 |  146 |  147 |  148 |  149 |  150 |  151 |  152 |  153 |  154 |  155 |  156 |  157 |  158 |  159 |  160 |  161 |  162 |  163 |  164 |  165 |  166 |  167 |  168 |  169 |  170 |  171 |  172 |  173 |  174 |  175 | 

  1. Help with the following code...from EntireRow to set width
  2. VBA and PDF files
  3. Range values not being copied with same number of significant digits
  4. Auto Mail
  5. Excel spreadsheeet
  6. VBA Module Function???
  7. Linking Worksheets
  8. Excel Sorting - Finding Duplicate Entries
  9. Tracking changes in sheets
  10. NG and Word
  11. Microsoft Excel Triggers Microsoft Word
  12. Comparing 2 different work books
  13. Complex macro issue
  14. Source Code control vba
  15. Formatting UserForm Text Field as Numeric
  16. cell change
  17. Assign cell to checkbox
  18. Spin button
  19. Worksheet event to change formatting when date expires.
  20. Getting Chart Cursor information in Excel 2003
  21. Locking Cells
  22. Getting Chart "Cursor" information in Excel 2003
  23. Formula to ask what Time/Date it is.
  24. Property in lowercase
  25. Getting Chart "Cursor" information j
  26. SUBTOTAL SUM AND AVERAGE
  27. Extreme calculations
  28. Macro not running in Protect Sheet
  29. Macro not running in Protect Sheet
  30. How to write VBA code to make backup copy in another folder
  31. Drawing a Flow Chart / Schematic / (tree diagram?)
  32. Macro doesnt work from another sheet
  33. VBScript Event Sink Not Firing
  34. Dropd Down (validation: list) on the fly with a code - a problem
  35. Macro / vb query
  36. VBA time and date?
  37. Re: Selecting the secon column of a separate range
  38. Determining number of columns of 2 different ranges
  39. Appending multiple columns into a new worksheet
  40. Slow Macro...Takes at least 1 Hour to Run
  41. exporting to a server
  42. odd vlookup solution required - can you rise to the challenge?!
  43. How to change column size in VB6 and Excel 2002
  44. ActiveWorkbook.SaveAs
  45. Using MS Query to do a Jion for pivot table data
  46. Excel List Box
  47. Re: Vlookup and sheet name
  48. Combining two ideas?
  49. Re: Passing frame object in code
  50. Re: Ranking with Duplicates
  51. Converstion of Complex Word VBA macro to Excel Macro
  52. "show office assistant" greyed out; code suspect
  53. maximizing the size of a UserForm
  54. Capture Events on programmatically generated Charts
  55. Deactivate / Reactivate the Paste Function in excel
  56. Save from exe file to csv file
  57. I just want to add a W!
  58. visual basic Loop by rows in Excel
  59. Changing cell data with macro--HELP!!!!
  60. Function to call macro
  61. Offset VLOOKUP data by one row - example in message
  62. Change background color when value changes in a column.
  63. RE: replace apostrophe with values above
  64. RE: Run Macro
  65. Macro Help ... Pass values to the excel based model and copy + pas
  66. RE: Run Macro
  67. Re: Run Macro
  68. Excel automation issue---enter date into cell based on other cellvalue
  69. replace apostrophe with values above
  70. Re: Text format in "Concatenate" function
  71. Text format in "Concatenate" function
  72. Run Macro
  73. Expand the NameBox in Excel 2003
  74. close all worksheets accept the active one
  75. Re: Saving an e-mail that attaches a workbook
  76. Merging cell using VB for Excel
  77. disable multiple toggle buttons
  78. format
  79. format number
  80. Re: Help with Excel Add-in
  81. Excel VBA Help
  82. Re: Help with Excel Add-in
  83. Re: Addin Issues
  84. Re: Help with Excel Add-in
  85. How can I embed a parameter for a stored proc into MS Query?
  86. Updating Workbook
  87. Equivalent to vb's causes validation?
  88. UserForm past data
  89. Automatic calling of a macro
  90. ?How to add to a list when sheet is protected?
  91. Data Fill in VB?
  92. Re: VBA to set focus back to exel
  93. count uniques in same column, post in blank cell, repeat until end ofspreadsheet
  94. Was workbook opened with Excel 2007?
  95. Placing button at cell's location
  96. Help with script Please
  97. Importing text files into a "cached" worksheet?
  98. Transferring control from macro in one workbook to macro in anothe
  99. RE: macro probs
  100. find last row, copy until end
  101. Returning data from within a date range
  102. Re: Hiding named ranges before printing
  103. Re: Check for valid file before hyperlinking
  104. Dates in macros
  105. RE: Count Uniques in Column, put result in next blank cell and continu
  106. macro probs
  107. Re: Count Uniques in Column, put result in next blank cell andcontinue until last row
  108. Sorting UsedRange of a Worksheet
  109. RE: change background color of cell as value changes
  110. how to count only one instance of an item if multiple occurrences
  111. Re: RDO working on development PC, not on deployment PC
  112. Re: Deleting cells in a row
  113. How to search a cell for last instance of repeating character anddelete to end of data
  114. Copying from one workbook to multiple workbook
  115. Creating a fund from stocks
  116. RE: Error - Method 'CopyFromRecordset' of object 'Range' failed
  117. RE: Only Copy Subtotals
  118. Capture/Passing Commandbutton click
  119. deleting cells: Auto filter or loop or what
  120. Print to PDF
  121. Mail Macro
  122. Advanced copying of range from one workbook to another
  123. code to merge cells with criteria
  124. Calling VBA function from a worksheet
  125. Two criteria
  126. icon on userform
  127. Sort by Cells Interior Color Then by Date
  128. Re: How to generate a text file from Excel using a macro or script
  129. Edit Function with Keyboard
  130. Excel 2007 - Split and re-consolidate master workbook
  131. Deleting rows
  132. List Box
  133. Range Formula
  134. Hidding buttons
  135. turning hyperlink off
  136. Form Printing
  137. Can a macro in excel open SAP
  138. Import and consolidate multiple files
  139. Error in Calendar tool - Compile Error
  140. Deleting cells in a loop
  141. Pivot table criteria retention
  142. Hyperlink question (or two)
  143. Macro VBA code to copy checked items from multiple worksheets
  144. Connecting userforms to buttons in Excel
  145. Range Formula
  146. Hide the #DIV/0! Error
  147. checking elapsed seconds
  148. Tool | Reference objects
  149. Programmatically Possible??
  150. VBA, VB Script and VB
  151. HELP: Search a formula inside of a Cell
  152. Sub to lock vbaproject for viewing for all xls in folder using a common password
  153. Combining multiple IF statements
  154. Reading in text file that is more than 65536 rows
  155. Solver Problem
  156. Access database error
  157. Excel & SQL server
  158. Confusion on Multipage Tabbing
  159. Code for macro security level
  160. Excel 2003 - Hide Toolbar
  161. Solver Macro
  162. pass a variable to activate
  163. replace all the cells in sheet that include spsific string-via mac
  164. Dont want a button
  165. Convert to Euro - Accounting Format
  166. Adding watch point "Application.Caller" crashes Edsel 97.
  167. Input Box - Type mismatch
  168. Automation of report, daily, monthly then yearly as per need
  169. Another VBA bug
  170. Run query to get data from Access based on user input
  171. Adding a menu item to Excel
  172. Combining data from column while deleting duplicate rows
  173. vba with bloomberg links
  174. linest use in vba
  175. can,t send any email..get an error message
  176. hi-lite missing field with macro
  177. Adding criteria to loop
  178. Need help automating a pivot table...
  179. Macro to count files on sharepoint
  180. Date ranges in macros
  181. MACRO Help
  182. new
  183. Updating text boxes on forms
  184. Small Help Required
  185. Macro deletes seperately
  186. show time of Refresh button execution
  187. Macro VBA code to copy content from one worksheet to another
  188. Assigning macro to button
  189. visual basic editor- defining length of a year
  190. selecting a range
  191. Test if Workbook is already open ?
  192. create folders as I create a row
  193. accessing data
  194. delete all the ranges that related to spesific sheet via macro
  195. excel macro problem
  196. delete Ranges via macro
  197. Can not add the page break when converting asp to excel
  198. Wordpad
  199. Workbook Slow
  200. Got Stuck
  201. Procedure to update a DATE field to either a year from now or a year from what is in the field?
  202. Find and replace If Then ?
  203. Serious Macro Menu Help
  204. Formats not updating with newly pulled data
  205. Help with code??
  206. Copying Multipage1 to Multipage2
  207. Close drop box
  208. Variable difficulties
  209. Clearing fields in Userform
  210. unload or hide?
  211. unable to get the activate property of the range class
  212. Wordwrap
  213. variable doesn't reference correct column
  214. unique values in an array
  215. Can you set up custom menus in Excel 2007?
  216. Add Footer to All Sheets
  217. linked listboxes
  218. textbox data to worksheet
  219. Which project type to use for Excel
  220. Splitting text in cells.
  221. Subtracting times
  222. "embedding" fonts in Excel
  223. Comparing Lists
  224. Macro help! Selecting rows after running a filter
  225. excel and fun?
  226. inputbox on userform
  227. Problem in inserting strings and numbers using right to left language
  228. only load userform if range empty
  229. Creating directories from given column of data
  230. Find Cell with Value and get Value of Cell Below it
  231. Minimize worksheet but keep userform visible
  232. Change Cell Value and Subtract the cell value in another sheet
  233. Deleting Code and saving
  234. Automatically extracting unique values
  235. Excel 2003 Macro help
  236. open file in current directory
  237. MS Query parameter
  238. Macro for special Insert comment text
  239. Passing Public Variable into Sheet Sub Functions
  240. radio buttons to equal values
  241. Delete row with no data
  242. Macros do not run when spreadsheet is used on a different computer
  243. start macro
  244. using offset with FormulaR1C1
  245. Excel Macro Selection
  246. Say "yes" to "OK"
  247. Remove password from multiple workbooks?
  248. phantom link/macro
  249. Opening/Activate Multiple Workbooks - Help
  250. Excel 2003 hangs on save after creating pivot table
  251. array
  252. How do you stop online HELP in 2007
  253. Programming Min and Max
  254. Nexted For Statements don't execute fully
  255. Back Button Macro
  256. VBA Conditional Formatting to UsedRange on Worksheet
  257. take every other cell and put in new colume. No blank cells
  258. Scheduling
  259. Accessing Form's Values from Invoking Sub
  260. changing the fill color on a cell
  261. If And Statements
  262. Workbooks Array
  263. Variable file name in copy macro
  264. For Next Variable Not Being Passed Through For Second Sheet
  265. Help: Pivot Cache error using Range object containing cell with 255char
  266. Programatically Add Outline and Grouping with VBA
  267. Transpose heading array
  268. Dialog box in a macro
  269. function question??
  270. Hide / Unhide Columns in Password Protected w/s
  271. Dialog Box
  272. array inside for statement
  273. Size a Cell to a Picture
  274. How to deate Conditional statement for the header
  275. Range End(x1up) problems
  276. IF statements in Macros
  277. IF statements in Macros
  278. Automatically Populate Worksheet Depending on Team Name
  279. Creating Excel file that points to relative path .cub file
  280. Rearrange data for printing
  281. Macro code
  282. Page break issues
  283. Keydown Problem
  284. Enable/Disable Macro
  285. Sample a random calculated cell
  286. Pick List
  287. formula to save value of cell w/o copy- paste special-value
  288. macro code for XML Fill
  289. Macro code
  290. Macro code
  291. Condensing Task
  292. Change a range to Uppercase
  293. Remove _ inside of string
  294. vb programing match function
  295. Changing a formula to value only
  296. import package from
  297. Two VBA Questions
  298. auto move cursor
  299. URG: Saving an e-mail to be digitally signed
  300. Color Chart
  301. Formula to add a number
  302. CustomMenu.Controls.Add
  303. Open form from another workbook
  304. ODBC-coupling SQL questions
  305. CF sheet sub modifications
  306. Getting the LastRow in ExcelSheet from Word
  307. String vs LONG format
  308. how to refer to the files with regular names? (with formula)
  309. Delete Row and Auto Subtract
  310. Find row with the same data like in another row
  311. FindFormat.NumberFormat fails with some strings
  312. SUM of data from multiple sheets in the mastersheet
  313. make a data entry into hyperlink using vba?
  314. Adding new sheets to the right instead of the default left
  315. Sorting Data in group
  316. Copying OptionButtons
  317. vba to append to a text file
  318. VBA tweak to run faster? <--Rookie here
  319. Changing the stated output of OptionButtons
  320. Help for vba to control the PivotItem in specific Field in Pivot Table by choose in inputbox
  321. Help With VBA Copy Code
  322. what is the vba language to make hyperlink?
  323. matching 7 columns of data
  324. 2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia
  325. Delete text in a string marco help
  326. Size Picture to Cell
  327. Skipping textbox
  328. Macro with FOR - IF Loop
  329. Error with EXCEL macro transfering information to a form in WORD
  330. Marco that Delete Cells With Specific Text
  331. VBA to TRIM data <--Rookie here :o)
  332. Scheduling Macro run
  333. What am I doing wrong?
  334. embedded sheets in a Word doc
  335. Macro and chart help
  336. Macro handling "Insert comment"
  337. Send Email from VBA
  338. How to get the location of a Form Combo Box inside the assigned ma
  339. references to data sheets
  340. Training material for VBA for Excel 2007
  341. InputBox and For...Next Loop
  342. Date & Time Picker Properties Question
  343. Can't Undo Macro Command
  344. VBA: What does Redim Preserve do in term of memory
  345. Calendar question?
  346. Move Range with a date to a Matching Monthly Worksheet
  347. Automate IE to log into bank accounts?
  348. Excel workbook SaveAs question
  349. rtd server question
  350. Finding a floating point value
  351. Size of Spreadsheet Displayed - both in Cells and TWIPs
  352. Variables in Query Strings
  353. Range Question
  354. Range Question
  355. Indication that there is a # cell value in the range
  356. manipulate / perform math on cell location a=a+1
  357. Extract Whole Row If Q
  358. Copy-Past as Pictures
  359. On Got Focus, Clear Cells
  360. Error handling
  361. getting new workbook name from opened template
  362. Worksheet change: move to next cell
  363. Need macro to trim characters in column
  364. Identify blanks
  365. How to backup Excel using VBA?
  366. EXCEL Spreadsheet CELLS have data but load as NULL
  367. Managed code error handling from VBA
  368. Add data from several excel sheets into one
  369. Clean Up without reducing print window.
  370. Auto Copy from Sheet1 to Sheet2
  371. "Compile error in hidden module: Addition" what does it mean?!?!?
  372. Alter macro security level programmatically
  373. Macro question
  374. Microsoft Office Spreadsheet 11.0 Control
  375. Creating a macro
  376. Macro to accomplish Zoom and Fit to Simultaneously
  377. Appreciated!!!
  378. Accessing Message Editor Of Web Based Email
  379. Timer
  380. sending mails from excel...but mail body disappearing
  381. Create Menu Macro
  382. Copying cell border formatting, without shading.
  383. Numeric Value of Choice in Combobox
  384. count comments funtion
  385. Macros
  386. Combining multiple worksheets into a single master sheet
  387. Select Range
  388. Judge whether Excel has password without opening it
  389. LN in UDF
  390. Naming a range in a module
  391. UDF is not working
  392. Conditional formatting
  393. sorting unknown range
  394. Transparent button
  395. fetch the data from sheet2 & place it in sheet1 based on the locat
  396. What's wrong with this code?
  397. how to creat shortcut button to switching between worksheets?
  398. Changing the values of priorities on update
  399. Microsoft Excel Addin
  400. repetitive items in For each loop
  401. Losing certificate details on workbook save
  402. For..Next error 'End if without block if'
  403. Pivot table error
  404. Duplicate sheets by data count
  405. Application makes VBE crash. How do I troubleshoot?
  406. Initialization using Multipage Tab
  407. Send e-mail via macro
  408. toggle or command and how
  409. object button name
  410. Create Pie Chart that changes from one data table with differentyears
  411. Programmatically changing values on grouped sheets
  412. Change Formula's to Values
  413. Compiled Application Crashes
  414. Floating menu to navigate through worksheets
  415. Dynamic userform field names
  416. Slow Procedure
  417. Checkbox Background Color
  418. Selecting a Range with a variable in the ordered pair
  419. Is there a Folder Picker method that shows files too?
  420. copy a worksheet from a closed file?
  421. Send attachment via CDO
  422. Help with search and copy issue
  423. Worksheet_Change event
  424. cell select
  425. Listbox vs Combobox
  426. move columns to separate worksheets
  427. If then else, or select case is giving me a problem
  428. comment copy&past!
  429. sort from date, to date in list
  430. Convert Font.Color to System.Drawing.Color in C#
  431. Range Select
  432. HOW TO MOVE DATA FROM ONE COLUMN TO MULTI ROW - please help
  433. RE: User Form Input mask
  434. Trust Access to Visual Basic Project
  435. disabling chart export progress bar
  436. Repeated search on the same worksheet
  437. How to get Cell.Address from Hyperlink cell
  438. change the color of a cell as a function of the cell value
  439. Update created sheet?
  440. Automatically select correct range
  441. How to rewrite this code? (Second half)
  442. How to rewrite this code? (first half)
  443. help with 3 problems??
  444. Search for Change in a column.
  445. Calculate Time
  446. Dialog to set path
  447. Initializing Userform not working
  448. Check error cell in C#
  449. Formatting with Macros
  450. File size
  451. Column Possible
  452. TRIM Function gives Compiler Error!!!!
  453. furmula to add hours
  454. the value of a condition in a conditional format
  455. VBA question
  456. Same task for Multiple fields
  457. AND/OR in Macro
  458. Move to next cell
  459. Excel Macro - Extract data from website
  460. Changing a formula inside a textbox - Excel 2007
  461. Calling AutoFit using macro in XLCALL.h
  462. Extract rows to different sheets
  463. Save several worksheets into one file
  464. Merging
  465. Error Number: 91 object variable or With block Variable not set
  466. Running a macro from the spreadsheet
  467. C++ Excel Automation
  468. Run Macro from different files
  469. how to set pivotitem.visible property to true
  470. Selecting A Tab By Its Name
  471. Command button
  472. Consolidating Various Excel Files
  473. Sort WorkSheetName unknown
  474. Listboxes
  475. Conditional Formating
  476. vb code to re-arrange data
  477. 2 line headers in excel 2003 spreadsheets
  478. Convert NumberFormat to System.Type
  479. Toolbars GONE!
  480. Specifying Cells To Copy Across Workbooks Not Working!
  481. Ribbon Image Size
  482. Missing relative reference icon
  483. Use Contents of a Cell to Create a Hyperlink
  484. Function instead of "Text to Column"
  485. auto start code when a sheet is looked at
  486. Deleting CommandBar("").Controls
  487. Page Header Macro?
  488. Single Row Count
  489. set print area to last occupied row
  490. Another lookup question
  491. Common Dialog Control Reference problem
  492. set print area to last occupied row
  493. Transposing/combining columns with 2 headers
  494. Pasting and organizing information from one sheet to another
  495. transpose address information for each customer number
  496. Data Validation Pop-downs
  497. Loop help Please
  498. Excel General Ledger Template
  499. html exported to excel when save as, defaults to web page
  500. RANGE
  501. Re: excel multiple choice toggles
  502. how can i automate copying of tabs to a new workbook?
  503. user form and radio buttons
  504. Find and Replace Macro
  505. Calling AutoFit using C API's
  506. Last Real Cell
  507. VBA ReadyState basics
  508. ie Command to Wait for "File Download" and "Save As" windows
  509. Merge problem
  510. Updating Date Field in Pivot Table with VBA Help
  511. IF and ISBlank for a selected range of cells
  512. getting error message 3704 when running excel vba
  513. Macro on Current Row
  514. How to save a project independent of a spreadsheet
  515. Displaying Line #'s
  516. Using VBA: Conditional Formatting of Row Color
  517. Formatting a worksheet
  518. locad password protected MS Access table
  519. Highlighting Rows and Columns with Macro and VB
  520. Column List to Multiple Columns
  521. Change sheets within a read and write function...
  522. Slow tabstrip
  523. Column AutoFit C API
  524. Find next empty row & paste data
  525. FitToPagesWide
  526. ListView - ItemClick - How to know column number
  527. Macro to Edit Contents of Cell
  528. Time Calculation w/ Macro
  529. Export records into a text file based on criteria
  530. Creating a list box
  531. Get numbers from cell
  532. load list data
  533. ByRef argument type mismatch when passing dictionary object
  534. Vlookup to Return Cell Name Not Value?
  535. do loop until empty cell
  536. Overwrite conditional formatting
  537. Problem with IE
  538. Disable Ctrl- PAGEUP PAGEDWN
  539. Find value in sheet 1 and copy matching row from sheet 2
  540. Auto insert
  541. Version Issues
  542. How do you x-late GetTextExtentPoint32's units into the real world?
  543. Can Search's default be changed to "By Columns"?
  544. nested for each or something else??
  545. Excel Add & Substract in One Cell
  546. Check for incorrect characters
  547. Extract Access records to new workbook using VBA in Excel
  548. Extensive file damage.
  549. Add data range to a specific tab based on "Sheet Name"
  550. Tabstrip Tabs Width
  551. Excel VBA functionality and SharePoint
  552. Trust Access to Visual Basic Project - Access to Excel and back
  553. Disabling SAVE AS Temporarily
  554. Sub to delete only all damaged defined ranges in book
  555. advanced lookup feature
  556. vba structure
  557. Conditionally format cells
  558. How do you hide .....
  559. Copy variable to clipboard
  560. exception in excel while writting to it
  561. reset a cell
  562. Re: Splitting up timeperiod
  563. Re: How to generate a text file from Excel using a macro or script
  564. Listbox help
  565. finding UsedRange with sparse data
  566. Outlook VB not working
  567. I protect sheet - Macro will not run now
  568. Excel 2007 ListBox missing last item
  569. Userform - 100 checkbox (10X10)
  570. Select Object Button
  571. stock the header items of a .dbf file into a vector
  572. Is 'IgnoreRemoteRequests' the same as....
  573. Making a [semi] Dictator Application: Hiding Main Command Bar?
  574. Sum variable ranges
  575. VBA...No Subroutine Code
  576. newbie - If a cell is blank
  577. Printing worksheets
  578. identifying multi-select items in a listbox
  579. Dynamically Change Cell Contents From VB
  580. Change Axis Title
  581. AutoFit function
  582. "next and "previous"button problem in vba
  583. Automatic Calculating & Autofil in Various Tabs
  584. loading another application from excel vba
  585. Count positive value
  586. import xml in excel workbok using VBA code
  587. Spreadsheet Component
  588. break apart pdf binder
  589. Blank cells & formula cells
  590. VBA to move and concatenate
  591. VBA to Update Pivot Table
  592. Importing Access to Excel
  593. data entry
  594. help with Run-time error '1004'
  595. Target.Cells.Count
  596. Target.
  597. Bypassing the Security Warning when opening Excel file
  598. Font enlarge/reduce by 1 pt?
  599. Trouble with code that is broken over multiple lines (space_)
  600. Modify the IgnoreBlank property of the Validation object
  601. Difference between two dates
  602. Does a shape cover a cell ?
  603. Macro to Paste Unformatted Text Into Excel
  604. hard time with If InStr(1, ..
  605. clear contents on linked sheet
  606. Combo box the exludes blanks
  607. working with images
  608. How can i automate the response to a generated pop up?
  609. Re: How to generate a text file from Excel using a macro or script
  610. Parameter Driven Query
  611. Lots of similar buttons need to call a macro but need to find outwhich button was clicked
  612. read xml and fill valuesin excel form combobox
  613. Re: Password Protecting/Unprotecting Worksheets using VBA code?
  614. Checking worksheet names
  615. Creating different worksheets from a main worksheet
  616. Clear entire rows below last row of data in col A except in 1st 3 sheets
  617. Loop Till the end of used Cell
  618. option button problem
  619. Why doesn't the FindNext work inside a function ?
  620. Re: Returning column letter
  621. Forcing Move seelction to the right
  622. Re: Returning column letter
  623. Filldown top cell to last row with data in adjacent col
  624. How can I see the Project Explorer and Code window together?
  625. Synchronizing worksheets
  626. How to validate path? --- bValidatePath ("") Then
  627. Activate one Book then another Book
  628. Problems adjusting column width
  629. How to change the background colour on event?
  630. Excel VBA : Find Method
  631. Change rangre color with scroll bar
  632. How do I select an option button using code
  633. Rename active sheet
  634. Read text into Excel
  635. Repost of How to get Popup Text help to work
  636. Hot to Get a Column Number from a column letter
  637. hyperlink in Excel 2003
  638. error running macro from Ribbon button
  639. CONCATENATE preserving original formating
  640. How can I list values in a combo box?
  641. Series order vs Legend Order in Charts
  642. I NEED AN EXCEL TEMPLATE FOR ANNUAL BUDGET CONTROL OF SMALL BUSIN
  643. Worksheet Help
  644. Custom View: hide/unhide does not work when worksheet is protected
  645. Change UserForm font
  646. Enable Auto Refresh Message Box
  647. Turn AutoCalc before calc takes place
  648. Adding help to a user defined function
  649. read datas from XML to excel using VBAmacros
  650. 2008 federal payroll withholding tax
  651. incrementing a cell value
  652. Choosing no when asked to overwrite an existing file?
  653. check box help!
  654. creating hyperlink using the value of the cell
  655. Make active cell a variable, return there later
  656. CreateObject from Template
  657. Formula for Finding Retail
  658. Select first 5 visible rows
  659. Can I find out if & where "Freeze Panes" is set
  660. VBA function wont update in worksheet
  661. Select charts by "Chart Names"
  662. Change Event
  663. annunce: excelmailer 0.2
  664. ctrl-a
  665. excel temp file
  666. Exclude gray figures from sum
  667. TextBox mismatch ..... calculation
  668. Copy cell to empty cells below.
  669. Protects running from VBA, but not from hot key
  670. Hou would you optimize this code?
  671. writing screens to enter data
  672. How to find a matching row and Insert Data
  673. Insert Multiple rows with data
  674. About xml constructing
  675. how do i create a macro that will print and save my file to sharep
  676. How2 accept only numbers in userform textbox
  677. HELP!!
  678. Need user unable to unhide sheets
  679. User Defined Record Compile Error
  680. Disable auto-update
  681. Date Range Macro
  682. Populate Comment on the basis of Text Box Entry
  683. 2007 Ribbon dropdown
  684. Duplicate items in ComboBox
  685. merging cells using VB - Excel 2003
  686. How do I Create a Macro to run VB Code in Excel?
  687. Excel and Calendars
  688. Change text in Textbox on Chart?
  689. protected linked cell
  690. Macro problems: Waiting for site to load and commanding Save todownload prompt
  691. MACRO IS NOT COMPLETE
  692. Spread data and keep format
  693. checkbox
  694. Using VBA to send email to distribution list ... how to CC?
  695. name box
  696. programatically create new worksheet
  697. Apply code to Icon
  698. Find first blank cell
  699. use a range variable in advanced filter
  700. Last Empty Row in Range
  701. "Move or Copy" sheet
  702. Variable not Defined Compile error
  703. Selecting multiple areas
  704. Sheet Protection doesn't hold
  705. Shapes!
  706. Columns ranked by highest revenue
  707. Repost: Copy Range from one wbk to another
  708. Popup box appears based on cell value entered
  709. Copy range from one workbook to another
  710. Uninstall Add-ins when workbook closes
  711. Unhide Worksheet with Login UserForm
  712. Row Headings (cell number) on Rightside
  713. VBA multiple events
  714. Hide/Show Rows based on Cell Value with Data Validation
  715. Activate woorkbook
  716. reset pivot table name
  717. First blank cell
  718. Who last opened file?
  719. Iteration Error
  720. NEED ADDITION IN MACRO
  721. VBA to save a chart as a GIF
  722. Bug applying Borders to Range
  723. Input Box code help
  724. Help in vba
  725. How I can get color (RGB value) from .ThemeColor + .TintAndShade?
  726. Worksheet with some limits
  727. How do I set a range to the currently selected cells?
  728. label to display multi rows and colums on a userform
  729. How to Refer to Another Excel Workbook
  730. Protected VBA vs RibbonX question
  731. How to get Popup Text help to work
  732. min function trouble
  733. How to enter a formula over 250 characters?
  734. Trying to create dropdowns in excel using vb.net
  735. What is the VBA function to return the greater of two integers?
  736. Value transfered to cell differs from value in record set
  737. Keep Losing VBAProject
  738. Amend sub to re-hide comment when activecell change to another
  739. Code not working since upgrade to 2007
  740. Application Maximise event
  741. HELP - Vlookup with referenced tab name
  742. Help with an IF Formula
  743. If B1=Level 1 then B2=10
  744. If b1 = 1, then b2 = Yellow
  745. Formlua Entry
  746. Using ADO to import Access table
  747. Conditional formatting cells with formulas = "DIV/0!"
  748. using the calendar on a userform
  749. Advanced transposing in Excel
  750. countif formula
  751. surpress leading and trail spaces
  752. Finding max value
  753. Loop Through Combo Boxes on Worksheet and in Workbook
  754. PT - list multiple page field selections
  755. exit sub if no data
  756. Usage of StockQuote.MSNStockQuote in excel vba code
  757. How to show zero values in conditional sums
  758. Add code on the fly to existing userforms
  759. writing to a table in wrod from excel
  760. PRINTING PAGES !
  761. Select or Enter into a TextBox on a UserForm
  762. Date format text conversion
  763. Linking to specific pages in a PDF
  764. removing comma in data string
  765. Help with code: Web query for security agreement
  766. Error for loop
  767. outlook and excel
  768. exit for loop
  769. copy access table in to cells comments
  770. Linking from a Combo box to another excel file's specific workshee
  771. userform
  772. Get parameters to create existing chart
  773. How do you do this?
  774. Creating Lookup User Form
  775. On Error GoTo .... error
  776. command button code needed
  777. Trouble changing Range destination
  778. Print Range
  779. Retrieving hyperlink from cell
  780. macro for mail merge automation
  781. ThisWorkbook.VBProject.References
  782. Excel Help
  783. Hover-over Function
  784. AllowEditRanges
  785. Attn: Barb Reinhardt
  786. VBA Tutorial problem
  787. Build DateSeries (?)
  788. ThisChart function similar to ThisWorkbook (XL2003)
  789. Excel and COM
  790. Updating tables in Access
  791. Document Manager Toolbar
  792. User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation?
  793. Excerise with Days Off
  794. Formula problem
  795. Please help...
  796. =SUMPRODUCT but need to break out Jan 07 and Jan 08 results
  797. ChangePivotCache
  798. dynamic print ranges ...
  799. Ping via VBA
  800. script to increase last number in cell entry for hyperlink
  801. Lookup variabel field in variabel sheet
  802. Copy paste different columns (ranges) to word
  803. Unable to disable macro
  804. Scalar Multiplying VBA Array
  805. userform and inputboxes
  806. Sheet sub to centralize comment display on mouse over
  807. Multi-threading in VBA
  808. Displays numbers as $ on a form
  809. auto filter based on color
  810. hiding excel
  811. Pivot Table Pivot Item Visible - Why so difficult
  812. find the matching and supply the quantity
  813. find the item and supply the required quantity
  814. Apply a macro to only one sheet
  815. cell list from access table
  816. adv: Designing reports in Excel
  817. Upon error close workbook
  818. Changed variable value
  819. multiple text files to multiple rows in excel
  820. Finding exact date
  821. using excel data to create multiple web pages
  822. Basic combobox question re setting values
  823. centering checkboxes vertical in cell
  824. Macro Looping Problem
  825. Loop or If then Question.
  826. Highlight text in Textbox
  827. Error data mismatch ??
  828. Problem with Public Variable value being changed.
  829. Vlookup Error
  830. Copy from 1 worksheet to multipule worksheets based upon worksheetname
  831. run access macro from excel pass parameter
  832. Total beginner
  833. Pausing Code
  834. Extract string from cells
  835. Insert Matched Value
  836. Data input and database record using macro's
  837. how to hve input box on msgbox
  838. copying formulae down a column
  839. Programmatically Open Locked VBAProject
  840. Area of freeform shapes
  841. Problem with Userform
  842. Shift-tab in keydown event
  843. Formula to count Month in Dates
  844. excel dates in sql procedures
  845. How to simulate Control (button) and Mouse Selection of cell
  846. How to count items depending on attributes in VBA
  847. How to print data in a text box
  848. out of range message
  849. automatically copy information to different sheet if certain condi
  850. Resize msgbox windows
  851. interactive message with mouse selection
  852. import access table to excel spreadsheet
  853. Weekly Totals
  854. Value between 2 values
  855. Item Count
  856. msg box 2 add and see data
  857. find the matching and allocate the required quantity
  858. M I.5 Persecuti on , why the s ecurity s ervices?
  859. sort using forms button - cycle thru 9 columns
  860. Code assistance
  861. Userforms Won't Close
  862. Can't Adjust the Screen Image
  863. Running an Excel AddIn from Access in Current WorkBook....Help!!!!
  864. Trimming Characters
  865. About Naming MSForm in VBE.
  866. Data Update Loops between Folders
  867. Stop Save as code
  868. Transfer flat file to a Shared folder.
  869. Update sheetname from cell, automatically
  870. Subtotal macro and delete original data
  871. Prevent duplicates in ListBox
  872. List files in Folder if Condition is Met
  873. UserForm not displaying
  874. Expert in Macro
  875. BLINK CELL COLOUR OR TEXT BY CONDITIONAL FORMATTING
  876. Disable custom menu item based on visible cells
  877. Help files
  878. Mandatory Cell check on multy page workbook
  879. Textbox for accepting TIME
  880. M I.5 Persecutio n ' abus e in set- up situati ons an d in publi c
  881. M,I-5,Per secution Ber nard Lev in expres ses h is views
  882. How Excel VBA corporate with MSN Alerts?
  883. M I.5 Persecutio n , Be rnard Le vin exp resses h is vie ws
  884. M I-5,Persecut ion c ost of t he operati on
  885. Sheet name, creating dynamically to be used in formula....
  886. M I`5,P ersecution , C apital Rad io - Chr is Ta rrant
  887. M,I`5 Persecu tion bu gging a nd counter-surveillanc e
  888. Link the ListCount to a Label automatically.
  889. Quick text key to format 2 cells
  890. msg box to display specials
  891. pop up msg box
  892. sub to delete all sheets other than x, y, z
  893. How to get back values in the excel bulidin dialogs ?
  894. Automated Forms issue
  895. PowerPoint export to Excel
  896. Protecting sheet in a macro doesn't work
  897. Data Link
  898. repeating formulas
  899. rows
  900. Pulling cell value into macro
  901. Showing large image in Excel ribbon UI
  902. Copy and Paste down the column
  903. Type Mismatch Help
  904. embedded Excel sheets in Word documents
  905. Linked Data Validation(s)
  906. Need help with Macro
  907. Unloading /Closing all userforms
  908. Convert Columns to Rows based upon a duplicate value
  909. Array formula acting as it shuld ... but
  910. Data Validation and a Clear Button
  911. COMBINE TWO MACROS INTO ONE
  912. Named Range Formula
  913. Searching online behind the scenes
  914. Ignore breakpoint when running a macro
  915. Specifying Row to Copy Across ?
  916. .formula property bug?
  917. HOW TO MIX TWO MACRO CODES
  918. Insert Date in correct cell
  919. toggle borders
  920. listbox remove item according to the value
  921. Run macro when file closes
  922. active sheet is 'slow' to be active
  923. dilemma with getting sql data
  924. Workable Scatter Plot Data Points
  925. grid on user form
  926. Split ActiveCell.Value and delete element if.........
  927. Dynamic Range
  928. Where to put code
  929. "UpdateLinks = 3" not working?
  930. can't select worksheet
  931. How to evaluate string form of numeric expression in VBA?
  932. assign macro to button programmatically
  933. Enable Excel Speech
  934. Problems with autofiltering and dates I think
  935. Don't want backup copy in XLSTART
  936. Endless Loop - Shortcut Key To Stop Code?
  937. Drop List
  938. Text Box Change Event
  939. recalling named ranges as must fill cell
  940. how to connect pictures from an excel sheet to a power point slide
  941. Drag-n-Drop_XLA_Install (VB Script)
  942. Drawing across Data from different workbook using long list.
  943. Importing Data - 2
  944. Importing data
  945. xl probs.
  946. Zoom to fit the page width
  947. check criteria and run macro
  948. go and check on spesific page and then run macro
  949. protect sheet with password
  950. Can not access MS Visual Basic Documentation
  951. Changing font color based on positive or negative number
  952. Formula / Football Pool / HELP
  953. Football Pool Fun HELP
  954. Match function in VBA
  955. color number list????
  956. Automated Build -- auto import of .BAS module into XLS or XLT?
  957. Having difficulty with scroll bar in VB
  958. code to choose tab color?
  959. IF Condition in Excel
  960. Function To Combine two 3-D arrays
  961. how to make a function(vb script) global (as in used from every w.
  962. Cell formating
  963. Opening explorer using VB
  964. Macros in Formulas
  965. Speed the macro works
  966. Updating time made by macro in excel
  967. Excel Form HELP
  968. how do I add vba reference to Microsoft Forms 2.0 Object Library?
  969. For Each Ctl In Me.Controls
  970. Userform - need to access data from a particular sheet
  971. small easy userform
  972. if then else
  973. delete rows
  974. Alternatives to "WorksheetFunction.VLookup"
  975. Hiding rows with zero values
  976. automating import of several text files from specified folder
  977. excel macro in '97 does not work in Vista
  978. Need help with userform vb code, any help would be appreciated.
  979. Add help or help file to a user defined function?
  980. Macro to insert at correct point
  981. vb add-in manager is empty
  982. solve for a variable
  983. Help with find/replace
  984. Format sheet programmaticlly??
  985. Help for VBA Functions
  986. Macro Path
  987. Search worksheet from add-in
  988. Change Text size on focus
  989. how to format a date to be used in sqlstring in excel 2007- contd
  990. Pivot Table Macro
  991. Deletions
  992. Shapes(Count)
  993. Search code help needed??
  994. Center Checkbox
  995. Macro Path
  996. Need Text box value to be $5,000.00 not 5000
  997. Code to copy cell borders and fill color from one cell to another
  998. SpecialCells(Formula) --> Value
  999. Dynamic data in PivotSelect statement
  1000. Copy date from row 1 to last row next sheet