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. scan text in cell and color part of the text
  2. vba project password
  3. Moving Macros to the Application Level
  4. Can I display an open file dialog from a macro
  5. Can you speed up this code?
  6. Passing a variable from sheet code to a module
  7. Re: Column Array
  8. Help with code please
  9. Stop text to date conversion
  10. Hiding graphics elements?
  11. format a specific letter by code
  12. Help with Connection to external text data file
  13. Re: Copy to Named Range
  14. Converting strings to numbers
  15. Copy filtered data (Values only)
  16. Insert Shape Based on Cell Changes
  17. Sort bug on Excel 2007
  18. Click Excel custom menu item via MFC automation
  19. find a non-empty cell
  20. Re: Who is in a network shared Excel file
  21. Matrix inverse with MInvers, help please.
  22. Check to see if subtotal is expanded
  23. Problem with file links changing
  24. copy multiple rows
  25. Array problem? List comparison?
  26. Compare two lists and get differences
  27. Case Method & Range Object Problem
  28. Tweak to display autoshape
  29. Insert character using Regex
  30. How do I create a hyperlink with a macro?
  31. Pop up message asks if I really want to edit the live office data
  32. Sort Worksheets Numerically
  33. names in file name
  34. Using iserror with greater than
  35. Re: Excel Export to Access via VBA
  36. Check for other open wokbooks
  37. complex formula
  38. Sorting question sort of
  39. Copy a Sheet to an AddIn
  40. Help with sorting data
  41. Textbox (Object) Right Click Menu - Disable Cut
  42. Pointing specific textbox
  43. MsgBox Loop
  44. Count the Colorindex of a cell with a conditional format
  45. Re: SUMPRODUCT is not working
  46. RE: SUMPRODUCT is not working
  47. RE: SUMPRODUCT is not working
  48. Help with SORT property in xl2007 and xl2007 !!!!!!!!!!!!!!!!!!!!
  49. Using vba find
  50. Re: How to find all UDF calls in all workbooks
  51. VBA to open a PDF, print, then close - Stumped
  52. A macro for converting formulas to formula results only
  53. Macro to save a workbook
  54. Insert character in a cell using a keyboard shortcut
  55. Checkbox values
  56. Hide Columns Based On Date Value
  57. Color Definition
  58. auto copy and paste to another workbook by using specific titles
  59. force recalculation of function
  60. quicker cell concatenation
  61. Re: Calling one UDF from another in a different module
  62. Find date in row and move to cell
  63. Detect macro in excel file without opening it
  64. Save as vba excel
  65. Evaluate VLOOKUP in cells in column
  66. Re: VBA source or reference
  67. Selecting a cell according to the cell value
  68. NetDDE
  69. HOW: Click Formula Hyperlink To Trigger Macro
  70. Re: Is the MSFT online help offline?
  71. RE: How to find all UDF calls in all workbooks
  72. moved macros to new book now they don't work
  73. modify formula
  74. Autofit
  75. Establish if Offset RANGE contains text
  76. declaration help please
  77. Insert an autofiltered range into another tab
  78. hours / minutes
  79. hours / minutes
  80. programming 33 tabs with 1 chart on each, 9 series lines per chart
  81. RE: Is the MSFT online help offline?
  82. automatic replacing of a VBE sub in all open workbooks
  83. Insert Formula based in cell user clicks
  84. Copy problem between worksheets
  85. Turn a range of cells into 'read only'
  86. Ignore Blank Cells
  87. VBA code to protect cells Outside a given range
  88. Loop Through Range
  89. Print Wide html reports using Excel
  90. Print only the used sheets in all open files
  91. 2 codes in one sheet
  92. Change cell font color when cell is clicked
  93. Wrapping entries in a ListBox
  94. Lose info upon activate
  95. VBA Code for Pasting Contents
  96. VBA Code for Pasting Sheets
  97. Call a Sub from another Worksheet
  98. Counting rows and inserting blank lines
  99. Macro not saving as
  100. Insert Pagebreak in Word document
  101. MSGBOX Run-time Error '13': Type mismatch
  102. Excel VBA 2003: subroutine to reorder conditional formatting rules
  103. Excel VBA 2003: how do I call an Analysis ToolPak function within
  104. Protecting range limits
  105. ADO connection Problems between excel worbooks
  106. Avoiding #N/A result
  107. Filter by error
  108. Inverse Matrix
  109. Column Coding
  110. Copy image in excel to publisher document using vba
  111. Comparing two worksheets
  112. auto_close give me additional information?
  113. is it possible to run code written inside a cell
  114. Formula- to create drop down down list based on diff criteria
  115. Combination to Two formulas with the Help of AND / OR / IF Functions
  116. Re: Is the MSFT online help offline?
  117. Auto closing UserForm
  118. LoadPicture() error XL2007
  119. Fill Down based on count in another sheet
  120. Search multiple columns
  121. Save all codes in a plain text file
  122. Combo Box question
  123. Autoadjust range declaration coding when inserting rows
  124. moved macros to new book, now not working
  125. Worksheets and Events
  126. Slope from a range of cells
  127. Adding Chart problem
  128. Print all open files
  129. Re: Can I get Excel to recalculate just one cell?
  130. Re: Can I get Excel to recalculate just one cell?
  131. Autofilter question
  132. Open Multiple Files At Once
  133. Find and Replace using a Loop won't stop
  134. RE: Can I get Excel to recalculate just one cell?
  135. Re: Can I get Excel to recalculate just one cell?
  136. Re: Can I get Excel to recalculate just one cell?
  137. lock first row and first column WITHOUT selecting Cell "B2" first?
  138. Show Application via Automation
  139. Re: Automating a copy from Excel to Word
  140. Collecting data for MPG (miles per gallon) calculation
  141. Before right click:
  142. Lessons Learned
  143. VBA to export large tables from Excel to SQL Server
  144. Edit Query
  145. Open Workbook to Specific Cell
  146. How to limit number of Message Boxes on Validation Error?
  147. Add Information Box to Macro
  148. assigning variables
  149. Compare Names in a column and create single list with adjacent vla
  150. Color Variation
  151. Unlock cells based on colour
  152. Unlock based on cell colour
  153. Delete space and restrict text length
  154. Multiple reference locking/unlockng in formulas
  155. Help, help! desparate for formula help!!
  156. Cannot write the contents of an Object to file
  157. Menu Add-in
  158. Initialise the registry values in a array and retrive the values asrequired
  159. Range Vlookup
  160. loop thru cells to find matching record
  161. moved code to new book - some doesn't work now
  162. Loop in Excel
  163. Adding to the cell value with a macro
  164. macro trouble
  165. Excel and Windows Live Mail
  166. Re: Using autofilter in VBA
  167. C application connected to Excel
  168. Delete contents of cells in a range based on value of a cell
  169. Tagging formatting (cells with mixed formatting)
  170. Determine if the Excel Version is 2007 or previous
  171. Formula ?
  172. loop VBA request
  173. loop VBA request
  174. calculate number of days formula
  175. slection change to make the selection go down 1 cell
  176. selection change macro to go down 1 cell
  177. Suggestion for Macro to Delete Dups based on all fields
  178. Graphing a bounded region with a twist?
  179. protect macro from a different users access
  180. Code in a macro to branch to another macro?
  181. how to brake a excel sheet passward
  182. Make code aware of the workbook file name
  183. Floating Text Box in Excel 2K3/2K7
  184. Select the UNIQUE vendors name
  185. Protection Macro Causes All Workbooks to Be Locked
  186. Dynamic print range using macro and constant print area.
  187. Extracting First Name from cell with first name and last name
  188. Ideas for an alternate (faster) approach to sumproduct?
  189. Open VBA Editor?
  190. 2007 Sharepoint XMLMap
  191. combo box
  192. hidden character in Excel
  193. Need a code
  194. If cell contatin string like .... copy in Offset mode
  195. RowSource
  196. Remove unnecessary rows
  197. Auto Fill Cells
  198. Auto Fill
  199. Excel Macro Problem
  200. Formula to format selective part in a text
  201. Classification
  202. find format syntax
  203. Deactivate macros but reactivate again once another macro is run
  204. Start of macro via desktop icon no longer work
  205. PivotTable count unique
  206. How pass credentials to Access from Excel (for onward use)
  207. find range question
  208. Formulas In Cell Comments
  209. Hiding a dropdown menu
  210. NetDDE
  211. Unhide rows in an Excel Macro
  212. Conditional formatting?
  213. EXcel Chart Size Probelm with Printer - Please Help
  214. Move all except latest to another folder
  215. Stop duplicate record
  216. How to hibernate Windows XP at the end of macro?
  217. Macro buttons
  218. Using a List Box to filter another List Box
  219. Excel macro to Automate ppt
  220. Hold shift to stop Auto_Open() not working in 2007
  221. Sorting one worksheet from another worksheet
  222. disable pageup and pagedown
  223. Form and tabbing
  224. setting more than one filter
  225. date data type is not a date??
  226. Listbox ?
  227. Merge Curves in Excel Graph from VB.NET
  228. Retrieve Formula Result when Saving
  229. Unexplained change in variable
  230. how do i change tick marks of excel graph from vb.net
  231. UDF XLA and SQL queries
  232. Excel development tools?
  233. Verify Input
  234. Create a small table from a large table by skipping empty columns
  235. Finding new records in subsequent reports (XL07)
  236. deleting unwanted columns in multiple worksheets
  237. .addline error duplicate name
  238. Help with loop-I'm stuck
  239. Excel Save problem from C# application
  240. Excel object model reference no longer available?
  241. Insert comment into cell
  242. Inserting the values of a formula using vb
  243. Programmatically Adding a Worksheet_Change Event Procedure to a Pr
  244. Change to different active printers on different PC's
  245. How do I retain formatting?
  246. multiple crieria searches
  247. email sending to a group name error
  248. Variable Range Sort
  249. Using VBA coding to count color Occurrences
  250. macro to apply only to even number rows and NonBlank cells
  251. userform problems with copy/paste and drop-downs
  252. restrict textbox on userform to mm/yyyy
  253. VBA Pivot Table Change Criteria - Help?!
  254. Excel 07 - doc insp says there's a hidden worksheet and there isn'
  255. From ListBox selection >labels on userform to show sheet cell valu
  256. Keep text box visible
  257. Exclude one folder in a filesearch
  258. Opening .CSV file
  259. Macro to copy and paste all rows of data in between two words
  260. Macro correction needed
  261. Excel 2010
  262. Re: Insert Page Breaks code is not working in Excel 2010
  263. Workbook properties code in the xla addin
  264. how to disable print button in preview
  265. Simple... Using FIND, I need to get the row and cell
  266. Re: Best way to package workbook and UDFs
  267. EnableEvents = False not working ???
  268. Self Closing MsgBox
  269. ActiveWorkbook.Save saves to wrong directory
  270. Complex Copy/Paste...Then Arrange Results in Columns
  271. FormulaR1C1 using variables
  272. Word table to excel
  273. Re: Best way to package workbook and UDFs
  274. Highest Value from Excel Formula
  275. Pairwise comparison using excel
  276. initialize userform code not working first time
  277. Need Help With the SUMPRODUCT Formula !!!!!!!!!!!!!!!!!!
  278. Needed Macro and Function Help
  279. Excel Convert text to Number
  280. Deleting columns if value of cell is not matching
  281. RE: VLOOKUP related question
  282. Add an asteric and let user input a number
  283. DSOFile.dll error - The document is not an OLE file
  284. Recommendations
  285. Link error/Warning using macro in files converted to Excel 2007 (.
  286. Sub menu
  287. Put a single quotation mark in front of numbers in selected cells
  288. Borders to every 8-th row
  289. Sheet Cleanup Help Please
  290. Macro to change column width and active window zoom as columns areselected
  291. How to write to file the contents of a generic array/collection
  292. VBA Editor Menu
  293. How to find default property for particular object.
  294. Faxing from Excel?!
  295. Opeing PDF's withing a MAcro I have written
  296. Match formula to match values in multiple columns
  297. Error
  298. Warning off by deleting a sheet
  299. find by concatenation of cells
  300. Average various variable ranges
  301. How to detect merged cells with C#
  302. Re: VBA: How to match two sets?
  303. save a particular column in notepad
  304. Macros missing
  305. Re: VBA: How to match two sets?
  306. Run Time Error '1004' Application or Onject-defined
  307. Help with code
  308. Count previous 30 cells two sheets
  309. Invisible Formula in Cells !!!!!!!!!!!!!!!!!!
  310. Search and Replace, or Add New Row
  311. excel extract data from one sheet to another
  312. autoscale stock chart
  313. Help with my macro
  314. How do I make a golf handicapping form in Excel?
  315. AdvancedFilter syntax
  316. Object Browser
  317. Adding code
  318. Macro Order Rank
  319. How do I apply State O Maine 5% Sales Tax schedule to $ amounts.
  320. Find and loop help-multiple columns
  321. Using VBA to create PDF - setting paper size
  322. RE: Get user inputs
  323. Substitute c. for something else
  324. input box prompt
  325. inputbox prompt
  326. Solver in vba
  327. Converting a number (17 characters) to text (Scientific Notation)
  328. Paste Name Questions
  329. displaying intermediate results from a function procedure
  330. Progress indicator help wanted
  331. Export from EXcel to jpg with 2007
  332. Convert Function to Sub
  333. Charting the Sum of Two, or More, Series of Data
  334. Need help with Trim function
  335. Deleting Rows
  336. Email Last row to an email address in the last active cell
  337. disable macro/code after date & time
  338. Dynamic Name Range using VBA
  339. Copy a Textbox to a range on different worksheet
  340. Fill in Date based on E1
  341. Basic VSTO questions
  342. Modify Code to format entire row of data
  343. Controlling execution of a Sub Procedure -Part 2 :(
  344. Macro to ransfer data
  345. Computer that can solve Linear Programming problem?
  346. TimeStamp
  347. Code wont work - help please
  348. Cell.Text different from Cell.Value when dates are concerned...
  349. check Wb is open and copy data to it
  350. word to excel
  351. Pivot tables
  352. How to identify Chart Source data as range?
  353. How to store relative cell values in variables & check it
  354. Change cell color
  355. data splitting
  356. Excel 2007 VBA - looping through scenarios not possible?
  357. How to fill a combo box with choice from another combo box
  358. variable
  359. How to code macro with condition?
  360. 2007 Customui - is it possible to control the visbility of a "grou
  361. How to set macro to run every 15 minutes?
  362. Adding code
  363. Lookup and return
  364. Use cell contents to make formula reference
  365. A seemingly simple problem for VBA
  366. number of seconds timer
  367. macro stopping
  368. such next free rows
  369. Controlling execution of a Sub Procedure
  370. calls to extract data from an open database
  371. Trimming leading character from string and replace underscore withdashes
  372. How can I overwrite the last line data in text or csv file from VB
  373. Sheet name changing dilemma
  374. Specialized Spreadsheet
  375. Active cell jumps when conditions are met on a single row but I needan expanded macro that will do the same on multiple rows
  376. What wrong with the coding?
  377. copy rows in range if data in first cell
  378. Change 2007 excel Autofilter back to 2003?
  379. How can I convolve 2 sets of data in Excel?
  380. Deleting rows when cell has "#DIV/0!" error
  381. disable clipboard alerts
  382. Extracting date file modified from a text file.
  383. Format sheet based on column contents
  384. Code help
  385. Accounting Problem. Complex Copy/Paste and Index/Match too.
  386. template task pane opens when work book opens
  387. RegExp not matching what I want
  388. Run stored Query in Access
  389. Progress Bar Internet Connection
  390. Set color for chart serie in excel 2007/2010
  391. macro to filter data based on selected data
  392. slow code with many loopings
  393. Change synthax of workbook-level names in one go
  394. Totally Totally baffled
  395. Save as variable file name
  396. MAC OS Excel 2008 Visual Basic Programming
  397. Knowing is a workbook's VBA project has password or not
  398. Format a PivotTable
  399. Get Month name from Date value in cell
  400. Cut and Paste
  401. Need help with Workbook_BeforeClose event
  402. Compile error
  403. Assign variable value across files
  404. Fraction to decimal
  405. fractions to decimal
  406. Tabbing in excel-use VBA
  407. "Move to bottom of range"
  408. A formula for subtotals against each category
  409. Worksheet toolbar
  410. Restricting pasting, except for Paste Values
  411. Problem with referencing a hidden column
  412. Arrange code
  413. Reference is not valid
  414. open word file
  415. Variable counting of rows
  416. Sheet delete event
  417. Excel query insert
  418. Finding Next Empty Cell in a Range
  419. To enter data in columns in required order in some special way and toensure this
  420. .insertlines automation error excel crash
  421. RE: page number in word 2007
  422. number consequetively
  423. Special Characters
  424. Use of Cell Values Instead of Hard Coding
  425. Does Excel 2003 or 2007 have a Report Manager Add In
  426. Sort on Tab Change
  427. Excel 2007 ribbon issue when in cell edit mode
  428. Pivot table has source data has exceeded 65536 records type misma
  429. Missing References
  430. Clipboard
  431. Save as crashes Excel - sometimes
  432. create range name in the active cell
  433. Filtering by three criteria including top ten value
  434. Re: conditional prevention of check mark in a cell
  435. Custom button image not loading on custom ribbon
  436. Create a new folderand name it the previous month
  437. how to make macro work even a sheet is hidden.
  438. Run-time error '380' Invalid property value.
  439. wildcard in filenames in macro
  440. Can VBA modify Task Schedular tasks in XP
  441. Button image not loading on Custom Ribbon
  442. Search and replace problem
  443. Sum of retuned valus as digits
  444. grouping
  445. Listbox Problem
  446. Save Macro with date in name
  447. dynamically referencing ranges with variables
  448. conditional copy of column to another column of same worksheet
  449. Execute a variable as an insertion into a VBA code line
  450. Linking Page Fields for multiple pivot tables
  451. Simple Formula Question
  452. Help inserting an image
  453. loop for macro
  454. Change code with code?
  455. Shapes and protection xl2000/2003
  456. Array Issues… Please help me….
  457. Advanced Filtering top values
  458. Repeating data when data matches
  459. Copy and Paste using VBA.
  460. Sorting or summing data column into correct rows
  461. Using Cell.Replace
  462. Formula-Find Duplicates
  463. Replace code module in distributed app?
  464. Active sheet problem / macro button
  465. Runtime error 1004 write data to a cell
  466. Save file
  467. Why CreateObject("vbscript.regexp") doesn't work?
  468. Automated Copy Paste
  469. Suppress Worksheet_SelectionChange conditionally
  470. Determining the Active Worksheet
  471. Macro to copy all rows between Comments
  472. Clear all including objects without deleting sheets
  473. VBA to superscript a part of a cell
  474. Macro command not running in excel 2007
  475. Automatically selecting active chart
  476. Text running
  477. Selecting a point on a chart in Excel 2007 on Windows 7
  478. excel 07 Dynamic copy certain cells if criteria is met onto next s
  479. Named Ranges on different sheets
  480. Summary Help Needed
  481. Open and close workbooks
  482. Matching in VBA
  483. How do you convert a string to a double?
  484. Literal string in filter, not a date
  485. Saving Using Active Workbook Name
  486. How do I test whether a string is a valid cell reference?
  487. refresh listbox
  488. Help needed editing a script
  489. Userform Layout
  490. Filter with criteria!
  491. Where is the problem on Next without For?
  492. Code to adjust column width
  493. Sub, Private Sub, Public Sub
  494. What wrong is the coding?
  495. Repeating cells when data matches
  496. modifying the Userform_Initialize event handler
  497. Check button
  498. Avoid protected cell warning on BeforeDoubleClick WS event
  499. Automatic message
  500. a macro to copy only 2 lines w/i a cell separated by 4 line breaks
  501. thiscell
  502. Refresh Listbox
  503. Excel 2007-Macros
  504. Copy row to worksheet IF
  505. Fill in Blanks
  506. How do you code to get SQL Server data from ODBC Connection?
  507. Rearrange sheet data
  508. Function Declarations !!!!!!!!!!!!!!!!!!!!!!
  509. Feach data according to cell value
  510. auto fill internet explorer
  511. Chart error: plotting series data XY scatter plot
  512. ScrollRow
  513. If specific cell is not empty, copy (or enter) formulas and format
  514. Turning off Whole Word selection in Excel 2007
  515. Turning off whole word selection in Excel 2007
  516. Selecting a Range of Columns for Variable Rows
  517. GetSystemMetrics32(n) Question
  518. lookup list
  519. RE: Macro to Pivot data in each sheet within a workbook
  520. Help with combining 2 seperate Worksheet Change Event scripts
  521. Workbooks.Open with a network path
  522. Active.Paste Error
  523. copy rows with values - not formulas
  524. Passing Criteria to a Pivot Table from combo boxes
  525. Slow Code
  526. Addins with isaddin property to false in excel 2007
  527. Dynamic view of data based on cell content
  528. Fix the size of form controls in a worksheet
  529. Disabling copy/cut/paste for shapes
  530. Working with a worksheet that is not the active worksheet
  531. How to write a macro to hide an entire row
  532. Countif number between x and y
  533. Get data - Multiple criteria
  534. Hi to Low
  535. Look for names when cursor is there..
  536. Cells range into an array, then into msgbox
  537. Excel 2007 Default User Form
  538. need help on refining find record macro
  539. Create menu with Workbook_open : error
  540. Re: Populate a comboxbox and Listbox in a excel userform with an sqltable data
  541. HELP: extract certain characters from text string
  542. Three questions about fields in worksheets
  543. Data Entry Form questions
  544. How to Run a Macro From WB1 in WB2 Against WB2
  545. Adding ws information to cell in new wb & saving with ws name
  546. Array computation in vba
  547. DELETE A RANGE NAME IF EXISTS
  548. If conditions for Data Entry Form
  549. Re: Copy sheets to new workbook - subscript error
  550. Finding Dups in one column then delete leaving one
  551. EXCEL Macro problem
  552. Excel 2007 - Dynamic sheet naming
  553. using write #1 to create a batch file
  554. Excel 2007 dynamic chart range correction
  555. Excel 2007 dynamic chart range
  556. Select not actualy selecting the cell
  557. Help with Formatting Spread Sheet
  558. 2-----------------------------------------------------------------
  559. Apply ADDRESS formula in VB
  560. Code to change a named range
  561. SaveAs file name
  562. Code to delete rows with varying amounts of data
  563. Find a Item & Copy the Data
  564. Locale issue with union operator string (,)
  565. update user name in excel on open
  566. Suppressing a screen
  567. Copy range from one sheet to another cell by cell
  568. Set destination sheet based on variable and paste data assistance
  569. Average a dynamic Range
  570. update stock prices
  571. Get External Data from Web
  572. Advanced VBA Conditional Formatting & Field Population
  573. How to copy one column values to another column based on conditionthat row2 contain todays date
  574. Generate random numbers - Using initial seed
  575. lookup help
  576. Toggling xlVeryHidden
  577. Copy Cell from one sheet to specific Col value
  578. dynamic sort
  579. Search and filter mutiple vaules
  580. button on macro recorder doesn't toggle
  581. Using xlsm worksheets on different computers
  582. Close a workbook
  583. Insert Image with name and filepath
  584. If/Elseif AutoFilter Macro
  585. wininet & FTP to Mainframe (zOS)
  586. Fill array with Values
  587. Formula to copy cell in Excel from on file to another
  588. Formatting Sheet
  589. Syntax got me again
  590. class modules versus modules
  591. RowSource for my ListBox
  592. Please Help: Append New text to Old text already present in databa
  593. Start/End Cells in a Range
  594. Textbox object event - Help please
  595. Please guide
  596. Max length of variable name?
  597. help needed
  598. Message box shadow
  599. Excel Security
  600. Variable Range with a loop needed
  601. Type Mismatch
  602. folder picker
  603. Get 2 Lowest Numbers from 4 Cells?
  604. Formula from closed workbook?
  605. Total columns Based on another cells value
  606. On Error Goto Function
  607. save as version 2003 problem
  608. Ignoring hidden rows in PERCENTILE function
  609. Formatting from VBE
  610. Automatically Update a Pivot Table Field Used as Column / Row
  611. ? offset('activecell',,-2,1,1) in Named Formula ?
  612. Totalling data from different sheets.
  613. Create tables on multiple sheets from list
  614. Function or formula to show currently active workbook name in cell
  615. Pivot Table variable sorce data
  616. Code to Implement Required Cells Not Working
  617. If the cell is empty, copy the value from a specific cell.
  618. How to open a specific worksheet via code from workbook_open
  619. Can't break out of code help!
  620. Variant Array Copy, Array row contains Object
  621. Error than Aborted Excel
  622. Sort issue Sort Of
  623. Sort issue Sort Of
  624. Working in Excel 2003 but not Excel 2007. Can not protect sheet.
  625. sheet2 = sheet1
  626. Compile error. Need Help with this UDF !!!!!!!!!!!!!!!
  627. using Name or other method to add cell values through workbook
  628. Map characters to their relative positions in a cell
  629. Connection with a serial interface
  630. Select Case
  631. Open event failing
  632. Visualization problem .xls file with office 2007
  633. loop through every other and 3rd cell in range
  634. IP address to Hostname in Excel
  635. Managing Macros
  636. How do I change a mouse icon !!!!!!!!!!
  637. ADO performance
  638. Consolidate Item, months and volume
  639. Change Range in macro
  640. JavaScript & WorkBook.PivotCaches
  641. Pivottable reference...
  642. Random selection
  643. Help Designing an Hyperlink process in Excel
  644. Pivot Tables - Multiple Ranges
  645. EXCLUDING DUPES IN STRING ARRAY !!!!
  646. Using Access form to assign values of variables in an Excel VBAprogram
  647. How to add "'" into string?
  648. Populating combox with worksheet names
  649. Consolidate, Lookup and Sum from dates to months
  650. cannot insert object error
  651. Strange problem
  652. Excel macro
  653. Need to Keeping Same Display Value on 2 Workbooks
  654. How to import the links with method="POST" within form?
  655. Multiple User Defined Categories in Insert Function Form
  656. Automation Error. What is this?
  657. Data Validation enter values with VBA
  658. Deleting veryHidden worksheets
  659. Help Needed Fixing Code !!!!!!!!!!
  660. Resize query
  661. Chart Rendering incorrectly in newer release of MSO 2007 12.0.6514
  662. How to select combobx value with vba?
  663. Delete CDO page heading and following matter when printing an emaildocument; to print the document only
  664. weird and spontaneous combobox resizing
  665. Deleting Lines
  666. How to open a specific worksheet via code from workbook_open
  667. Conditional Format Formula to color row based on text
  668. Formula + a variable
  669. Using Object & Worksheet names as variables
  670. Macro to Update links on a network
  671. Problems finding a file on a network drive in excel 2007
  672. on error
  673. How do I insert a radio button using Excel 2007?
  674. Rounding a formula in code
  675. the default worksheet
  676. are there any VBA consultants left ? - will pay for help
  677. 'Excel reclaculates formulas' message
  678. Visual Basic in a shared workbook
  679. Selecting Multiple columns with multiple rows
  680. GetTempFolder and GetTempFile ?
  681. Dialogsheet Checkbox to Select All Checkboxes
  682. Suppressing Values in Autofilter Criteria List
  683. offset method problem
  684. VBA Opening Access Table from Excel - Permission Error
  685. Message box warns for duplicate use of named ranges when copying s
  686. User Form instead of message box to collect data
  687. Time Out a MsgBox
  688. Function VBA - 3 variables
  689. Extarct limited Excel data from D drive to another excel file
  690. DisplyaAlerts Problem
  691. Move Form to edge of chart window
  692. Use specialcells to identify specific values
  693. VBA to create new data help please
  694. Hide button based on a cell value
  695. Dim As Range Object
  696. Extracting date from cell
  697. Intersect & Hyperlink
  698. How do Excel define the application area?
  699. BeforePrint & PrintPreview Hangs
  700. How to break the FOR loop?
  701. Code to make a Spinner button work with Filters on a Pivot Table
  702. auto run a macro
  703. change colors in a range of excel cells based on another range of cells
  704. How to reverse order on FOR loop?
  705. Excel spreadsheet for weight and balance calc for Cessna 182
  706. Can I run a file with a known extension from Excel VBA
  707. Insert functions diabled in ribbon Excel 2007 Windows 7 Pro
  708. Time Delayed Response to MsgBox
  709. Export from xlsx to csv preserving non-german characters
  710. How do I create an average collum in my spreadsheet?
  711. Syntax help
  712. Macro speed
  713. VLookup in VBA Help Needed
  714. Conditional formating using VBA
  715. A list and chart from two pivot tables
  716. How can I create an hyper-link automatically.
  717. Find files
  718. Looping through Worksheets_(excluding one)
  719. Time Spent
  720. VLOOKUP with VB
  721. Maintaining a form open when selecting a cell
  722. String manipulation in 2007
  723. Screen coordinates of ActiveWindow
  724. Save Text to File
  725. runtime error 91
  726. Point to My Docs in Win7/XP, Excel 03/07
  727. Public Variables
  728. Run make table query from Excel with Access closed
  729. Option Button in form controls
  730. How to delete sheets using macro?
  731. trying to find the previous thursday before running a macro
  732. copy a range from active cell
  733. RE: Open Hyperlink in secondary browser ..?
  734. Create an auto chart using macro
  735. Erroneous Macro Recording
  736. How to export specific emails to excel?
  737. Sendkeys
  738. cell formula
  739. Values of the last date
  740. Send Email(s) by selecting users from user form
  741. How to import a list of links into Excel?
  742. nested find/find next
  743. Circular Reference when opening program
  744. VBA Macro to open excel file and replace VBA module with update
  745. Crane model in Excel
  746. APR calculation for Mortgages with a balloon payment.
  747. filling a form in excel
  748. UPC Numbers
  749. Referencing objects inside of a loop
  750. reset the value of a spin button