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. Formatting cells - December issue!
  2. COUNTIF to be used with a time range
  3. XL2002 - Cell Reference for Active Button
  4. Update Timecard to new year
  5. deployment
  6. Memory Question
  7. Action depending on cell Value
  8. Proper case using VBA
  9. spaces2
  10. UserForm and .hide: prevent code from further execution
  11. exporting VB files
  12. Send Email depending on Cell Value
  13. How to open a book with parameters
  14. spaces
  15. Delete if find a data format
  16. how to publish my Excel project to sharepoint server or excel serv
  17. implementing help for UDF
  18. File renaming doesn't work
  19. Scan my network for any shared folders
  20. Assembling Data of 100 Sheets in one Summary Sheet
  21. Move the active cell
  22. Array formula with IF
  23. question on Array
  24. How to undo autofilters without removing?
  25. Setting the colour of the legends in chart.
  26. sharing variables between form and module code
  27. Excel challenge, please save a doctor some time!
  28. Lock a custom Userform in toolbar
  29. excel 2003
  30. Capture button name or row # during click?
  31. HELP! PLS!
  32. Border
  33. How to capture Excel Save As dialog box?
  34. Finding Multiple entries for a name
  35. Conditional Format Pivot Range
  36. define a label
  37. Add A Button To The Menu Bar When Opening Workbook
  38. i.Value, i.Text, Or just i?
  39. Pasting within a text entry
  40. Excel 2002 - Getting enable macro prompt with no macros in spreads
  41. Validation of multiple selections
  42. Run a macro by sellecting a cell
  43. Split based on multiple criteria
  44. macros in pivot table
  45. Index in VBA
  46. Office Assistant Balloon no longer available
  47. Perform task on multiple sheets in a folder
  48. hoping for help
  49. Remove Non-Numerics from String
  50. Is This Possible?
  51. most efficient large range summing?
  52. missing data in columns[empty cells]
  53. UserForm image stays when form is dragged to another area
  54. Change a Cell Ref When Clicking in another Cell
  55. java to vba
  56. Macro Examples for prompting info
  57. nested query
  58. Deleting rows within a named range
  59. Sort of sharing a spreadsheet application
  60. Import CSV into Web App
  61. Need help with program locking up
  62. Multi Criteria for Autofilter
  63. button object & imbedded image
  64. Problem in autofilter procedure
  65. RANGE NAMES IN MACRO WITH ADVANCED FILTERING
  66. formula error query
  67. Return to Previous Sheet
  68. Custom UDF
  69. "Picture too large/truncated" error?
  70. Unable to set the xvalues property of the series class for a single row of source data
  71. Get data from Internet? XML? QUERY?
  72. idea anyone?
  73. ProgramEntries.Show 1 causes errors...but no error message given?
  74. How do I stop a macro from running in Excel 2007?
  75. Variables in URL formula help
  76. Data validation of cells using code
  77. Log time against a job
  78. data manipulation quandry
  79. Is it possible to get a date stamp from an Excel file?
  80. hide multiple rows
  81. Referring to a member of the workbooks collection by name.
  82. Sum/If???
  83. VBE Project Protection
  84. equal size columns [same no. of rows]
  85. VBA Code Please help!!
  86. How to Revert to ActiveCell.Formula = format from ActiveCell.FormulaR1C1 = format
  87. Tab colours
  88. Pass worksheet object name to a class module
  89. Delete cells in column every
  90. Add variant arrays (without loop)
  91. Open a copy of xls file
  92. Read Content From A Website
  93. Last Saturday of each month(check on Monday)
  94. Write from variant array into range
  95. Refresh linked Custom Document Properties before save.
  96. Rename and use toolbar menu name by user entry
  97. Allowing Chart creation in protected worksheets sheets using VB co
  98. Excel VB to make a copy of opened file
  99. repetition cases
  100. Drop down list
  101. Linked workbooks
  102. Arrows for UserForm resizing
  103. Moving data Between Two sheets
  104. need macro to edit formula...
  105. Excel 2007 is a Joke
  106. macro to hide rows
  107. move from sheet1 to sheet2 if criteria is met
  108. View data as a form
  109. Lookup function in code
  110. Determine top row and bottom row
  111. VBA code to "reset" application run and empty preserved arrays
  112. If duplicate found sum column C
  113. Comment instead of Data Validation
  114. Macro Problem
  115. Formula Question
  116. number all entries for each letter that apply to the same column
  117. Conditional Format Code Pivot
  118. Sum Times based on StatusID & EmpID
  119. Can a checkbox be placed 'within a row'?
  120. How to pull a value out of a cell into a macro filter
  121. How do I use VBA to update pivot table formulas
  122. Runtime 13 - type mismatch
  123. Runtime 28 - Out of stack space
  124. Custom Command Bar Options
  125. SUMIF every 2nd cell
  126. automatically using VBA code in Sheet 1
  127. Skip function if data sheet is empty
  128. Setting a collection in a class
  129. Convert text value to numeric value in VBA
  130. Problem with comments overlapping frozen panes
  131. Create an Array that includes every possible combination for 4 gro
  132. Validation ON List of values against by command button
  133. Array write
  134. Connection Cannot Be Used to Perform this Operation
  135. Using VBA to Populate a Calendar Template
  136. ActiveWorkbook.XmlImport?
  137. Alphabetize a combo box list?
  138. Load a ComboBox without triggering another event
  139. UserForm ListBox Height
  140. Copying filtered rows
  141. Seems there is a bug with long integers in VBA
  142. I need help with large data set
  143. How do I go from time to decimal if over 24hrs
  144. WorkBook Open & Sheet Activate
  145. Replace Formatted Cell Contents
  146. How do you stop calculating when running a macro?
  147. Pivot Table
  148. What is the best way in excel 2007 to save hidden large data objec
  149. How to use MATCH function to return multiple values
  150. What is the numeric value of xlNone, xlDiagonalDown and others?
  151. Tooltip on Macro Button on Toolbar
  152. Run-time error 9 when running add-in
  153. Update Access Query save and close through Excel VBA
  154. Manipulate workbooks without and Office Instalation
  155. combobox change event triggered without change
  156. WEB Query
  157. Worksheet_Change
  158. Open the Find & Replace Window Using a Macro
  159. Pivot Table Macro
  160. HLP - Make comment appear when click cell
  161. Input box doesn't close if input is false
  162. Save Excel sheet as webpage with macro
  163. remove rows from Pivot Table
  164. Help with Two questions
  165. STUPID range object error
  166. Choose a specific calculating formula for a cell
  167. Borders
  168. The Binary Data that was saved by xlDefineBinaryName can't be retr
  169. Prevent Corollary Event
  170. Vlookup to choose two fields
  171. Capture current WS Name?
  172. Vlookup to choose two fields
  173. Link Excel with Internet explorer (particular site) through progra
  174. msflexgrid doesn't exist on vista
  175. Choosing a service with a formula
  176. Time calculation in excel
  177. Accumulating Data From Sheets and preparing one summary sheet.
  178. experts help required plz
  179. Column Headers down the rows...
  180. If condition
  181. Protect sheet with PivotTable based on OLAP data
  182. IF Duplicate row then cell
  183. Copy Several named Range in many sheets to a summary sheet
  184. Fixed length cells
  185. Problem Using If/Then Statements To Hide Columns
  186. protection sheet
  187. Currency Format within a Concatenation
  188. Wait for press a key!
  189. Chemical formula with sub/superscript in TextBox, Label etc.
  190. two interesting questions
  191. File size MASSIVE but why?
  192. Obtaining the value of an ActiveChart.SeriesCollection(1).Points(2)
  193. Loading Combobox, but avoiding duplicates
  194. Search a address range and street name or number return a map file
  195. open word from excel & then back again
  196. Advanced Filter Multiple Criteria Range not working
  197. converte date julian to greagorian in VBA
  198. open word from excel & then back again
  199. Indirect to a closed workbook
  200. Get the MIN and MAX of filtered answers?
  201. textbox spell check
  202. Slow Text File Import
  203. Macro/VB Help Needed
  204. Save as
  205. Help! trying to send emails through excel
  206. Hiding rows based on user input
  207. Check for Sheet
  208. Monte Carlo Simulation on Long / Short Equity
  209. error when I try to convert hex to bin with more than 8 chacters?
  210. Checking for Invalid filename characters
  211. How date stamp & save filename?
  212. Calculating Early Login & Last Logout
  213. programatically change source of multiple links for multiple files
  214. how to add bullet formatting to excel text
  215. link and filter two w/s beginner
  216. Change Event across every sheet in workbook
  217. VBA & Oracle Applet
  218. Extracting font color within a range
  219. run time error 13 "type mis-match"
  220. Macro acting on all Sheets
  221. Altering an open excel document
  222. Run aloop using a list
  223. Passing a TextBox Object
  224. Moving around a userform with enter
  225. Changing cell values based on a worksheet name
  226. Hide Zeros in Pivot Tabel
  227. Display 3 lowest numbers in column.
  228. Goto location of another cell value
  229. Listbox Height Question
  230. format microsoft query data
  231. XLL loading fails unless load through File >> Open
  232. source code print margins
  233. Create a 2 column table used for data entry on a user form?
  234. Reverse Engineer complex spreadsheet
  235. Question regarding returning a variable value to a cell
  236. Wanting to Create A Command Button Command
  237. Copying sheets into a new work book
  238. Date formatting problems
  239. codename and cell selection
  240. Shape Height Goes Down!
  241. Set itm = doc.MailEnvelope.Item Error
  242. Problem with my Nested IF, the Else output is incorrect
  243. Check all textboxes
  244. Comparing Formula Strings after Row has been Inserted
  245. Looping through Option buttons
  246. Vlookup and IF
  247. Count Data in two Columns
  248. RoundUp Sub/Routine not defined
  249. Simple Change Event not working
  250. Input data for graph
  251. Input data for graph
  252. importing a text file and comparing
  253. Need some more eyes to look at this ...
  254. Prevent two network users from opening same workbook?
  255. Excel / Access Question
  256. How to set "top" of listbox
  257. InList()?
  258. "Linestyle" in Macro
  259. How can i set up a formula to count option buttons in a column
  260. Set objects at module level?
  261. Duplex Printing in Excel?
  262. Creating new shifttime
  263. Load picture in excel cell
  264. List Box Match
  265. ADO excel VBA to update data in Access
  266. Hide Userform modeless
  267. Visualize the context help using HtmlHelp API
  268. In VBA How to Open two text file in same time?
  269. Excel & API question
  270. using xlodbc.xla with Excel 2003
  271. CommandButtons relocate when printing
  272. Excel Icon
  273. gather data in selected cells and transfer value to another cell
  274. Programming problem.
  275. Excel VBA Charting at Axes("xlValue")
  276. can't enter break mode at this time
  277. Columns AV:BE Showing (Not Suppose To)
  278. Symbol for Not Equal
  279. xl2007 and Windows Media Center
  280. xl2007, problem with Activechart.Deselect
  281. UDF returning #value
  282. Str(Answer) Question
  283. Find Data
  284. How to change a value in a cell based on finding value in another
  285. Named Range Problem
  286. Range Formula Problem
  287. Vatiable range
  288. Multiple Coumns Criteria
  289. Find Number On Active Sheet
  290. Parsing blocks of cells using VBA
  291. Format and DDE.......Bet this can't be done
  292. F9 vs. Calculate Sheet
  293. xl2007 bug, Activesheet.Name = "something" out of memory, and more
  294. Time comparison problem
  295. replace excel submenu with my own
  296. Range Statement in chart
  297. API commands and personal liability in a corporate business?
  298. SaveCopyAs (Excel 2007)
  299. Delete columns
  300. Sheet protection/unprotection
  301. specify each sheet name when saving workbook as html
  302. Clearing Array Contents
  303. Conditional formatting
  304. how to get the week?
  305. Runtime Error 9 Subscript Outta Range
  306. Shifting online data comes to excel to be shifted to adjacent cells as per formula with very minimum time lag or in micro second timelag is the problem to be solved
  307. Which Loop would you use?
  308. Delete rows at the same time from selected worksheets
  309. Disable Ctrl-Break
  310. Repost of listbox losing linked cell
  311. List Box Linked Cell loses connection
  312. Excel 200 Automation and IIS7
  313. online data comes to excel to be shifted to adjacent cells as per formula with very minimum time lag or in micro second timelag is the problem to be solved
  314. Generate Reports from Excel Using Seagate Crystal Reports PLs... H
  315. Excel 2007 macro does not work
  316. ErrorCheckingOptions
  317. Change contents of a cell based on cell contents.
  318. Make CommandButton on Menu Bar
  319. transferring data
  320. Can Excel's speech be made to read cell contents instead of macro placed text?
  321. duplicate a range a specified number of times
  322. Problem writing numbers and dates to spreadsheet using ADO
  323. Create Flow Chart using Excel VBA
  324. Source Control For Excel VBA?
  325. Paste no borders and values
  326. Copy worksheet without code behind
  327. export a form
  328. ComboBOx
  329. Help with creating a Macro
  330. Data to new Workbook
  331. UDF with Sumproduct
  332. Creating formulas in Excel
  333. Macro activated when a value in a cell changes
  334. VBA For All My Spreadsheets
  335. Count # of Days in a Month
  336. hh:mm:ss.ss Number format
  337. Count
  338. Automatic Formatting Code
  339. SQL vs. VBA
  340. opposite of Merging data in multiple columns into one
  341. Defining Variable Type for Items and Keys in Dictionary
  342. Pivot Conditional Formatting
  343. Suppress error message with saveas
  344. Program/Macro to remove Hide/Unhide with password?
  345. Search button in a speadsheet
  346. Userform Error
  347. Programatically Add a Button to the QAT?
  348. For-each syntax problem
  349. BeforePrint event
  350. How Do You Programatically Select a Tab on The Ribbon?
  351. Need help getting macro to run
  352. Recording a macro
  353. Check for orphan functions
  354. Using Wrap Text after setting Row Height
  355. list, search, and display
  356. Can I use a between clause or in clause on an IF statement
  357. Paste Range to a new workbook
  358. Name of Work Sheet to be placed in any cell
  359. Copy information from all sheets and store on final sheet.
  360. Error when WB already open
  361. Macro
  362. parent/child ranges
  363. Quick Inverted Comma Question
  364. Excel Macro to enter same text in comment box file's property box of 132 different files
  365. TRANSPORT SETTINGS TO ANOTHER COMPUTER
  366. Simple Macro problem. How do I test the entire range
  367. Printing an embedded Word Object
  368. Date format changes from 'yyyy-mm-dd hh:mm:ss' to 'mm/dd/yyyy'
  369. return .caption text of worksheet control
  370. Set "Print entire Workbook" property from interop code
  371. Opening Excel in PowerPoint
  372. Altered Column Width
  373. need to automate
  374. Save Sheets as Separate Wksheets
  375. Fill ROW with alpha (a-z)
  376. Update number formatting automatically
  377. Calculation order
  378. Rounding in VBA
  379. Changing code and formulas in Excel Program
  380. Insert a table into word
  381. Changing filename causes major slowdown, any help appreciated
  382. VBA: Force wait until recalculate
  383. InvalidateControl in a ribbon
  384. Maximising IE via excel based VBA
  385. advanced search or filter
  386. set macro security to low does not save the setting
  387. Help file Wont display
  388. CommandButtons relocate on worksheet when code runs ??
  389. OnTime Function Call
  390. Debra Dalgleish - Pivot Tables (Change Multiple Page Fields)
  391. Download Historical Stock Quotes
  392. Stock Quotes from Web
  393. Assigning Macro to Toolbar
  394. Select first field whilst autofilter is on
  395. How can i compare particular columns of two worksheets and get a return
  396. Entering quote marks in SUMIF function
  397. Creating a 'Submit' button with in an excel form that will email f
  398. sorting by groups of rows
  399. shade every other line with condition
  400. pasting problems
  401. Converting an invalid negative number to recognizable format?
  402. Finding records that have 12 consecutive values.
  403. Posting data from worksheet to webquery ??
  404. Type Mismatch error when number is negative
  405. Copy Excel Sheet to another sheet and preserve formatting?
  406. Toolbar troubles
  407. getting data from a Microsoft Access table
  408. copy worksheet without code behind
  409. VB Code Question - Input Box
  410. finding a file in excel
  411. Export from Excel using alternative delimiters
  412. Merge the contents of three non-adjacent columns
  413. Pivot Tables need a dynamic range
  414. Unable to set the visible property of the PivotItem class
  415. VB refresh of query
  416. Sort Order with Dates & Text
  417. Help with Send e-mail
  418. help with Unmerged cells that need linking back - populate rows
  419. PriorSheet Function
  420. Change a cell based on current content.
  421. Accessing Arrays stored as a Name
  422. opening a file in closing
  423. if condition on a hot button
  424. Updating a .XLA sheet referenced by a Client Sheet
  425. Summing Similar Columns of Data
  426. Conditional Formatting Range
  427. Consolidate external data -- proofread #2
  428. Switch between two states
  429. I need help with a simple formula
  430. FORMULA IN EXCEL
  431. auto text
  432. VB MsgBox Icons similar to Data / Validation / Error Alert's
  433. VB Code Question
  434. Could not load file or assembly HELL!
  435. XL2002 - Resetting Checkbox values on Multipage Form
  436. VB - Relative Refs
  437. Naming conventions for variables
  438. need a little help with some basic scripting
  439. Specify network printer in Open for Output method?
  440. Connecting to a DB without using the local machines ODBC
  441. vlookup using range with catenated first and second column values
  442. default pivottable page filter when parameter not present
  443. SelectionChange
  444. Conditional Recalc
  445. Headers
  446. Object doesn't support this property or method
  447. compact Access DB from Excel
  448. Grouped Tab Alert
  449. Data Validation
  450. ActiveX Control Button moving around
  451. Trouble with copy to newly created sheet
  452. Restore Userform
  453. FUNCTION IF
  454. time between two days
  455. Interruption?
  456. Newbie Shapes Question
  457. Goto a specific Cell
  458. Excessive Defined Names Causing Book Properties not to work properly
  459. Cell Referencing/Calculations
  460. Custom Message in Status bar
  461. Copy data without opening file and without using ADO
  462. Help - Search for set dates then average other cells values
  463. Function parameters: trying to pass a control
  464. format text as number
  465. Error on Object variable or with block variable not set
  466. Printing Next Row
  467. Reading data from excel
  468. row source
  469. passing range to function: type of argument is byref incompatible
  470. find matching cell in spread over two worksheets
  471. Store information
  472. Fill Array not working
  473. how to enter a string value into a cell?
  474. protecting range with macro
  475. Delete rows if value from cell is not in list Options
  476. xl2007 problem, points(i).datalabel.top gives overflow
  477. Error 1004 -Application-defined or object-defined error
  478. Whats wrong with my code?
  479. SetFocus not working as I would expect
  480. text does not update in rectangle box
  481. how to set current cell (variable row) to sum values of all cells above
  482. update second workbook
  483. check for empty cell
  484. Found out why my User Defined Functions were giving the #NAME erro
  485. SumProduct in an User Defined Function
  486. VB coding
  487. Thisworkbook.path empty or starts with backslash
  488. How to start an RDP seesion by clicking link.
  489. variable as criteria in COUNTIF
  490. Unwanted combining of Conditional Formats
  491. restoring toolbars
  492. ADO vs ODBC question
  493. Retaining Values in Userform when called a second time
  494. Password protect hidden sheet
  495. Pivot table page filtter default value
  496. API to MSGBOX in Excel all running applications in Windows?
  497. Unload A Form based on a Variable in my Module
  498. Loop through pages in multipage control
  499. VB Code Question
  500. Setting up headers & footers in Word from Excel
  501. make two range exclusive
  502. Need VBA for embedded object?????????????
  503. Filtering tabs.
  504. VBA Codes to combine PDF files
  505. symbols in VBA
  506. Excel, VBA, & C++ DLL's
  507. Wild card in filepath
  508. How do I change date to FirstDateOfTheWeek?
  509. User Defined Function - Using Cell Range
  510. How do I use VBA to modify a pivot table formula
  511. Tricky Problem with Sequential Fill Macro
  512. Tricky Problem with Sequential Fill Macro
  513. VBA Do Until
  514. Tricky Problem with Sequential Fill Macro
  515. Passing multiselections from listbox to sub
  516. How do I calculate a due date in excel
  517. run macro on all closed workbooks in folder and subfolders
  518. disable menu items
  519. need help w-populate calendar every-other-day
  520. Hide Show Command Buttons
  521. Initializing a radio button on worksheet open event
  522. Excel Import by Webquery
  523. How to include a 'down' key in a macro
  524. Add Charaters to the beginning of a column of numbers.
  525. Interop Chart Series Error
  526. disable macro during save-as
  527. ControlTipText
  528. Fields show in one column problem
  529. Fields show in one column problem
  530. Modifying For Loop
  531. Simple Excel Formatting
  532. SUM for columns of variable length
  533. Offset by x
  534. Skip ... Selection_Change Event
  535. using sheet code name
  536. Handling multiple SQL queries
  537. Deactivate individual listbox lines
  538. Focus Event
  539. Dynamically Change a Pivot Table's Data Range
  540. Cell Insertion
  541. Group and Create New Sheets
  542. Advanced Filter
  543. Re-calculate
  544. count if?
  545. Nested if's in vba
  546. Problem with Interop.Excel after uninstalling Office 2007 and installing Office 2003
  547. Getting .NET form to respond to Excel window events
  548. Error, when autofilter does not return visible rows
  549. macro help please
  550. Help with nested for loops
  551. Seach all WS
  552. "Object Required" error when calling .Net DLL
  553. Eliminate Duplicates
  554. personal.xls
  555. Countdown timer
  556. Check for valid national insurance number
  557. Help with regular expression
  558. Enable/Disable SAVE AS button from code
  559. Can you improve the performance on my user defined function?
  560. Print a selection based on checked checkboxes
  561. find works very oddly
  562. Copying data from one sheet to another on a specific date
  563. Protect individual worksheets from deletion
  564. Edit text of shape without selecting it
  565. Removing Blank spaces?
  566. One text box for multiple cells
  567. Check if a File Exists
  568. Shortcut Macro for Database Add-In
  569. Shortcut Macro for Database Add-In
  570. Pivot Conditional formatting
  571. VBA: Worksheet_Calculate() Not being called
  572. VBAProject Browser showing the same file multiple times
  573. User forms "Clear"
  574. Copy/Paste
  575. Merging Data from Two Different Workbooks on a Common Key
  576. Saving Excel Document as a Web Page
  577. Code Improvement
  578. weeknum function
  579. VBA training source
  580. Am back at last plus a question on calculation
  581. if statement with sql
  582. COM add-in form show question
  583. ADO Scaling Connection Parameter?
  584. Pulling Data from one spreadsheet to another
  585. Auditing function dehanced?
  586. counting characters in a cell
  587. Find Method in For Loop
  588. ColorIndex
  589. setting print ranges to print based on option
  590. Suppress Error Dialog: "Data may exist in the sheet(s) selected for deleting...."
  591. Determine in VBA if a cell has conditional formatting applied
  592. Array Properties in a Class
  593. ADO Access Query bombs when data has apostrophe
  594. VBA Image transfer.
  595. change range names on a particular sheet
  596. OLEDB rounding percents incorrectly?
  597. How to iterate through results of SQL Query
  598. disable shortcuts
  599. Ping Alan Beban: ResizeArray
  600. How to Parse a string; Delimiter is any Operator
  601. VBA code to convert *.XLS file to an *.IIF file
  602. about using a function for more objects
  603. Thank You
  604. examine value, leave it or increment it
  605. Filtering with criteria in an remote cell
  606. Locking Data Cells
  607. DIR and Arrays
  608. Macro Window - Prevent 'Run'
  609. SaveAs worksheets
  610. Create multiple rows
  611. Re: Selecting ranges with Cells()
  612. Excel 2007 "Error loading DLL"
  613. publish excel sheet through API
  614. Selecting ranges with Cells()
  615. How to Repeat Formated Row
  616. How to change weight of line in XY chart
  617. Third-Party Add-in, Names
  618. Pull Down Menu - Code not working
  619. Insert Row
  620. Trouble sorting a list and getting subtotals + totals
  621. Hyperlink Link Field to link to file on website
  622. help with cell reference...
  623. Command button no displaying
  624. Activate vs Select a sheet
  625. Invoice Template Help #2
  626. text characters
  627. Button Control Moving
  628. Excel Camera Tool Automated Placement
  629. Invoice Template Help
  630. SUM() cells by variables
  631. Macro Help
  632. Cell has focus but no indication that it does.
  633. convert percentage to text
  634. ADO SQL syntax for extracting specific columns from Excel to Excel
  635. Change row height based on content of merged cell
  636. Worksheet Change Events
  637. Auto date & time
  638. Get routine/function name
  639. using CountIf in VB
  640. Excel and Word crash when I try to add a UserForm
  641. Excel Macro Security
  642. Macro to highlight rows and...
  643. Data Validation
  644. XL2002 - Setting same MaxValue on 2 axes...
  645. Testing if Userform loaded
  646. TreeView Control help pretty please.
  647. Memory limitations with VBA
  648. Workspace / Transactions
  649. Delete rows if value from cell is not in list
  650. requirement for creating a sub menu in c# excel addin
  651. pasting data in different columns
  652. Different regional date settings in reports
  653. Executing Macro Help
  654. Macro for rearranges cells
  655. Running a macro with hidden sheets
  656. excel 2007 problem, activewindow.visible = false does not work
  657. Unable to prevent copy/paste of protected worksheet into new docum
  658. Create new sheets based off Data sheet, and template sheet
  659. Formula Modification
  660. forcing entry in input box
  661. Replace a character by it's place in a string
  662. Linking multiple scrollbars based on value
  663. Looping, but with Live Data
  664. Relative cells in previous sheet
  665. Drop-Down List Value populates adjacent cells
  666. Resizing a merged range
  667. Accessing external DB, and making query
  668. Drop Down List Value populates adjacent cells
  669. COUNTIF Formula
  670. left of symbol
  671. Writing a user-defined worksheet function
  672. Saving date created with =Today()?
  673. Macro to copy previous row and insert two blank rows
  674. Re: VBA Assistance needed to test for open file in a different direct
  675. Is there a way to keep calculation mode in automatic.
  676. Number generating an error
  677. Macro Compatibility
  678. help plz in sorting out the error in problem
  679. Grouping
  680. Inscrutable error
  681. DSUM vs. SUMPRODUCT
  682. Click-Sort Button: Dealing With Now-Irrelevant Subtotals?
  683. Controling Word from Excel
  684. Order the TabIndex
  685. dbf Database 5 file access problem with Excel
  686. XML Maps and SpreadsheetML
  687. Compile error in hidden module: [user form name] Excel/VBA
  688. default value of a control
  689. "That name is not valid"
  690. End If without Block If Error Help
  691. Evaluating if a Shape is a line or a shape
  692. Open Workbooks present in the same directory
  693. Run Time Error"13".. Mismatch..help plz
  694. myCell.Row?
  695. How Do I Copy Cells From One Sheet To Another
  696. print Cahrt created by OWC
  697. vlookup grabbing same data for each row
  698. By selecting a cell - change color in a range
  699. "Unable to get Pivot Tables Property of Worksheet Class "Error
  700. Copying and Pasting between Two workbooks
  701. Selecting a Range based on an IF condition
  702. Best Way to Get File Names into UserForm
  703. VB for multiple filters
  704. copying numerous formats from a VLOOKUP
  705. Counting/Changing multiple buttons?
  706. Need help copying data from one column to specific columns
  707. Rename a Module
  708. Many users adding to one workbook?
  709. Printing to Dot Matrix
  710. Application Error
  711. signing macros
  712. "after update" type macro
  713. A Simple Block Diagram UserInterface
  714. 1004 - Move Method of Worksheet Class Failed
  715. Using Weekday function with no add-ins
  716. Help w/ modifying code... pull down menu
  717. Using Script to download from secure site
  718. Substituting substrings
  719. Preventing Invalid Characters using data Validation
  720. "Error 1004 Unable to set the ColorIndex property of the Interior.
  721. Need help with Error 'object variable or with block variable not set'
  722. Close 2007 add-in from code
  723. Select Half a Worksheet
  724. Using Icons wthin an Excel spreadsheet
  725. Help with Simple Excel Loop
  726. VBa code for index(linest)
  727. App_WorkBookBeforeClose()
  728. insert a row for every 20,000 th row?
  729. for each doc in dir, copy data to excel
  730. problems with hidden sheets in for each
  731. Incorrectly getting "Subscript out of range" Error.
  732. Macros in Excel
  733. here is my code...it's running a bit slow though..any ideas to make it more efficient? thanks
  734. Help!!
  735. Spin Button to Change Label between Normal and BOLD
  736. Automatically extending a range
  737. Changing Font Name in Function Sub
  738. Formulae trouble
  739. Using Hebrew in a Macro
  740. Using an excel built in function in a Macro
  741. XlTable format with Unicode
  742. Parsing a string into an array?
  743. Formatting date in footer
  744. using functions
  745. add to a cell with a button
  746. Worksheet with its own toolbar
  747. If text found in Row, delete Column
  748. Creating Intermediate Date Values - New Problem
  749. Automatic Filesave using Loginname
  750. USe VB to Get Pivot Data