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. Naming Workbook
  2. Copy Digital Certificate between workbooks
  3. Split Cells?
  4. VLOOKUP ERROR HOW DO YOU MAKE IT BLANK
  5. WorksheetFunction
  6. Textboxes not Calculating properly
  7. Hiding Rows from VBA
  8. Reading values into an array of User Defined Types
  9. Input Box only if a cell is blank
  10. Disregard conditional formatting if cell is blank
  11. o -t does anyone see and speed increase after office 2007 sp1 is installed?
  12. Copy certain rows from one worksheet to another
  13. Multi Line Transpose Excel VBA code
  14. Macros not found and macro toolbars
  15. Subtotal
  16. Can't copy
  17. How can I make an executable program from excel?
  18. Sampling in excel
  19. Seems easy
  20. Problem with Deletion
  21. Condense ISERROR(VLOOKUP(MATCH())) to VBA function.
  22. reset my format cell properties
  23. Please help with Count
  24. .find not finding corect value
  25. Install Analysis ToolPak
  26. How to pass selected cells into a delimited text string?
  27. Refer to Public Variable from Another Workbook
  28. With .Controls.Add(msoControlPopup)
  29. Set Named Range with Last Row
  30. Find blank cells and clear adjacent range
  31. ID3v2 MP3 Tag Reading Class
  32. Changing chart data ranges from VBA code
  33. Deleting Columns - Causes Code Changes
  34. Which is faster, copying range to another set of ranges or copying tomemory?
  35. Programming to the VBE - Help
  36. Prompt box when emailing via VBA
  37. Macro Help with Variable
  38. Excel & Word Password Protection
  39. Run "VB code" which it is in a sheet
  40. Min Function on 2D Array
  41. problems recording macro_value or formula?
  42. Referencing WSH in Excel (2002)
  43. Automation error from RTD
  44. VBA Code Optimization
  45. Application dies when you use mouse wheel in listbox
  46. bar graph from pivot table with two data fields
  47. Form scrolling on its own
  48. findnext error in loop
  49. Importing DBF with large number of fields
  50. Display the current value of an Options setting
  51. Excel 2007 Buttons
  52. Macro programing in excell
  53. Check box problem Excel 2003
  54. Syntax Error ?. Execution does not enter the Select Case
  55. New to userforms - can you help with this code?
  56. Unique ID on different sheets
  57. Highlight cells containing words of a given type
  58. Macro for numbers duplication
  59. copying if value in cell from range of cells
  60. Very Slow
  61. Sending Email - different reply-to address
  62. vba code for .zip conversion
  63. How to get the number of Line/Column used in Excel sheet ?
  64. referring to the button that triggered the macro
  65. Sorting a Column in ascending order in excel vba
  66. Selection.* not work
  67. VLOOKUP Error N/A
  68. Excel's Refreshable Web Query & Javascript...
  69. Code to Slooooooow
  70. RTD Server deployment
  71. public sub worksheet_change ever possible?
  72. How to make Excel More Interactive and Dynamic
  73. Delete Rows Between Border Lines
  74. Create a Macro to update File and Worksheet References in Formulas
  75. VBA Button Size Larger
  76. Setting a cell format based on a function operation
  77. PageSetup Performance Question
  78. Finding row number with .find()
  79. Copy Cells
  80. Incremental balance and progress bar
  81. carrage return
  82. Array function
  83. xls file becomes larger
  84. Query multiple database platforms from Excel
  85. Determine ActiveControl on a multipage (tab) control
  86. Create a Formula
  87. setNumberFormat in custom excel function
  88. New to VBA - What does this code mean?
  89. Modifying J Walkenbach's data entry userform
  90. Making Application.CommandBars.ExecuteMso method work in 2007
  91. how to launch VBA in 2007
  92. Adding UserForm Data to Worksheet
  93. yet another Obj var not set
  94. Pass control to a function/subroutine
  95. format numeric data in pivot table
  96. Macro to validate is cell is not empty and copy the line
  97. MEET NEW ADULTS! 5000+ NEW PROFILES PER WEEK! FREE!
  98. Populating a portrait orientated 'form' from Excel rows
  99. New Forum For People Who Love To Discuss On Technical Topics
  100. If or Case help - Which to use
  101. Multi Page Scroll Bar
  102. Pivot filter Help
  103. Referencing Worksheets from Cell Values
  104. PDF help!
  105. Problem with deleting rows in a List object with center alignment
  106. Numeric Format
  107. Changing formula to Upper case
  108. ERROR problem with Formula
  109. transfer range of cells from excel to Acess using vba
  110. Help with FindNext error
  111. Please Help Splitting data
  112. Sort and Match Cells
  113. Storing variables in a macro and using those variables to performcalculations.
  114. fill external data in specific cells of various sheet
  115. fill external data in specific cells of various sheet
  116. unlocking merge cells
  117. Accessing a C# dll from vba
  118. VB code needed
  119. Combining text in a cell with a named cell value
  120. JSP's form-submit & Excel's Web Query....
  121. Access wab page with excel VBA
  122. get data from web
  123. Freezing Top and Bottom Rows
  124. Codename passing
  125. Create command button with VBA
  126. Help !, problem updating data through userform !
  127. Worksheet Codenames Passing to Function
  128. Help - Routine to screencapture and save image?
  129. Getting list of named ranges
  130. Macro to create seperate sheets
  131. Multiline Messagebox in VBA
  132. tab to select combo box instead of field?
  133. Extracting proper range address from multiple cell selections in V
  134. Help with messy formula
  135. On going formula
  136. Odd macro performance. Explanation?
  137. Find and Replace
  138. DIVORCE FORMS
  139. focusing mouse pointer to the specific button in a userform
  140. How do I show 2007 custom Button Images with transparent backgroun
  141. Matching a number from another sheet and copying a related value
  142. Repost: Is Workbook already open?
  143. MultiPage Scroll Bar
  144. HELP: How to call UDF defined in another workbook?
  145. Any way to word search in a Text Box?
  146. Is there a way for a idMso button to display a custom image?
  147. Easy way to test range as single cell
  148. Is there an Excel Viewer ONLY = Excel WITHOUT menues+toolbars around ?
  149. Finding row
  150. Combobox.additem (No Repeats)
  151. Using a TextBox in a Userform
  152. Is there an Excel Viewer ONLY = Excel WITHOUT menues+toolbars around ?
  153. VBA Programming Enviornment & Intellipoint
  154. Help with pivot charts and vb.net
  155. Loading an Array
  156. How do I make all rows 7,...23 exactly 8 pixels higher ?
  157. complicated change to formula (conintuous)
  158. Use VB array as as argument for worksheet function
  159. subtotal
  160. VB Right
  161. what object var should I use for the following code
  162. HELP: How to restore Immediate Window to original state?
  163. custom view to display specific toolbars
  164. Excel RTD,SQL Server and persisting range
  165. COLOR INDEX UPDATING & FOR CONDITIONAL FORMATTING!
  166. Continue to have issue with array in Subtotals automation
  167. Replace value in cell with value from a table/array?
  168. Specific Macros
  169. An error occurred while loading image with relationship ID ...
  170. Printing envelopes based on Excel table contents
  171. Excel Converter Using C++
  172. Workbook Sharing
  173. Code for combining text and deleting row for c10 thru entire range
  174. Out of Context
  175. Userform to show and update data problem
  176. Help with a form
  177. Excel: use macro to do 'step function'?
  178. Finding the difference...
  179. Excel 2003 - Macro for Deleting Rows
  180. Editing MS Project File from Excel VBA
  181. How to know if Excel is still attached?
  182. Try Again... copy a row if another worksheet cell <>null
  183. Do function on worksheet open
  184. Userform Question
  185. Userform and Worksheets
  186. find string in web page
  187. Correct me if I'm wrong but...
  188. How to delete duplicate record
  189. Convert text to numbers
  190. Search 1 worksheet then another for data in large workbook
  191. Can I format cell to autonumber everytime I enter spreadsheet?
  192. Tranferring text from Word to Excel
  193. Setting Column Widths
  194. Efficient paste from web page; also bring Excel to front
  195. Convert to Number
  196. sql stmt issue
  197. Error Trapping Issue? WorksheetFuntion.Search
  198. This used to work...
  199. Unwanted Sub Exit, Ws in page break preview View
  200. Enable To Run Macros
  201. Pivottable filter
  202. Excel 2003 - Macro for deleting rows
  203. Validation List
  204. Open New Workbook / Save and Close Current Workbook
  205. vba/macro recognizing other worksheets open
  206. Excel VBA Bug
  207. Copy formula if other worksheet cell <> null
  208. Find value, perform function, search for next value
  209. If problem...
  210. How to copy VBA array into range of cells?
  211. Question for Userform Excel Wrksht vs Access DB
  212. Speed test results if interested
  213. Only matach two excel spread sheet
  214. Ambiguous Name detected?
  215. See the accepted papers, keynote lecture, plenary lectures, thecontents of the Book of the Proceedings (i.e. accepted papers). WSEASPost-Conference Report for the Conferences MACMESE '07 and DNCOCO '07 (124images)
  216. Automatically close file
  217. Range("A1").Interior.ColorIndex=xyz does not work
  218. ReDim Preserve on 2D Array not working
  219. macro toolbar button problem
  220. Error handling on Workbooks.Open
  221. Array help
  222. VBA Commands
  223. Sheets.copy problem
  224. How to list items meeting conditions?
  225. UDF with user help
  226. Copy from one work to another
  227. Two decimals
  228. selecting range over multiple sheets
  229. Hide/Unhide Sheet using VB
  230. HOW TO IMPROVE PERFORMANCE FOR VB
  231. Linking Forms across seperate addins
  232. Delete non weekdays
  233. Is there a faster way
  234. Send multiple cell values to multiple cells
  235. NumFormat problems when exchanging dot to comma
  236. sub-range
  237. Function or sub (add-in)
  238. Can multiple selection available to copy to new Workbooks ?
  239. Last saved by
  240. Range Prompt
  241. UNDO
  242. Double Click on cell to goto - Help needed please
  243. setting label properties
  244. How to find out if an excel spreadsheet is already open
  245. Aggregation on Column Value (groub by logic)
  246. Copy a part of worksheet with active x elements
  247. Can I draw an arrow at form using word macro?
  248. Programming Macro - Sheet Specific
  249. How to prevent change Numeric value to date format ?
  250. How to control recalculation in VBA?
  251. Custom Menu
  252. Protect Selected Sheets
  253. Match excel spread sheet with macro
  254. What is the "VSTO way" for loading data into variables at run time
  255. Filter Macro that can work for any column/active cell
  256. Microsoft Office 2007 Compatibility Pack troubles
  257. Sort Column
  258. Populating dates
  259. Lookup - copy.paste values macro?
  260. A Macro to change various cells with a condition
  261. macro to hide # of columns based on value
  262. Find doesn't find...what the !@#$
  263. Convert column data to trim all characters and leave the last 6
  264. Add Column Names to VBA script
  265. Make sense of Arrays after Transpose
  266. adding a row with a looping macro
  267. how to recycle through cells in a selected range
  268. Copy Contents From Worksheet to Another Worksheet
  269. RefreshAll pivot tables but query
  270. Conditional Formatting
  271. Input box password
  272. Sub add-ain
  273. automatically hiding a cell when value changes
  274. summing by color
  275. Check if cell content changed
  276. fomula comes to next row on click
  277. when exiting combobox, this code moves the selected cell down two rows instead of one
  278. Create Output CSV File Worksheet
  279. Multithreading, of a sort. Or is it interrupts?
  280. Help with formula
  281. Crashing Bug in Solver.XLAM for Excel 2007???
  282. Customize Addin
  283. Code execution has been interrupted
  284. Need some VBA help
  285. Loose formating of linked cells
  286. Help with "Doubleclick event"
  287. Reference Material for setting values for Form Controls using VBA
  288. ActiveWorksheet vs Worksheets.Item(1)
  289. Workbook name
  290. Find text string within a named range
  291. Display text and hidden value into a cell
  292. To transfer data to SQL Server 2005
  293. how to call statistic funtions from vba (Histogramm)
  294. VBA application not saving properly
  295. textbox problem
  296. Help with code please
  297. Help with VBA loop, lookup and calculate problem
  298. Hyperlinks in Pivot tables
  299. Atoumate the counting of Net Finance
  300. Net Financing
  301. Open File, pause macro until file is selected
  302. Macro unexpectedly jumps to other macros and functions Options
  303. flash cell colours from white to red and back again
  304. Cannot set the row property
  305. help me excel coding
  306. STOP CHINA OLYMPIC!!!!!!!!!!!!!!!!!!
  307. Passing a value from one userform to another (multiple) form
  308. Entering a Sum Formula in VBA with variables
  309. How to get Properties Generate tab Location value
  310. Add-in
  311. Complie error
  312. How to search for ceratin word in a web site using excel macro
  313. vanishing buttons
  314. Email - Outmail - From
  315. Problem in using Chart.ApplyCustomType for Excel 2007
  316. Excel macro SHortcut Keys Disappeared and Defaults re appeared
  317. closing excel file through code
  318. Auto sort
  319. Macro to record history of Excel files
  320. import excel file to access but only new data
  321. Create SumIf function for date parameters
  322. commands have been grayed out
  323. pivot table using vba problem
  324. From variable to excel constant
  325. Finding xla
  326. How to generate random number sets
  327. How can I save a macro to an excel 2007 woorkbook
  328. how to get the value of a text box in a sub or function
  329. Data Validation Macro
  330. MenuMaker
  331. Can Excel modify data in a Query?
  332. PivotTable from a ADODB.Recordset ?
  333. Better way to find matches across multiple cells?
  334. Best way to find repeated matches?
  335. Code for dealing with #REF
  336. Date on UserForm
  337. Cell Reference with Hyperlinks
  338. Concatenate unique items
  339. Statusbar
  340. Find File
  341. listing a column in reverse order
  342. Using ADO with Pivot Tables
  343. Convert timespan d:hh:mm:ss to number
  344. filename as variable
  345. Locating end of used range- not returning expected value
  346. Macro Clear Cell Contents
  347. Getting names of files in subdirectories
  348. Insert comment in a cell Excel
  349. Dynamically declare and populate variables
  350. UserName Property
  351. Substitute worksheet function considered harmful: can createunopenable workbooks with cell values greater than 32k
  352. Random match name to date
  353. Macro Autofill Question
  354. Save only a range from an excel file to another
  355. macro to copy to another workbook
  356. converting numbers
  357. phantom 'Task Pane' problem
  358. SQL Syntax Error in Query
  359. Reference workbook name to cell reference
  360. linking OLAP queries
  361. Create New .txt file
  362. Number Format Question
  363. Textbox1.Value Question
  364. DV Issues with IF statements. Call function instead?
  365. Error 1004
  366. Find last row with data in set range
  367. Data entry commitment without hitting Enter key
  368. ACCESSING closed files
  369. LAST value of loop to be a variable
  370. merge xps documents
  371. Copy embedded chart with updated data request
  372. Dynamic selection of a range
  373. Delet certain row in a sheets in workbook
  374. command bar
  375. Userform Multipage
  376. Send data from Excel in email from specific email address
  377. Break Mode
  378. Excel to Powerpoint - copy/paste text box
  379. How to Capture log of Activities on each worksheet of a Workbook
  380. MOVING WITH A RANGE-TAB
  381. RANGE SELECTION
  382. POSITION OF ErrorHandler?
  383. Putting a variable value into the Clipboard
  384. Ranking and Movement
  385. Ideas for a menu
  386. Sheets.Copy breaking the links
  387. Using a variable as an argument
  388. adding a page number in a cell
  389. Two Question
  390. How to write a macro to jump from 1 input field to the next?
  391. copy method problem
  392. Adding a named formula in VBA
  393. macro renaming tab
  394. Move around excel sheet
  395. Wait for refresh/calc before proceeding
  396. Tab to and from combobox
  397. Print with staple
  398. How will we create UDF's on 64 bit OS after support for VBA is dro
  399. Inporting data: can I tell the query which cell to place the data
  400. excel sheet opening as web page
  401. "Unable to get the Hlookup property" VBA
  402. Close all open modules
  403. naming a tab based on a cells value
  404. Failed Comparison... why?
  405. Counting from one column by specific identifier
  406. Checking if worksheet exsits
  407. Using Countif on Array
  408. Freeze Sheet Tab
  409. Counting a subset
  410. Hiding Rows Based on Cell Value
  411. looking for a Excel consultant
  412. Spreadsheet control in Office 2007
  413. i think there is a problem with my loop
  414. empty
  415. Code Execution Has Been Interrupted
  416. Splitting variables with a comma error with slashes
  417. how do I create a macro that will activate other macros?
  418. help with code
  419. Mold Manufacturer
  420. Additional controls in Office 2007
  421. copy data from worksheet in folder a to worksheet in folder b
  422. SQL on Column with Text and Numbers
  423. fx button shows ... for a UDF
  424. VB code to copy and past a row or set of cells...
  425. Retrieving List of Macros in Workbook
  426. SolverSolve function exits abnormally
  427. Print Outline/Group Structure
  428. Accessing individual items in an array returned by a function
  429. How to Define and Use a Dynamic Array
  430. Excel error connecting to sqlserver using ADODB, but can thru Datamenu
  431. macro to copy entire workbook to another.
  432. Writing tabular data from excel to sql server using VBA
  433. Array problem
  434. Using Worksheet_change module in protected workbook.
  435. Repeated calls to Solver.xla causing Excel problems
  436. vlookup
  437. Lookup function, but then a bit complicater
  438. Button to automatically change linked cells
  439. Further to my last thread - Check for worksheet in a closed file
  440. Help with code please
  441. Add-in - add a custom function to a custom group.
  442. Setup your VS debugging environment for a COM add-in (Excel 2003)
  443. Can't see macros in .xla file
  444. office 3 calender
  445. runtime error 9
  446. Calling MVPs and Microsoft Techs and Excel experts
  447. programmatic conversion of XLSX into XLS
  448. Printing
  449. MS EXCEL - To supress warning messages created by Anlysis ToolPak
  450. macro for copying between Workbooks
  451. Disable Window Minimize/Maximise/Resize
  452. How to parse UDF arguments? (separators are localized)
  453. project protecting
  454. Insert Blank row at change in a given Column
  455. Subtotal with more than one Function
  456. SENDKEYS COMMAND
  457. coping a entire tab to a new tab
  458. Merge muliple pdf's
  459. Problem loading DLL: Error
  460. Copy data onto new workbook and move onto next lot of data
  461. Need to find and replace text inside a macro using vba
  462. Syntax again for DA
  463. Size comment box
  464. Wanna earn Money very easy ??
  465. Code for Subtotals
  466. Userform Initialize
  467. email user form
  468. Identify number of numeric sets in a long string of numbers
  469. Macro for "Next" Button on User Form?
  470. Help pLease... Creating a Usage Log
  471. Next and Back Buttons
  472. An auto macro to change color of the active cell
  473. Form Text Box
  474. Searching and Then Copy Cell to word
  475. If/Then Macro For Each Visible Worksheet
  476. Named ranges in the VBE
  477. Conditonal listbox
  478. Loop in a Macro
  479. set range error in add sheet
  480. Changing filename as variable
  481. MSGBOX UPON ERROR
  482. Automation Add In, functions parameters as Range
  483. Help with a loop
  484. use the range value from a cell to update the cell with data
  485. How to Synchronize page fields for two or more than 2 pivot tables?
  486. user Forms Question
  487. conditional list boxes
  488. Built-in Commandbar, can't find the right one
  489. Searching only Column A
  490. downloading excel file for open causes "file is locked for editing
  491. Custom commandbar (1 works, 1 doesn't)
  492. VB6 and Excel question
  493. Excel Formula
  494. Ensure macros enabled - C. Pearson's sheet visibility method
  495. Unwanted Hyperlink
  496. Worksheet copy to another workbook
  497. Find an exact word in a cell with many words
  498. Problem with varaible dates in SQL query
  499. Multiple worksheet named ranges to PDF
  500. slow .Clear in 2007
  501. SetLinkOnData only fires once?
  502. Add additional logic to my code
  503. Autofill until last cell in a row
  504. Date reformat and export
  505. Controls on Chart Forget assigned Macros.
  506. multipage
  507. Open second spreadsheet with certain permissions via onopen
  508. Check for worksheet in closed workbook
  509. Automatic Cell Locking
  510. Formatting Problem
  511. Doing nothing when pressing Cancel on InputBox
  512. XL 2003 / IE 6.00.2900 - Macro menu unavailable
  513. Import data from external XLS tio dropdown-list.
  514. Date search and date extract
  515. Double clicking on a pivot table
  516. How could I deal with the concurrency in my project ?
  517. Going To The Last Empty Row and Pasting Special (Values).
  518. How can I calculate the minimum value of a VBA array?
  519. Print User Forms as one document
  520. AUTOMATICALLY ADD NEW SHEET VALUES IN CONSOLDATED SHEET
  521. CAN files be accessed with a macro when closed
  522. MACRO in a Loop Problem
  523. Question on User Forms and Command Buttons
  524. Listbox update on command
  525. How do a sort a multidimensional array(1000,2) in Excel-VBA?
  526. Multiple Excel File Import
  527. Function cannot obtain cell values
  528. Help with FOR LOOP and and Advance Filter
  529. re : Save As
  530. How to Evaluate Values in the filter used range
  531. PivotTable with Server Page Field Leaves MS Query Application WindowOpen After Refresh.
  532. Need help with FOR NEXT LOOP
  533. Slow Opening Excel Workbook from Access
  534. File Properties
  535. Add ins for outlook object 11.0
  536. More than one User Forms
  537. Value Returned in Message Box Q
  538. macro
  539. switch the "scroll" led with vba
  540. defined names in conditional-formatting don't work
  541. Export VBA Modules
  542. Change CellA.
  543. summary of values for a period of time
  544. Pop up Box that displays files sheets Q
  545. looping
  546. Range to VLOOKUP as a Variable (range in another file)
  547. Referencing worksheet
  548. VBE windows, zoom, ActiveX controls: Just one hit on memory, or many?
  549. Excel XLL versus DLL
  550. How to propagate xlErrNull back to Excel formula?
  551. Update Sheet code using VBA - question for Chip Pearson
  552. User Form and database
  553. Gantt Chart with VBA
  554. Plot Ranges
  555. Run-time error '1004'
  556. Color of Buttons
  557. Position of Userform in other scrrens/monitor problem
  558. Relative adress in recored macro
  559. Please Help in this Compound Interest UDF
  560. Counting Unique Values
  561. Make the charecters in a cell to equal a certain quanity
  562. Hide Macro from View Q
  563. Deleting Part of a cell value
  564. filesystemobject
  565. How to access functions in .xll file using VBA?
  566. pLeAsE hELp! format function in excel visual basic editor
  567. event integration
  568. Have A1 in Top left corner of screen Q
  569. Code to Change Sheet Name
  570. Copy and paste only values
  571. How to calculate 6 working days between two dates
  572. Looping
  573. Gotta be some more Efficient code
  574. Link input cells on user form to macro
  575. Merge Macro Excel 2007
  576. Looking for consultant to do some Excel macro programming
  577. Replace all non-operators from string
  578. Find and Replace in a Macro
  579. manual/auto calculation toggle button
  580. activate/deactivate the scroll button by vba
  581. Personal.xls file with multiple Excel versions
  582. Suppressing ODBC Login Prompt
  583. Easy question, I think
  584. VB protect sheet but allow certain options
  585. Undo a scroll action
  586. VB Import/Export CSV
  587. Newbie to VSTO basic question about what to buy
  588. Conditional Formatting using Dates but excluding weekends
  589. Fomatting a row based on style of a cell within the same row
  590. percentages
  591. Command Button disappears
  592. Macro to select a row that has max value and paste it in an empty row
  593. how to check if more than one excel file is open?
  594. Macros
  595. HELP!! VBA Nested IF Function
  596. Invalid function importing data query from Access
  597. Public Const & RowSource
  598. Deleting row from entry in listbox on a form error
  599. Weekends for timesheet
  600. Find column and then insert column
  601. traveling days
  602. (reposting) Memory problem: Out of Memory and cannot save
  603. Thanks!
  604. Counting number of columns in CSV/Text file
  605. Opening another workbook
  606. excel days counting formula
  607. Changing file/open and file/saveas directories
  608. Delete Blank Rows - specify column via dialog
  609. Start my application when a .txt is added to or updated in aparticular directory
  610. max of a range every set amount
  611. VB Excel Code returning my error message twice instead of once....
  612. Conditional formatting based on dates
  613. I want to create a macro that opens the Find Box on the sheet
  614. Need to update Multiple PivotTables from same sorce
  615. PivotTableWizard Using Csharp
  616. SoD table - Excel for Roles conflicts
  617. Error with MarcoOptions method, add a new category
  618. VBA help
  619. Loop Within a Loop Problem
  620. Excellent website for Microsoft professionals
  621. Excel 2007: OpenDatabase fails to connect to a SQL database
  622. macro that searches by first and last and enters id number
  623. Autofilter
  624. Disable Setup button on Print Preview screen
  625. Input Box Help
  626. Creating a Formula Refer a New Sheet that is created Q
  627. How to read from txt file from bottom to top?
  628. buy cheap lotro gold powerleveling
  629. Creating a calendar
  630. Password security problem: view of the hiden worksheet in xlsm and xlsx file !?
  631. Database Search Function
  632. Compatibility issue?
  633. Excel crashes after running macro !!! Urgent
  634. delete group not object
  635. EAN-13 checksum
  636. Refer named range in a copied sheet
  637. Vlookup property missing
  638. Temporary Internet Files
  639. Concvert Full Width Katakana characters into Half Width Katakana C
  640. Excel and Flash
  641. Pure .NET Office add-in vs VSTO solutions
  642. Textbox Writing
  643. Pause for data entry
  644. Should be easy, but not working out
  645. multiple cells copy & paste
  646. Memory problem: Out of Memory and cannot save
  647. Memory problem: Am I hitting the 64K segment boundary?
  648. addins dont load when launched by access
  649. Memory problem: Userforms and ActiveX controls: How many is too many?
  650. Memory problem: Need to set object variables for userforms? Forranges?
  651. Autofilter
  652. A Whole Slew of CheckBoxes
  653. Excel Formula Dates
  654. Mirror Workbook
  655. Form Data Input
  656. Number of pages
  657. User Form Data Input
  658. Count Number of Records and Number of Fields in CSV File
  659. Track Inserted Rows/Columns in two spreadsheets
  660. Bypass "Save PDF File As" Prompt via VBA in Excel
  661. Loop Until Desired Columns left
  662. Searching
  663. MS Query Application Window Remains Open After Refreshing PivotTable
  664. On Error GoTo Doesn't Work
  665. Filter
  666. if Error, Pause or Loop
  667. RUNTIME 1004
  668. Using a 2 dimensional string array variable like a lookup function
  669. custom excel function returns array, showing #VALUE in cells
  670. Validating with Like
  671. I am desperate for help on Excel export to Quick books
  672. Saving/Refreshing with Ontime
  673. Display alert problem
  674. Importing Visual Studio form into VBA?
  675. Find 0s on Sheet and Replace with Formula
  676. Repeating a loop
  677. Find Number Then Do Until Loop Question
  678. Test if moving off a cell without choosing a value
  679. Copying sheet tab "x" number of times
  680. call sub inside other sub
  681. Help with Data Validation.
  682. Add User Name to Comment
  683. Find End in Undefined Range > Select Range > Trim
  684. loop for-next with variable end
  685. Re: Select and copy certain tabs using macro
  686. Newbie attempting VBA Scripting
  687. Choose function in Excel 2003
  688. len of item in an array
  689. Rename a Sheet Q
  690. Select / Activate last Sheet
  691. Two formats within one cell
  692. Variable text manipulation
  693. removing maximize control from excel application (not justworksheet)?
  694. Looking for values
  695. Throw out the Excel Object Model and then bring it back!
  696. Macro Short Cut Key Issue
  697. Another hyperlink quandry:
  698. Finding words with capital letters and numbers in them
  699. Repost - CommandBarButtons not responding
  700. Filter and Corresponding Validation List
  701. Range problem
  702. Select and copy certain tabs using macro
  703. Modifying chart source range using variable
  704. Add rows Automatically
  705. Button - Macro to auto-populate data
  706. Input Box for data-entry
  707. Error handling
  708. Delete rows macro
  709. Getting a celldata from another excel worksheet
  710. STILL_ACTIVE
  711. round
  712. Merging Two Files
  713. 2003: Slow Response on ClearContents
  714. ActiveWorkbook.SaveAs does not work
  715. Copy rows onto existing sheet / start a new sheet if full
  716. subtracting one csv file from another
  717. Pulling Data from Web Automatically
  718. Hi all,
  719. Input and display help...
  720. Setting xsi in Excel XML output...
  721. How to make a txtbox not visible
  722. Changing cell formula in VBA
  723. Changing Control Object Name( command buttons etc ) from VBA code
  724. Macro for Fill Down where number of rows differs and without havingto hardcode column ranges
  725. PageSetup
  726. Split the Worksheet
  727. Worbook increases in size, slows down too much
  728. Set Range.....am I to blind?
  729. using a vlookup to enter text into rows beneath the vlookup cell
  730. input box method for macro
  731. Workbook Reset AutoFilter to ShowAll
  732. Look for values into Ranges
  733. Reoccurring mathamatical answers
  734. How to return Excel errors from VBA?
  735. Is a cell in a range?
  736. hiding unused rows using macros
  737. Dave Peterson Numbering Worksheets
  738. Adding Help Text to Newly Created Functions
  739. Vlookup?
  740. vba excel - public function in module
  741. Changing Watch variable value
  742. Password Form
  743. Chart Seriew Values
  744. delete empty rows
  745. Tab to combobox and select it instead of the cell
  746. Word-Object: Type mismatch
  747. Filter Pivot table from a form
  748. UserForm Not Hiding
  749. Pivot Table Column Issue
  750. Select certain tabs using macro