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. ADO read of Access...
  2. Cannot get message box to show
  3. Investor's Knowledge Analysis
  4. Opening a file from another file
  5. Search for calculated duplicate using worksheet events - Possible?
  6. Re: calling xlfEvaluate/xlUDF in an xll
  7. Copying Worksheet from one workbook to another
  8. Copying Worksheet to new workbook with VBA
  9. Unique combinations of records in a list
  10. position of inserted picture files in Excel 2007
  11. Copy & paste rows after found text to different wb and delete them
  12. Extract Comments to Cell and search with AutoFilter
  13. Another 'Last cell in column' question
  14. System Date - Network
  15. Excel2003 - possible to lock/protect individual cell(s)? maybe wit
  16. Pulling text from the right end of a string
  17. Copy charts to powerpoint
  18. Sub Total in worksheet or SUM IF function
  19. pulling in a table with formulas
  20. VB Cond. Formatting of Formula Cell
  21. paste into destination w/o overwriting existing
  22. How can I specify which cell has focus?
  23. Strange error when changing locked status of cells
  24. Color Index for light yellow & Code Help?
  25. Finding and highlighting duplicates across multiple worksheets
  26. Upload Data from Sheet1 on Local Machine to Sheet1 on LAN
  27. Puvot Refresh
  28. Moving from VBA to VSTO
  29. VBA Book
  30. Adding many textboxes on Form
  31. display problem with listbox
  32. Excel bypassing Word password
  33. Bug in Excel 2007 using Names/Ranges?
  34. Bug in Excel 2007 using Ranges/Names?
  35. Unprotecting a Workbook before exiting
  36. Open file ready only
  37. Count font colour in a cell
  38. Dynamic property names
  39. Wookbook speed
  40. How to email an embedded object
  41. Change A Line in A Module Using VBA Code
  42. Run a macro if file is a template
  43. Chart Window's class name in Excel 2007
  44. Re: Locking cells in Auto filtered list
  45. Range statemeny query
  46. Cleaning file
  47. Re: Locking cells in Auto filtered list
  48. Public Variables
  49. Need Help to Control the UDF from re-calculation
  50. Pulling cells from multiple reports into a new column
  51. Enabling Turst access to Visual Basic Projects
  52. Locking cells in Auto filtered list
  53. Update links automatically when opening file
  54. how to call excel.range.errors in vc++
  55. Returning the name of a module
  56. 'Trusted Publisher' under Vista
  57. Macro attached to Menu Command Button
  58. File opens another file runs macro and closes
  59. E-mailing a worksheet only from a workbook
  60. Drop Down Box
  61. Separating a master file into many workbooks
  62. Total or summing in a workbook within a folder
  63. Charts
  64. Move row of data from one worksheet to another
  65. Creating CSV for every Excel Tab
  66. registry setting to disable save warning for csv file
  67. Conditional formatting
  68. How to find all folder and/or files in a specific location
  69. Help with VBA programming for a new user
  70. Excel Formula's
  71. Report of Margins and Worksheet Setup?
  72. Pop-up
  73. Tools->References greyed out
  74. Why won't this sheet delete?
  75. Cell content limitations...
  76. If filter results in blank cells, skip to next part of program
  77. out of memory errors
  78. Switching sheets while timer running
  79. nested if not working not sure why Help!! Please
  80. Creating spreadsheets for managers with mutiple tabs
  81. Finding every instance of a value in a multi-sheet workbook
  82. How do I change the reference in a formula based on a logic test?
  83. Bracket
  84. Run code on "IF" formula result change
  85. Add Hyperlink
  86. Read cell value of xlVeryHidden sheet
  87. comparing times
  88. Count cells every 12th column?
  89. Used range row count throwing up a wierd result, slects wrong as well!
  90. .ldb question
  91. Interier Worksheet Formating for Rows.
  92. Arrays
  93. show intersection of data
  94. dropdown control
  95. Macro to change file properties
  96. Need to skip warning
  97. Globally Named Range Problem
  98. Copy Insert Paste into all Workbooks in Folder
  99. Moving an entire range and a for loop question
  100. Macros and merged cells
  101. Sync Button
  102. ByRef Argument Type mismatch
  103. Conditional Formatting- Refresh
  104. Copying filtered data
  105. Excel macro is recognised as a virus
  106. Run-time error '1004': The PivotTable field name is not valid....
  107. String Comparison
  108. Find and copy down Macro
  109. Cursor Shape
  110. Pop up reminder when closing Excel
  111. why xlcShowToolbar cannot run succeed?
  112. Problems with Trigger sequencing and disabling events?
  113. Textbox inserted on an Excel sheet does not allow TABINDEX or SetF
  114. Find/Filter highlighted cells
  115. Checkbox
  116. How to populate a Pivot Table using VBA code?
  117. Show all data in Pivot Table
  118. Problem with Workbook Protection Excel 2007
  119. Macro Question
  120. How do you give a user the choice of printer
  121. Copy and paste formatting and values only
  122. File size and pivot table refresh problems
  123. File Search
  124. Run a code on a workbook?
  125. !
  126. Excel automation: How to access XL sheet as the second task?
  127. Which ComboBox?
  128. Interior and font color change based on value
  129. Adding Menu Buttons
  130. Installing unwanted Excel features during automation
  131. Scroll Wheel, Excel and VBE Weirdness
  132. Delete columns
  133. Before Workbook Event, Custom Calculate a Specific Worksheet
  134. more on interior.colorindex issue
  135. grid lines
  136. For Each...Loop using Pages in a Multipage Control
  137. Input Box
  138. Case query
  139. increment cell value based on another cell's value
  140. Re: User defined function
  141. Activate?
  142. Automatic Protecting Question
  143. How to transferred data from one workbook to another
  144. Reference to Sheet Name When Copying Worksheet
  145. empty range causes error
  146. Range Reference When Copying Sheet fm One WB to
  147. Hyperlink Help - want to link to diff sheet, looking for name cursoris highlighting
  148. Copy
  149. Trailing number on Named Region
  150. Automatic Return When Choosing Drop Down Menu Sleection
  151. Delete cell entry and default contents are restored, for multiplerows
  152. Adding Data Fields to Pivot Tables
  153. Unhide depending on selection
  154. Close button on form
  155. formatting cells with boolean values
  156. Copy .xls betwen local disk and https:// location
  157. placing limits on ubound, and lbound
  158. passing array reference to sumproduct formula-???
  159. How do I create a formula to add hours to a mm/dd/yy h:mm format c
  160. Automatically show Standard deviation in a selected range
  161. Add comment, and move up
  162. show value of formula
  163. Abandoning changes in workbook
  164. Return name of excel addin .xla
  165. Worksheet name in cell
  166. Need help with Excel worksheet
  167. Case sensitive VBA function
  168. gray - blank sheet issue
  169. Defining array size when it is dynamic
  170. typing in one cell automatically brings up something else in next
  171. DIR fn when filename has non-ANSI characters
  172. Save workbook inplace
  173. Changing Orders
  174. Change properties of a multipage
  175. Fill ListBox as per number of Records in the sheet.
  176. Help needed with Macro designed to compare data...
  177. How do I adjust a combobox once I've Programmed it?
  178. Simple line error msg
  179. Tab Code Retrieve a Value
  180. Compile error: Automation error in Excel 97
  181. Help with Code
  182. Vlookup Help :)
  183. Mouse using "Right click to paste"
  184. Finding next empty row
  185. Excel and SQL question
  186. call to macro in xlam from macro in xlsb
  187. Follow up question. Get value of closed file.
  188. vLookUp return several columns?
  189. Jarek, almost there...
  190. Copy data from one tab to another based on cell value on one tab
  191. ReadLine in Reverse
  192. Combo Boxes as data source for a grapgh
  193. Test if a file has a password
  194. screenupdating=false not working
  195. HELP=>What Is Wrong With This Code ?
  196. Kill all files in folder
  197. Tab sort
  198. run-time error
  199. Moving Information from AD to Excel Using VBScript
  200. Macro to copy A1:d1 if Column A has total spend
  201. Using the calculations of excel in a word macro
  202. macro to delete certain results
  203. A Dave Peterson macro
  204. renaming a Named Range in multiple workbooks
  205. Excel 2007 PrintPreview
  206. how to make a cell value increment every time a new worksheet is o
  207. VBA code for moving data from even rows to columns after data in oddrows
  208. Userform in Before close event of workbook
  209. Nothing happened while trying 2 export Infoworks Reports to Excel
  210. Worksheet Linked with flags
  211. Object Required Error
  212. Macro will not work in protected Excel 2003 Worksheet
  213. Finding a matching value in another file
  214. Macro stopping and starting.
  215. looping formatting multiple sheets
  216. Macro speed change when closing file
  217. MACRO
  218. Play wav file / comment displayed
  219. how to add comma to a formula
  220. Multipage Pages will not show controls when enabled
  221. Event after update / calculation
  222. Solver
  223. message box choosing a date
  224. When excel launched through automation, not running custom toolbar
  225. Formula in pivot table
  226. How to get looping VBA code to respond to events on worksheet
  227. Comparing several rows of data for 1 record
  228. Copy a page from an xla file
  229. Messege boxs
  230. Problem protecting workbook
  231. Macro to hide rows based on criteria
  232. Bad PasteValues Operation with date
  233. Word Wrap In UserForm TextBox
  234. Help with Pivot Table
  235. Error 9 when launching add-in userform from Ribbon in Excel 2007
  236. Carriage Return Characters - Chr(10)
  237. Suppress display of Print Control Characters
  238. EnableDataValueEditing=true and copy & paste
  239. PageSetup is slow: Revisited
  240. Re: Integrate Outlook with Excel
  241. Enter Today's Date In A UserForm TextBox
  242. Match a cell in a range to a value from another sheet and select r
  243. exporting to Excel without overwriting the macros
  244. Setting Cell Values???
  245. Data Validation - Dependent List
  246. Copy Range to new Range and keep DATE format??
  247. Entering value into cell via VB code if cell is empty
  248. Defining a range
  249. Partition data range by an indicator variable
  250. search and replace data
  251. Re: Strange problem with HPageBreaks
  252. HELP => VBA Code To Import Worksheets Into A WorkBook
  253. Highlight certain text for the entire workbook.
  254. Beginners help
  255. unload userform
  256. Macros Disabled
  257. Pass a cell address - Modify interior font
  258. How to get user to select cell
  259. Mass change Hyperlink reference
  260. Color cells if
  261. Not getting ".0" in tenths in calculation?
  262. Print the WebBrowser Object
  263. using a macro to edit the data range of a chart
  264. Copy Fomulas down
  265. naming sheets
  266. Has anyone developed or is using inkeeping templates?
  267. program ok command button
  268. Office 2003 SP3
  269. Office 2007 SP1
  270. close/open workbook without prompts
  271. VBA limit from sheet to several ranges
  272. Textbox
  273. Prevent code running
  274. How to desensitize the "X" on Inputboxs, Textboxes and other gui's
  275. How to desensitize the "X" on Inputboxs, Textboxes and other gui's
  276. Select cell after last row in selection?
  277. XLL Help
  278. function doubt
  279. Help Required 4
  280. code for a formula
  281. Search and change font color to Red and bold it
  282. Macro to delete ROWS in a spreadsheet using Text file
  283. Problem with pivot table when workbook is protected
  284. Reference books
  285. Delete text when font is color black
  286. VB Array - Select column
  287. delete coding for excel 2007
  288. Passing an array in a user defined function
  289. square root
  290. How to get a reference to the Excel application inside a classimplementing IRTDServer
  291. Loop through worksheets
  292. Load Values from a Range into a List Box
  293. HELP W/ VBA: SELECT RANGE, ALLCAPS, CELL COLOR, RETURN TO BLANK CELL/PATTERN CELL
  294. Comment / wav file
  295. Excel VBA reference docs?
  296. Re: Sendmail and Lotus Notes trouble
  297. How detect if any workbooks are open?
  298. MOD function results
  299. Send Data From Active Sheet to Closed Sheet on Network
  300. Re: Sendmail and Lotus Notes trouble
  301. interior.colorindex does not work?
  302. how to find URL in Excel 2007
  303. RE: Macro Not Running in Excel 2007
  304. email
  305. Re: Macro Not Running in Excel 2007
  306. VB script email
  307. How can I execute Shape drawing Excel 2007?
  308. Quick Help!!! - remove character at position "X"
  309. Using a WILDCARD (%) in the SELECT clause
  310. Macro runs faster when VB code window open
  311. Using Get with very large file
  312. Calculating Number of Rows for Merged Cell Text Wrap
  313. Re: Paste Value into separate workbook
  314. Re: PivotCache.CommandText
  315. pdf to excel
  316. Re: Macro 2 insert formula if part of cell contains specific text
  317. Followup to Dave Peterson search routine from 4/15/08
  318. Can I change the format of numerical & specific word referenceswithin a cell?
  319. Returning FileLen with very large file
  320. formula
  321. incredibly dificult formatting problem
  322. Re: Generate Excel Scatter Diagram
  323. Re: VB Chart
  324. abt computer operator
  325. RE: ClearContents terminating macro - using 2 workbooks
  326. using if formula on page 2 to post answer on page 1
  327. RE: Find 2 values in adjacent columns simultaneously
  328. XLL help
  329. Average of cell values - Ignore if 0
  330. Other program disabling my custom toolbar
  331. Dual Code
  332. Conditional Formatting for a row
  333. select case issue
  334. Move data from text box to cell
  335. Microsoft Excell
  336. Re: Generate Excel Scatter Diagram
  337. Get data from browser
  338. timer issue
  339. Re: Problem with find function
  340. Re: Macro 2 insert formula if part of cell contains specific text
  341. How to set primary key property in a column
  342. Re: Stop / Pause a Macro using Pause button
  343. Re: RegExp & VB Noob Qs
  344. Loop not working properly
  345. How do I get this macro to start the search in the second row
  346. Export Excel Data to Xml Output
  347. Excel - oleDB - DataSet
  348. Gaussian de-convolution
  349. Stop looping macro
  350. VBmodeless user form errant behaviour
  351. Set an Add-In to This Workbook module
  352. Command Button
  353. Find top 10 items in a range
  354. Custom Toolbar Add-in
  355. Here's a big ask
  356. Excel with OLEDB and Ado.Net - Single quote problem(')
  357. Filter First Record
  358. Putting text together from 3 cells
  359. Call Outlook Contacts from Excel Userform
  360. Excel spreadsheet still pointing to old server after server move
  361. Error 1004 after copying 84th worksheet to a new workbook...
  362. Macro: how to create label forms inside the worksheet not userform
  363. save\change sheet name
  364. Automatic GETPIVOTDATA formula generation from within VBA?
  365. Excel 2007/Excel 2003 compatibility
  366. Ignoring cells using IF
  367. Text String
  368. Copy two ranges without the interval rows to the email
  369. Select the current region excluding the top row
  370. Changing colour bases on another sheet
  371. Any help is appreciated Creating New files from One File
  372. Comparing data in columns for Non-Matches
  373. Problem with Subs and If's !
  374. Learning VBA-don't understand error message
  375. macro opening too many files at once.
  376. Inverse prediction
  377. Array() function whacks out Excel 2007
  378. finding duplicates
  379. Accessing the excel 2007 context menus...
  380. Help needed with Modifying 2 Macros
  381. Merging cells
  382. Best way to wait
  383. Countdown Timer Followup
  384. Permission denied when copying file
  385. range row
  386. automaticaly change script
  387. Automatically hide/unhide rows
  388. Cell Reference Changes According to Project
  389. Clean up code and port to Mac
  390. Access converts "!" to "$"
  391. Ignoring Cells through IF Functions
  392. Automate Excel export to a CSV file
  393. Update a range in a sheet click event (Excel 2003)
  394. Multiple criteria for moving a row to new spreadsheet
  395. fix basic macro to filter blank data
  396. Copy active sheet tab
  397. VBA and Office Question
  398. Paste just the Value
  399. Name Issue
  400. Has the Excel 2003 OLE model changed over SPs?
  401. Large & Vlookup functions
  402. Icon on Taskbar
  403. Concatentate A1:AZ1 separated by ~
  404. Hiding Data points Equal to Zero
  405. Help needed with Very slow code Please
  406. Adjustable Axis in Excel 2007
  407. Visual Basic Chart Objects array
  408. Delete all Blank Rows from data table
  409. Combining multiple like's with Or?
  410. Understanding R1C1
  411. Found a workaround
  412. Merging two files with different time stamps
  413. Sorting numbers
  414. copy data from new worksheet to master list
  415. Sorting text strings
  416. Clear status bar message in bottom left hand corner
  417. worksheet_change help
  418. Importing Sheet
  419. Importing Data into an Excel sheet-template
  420. Copy cell based on unique value - alternate rows - into 1 row,....
  421. Copy cells up - based on ID??
  422. How to search for "#N/A" in Excel VBA
  423. Excel 97
  424. V2003 Macro not working in V2007
  425. Copy rows with today's date to new sheet
  426. VBA Excel range name test
  427. How to sort
  428. Want to auto filter with date on daily basis
  429. Controlling Auto filter
  430. Data need to be copied as per sheet name
  431. SaveAs Type Problem
  432. compatibility issues w Excel 97-03 to 2007
  433. Changing color
  434. Halt / Stop processing when a user selects Cancel
  435. About Application.OnUndo again
  436. Re: PageSetup is very slow
  437. Auto Right Click
  438. Custom Right Click
  439. VANILLA ICE FANS ONLY
  440. Macro for event procedure
  441. Drop down menu / list
  442. separate data with extra column
  443. Naming Of Sub Procedures
  444. Pulling data from Access
  445. Maximized Workbook
  446. Unique records excel
  447. Greater than less than in a find function
  448. Xors and byte arrays
  449. Need equivalent code for 2007
  450. Excel App gets focus
  451. named range/offset
  452. EOMONTH not allowed in Array Functions?
  453. How to do something in an VBS script for all worksheets of an Excel file?
  454. how can I delete rows based on column value
  455. Followup to RonDB "Modify Copy4" discussion from June 19th
  456. Selecting data in tables, if not given then interpolating
  457. sum true/false
  458. My Macros will not work after I protect my document.
  459. Deleting pasted HTML controls with Javascript
  460. DNS-Less Connection String
  461. Watch Window disappears and not available but Immediate and Local
  462. Huge spreadsheets, anything I can do?
  463. foce region to print on one page
  464. Copying modules from one sheet to another, in code?
  465. loop?
  466. Can excel convert a date to text
  467. VBA code for check boxes in a form
  468. Refedit
  469. Closing application problem
  470. adding bold to formula cell
  471. Using IF to refernce another cell
  472. Application event for Chart selected/activated?
  473. Radio Button Selection on Auto Open
  474. "If" Formula in VBA
  475. Dynamic Range
  476. changing constants
  477. Dim cht as Object Constant Declaration
  478. Reason to Answer Questions in this Forum
  479. is there an easier way to update?
  480. Opening file cause rows to lose
  481. Close UserForm by pressing Esc key
  482. Create Function which returns an Array
  483. Worksheet_Change
  484. Blinking Text in the UserForm
  485. Convert numbers to words, 3=ship, so if I enter 3, it says ship.
  486. Reorganising Data
  487. How do you trigger an "On Click" event programatically
  488. Need help converting macro from 2002 to 2007
  489. Conditional Borders through a Macro
  490. VBA - entering a formula in excel
  491. Macro to copy from another workbook
  492. Userform
  493. Fill Color
  494. conditional formating bold is true not bold false how
  495. Test if macro is called by another macro
  496. How to search in VBA?
  497. Macro Textbox accross worksheets - wont work!
  498. subquery to keep maximum date
  499. Activate Condition When Another Cell Is Selected
  500. Dynamic Sorting Lists
  501. text wrap is not stable
  502. show all data issue
  503. VBA help for simulation
  504. Having trouble changing the Locked status
  505. Excel VBA help to test the activecell.value
  506. Option Private Module
  507. control excel in c++
  508. Problem to use Excel remotely
  509. VERY tricky timer question
  510. Full Screen
  511. ADO read to and array
  512. Update database from ODBC query (or another method)
  513. How to Remove Duplicates and Replace with Blank cells in excel ?
  514. Unable to set the Visible property of the Worksheet class
  515. Need help reversing a formula...
  516. Help With Pivot Tables
  517. COMBINING WORKBOOKS
  518. ControlSource question
  519. Prior macro not working in new location after some alterations
  520. Force a SaveAs
  521. Calculate age in years and month or decimal
  522. Need urgent help with VBA 2007 CHARTWIZARD method !!!
  523. Hiding rows with merged cells
  524. Excel files
  525. Userform and textboxes
  526. For/Next Loop
  527. search method
  528. Rows won't hide?
  529. Application 1004 error
  530. Inserting colon as text
  531. If Function ignoring rest of formula
  532. Hide Every Thing during UserForm Loads
  533. Code fails after upgrading to Office 2007
  534. COM Shim in VS 2008?
  535. Radio buttons: "mutually exclusive" property?
  536. Calculating average of percentages
  537. Simple Chart name modification Not working
  538. Calculating once, daily
  539. Copy conditional format from one sheet to another using VBA
  540. Changing tab color continued
  541. Extracting values from Freeform shapes
  542. Option Buttons and Combo Bars
  543. Makro from value in one cell, hiding columns in another sheet
  544. I have no idea how to start this.
  545. Looking up a table value based on two conditional option buttons
  546. Calculating Difference between ranked values within random range
  547. VBA help
  548. No idea how to start this.
  549. Delete worksheet if cell is empty
  550. Requiring "Explanation" when changing number in cell
  551. Workbooks.Open using Dialog box
  552. How do I change the dates?
  553. Macro to change color of tab based on color of cell
  554. Default autofit contents for comments in excel 2007
  555. Center Text on Point
  556. dependant summing
  557. how to Hide/delete dynamically created button?
  558. can excel automate text-based screens?
  559. Close a particular Word file from Exce;
  560. Another User
  561. Countdown Timer
  562. identify selected worksheets
  563. Two Monitors
  564. HLOOKUP problems
  565. Worksheet_Change event problem
  566. Simple Macro help
  567. How do i copy a sheet from one workbook to another using VB
  568. Workbook_Open operates correctly in single step but not when run
  569. Selecting Contiguous Ranges on a Sheet
  570. Mapped Disk Full Error Message
  571. Automation Interface use
  572. finding transverse cell in excel
  573. splitting a string
  574. Input box question
  575. Pivot Table Type Mismatch when More than 65536 rows
  576. Chart Axis Modification
  577. Addition of user functions in function wizard.
  578. Look up - HELP!!!
  579. BubbleChart XP vs VISTA
  580. Sheet Within Sheet
  581. repair hyperlinks / testing for invalid address
  582. How to programmatically add a non standard custom cell format
  583. debug automation add in written in VS2005 for excel 2003
  584. cycle through checkboxes
  585. Displaying possible combinations
  586. Pivottable refresh problem
  587. how do I get formulas to recognize case sensitive text
  588. calling a worksheet function from another worksheet in same workbo
  589. HOL for Excel 2007 Programming
  590. Pivot Table selection lists retain old values and are not re-sorte
  591. Refering to a particular cell in a Named Range
  592. increment time
  593. Visible countdown timer
  594. Excel Header formatting with a programmed field
  595. Spreadsheet column width from html
  596. month name
  597. insert picture
  598. PHP script
  599. Draggable Navigation Map
  600. Macro/VBA code to compare lists & highlight similiar items
  601. Dynamic Sumif of Sheet1 into Sheet2
  602. Excel-Auto Sort and Paste to new Column
  603. Big SUMPRODUCT problem
  604. Advanced Filtering and Data Entry
  605. HELP -> Perl 'Hash' Functionality Required In VBA
  606. Check Digit formula
  607. worksheet change event only if cell was blank
  608. Crop pictures in excel,,,
  609. Disable a message box
  610. Re: Save to CSV macro crashes Excel 2003
  611. Re: Save to CSV macro crashes Excel 2003
  612. Sort an array to use in a listbox on a userform in Excel 2007
  613. need help formatting text in macro
  614. login userform with change password
  615. PDF Object Model in Excel 2007
  616. AUTO FILTER WITH VALUE IN CELLS AND COPY FILTERED DATA TO NEW FILE
  617. how do i auto filter with value in a cell
  618. auto mailing of selective range as attachment
  619. skips controls
  620. Good article on Microsoft
  621. Suppress Delete Sheet Warning
  622. Clear Contents Macro
  623. Automation add-in (UDF) not loading when Excel invoked programatic
  624. Look down column and enter blank row and color grey
  625. Array Declaration Problem ??
  626. Interactive spreadsheet column select
  627. Re: Data update
  628. color row using macro..
  629. How to delete the content of Excel cells from VBS script?
  630. is activating a hidden worksheet a no-no?
  631. Dependant List
  632. include links/css in web page?
  633. How do you insert rows in a sheet that has a PivotTable
  634. Is there a write-multi-cell-at-once function in VBS for Excel?
  635. Error 2042
  636. Macro to automate simple routine
  637. what does this mean?
  638. InputBox Cancel Button
  639. can someone tell me what this means?
  640. Progress from Stored proc in Excel
  641. getting value of named range
  642. Fill in zeros within a specified range
  643. Hide Column based on Cell Value
  644. Merged Cells Causing Problem in Macro
  645. Combining Data from Multiple Worksheets into 1
  646. GetSaveAsFilename - file name is blank
  647. How to proceed
  648. Conditional text boxes on Form
  649. Userform appears behind other application
  650. CutCopy mode goes to False
  651. Excel PivotChart Field Buttons
  652. Pound NA problem
  653. VB6 COM Add-In Ribbons defined in customUI XML not appearing
  654. Save as from right click menu (a bit off topic)
  655. Print Page Set up
  656. Timesheet Date Populating Problem
  657. Excel Automation
  658. Sumif Range to new Worksheet
  659. Dynamically Changing Pivot Data Fields with a Macro
  660. Workbooks.Close
  661. Matching Ranges
  662. Disable or hide Cancel button on Save dialog box
  663. A formula that's different on every row
  664. Como se realiza isso?
  665. Loop through image controls on worksheet
  666. Transpose paste with space
  667. Changes to Excel 2007 VBA
  668. "Condition" format based on Font color
  669. CommandbarButton.Execute method not working for drawing shapes
  670. Find Value of cell in another sheet
  671. Cancel save dialog box
  672. More about trying to automation multiple Excel instances
  673. EXCEL PROGRMMING OR MICROSOFT PROGRAMMING QUESTION
  674. Saving file overwrites AddIn
  675. Copy Patse Macro
  676. Click the Step Into button via code
  677. IF AND THEN Statement problem
  678. Posting in each row of a Summary sheet the sum of corresponding itemson another sheet
  679. In VBA, bump to next row each iteration
  680. Arrays
  681. insert cell value into string
  682. Application.FileSearch 2003 vs 2007
  683. Adding date to a column in Excel
  684. Clear a sheet.
  685. Managed UDF Cannot Call WCF service?
  686. Hooking the FileOpen Event from the OfficeMenu in Excel 2007
  687. CommandBars in 2007?
  688. Need help w using custom image for custom toolbar in Excel 2007
  689. TreeView - How to add + and -
  690. Close a form when you click outside of the form
  691. Code to list concurrently open workbooks
  692. Duplicate Rows Based On Cell Value?
  693. How to click a cell with mouse and have a different tab appear
  694. Data validation on combo boxes
  695. Chart Macro Problems
  696. Undo a Worksheet_Change Event Causes run-time error '10'
  697. Creation of a form in Word and save the data to excel.
  698. Textbox Formatting Trouble
  699. Conditional Formatting Code
  700. create loop in macro for a list
  701. When I rename a module the keyboard shortcut stops working
  702. DDE Links
  703. Accurate vertical scrollling?
  704. How to traverse subdirectories
  705. transfer the name of combobox to module
  706. dates to text
  707. save as error with no click
  708. SELECT * INTO[Text;DATABASE...
  709. modification of auto-multiple workbook macro, Ron DeBruin (Copy4)
  710. Code takes a long time to process
  711. Macro that needs user input to import excel files
  712. QueryDef; Error 1004
  713. Making a Summary from multiple worksheets
  714. Using Add-ins
  715. Table range coordinates?
  716. Hyperlink All Column Values
  717. Macro in excel
  718. Pushing/Writing data from one cell to another
  719. How to Dim Hummingbird HostExplorer
  720. Insert Column to the left in a list
  721. Range("A1:A10").Interior.ColorIndex = Xlnone
  722. SUMPRODUCT in macro
  723. How can I use "VLOOKUP" with different Table Arrays
  724. Dynamic Visibility of Charts Through Checkbox Selection
  725. Simple Excel 2003 macro not working in Excel 2007
  726. ThisWorkbook.FollowHyperlink....
  727. Macro for duplicating rows based on cell value?
  728. Make Enable Property = OptionButton.Value for all Controls in Fram
  729. OptionButtons with same GroupName not working properly
  730. Re: Move a file
  731. list the pivot items into column a:a
  732. How to get the folder name of thisworkbook
  733. Worksheet arrays VBA
  734. rng.Count ====>results wrong value?
  735. TABLE filter net zero amounts
  736. Productivity tool for managing numbers in Excel
  737. Excel 2007 error after close down
  738. Dates and Times
  739. GetActiveObject("Excel.Application") for multiple instances of Exc
  740. Combo Box
  741. Cond format if Len() is greater or equal to 255 in a code.
  742. Insert Text to the cursor position of a Text box from another cont
  743. .Font.ColorIndex Delay Question
  744. If statement to add picture based on cell value
  745. How to keep Excel from formatting columns?
  746. Re: Settin up the default application to open hyperlinks in cells
  747. Creating a new worksheet and naming it according to a specific cel
  748. Macro to update hyperlinks?
  749. Enabled property failing when code tries to set it
  750. XL2007 Save Thumbnail
  751. RE: How can i get xCellRef.val.sref.ref.rwFirst?
  752. Could this issue be specific to Excel 2003 ???
  753. Auto save at specific times with changing saveas name
  754. Refresh a cell that contains a formula
  755. Select Variable Range paste last row + 1
  756. How do I set up a weighted percentage formula in Excel?
  757. Compare value in column AP with value entered into one of COLs D-
  758. RE: Followup To Jim Thomlinson macro
  759. Status Bar more complex
  760. Find a cell value then read the next row as a record of columns
  761. PivotTable & PivotFields/VBA
  762. Combo Box value is null
  763. Find previous active cell
  764. Adding page breaks conditionally
  765. TrimAll ; $nbsp; alt+0160; Cell View Add-In
  766. Stopping Find from wrapping around in code?
  767. Ignoring errors?
  768. VBA Combo Box for Excel
  769. Insert picture using Macro..
  770. Define a Variable
  771. Staus Bar
  772. Non-Sequential Count
  773. Number of colons
  774. A macro that counts cells when the conditional formatting formula =True. i.e. the cell is colored other than white.
  775. Pivot tables map to network drive?
  776. Data Type Declaration
  777. Re: Concatenate the lookup values from all occurences
  778. push recordset from excel to SQL server
  779. Data Validation
  780. Access Query from Excel VBA
  781. Fastest way to reference a particular cell?
  782. Re: controlSource ques
  783. Print macro Excel 2003 used to work, now crashes
  784. write data to a closed file on network drive
  785. How to apply vlookup formula dynamically to a worksheet
  786. Text alignment in User Forms
  787. Re: Deleting rows
  788. How to make a macro run every fifth minute
  789. Re: Strange behavior in Excel 2003
  790. Hide All Excel Toolbars, Menubars etc when UserForm Loads
  791. Prevent worksheet Rows to Delete.
  792. Call sub from Personal.xls
  793. Re: Multi Select List Box - Checkbox
  794. Need to clear a fielf in Excel 2k7
  795. select case multiple conditions
  796. Splash Screen Timing
  797. Re: Update workbooks in folder, new name and save in new folder
  798. RE: Controlling Entire Worksheet with VBA Function
  799. Find, select, cut and paste
  800. RE: Multi Select List Box - Checkbox
  801. Coding UDF's with VSTO
  802. vb Code
  803. Protected Formula Error
  804. Timer on Userform
  805. Processing Time Varies
  806. Merging user forms with spreadsheet
  807. Advanced Filter works in recorder but not while running macro
  808. HOW TO CHANGE RESULT WITH SAME MACRO CODE
  809. Irregular Shape - Follow up
  810. Convert xls to pdf
  811. EXCEL MACRO HELP
  812. Problem with RegEx and matches
  813. Who opened the file
  814. Save to pdf and make filename
  815. type mismatch error
  816. Clear pivot fields - please help
  817. ListView Control
  818. hide columns automatically
  819. Entering value into cell in macro
  820. VBA Debug Mode : How to I enter it after executing the nth data row.
  821. Combobox
  822. Start up security
  823. HELP radio button not functioning in Excel 2007
  824. How do I use WinHttp within Excel 2003 Macro?
  825. Running balance table, monthly/year grid
  826. Header & Footer text
  827. Run Time Error 9
  828. Problem with password security
  829. Looping Text Import problem
  830. ListBox Conundrum
  831. MACRO ACTIVATED AUTOMATICALLY
  832. Saving as PDF and printing in a macro
  833. Sorting issue
  834. Export Excel Data to Xml Output
  835. Automatically change the line thickness of a row
  836. VLookUp
  837. InputBox
  838. General VBA Question Help.
  839. excel 2003 very unstable after copying a worksheet
  840. Can't manually open file after coding.
  841. Vanilla Ice vs. MC Hammer
  842. I Keep Installing Ubuntu And Vista And Windows 2008 Server, Just FYI
  843. need help; unprotect + unhide + save with certain name
  844. Mouse Coordinates
  845. Date Validation
  846. Break Links But Keep Formulas
  847. test for number
  848. Problems using FormatConditions.Add with an Expression
  849. Selection.Sort problem with formulas
  850. How to programmatically set ControlSource?
  851. save existing file name, different format.
  852. Open All Files that Meet Condition and Save Renaming
  853. How do I retrieve data for the last 90 days?
  854. Macro to group data in pivot charts
  855. Sub to clear pivot filters
  856. solely search certain cells
  857. Macro which inserts new sheet name
  858. Hide row from Autofilter
  859. assign formula to variant range of cells
  860. Trouble positioning an autoshape object using .Top in Excel 2007
  861. 2007 PivotTable Type Mismatch for records more than 65536
  862. Calling a function from a Sub
  863. Need sample for reading value from and writing value to cell E53 from outside Excel
  864. Same Contents, Regardless of Order
  865. State Validation
  866. Embedding an OLE Object from DAO Recordset
  867. target cells in solver
  868. Send email from excel with image
  869. Missing objects in worksheet (e.g. command button)
  870. General questions about VB6/2005 and Excel 2007 compatibility
  871. Reconciling Lists
  872. Select all Matching cells
  873. Variable Declaration
  874. SIMPLE way to call code in one XLA from another?
  875. command button can't be clicked
  876. VBA empties clipboard
  877. Formula Problem
  878. ado copyfromrecordset and nextrecordset
  879. Printing-don't need half this code but which half?:-)
  880. Open workbook and pass info
  881. help! macro textbox
  882. operate macro across multiple sheets, error, cannot locate solutio
  883. Getting text to overlap into other cells
  884. Help with a Macro
  885. Writing Macro in Excel 2002
  886. Complex Summation
  887. Stop Macro if file is already open
  888. transfer a macro to the personal macro worksheet
  889. Frame
  890. ShellAndWait Query
  891. Variable Row Numbers
  892. Send Values from TextBoxes to Specific Sheet on Network?
  893. If active sheet and cell reference
  894. Returning result as 0 from #N/A
  895. 2008 East Coast US Excel User Conference
  896. Jet 4.0 ISAM Error
  897. Reminder or Buzz in excel sheets
  898. Excel crash while expanding object in watch window
  899. Vlookup - error handling with VBA
  900. Code to close and reopen file
  901. SpecialCells method of Range class failed
  902. OLEObjects
  903. Want to Copy and paste to new sheet range except hidden rows.
  904. Little help with filter Please please!
  905. Excel 2007: Error 400, Excel 2002: OK...
  906. Prompt for password
  907. Getting Unique Data Only!
  908. Format date in Multi-column listbox
  909. Can I add an item to a PivotCache with VBA?
  910. VBScript to set conditional formatting for cells
  911. Open a UserForm when a Tab is selected
  912. Custom Function displays as #NAME
  913. Excel document (with VBA and Macros) TO standalone app or Web
  914. Excel Add-In Using ADO to retrieve database records
  915. Excel hangs when switching focus
  916. Pivot table grouping
  917. changing formulas across worksheets
  918. working with format 01-01-08
  919. Test for color of sheet tab?
  920. Can you use UsedRange.SpeciaCells() to loop through all Cells?
  921. Macro Problem
  922. Insert Pictures using Macros
  923. Data delete and mass copy/paste with macro questions
  924. Setting the view area
  925. Sum an R1C1 Range
  926. HOW TO PROMPT MSGBOX JUST ONCE
  927. Detecting which Windows is running
  928. multi text boxes validation
  929. textbox validation for date and condition
  930. Auto-Numbering fails
  931. grouping in Excel
  932. Convert Number To Word ?
  933. Creating User Forms
  934. Keeping a log of activity in a worksheet in a second worksheet in same workbook. Phew.
  935. HOW TO PROTECT SAVEAS FILE
  936. countif / sumproduct or something else?
  937. Overwriting data
  938. find row number of next empty cell in range
  939. calculate direction
  940. VB code to move text cell
  941. combining integer and decimals
  942. Nested IF functions
  943. Use UserForm to Access Spreadsheet on Corporate Intranet?
  944. How to set a tab stop for a command button
  945. How to translate Excel formula function name to another language?
  946. Date entry mandatory
  947. How to set the range?
  948. Zoom event in VSTO 3.0?
  949. move and then unprotect
  950. Protect all cells but allow data validation dropdown change
  951. value is changing at the end of Call Sub
  952. Need help with data validation
  953. Excel to Auto Recieve an Email
  954. Adding todays date to new records in Excel
  955. Textbox date "oddity"
  956. Sending Excel Workbooks to Outlook people automatically
  957. Textbox date "oddity"
  958. VBA - Active Printer Port Problem
  959. column count
  960. Starting Word from Excel
  961. How to Auto populate dates from a given start date
  962. Excel 2007 macro gets workbook name and path from temp file
  963. ADSysteminfo
  964. How to refer cell E53 from the previous (=next left) worksheet?
  965. Clarify this post
  966. macro to unmerge cells
  967. Auto Cell Color using VB
  968. Delete Rows
  969. Cleaning up code
  970. Why does this work now?
  971. Easier Way to Macro Total
  972. Prevent Right Click Menu
  973. Error 0:
  974. web query - strange behaviour (HTML instead values)
  975. Formatting/Merging Cells from XML Publisher
  976. taking "strip html" to the next level
  977. Clearing the interior color properly?
  978. Looping a Macro
  979. Help to the first sheet
  980. Cursor information from a graph on a sheet
  981. Importing text from clipboard into a sheet
  982. Adding formulas to cells dependant on data in another cell.
  983. Printing macro i network
  984. for small project management which is the most suitable software
  985. Change view without activating sheet? - Repost
  986. Hide blank rows - what is wrong with this code ???
  987. need to get several formulas to change chronologically across shee
  988. Using Solver in VBA for excel without cell references
  989. Makroprogramering
  990. Change view without activating sheet?
  991. Excel VBA 2003 Addin trying to map Context id to .chm file
  992. Trouble Sending emails
  993. Remove Alpha Characters
  994. problem running macros on a file from server
  995. is current cell within a named range
  996. use data in cell as a formula for another cell
  997. Web page will not reveal its secrets
  998. Values for charts
  999. In an Excel formula can the clock be used to measure time?
  1000. Re: fill a web form from excel vba