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. Edit Cell's content into a larger box (Rich text box)
  2. find out if a sheet is open by another user
  3. Issues with time clock
  4. HOW CAN I WRITE A CODE TO COMMANDBUTTON ADDED AT RUNTIME?
  5. sql statement being run from vba excel
  6. sum the column
  7. Unhiding rows based on another cell value
  8. Importing Data to Excel 2007 from Access 2007
  9. unhide, Remove filter, Unfreeze help
  10. Datatypes
  11. VSTO using a document that relies on an XLA
  12. Fill rows downwards with column names
  13. Summing using column Heading
  14. SEND FILE FOR UPDATE
  15. Inserting rows
  16. login username
  17. Adding data to a closed sheet
  18. Function won't update a cell
  19. MISSING: ReportBuilderAddIn 1.0 Type Library
  20. Import CSV file
  21. Show full text?
  22. Hide rows with zero's on several sheets within a workbook
  23. Exiting a select case group
  24. Dynamic drop-down menus with PivotCharts
  25. login username
  26. How to get Tree View Structure for Huge Data
  27. Simple Checkbox
  28. Changing linked formula
  29. Apply security
  30. For Excel 2007 copy visible cell only is only thru for few number
  31. using cell value to open file
  32. linking data to specified fields
  33. Acronym Macro
  34. Linked data
  35. put cell valve in a text box
  36. Modifying Ron's codes
  37. Web Query Stopped Working
  38. Copy selected range along with filters
  39. Re: ReadOnly TextBox from ControlSource
  40. ReadOnly TextBox from ControlSource
  41. Read a cell value without opening the file.
  42. Change file to read only
  43. Building SQL-string with vba
  44. column width and row height formatting, & IF
  45. Add Button at Run-time in Code
  46. Autofilling a formula down
  47. Copy a range of cells 15 rows down and repeat to empty cell
  48. Removing Macros when saving a copy of excel file
  49. Cell value in a test box
  50. Re: convert A1 to R1C1 in VBA
  51. If statement result
  52. Re: convert A1 to R1C1 in VBA
  53. Deleting ' in front of text in a cell
  54. Copy select information from a workbook to a template
  55. word to excel
  56. match values in column against another column and move
  57. Recover modules and forms from a damaged spreadsheet.
  58. Accessing the PERSONAL.XLS without a macro ever recorded by user.
  59. Formula problems
  60. Create a hyperlink that emails the current worksheet
  61. unhide rows based on data validation
  62. export excel to EBCDIC fixed-width text file
  63. Generating spaces in code
  64. VBA Query
  65. results of a macro function to appear in another ecxcell sheet?
  66. Can you dimension an array in a way other than Variant?
  67. Shell to use already open instance
  68. Copy Worksheet with Named Ranges
  69. Pivot table access - Connection
  70. Enquiry for Ron de Bruin
  71. deleting worksheets msg box
  72. what is "Notify before state loss"
  73. Compile directive for 2000 to ignore 2003 commands
  74. Using a Macro to Open IE, then get the Source of an ID
  75. determining the cutcopy range progamatically
  76. Error Handle to Exit Loop on Blank Page
  77. Rounding Off decimals to the lowest number
  78. Excel VBA 2007 - Combo Box
  79. Open compressed file
  80. Excel crashes after printing via VBA
  81. Need help evaluating cells in another workbook in macro
  82. Create a table from raw data
  83. map network drive
  84. Error in Vlookup formula
  85. Runtime Error 91 Object variable or With block variable not set.
  86. Combobox Row Source
  87. Error without activating worksheet
  88. Math function...
  89. Calculation on a range problem
  90. SQL + INNER JOIN + ADO
  91. sp3/cube error "database driver does not include the necessary cap
  92. Printing
  93. Summary worksheet
  94. Any ideas on how to do this?
  95. Shift Information
  96. Autofilter causes drawing objects to disappear
  97. LookUp Returning more than one rows
  98. Irregular Shape
  99. Email generated from Excel database
  100. Macro not always when opened from shared drive
  101. Copy visible cells only
  102. Sort protected sheet
  103. Make 1st word in cell bold after combining words from two cells
  104. find duplicates and concatenate
  105. dialog box validation
  106. Find the other workbooks name
  107. Create a hyperlink with concatenate and copy to a different workbo
  108. Did FillDown break in 2007??
  109. Excel won't calculate
  110. Keep Original Sheets Font Format when Populating data into other sheet
  111. Email using a macro
  112. Installing Add-In problem
  113. Load selection into an Array - VBA
  114. can a workbook become corrupted by too many charts
  115. Worksheets
  116. Find and Replace Question
  117. Re: range, format, file size
  118. Macro to compare, find match and copy between workbooks
  119. NEED HELP ASAP using find function with a combo box
  120. Macro attached to New Menu item on toolbar
  121. Scrolling
  122. Read only
  123. Name conflicts.
  124. View the table relationships in a database
  125. Importing Data to Excel 2007 from Access 2007
  126. Multiple instances of Excel
  127. Highlight cell
  128. subtotal
  129. how to know a caller at run-time
  130. Multiple worksheets feeding into one worksheet, formulas won't wor
  131. Checking if ranges are the same after Range.EntireColumn
  132. Need help using nameranges to write to columns
  133. Track Maximum occurences in Array
  134. Code not working to move cursor down on Enter.
  135. Conditional formatting - currency?
  136. Bulk Unhide
  137. Conditional Formatting
  138. Reference sheet by number or name
  139. Formula Analyser / Analyzer - Anyone written one?
  140. Custom Format Time Code
  141. TextBox Characters Method - Need Help
  142. Count from A5 down to last used row - Not up
  143. Using a formula to copy data from one worksheet to another
  144. Force new Excel instance
  145. I need help with locking and Wrapping
  146. Fixed and Relative Macro References
  147. automatic names IDX,IDX1,IDX2... (Repost)
  148. Save 60% on Data Entry, Data Conversion, Data Processing Services byOffshore-Data-Entry
  149. Save 60% on Data Entry, Data Conversion, Data Processing Services byOffshore-Data-Entry
  150. FORMULA TO SUM ON CRITERIA
  151. Help with vb Bot
  152. XLA: User-Specific, Not Document-Specifie
  153. Auto-Saving .XLA Code Changes?
  154. Excel WorkbookBeforeClose ___ Documentation proof needed
  155. Code too slow (looping find to match data)
  156. Using a Macro in Excel 2004 to move entered data from one sheet toanother and space between rows when next data is entered?
  157. Excel Workbook Close Event__ Documentation Proof needed.
  158. Excel Form/Label Won't Show
  159. Email Generation
  160. Closing Workbook in Office 2007
  161. substring method for VBScript
  162. union range
  163. Take various screenshot using macro and save in disk
  164. How do I create a User Defined Function using VBA in Excel 2007?
  165. Calendar control
  166. Save picture using VBA
  167. how to use Application.VLookup on close sheet
  168. FUNCTION in easyer format
  169. Vlookup from close sheet via VBA
  170. How to hide rows in a Workbook with multiple sheets with zero valu
  171. Table formatting in C#
  172. taking out all \/?*[] so input can be name of worksheet
  173. Test an array to see if it is populated without an error
  174. Little help on Autofill please
  175. What is wrong with this code?!?
  176. Macro to copy a cell contains formula to a range
  177. simple code, for each
  178. Displaying data from multiple spreadsheets into one spreadsheet.
  179. Add ins vs. Templates
  180. Macro to concat row
  181. Add-in used by more than one user
  182. Suppressing screen flicker when sheet is activated
  183. Inserting an image into Excel from FTP - occasional 1004 runtimeerror
  184. Conditions in a macro
  185. Track Max of Matches across 2 columns in 2D Array
  186. Time Clock - Making sure they clock out
  187. Special average calculation
  188. Problem setting BorderArround LineStyle:=xlLineStyleNone
  189. error in macro (next related i think)
  190. Password to Unhide VeryHidden Sheets
  191. Copy text from embedded Word object?
  192. Marker Transparency
  193. hyperlink in a PDF
  194. Adding Menu Items to excel 2007
  195. Pivot table or array formula
  196. Freezing a cell value
  197. RETURN NAME OF WORKBOOK
  198. Supressing warning about too many data points in a chart series.
  199. Norman Jones
  200. Keeping Variables Alive
  201. modify macro-- .columns()
  202. Creating Index
  203. Displaying Comments in separate worksheet
  204. Looking for specific text Value in cell
  205. Urgent help with input box & loop
  206. blank space
  207. Does Anyone Have a Excel Writeback Cube Sample?
  208. Regex Pattern to extract Sheet Name from .Address(external:=True)
  209. Showing sheet name of dependent
  210. Row Heading to follow on all pages
  211. Macro not running properly when shortcut is used
  212. Shorting code
  213. filter list combo box move
  214. Command Button Dependent on Cell/Range Value
  215. Re: date code
  216. Copy / Past problem.
  217. NAME# Error in 2003 excel.....PLZ ADVICE..............
  218. Re: code for conditional validation to textboxes
  219. HOW TO CHANGE DRIVE ADDRESS IN MACRO
  220. XML esporting
  221. How to close XLAs, but not Excel...
  222. Value and result in one cell - impossible?
  223. how to open excel zip file useing vba
  224. file size makes no sense!
  225. Need Loop Optimization Assistance
  226. 2 Most recent files
  227. calling for help again for xls 2003
  228. Renaming a copied sheet programatically
  229. Display the Browse for Folder Dialog
  230. VisibleRange addresses to Array
  231. Sumproduct from previously blank row
  232. Copy chart from EXCEL into Word
  233. worksheet number OutOfRange
  234. Qery open and clos sheet
  235. Best way to pass data between forms?
  236. IF Function
  237. AP Conditional Formatting
  238. Step into in Excel 2003
  239. Key Presses within a MsgBox
  240. how to open xls._CRYPT file
  241. Using JET Reports
  242. Transpose range for drop down list
  243. Remove hyperlinks
  244. BeforePrint event - Jim Thomlinson / pwrichcreek
  245. Inserting an image
  246. Stopping screens from flashing using Screenupdating
  247. Adding Forms to the taskbar?
  248. vba dim statement with equals
  249. Excel query then insert row
  250. Excel Form: Can't format date in a Multi-column Listbox
  251. Saving a macro to be available to all workbooks
  252. Excel 5.0 print problem
  253. conditional formating
  254. MACRO IN EXCEL 2007 DOESN'T RUN
  255. Adding a Worksheet and Renaming
  256. It was working but now not
  257. Add-In Excel Locked Up
  258. Help with Input Box.
  259. User created Dialog Box
  260. Spreading numbers from one cell to others
  261. insert rows into Excel database
  262. What does Address(external:=True) mean?
  263. Excel Services on SharePoint / Windows Compute Cluster Server
  264. Loop through cells to find dependents
  265. Runtime Error in code
  266. Changing Series for a chart
  267. referenceing 'last row' in a cell formula
  268. A Real Mystery
  269. Suggestion for changing one character using VBA
  270. Select method of range class failed problem
  271. Problem printing hidden rows
  272. VBA code for Msgbox
  273. Solver add-in
  274. Digital Signitures, Creating / Obtaining?
  275. formual help
  276. Right click mouse menu in Page Break Preview mode
  277. Inputting from message box
  278. How to I Delete a Row if a Cell does not have a particular value?
  279. Use a password in VBA ActiveSheet.protect & ActiveSheet.unprotect?
  280. Save selected cells to a Text file
  281. CORRECTION NEEDED
  282. Error trapping?
  283. Macro To Sort and Seperate Data on Serpate sheets from a Master Li
  284. fixed width import
  285. Publish Spreadsheet to Web
  286. Macro to show/hide rows based on a range of dates
  287. Macro to add code to ThisWorkbook module
  288. A way to Determine visible cells on the page
  289. Code Module in Sheets Collection
  290. send value in dialog box....
  291. Understanding Resize Method
  292. 2003 to 2007 updates
  293. SUM() of empty dynamic named range returns #N/A
  294. Arrays/Redim/Help!
  295. PLEASE CAN ANYBODY CORRECT THIS MACRO
  296. Offset in for loop not working
  297. How to correct formula error?
  298. RE: Copy UserForm to new Workbook
  299. VBA to C# conversion.
  300. Re: Copy UserForm to new Workbook
  301. Re: Copy UserForm to new Workbook
  302. Suggest a filename for SaveAs
  303. Application.Calculate - Runtime Error
  304. Late Binding
  305. Visual Basic Chart Moving
  306. Interpolating a list (range) of data?
  307. Statistical Analysis
  308. Re: Insert 4 Columns If only 9 Columns
  309. Shell function. Open Excel swtiches
  310. Re: Insert 4 Columns If only 9 Columns
  311. Over write a file someone has left opened.
  312. activate workbook
  313. checking path
  314. VBA Project
  315. picture resize
  316. QueryTables
  317. control of pc speaker from VBA
  318. VBA code to update row format
  319. Automatic conversion
  320. Generic Event Handler Hanging. Need help
  321. Anything like STRUCT in VBA?
  322. Allow VBA Program to use in Specific Computer
  323. View Numbers in Textbox in Proper Format in UserForm
  324. trigger worksheet activate event in another worksheet
  325. Using a macro to make a list from results
  326. Advanced Filter doesnt work in VB2007
  327. Why does excel sometimes not ask to enable macros (medium security
  328. insert into oracle commit
  329. Find, cut, and paste entire row
  330. Disable Optionbutton Control
  331. Macro to Write and delete value in registry
  332. Problem with Filesearch in Excel 2007
  333. How do you find WHERE Excel splits your wrapped string?
  334. Need text from embedded Word object
  335. Works in Personal.xls but not in normal workbook?
  336. broken links in excel 2003
  337. change font color for row...
  338. Two Macros to One
  339. Not seeing cells as blank
  340. Assigned macro in Dialog giving error
  341. How to copy cells content only
  342. updating links
  343. No help for "Worksheet_BeforeDoubleClick"
  344. UDF Macro Looping Issue Erroring out
  345. VBA code for MsgBox
  346. Different Payroll Formula Question
  347. Printing an array of worksheets
  348. ComboBox List - Invalid Argument????
  349. How to find out when you are near the top of a worksheet
  350. extend selected CurrentRegion results in application or objectdefined error 1004
  351. Assign Macro to Command button by right click
  352. Question for Jim Thomlinson or Ron de Bruin
  353. Send email based on cell value
  354. Need Help in VLOOKUP (second attempt)
  355. How do I build automated currency exchange rate into Excelspreadsheet?
  356. Use of checkboxes
  357. preventing data entry if one cell's value smaller then zero
  358. sheet formulas and strings
  359. Hyperlink or Command Button?
  360. How are Digital Certificates Stored and How Do I Manage Them?
  361. spawn a vba program from with VBA
  362. Sort list by selecting header cell?
  363. Positioning Pictures in a Worksheet
  364. Possible Data Type Issue
  365. Multiple range selection and editing
  366. How to insert VLOOKUP function in VBA?
  367. defined error
  368. Arrays and other general coding help.
  369. validation for 10 text boxes
  370. Tools > References...
  371. Macro deleting row if duplicates found
  372. Cell will not format with a color
  373. VBA Function for Match and Offset
  374. Help with a Time function or ... Something
  375. How to create Macro that can build a Scenario PivotTable Report?
  376. Chart Location - Only allowed New Sheet?
  377. How to Reduce the size of VBA Program
  378. Data imported into Excel from Access
  379. function to return a "sub-range"
  380. Loop in Auto filter
  381. Macro Buttons
  382. Copy Specific Data
  383. mutipage and optionbuttons
  384. Not able to send Mail - Ron de
  385. NumberFormat syntax tutorial
  386. Re: Turn screen blank during Macro execution
  387. Addin macro
  388. MultiColumn ComboBox Display
  389. Visible property for worksheets objects
  390. Difficult Looping Macro…with AutoFilter
  391. conditional copy macro
  392. Another Problem with Regex Pattern
  393. Check Box checking
  394. How to obtain properties of graphical "line"
  395. Help w/Duplicates & Macros
  396. Where do I begin?
  397. using find with a combo box
  398. For Loop with headers
  399. Export data to new workbook, maintaining formating and page setup
  400. .xla information tab
  401. What is wrong with this code ??
  402. calender
  403. Invalid procedure call trying to use FormatConditions
  404. Form Problem
  405. WinFax Pro and Printer Confusion
  406. Excel VBA - Find value in external workbook, same folder
  407. .XLA: Making it an AddIn vs adding a Reference?
  408. Summing based on currency format of Cell
  409. Preventing change of a cell value
  410. Find x-y coordinates of cell?
  411. Calculation of cell value with worksheet change event
  412. Color Index
  413. Data imported into Access from Access
  414. custom function doesn't update value when source value changes
  415. copy paste methods.....
  416. Detailed formatting problem
  417. Excel filter options
  418. "Time Clock" Functions
  419. Dates in a SQL Statement
  420. How to format trendline as same color as series line in XL2007
  421. Launch MS Visual Basic = Error in loading DLL
  422. function that returns cell and or font color of another cell
  423. Copy sheets to New Workbook - Excel 2007
  424. how to find the data in between the sheets?
  425. Macro using relative cell reference to set name for range
  426. Nightmare with Arrays
  427. using lists and bringing in info from another sheet.
  428. validation textbox for numeric values
  429. import =[test.xls]Sheet1!A1 - help
  430. SEND MAIL TO DIFFERENT ADDRESS WITH DIFFERENT MESSAGE
  431. How to make a dream living?
  432. RE: Conditional Formatting with VBA
  433. RE: Conditional Formatting with VBA
  434. RE: Conditional Formatting with VBA
  435. RE: Trying to change an Excel file to be database friendly
  436. Another last row in column question - with a twist.
  437. Going through a string, a char at a time.
  438. xml import error
  439. Long extract routine stops running
  440. select a range between 2 words
  441. Simple iteration problem. Help
  442. new menu opens in all worksheets
  443. error 9 - simple code
  444. Importing a single cell from one .xls to another
  445. Registry syntax to ensure that an addin is opened readonly ?
  446. Consolidate (sum) last sheet (32) of all workbooks in a folder
  447. Avoiding verbose code
  448. Reading formatting from Word table in C#
  449. How to retrieve the last selected cell before SelectionChange even
  450. Vlookup
  451. copy files by name patterns with wildcard
  452. If cell value is the same
  453. Create function to find a value in an array in seperate worksheet
  454. Macro to move data
  455. Name a New Workbook
  456. Hide columns based on related cell
  457. .XLA's Code Not Available?
  458. Re: Copy Row
  459. StopWatch Macros
  460. Re: Copy Row
  461. Re: Copy Row
  462. Re: Change formulas from relative addressing to absolute?
  463. Re: Change formulas from relative addressing to absolute?
  464. Trying to create a spreadsheet with drop menus
  465. Huge Number of Formulas
  466. Create CubeFields with C#
  467. Is it possible to loop through text?
  468. WinDBPro. Ver 2.0
  469. Save range as new worksheet
  470. How to removed the Dased Line using VBA
  471. Formula on Creating Unique Value (Similar to Select Distinct)
  472. Cycling Through Page Fields
  473. bob phillips, question bout conditional format white paper
  474. saving using ip address
  475. Update References To Absolute
  476. Adding to arrays
  477. is it possible for a drop down menu to select other drop down men
  478. Correcting time input by users
  479. cell range
  480. VBA code for 5-rule Conditional Format
  481. Macro
  482. Command Button Click Help
  483. For next doesn't loop
  484. Colours not changing
  485. Copy/Paste Macro; Loop is Misbehaving
  486. Summing values... conditionally
  487. Delete only the fourth character
  488. Userform
  489. Calling a Sub from Another Sheet
  490. CHOOSE and External References
  491. Macro to Add More Than One HTM File to an Email
  492. Chart Picture Size in UserForm/Picture Control.
  493. Condensing Format Code
  494. VBA to VB6 DLL, interface split to support Excel 2000-2003, 2007
  495. Execute code in a loop - Question
  496. Barcode fonts with Add-In for Excel simplifies creation of multiplebarcodes
  497. macro speeds
  498. Open files with a variable name in a folder get name in B1 and sav
  499. Displaying the Sub or Function Name
  500. saving in CSV with a nonstandard list separator - possible bug or 'bydesign' quirkness ?
  501. Connect to SQL Server
  502. unload vs hide userforms
  503. WEB Link
  504. Counting text numbers
  505. Sort Columns using lastrow
  506. Why wont inserting a shape record in a macro?
  507. RE: Open Excel from Access
  508. Macro to disable Refresh Data option?
  509. RE: Copy Selection to a Batch File
  510. RE: Copy Selection to a Batch File
  511. Excel 2007 VBA versus excel 2003
  512. DELETE CELL OF ZERO VALUE
  513. Macro code to proect and unprotect worksheets
  514. Save file with last month date on end
  515. Last Row of Data
  516. Naming variable range selected by cursor movement
  517. microsoft.public.excel.programming (PAGE PROBLEM)
  518. Executing dos command
  519. How to write own goal seek function which took parameters from excelsheet?
  520. Sample code
  521. FileSystemObject Issues
  522. ComboBox Will Not Advance To next Item in list
  523. Getting list data into spreadseet
  524. Dates - Days and months switching around
  525. Prevent "[File] now available for editing" popup
  526. Vanilla Ice in high-definition!!!
  527. PrintPreview of multiple sheets under Excel 2007
  528. Redim Preserve question
  529. Chart Generation. Changing interior color.
  530. Link Data to Excel Spreadsheet
  531. Excel macros run out of memory in Windows Vista
  532. SUM in VBA, Msgbox
  533. Macro to be to split an amount based on it value and spread over aperiod (months)
  534. For Each workbook in Folder A Copy Values & Format of each Sheet2...
  535. Protected sheet: Automation error for validation
  536. Send email in Lotus Notes
  537. Hiding Rows-Macro or Autofilter
  538. Plotting and selecting data
  539. Lookup from Excel to Access
  540. page set up
  541. Macro to Paste Value and Link to Another Cell
  542. Unable to set the FormulaArray property in Excel 97
  543. Dynamically increment date for data import from another spreadshee
  544. Macros and formatting disappear on save
  545. move an object in active directory excel 2007 vba
  546. intercepting the file | new command or the file | new menu choice
  547. Need a Marco to find and delete an entire column based on text sea
  548. extracting strings from cell
  549. Reviewing Large IF statements - Any tools?
  550. Re: FIND Macro
  551. writing macros
  552. Excel-Query-Access Question
  553. Find problem
  554. Use Row Number to find Cell value
  555. Hyperlink to a userform?
  556. Count cells
  557. VBA code for 5-rule Conditional Formating
  558. Blank or Zero or None?
  559. Automation error with validation object
  560. Breaking Link to a Circular Reference with Macro
  561. Visual Basic and Excel 2003 and 2007?
  562. using the slope function with non contiguous cells
  563. Using Error handling with the Find Method
  564. help with Sorting
  565. VBE is disabled
  566. Text Boxes and Shared Documents
  567. Attempting to copy multiple ranges from one worksheet to another
  568. Adding 4 cells next to eachother and then adding the following fourcells
  569. Needle in a haystack...searching for VBA code in all Excel sheets orfinding xls users of xla sheets....
  570. worksheet selection
  571. trying my first user form.....
  572. Sum col with reference to criteria in other col
  573. right click
  574. Using a variable to select a cell on a worksheet..."Subscript out orrange"
  575. How do I name an autoshape so that I can refer to it in a macro?
  576. Is my VBA wrong???
  577. Auto-Installing .XLA first time a spreadsheet is opened?
  578. Running MS Access From Excel VBA: Communication Between Processes?
  579. Grid Lines in Color-Filled cells
  580. Create a floating tool bar.
  581. database connection dsn vs. odc
  582. Make an autocorrect entry italic
  583. write date into file in YYYY.MM.DD format
  584. Running a macro across a folder
  585. Global Address Book Question
  586. Pivot Table Code Fails
  587. How to avoid being asked for a VBA password on workbook close?
  588. SIMPLE msgbox Problem
  589. Format Cells Dialog from a Macro
  590. Wierd Problem Excel 97
  591. Very EASY & SIMPLE VBA~!!! HELP msgbox
  592. Excel UserForm to Collect Data for Access
  593. Urgent!!! Run-time error '-2147024770 (8007007e)' Automation error
  594. Network file attributes
  595. Copy and Paste from Internet Explorer
  596. Workbook_Open Macro
  597. ODBC in Excel 2007 to work in Excel 2003
  598. All Possible Combinations
  599. Conditional Formatting in Excel
  600. Limiting Input Range using VBA
  601. Need help with creating a caluclated pop up
  602. Master xls to CSV
  603. Consolidating Data from Multiple lines
  604. Multiple users writing to one file.
  605. performing calculations on time data
  606. calendar control
  607. VBA Email Macro Skipping code
  608. Excel 2003 Add-In Automation
  609. store active workbook
  610. Changes to entries made through validation
  611. Non-Intersect Function
  612. show cell reference as text
  613. Creating a link from one workbook to another
  614. Pivot table vs formula
  615. Display Custom Document Property
  616. blank cells
  617. RE: Selectable Column SUM
  618. sound
  619. Events
  620. Problems with Reg Pattern "[^"]\$[A-Z]*[0-9]"
  621. How to distribute your macro?
  622. insert data picker into range of cells
  623. Display Worksheets from AddIn
  624. How to keep format while pasting
  625. Excel Query
  626. columns
  627. dynamic cell addressing in formulas
  628. Macro on filtering pivot table (pivot fields) => debug
  629. 2 named cells
  630. how to enter if formulas
  631. Macro that will add multiple emails based on a range of cell values
  632. Custom cell format
  633. Why wont my code populate Textbox ?
  634. Convert xx:xx:xx to decimal value so can be summed.
  635. Embedding Help
  636. Managed Add In With Excel 2002
  637. Loop
  638. Office Automation
  639. WinDBPro. Ver 2.0
  640. Box Border in Header - Excel 2007
  641. Problems with Processing Emails
  642. copy cell B19:J19 Range data’s from sheet1, and to past in sheet2
  643. Textbox validation
  644. CheckBox
  645. Trendline color format bug/issue?
  646. RE: Determine which button was clicked on a sheet
  647. Adding a new row in VB
  648. What is the proper syntex for .cells or .range ?
  649. Find / FindNext Trouble
  650. VBA : Sumif on different workbooks! *********
  651. Creating a Formula
  652. Control-Break
  653. Internationalization: Addin names
  654. Unexpected result using Datediff
  655. CountIf in VBA
  656. Percentage of values in list
  657. Customised Buttons
  658. Delete part of cell value
  659. Delete part of cell value
  660. Windows API calls
  661. Compare Differences in Blank Ranges across sheets
  662. control the controls with a control
  663. DOEVENT stops working??
  664. How to set an arg list for my VBA functions
  665. How can just opening & closing a workbook prompt the Save? dialog?
  666. label captions
  667. Problem Setting Range
  668. insert rows in Multiple worksheet
  669. Replace file without being prompted to save
  670. Array using 2 columns
  671. setting Range from address
  672. Input formula into a column via macro
  673. Hide automation add-in functions
  674. Sending a selection by email
  675. NOT ABLE TO ENTER VB CODE
  676. Loading Sheets into a Customer Collection
  677. Conditional Formatting - Formula - Excel '97
  678. Validation for Textbox in Userform
  679. Re: Change 'ENTER' key behaviour on different cells
  680. C# 2005 Excel access to Axis (xlSecondary)
  681. Macros and VB
  682. getting macro installed in each new workbook
  683. Check if shape exist
  684. variable not set
  685. Conditional Formating Issue
  686. Create calculaed members in Excel 2007 Pivot tables
  687. TO ARM REPORT FROM BOOKS CLOSED - ADO
  688. export visible rows only
  689. get number of service pack installed
  690. change the appearnce of a userform
  691. Variable Syntax
  692. VBA CODE SOLVER TO RETURN VALUE
  693. Renaming pictures
  694. Reading data from Excel and Word tables
  695. How I write "if cell value =>1, copy entire row & paste at dest.
  696. Inserting Name in a cells
  697. how to test whether selected variable is within defined range in V
  698. Excel Column "SET Filter to " in one column count in another colu
  699. lookup
  700. RE: Cut and paste columns programmatically
  701. insert rows by vba
  702. Relative and Absolute Links
  703. Freeze Data in drop-down combo box list
  704. Gary Student ? How do I add a For next to this.....Macro
  705. Deleting rows with formulas
  706. Change 'ENTER' key behaviour on different cells
  707. Read next value?
  708. Need VBA stript for column selection
  709. How to show columns/cells in sheet but hide them in print?
  710. Auto filter to all csv file in a folder.
  711. Dilettante Question: VBA to VB.Net?
  712. Macros
  713. count IF cell IS yellow
  714. Error '13' Type Mismatch
  715. Export Arabic data in to Excel issue
  716. Run time Error 13 Type Mismatch Excel 97
  717. Disable "contacting the server for information" message?
  718. Get Workbook Object properties without opening Workbook?
  719. Need a macro to Copy data from one sheet and paste to child
  720. INDEX & MATCH Help with syntax please...
  721. Can't find libraries
  722. Automatically run Macro before printing
  723. Getting there but.....
  724. getopenfilename <> this workbook
  725. cursor movement on optionbuttons
  726. VBA - checking for existance of a property
  727. accept fractions from textbox
  728. Error 424 for sample code?
  729. color formatting from vbe
  730. macro adjustment
  731. Shortcut key to commandbutton
  732. Excel Macros
  733. Excel CDO mail
  734. CDO mailing from Excel
  735. looping through comma delimited text
  736. VBA and VB6 functions return different answers?
  737. Enumerate cell formulas
  738. remove Add-In?
  739. Find Help
  740. Selecting File to do VLOOKUP From
  741. For Each Cell in Sheet1 Range, do some Vlookup calc. from Sheet3
  742. find a value in a column then copy next few rows
  743. Checkbox works in one window but not another
  744. passing column character as subroutine parameter
  745. from VBA to DLL VB6 for security's sake:recommendations sought
  746. 2003 2007 Code
  747. Need a macro
  748. Testing Blank Conditional Formatting
  749. Conditional Formatting
  750. Insert text from Comment in 3/4 TextBoxes in a Form