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. Make changes to Options in Internet Explorer and log onto a networ
  2. Adding a new menu on the Worksheet menu bar
  3. Report creation in Excel Using VB.Net App.
  4. Intercepting the Save
  5. For control variable already in use
  6. marco to move a sheet
  7. Open file already open by other user
  8. VBA in 2007 interface programming question.
  9. Could my ADODB connection be causing a network problem?
  10. cant draw connector lines between 2 shapes
  11. PLEASE HELP with populating userform fields from access database
  12. Design of web service for Excel consumption
  13. animated text in a userform?
  14. Why does Excel think this is a number?
  15. Dividing lines in userform list boxes
  16. AutoFitMergedCellRowHeight limitation
  17. Don't refresh tables on Open
  18. Re: MACRO Recorded and saved does not run the second time.
  19. Import external data from Access query with Variable
  20. opening a userform from a userform
  21. Copying command buttons
  22. RibbonX, Keytips, Menu Controls and Underscores?
  23. Destroy VBA code within a macro
  24. Importing / Linking Dynamic Data or ASP Tables into Excel ?
  25. Adding an image to an Image control
  26. Open and Save Files in Directory
  27. Setting up Solver reference in a protected VBA project
  28. Setting up Solver reference in a protected VBAproject
  29. Getting info from other Excel Files
  30. if then statement with a vlookup?
  31. Check Auto Filter - if on, turn off before running macro
  32. creating groups from an existing list
  33. Macro Help
  34. code breaks in macro
  35. file names and path. How text to columns from right to left
  36. Open multiple workbook then combine into single workbook butdifferent sheets
  37. make changes to Internet Options and how to log onto a private net
  38. UserForm Query
  39. Macro to copy and paste
  40. Using Excel to WRITE to a closed Excel file
  41. Alternative to Calendar Control 8.0
  42. Calendar control code
  43. Problem reading with Percentage values
  44. Do you need MS Access to query on an Access table?
  45. Application-defined or object-defined error
  46. ListBox TextAlign-Property Question
  47. Re: Ribbon X macro not available
  48. Simple Range Syntax Question
  49. retrieve an AVERAGE of a range using VLOOKUP to locate start/end d
  50. String comparison
  51. disable sheet while processing
  52. Help with Date functions
  53. Printing userforms
  54. Help. Sumproduct Data Type Mismatch Erro
  55. read vs write file
  56. MACRO Recorded and saved does not run the second time.
  57. kb973593 bug
  58. copying a range of data multiple times from multiple workbooks
  59. Open file validation
  60. multiple value choices for If range().value = "xxx"
  61. Message box this is what your looking for
  62. pasteall problem
  63. MsgBox in another Instance of Excel
  64. date comparison
  65. ThisWorkbook.RefreshAll Issue/Question
  66. Formatting a subtotal line with a macro
  67. Sumproduct gives #Value! when answer=0
  68. How to assign range to Double array?
  69. Moving Files
  70. How to work with reference unions (A1,A3,A5)?
  71. VBA Password Workaround
  72. Set up macro (or formula)
  73. Macro shortcut glitch HELP!
  74. starting Word from an Excel macro
  75. VLookup and Indirect
  76. Coding deletion
  77. Date Format
  78. Include Dropdowns and Checkboxes in Worksheet Change event
  79. Macro Security Warnings
  80. Coonect to access with password
  81. Copy from one source to multiple spreadsheets
  82. How to use comma separated inputs in macro
  83. How to call a macro from a xlam in a xlsm
  84. list workbook names except one
  85. Hyperlink File Help
  86. Averging data when criteria is met
  87. Hyperlink File Help
  88. Hyperlink File Help
  89. Hyperlink file help
  90. add combox with code
  91. Emergency! Switching to Office 2007!
  92. Not sure what the subject is
  93. Change row colur
  94. Getting info from closed Excel files
  95. VBA to remove records
  96. Excel Database and Macros
  97. merge data macro
  98. Macro to FTP a CSV
  99. Publish charts as PNG
  100. Using VBA to read/write data from Excel files
  101. Workbook with Macros won't share
  102. Macro to copy from one source sheet to numerous destination sheets
  103. strange result for SpecialCells
  104. Ribbon's equivalent to CommandBars.ActionControl
  105. making a countdown timer
  106. Adjusting row heights and column widths to align with another sheet
  107. if then and do - DA
  108. SUMPRODUCT Formula Not Calculating with 2 criteria
  109. Modify Recorded Macro
  110. OT: IE Save Dialog gone!
  111. Reference a workbook chosen by a user from a userform
  112. Copy from one open workbook to another?
  113. Finding rows that contain Keyword1and Keyword2 in any part of fieldin Column A, B or D
  114. copying VBA from one Excel file to another
  115. user-defined data type capabilities
  116. sumproduct ?
  117. Date Format
  118. Can't get length of a variant array passed to a subroutine
  119. Hiding a "Userform" instead of closing it???
  120. String to Number Conversion Problem
  121. How to express a set of cells as a range
  122. Pasting Data into a webpage text box
  123. Cut and paste objects into userforms
  124. Drag and drop text in userform text / combo boxes
  125. Check values in each column
  126. Re: Pasting into a Webpage Message box
  127. looking for matches from 2 different sized ranges
  128. Using "Select Case" inside Worksheet_Change() subroutine.....
  129. Defining variables
  130. Preventing "save changes" dialog box???
  131. 2nd question - Calendar Control 8.0
  132. Cell entry triggers Worksheet_SelectionChange event
  133. Button for a Macro
  134. select a range by cell names; vba
  135. Copy from one worksheet to another
  136. Problem with copy from one worksheet to another
  137. combo box value
  138. Sumproduct formula works in spreadsheet, NOT VBA. Help please
  139. Workbook_Activate() vs Workbook_Open()
  140. I have excel 2007 but I need 2003 tool bar
  141. simple question regarding pasting
  142. The worksheet calculates too often
  143. Set Print Area with Dynamic Start Point
  144. Calendar Control 8.0 question
  145. Index-Match and Like...maybe...
  146. Help with creating dynamic table & filtering
  147. Workbook_SheetCalculate Method
  148. XML Data
  149. Re: Create a new worksheet (excel 2003) if one or more cells in arange is not empty
  150. Create a new worksheet (excel 2003) if one or more cells in a range is not empty
  151. Why Range name not showing in list
  152. display dots inside a cell in graph form but without Excel graph?
  153. How do you work with high character numbers?
  154. Creating a Pivot table
  155. VBA - Copy/Paste to next empty cell
  156. Axes(xlCategory) for a chart-sheet in 2007
  157. Sum using ordinal/relative positioning
  158. Is there another way to write this?
  159. VBA code
  160. Remove some intermediate lines
  161. Excel 2007 Smart Forms
  162. Moving files based on cell references
  163. Selection Change Event
  164. read hidden cells; vba
  165. Show a range in a shape/picture object
  166. conditional format -- if not a date, then highlight cell
  167. Macro Recorder
  168. Macro Quick Key
  169. userform list setup
  170. Please help!
  171. Remove a shortcut from desktop using VBA code
  172. DataObject: PutInClipboard Not implemented
  173. Charttiltle as function
  174. Excel getting info from Access
  175. Insert formula to range of rows (Variable) from macro - debug help
  176. Update value. Function
  177. Array within a dictionary
  178. Sumproject Run-time Error 13
  179. help needed with graffiti.net email query
  180. Open Search and replace dialog
  181. Open Search and replace dialog
  182. How to retrieve data from share folder using vba?
  183. How open multiple file using vba then later combined into oneworkbook
  184. Group
  185. Feasibility of 365 day workbook???
  186. Mysterious re date Format
  187. ODBC - SQL parameters error
  188. Filter based on named range cell - debug help required
  189. Hidden sheet tabs (to store data)???
  190. need to automate a sheet re-organization
  191. Save the ppt file with password
  192. VBA Code not shown
  193. Detect top, left & height of activeworkbook? How do?
  194. Copy from one open workbook to another?
  195. creat sheets with assigned name and protected
  196. Want Macro to save to .xlsx
  197. Acos in WorksheetFunction
  198. Chart Question for Excel 2003 **Desperate**
  199. sub tot column to next blank cell when blank cell exists in both c
  200. Using VBA with Pivot Table Report Filter
  201. Only keep rows that contain
  202. Ron de Bruin's merge cells to master sheet
  203. Assign macro to check box?
  204. Copying and Adding Values
  205. Sumproduct in VBA Type Mismatch problem
  206. complicated Vlookup?
  207. Referenced Workbook Add-In Slow to Open in 2007
  208. Getting all open files in Excel
  209. VBA Format for a Range Name Used in the Sum Function
  210. Joel - The DBF Solved
  211. Error 13 Type Mismatch
  212. How check if file to open is Excel or if Excel file is corrupt?
  213. Open a sheet based on day of the week!
  214. November 10, 2009 Security Update macro problems
  215. search posts
  216. Passing a range from worksheet to VBA function
  217. Oracle <CLOB> question
  218. Select range of cells in column AS based upon lastcell in col A.
  219. Reverse sign of range
  220. Time-Saving Metrics on Sorting By Color
  221. Use memory variable in range selection
  222. set pivottable source data to range name
  223. Get Access Data into Excel
  224. Show cell contents depending on other cells information
  225. can msoFileDialogFolderPicker display file names in the folder
  226. MS Excel 2003 to Mac Office (Excel) 2004
  227. Workbook_BeforeSave Event
  228. filesearch frustration
  229. Make cells blank IF
  230. Can I use a macro to create a macro in a new workbook?
  231. Printing Macro
  232. Still need help on Macro
  233. Delete Rows that do not contain
  234. Macro to pull every Nth row of data
  235. How to match debit and credit line item
  236. Problems saving XML file: Run-time error
  237. userform help
  238. Excel Function not Evaluating to a Result
  239. Specifying which axes Excel uses to plot a graph
  240. Need Marco Help please
  241. message box caption color
  242. Giving back
  243. Cells formaring with VBA ?
  244. How to add condition within macro?
  245. dynamically increase x axis
  246. Tricky question about rows of cells.
  247. convert to Numer
  248. Internet Time and Excel
  249. Linking to Access Table
  250. What's up with mswinsck.ocx ?
  251. Book with 365 sheets??
  252. Protect Workbook in 2003 changes to password to open in 2007
  253. Array in Both Branches of an If Statement
  254. Evaluate File for Last Updated Date
  255. How do I connect to a sql server over an IP address?
  256. Run-time error '9'
  257. Significant figures
  258. Delete all rows not current date
  259. Extracting numbers from a string containg letters at the end
  260. Changing color background in a range from a drop down
  261. The mode function
  262. Delete rows with names
  263. on error msg box help
  264. HELP Error: Trying to populate userform fields from access databas
  265. Print group of records with same Customer name
  266. IF a cell is active THEN...
  267. Number Stored As Text
  268. Personal macros file
  269. Position Userform In Cells Portion of Excel Only
  270. How do I Shorten Object References?
  271. Populate date into excel from DataSet/DataTable
  272. Why are the two codes below not getting the right formula for myworksheet event change formula?
  273. help with sort on active cell
  274. MultiLine Code Builder, Need Help to Clean Code:
  275. referencing web site object
  276. Joel - The DBF4
  277. Autofit -
  278. Calculating a sum, exceptions for specific values
  279. Copy URL to clipboard
  280. Lost VBA
  281. Change file name from folder using VBA
  282. combining rows
  283. Excel Instance not cleaned in Task Manager (Interop)
  284. SasAs Issue: Automation Error
  285. C# Add-in and PivotTables
  286. How to run macro to shut down my PC?
  287. sort dynamic range on active cell
  288. Looping through sheets
  289. Password protect all files in a folder
  290. Open file with a Pivottable Protected
  291. duplicate data in range clear contents
  292. writing a vba code for a simple function
  293. Problem with Code to Change Font Colour Q
  294. Formula Cell Error
  295. TRIM, CLEAN, or Something Else?
  296. Print Spreadsheet to PDF file
  297. STOP close button on another workbook
  298. VBA Borders in Excel 2007
  299. Delete columns based on a cell reference date value
  300. New to Excel/VB and could use any help
  301. Function to Return the IP Address of a known Host
  302. can anyone help me finish this
  303. Visual Basic for DOS
  304. Formatting cells entered by a macro
  305. Ghost VBA Projects Created when using Hypelink
  306. Macros help!
  307. a way to append data from 2 different files
  308. Pull info from access to excel userfom and edit an existing record
  309. VBA question
  310. Maco question
  311. Rename Sheets based on List
  312. Convert (-) to a (+) number Macro
  313. Populate ComboBox with Worksheet Names
  314. VBA Copy Range of cells with a condition to another worksheet
  315. Save last row to use in another set of code
  316. #N/A
  317. Data analysis by 2-dimensional data table + database
  318. Inserted rows, now need Counta function
  319. Counting Highlighted Rows
  320. Limit size of number input
  321. Change page orientation to suit selection
  322. default workbook name
  323. 2007 Even/Odd/MOD
  324. automatic replacing of vbe code for multiple workbooks
  325. Selecting top 15 records for multiple selections via VBA
  326. Convert Radian to degree angle for COS function
  327. Aligning edit boxes on the Ribbon
  328. Like-for-like cell linkage returns '#N/A'
  329. Changing Input to code that creates a chart
  330. Extracting Data from Access dB to Excel, using VBA
  331. advanced filter office 2007
  332. Working with the current selection
  333. Dim xls As Workbook, Dim Csv As ????
  334. Dynamic range thru inputbox
  335. Start Macro when specific Cells are selected
  336. Customize Ribbon with excel interop
  337. Customize Ribbon with excel interop
  338. Data collecting from different sheets
  339. Insert cells at end of selection
  340. how to loop through shapes in powerpoint vba
  341. Changing name from Arabic to English
  342. Macro to delete a specific sign
  343. Deleting duplicated rows based on data in two columns
  344. Userform question
  345. Defining a range
  346. Excel crashing during macro (but very odd)
  347. Combobox strange behaviour
  348. userform question
  349. user form start field
  350. Looking for a macro to remove Line Feeds and Carriage Returns
  351. Why Doesn't This Work? (Page Setup)
  352. Data in a Calender layout view
  353. Ribbon - custom button calls macro with argument
  354. user form parameters
  355. Dynamic Image references in a cell
  356. Count only cells with red font.
  357. Timer recalculation
  358. Transfering data from one spreadsheet to another.
  359. HELP: Export data to word template and save it as a seperate file
  360. HELP: Trying to a word template with name from userform at a diff
  361. Combobox add large range of cells
  362. Wrestling with fractions and dates. Knowledge of photography is helpful.
  363. Display ranges from one worksheet to another
  364. help with HUGE file building list
  365. data lookup/validation syntax
  366. Autofil on variable rows, delete extract and show remaining rows
  367. paste linked cells show "0"
  368. Copy only visible cells after applying "Subtotals"
  369. Problem with Vlookup
  370. Copying Data from One sheet to another
  371. VBA//Oracle Interfacing Question
  372. Count filtered rows
  373. Help with my Excel Database
  374. reset combobox to blank
  375. UNDO become impossible after modifying SheeChange handler
  376. Pivot Table Page Fields Selection
  377. Macro
  378. Well, how hidden is it ??
  379. Automating Making a DBF File
  380. Prefill column
  381. Should be an easy but I can not figure it out!!
  382. what type is calendar control
  383. Re: code to sum 8 textboxes
  384. code to sum 8 textboxes
  385. Turn pc speaker on/off with vba code
  386. Timestamp a cell when row is updated.
  387. Append Below
  388. Syntax Error Writing in MDB table
  389. Re: How can i make a macro run all sheets ?
  390. Remove a cell's CF by double clicking it
  391. MS Query has data, but does not transfer it to Excel
  392. find text and copy selected rows from text and loop
  393. Conversion from text to excel
  394. is there an add-in to use genetic programming in excel?
  395. Run-time error 1004
  396. Please Help (Unusual Lookup)
  397. conditional formating
  398. Little help - Quotes in VBA
  399. Need macro to turn off AutoFilters in a table (repost)
  400. Show the Paste Names dialog via code
  401. Need Excel macro to turn off AutoFormat in a table
  402. Data entry form macro shows wrong formats
  403. Re: CommandBars
  404. Scrol window
  405. Excel Game
  406. Find & Replace Macro
  407. remove all format(s) on a sheet
  408. excel macros
  409. Option Button Stays selected
  410. too long a formula, can someone cut it down
  411. Runtime error '16':
  412. File dialog makes application visible
  413. Tools for Analysis - Samples with VBA
  414. Related Functions
  415. Date and time picker use in a userform
  416. Web Login, Table1
  417. explicitly name workbook and close without saving
  418. INVALID PROCEDURE CALL OR ARGUMENT
  419. double click event search in other workbook
  420. Re: Remove password on 'file save as'
  421. save only selection and subtotal
  422. How can I open an ODS file?
  423. Is Sheet Empty and unused
  424. search button to populate cells from sheet
  425. Calculate Range run-time error 1004
  426. error on sorting a range
  427. VBA compatability
  428. Addin compatibility between Excel 2k3 and Excel 2k7
  429. Rounding range of cells
  430. Problem with IRibbonUI - Help please!
  431. German VBA
  432. Excel/VBA Coding Help
  433. Format linked workbook cells (updated)
  434. Sending Excel Worksheet as PDF file with Excel 2007
  435. #N/A Conversion
  436. Address Range in Email Script
  437. Save a pdf to the desktop with a filename as a cell reference
  438. I need a Magnifier for electronic maps
  439. Format linked workook cells
  440. deleting first 10 characters in a cell
  441. Auto filter, sub totals, text
  442. Adding Column Headings to a ListBox
  443. Better way to select Cell in Range
  444. visual basic in excel dictionary/glossary of command terms
  445. Help with Time Calc
  446. Attn: VBA Yahoo Finance Historical Quotes
  447. Row find Macro
  448. Making a list of 100s of items typing narrows search
  449. Dividing variables
  450. AutoFill down a certain number of rows
  451. Excel Pivot Items Using C# - Unable to Access
  452. Two macros with same name in different workbooks
  453. How do I get the row number?
  454. Cropping an image
  455. No filter rows
  456. advanced filternot working in macro
  457. Select (highlight) Text in txtBox at Initialization
  458. random numbers from list box
  459. copy date to text
  460. Fill down Formula Automatically
  461. Excel buttons
  462. switch automatically between text boxes
  463. Code to resize image
  464. Image resizing
  465. Look up question from changing range with criteria
  466. Delete Entire row if value don’t match
  467. Time Stamp help
  468. Charts Having X Axis Scaled Using Calendar Weeks
  469. Find similar items from a two fields.
  470. Rnd() 1004 error
  471. Dynamic Ranging
  472. on error help
  473. triming the first 10 characters in a cell..
  474. Excel Shapes
  475. automation to remove certain characters from a cell
  476. Mystery of the re-appearing custom toolbars
  477. Can I use VBA to copy from excel and paste
  478. Validation List
  479. stdev CF Formula
  480. Need help
  481. auto running macro
  482. Vlookup return %
  483. Call subroutine problem
  484. How can I use vba to populate a website input box?
  485. Ping
  486. Converting workbook to run on German excel
  487. Pivot table Macro
  488. same button on multiple pages
  489. Variable in formula problem
  490. formula variable prob.
  491. adding comment to cell if value changed
  492. Split Workbook into Multiple Workbooks
  493. Create Hyperlink to URL
  494. submitting a cell into a search box on a website
  495. automation of sub
  496. Insert Picture using Macro & Validation list
  497. Validate Text in Textbox to Ensure Text is a Valid Price Format
  498. How to insert email signature from EXCEL VBA
  499. Editing controls on a userform en masse
  500. HELP with .HTMLBody: Display Hpyerlink in email body
  501. Using VBA to evaluate ranges of data
  502. Scheduled task "Error # 70 was generated by VBAProjectPermission
  503. Run-time error 13: Type mismatch
  504. So then how to a get arrow keys to control a spinbutton?
  505. Excel (or Access) Challenge
  506. RE: Create new worksheet with Excel Macros/Formulas from another works
  507. How put Array in VBA
  508. Long Block & "Name Box"
  509. If Code
  510. after filtering, change every cell in column J
  511. Office Discussion Forum
  512. Finding the next blank cell
  513. workbook
  514. VB macro script to find column A in Excel when row not known
  515. Scheduled Task Fails running Code to send Outlook Mail from Excel.
  516. Macro to populate cell value from another sheet based upon the datavalidation list selection
  517. Excel 2007 bug caused by latest security patch KB973593
  518. Using SQL (with a Group by function) inside EXCEL VBA
  519. Need advice re: date without slashes
  520. Random Number
  521. help with on error stuff
  522. macro to set cell protection by row, based on pre-populated values
  523. Trouble with conflicting IsBlank() and CountBlank() results
  524. Insert Page Break Based on Text
  525. Excell
  526. Reference Errors with Distribution of excel sheets with macros
  527. Range to Variable for Sort
  528. VBA Help
  529. auto fill cells with text if value of one cell meets specificcondition
  530. on error coding
  531. Re: Loop range change a cell color
  532. delete all rows not beginning with
  533. RE: Loop range change a cell color
  534. Output to a fixed row in a Text file
  535. vba to lock columns b thru d based on value selected in col a
  536. Macro to hide rows
  537. Matching with respect to Column text
  538. Formula in a table header
  539. Out Of Memory Issues
  540. wrong code
  541. Populating values in cells based on lookup from other cell.
  542. Make Array Look Like a Range in VBA
  543. Highlight Text In A Textbox
  544. Display variable in userform
  545. Show cross-referenced value from 2 combo boxes
  546. Redefine a Range
  547. Run Code in Another Workbook
  548. Trying to loop
  549. <1000
  550. Assign faceid to image on userform
  551. Re: templates
  552. Re: Remove password on 'file save as'
  553. Synchronization Best Practice
  554. web page data (question for Joel)
  555. Highlight cell if criteria met
  556. Shapes: identifying different types (charts, textboxes, pictures e
  557. Embedded function screentip
  558. How to refer to the previous target
  559. copy and past numeric values only
  560. Command Buttons not responding
  561. Re: date confusion
  562. Command Buttons not responding
  563. Applying a specific Print setting to all worksheets
  564. customize Excel ribbon
  565. Excel.Chart size changes after copy-paste into Word
  566. Excel 2003 lookup help
  567. Array question
  568. Missing Reference
  569. Assign range to variable for sort
  570. make worksheet tab blink?
  571. Array question
  572. Creating a Macro to adjust the row heights
  573. Merged Cells Autofit Macro Help
  574. Expand and Collapse rows using a macro
  575. CONDITIONAL FORMATTING IN VB
  576. Merged Cells Autofit Macro Code
  577. copy/pasting data into a worksheet and then sorting worksheet
  578. hyperlinks
  579. Re: Vlookup against a different spreadsheet.
  580. Change background on excel chart
  581. Dynamic Event handler wanted.
  582. Adv filter fails in macro, works fine manually
  583. help please
  584. combine sheets from several workbooks into one
  585. Simplify save code
  586. How to find a workbook name?
  587. RE: reading hyperlinks
  588. Test if Internet Explorer or Excel
  589. Test for Internet Explorer or Excel
  590. reading hyperlinks
  591. auto convert to upper case
  592. Error 2029. How do I fix this error
  593. Rounding problem
  594. Seating Chart
  595. Increment/decrement a number in text cell
  596. Help with Sub's on a worksheet
  597. Re: stuck with Auto column fit
  598. Re: stuck with Auto column fit
  599. Can I use HLookup with an internally defined array?
  600. Explanation of code
  601. Pass parameters to Workbook from hyperlink
  602. Please help
  603. code is not working.
  604. Auto column fit
  605. Opening / Closing files using Excel Macro?
  606. Refer to Hyperlink
  607. Create a workbook from every worksheet in your workbook
  608. Copy data from one excel to another
  609. user defined type not defined issue
  610. Select and Delete
  611. Select and Delete
  612. Clarification
  613. Finding what if IE or Excel is opening a workbook
  614. Need to find what is opening workbook ( IE or Excel )
  615. Get info from second sheet
  616. Another Find and Replace need
  617. how to convert 123- to -1.23 with a macro
  618. set up drop dpwn using VBA
  619. Macros
  620. Excel 2000
  621. Charting in excel
  622. Changing formulas in Excel that relate to Pivit tables
  623. feedback program
  624. copy from excel to word
  625. Re: Cell Change Alert
  626. Find then Sum
  627. Rookie Question - Activating Worksheets
  628. Creating Named range problem
  629. Display file path as hyper link in outlook email body
  630. Copying specific cell ranges from a worksheet multiple times to a newsheet
  631. Re: Just a test post please respond
  632. Allow "Goto box" resized in Excel since long tab name problem
  633. populate some userform fields from access database
  634. merge worksheets
  635. Button location problem
  636. Warning Readonly File Disappeared.
  637. Deleting all rows in all sheets
  638. Insert row gives run-time error 13 message
  639. Variation on the count row question
  640. loop through the workbook and paste every sheet it into newly createdworkbook with same sheet name
  641. To have 2nd window view only
  642. Formula in macro gives "Run-time error '1004':"
  643. ADO copy from SQL Server into Excel 2003 List Box
  644. Change Source Data in VBA
  645. Listbox selection hangs
  646. Problem with code used in other countries
  647. Obtaining a certain date from columns
  648. Changing the background color of a cell
  649. Protect Workbook and Share it.
  650. 2002: Worksheet_Change and Validation error
  651. 2002: Worksheet_Change and Validation error
  652. Excel Linking issue to XLA
  653. Code inconsistent
  654. Row deletion event: identifying deleted row ID
  655. Copy if code
  656. Impossible? Dynamic copy/paste
  657. Impossible - dynamic copy/paste
  658. Impossible - dynamic copy/paste
  659. copy and paste it in a new sheet with sheet name as a1 value
  660. Compare two Sheets
  661. Automating a web link
  662. XL7 bug in inserting pictures
  663. Need Macro to Sum Range and Paste the Value into one Cell
  664. Excel 2007 stops calculating
  665. Clear a range
  666. Clear a range
  667. Grouping tabs
  668. userform - user selects image file from dir that will display in c
  669. userform - user selects image file from dir that will display in c
  670. How do I change the active cell in a non contiguous range or selection?
  671. Hide columns with certain coditions
  672. Please Help, Excel to Website and web data back to Excel
  673. Match, Index and CSV
  674. sorting data in columns
  675. Textbox form to Textbox in worksheet
  676. What do I do wrong [Excuses pushing the wrong key combination earlier]
  677. What do I do wrong
  678. Increase the value of a cell by one... With a mouse click...
  679. 2003 works, 2007 doesn't: "Method 'Select' of object 'Shape' Fail
  680. Export VBA Code to Text File
  681. 2003 vs 2007 Shape Selection Error
  682. Function to find value in string
  683. color lines in a spreadsheet
  684. From Excel - Access run saved import then open query design view
  685. Code to get the primary key of table using ADO and VBA
  686. Do I need these lines?
  687. Extracting data on multiple files from one folder
  688. Repost - Set print properties in programming?
  689. Populate userform fields from access database
  690. Limit to hours in elapsed time format?
  691. Record Selection by Current As of Date
  692. Run Existing Access Query From Excel
  693. Changing filenames in a folder
  694. HELP: Update a password protected workbook and save it as unprotec
  695. Multiple IF functions in one?
  696. Assigning "Counter" for Groups
  697. Transpose Data Macro - Question #2
  698. sheet calculation
  699. Loop Macro
  700. VBA: Collapse Column Groupings
  701. renaming excel data lists
  702. Help locating Object Libraries
  703. stop calculation on a sheet
  704. Using IsError
  705. Status Bar shows "Calculate", but calculation is set to Automatic
  706. How do I set a macro to unhide a worksheet and stay on it?
  707. Help on macro that reads a layout and opens a fixedwidth text file
  708. absolute reference r1c1 code
  709. Excel Add-In
  710. Printing userform in landscape on one page only
  711. Selective Range extraction depends on the cell outcome
  712. VBA r1c1 absolute previous row in formula
  713. Clearing Merged Cells
  714. Auto Member List in Excel 2004
  715. Set Multiple Variables
  716. change font using conditional formatting
  717. Web Query, not capturing data
  718. running the same macro for different Excel workbooks
  719. selecting data from a column with multiple conditions
  720. ADOBO control of Access Make Table query
  721. Filter by Colour - conditional formating
  722. shapes "linked" to cells?
  723. How to paste a value for a preceding row if a cell is empty
  724. Export access table to notepad
  725. Office 2007 Excel Macro to save Active Worksheet to HTML by name
  726. Clean up code
  727. Unintialized activex control
  728. sum column with variable range in loop
  729. 2007 lost "application.filesearch"
  730. Re: Set CurrentRegion
  731. Slow loading workbook
  732. For Each srs in cht.seriescollection not working
  733. find/delete data on different tabs
  734. ToolBox keeps popping up whenever UserForm shows
  735. Excel and Html linked?
  736. Looking at this problem a bit differently
  737. Open password protected file with macros
  738. get ActiveCell.Address when a chart is selected
  739. Changing Cell Color based upon value on another worksheet
  740. Is there a FormatReverse Function?
  741. Creating excel file, adding code to it from code, VBE window stays
  742. VBA code adds unwanted characters
  743. Set solver constraint not working in VB
  744. HELP JOEL: auto populate certain userform fields from access datab
  745. Set Range with Long Variable
  746. Displaying Line Number In VBA Code
  747. Button in Spreadsheet to change text back and forth in a Cell.
  748. Copy code that partly works
  749. Toolbars for 2007
  750. Hide the Name Box