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. Compair first 5 numbers
  2. Open a sheet from other Excel file
  3. Worksheet Delete method's dialog box
  4. Copy linked cells content to an other workbook
  5. create search macro based on if cells are merged, or have color in
  6. Strange find and replace query
  7. vba to send email attachment
  8. Re: NumberFormatInfo and Custom Numeric Format Strings
  9. file sharing
  10. vlookup
  11. Number Format
  12. Interfacing Excel to a Web Browser?
  13. Search Companion
  14. last row of a non-contiguous selection
  15. Get the path of the .xls file
  16. Re: Outlook messages generated from Excel macro
  17. Move data based on data type
  18. ChartObject.Copy *very* slow
  19. adding daily totals to weekly totals
  20. autofilter average values
  21. Identify second line
  22. XL2002: XY Chart and Image Position...
  23. macro for serching syllable in a word
  24. VBA problem after Excel update?
  25. adding data to one olumn to another
  26. adding arrays from multiple workbooks
  27. Auto Group
  28. Macro for IF formula
  29. How set print area & account for length of text inside cells?
  30. Help on load the web link into Excel?
  31. 0x800a03ec - VB 2005 or VB 2008 & Excel 2007 (Range Text) (AddData
  32. Finding, copying and pasting
  33. AutoFilter Blue Arrow
  34. Excel 2003 #NAME? Error for Swedish Regional option
  35. Printing workbook sheets in sequence
  36. Get macros in Excel to show up as text always on the toolbar?
  37. ActiveCell.FormulaR1C1
  38. Adding Data totals
  39. Adding Data totals
  40. Create mutiple mails w/ .xls attachments from one spreadsheet
  41. updating totals to a list
  42. Adding an input box to a custom toolbar
  43. VBA Code and Summing Next Non-Blank Cell in Column
  44. Links in a work book
  45. Sort Problem!!!
  46. SQL query
  47. Strange problem when executing Worksheet Change code
  48. Excel 2000 Duplicate Shortcut Keys
  49. Help with PageSetup for printing, please?
  50. Odd issue with an Excel worksheet using macros
  51. Obtain Name of Function or Sub
  52. Excel4v behaving differently in Excel2007...
  53. Remove Shortcuts
  54. Protect Number Format Only
  55. Resolving Addresses With Redemption
  56. Excel User Defined function calling RTD
  57. PrintOut Problem
  58. Qucik Access Toolbar help (Excel 2007)
  59. Before Double Click Procedure
  60. code fails if graph is selected
  61. Looping a textbox
  62. Copy and paste
  63. Open Multiple Password Protected Workbooks with Macro
  64. Prevent conversion to date format
  65. Global search and replace in VBA
  66. #Value! for a
  67. Extract numbers from string
  68. Formula in Chart Title via Macro
  69. Macro To Change Column Headings
  70. Reading a CSV file into an Excel w/b
  71. Program to copy old weekly status sheet to new one
  72. Loading Multiple HTML Files in same Workbook with C#
  73. Populate Data Validation List
  74. Variable Range, Control ToolBox ComboBox
  75. Custom Toolbar Changes Not Portable
  76. PowerPoint Chart Preview in VBA Userform
  77. return item from second column from2 column combobox
  78. How to sort buttons
  79. LF: verify that proper file is being used.
  80. Table already exists
  81. Calculating Average using a Variable Range
  82. Show all, but leave the cursor where it is
  83. Filtered list question
  84. General Programming question
  85. Formula to sum non-adjacent cells
  86. Turn +ve to -ve & vice versa.
  87. VB compiler does not recognize VB functions.
  88. Toggle Button in Ribbon to Hide/Show Built-in Tabs
  89. Round in excel 97
  90. Run-time error '1004' with ActiveWorkbook.Save
  91. Problem with autofilters
  92. On Error - Only executing once.
  93. Counting data
  94. Advance Filter
  95. How to safe as draft email created by macro
  96. Modify Data Validation Input Message
  97. ChartObject.Copy very slow
  98. ChartObject.Copy very slow
  99. Re: How to force user function to recalculate
  100. Re: How to force user function to recalculate
  101. Double Click Event on Image
  102. How do I split one table in multiple tables base on condition?
  103. How to distribute updated code of a addin to users?
  104. copyToColumn
  105. Re: Sort
  106. Pivot table calculated field in data area
  107. Issue with Shape(text box)
  108. The Best Property in The World....take look its.....
  109. A tricky one... Bizarre!!!
  110. How to make a query menu?
  111. Find the login time of the current Windows user
  112. String Array
  113. Sub to iterate thru combo box n copy paste n name ranges successively in a new sht
  114. Sub to iterate thru combo box n copy paste n name ranges successively in a new sht
  115. Can I examine an image file structure using VBA statements
  116. Re-assigning CommandText to an existing PivotCache
  117. program next column
  118. Global Variables and Constants
  119. search files for same cell
  120. How to assign a hyperlink to a button on a form?
  121. Not working... Why? ActiveSheet.QueryTables.Add(Connection:=ActiveCell.Offset(0,
  122. Dependent dropdown query - hiding items selected in prior column
  123. Saving Excel Add-In settings
  124. Pasting Link problem
  125. Check cell value on workbook open
  126. reset last used row and cell
  127. Counting number of Sundays
  128. Tab Naming Macro problem - help needed
  129. lastrow in formula
  130. Combination Charts
  131. Selecting a range relative to an active cell
  132. unusual function needed, unusre how to/if possible
  133. How to change font color on string/text values>
  134. Running Excel 4.0 Macro in Excel 2007.
  135. Date sensitive workbook.
  136. How do I create a Macro to automatically update a graph daily?
  137. Close Personal.xls after each macro
  138. create shortcut but not for active workbook
  139. Way to receive any keystrokes from COM Add-in?
  140. WCTrendline equation
  141. Copy VBA Module to new workbook
  142. Any way to be notified if someone else is in the same sheet?
  143. Copy conditional format colors to another cell
  144. VBA code being corrupted
  145. Copy Sheets to new Book
  146. Delete all commandbuttons in workbook
  147. Help to change code
  148. User prompted date to open file
  149. Shape Size based on Values
  150. Loop thought contents
  151. check box linked cell
  152. Cell to Cell Data Transfer
  153. CATCH-22 won't let me save the file
  154. sheetchange date and time
  155. Reading numbers as text
  156. needing xla assistance
  157. How do I force all functions within a cell or worksheet to bere-evaluated without doing it manually?
  158. SaveAs - modify code?
  159. Color a range with different colors
  160. Input Box selection and file open
  161. Automatically drop down the drop down menu
  162. XL Charts to Word
  163. autofilter criteria
  164. Working with Cell Comments - VBA
  165. Array Math in UDF
  166. sorting merged cells
  167. How many times this file edited
  168. Excel sheet for ”multi emailing”???
  169. worksheet codename direct use vs. use in a object variable
  170. Access Add-ins
  171. Last cell in range of formulas not equal to blank
  172. ungroup columns in protected sheet
  173. Colour row
  174. RE: Conditional Formatting and Interior.ColorIndex
  175. Macro to prompt for password to unprotect worksheets
  176. UNDO DELEING ROW AND POPUP WARNING MESSAGE
  177. File won't Open
  178. Vertical lookup conundrum
  179. RE: Conditional Formatting and Interior.ColorIndex
  180. Event Macro help
  181. Selection saved as CSV with string delimiter
  182. Re: Conditional Formatting and Interior.ColorIndex
  183. Can I display a chart in a form?
  184. How to disable "New" "open" menu items in Excel 2007
  185. Hiding and displaying selected rows programatically
  186. cell update doesn't run macro
  187. Excel + Word + popup screen before entering data (mail merge)
  188. Renaming newly added worksheets
  189. Problem with decimals/percentages
  190. need help passing parameters to OFFSET
  191. Macro/VBA code help for moving data from 1 line to another thendeleting redundant lines
  192. XlBuiltInDialog.xlDialogPatterns
  193. Naming of wordart
  194. Drop down selection inserts value in new cell
  195. What can inhibit an event handler?
  196. Sum in Pivot Table
  197. Macro opens file and hangs in VB editor
  198. erasing a character in the
  199. Drop down list column width change
  200. copy and paste
  201. count variable in range
  202. Create a hyperlink from data inserted into a feild
  203. bypassing BeforeClose event?
  204. hidden results
  205. adding to cells
  206. Eliminating repeats from a list
  207. msg box to stop user if range is "" (tricky one)
  208. Smart way to delete the first row of a huge file
  209. Suppress File Selection Box
  210. workbook close delay
  211. getsaveasfilename loop... <> false and not already exists
  212. parseing out City, State ??
  213. log based on cell values
  214. delete rows that don't contain text
  215. WorkbookBeforeSave Event - check required fields before saving
  216. Cannot select items in listbox
  217. SUMPRODUCT ???
  218. Lower right cell address in a selected range - Excel 2007
  219. Using xlPaperUser
  220. ListBoxes - Different Elements, different colours.
  221. Number Precision
  222. Problems passing parameters to OFFSET, probably a simple fix for theexperienced Excel programer
  223. looping through range
  224. Combination Charts
  225. Making a Textbox Required Field
  226. row number within a named range
  227. String array to a comboBox
  228. Delete value if found in cell.
  229. Find latest file in folder & Open
  230. autocomplete combo box from contextures.com
  231. Pivot Table question.
  232. EXCELDE BİR HÜCREDE GÜN VAR,CUMA BAŞKA Bİ HÜCREDE CUMAYA RAKAM VE
  233. att: ANON. Please if u can and not mind
  234. need rons help on email.(recall temp file?)
  235. Code seems limited by row number
  236. HOW DO I CONVERT EXCEL FILE TO DBF FORMAT IN OFFICE 2007 ?
  237. web query with Workbooks.Open("http:// .....
  238. How to protect some specific module in VBA project?
  239. Variable as percent
  240. Save as web page
  241. Need to conditionally duplicate rows
  242. Check if Workbook Exists
  243. ListBox
  244. Disable UserForm 'X' Close Button
  245. Expert help for alternative to slow workbook
  246. Excel Calculation is faster when visible than when Visible=False?
  247. Excel 2003 Macro to move data around worksheet
  248. Return Value based on Day of Week
  249. Count unique values - Match and conditional IF
  250. Count unique entries across multiple columns
  251. Workbook.Save that also updates XL version?
  252. Copy data from data sheet
  253. redim multiarray
  254. Creating new sheet named one week newer that active sheet
  255. Creating a list on a different worksheet/form
  256. Column Charts
  257. Does Excel register an IP address when it queries a website?
  258. I need help to make a viewer files EXCEL
  259. Does Excel register an IP address when it queries a website?
  260. I need help to make a viewer files EXCEL
  261. How to detect if workbook is running in Internet Explorer
  262. copy and paste within macros
  263. Need some syntax help, simple loop I think
  264. OLE DB Query Using Cell Value as Variable
  265. Using FaceId for CommandBar Icons in a commercial application
  266. Copy/Paste values rounding problem.
  267. Opening Excel files with VBA
  268. Macro Issue
  269. Help with macro. Import text file (fixed width)
  270. VSTO Excel with Autoshapes, Connectors and Polylines on Worksheet?
  271. SOS:why run error
  272. Need Programming Help
  273. pushing window to the front
  274. Out of Memory Error 7 While assigning named range value
  275. Select Checkbox on Web Page
  276. Selection EntireRow Insert
  277. Lookup data for a range of dates
  278. Macro to Count Entries of Columns
  279. Does Excel register an IP address when it queries a website?
  280. 401k Spreadsheets help
  281. Change sheet name based on cell value from another sheet tab
  282. Find & Replace Dash
  283. Automated Process that Updates all Spreadsheets in a Folder
  284. With all sheets?
  285. Clearing Immediate window in VBA by code
  286. Undo button in the context menu (right click menu)
  287. Personal Macro Workbook
  288. SeriesCollection Object Issue
  289. Missing blanks
  290. format calling cell
  291. Hidden Userform
  292. Autofilter tables Uniquelist
  293. Open workbook "inactive"
  294. For Next does not find dates?
  295. Is there any way to collapse/expand codes in VBA editor?
  296. Axes values changes autmatically / textbox formatting lost
  297. in Me.lbx.MultiSelect = fmMultiSelectMulti
  298. Information results on user form?
  299. Interop Excel
  300. Re: Excel VBA Step into
  301. Re: Excel VBA Step into
  302. html chm help file won't launch from VBA, sometimes
  303. Count certain values in numeric array
  304. Macro to copy a workbook and delete a specific worksheet
  305. Excel columns: Converting numbers to letters and vice versa
  306. Down Loading External Data From Web. VBA to Control it
  307. Rounding
  308. cell format text and data displayed like a number
  309. CheckBox . . .
  310. "For" help (I think?)
  311. Update worksheet according to given user names.
  312. checkBox & ListBox on ToolBar...
  313. Installing an add in
  314. Ensuring Selected Cell is Visible on Screen
  315. Find reference to specific range in code
  316. Formatting date
  317. Screen Updating Problem
  318. Sort Problem - dynamically set the upper bound
  319. How to update a worksheet based on a defined named range using VB.
  320. running exe file in web
  321. Excel 2002 - Borders(xlInsideVertical).LineStyle=xlcontinuous notworking
  322. Urgent help needed please
  323. Nested grouping of hierarchical headings during/after import
  324. Fills page number of all sheets in current workbook
  325. copy latest price from sheet1 to sheet2 using VBA
  326. Convert the date to day of the week.
  327. Double Click Jump
  328. Format Column to display leading zeros.
  329. How can I install Excel 95 on a new Windows Vista machine ?
  330. mailing from excel - For each cell - already in use - error
  331. Formula into cells from VBA help please!
  332. Formating problem
  333. Simple Loop question
  334. Datewise table view with unique count
  335. Disable scrolling when macros disabled
  336. Update worksheet - Based on user IDs list
  337. Looking for a Month Name in a String
  338. Looking for a Month Name in a String
  339. Macro Button and Closing Excel
  340. DisplayHeadings
  341. Macro to populate a second column
  342. Unable to mark the range in VB and get application error- WHY
  343. Userform otomatic to perceive
  344. Custom security
  345. Can't pass a ListBox as a ListBox - must be a Variant??
  346. ONE BIG THANK YOU TO MR. MARK IVEY
  347. Remove the X button from a user form? Api?
  348. useing a macro copied
  349. 2007 Excel / Powerpoint copy paste problem
  350. IMPORT TEXT FILE WITH VB
  351. Previously Functioning Date Interpreter Now Failing
  352. Active X CAlender day colour
  353. Change color of characters in a cell based of a cell reference
  354. Including Solver Tool in a Macro
  355. Solver to match set elements - does it work with big numbers?
  356. Columns doesnt return expected results
  357. A Better Way to Reorganize Data?
  358. Programmatically check security of VB Project
  359. Possible to pass a variable to Excel from command line/short cut?
  360. RE: sum every nth cell in a row
  361. upload control for attaching files
  362. Save as with Default location
  363. Check totals in range
  364. Setting Vertical Page Breaks
  365. Auto load
  366. Hardcode
  367. Hidden Rows not working correctly
  368. dll problem
  369. How do you .DELETE a (sub-menu) Control that was clicked?
  370. Adding date to file name when saving and over writing a existing f
  371. Print to PDF then set Zoom.
  372. Need to calculate the difference between different pairs of values!
  373. Compare Col A and Col M, if Match, Copy Col N to Col E
  374. Peak Detection Approach
  375. Source data for pivot table to point to cell on worksheet?
  376. Set page break criteria?
  377. Cant get to fill using plus handle to fill serial number-WHY
  378. VBA Open Wkbook Disabling Macros
  379. Require specific cell entry before saving file
  380. Copy Data from one sheet to many based on column A
  381. Copy to designated sheet based on value in cell
  382. Get a date to display in date format on a UserForm
  383. Delete earlier 'Picture' version when new picture copied in
  384. Replace "FIRSTNAME LASTNAME" with "LAST"
  385. Declare array
  386. Use a spreadsheet to calculate and email an alert?
  387. Data Entry Outsourcing Services: Profitable and Reliable Advantage
  388. ADO versus VBA
  389. HOW TO FIND last cell from activecell?
  390. Using VB to code sheet formulas
  391. Data importing prob
  392. ListBox repeat selection fails
  393. construction estimating
  394. VSTO install package-How to check for prerequisites and skip them
  395. WHY EDIT-FILL-"SERIES" OPTION cannot be seen in one particular sh
  396. Popup message when value changes
  397. comman button on form to transfer items in listbox to a sheet
  398. Using ActiveX combobox controls...
  399. Cannot Select Items in ListBoxes
  400. seriescollection(name) not working in excel 2007
  401. Rules for element-by-element product in array multiplication
  402. Auto-Insert
  403. Help with a regex pattern please
  404. RE: Updating Worksheet Event Code Module via VBA
  405. Re: Updating Worksheet Event Code Module via VBA
  406. Formula for counting minute intervals
  407. Limitation on .Pictures.Insert?
  408. Save workbook problem
  409. How do I count the number of times a particular word is used?
  410. set color of textbox (shape) bullets
  411. Lotus Notes Attachments
  412. ADO Recordset Filter for alpha
  413. Named data into macro
  414. formatcondition,,, curious....
  415. Deletion problem
  416. Running Access Macro from Excel
  417. Turning a schedule to millions
  418. Re-entrant function
  419. Val function with contents of a Hyperlinked cell
  420. Counting problem
  421. ADO
  422. VBA Help...I need a lot
  423. Help with Formula - Concatenate
  424. HowDoI Convert Excel to Tab Delim txt (File to long to open in Exc
  425. PLEASE ANY BODY CAN CORRECT MY MACRO
  426. Help with code please
  427. Macro Help
  428. Cell address
  429. VBA code to find specific data by name. Get average. Put in cell.
  430. modify a form on the fly
  431. Solver to match set elements - does it work with biiig numbers?
  432. MACRO NEEDED TO MAKE SPREADSHEET PROFESSIONAL
  433. how do I use r1c1 notation in excel? just doing "=r2c3" not work
  434. exit cell automatically after entering data
  435. Centering and warping text
  436. Calling Forms by their Caption?
  437. Object Required error on Weekly Summary sheet creation
  438. Help on coding please
  439. If not then
  440. Sumproduct error
  441. HOW TO SELECT NEXT CELL OF LAST VALUE CELL
  442. On Error, Message, Exit
  443. Excel as a front end to an Access database
  444. How to create button and associate a macro with it.
  445. search without using sort (lookup function)
  446. Email hyperlink that subject line will reference cell content
  447. Inserting Comments - 2nd post
  448. Copying worksheets
  449. spreadsheet coming up read-only but only across network
  450. worksheet?
  451. Inserting a row
  452. Search without sort in the sheet
  453. RGB fill colors
  454. Selecting Ranges using Variables
  455. Find Data and Change A Different Column
  456. Excel Worksheet saving of Ranges ...
  457. Multipage for a Wizard
  458. Last Cell
  459. Excel 2007 and inserted images
  460. multiple users saving to a workbook
  461. how can I work with worksheet textboxes in VBA?
  462. conditional merging of two columns?
  463. ActiveX calender help
  464. Excel 2003 vbs script problem
  465. Inheritence in VBA?
  466. Fill cells with pseudo-random values
  467. Trapping making a selection from a dropdown validation list
  468. Applicaion.Selection on Excel
  469. Stereo - dual view
  470. Determine instances of Excel open
  471. ip address
  472. Tournament tie breaker
  473. Code for Inserting Sheet in Excel 2000 not working in 2003
  474. For last one year trying to find out- pls help
  475. Rearranging data
  476. Sorting Random Data
  477. Calender Activex Help
  478. Code to OK DeleteSheet automatically
  479. Why is Add-In path associated with save location
  480. Extracting data from text file that changes daily
  481. Determine width of entire visible area and width of labels
  482. Unmatched Query
  483. Application Close Event
  484. How to loop through multi-selection listbox?
  485. Need formula to calculate comission & bonuses
  486. Referencing 2 cells in a macro
  487. MsgBox or like it for with requiring user input
  488. Need Help Modifying Code Please
  489. Parse Data Sheet (anti-consolidate)
  490. Excel seems to hang while running a UDF
  491. Move to a specific column in whatever row the cursor is currently
  492. Require specific cell entry before saving file
  493. Help - selecting range
  494. Macro
  495. WordPerfect table converted into excel
  496. Can't get correct Workbook Create date from VBA
  497. Fill Down, Column E
  498. Create a floating calender
  499. Average Percentages Excluding Zero Percentages
  500. Can I have the same variable names in multiple different "forms"inside my personal.xls?
  501. Rund VB code on one tab while on another
  502. combo box to be used in Macro
  503. Error 1004 on VBA operation
  504. CutePDF Writer and excel
  505. BeforeClose Event
  506. Referencing a Cell in Macro
  507. Cursor placement within a form
  508. Do File Open and default to the MyDocuments dialog box
  509. Filter macro
  510. Compile error in hidden module:frmwork
  511. Business Days
  512. Conditional Deleting of Subtotals
  513. Programming personal macro workbook
  514. Tracking lastest date of change in a row?
  515. Copying worksheets or data to other spreadsheets
  516. Inserting comments
  517. offset to column A current row
  518. Problem with Macro Calculation
  519. Concatenate
  520. PIA and Frozen Panes
  521. password to access a custom menu?
  522. querytable connection fails in Excel 2007
  523. Data query refresh problem with changing filenames
  524. visual basic word scramble
  525. Help With BeforeDoubleClick
  526. Picking Region Data from State Information
  527. Macro to setup Rows to Repeat at the Top
  528. Centering picture in Excel 2007
  529. Variable Initialization
  530. Form variable duplication allowed in different forms in personal.xls?
  531. Connect to intranet
  532. Floating calender
  533. Macro Help - Excel
  534. Writing data to a new workbook
  535. Automated Process that Updates Multiple Spreadsheets
  536. Help me to change color (By VBA) of cell if value in the cellchange!!!
  537. Help me to change color (By VBA) of cell if value in the cellchange!!!
  538. Corrupt Excel files when saving to Win2k3 server
  539. Sorting in Ascending Order
  540. How to load an excel file through web link?
  541. variable row on fill?
  542. Excel VBA Sorting Error
  543. File Open Dialogue Box to a Specified Location
  544. Error with sorting
  545. 2007 Print Preview Issue when printing multiple sheets
  546. Programmatically create button on Excel worksheet (vb.net)
  547. Enableling a shape
  548. How can I save charts as a jpg or gif automatically.
  549. Export to excel via webpage: "Invalid Procedure Call or Argument"
  550. Run-Time Error on Macro
  551. Print Macro Problem
  552. How to prevent overwriting of file ?
  553. List & count unique records
  554. Using OR and wildcard
  555. send mail without outlook
  556. PDFCreator code
  557. Autofill variable range
  558. Converting Numbers from a given cell to English Words (Currency)
  559. Re: MACRO LINKING - DIFFERENT
  560. Rename unknown sheet name in excel.
  561. Need to print a Worksheet without selecting it
  562. Processing arrays with the for each-next construct
  563. Accessing individual elements of an array returned by a function
  564. Different chart sizes between Excel 2007 and previous versions
  565. VBA Code Change
  566. DDEInitiate locks up Excel
  567. VBA Totaling
  568. AutoFit Row Height with Merged Cells in the Row
  569. insert formula
  570. Listbox Problem
  571. Variable not defined?
  572. Request for design ideas moving from data entry in spreadsheet toUserForm
  573. xlTextPrinter and Accounting format
  574. file error
  575. variable row...
  576. MsgBox help
  577. recreate a deleted LegendEntry
  578. Macro to insert command buttons
  579. NamedRange - Variable Sheet
  580. Compile OverFlow Error
  581. Re: Importing data from the web (script page)
  582. Excel connect/import Access data using ADO and VBA?
  583. command button to combo box
  584. Work-around for blocking of invalid certificates Excel 2007
  585. Dynamic Print Area (ActiveSheet)
  586. LeftHeaderPicture
  587. Macro Auto Change Cell References
  588. hide-unhide
  589. A little Macro Help Please ...
  590. Enable macros
  591. Hiding columns
  592. What meaning
  593. help with Count function
  594. Continual Executions
  595. Pivot Chart from database and Excel sheet
  596. Clear data and hide rows.
  597. Using the functions "LARGE"and "SMALL" in an Excel program
  598. which text be selects in VBA listboxs
  599. Extracting from string
  600. Have you ever had a file show up as having 0 bytes?
  601. Importing data from the web (script page)
  602. Pie Charts
  603. Can a Macro Run Another Macro
  604. Chinese problem with an application
  605. Macro problem where workbook name is saved in another name and macro reference changes
  606. Remove Forms Command Button
  607. Filter on more than one field
  608. Excel created in LotusScript slow
  609. Linking worksheets
  610. call VB code on refresh.
  611. Finding all divisors of given number in a set
  612. returning back to loop check condition without completing the loop
  613. RE: One for every month
  614. RE: One for every month
  615. name of cell
  616. Invalid Procedure call or Argument when Export to Excel via web pa
  617. even
  618. A problem with creating a workbook by VBA
  619. Is workbook open on network drive
  620. Error message when adding 2 columns with Macro
  621. For Loop - If / Or
  622. Problem opening Workbook files in Macro
  623. Combobox question
  624. Macro to refresh data from different files
  625. Getting Names fron Outlook
  626. VB Code to Convert Rows into Columns in Excel
  627. Delete row macro
  628. Macro code doesn't work with Button
  629. Code to detect if add-in is available
  630. Getting the filepath of a template
  631. How to clear a row I have selected to copy to another worksheet
  632. Avoid importing 65,536 rows
  633. ODC named range question
  634. selective copy data from table
  635. Named Range as Chart Source
  636. Clear Contents of all Sheets
  637. variable available after userform
  638. userform label.caption
  639. How to copy data from different columns in an Excel to one column
  640. A challenging One
  641. can u insert several hyperlinks in the same cell?????
  642. Activating ManualCalc for any workbook opened
  643. Custom toolbars uninstall/re-install
  644. Run macro in workbook from PERSONAL.XLS
  645. Barcodes & stocktake
  646. Select a particular cell
  647. Recalculate formulas when active sheet switches
  648. How do I search for a word and add text to a cell if found?
  649. Autofilter problem
  650. Excal, Variant and Range
  651. Text is being added to the macro vb edior
  652. Range of Object Worksheet failed
  653. defining a range
  654. Best practice for executing code
  655. evaluate function only in Excel application
  656. Filtering Columns
  657. Listing properties
  658. Run Time Error 91! What am I missing?
  659. GetSaveAs Issue in Excel 97
  660. Populate Bookmarkes in a Word Doc. with Excel
  661. cant read memory crash when printing
  662. find location of ActiveX control
  663. Will anyone help a new user out there?
  664. 2 questions
  665. Creating and Sharing a .xla VBA Macro
  666. find the location of an activeX control
  667. Search entire computer before opening file
  668. Textbox from 1st worksheet to textbox to other multiple sheets
  669. Copying or deleting row based on value found in other ws
  670. file error
  671. Task option control
  672. Project Time Template Needes
  673. Marco to process data in many files
  674. Data analysis toolPack
  675. Create new workbook and move the Macro without reference to old wb
  676. Unprotect Sheet with Password Included
  677. MS Excel If statement containing AND within an OR
  678. Rich Text box
  679. Correlating rows on different sheets
  680. Calculation With A Macro
  681. dynamic range
  682. Hiding Sheets
  683. How do I solve the colbrooke equation by iteration in Excel?
  684. What's wrong with this code?
  685. VBA Pause to allow Print to start. sending fax via Outlook
  686. Extracting the Nth element from a String
  687. Copy text then Past Text into TextBox not working
  688. Read Only Message for open workbook
  689. Setting cursor location on opening
  690. The Funky Stuff.
  691. Move files by time/date
  692. One for every month
  693. How to import multiple csv files in single excel file automaticall
  694. PivotTable - Clear all data fields
  695. combobox value blank
  696. Insert comment If cell content changes.
  697. hexadecimal mathematics
  698. Slow code
  699. UDF expanding beyond its cell
  700. Copy rows where entry in column A
  701. file not found
  702. Windows API Calls.
  703. problem with undo and a user form
  704. chnage pronounsaction in speech recongnition
  705. help on windows login name, dear Chip Pearson
  706. expiry date for passwords
  707. Skip Read Only MsgBox with Save As
  708. Special loop
  709. Code to create worksheet names based on the values in the selectedrange
  710. Capture Error 1004
  711. macro to automatically sum a column based on another
  712. Error in a "Kill" command
  713. Buggy Microsoft Excel Patch Causes Bad Math
  714. Copy Data From Excel Into a MSWord Document
  715. How to process multiple Excel Files
  716. if today is last day of month then, else
  717. FORMULA OR VB
  718. check if is last day of month then, else
  719. Start MS Word?
  720. Best format to export Excel Range to picture?? WMF??
  721. Re: WrapText Property
  722. WrapText Property
  723. Read Only alert interference
  724. Excel equivalent of a "this" pointer...
  725. Application Event Question
  726. Sort and Transpose
  727. How to code macro with if condition?
  728. Converting Dates
  729. Getting Monthly Data using Split()
  730. Macro Range Selection
  731. Macro to change columns - monthly question
  732. problems changing the size of my chart
  733. Using PI in a macro
  734. How to exit the loop?
  735. Setting cell fill colour
  736. SHdocVw event problem
  737. Reportable Error in xla - Follow UP
  738. search entire computer then open file
  739. HELP WITH FORMULA
  740. sign a project in office 2000
  741. How to use Index function in coding macro?
  742. calculate time
  743. shortening code by defining variables using an array?
  744. JLG Copy Row
  745. file conversion
  746. GetOpenFilename Close
  747. Two Open workbooks
  748. Help Reviewing My Loop
  749. How to use substitute function in macro?
  750. Reportable Error in xla - Desperate