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. Duplicate records
  2. Removing Weekends From a Formula...
  3. Using ADODB Efficiently
  4. Calling VB functions that are stored in an addin
  5. Sending mail
  6. detecting a proteced workbook
  7. Invoice
  8. Unexplainable Worksheet Function Calculation Process
  9. Excel 2003 keeps crashing
  10. Formatting problem
  11. Formula Copying in workbook
  12. HELP!! Macro Deletes Last Interval
  13. error message for phantom chart with log scale
  14. 16.000 workbooks
  15. Deleting rows
  16. Feed List of Names into Ron de Bruin Code-Filter
  17. Change pattern for individual data points on chart
  18. Change syntax
  19. Transpose in Reverse
  20. Passing a control to a Sub
  21. downloading a small database
  22. Find duplicates, sum column then delete duplicates
  23. shortcut keys
  24. Author's Name
  25. adding text boxes at runtime and setting autosize to True
  26. Move to a named worksheet from any worksheet in the same workbook
  27. Binding a DataSet to a ListObject
  28. Help with Loopas
  29. Userform - indication of activity
  30. access controls on the spreasheet
  31. Find Range Location of a Shape Object
  32. Search and Replace a Spacific Character with Conditional Formating
  33. Error with Borders of a Range
  34. 'SaveAs Filename' versus 'GetSaveAsFilename'
  35. Setting formulas with R1C1 in VBA and eliminate $
  36. Swapping data between columns
  37. Condensing code
  38. delete rows for values
  39. Printing the contents on a named range in the Header of an Excel s
  40. Combo Box or List Box
  41. Big Problem with Excel 2000 / 2003
  42. retrieve data from MS Access
  43. Selecting a worksheet based on the sheet Number
  44. Opening a recommended read only file as non read only
  45. using activeworkbook.worksheets
  46. Intel Hex
  47. Looping and passing variables to a macro etc.
  48. Re: C# .net and Excel Named Ranges
  49. How to display date list in a calendar view
  50. XL Query Issue
  51. C# .net and Excel Named Ranges
  52. Macro to close embedded charts/resize in PowerPoint
  53. proper
  54. Passing IO.FileStream in Excel 2007
  55. Sub or Function not defined
  56. Convery to Number in VBA? How do you do that?
  57. removing the file extention
  58. Use a checkbox to change calculations
  59. using command prompt & FTP
  60. Graph to only include rows with data in
  61. Workbook file name
  62. exclusive macros
  63. Insert Comment
  64. Launching Outlook Calendar
  65. Export Excel to XML and Date Format
  66. Defined Names response
  67. Excel as an database
  68. Applying custom chart type
  69. obtaining the format of text in acell
  70. hyperlinks saving error in code
  71. Add Current date and time when pressing a command button
  72. OLE with Excel question.
  73. Cell Position
  74. Filter/Copy Unique records
  75. toggling checkboxes
  76. Transferring specific data
  77. VBA Sum Product
  78. Sum a column where the cells are based on calculation. HELP
  79. Excel help - Find and copy files
  80. trouble adding a name...
  81. prevent users from adding sheets / charts
  82. Passing a Variable to a Macro
  83. Transfer data between 2 workbooks opened with IE
  84. Deleting entire row
  85. Adding a DLL to Excel (2003) Object Browser
  86. Do NOT find in hidden rows?
  87. fill in cell before printing / saving
  88. Crystal Ball
  89. Copy paste one excel workbook into another workbook
  90. CopyFromRecordset fill back color
  91. Program text in wordart
  92. Count unique numbers multiple criteria
  93. combine
  94. Finding a specific cell value on different sheet
  95. Defined a range
  96. 2003 VB Excel back to 2000 VB Excel
  97. Prining with features (staples)
  98. charts converted to pdf
  99. Print Routine Needed
  100. iif statements
  101. Data Validation
  102. Drop Down List a la HTML
  103. load data from MS Access
  104. chart select causes error 1004
  105. Re: Cannot Read the posts above?<174d74c3-b82b-4a6f-abbf-d49609ba19ab@u12g2000prd.googlegroups.com>
  106. Autofill Dynamic Range
  107. If Then VBA
  108. excel query
  109. AppActivate - Question for Chip Pearson
  110. Compile Error: Expected Array
  111. Re: Read text file?
  112. Invoicing Capability
  113. A form combobox with list style as options.
  114. chinese (UFT-8) in csv files created by a server
  115. RE: copy range code
  116. If Empty run Macro
  117. Worksheet calculate -question
  118. Gridlines in listbox
  119. delete columns based on value in one cell
  120. Consolidate/ Clean-Up Some Code
  121. Macro for wrapping text
  122. Guidance, please (xl2007)
  123. Moving rng of wrkshts to new workbook
  124. Query Error
  125. Compiler Error
  126. Custom toolbars in templates
  127. HOW TO ADD OR DELETE ROW AUTOMATICALLY
  128. Looping
  129. fill userform textbox from userform listbox clik event
  130. Fix Comments
  131. Very difficult mathematical-iteration problem for engineers!!!!!!
  132. Macro call from another Macro
  133. Current position on worksheet
  134. Array of Collections
  135. Save only edited sheet within a workbook (Excel 2003)?
  136. How to get autoscroll in a multiline textbox?
  137. Re: removing any letter from string
  138. Re: removing any letter from string
  139. RE: removing any letter from string
  140. Re: removing any letter from string
  141. Can you launch Macros from a customized Toolbar?
  142. Move to next cell automatically after typing one digit
  143. Register user on worbook open
  144. Return to starting point
  145. Macro for bolding and italicizing word strings
  146. Count unique values in one column if values in corresponding columnare null?
  147. disappearing formats in UserForms
  148. Converting Consumer Reports rating symbols to numbers
  149. three or more interconnected worksheets
  150. Using DLL from C#
  151. Converting Consumer Reports rating symbols to numbers
  152. Help with Calculating Using Macro Pleaseeeeeeee
  153. Compile Error: With From:= << Highlighted
  154. Hide rows to create summary
  155. Delete certain files in all subfolders of specified folder
  156. Array formulas in named ranges
  157. Re: xlConstants to numbers?
  158. Copying Sheet1 to Sheet2 in a certain pattern
  159. Re: xlConstants to numbers?
  160. Extract Outlook mail using VBA from non default Inbox
  161. Re: How do you find ClassTypes Info..?
  162. User Form
  163. create worksheet with specific name
  164. Refresh ColumnTotal
  165. Filter The msoFileDialogOpen
  166. worksheet-change event in combination with a select case statement
  167. Override cell comment functionality
  168. Trim Function
  169. copy query table data
  170. List of Subroutines/functions in a workbook
  171. Match several values in ‘Summary Sheet’ to several values in ‘Mast
  172. sort button
  173. Data Error 9 Subprocedure Out of Range
  174. C# Referencing of Office Libraries without Office installation
  175. How attach an image and send mail.
  176. Group Highlighting
  177. Merging data from different workbooks
  178. Caching a high and low value
  179. Macro/coyy & Paste from a new data a fix infp
  180. Date->Text Format
  181. Macro/coyy & Paste from a new data a fix infp
  182. rs.addnew - named range vs. individual cell
  183. I want VB to select data automatically to the end of the row
  184. during a loop
  185. ControlTip Text
  186. Sum Time when not posted as time
  187. copy data of different range to other sheets
  188. Pasting in an Excel Macro
  189. Code not doing what I hoped for
  190. Search and Match Values
  191. Stop the loop after it runs for 10 times.
  192. UserForm problem
  193. Hide Pivottable GrandTotal using VB
  194. Macro to launch the Activate dialog box?
  195. Delete "count" of workbooks?
  196. If -Then in VBA Code
  197. Array formula[S] in named range[S]
  198. Close all other open Workbooks
  199. Mulitpages on Forms
  200. Macro Skip the Constraint (Solver)
  201. How to record macro using validated cells?
  202. Macro cannot access hidden sheet
  203. Help with code
  204. How to verify if a range (or a cell) is contained in another range
  205. Activate PowerPoint from Excel
  206. Get VB object worksheetname
  207. Repost: Excel 2007 and Declaring Variables
  208. Excel 2007 and Declaring Variables
  209. Solving Linear Programming
  210. Event Driven Procedure
  211. For...Next loop limits
  212. Office Automation Problem
  213. Excel application
  214. transforming data into a single format/file
  215. SUM Prices with variables.
  216. Multi Line listbox
  217. macro for different users... kind of
  218. VBA to identify the name of a point
  219. From Formula to Value
  220. column adjustments
  221. comments
  222. Complex Question. Index/Match then Copy/Paste to Summary Sheet
  223. Deleting sheet2 and sheet3 in a workbook
  224. Vlookup in VBA
  225. Variable Chart Elevation & Rotation
  226. Adding a line in a row
  227. Finding a Shape
  228. Newbie question : Help required on recalculation
  229. Transpose a variable length list
  230. Pivot Page field filter based on cell value
  231. Running A Shell Command In VBA
  232. Display a sequence of cell values based on the week
  233. Print CSV File With Correct Column Width
  234. Acrobat ribbon name Excel 2007
  235. Exit sub only and only if there is an error in the procedure.
  236. sumproduct help
  237. Reliably activate PowerPoint, do something, Activate Excel
  238. Saving a Workbook using info from a Cell???
  239. Button to increase cell value and print document
  240. Macro for sending e-mail with info from an excel sheet
  241. Create Graph with Data from 2 Cells
  242. Refresh Query if office 2007
  243. Calling on Methods and Properties within Worksheet Modules
  244. Shape Names on User Form
  245. How to stop 'Egg Timer'
  246. VBA to identify the name of a point
  247. using record macro, can I stop it to get user input?
  248. Format sheet header via vba
  249. Macro Copy and Paste Help - Macro and VBA Newbie
  250. VBA Macro - Loop through folder and move files to other folders
  251. excel limitation
  252. Splitting data from one sheet into 2 other sheets. Data is skewed
  253. Excel macro to execute Access query
  254. Find data on different Sheet
  255. 'Can't find project or library' error
  256. RE: Hide the running macro
  257. Tabbing through Protected Sheet
  258. Using IF function .....
  259. Matrix ANALYSIS
  260. RE: Macro won't run
  261. Months as Column Headings
  262. Sheet names from closed workbooks
  263. How can I program an Trailing stop loss?
  264. Print clipboard Contens
  265. VBA code for if no visible cells after filter goto next stage
  266. FormulaR1C1
  267. I want a range not to recalculate
  268. schedule
  269. Formatting problem
  270. Formatting problem
  271. Formatting problem
  272. Find Replace
  273. Count unique text in cell range
  274. How to load and import zip file using Macro?
  275. How to format cells of a column as text programmetically
  276. SUMIF CODE
  277. rearranging the data
  278. Formatting problem
  279. MkDir question
  280. formate sheet row a:a
  281. looping a code
  282. Matrix analysis
  283. On-Screen help
  284. How can i use Office Assistant and Balloons in 2007?
  285. Format Cells
  286. Very slow when I delete Row...how to speed up?
  287. Array Range
  288. Deleting sheets within a workbook
  289. Move files into particular folders
  290. Inserting three rows at the top
  291. Deleting a column using VBA
  292. Macro to reset Validation box
  293. Search with "Workbook" and "columns" built-in somehow?
  294. ADO access to excel workbook on website
  295. Making the worksheet.hyperlinks.add method work!
  296. More than 65,536 lines
  297. VBA for Lookup to other Columns
  298. Excel 2003 VBA - Select a range based on a date
  299. Excel 2003 VBA Assistance needed
  300. wait for data to be stable
  301. Left() Need the equivalent of this
  302. Re: some exotic error
  303. Problem using tab in TextBoxes not in Userform
  304. Re: some exotic error
  305. Conditional Saving
  306. hyperlink to word
  307. Formula R1C1
  308. cell format printing
  309. Loop Check for Workbooks already open
  310. copy hyperlink to clipboard
  311. RE: some exotic error
  312. Option Button Value Zero?
  313. Exporting to DB2 Database
  314. Rentacoder project: seeking spreadsheet/script/macro developer.
  315. Macro Modification help needed
  316. RE: Plain .TXT file to Word .DOC file via Excel VBA - Possible?
  317. Ensure range of cells each contain an value
  318. VB to send email via outlook to a distrobution list
  319. Re: Web query causes excel crash!
  320. Running a Macro when cell value is a specified value
  321. sendmail won't run on some computers
  322. IF value = "DEC" or "MAR" cut and paste 3 cells
  323. Dates in Excel
  324. SaveAs call changes text to #####
  325. Update on out of control Active Cell Indicator
  326. Referencing a workbook in a lookup
  327. Re: Requiring a value in a cell before allowing user to print
  328. RE: Requiring a value in a cell before allowing user to print
  329. SQL update statement in excel vba
  330. how to give variable range
  331. Exception from HRESULT: 0x800A03EC at Excel.Workbooks.Open
  332. VBA, 'implements', and occasional failure to upcast. [probably messyVBA internal bug?]
  333. Converting RTF file into TXT file
  334. If result of formula is zero disgard it?
  335. Extract first word for a highlighted selection (non contiguoes)
  336. AUTO FILL ADJACENT CELL WITH SPECIFIED VALUE
  337. =TEXT()
  338. Using selected dates to select a non contiguos range
  339. Convert American Date to Australian Date format
  340. Sum of each row.
  341. Pivot table - How To Obtain a External data Source??
  342. Get the last row
  343. Second Smallest Number in a Set
  344. Find the last Cell in a column in VB
  345. need to turn a word into numbers (or ascii codes)
  346. Pivot Table Help
  347. Command button
  348. Clean-up Code
  349. I have to rewrite the following for Excel 2003
  350. Trust Center properties
  351. Margin Lines in Print-Preview Mode
  352. Write a row to a email
  353. RE: do not delete "0"
  354. Help for Excel time format "MACRO"
  355. Assigning Range Names using VBA and R1C1
  356. do not delete "0"
  357. Can I Turn PivotCache Refresh (Calc) off & on in VBA?
  358. Hide rows in EXCEL
  359. sales report
  360. find multiple instances and select entire rows
  361. Selectively running macros on open
  362. Macro to set variable print area
  363. Date and time picker control
  364. RE: removing parentheses
  365. Make code more concise
  366. Modules - Save each code in seperate module? or group like code in
  367. Excel 2003 and AppActivate (patch issues?)
  368. Help with automating macro
  369. Excel:VB properties window will not open; project explorer is ok
  370. Exporting An Array to Access
  371. Interior Cell Color Numbers
  372. Setting Print Range
  373. adding shortcut to Quick Launch
  374. MultiPage TransitionEffect won't work.
  375. subtotal efficiency problem
  376. Change cell colour on formula result change, no conditional format
  377. extract and compare
  378. extract and compare
  379. What is calling this?
  380. Visual basic for a rightkey command
  381. Create UDF in Class Moduels? (frm Leo)
  382. GetSaveAsFilename/GetOpenFilename
  383. Add Values in a comma separated cell to combobox
  384. Select the sheet to the right Q
  385. I need help with a macro to compare data between worksheets
  386. TabSritp & Multipage
  387. How to get info of new filename and new path
  388. Excel ActiveX Combo - AutoComplete and LIst Issues
  389. Moving VBA6 string functions into VBA5
  390. Printer Names on a Network
  391. Cycle through all workshhets
  392. Excel Image or Picture from SQL Image Data Type
  393. Move one ws to new wb. Save new Wb with same but modified name as original WB
  394. Checking all sheets except 1
  395. Personal.xls TOO slow
  396. Copy row Macro Help for VBA Newbie
  397. Multi Pages Setup
  398. Need Help Converting Hypertext GIFs
  399. Calculate string width in inches nzDec01
  400. Check before overwriting file?
  401. Importing a collection of WB's where one or more WB's is alreadyopened by a 3rd party
  402. Disable WorkBook AutoOpen
  403. using SQL to query Excel (or Access?) selecting specific row numbe
  404. Invoking a macro from a cell change
  405. multiple conditions for if then else
  406. RE: User Form
  407. Change web address in macro
  408. Assign shortleys to macro
  409. Re: User define function that reply array
  410. Finding last appearance of given value
  411. Sorting of sorts
  412. Sending An Email In Excel Programmatically W/O Sending An Object
  413. Userform Instability
  414. Microsoft Query - reference to subquery alias
  415. Unexplained size increase
  416. Inser picture problem
  417. Run Part of a Module Q
  418. running Excel2007dllsdk
  419. Opening New Work with Wedpage Content when address is in original workbook
  420. can i format a group of cells based on the number entered in a cel
  421. Fi nd & Replace
  422. Hiding entire row(s) on entering data in cell(s)
  423. Unwanted characters saving to fie
  424. Error due Changed Drive
  425. Object references
  426. Editing user defined functions
  427. Help with Error in Function Definition
  428. Close all Shared Workbooks
  429. Formula in Range
  430. How do I do this.
  431. Re: Networking by VBA
  432. Excel 2007 Crashes in Vista
  433. DoEvents(?) issue
  434. The Immediate Window
  435. CountIf on not number values. How can I solve?
  436. How to write a macro 30 Nov?
  437. Does VBA support multi-thread?
  438. Can I prevent a user from running a macro?
  439. afterupdate event in Excel
  440. Conditional Format to highlight differances between to sets of data
  441. Any way to add hex numbers?
  442. RE: Copy Up To Top 10 To New Worksheet
  443. For each, Next - 4 worksheets
  444. Pivot table
  445. restore sheet
  446. Macro to select a cell in a table from a reference in a different
  447. Graphics question
  448. How do I resolve recordset overflow?
  449. Can I add data to a pivot cache?
  450. VBA for Virtual Earth
  451. Re: Missing Library
  452. Last saved by
  453. Sales Schedule
  454. raw of code..
  455. need more than just 3 conditional formatting.
  456. Create custom wildcard for searches?
  457. automatic unique value extract
  458. trying to make a simple search.....
  459. worksheets scrolling
  460. Can't change pivotfilter value1 parameter in code
  461. Date formats change (code included)
  462. transitions in ms excel
  463. Delete data Help!!
  464. closing a workbook with a macro
  465. Save user entered value in hidden lookup table.
  466. Test for File Creation Date
  467. Processing groupbox values
  468. How do I select a range to merge cells?
  469. Recongnizing #N/A as cell contents
  470. close workbook event
  471. Kill all files in Folder, If folder exists
  472. Copy row from one workbook to another
  473. RE: Inputbox & “Processing…” window
  474. serial port
  475. Run a macro from a vbyesno Msg box response
  476. Compile error [Chr(13)]
  477. colour palette reset
  478. Disable links to other workbooks
  479. Hiding option buttons
  480. RE: Second Sunday in the month of May?
  481. Re: Second Sunday in the month of May?
  482. Lost from memory
  483. HOW DO I DETERMINE AN EXCEL FILE CONTAIN MACROS OR NOT WITHOUT OP.
  484. for next loops in visual basic excel
  485. Top 5 most recurrent values in range.
  486. Delete Column having specific word/value
  487. Enable / Disable Buttons
  488. Reinstall Custom toolbars
  489. Open file for output
  490. XL2007 .CodeName bug when copying sheet
  491. Tracking training by percentage
  492. conditional format - put inside a for/next loop
  493. Setting a cell background color
  494. Programming Validation
  495. Some Error on e-mail
  496. Include "00"
  497. Converting CtrlShiftSpacebar to VBA code
  498. Creating a Custom Worksheet Object
  499. RE: Importing stored procedures into Excel with parameters
  500. workbook code window
  501. Instruct to start in Row 5
  502. Insert data into SQL Server db - find out the record number
  503. For Loop
  504. Run Macro based on cell change
  505. Trigger Macro based on single Cell change
  506. Trim Entire Column
  507. Textbox not filling from listbox
  508. excel macro
  509. Excel 2007 ang "Group row" option
  510. truncate text in each cell in column
  511. MsgBox responce If statment
  512. trigger msgbox when certain conditions are met
  513. Run Macro at specified time
  514. HELP: Performing multiple cell changes in a range - converting text to numeric
  515. RE: UDFs and Conditional Formatting?
  516. RE: change pivot filter through code
  517. print embedded multiple page OLE objects
  518. VBA searching through range and pasting value if no match is found
  519. RE: UDFs and Conditional Formatting?
  520. Re: UDFs and Conditional Formatting?
  521. Excel 07 vs. 03 "listrows" reference <subscript out of range>
  522. Generate data with all combinations
  523. Sending PDF with Outlook
  524. LOOKUP, MATCH MORE MATCHES IN TWO COLUMN
  525. Select only Text duplication
  526. Can Add-in determine if macros enabled in another workbook?
  527. Calling a Sub in Personal.xls
  528. XL2007: Copying worksheets between workbooks
  529. Split LastName, First Name column into 2 seperate columns
  530. How to move data from many spreadsheets to one
  531. Help with Correct Call for Ron de Bruin's "RDB_Last" to Find Last Row in a Column
  532. Changing properties of a file with VBA
  533. How to get a permanent Range address?
  534. Out of control Active Cell Indicator
  535. ChartWizard difference between Excel 2003 and 2007
  536. How to list Workbooks associated with VBA Code.
  537. Textboxes not populating from listbox
  538. Getting a "Read-Only" error
  539. wait msgbox for 3 seconds only
  540. Random Cell Value Display?
  541. Trigger VB code on user selection from Page field in Pivottable
  542. Email Workbook - Outlook object model (attachment) - runtime error
  543. auto close in Excel 2007
  544. Edit Cell with "/2"
  545. function to modify other cells
  546. 2003 vs 2007 Macros
  547. double sound alert for on-line stream
  548. Class module Question
  549. Problem with MUI and Excel Add-in
  550. Copy two sheets into new files and save to multiple locations
  551. how do I pass myfunction(A2:A4) instead of myfunction("A2:A4")
  552. Headers and Footers by VBA?
  553. Sorting a range with duplicate values
  554. Which Dialog Button? (XL95 in XL2007!)
  555. ADO Connections
  556. Looking for a way to calculate the minimum and maximum value of a formula .
  557. OR
  558. prevent doubleclick for command button
  559. How to Activate and Dropdown a Combo Box
  560. sumproduct problem
  561. macro
  562. Loop within a loop
  563. Link an IF to a Vlooup
  564. Formula Array - Syntax Error
  565. Determining if Cell has Formula
  566. Deletion of Data across multiple sheet
  567. execute a macro from a dialog box on enter
  568. Problems with mouse in Excel Automation from VC++ 6.0.
  569. strange behaviour
  570. Transfer files & change file attributes with VBA ?
  571. Workbook_BeforeSave not working.
  572. Ranges vs cells with VBA
  573. draging formula
  574. script help!
  575. IF function to get a (specific) name from a Vlookup and convert va
  576. PERSONAL CRASH
  577. Automatic Unique Values
  578. Running a macros every Monday, Wednesday, and Friday
  579. Cell specific code
  580. Validation list problem
  581. Define the Range of a drop-down list
  582. Link an IF formula with a cell containing a Vlookup formula
  583. Combo and List box combination
  584. Counting unique formats in a workbook
  585. switching between workbooks
  586. userform duplicate control not working in my code. Thank you
  587. ShowMe function works fine except I need the offset to adjustdepending on column
  588. Connecting Excel to Access Using Late Binding
  589. Counting backwards through the File System Object files collection
  590. setting ranges and vlookup in custom functions
  591. Flashing Cell for a number range
  592. Calculating Staffing on a Schedule
  593. Contiguous Ranges and 255 Char Limit Constraint
  594. array formula doesnt work from row 32737
  595. Text box macro button...need it to remain stationary.
  596. Listbox Change events triggering when i "Save As"
  597. Format Paste from nonmerged cell to merged cell
  598. Cells Within Range Failure?
  599. Improvements to code
  600. RE: Reading Comm Port in Excel
  601. Auto Open + Disable on Final Product
  602. Populate an input box in a macro
  603. Re: Reading Comm Port in Excel
  604. Open Access DB in Excel 2007
  605. Duplicate Group Names
  606. this newsgroup on easynews
  607. Closing multiple workbooks?
  608. Excel macros in XL2k Pro vs Std
  609. Use loop to filter, copy/paste to new sheet; run through entire li
  610. Combining Variable Sized Ranges
  611. Multipage default open
  612. search box
  613. Changing tab order of locked worksheet cells
  614. I want 'Enter' to be a line break in a text-box
  615. Sort in Office 2007
  616. Change cell colour to red
  617. How to: If autofilter is "all" then, else...
  618. changing a color based on another color change
  619. vlookup function
  620. Getting r/t 13 - Type Mismatch on this line - Why?
  621. Count all "xlsx" fromat files in a Folder
  622. Doughnut chart with VBA
  623. COM Controls in Excel
  624. Re: Sumproduct VBA
  625. execute a function with a dynamic name
  626. Next blank cell
  627. Remove Middle Initial
  628. Delete row/s with the same elements as the above row
  629. Deleting a sheet with VBA
  630. VBA ".Clear" Error
  631. insert table into specific location
  632. Help with converting code - import > 65536 from Access
  633. Find, Copy and Paste
  634. Please Help on Object Library Invalid or contains....
  635. comparing 2 worsheets using a macro
  636. Another Simple GoalSeek question ??
  637. What do I need to do o = New Excel.Application
  638. Code acting weird with sheets with collapsed groups
  639. Calendar Control Linked Cell
  640. linking pivot table selections
  641. Re: Excel Security Update 2003 (KB955466)
  642. How do I create a Reset Button on a form created in Excel
  643. Two problems inserting a formula
  644. Override a built-in command with a macro
  645. AutoSize a cell comment
  646. Re: Font in MsgBox?
  647. RE: Font in MsgBox?
  648. RE: Font in MsgBox?
  649. count number of times a particular letter appears in a cell
  650. RE: Excel Security Update 2003 (KB955466)
  651. RE: Excel Security Update 2003 (KB955466)
  652. Totals An Easier Way??
  653. Number Stored as Text Issue
  654. For each chart loop not working
  655. Excel code
  656. Translate to code
  657. Using Offset on two seperate worksheet
  658. Active Workbork Issue
  659. Delete row with the same elements as the one above
  660. Working with Linked files
  661. Calendar control (view/layout problem)
  662. If A1= yes then calculate index
  663. Delete Entire Row for duplicate values in selected column
  664. How to Select Successive Groups of Individuals for Trendlines
  665. Finding the last used column
  666. Using Query to return data from SQL database
  667. RUNTIME ERROR 1004
  668. Macro to select only cells containing values within named range
  669. change pivot table in code
  670. New VAT Rate
  671. how to wright this formula in VBA code
  672. Assign Shortcuts
  673. Importing .csv with #2000-04-06 10:15:00# date format field
  674. How to expand or stres row summaries back to row details?
  675. How do I add properties to add-in ?
  676. Marco that will run if the condition met 2
  677. Excel / SQLite
  678. Finding ways to identify last row of every printed page
  679. Open file dialog box works in XL2000 but not in XL2003
  680. Continue running macro until last line of data.
  681. Adding a right-click context menu to Excel VBA TextBoxes
  682. Macro to select data Validation List Item
  683. Conditional find and copy to different worksheet.
  684. Changing font color based on type cell it is. How to do it?
  685. RE: code stops working after X rows.
  686. Row numbering from a macro
  687. Using Ron's Sub Copy_to_Workbooks
  688. Use CASE?
  689. Alphabetical sort but includes the expanded section when it rearra
  690. Changing hour and minutes to percentage of hours
  691. Change Value of Cell in Printed Title - Print Preview Event?
  692. What is wrong with this?
  693. List out the "Find All" results list?
  694. Copy and Paste + erasing date
  695. a few adjustment for a do-loop escape
  696. sumproduct in VBA
  697. Create Object for MS Mail
  698. time formula
  699. to many e-mails
  700. Copy Row 2 from Sheet1 & Paste to Row 10 Sheet2
  701. Status Bar Message
  702. Text box last entry
  703. Start my Application in its OWN instance?
  704. Autosize
  705. copy adjacent cells also and put totals at the end (for copied cel
  706. How to enter a non-standard format hyperlink
  707. For every empty cell in a column, copy the value from the above ce
  708. conditional formating
  709. Copy data from new file in a folder
  710. Date value
  711. Change a pivot field based on another pivot field
  712. Run time error 53, cannot find file
  713. Finding/Moving Columns within Macro
  714. Assigned macro change
  715. Vlookup - Multiple Sheet HELP PLEASEEEEEEEEE
  716. Functions
  717. Reapply filter
  718. Filtering Automatically
  719. my incomplete macro to fill in 8000 rows - pls help
  720. Run code conditional on sheet visibility
  721. Close form when I press enter
  722. Change MS Access query from Excel
  723. User input - string on userform
  724. batch update excel with add-in
  725. How to change MS Query via VBA
  726. Sumif
  727. Following a web query with a macro
  728. Color cell font text based on cell type? How do it.
  729. Splitting a row of email addresses
  730. Match, then Look Left 4 Columns, then Loop to End of Range
  731. Re: Picture in spreadsheet to picture in userform?
  732. Error Message: "Can't Execute Code in Break Mode"
  733. RE: Picture in spreadsheet to picture in userform?
  734. Multiple workbooks - NEED HELP
  735. ASP.NET 2.0 in Visual Basic Language
  736. error with chart object
  737. Testing For Range Variable Limit
  738. Match six digits and copy specified row
  739. macro to keep chart dual axis format
  740. Data filling question
  741. Excel Application Examples?
  742. How to order numbers
  743. Show progress with an Asynchronous ADO recordset
  744. Dynamic Userforms,
  745. looping through txt files and pasting into a excel worksheet
  746. Conflict Between Two Add-Ins
  747. List of open workbooks and their User Names from Folder X
  748. Formatting borders
  749. running change events to macros
  750. Print Access reports from Excel