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. ADO connection Open failure
  2. Determining row # of selected cell
  3. combobox multiple columns
  4. COUNTIF Query
  5. Remove Modules
  6. inconsistent excel execution of cell logic
  7. Cell address of function call
  8. Keep User Form Active
  9. Need help in creating dynamic drop down list in userform
  10. Interpreting some code in C
  11. Displaying a Userform
  12. sorting column order
  13. Convert excel formulas from worksheets into standalone ie. databas
  14. strange range access
  15. sorting by Contract #'s
  16. Simple Macro task driving inexperience user crazy
  17. Copying Conditional Formatting from one cell to another
  18. Last Cell
  19. how to change 1 line of data to multiple rows
  20. VST"A" with Excel
  21. ADDIN TOOLS
  22. Match two excel spread sheet using Macro
  23. Workbook_Open not executing in Excel 2007
  24. Pause Until Mouseclick?
  25. need to stuff the array with the nth number of service groups
  26. check for last day of month
  27. Please help with my code
  28. In Excel 2007 how to switch off macro with a macro
  29. Refreshing External Data Ranges
  30. how to fill an array with the nth number in a list
  31. Text Property of the Range Object
  32. Compare and Highlight Differences
  33. vba code to show specified sheets in list box
  34. Import binary file and convert to HEX data
  35. show / hide chart data
  36. How do I find all zip codes from the web?
  37. The fastest way to count values in a range
  38. need to add 24 rows to each service group
  39. macro to add 24 rows to each group in column H
  40. Macro to stop data entry errors
  41. Making all past dates bold, looping
  42. add xtra rows to before the subtotal rows.
  43. Excel Nooby -> Importing a file..
  44. printing list box in the user form
  45. countif using multiple criteria
  46. Vlookup in multiple sheets
  47. Open wb from a wb and run a macro
  48. Run-time error '1004'
  49. File Exists 1
  50. Determining if certain row # is blank
  51. USERFORM CONTROL COPY: IS IT POSSIBLE?i
  52. VBA To Calculate Across Monthly Worksheet
  53. Using Excel VBA to run C function in DLL
  54. Making Access Queries Static Data
  55. OLE Link bug introduced in Excel 2003 SP3
  56. Change cell reference type
  57. Check Input for Valid Month
  58. Quering a changing range SQL
  59. list box based query
  60. for each next question
  61. Java Script
  62. Open all workbooks inside a folder, run macro and save them?
  63. How to check for duplicate values within a column
  64. userid in macro
  65. BackgroundWorker and Excel
  66. Sorting Backwards
  67. Cannot close a workbook in VBA due to Run-Time error '1004'
  68. Using a workbook name
  69. Range or Array?
  70. Saving file when path is unknown
  71. Nth Day Of Week For A Month
  72. Can macro return me to cell edit mode
  73. Import data from a log file
  74. XML schema edit
  75. When I type an H in Excel, I need to to change to the colour red?
  76. comparing text strings
  77. Creating a macro that reformats data in excel
  78. label control from macro
  79. Functions for manipulating arrays
  80. UserForms - how to return a value?
  81. Colour Coded Shapes
  82. Fine
  83. efficiency
  84. using text box or list boxes info for email distribution list
  85. Indirect & Named Range
  86. referencing a cell in a hidden sheet
  87. Cummulative Totals
  88. Worksheet-level event
  89. Is Conditional Format met?
  90. Run in small window?
  91. Huge problem with comparing cells in different ranges and sheets
  92. Hidden formulas
  93. MultiPage Control
  94. insert named cell in header
  95. I need to suggest a value
  96. determine the name of the selected pivot table
  97. Double-Click to Change Interoir Color
  98. How to delete CONSECUTIVE duplicate Rows
  99. Simple If statement encounter error
  100. Very Simple Copy and Paste Sheet - Error
  101. What is the Cause of this Error Q
  102. Email button
  103. Moving Average of Array : Can use built-in functions?
  104. Additem problem
  105. ARRAY QUERY
  106. Worksheet events inactive
  107. Getting Started with Excel Programming
  108. Incrementing a string
  109. A Property or Collection?
  110. Operator is in excel cells, how to reference it
  111. How to use operator in cells
  112. Entering a value into a cell with a formula or by tying the value
  113. Total number of cells
  114. How to get the mouse scroll-wheel to work in Excel VBA IDE?
  115. How to declare global variable in Excel VBA?
  116. Color macro
  117. Clear Blank Cells
  118. MultiTab userform question
  119. Use of Tab key in a range
  120. Copy and Remame Sheet in active Workbook
  121. Use Keyboard with KeyDown and KeyUp
  122. Worksheet_Change
  123. Find a string in a column
  124. Hiden sheet code - need access
  125. How to return a value from a function?
  126. Save copy on close ?
  127. Cell Value
  128. remove items from listbox together with add item
  129. Application inputbox, Range versus Cancel
  130. Apply macro
  131. How do I set up a progm that allows entry of daily tips.Waitress
  132. Listbox-userform question
  133. Change Cell contents
  134. How to find the Day of week in a Month
  135. Help with text length of cells
  136. XValues series breaks on disjoint ranges - but works fine in Excel 2007
  137. Writing array data to range object always writes 0's on worksheet
  138. adding multiple spreadsheets onto one to sum up values
  139. Pivot Table Data format
  140. VBA Event to Restore Lost Public Variables
  141. Track Changes
  142. On Error Resume Next question
  143. Chapter 5 professional Excel Development
  144. How do I Automically add the file path to a new document?
  145. Displaying A custom menu as a popup menu
  146. Clear print preview dotted lines?
  147. Change filename & auto_open
  148. Formatting and data loss when migrating from Excel 2003 to 2007
  149. clear cells containing specific values
  150. printing to a computed column
  151. Max Name Ranges Allowable in Excel 2003
  152. Pass array of sheet names to subroutine
  153. Copy and Past Macro
  154. save textbox as number wth Cint?
  155. Aligning buttons
  156. Import Web Page
  157. Type-ahead on multi-column combobox?
  158. select listbox item
  159. reference a cell within the header
  160. Validation List
  161. code is not selecting correct range
  162. Pick value off sheet list for VBA code determination
  163. Can't set Application.Interactive
  164. Writing to windows directory in Vista
  165. complex IF statement
  166. Identify Last Cell and autofill last column
  167. runtime error 1004
  168. Multiple results for vlookup
  169. Address Referencing
  170. Assigning a macro to a picture
  171. macro for arranging by Contract #
  172. Code modification?
  173. Copy a Module - Please Help me decipher the Pearson Code
  174. Macro to log .xls file names
  175. Macro to lock project from viewing
  176. Format affects precision?
  177. Change the worksheet tab name updates hyperlink on first page?
  178. pivot cache in VBA
  179. right-click cell menu only for specific range
  180. Coding Formula
  181. Pivot Table Macro
  182. Excel Range of multiple columns
  183. Protected Object
  184. Automated Search and Replace; Sheet2 to Sheet1
  185. VBA Code to Delete Part of Row with Data
  186. password protect a macro on a command button
  187. Array?
  188. collapse conditional formatting?
  189. VBA - array or collection literals?
  190. Calculating Counter
  191. Function breaker tool
  192. Which one is most powerful for developing a Excel Application
  193. Conditional Formatting
  194. Re : Excel Hyperlink to Open an External File
  195. range names in macros - syntax again
  196. Using 'i' to calculate public variables
  197. How do I code auto email alerts when a certificate expires?
  198. Last Value in Column B Shifted Down & Value in Column A Shifted Do
  199. Late Binding Problem between Excel and Project
  200. Fin End of Used Range
  201. calling a macro upon selecting a cell
  202. Applying random changes to a list of numbers
  203. Is there a formula to transpose numbers, e.g. change 36 to 63
  204. Simple Excel VBA Question
  205. Looping through different comboboxes in an excel sheet
  206. Insert Row *below* button position - no need to copy formulas
  207. New Tips Website For Excel
  208. UDF's and Workbook events
  209. how create pie chart reflecting data from multiple worksheets?
  210. Macro doesn't work when sheet protected
  211. Adding up unique numbers in a column
  212. Text blocks and multiline textboxes
  213. OpenText Method with "StartRow" as a variable
  214. How can I enable hide functionality for a protected worksheet
  215. StrComp numeric
  216. Wild Card?
  217. Save Textbox into Named Range
  218. PasteSpecial Constant
  219. Odd behavior of ActiveX ComboBox on worksheet
  220. GetPivotData
  221. Excel 2003 Macro in Excel 2000 Environment
  222. calculate a correlation with ranges
  223. Organizing the VBE
  224. Still struggling... how make a hyperlink not hot!
  225. Finding the last one
  226. GetWindowsDirectory in Vista
  227. Find values over a certain amount
  228. Evaluate IF(OR Statement
  229. Excel code from 7 day data to 1 day data-pivot tables
  230. If then statement
  231. OK, I simplified my problem a bit, smart people sound off!!!!!
  232. Validating checkboxes
  233. Worksheet name with space problem
  234. Round to nearest month
  235. Importing an Excel file and prompting user for input
  236. Shell Command read Range and Loop
  237. Checkboxes are duplicated over and over as emf in the Temp folder
  238. Refer to a specific element of a UDF created array in another UDF?
  239. Advancing Cursor
  240. Delete Data in Range -macro
  241. Changing default menu item behavior
  242. Avoiding a range in recalculation
  243. Solution: Calculating Time Elapsed Between Two Dates
  244. Please help with coping cells
  245. Delete multiple rows
  246. How do I round a date?
  247. Different results when running macro vs stepping into macro
  248. ot- link to fixes in office 2003 sp3
  249. time function
  250. Font size and rows height for whole sheet
  251. Moving a Comment into a Cell - automaticlly
  252. find "Cancellation" in column "A" and copy all data from Columns B-F onto another Sheet
  253. Use Command Button from each Row to fill UserForm
  254. closing form when pressing escape key
  255. Border for range
  256. Macro to Select
  257. Excel / Access User Conference - Oct 24-26, St Loiuis
  258. Character Limits within an Array?
  259. .Display (One for Ron De Bruin maybe!!)
  260. Shift+Del buffer
  261. Auto Capitalization annoyance
  262. FInd value and insert rows below
  263. Passing a variable to UserForm_activate() event
  264. Using .AutoFill with a CELLS() reference
  265. Activating javascript with excel
  266. VBE Coding tools
  267. Inputbox used for password
  268. Auto run a macro
  269. Time formats in A form AND in a worksheet
  270. Creating a new column through a column sub-header
  271. Disable message box when trying to save a read only workbook
  272. SQL
  273. How can I detect that the user canceled a close?
  274. Change color of an autoshape
  275. HELP with Syntax please !
  276. Excel automation: connecting to Excel
  277. "How do I un/protect sheet by macro program with password
  278. Creating a toolbar that works in Excel 2000 and 2007
  279. Eliminating dupes in a single cell
  280. Is This Possible?
  281. real time read & write of excel spreadsheet on website
  282. how to excel automation erase macro name..?
  283. Default Formats
  284. Conditional Formatting
  285. run-time error 1004
  286. Is this type of VBA Logic possible? Delete Unique Row
  287. from a cell to my textbox
  288. Is conditional format met in XL2007?
  289. Re: Error - SendKeys in between a macro
  290. Automating requery
  291. Lookup function in VBA
  292. Help with TEXTBOX control
  293. Re: Concatenation prob
  294. Newbie needs help
  295. Code for deleting rows?
  296. Need help by smart people!!!
  297. if fill color = this, then increment this cell by one
  298. How to refer to the specified sheet in the workbook?
  299. How to create a UDF to return an array of values with input variab
  300. Iseries - Transfer to
  301. Insert Varying # Rows
  302. Drop Down Lists
  303. How do I get a complete list of all VB Functions
  304. Want to change color based on Text, NOT using Conditional Formatin
  305. Regular expressions
  306. Conditional formatting in a programmed cell
  307. how do i extract multiple data from a cell(string) whose length v.
  308. addnew record automation
  309. ListBox & TextBox Save
  310. Programming a pivot table
  311. Nulls in Pivot Tables
  312. Help with solving
  313. Toggle Between SheetVeryHidden and SheetVisible
  314. Excel cores when trying to close a workbook after exporting+removing VBA modules
  315. Copying select data frm one workbook to multiple workbooks & save
  316. Odd Lookup Formula
  317. Nested Do Until Loop
  318. Removing with formula
  319. Using worksheet_change
  320. auto update text in cell b as date in cell a changes
  321. macro cell add a comma
  322. Converting WeekNumber to Weekday
  323. Open csv file with all values as text
  324. pivot table refresh
  325. Data validation list type
  326. Opening Hyperlinks
  327. Arrays and deletion
  328. Execute Worksheet_Change before recalculation
  329. Replacing a module by coding in VBA
  330. GOTOs
  331. Automation in excel
  332. format date
  333. Interest Rate Help
  334. Do I have superfluous code?
  335. convert multicolumn/multirow table into two structured/formatted columns => feasible?
  336. Find cell contents within a data matrix
  337. Problems with Pasting Array contents in cells
  338. Navigation
  339. Reference for German Code
  340. Help with insert a row
  341. Indirect Variables; List of Variable Names
  342. workbook level name vs worksheet level name
  343. find entire string then row background red
  344. Macro with input box to Select a column on active sheet
  345. Compare Rows on different Worksheets and Output Difference's to other Worksheets.
  346. Opening a Hyperlink using macros
  347. VBA way to access of the cell being calculated?
  348. closing workbooks
  349. Sorting and graphing
  350. finding first empty cell
  351. Converting Hyperlink formulae to real hyperlink
  352. Flickering screen while processing macro
  353. Restrict Copy to Values only?
  354. Text File Import - File Origin
  355. Cell bg-color
  356. if todays date is in the month of january, then specific drop down list, if feb, another list, etc
  357. File freezing - Trust access to Visual Basic Project setting
  358. Error - SendKeys in between a macro
  359. Custom properties to Sharepoint
  360. Grouping function in VBA Excel
  361. Change document properties
  362. Saving Worksheets
  363. Open "Find" Userform
  364. Open "Find" Userform
  365. FileSearch error 1004
  366. Remove Item from Listbox by Item Name
  367. PIvotitems visible
  368. Need macro to add 100 years to a cell's date
  369. External Reference Data Updates.
  370. Print to PDF file in Excel or Access
  371. Subtract 5 minutes from Now()
  372. setting up blank lines in an excel 2003 pivot table
  373. userform question
  374. Here's one for the masters
  375. Excel automation: Problem with inserting an array of formulas into a range
  376. Excel phone number formula
  377. Excel problems with macros
  378. Frequent Crashes with User Forms
  379. How can I insert a row in MS Excel using a formula?
  380. Using VBA - create array - parse values - find differences
  381. Changing For...Next index
  382. Count?
  383. Listbox Formating
  384. Mammoth Insert Formula
  385. VLookup Function in VB
  386. Run time error 9
  387. Opening .xls files
  388. Converting Text to a hyperlink
  389. Dynamic sorting and selection of data
  390. VBA String Output adds Quotes when I cut and paste to Notepad
  391. Add New AutoCalculate Function
  392. Delete row
  393. determine if value in pivot table
  394. Checking which row is selected
  395. sorting a changing range
  396. Excel coredumps with each call to a dll - for function RegQueryValueExA in advapi32.dll
  397. Excel 2007 - Using a Named Ranges in lieu of Cell References
  398. To Do List
  399. Format Unlocked Protected Cells
  400. Pivot Tables - DisplayEmptyColumn question
  401. F1 Help key in VBE problem...
  402. removing #NA from the list
  403. permutations/combinations
  404. Unique data...!
  405. Deleting Blank rows as a result of a formula
  406. Copy a File 'n' Times, New Filenames are "File_n.xls"
  407. Save only the code from a Sheet?
  408. Delete Row 22 in all Sheets
  409. Use loop to re-arrange:
  410. Worksheet_Change Event problem in 2007
  411. Spread macro
  412. Help with known issue
  413. If then, adding more choices
  414. move offsetting values
  415. Disable Right Click
  416. Opening Hyperlink
  417. Selection
  418. Count if begins with AAA
  419. Macro Using Cell Data for .Log name
  420. vba
  421. Coding needed for shaded cells
  422. Save As
  423. F2 Cells in a column
  424. If Then Statement
  425. No cancel on input
  426. 'BeforeClose' code problems:book won't close if more than one book is open
  427. UsedRange and Ctrl-Shift-End Mystery
  428. Need help using date as an index
  429. seting a changing range to sort on 3 different sheets
  430. data in a column
  431. Scripting Dictionary to hold User Defined Type
  432. data on top
  433. File open - .xls not recognized as spreadsheet
  434. appending series
  435. Last day of the month
  436. Hide rows if...
  437. Formula for the last day of the month
  438. Compare multiple column rows on different worksheets.
  439. VBA 2007 -- How can I tell if the user cancelled a Save?
  440. Automatic refresh macro
  441. Call a file name from within string
  442. vba coding
  443. "... or one of its dependencies, was not found."
  444. Excel app as web app
  445. new version# when opening file
  446. Histogram
  447. caption of Triplestate buttons
  448. solver add in / excel solver / vba
  449. Extracting numbers from text string
  450. Date Format
  451. Changing Chinese Font in Excel
  452. Insert Concatenate formula in Cell
  453. data validation with indirect ref to dynamic range
  454. list box column widths
  455. Testing if Commandbar exists
  456. Looping thru multiple files to produce a consolidated summary by Code
  457. Importing CSV just like Excel opening CSV
  458. Combobox on Quick Access Toolbar
  459. CLICK THEN GO TO NAME ON SEPARATE WORKSHEET
  460. Print preview creates problems in macro heavy reporting tool
  461. Full proof UK postcode validation
  462. Running Conditional If-then script off a command box
  463. How do I Run Macro on Opening if user is not the "Last Saved By" U
  464. How do I write code to "Workbook_Open" from within a VBA?
  465. Macro to Paste at next blank row
  466. Coding to remove and import Module
  467. Generate list of numbers between start and end value
  468. Multiple selection (range or individual) capability in a drop down list
  469. Imported .csv file - illegible data
  470. manipulating controls
  471. Can you limit the amount typed in a cell in Excel 2003?
  472. name validation
  473. rename column header after filtering column results in the MS SQL
  474. Multiple Search Criteria - One works other does not.
  475. how do you set up the simpsons rule on excel?
  476. Macro - Share with Users on a shared network drive
  477. Loop until finished
  478. need help with nested for-next loops
  479. Deleting Duplicate Rows
  480. select range of cells in multiple colums automaticlly
  481. Sheets("sheet1").Copy
  482. Easy Syntax Question - refer to current row & column to pull a val
  483. List Modules in a user form
  484. Excel 2007 autoopen shift key doesn't work
  485. match two excel spread sheet using macro
  486. PageSetup changes not working in VBA
  487. Looping thru multiple files to produce a consolidated summary by Cod
  488. SetText Format in Excel sheet Cell
  489. Enforcing worksheet Naming Conventions - Trapping Copy/Rename work
  490. How do I stop 2nd row deletion
  491. Can Outlook contact data be linked to an Excel Workbook cell?
  492. Auto-correct macro or VBA
  493. Help with insert a row
  494. Password protect worksheets
  495. Help on Macro
  496. Modified McCauley Duration From VBA?
  497. Macro to Unlock All Protected Worksheets
  498. Help with VBA date
  499. why doesnt my VSTO SE addin work?
  500. Macro to Modify a Macro?
  501. highlight a column
  502. Filtering on String Length
  503. Type Mismatch Error
  504. Summing while hiding?!
  505. If Range("J1").Text...Then
  506. What happen when a row is hidden?
  507. What happen when a row is hidden?
  508. What happen when a row is hidden?
  509. Is there a way to make the text blink on and off using Excel VB?
  510. Listing all cell references
  511. Finding chart on worksheet
  512. Updating Data between workbooks
  513. Find a substring
  514. Pivot-Multiple Items-Linked Pivot-Macro
  515. copy Module via macro
  516. Kill Error Message
  517. Save creating enormous temp files
  518. Alignment of Figures
  519. How do I display cell name with Msgbox?
  520. Excel "stuck"
  521. transpose Copyfromrowset
  522. Macro to expire after a specified date
  523. Command Bars - working with the built in buttons
  524. Call VB6 DLL from VBA wrapper
  525. How to determine type of function argument?
  526. How to Disable a special button
  527. How can I access Directory Names?
  528. Issue with mail merge date field
  529. delete blank rows and remove blanks from dropdown
  530. How to remove single quotes
  531. VBA/Macros in Cell Edit mode / Formula text selectio
  532. number to words
  533. Adding class object to collection repeats same object through collection?
  534. Define Range Dynamically
  535. Protecting & Unprotecting worksheet
  536. sumif question
  537. Variable type
  538. Compare xls & mpp files against a master file register then flag missing.
  539. What is Runtime Error 6028 and how can it be resolved?
  540. Improving the code from a recorded macro
  541. Run Time Error 6028: Help?
  542. Import data from a secure website to Excel
  543. Button to email?
  544. Whats happened?
  545. Find a Number and Date - VBA
  546. pivot table running total problem
  547. Stamp a Cell with Time Q
  548. Help with For Each ... Next and control
  549. row index number in a hlookup formula
  550. Data Validation Macro
  551. Compound IF statement
  552. File Exist
  553. Export a chart in a GIF file. Run-time error '1004': Application-defined or object-defined error;
  554. all open workbooks
  555. end if without block if error
  556. Dates and Conditional Formatting
  557. Return Value from MsgBox
  558. Is Worksheet Empty?
  559. Macro function to read text file
  560. Selective Worksheet printing
  561. Save it giving as a name the content of a cell
  562. named range as rowsource
  563. Custom Ribbon example in Walkenbach's "Excel 2007 Power Programming with VBA"
  564. How to Find the last non empty row
  565. Two related Data Validation lists
  566. Table Live
  567. a1+a2=a3 How can I change a2,keep old a2 value & increase a3
  568. MsgBox with Two Questions
  569. Cal formula upon sorting
  570. linked cells not updating
  571. can't activate chart
  572. Null Value
  573. Copy Module to new Workbook
  574. creating a formula with a loop
  575. Tidying Recorded Macro Code
  576. Macro to change font
  577. Cannot change column name in Excel's MS Query tool
  578. Accessing the text of a form command button from underlying macro
  579. Make shortcut to Excelfile on desktop
  580. select data from dropdown menu
  581. Error on E-Mailing Q
  582. Build whre statement
  583. Invoke Edit Mode
  584. Changing a two-dimensional, one row array to one-dimensional
  585. value of one cell in a named range
  586. NUMERICALS CAN CHANGE IN ALPHABHATS
  587. How do I create a pulldown value list for data entry?
  588. form population macro
  589. How to write code for find a word in excel?
  590. Pivot Table Custom Filters
  591. Find a Number and Date ...
  592. Transfer data from one workbook to another workbook based on a key
  593. Pivot Tables - DisplayEmptyColumn question
  594. AutoFilter
  595. Visual Basic v6.3 and Excel v2002
  596. VB Help/Request? Compare and insert to different data in columns
  597. Capturing Listbox Selections
  598. Conditional Formatted numbers add based on color?
  599. On File Open
  600. Counting Worksheets
  601. Finding the path of a folder
  602. if questions
  603. Buttons disappear when projected
  604. Any way to enable the 2007 pivot table option Defer Layout Update with VBA?
  605. Question on this conversion code switching between r1c1 to A1 format tia sal2
  606. Hiding Columns
  607. goal seek reference
  608. Run-time error
  609. type mismatch error when passing collection byRef
  610. Only want to see half of my result
  611. Remove a cell from a range
  612. running Access procedure from Excel
  613. Macro to delete rows
  614. how to suppress auto correct?
  615. Xlusrgal
  616. Import from MS Access - Lose the drive letter..link only to drive
  617. Fill Cell with Asterix
  618. Hide all toolbars/menu bar when open file
  619. Counting elements of array and range type data
  620. Answer msgbox with macro
  621. Copy Command Button Code.
  622. Undefined MergeArea when MergeCells is true
  623. Changing Numeric value to text
  624. IF statement in excel
  625. Key combinations not used by Excel to use in macro keyboard shortcuts?
  626. Find error!!!! Is there any other way to do this?
  627. Find error!!!! Is there any other way to do this?
  628. how to recognise a c# dll in vba excel
  629. Not Enough Memory to run Microsoft Office Excel.
  630. allcaps option in excel like word
  631. Preventing corruption of dynamic range names on cell deletion
  632. Application.Volatile not working
  633. Deactivate Code
  634. transforming poll data from rows to colums
  635. Help- It's only a tiny change
  636. Exception occured
  637. TreeView1
  638. Open Forum 4 ALL
  639. Check a workbook exists before opening
  640. "view page breaks"
  641. Getting file name and Modified date
  642. Linking to several other spreadsheets
  643. I need help programming a joke on a friend.
  644. Conditional formatting based on what function is used in a cell.
  645. Columns limit 512
  646. Using an Array to Speed-Up Range Copy
  647. Set Class1Var = New Class1
  648. Working with huge cells
  649. Matching two worksheet?
  650. align left and right in listbox
  651. How to print out matching names?
  652. macro to color all text red in worksheet if within certain date
  653. Excel error message
  654. check control names
  655. Deleting Rows if certain criteria isnt met
  656. Starting excel and running it on the same process
  657. excel 2003 Reading workbook properties / details from an XLA how do you do it?
  658. excel 2003 Reading workbook properties / details from an XLA how do you do it?
  659. Auto number formatting
  660. Hide rows and prevent unhiding
  661. Inserting sender in voting response
  662. Workbooks.Add = Macro Regression in 2007
  663. sql
  664. Macro to copy data with a date criteria
  665. Use cell values as object names
  666. VBA code to email 1 worksheet in a workbook
  667. Instead of the word "dropped" could I use an arrow?
  668. VBA Question - Delete set if any member meets criteria
  669. Removing Blank Rows for Excel VB Newb
  670. Calendar with weeknumber?
  671. How do I use the Shift+Ctrl+down feature in a macro
  672. code reopens file
  673. Active worksheet problem
  674. macro to close file and not save changes
  675. Partial sheet protection
  676. Copy only basic number without dollar sign or commas (or cell formatting)?
  677. Best way to import .csv
  678. Is there a way to run a procedure before the paste command?
  679. Tab printing Macro
  680. Macro acting wierd with Zip Codes
  681. Missing Reference causing strange errors
  682. What's the fastest way to push this data around?
  683. hide sheet
  684. Code to Print single cells
  685. Worksheet_Change
  686. Grouping Checkboxes in a UserForm
  687. display cell contents
  688. range values
  689. Two Parter: filter list and search for a match for the password
  690. If Then statement comparing date values
  691. Flag me if macro errors
  692. Worksheet Change event code, but retain Undo?
  693. Why does VBA mess up
  694. Checking if a property contains another specific string
  695. Batch deleting invalid defined names from a workbook
  696. this code crashes excel. How come?
  697. Code to Create a Command Button
  698. Can VBA Code change itself?
  699. Printing to Local Printer and the not the default printer.
  700. Location of Cell with Value in Merge Area
  701. Finding Embedded Object Type in Worksheet
  702. Finding embedded object type in Excel Worksheet
  703. Excel / Access User Conference - Oct 24-26, St Loiuis
  704. use a variable for a worksheet name in a formula
  705. How to create a time log sheet
  706. Excel cannot complete this task with available resources. choose less data or close other applications
  707. defined name with formula as source in VBA
  708. opening a file from a cell reference
  709. Copy-pasting from Excel to Word
  710. Is there a code to clear clipboard to prevent pasting on mouse mov
  711. Export and Import Userform from Excel-file to another Excel-file
  712. Using Shape's OnAction property in C#
  713. Draw Entries
  714. Error in Insert Row command.
  715. Conversion from columnwise to rowwise
  716. Find function using chr
  717. Excel macros
  718. Track Changes History sheet (Who changed the last cell)
  719. Code Needed For a Macro
  720. Selection.Replace What and double quotes
  721. help on Converting R1C1 to A1 and A1 to R1C1..tia sa2
  722. Hiding Columns
  723. Split first name and Surname
  724. copy checkbox to multiple cells?
  725. Editable Worksheet_Change Result
  726. Formatting the excel window
  727. Sheet CodeNames
  728. Stop a user from opening Excel if the Add-in is not found
  729. Sumproduct, array
  730. Option Explicit when install Essbase
  731. can't transfer to worksheet
  732. Auto size named range by .Net or VBA
  733. How do they do that?
  734. Macro not running when it is supposed too
  735. array data to cells
  736. Req help on Formula or vb in excel to calculate between reference style and formula style tia sal2
  737. Arrays [Why does this not work?]
  738. if database exists... MS Query
  739. Nested IF problem
  740. TRANSPOSE and INDEX limit in Excel2007
  741. Hiding checkboxes
  742. Convert numbers to text (from product id # to name of product)
  743. Search all worksheets
  744. Search all worksheets
  745. help with this loop macro
  746. Finding the nearest match without reusing results
  747. List Worksheet Names in a Dialog
  748. End(XlDown).Row - Problem if only 1 row
  749. Named range reference in VBA for Excel 2007
  750. CHANGING FONT SIZE