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. transpose values
  2. How to set up a weekly Pennant draw with list of players and not
  3. Timing Multiple Events
  4. Displaying data Horizontally
  5. sum across cols using for/ next
  6. Why EXCEL is going into Breakmode and open code window.
  7. Naming/Renaming a Module
  8. Copying part of a string to another cell
  9. Printing updated sheets within a spreadsheet when files are upload
  10. Convert Decimal Minutes to Hours-Minutes-Seconds
  11. PERSONAL.XLSB
  12. VBA Dictionary Trim to N smallest items
  13. How do I convert a macro that was created in 2003 Excel to 2007
  14. Test for numeric constant in a cell
  15. Application.Quit
  16. Billing Statement Help
  17. Cannot run debuger properly
  18. Problems with moving to next empty column
  19. Need to add hyperlink using VBA code
  20. .movefile
  21. Determine which commandbar called a function
  22. Read csv to 2D array
  23. Personal.xls macros will not work in any other sheet
  24. Programmatically Disable Taskbar
  25. Return caption of unknown button into a cell
  26. cell.Characters and Fonts
  27. Help Deleting Rows
  28. How to work on a new worksheet
  29. comandbar controls
  30. swapping out drop down box
  31. Search for cells that DO NOT contain specific text
  32. vlookup
  33. Macro Help
  34. Add reference to Outlook library programmatically
  35. complicated command button
  36. Adding Sheet using Template creates link
  37. simple copy paste multiple range macro ARGUMENT ERROR
  38. Data Not Transferring From Source to Data Worksheet
  39. Protect Macros
  40. System.Runtime.InteropServices.COMException (0x800401A8)
  41. Convert Letters to Numbers?
  42. How to force column formatting (text, date, etc) when loading a fixed width text file into an array?
  43. How to code tab order for Controls in Excel forms
  44. How do I get the current Date to autofill in a column
  45. Corrupt File Issues - Opening in 2003
  46. SendKeys
  47. Using a variable to select a CommandButton and setting the caption
  48. File Search for Combo Box Usage - Excel 2007
  49. preset range
  50. Validation of text cells through Code
  51. Const declarations and accessibility
  52. unmatched data string
  53. Issue about send email through lotus notes
  54. Populate a formula with macro
  55. Userform - On movement leaves a trail.
  56. Macro's Pasting into continous rows
  57. Macro Problem
  58. Pasting values on first blank row
  59. Test if a Workbook is Open
  60. How to run sub menu items from VBA
  61. Merging Rows
  62. How to edit MyAddIn.xlam
  63. Macro to select a variable range
  64. Keep a record of entries in cells
  65. SaveAs
  66. auto run macro on cell change
  67. Date Issue
  68. To open an excel file.
  69. How to create a standard Quick Launch menu in Excel 2007
  70. Update A Url Image
  71. Get an enum value assigned with *concatenated* string
  72. Get an enum value assigned
  73. Reset to full rows visible
  74. Send email with Outlook
  75. switching out drop down bars
  76. Validation List
  77. RE: UserForm CheckBox Help
  78. Monthly Calendar Form
  79. How do I trace link errors?
  80. Script to Split up Worksheet into Multiple Sheets based on a Columnof Data
  81. Moving data to another Sheet
  82. Lock individual modules
  83. sub for filling each cell of the grid
  84. How to run an API
  85. Scope of private function
  86. Find an Alphanumeric in a column
  87. Ending Procedure When Condition is Met Anywhere in Procedure
  88. Scope of private function in VBA Module
  89. VBA Macro - ranges & pivot tables
  90. userform control value as constant
  91. Changing the visibility of Textbox/Label Based on Two Checkboxes
  92. 3-character combinations?
  93. Programming the VBA Editor Question
  94. Subtotal method of Range class failed
  95. FSO.MoveFile
  96. Why does this COUNTIF code not work
  97. EXCEL VBA RANGE Question
  98. opening files in excel 2003 when 2007 is installed
  99. Yahoo Quotes Macro stops functioning
  100. filter part info
  101. VBA Import Convert Data Type from Type 1 to Type 2
  102. Linking the Regression equation of a line to a table
  103. Use VBA to reset data validation (=list) value to first value in that list (list is a named range)
  104. VBA to select rows based on selection
  105. VB Form as Menu
  106. email Word DOC along with XL sheet?
  107. running 2003 and 2007 side by side
  108. RE: Storing Rows.Value in a single variable
  109. Print to PDF
  110. How Write for RGB palette?
  111. Display charts on a userform
  112. Set DTPickers Data to Todays Date by Default
  113. XL2002 - I'm having a bad day!
  114. Workbooks.Open not working from a service on Vista
  115. Using a Variable to point out a listbox.
  116. Test If Workbook is Open in Network and On Users Computer
  117. Can't get combobox to display 2 columns.
  118. inserting and naming a tab with vba - any help please thank you
  119. How to control how much gets printed (prevent printing blank rows)
  120. Personal.xls macros will not work in any other sheet
  121. Problem jumping between tabs in a MultiPage
  122. HIDE / UNHIDE sheets based on user answers
  123. Starting a macro by changing autofilter criteria
  124. open save as from list
  125. Count If query within string
  126. CountIf query within text string
  127. CountIf query for words within string
  128. ExecuteReader on empty Excel range hangs
  129. To assign list of number
  130. look up formula
  131. To assign month for a certain range of date
  132. Selactively read text file
  133. Importing CSV - Avoiding conversion to 'dates', but totally different results when controlling manually
  134. excel2003 trial still available?
  135. excel 2007 security
  136. scope of private function called from UserForm fails
  137. Compatibility mode
  138. Hidden worksheet problem
  139. Modify to only work with nominated range instead of entire sheet
  140. require cell completion before saving
  141. FileSearch misbehaving
  142. On Error action inconsistent
  143. Convert numeric field from type 1 to type 2
  144. Print Only Visible Rows Using AutoFilter
  145. Select a range based on Fill Color
  146. List box sort
  147. Combo Box row Source
  148. Opening the VB Editor via VB
  149. getting Cell2.value=empty when their are values in the column
  150. ActiveX error - multiple workbooks appearing in vbproject
  151. Code for insert .jpg file
  152. macro hangs if no data is found
  153. VBA
  154. adding rows to spreadsheet
  155. tool bars
  156. Using a typeconverter in Excel PIA assembly
  157. looking up data and using a combobox user form
  158. Can I use Select Case to do this?
  159. branches /loops
  160. VBA code
  161. Strip first 5 characters from a cell.
  162. Combo box should trigger another combo box
  163. Vista, IE7 and Excel 2000
  164. Event macro does not run a Private sub
  165. How can I open an Excel workbook using a cell containing the path and filename
  166. Change event
  167. chart question
  168. API run program
  169. Run a program
  170. collect data from sheet and put into one row of csv file
  171. Macro email
  172. Teacher Substite
  173. Assigning values to dates
  174. block characters
  175. Use of Split
  176. combo boxes entering data
  177. Trailing zero's
  178. Reading the keyboard in VBA
  179. Moving a form using a button
  180. Why isn't this code to change the font colour working?
  181. preset table
  182. SENDING SERIAL INFORMATION TO A COMPORT
  183. Write data back from form to rows
  184. Write data from form to row in sheet
  185. predisigned table
  186. RE: Workbook change event when tab color changed?
  187. Disappearing Personal.xls
  188. formula works when pasted, but not when typed
  189. Selecting Radio Buttons by Using Macros
  190. Number Format
  191. Add multiple custom lists
  192. Re: automated cursor movement in Excel
  193. RE: automated cursor movement in Excel
  194. Printing Sections of Worksheet Using AutoFilter and ListBox Values
  195. macro to find data and filter it and copy to another worksheet
  196. RE: automated cursor movement in Excel
  197. If Then using "Find" command
  198. Open a text file in a template
  199. Re: Swap trailing minus to leading
  200. VBA Workbooks.Open - Suppress File Currupt Message
  201. comparing a column in two separate spreadsheets
  202. Selecting a group of tabs regardless of name and amount
  203. name of workbook...
  204. Private Sub Workbook_SheetChange
  205. inserting data in a column based on data in another
  206. goto last cell with data
  207. Userform - calendar control
  208. Revision Control
  209. Checkbox for list-totaling
  210. need help
  211. Re: Swap trailing minus to leading
  212. Lock colon in textbox
  213. RE: Swap trailing minus to leading
  214. How do I insert a button in Excel 2007
  215. CalculateUntilAsyncQueriesDone()
  216. Calculate Change
  217. Radio Buttons Created Dynamically
  218. Listing Active Directory groups that have directory access rights
  219. Iterating over a nested Dictionary object
  220. Cant find a Control
  221. BeforeSave macro
  222. How can I email a spreadsheet as plain text using MailEnvelope oranother method...
  223. Get Value of ComboBox in Menu
  224. Opening workbook - get error message : unreadable content, lostvbproject
  225. How to Print varied page numbers in a single print job without col
  226. Reverse axis problem between 2002 & 2003
  227. How to use excel vba to specify the path of a link table in access
  228. Delete Rows on Set Criteria
  229. How to let the formatting follow data during sorting?
  230. Auto fill Sheets
  231. Commenting out
  232. Format VB command
  233. CONCATENATE IF macro or function?
  234. Application.Quit
  235. Excel Macro to auto fill a webpage (Automation Testing)
  236. VB-How can I use a variable in a sheet reference?
  237. Hide all autofilter dropdown arrows
  238. Changing Cell Properties when sheet is protected
  239. Change Zoom Value of Window with ComboBox in Custom Menu Control
  240. Formatting a Cell or Merged Cells
  241. Lock checkbox to cell?
  242. Run VBA hyperlink module on open
  243. macro to lookup value and open tab based on lookup value
  244. goal seek is not accurate
  245. Macro not working on different computer
  246. Running Macros from Excel Saved as html file
  247. How to distribute addin with a reference library checked?
  248. OPtion Button
  249. Office 2007 get ribbon name
  250. Avoiding Invalid Inquery Message
  251. Send CommandBarControl Tag as Parameter to Another Procedure
  252. using a conditional formula from a drop down list and If Statement
  253. move data based on number of characters in a cell
  254. resize range
  255. Option Button Default
  256. Convert Percent Entered as Text in Wksht to Number in VBA
  257. Macro to fire button in external file
  258. Like Operator Error
  259. Fast code in 2003 = agonizingly slow code in 2007
  260. copy conditional formatting across all cells in column
  261. Testing under Office 07 and getting #DIV/0! and #VALUE!
  262. Assigning number value to letters
  263. Macro not running when a change occurs
  264. Get info from first cell in row.
  265. Automation of Keystrokes in Populated Cells.
  266. Suppressing Input Box
  267. How to Protect the sheet, if few of the columns / rows are grouped
  268. Bypass Error Q
  269. script to replace data in csv file
  270. How can I filter a list with VBA?
  271. Save Excel Workbook
  272. How do you specify a sheet when using redirection from a webpage
  273. Pls help on Excel 2007 SDK sample!
  274. How to create sub-folder through specific cell value?
  275. sorting / formula
  276. OptionButton
  277. ISBLANK or NOT
  278. Sort data
  279. Edit datasource in a query
  280. MACROS - Copy row from sheet to sheet.
  281. Shadow property
  282. different formats on one sheet
  283. Continual addition to Cell
  284. VBA open workbook xlxs in 2003 that contains a password
  285. changing parameter in SQL query from Excel
  286. workbook to access
  287. How to program a toggle control button
  288. auto fill
  289. Workbook numbering
  290. protect xls workbook (Vista)
  291. Using an array formula as a hyperlink cell reference
  292. How to hide xls worksheet tabs (Vista)
  293. Mapping Mulitple Elements to The Same Cell
  294. Command buttons and Mac
  295. double click macros
  296. Columns Reference in VBA after inserting a new column
  297. Macro to add row and past values on new worksheet. HLP
  298. Inserting Row after data change
  299. How do I reference a Range of cells in excel using variable names
  300. Identify computer Login ID
  301. Thousand/Decimal seperator
  302. extracting data from a row
  303. Converting code to function
  304. RE: Help needed with modifying this code
  305. code works on some computers, but not on others
  306. Finding a used / filled column
  307. Finding a used / filled column
  308. File Reference
  309. Search Box and 13 sheets
  310. If Then VB
  311. Leave loop
  312. "Sumif " across worksheets?
  313. Selecting data with a specfic value only
  314. Refreshing a SharePoint list in Excel
  315. Wild card in formula
  316. File exists, but code doesn't find it?
  317. Toolbar position
  318. Delete blank rows
  319. Challenging - Can an existing SSIS package be run from Excel usingVBA ?!
  320. Userform cancel problem
  321. variant sheet name to filter
  322. Declaring Command Bar Control
  323. Add a ' in front of all highlighted code in VBA
  324. Len(ZipCode)
  325. Stop Procedure when an Error occurs in another procedure
  326. Internet explorer
  327. Copying data from a pivot table
  328. Case Statements
  329. Populate a multi-dimensional array from Ranges
  330. Changing a value appearing in a pivot table
  331. COM Exception when read Font.FontStyle property of Style object
  332. import data
  333. Uncheck AutoFormat (Pivot Tables)
  334. Referring to last row with data in it
  335. display userform a certain time of day?
  336. Why activex calendar control 12 missing in Excel 2007 SP1?
  337. Using Excel Hyperlinks to refer to a Subroutine rather than a Cell
  338. Problem with Hiding Every Other Column - Still need Help
  339. COPYING ONE ROW TO ANOTHER SHEET AFTER CELL INPUT
  340. Insert row & copy formulas
  341. If Then Else Pivot table
  342. Print?
  343. Return the Line Number where the Error Occured
  344. UDF - How do I include help to the user like the built in function
  345. Transferring date's from a calendar control to a text box on a use
  346. copy then paste to multiple ranges
  347. automatically get worksheet name
  348. Hidden rows reappearinmg when macro deletes rows
  349. Politics
  350. Repeats Help installation
  351. COPY DATA FROM 2 CELLS
  352. Yes No box no working properly
  353. Format input box
  354. vlookup and if function
  355. Excel NUmber format IN VC++
  356. Re: Macro is pulling wrong date format into Email
  357. Date problem
  358. PivotFilters in pivottable
  359. Confirm SaveAs takes place.
  360. Cosine function
  361. Re: Macro problem: Won't send messages
  362. RE: Macro problem: Won't send messages
  363. Escape Key Interrupts Code Execution in Add-In
  364. Transpose problem
  365. Extremely slow sheet copy
  366. Prevent User from Changing Password
  367. worksheet tabs
  368. Checkbox limitations
  369. Create formulas in conditional formatting
  370. What are the common problems when app cannot connect to Excel?
  371. Copy & paste formula down a column
  372. Page setup problems in VBA
  373. Creating custom toolbar
  374. Duplicate Count
  375. Customizing a toolbar icon
  376. Remove empty rows from a range
  377. disable workbook
  378. Most efficient way to loop through a folder and find all the XLS f
  379. Return the Module Location & Sub Procedure Name on Error
  380. Index/match between workbooks problem
  381. Split an Excel file into separate files
  382. Resetting Activex comboboxes to blank
  383. Vlookup
  384. Merging Files using Employe ID Number
  385. Different colors for different sets duplicate cells
  386. Macro or code to insert Shape (Say Smiley face) in XL?
  387. current week, current month, current year
  388. Userforms & worksheets
  389. RE: CheckBox Help
  390. sendmail recipient
  391. Creating a Macro that saves over a protected spreadsheet.
  392. Adding Menus to the Ribbon
  393. Vlookup function
  394. assign a name to a cell using vb
  395. find row to use
  396. Text in a Rectangle Object
  397. Removing unnecessary rows through macro
  398. Minor Axis Numbers
  399. Copy value only
  400. Activate a workbook
  401. If Process Exists then
  402. Problem with Hiding Every Other Column
  403. Checking my lottery numbers
  404. date comparison
  405. Re: Save this web page with value of the active cell in sheet2
  406. Advanced filter in VBA messing with my chart
  407. XL2003: Toggling "Extend" Mode with VBA
  408. Macro code
  409. Automating Web Query import
  410. Golbal Variable Failed
  411. Do Loop or If Then
  412. How many checkboxes can you have?
  413. publish xl list with more than 64 columns to sharepoint
  414. workbook name changes
  415. Re: CheckBox VBA Issue
  416. Change Link in batch of workbooks
  417. RE: CheckBox VBA Issue
  418. How to optimize column deletion in a large table of data
  419. reference tab value on worksheet
  420. Need help with a Formula
  421. Re: CheckBox VBA Issue
  422. Convert number to date
  423. Have code working but need to edit to use on multiple variable len
  424. reference error
  425. Print a Userform To Fit On One Page
  426. Combobox Events to Shrink and Expand Width
  427. How do I write a select case statement for range
  428. Excel formula/macro integrating with font colors?
  429. how delete old querytables?
  430. Textbox Data IsNumeric
  431. Search workbook for cells with white font
  432. Protected Data>Lists - and no VBA?
  433. Range.Delete Shift causing merged cells to unmerge
  434. Formula to Find First Cell in a Row with Values
  435. Any ideas?
  436. Need help with respect to CDialog-based display of dialog in Excelthrough xll
  437. Quick method to sort a list of strings?
  438. Change Colors in Charts
  439. Dsiable right click on objects
  440. First post - How do you build If statement condition dynamically
  441. Programming to create a report from raw data
  442. extract elements of strings
  443. Userform Combo box to mimick Worksheet Cell validation list range.
  444. XL2002 - SelectionChange Question...
  445. Convert number to date
  446. Analyst tool Pack
  447. Setting the Colour of Individual Items within a Legend
  448. RE: Highlighting Rows and Cut to another worksheet
  449. **Urgent help Needed** Run time error 9
  450. Sending SMS from excel
  451. Random Golf Foursome Generation
  452. Random Number Generation
  453. End If
  454. Application trim or rtrim
  455. multiple updates to database
  456. Excel VBA xlcountrycode always returns 1 = US
  457. How do I create my own functions in Microsoft Excell 2003
  458. Referring to BeforeDoubleClick
  459. Creating a variable of type Range
  460. Re: What am I doing wrong with this VBA range?
  461. Re: What am I doing wrong with this VBA range?
  462. Variable not yet created in this context
  463. Using a named range in the Worksheet_Change event
  464. Please improve this simple implementation
  465. Letting user have temporary scrolling authority
  466. Need a date range
  467. Lock from moving cells
  468. range array
  469. TypeName function
  470. Pivot Chart Drill through / Hyperlink to detail report
  471. problem with type mismatch error
  472. Saving a spreadsheet from .Net Web Forms application under Vista
  473. deleting characters from autofiltered cells.
  474. RE: Pivot table - consolidation report
  475. create mdb 2003 format by excel?
  476. Pivot table - consolidation range
  477. Dynamic range
  478. Rolling sum cell variable location input
  479. formula
  480. VBA Program
  481. Any Guru can figure out how to diisplay C++ MFC CDialog-basedcontrol in Excel from Excel command?
  482. Running a Macro
  483. Disable Adobe save file prompt
  484. How to sort a selection of rows?
  485. Using datedif to format cell color
  486. worksheet change based on target range
  487. Re: Checking row for data
  488. Deleting certain cells only
  489. Timed Display Alert
  490. Macro: selecting ranges from list of names
  491. Setting cell format based on format codes
  492. Change criteria for worksheet change code.
  493. calculated member analysis services
  494. Reference relative to activecell
  495. How do you Find with data in hidden columns
  496. About Lisview control
  497. Data from Combo Box
  498. Change Excel hyperlinks from absolute to relative
  499. Creating xla file to clear junk and sort reqd data
  500. PivotTable - multiple sources
  501. Use worksheet as database
  502. How to find difference in cell contents visibaly looking same
  503. Adding hours
  504. Comparing a list of Records
  505. Excel as a Game Design tool
  506. Merging rows
  507. backspace key
  508. Microsoft Office Spell Checker
  509. Error help
  510. Custom Sort Routine
  511. StructureMacro.xla PASSWORD?
  512. Autosave
  513. WorksheetFunction.EOMonth
  514. Is there a way?
  515. ActiveX component can't create object or return reference to thisobject (Error 429)
  516. Insert a File, not a Comment, to a Cell
  517. Range and Array Problem
  518. macro with drop doown box to to find name in 40 work books
  519. Copy names to another sheet
  520. Change links for batch of workbooks
  521. Is there something wrong with this?
  522. error trap/handler placement
  523. LEFT and MID
  524. VB script
  525. I need to look for a number and return the column heading.
  526. Input box
  527. Find/Replace Specific Range Woes...
  528. Line chart by day of week
  529. Macro doesn't loop through sheets of books in specific folder
  530. Get the name of current pivot field
  531. finding date in range of dates
  532. Format font of text in a message box
  533. "Autofilter: Show All" causing an error
  534. reading Comments in a closed file
  535. Moving to other sheet basis on condition
  536. Macro
  537. Excel VB Editor output stack and/or intermediate window to file
  538. Doing search in worksheet
  539. Selection.EntireRow - Filtered
  540. Prevent Escape on Nonmodal Userform with Progressbar
  541. Macro to run when cell click
  542. false VBA cues
  543. sheets(N*).printout problem
  544. trouble with onchange event
  545. On save excel jumps to another worksheet. How to fix VBA code?
  546. Log specific changes
  547. Function to return two values
  548. Error 400 when trying to enter reference in excel vba
  549. Need help calculating time in VBA
  550. Determine if a workboo has been saved
  551. VBA for a complex If...Then Loop
  552. Delete or adjust auto Pagebreaks
  553. paste special macro
  554. Finding a used / filled rows
  555. Use reserved word to specify current worksheet name
  556. Code for Deleting all but first row
  557. Use reserved word to specify current worksheet name
  558. cell formatting and format conversion
  559. Looping Macro to scrap multiple pages in Mainframe
  560. [VBA Excel 2003] How to do it in VBA?
  561. sheet name change
  562. Macro to run when cell changes
  563. Macros - Automatically highlighting rows
  564. Toggle Event - 2 Commands on 1 Button
  565. Copy and Paste - Workbook to Workbook
  566. Simulate click of AutoSum doesn't work in 2007
  567. paste special
  568. Printing Problem
  569. "File Already Exists" MsgBox when opening Workbooks
  570. type mismatch
  571. paste value
  572. Run/call a macro when value in cell A5 changes
  573. how can I create wordart using vba/macros
  574. Graphs not shwoing when data is grouped
  575. RE: Bug or feature?
  576. Exclude date
  577. Dates changing when opening a CSV
  578. I don't like variants but...
  579. Returning to same column on current line?
  580. Calendar Function
  581. Excelsheet as html
  582. Replacing \r\n #13#10 to <br> in a string?
  583. Creating and filling a word document from excel VBA
  584. copy worksheet to array
  585. Option buttons in two levels groups
  586. Select one checkbox to Add a Purchase Order (PO) Number
  587. Data Validation List
  588. Row Count Error
  589. Excel 11 Type library for VB.NET?
  590. Copy / Link Textboxes between Files
  591. Help with IF... Then... Else statement
  592. VLOOKUP and INNER JOIN ?
  593. Print of DataGridView on worksheet is always blank
  594. Worksheet_Change(ByVal Target As Range) - Big Problems
  595. varinat variables problem
  596. Macro doesn't refresh
  597. Required Data in cell
  598. Test for range value
  599. Save Cell address to activate it later in the procedure
  600. delete rows if data is either
  601. Automation Error with BuiltinDocumentProperties
  602. Pause a Macro
  603. Re-word text
  604. Re: Tanspose Error
  605. Convert text to all caps
  606. Installing Addin Causes Serious Error in Excel 2002
  607. Macro to loop through a list of items and print for each item
  608. SQL Date as Filter
  609. Copy worksheet from one workbook to another
  610. Macro Find value & insert
  611. Regular Expression Conditionals (?(if)then|else) in VBA?
  612. Formula to Find Max in a Row and Return Column Title
  613. Find and Replace
  614. Select column in VB based on variable
  615. Mulitple updates in database
  616. Conditionally formatted ranges
  617. code snippets
  618. Add 10 minutes to a Date
  619. Trouble using the Cells() function
  620. help with error
  621. Add names to blocks
  622. problem to add reference in vb.net 2003
  623. I am using OWC11 in my application. which is merging last cell
  624. Not Sequencing
  625. FormatCondition.Type Property in Excel 2003 vs Excel 2007
  626. CopyFromRecordset with Filtered ADO recordset
  627. Test for value then format!
  628. Run time error - selecting range of cells.
  629. Macro Modification help
  630. Help with function
  631. data validation list
  632. RoundUp not working in VBA
  633. Paste Method - Link: "" > 0
  634. macro to eliminate format issues
  635. Execution slow around PageBreak Code
  636. Named ranges and pasting formulas with named references
  637. Selecting the Current Column ?
  638. Getting week number?
  639. Define a Range with Assembled String
  640. hyperlink on part of a text contained in a cell
  641. Time stamp on cell entries
  642. Dynamic file location macro
  643. Command button continues to be visible!
  644. adding formula to cell
  645. Change Excel secuirty level
  646. Finding empty rows
  647. Creating text lists
  648. VBA Form with Calendar Control - Excel 2002 to 2003 compatibility
  649. User Defined Function not allowed in Excel Query of Access DB?
  650. Missing Save As Add-in option
  651. Search for multiple words
  652. Finding empty rows
  653. Pivot Tables: Alternative to PivotSelect?
  654. Subtracting & counting rows
  655. Create XML 'baseName' or 'nodeName'
  656. Worksheets Macro
  657. Excel Addin File Size
  658. Recognizing Ctl or shift key in VBA
  659. Uncheck child nodes if parent node is unchecked in treeview
  660. comparing lists
  661. RE: How to make a VLOOK UP OR HLOOK UP formula
  662. Determining dates based on colored cells.
  663. using formuals
  664. Changing up to 2 of 3 vals and the 3rd val is automatically Calcul
  665. hot get a cell value in varable
  666. How to copy a range of cells from one sheet to another
  667. Any luck using CopyModule?
  668. IF Statement
  669. returning a row number
  670. Bar Graph in Excel 2007
  671. Macro Security
  672. Macros
  673. Function to Check if Cell is Highlighted for Change in Shared Work
  674. How do I set auto-sort for a column in a worksheet?
  675. Conditional formatting limit to 3 Excel 2003
  676. Re: Should an automated version of Excel close?
  677. check format
  678. Show checkbox checked on open
  679. ClickMe
  680. Application.VLookup
  681. Excel 2007 and Named Ranges
  682. Ribbon Button not Working with my Referenced Workbook
  683. VLOOKUP FUNCTION
  684. Excel 97
  685. Copy Formula
  686. sum in range meeting criteria
  687. Selective Ribbon miminise
  688. Can VB execute VBA code?
  689. lookup returning #N/A
  690. Excel 2007 Adding Template Sheets and Invalid Name Error (#NAME?)
  691. Disable right click with a difference
  692. My Workbook is always hidden when I open it?
  693. lookup two columns
  694. Macro to print plus list options?
  695. Disable selective events
  696. Lookup not working
  697. lookup returns zero or the wrong number
  698. Error in loading DLL
  699. Conditional Format Currency
  700. Unable to populate a range with a formula
  701. Excel vs Lotus [pop-up screen with directories]
  702. Macro question
  703. To change command button caption
  704. ignoring blanks cells while importing data
  705. How to Select Last Row of Sheet
  706. Re: Excel Select All Visible Merged cell then Spread Cell Data
  707. Hide VBProject while copying Forms & Modules to another workbook
  708. If then else if problem for DA
  709. formatting backcolor on Forms Control Button
  710. fill a cell with this..
  711. Multiple (ByVal Target As Range) Cancel each other out, as written
  712. Loging users who open a file
  713. Microsoft Office Web Component issue
  714. How do I do "Range(A1).text" in a XL forumla?
  715. Problems importing data from a *.dat file
  716. can I use an array formula to query a source data table?
  717. Validation for Password protection?
  718. Paste Special Macro Assistance needed
  719. circular reference error for simple IF statement
  720. Sum + countcolor
  721. Custom menu created in an xla macro
  722. I just installed Office 2007 and an Ad-In I have is not working.
  723. Emailing Files
  724. Copy Certain Values
  725. Match function / returning closest value in VBA
  726. Call Procedure with On Error Statement
  727. Embed Mre Func
  728. choose a range to copy paste based on data in the cells
  729. Copy Textbox data to Textbox in Other File
  730. Problem with selecting a column in a macro
  731. Decreasing Validation List - Excel 2003
  732. Using LIKE in case statement
  733. How to accomplish?
  734. Combo box does not respect font size
  735. Usage of Range for an UDF
  736. Listbox in form
  737. Connect to iSeries
  738. Email Voting Buttons
  739. Range when selected goes to lowercase
  740. Keep cell in sight as scrolling through worksheet
  741. PASTE CLIPBOARD TO AN IMAGE FILE (.BMP,.GIF.. ect...) for excel 20
  742. Entering data
  743. Setting Excel cell format
  744. Remove DateTimestamp from String
  745. Delete Row when date in activecell doesn't meet the requierments
  746. lookup vba
  747. Refedit Paste
  748. VBA to sort list automatically in alphabetical order
  749. Macro: Finding Text Within Text
  750. Read/Write variables to XML with VBA