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. Resize a Table using VBA
  2. reading and replacing just the first line of a txt or csv file XL2
  3. Open picture manager and print from excel
  4. make message box appear when cell is clicked?
  5. Check user credentials
  6. If date more than
  7. cancel a combobox change
  8. Can't delete file?!!?
  9. SELECT PART OF A TEXT IN A CELL
  10. Countif using symbols
  11. Re: Embed pictures and sound that show when needed
  12. Data Validation Help Needed urgently !!!!!!!!!!!
  13. 2 finds/findnext in nested loops
  14. Error can't Find File
  15. Search and replace multiple values
  16. Help on Custom Task Pane in Excel 2007 using Managed code...
  17. Saving information to PERSONAL.XLS
  18. Email selected sheets
  19. Protecting a sheet partly in Excel 2003
  20. Help with search macro not finding
  21. Median in Excel 2007 pivot-tables
  22. Toolbars in Excel 2007
  23. Data moving 3
  24. SUMIFS in Programming
  25. Copy range C5:Lastrow and paste to two different worksheets
  26. Subtotals for a variable number of rows
  27. Need a little help coping a sheet from one workbook to another.
  28. simple macro to compare lists
  29. Controls collapsed with outline
  30. To prevent a user from deleting and renaming a sheet in a workbook
  31. PADDING STRINGS !!!!!
  32. I need help with this.
  33. Insert Picture using Macro
  34. Select list box entries in multiple rows?
  35. resequence my worksheets
  36. Highlight Rows
  37. Re: Cut and paste to new sheet
  38. Re: Cut and paste to new sheet
  39. ODBC
  40. Disable PDF add-in
  41. if statement
  42. Excel and MS Project
  43. UDF to Calculate YTM
  44. Conditional Formating (If statements)
  45. multiple processors
  46. Re: Multiple replace in Excel - macro ?
  47. Macro Help - Insert row/copy based on criteria
  48. Re: Compare two spreadsheets and eliminate duplicates
  49. Easy way to add my custom button on Excel 2010 quick access toolbar?
  50. Autocomplete date for cell based on other cell values
  51. Can I loop this?
  52. Table Name
  53. Testing object value
  54. RE: vlookup loop help
  55. Macro to Find Column
  56. move data from one spreadsheet to another and repeat
  57. Formula Question
  58. Logging an update
  59. Copy some of selected columns to master sheet
  60. prevent a user from adding any sheet in a workbook
  61. Auto Adjust cell# in a Macro
  62. Table Name
  63. PivotTable 2003 Code is not working
  64. Re: Macro which delets in a cell all characters after comma
  65. Re: Macro which delets in a cell all characters after comma
  66. delete row off 5 worksheets containing specific value
  67. select a specific ActiveCell by VBA
  68. Conditional Formatting
  69. PivotTable 2003
  70. Copypicture from Excel to PowerPoint
  71. Extract data from Oracle
  72. selecting all worksheets to the right of specified worksheet
  73. adjust cell width change font.
  74. Pivot Table Filtering - Macro
  75. for loops
  76. copy paste in correct data
  77. Can excel objects be defined as global variables
  78. Tabs on excel worksheets
  79. Refreshing data
  80. Sum Column in Array
  81. Insert formula even cells with data below it
  82. Non standard characters
  83. RE: Formula to find text and count it within an entire workbook
  84. OleObject not copied properly
  85. sort range
  86. Moving from Excel 03 to 07, need help with customizing
  87. IF for inverting true/false
  88. Run macro on selected sheets
  89. named range in macro call
  90. COM add-ins
  91. How to load specific range of html into Excel?
  92. datetimepicker finding the hours between two dates
  93. Codes needed to update wages
  94. Adv Filter fails in macro, works manually
  95. RE: printing a print area to a non default printer
  96. Make a file save and close itself based on the value of a cell
  97. How to use a variable as an argument in .FliiDown
  98. Hiding Rows Using IF Statement
  99. RE: Check Work Books
  100. hisind rows with an if statement
  101. trying to highlight records with at least 3 same value
  102. How to Combine Columns of Text - sounds easy
  103. Excel 2007 Custom ShortCut Keys
  104. Chart.Name lives forever?
  105. Dynamic Table Problem
  106. Macro Message Box
  107. Find a string with a text paragraph
  108. method 'run' of object '_application' failed
  109. Joel - Data Consolidate Limitation
  110. Like a pivot table
  111. like a Pivot Table
  112. chr$
  113. Contract / P&L management tool sought - simple is best
  114. Removing artifacts from a spreadsheet with VBA
  115. Code running slowly
  116. Different password for different worksheet " Help !"
  117. Selecting Multiple Controls
  118. Help Modifying Hyperlink Macro
  119. find sheet
  120. Pivot Table: Get "customized" detail
  121. button name scope and Caption
  122. Random Running of a Script?
  123. if or not if ???
  124. Easy one for you...
  125. Multipage userform
  126. Application.UserName
  127. How to using Address in selected Range
  128. Vlookup
  129. Cdbl and Cstr with a "Type Mismatch" Error
  130. Combo box in user form
  131. Split Alpha/number
  132. Excel UDF implicit range argument
  133. Excel file is locked by User X
  134. series objects; finding specific ones in the collection
  135. MSProject Template failing
  136. Sort by range
  137. Remove h
  138. Smaller Procedures in case procedure
  139. Auto format sheet
  140. RE: Personalizing a macro based on user input
  141. Add New Events to Existing Collection of Events
  142. Getting Rid of Hyperlinks and Restoring them to a double
  143. Entering (NOW) information on click
  144. Bin Packing Problem (1DBPP)
  145. Type mismatch
  146. Unique problem
  147. Workbook to Workbook Paste Special
  148. To insert a picture in a form
  149. Message to RustyOnVBA
  150. How To Exit Macro Without Debug Prompting
  151. Is there anyway of using a calendar similar to the VB version in e
  152. what is the code to close a file for a macro
  153. delete addin in Excel 2007
  154. make dropdown list greater than 8 rows
  155. Printing
  156. Control Z-Order of drop lines in an Excel 2007 chart?
  157. Validation on InputBox()
  158. check if value exists in pivot table
  159. Look up range and return value
  160. subtract times
  161. Convert UTF-16 Unicode to UTF-8 Unicode?
  162. Passing sheet (using codename) to separate sub as optional paramet
  163. Search & Replace
  164. Program a macro to print
  165. Re: named range in macro call
  166. Re: named range in macro call
  167. Re: named range in macro call
  168. Hovering over an object
  169. Save a date as a variable and run/convert formula against the vari
  170. Copy and paste from WB to another WB
  171. Can someone help me?
  172. XML and SharePoint
  173. Set Chart Legend in VBA
  174. VBA SQL - variable Source Data...
  175. Cut not Copy Appended Data
  176. Strange probem with capitalization of object
  177. duplicating data
  178. Search Directories/SubDirectories and Display in ListBox or MsgBox
  179. Hiding and unhiding rows with if statement macro
  180. Changing Name
  181. Sorting the data in descending order
  182. Excel 2007 Rect type problem
  183. Stop users leaving cells blank
  184. Function to Query CSV file
  185. Issue skiping characters by Regular Expressions searching Word
  186. setting FormulaArray slows down my code
  187. JW Progress Bar after DoubleClick event
  188. Find date
  189. Copy-Pasting row into exact same row on specific other worksheets
  190. Button to take the user in a different place on the same sheet
  191. mailto syntax for text to display
  192. How to re-fresh the import links if it fails?
  193. how to select a column from a cell after find
  194. Alpha Numeric’s bunch together
  195. Macro for changing number of rows
  196. Need To Protect "Tab code"
  197. Loading Data into MultiPage UserForm
  198. Need Syntax for "AND" to Evaluate 2 Cells
  199. Move cells down to match cells
  200. Separating parts of a string in VBA
  201. OnError not trapping subsequent errors?
  202. RE: using cell offsets
  203. Move cells down to match cells
  204. Move cells down to match cells
  205. Move cells down to match cells
  206. Move to match cells
  207. Move to match cells
  208. Move to match cells
  209. Move to match cells
  210. Move to match cells
  211. Move to match cells
  212. Move to match cells
  213. Move to match cells
  214. Move to match cells
  215. Move to match cells
  216. Moving cells to row with matching data
  217. Check and clear Multiple check boxes
  218. Keystroke macro results . . .
  219. Filling in columns counting by Hex
  220. using Forms and VBA within Excel
  221. VBA Input box (or MsgBox) with pull down or choices
  222. search column for duplicate value during data entry
  223. Looking for a golf league scheduling spread sheet for 18 teams of
  224. SOS-Need to calculate number of working hours per each week of mon
  225. Outlining based on level numbers in most left column
  226. Re: How to print all columns from a multi column listbox?
  227. Hide/unhide a button based on selection in a combobox
  228. Preserve XML whitespace in Excel 2003
  229. error -1.#IND
  230. Is possible to upload file to OfficeLive via Code (VBA)
  231. Problem opening an Excel file from code
  232. Tracking New Tabs in Excel
  233. Paste copied data to specified sheet based on range - variable iss
  234. RE: Autofill of Cell based on contents in non adjacent cell
  235. Copy to specified sheet, values only
  236. Adding Outlook signature to email created by macro
  237. Make a PDF file from Excel Data
  238. RE: Lookup and User form
  239. RE: Edit current row in user form
  240. Measure on the date different
  241. RE: Edit current row in user form
  242. Convert text invoice into a table- please help!
  243. Need to break up my SheetSelectionChange routine
  244. VBA macro guru help needed!
  245. Close msgbox after making selection
  246. How Do I?
  247. Open a workbook and get data from it
  248. simple code not working
  249. Find/Find all
  250. delete rows with header, excluding 1st row
  251. Command button naming issue
  252. RE: open from sharepoint
  253. Stop fill in the blanks (down) at specific row
  254. Fiscal Year Week Number Calculation with a twist....
  255. RE: Error trap X 2
  256. Get cell value
  257. To determine the data type of the selection range
  258. To determine if selection range contains empty rows
  259. How do l get the sheet name from the sheet code name?
  260. RE: Arrow color with Autofilter (with Excel)
  261. RE: Automatic Excel data selection and transfer/copy to another wo
  262. RE: Populate an array with file names
  263. RE: delete cells containing zero after a cell containing a value
  264. Prevent changing a fraction
  265. Excel Programming
  266. How reliable is this site!
  267. Find Text String
  268. REARRANGE STRINGS IN ARRAY !!!!
  269. Re: Help making this macro dynamic :)
  270. RE: extract data from .ora file
  271. RE: Object not set
  272. Form check box
  273. Like, with worksheet- UDF?
  274. determine how excel was opened
  275. Help with Subtotal Function
  276. RE: Object not set
  277. Picture scroll with active cell
  278. How to ID calling worksheet if it isn't the active sheet?
  279. Excel formulas
  280. Excel VBA Project Has Protection?
  281. Case not recognized in Select Case
  282. Re: How does Personal Macro Workbook become personal.xls
  283. Image Control
  284. Selecting a point on a chart in Excel 2007 on Windows 7
  285. File name being changed
  286. Error when no records meet criteria - repost
  287. Should be easy...what's missing?
  288. VB help with ExecuteExcel4Macro
  289. how to make data together by VBA
  290. DoubleClick to return SeriesIndex & PointIndex
  291. For each
  292. Select 'used range' except header row in excel 2007
  293. Disable share workbook option in VBA
  294. Chart Sheet BeforeDoubleClick
  295. Copy a particular column of all the Worksheets in a folder in a newworksheet
  296. Alternative way to show 12 tabs??
  297. Re: Opening file by partial name in same folder as master file
  298. DYNAMIC RANGE FOR PIVOT TABLE
  299. Check Workbook name currently opens is correctly
  300. Another 'Copy To The Next Available Row' Question
  301. Vista
  302. Using WorksheetFunction.Find in VBA
  303. Delete OLEObject from Row or Cell
  304. run report on company intranet and import to excel
  305. invalid use of property message
  306. "Invalid use of Property" message
  307. building a range for SetSourceData
  308. Code to select data
  309. Repeat a marco with number of times or loop until End
  310. VBA Chart Size Accuracy
  311. Excel message box
  312. INSERT FILEDATE INTO CELL COMMENT
  313. Matching strings with a pattern
  314. FASTER USE OF THE REPLACE() FUNCTION !!!!!
  315. Prevent clicking on a cell
  316. Adjusting time data to nearest ten minute block
  317. The Missing File
  318. Copy Picture problems
  319. macro to run when I hide or unhide rows in a group
  320. Collect value
  321. Updatig the Next Consecutive Empty Cell in a Range
  322. Macro
  323. DoneEx XCell Compiler - comments on VBA protection?
  324. What is the Limit of Text Boxes & Labels a User Form can have?
  325. Showing argument descriptions as an XLL worksheet function is type
  326. simple little loop
  327. select case simplification request
  328. Collect value
  329. ChDrive and ChPath to a network drive
  330. use variable value in a range reference?
  331. RE: Complex If/Or/And formula
  332. Strange behaviour
  333. RE: Complex If/Or/And formula
  334. Need help with simple macros for double checking manual plugs
  335. To,Mr.Jensen Harrisn and Mr.Savraj Dhanjal @MSoft.com
  336. Excel VBA recommendations
  337. help w/deleting rows if 2 conditions & calling macro from other bo
  338. Re: How to skip confirmation for macro and update all links?
  339. Redirecting ALT+1 keystrokes to run routine
  340. How to skip confirmation for macro and update all links?
  341. Loop by Group Within Group
  342. Password entry userform
  343. Reference list
  344. Extracting Data From a Chart
  345. unhiding / hiding sheets
  346. Keep getting "Type mismatch"
  347. Insert, copy, update, delete records through VBA
  348. CommandBar and Controls (how to create separate "Sets" of Controls)
  349. More efficient code wanted
  350. Debugging
  351. Debugging
  352. Debugging
  353. Another Easy Question
  354. Link checker: checking if a URL exists
  355. Sumproduct error
  356. Move lines from one sheet to another
  357. SaveAs in Excel97-2003 format
  358. In what order do installed AddIns open?
  359. Application or object defined error
  360. VBA Calculation with Variables
  361. Picture Form Help
  362. Maximize Excel?
  363. How to run a macro by opening a file?
  364. What IF statement
  365. CDbl and "Type mismatch"
  366. Sort data from every workbook in a folder into sheets in another?
  367. userform control structure strategy help request
  368. VBA Calculation with Variables
  369. Macro Help - Array
  370. A macro to check if a URL exists
  371. formulas containing constants
  372. Locking all text, combo and check boxes
  373. Filter Table based on Cell Value
  374. copy text and logo from protected, hidden sheet
  375. HELP: Email body transcript deleted when receiving response emails
  376. Very Easy...Right?
  377. Macro help needed
  378. add cells
  379. How to group
  380. Problem with workbook on_open event
  381. How do I open a com port using Excel visual basic
  382. Auto_Open Macro
  383. Lookup and Enter Value to Other Tab on Change in Cell
  384. Re: How to reference shdocvw?
  385. How to reference shdocvw?
  386. Saving workbook with a trusted extenstion VBA issue
  387. how to skip open operation
  388. Copy Filtered Data
  389. How to Loop
  390. Syntax to match sheet by codename
  391. Error values generated in functions
  392. Combine two ranges with different numbers of rows and columns
  393. Go to record end, then one across
  394. Re: How can I check a collection (e.g. worksheets) collection to beempty?
  395. Hiding menu options
  396. Re: Trying to read CustomDocumentProperties of an open 2007 AddIn
  397. Importing text file into Excel 2003 - C# - QueryTables.Add throwsSystem.ArgumentException
  398. Programatically format Axis Values
  399. merge all files in sub dirs
  400. Savecopy and saveas locking up excel
  401. Excel 2007 ADO Connection Error
  402. Protecting macros
  403. Exit Sub from Main Sub
  404. UserForm Text Box to display worksheet cell text
  405. Conditionally populate a data table
  406. Code to update links every 30 seconds
  407. Array To View Specific Sheet(s)
  408. Existing File Not Found
  409. CurrentRegion - Usual Behavior?
  410. How do I capture the last character in a string inside a macro?
  411. DATE MODIFIED
  412. Excel hangs crashes when pasting formulas
  413. Max size of user form?
  414. fill several sheets with data from other workbooks matching criter
  415. fill several sheets with data from other workbooks matching criter
  416. run report on web page, import to excel
  417. IS it possible to get the Visual Basic Form to VBA Excel
  418. Date Stamp
  419. Pivot Table and Protection
  420. Reloading and Editing UserForms in Excel - help!
  421. Dynamic radar chart
  422. Identify last row containing data
  423. ListBox / UserForm interaction
  424. Error when no records meet criteria
  425. Copy numbers from an array, each to it’s own sheet
  426. If statement works here, case doesn't
  427. Trying to read CustomDocumentProperties of an open 2007 AddIn
  428. Combobox display 1 value, access another
  429. Add formula to cell to sum range of cells
  430. Concatenate A1, B1, and C1 into D1
  431. Adding a sheet to a workbook
  432. Copy/Paste Import/Export Data VBA Code
  433. Code to look at range and extract data.
  434. Autofill Formula
  435. Conditional Format Syntax Error
  436. Passing info to the Workbook.Open event
  437. Sending Emails
  438. Extract multiple data to other cells with same numbering
  439. Problem Applying Formula to cell
  440. Separate first and last name in two columns
  441. how to check if a number has no more than 2 decimal digits
  442. Which version Excel created file?
  443. Selection based on partial input
  444. Conditional Format
  445. Named Range
  446. This one is For all the accomplished MVPs.
  447. Getting the entry of a Named Range
  448. Code to find all / next in a row of data
  449. Array range error question
  450. SUMIFS BY MONTH
  451. Drawing in VBA - compatibility between Excel 2003 and 2007
  452. microsoft 2008
  453. senin - sabtu
  454. Alternate Shading for non-bold rows
  455. Re: Extracting a number from a multiline-entry
  456. What VBA function returns cell 2 from which cell 1 gets its value?
  457. Lookup value, but between dates
  458. Sheet and workbook code: All sheets should have row 1 to 5 of Sheet1to be repeated at top
  459. random selection of rows
  460. Help with printing rows and/or columns
  461. Help with drop-down box creation
  462. trim a range object
  463. Pivot Items Visible
  464. Making A Particular Wooksheet Active
  465. Turn off all error messages in Excel
  466. Type mismatch error using Sumproduct
  467. Emailing individual worksheets - problems with save as and filename/subject
  468. Columns Grouped
  469. Making a sports league schedule
  470. Prevent user from Inserting new worksheet
  471. Copy Rows Based On Criteria
  472. Setup dropdown list that selection references another dropdown
  473. Using VB to pull formats and data from another workbook
  474. Pivot table and it's macro
  475. Excel Function
  476. How do I programmatically select various ranges in vba?
  477. Populating and Comparing Arrays
  478. In XL VBA, Word Document SaveAs throws error
  479. Where to ask- running Excel from .NET?
  480. Add Page Numbers to PDF
  481. Macro Please
  482. how do i bring a visual basic form to the spread sheet?
  483. Creating a Required Field
  484. Programming question
  485. Do loop or For Next with data from cells
  486. Events copy and paste
  487. Can I do without using VSTO
  488. migrate xls app 2003 to 2007 -- get custom macro button out of des
  489. Macro for blocker from using cell range
  490. Sharing macros
  491. Email Help: Email with voting buttons from excel, Body gets delete
  492. Why Excel process is still there on Task Manager list
  493. E-mail from Excel
  494. Save file to Specific Directory - then EMAIL
  495. Saving a Macro Button on the Quick Access Toolbar in Excel
  496. How to do it in macro?
  497. Saving files to Sharepoint site: error 1004 (can't save file)
  498. cells() property?
  499. create a macro that opens, edits then closes cell
  500. A link to a collection of videos and tutorials on MS excel:Data mining Add-in
  501. how can i search for sheet with any part of sheet name
  502. Type mismatch: array or user-defined type expected
  503. what is the code cann make this pls. help me
  504. how do I find all the rows containing a specific value in excel
  505. Macro slow when copy and pasting
  506. Advanced filter VS formula in cell
  507. find item in coloumn
  508. date format
  509. date format...3.1.2010
  510. date format...
  511. Excel VBA: Reading data from HTML-file
  512. Copy cell values to another sheet
  513. Merge 1000+ cells into one
  514. Organising sales data by month
  515. Macro to copy a VLOOKUP formula - Data with a filter on
  516. Distinct items from recordset
  517. Change color on faceid 3077
  518. How not to display any pop up message for macro?
  519. Protect Worksheet Macro
  520. make it text in vlookup
  521. case is string contains string?
  522. Local cube files
  523. sumif
  524. HELP: how to locate objects on userform from VBA code
  525. show and hide a drop down list
  526. slecting averages from a changing table
  527. application.statusbar updates freeze
  528. Open Referenced Add In Workbook as Read Only
  529. Question on pivot tables
  530. Advantages and Disadvantages of Referencing An Add-In Workbook
  531. How to Update Selections for (Numerous) Validation Lists
  532. between
  533. I need help with this Subroutine!!!!
  534. Lists not working w/ userform
  535. Search for userform or procedure name?
  536. dynamic references to content in closed Excel workbooks
  537. Can anyone help with a macro?
  538. VBA IF THEN with an OR
  539. Complex Excel formula help
  540. How to determine which sheets appear on opening a workbook.
  541. Formula appearing instead of result
  542. Importing number with dash changes to date
  543. How do I create synchronised lists in Excel?
  544. Copy and paste rows from one wksht to another based on cell value
  545. Application.SendKeys & Printing
  546. Extracting a number from a multiline-entry
  547. Organising large amounts of VBA code
  548. Chip Pearson's VB Object references
  549. How to set cell validation in excel using name range?
  550. Why macro cannot refreshall?
  551. dumb question about subtraction
  552. lookup
  553. Date Format returned from Userform to Excel worksheet
  554. Reading from a dat file
  555. what type of code is this?
  556. Dropdown list items and item IDs
  557. Looking for beta testers
  558. move one cell down
  559. User Form Date Field disappeared!
  560. Delete Blank Rows when Pivot Table included on sheet
  561. Problem with exported text
  562. automating data copy from dynamic invoice to single spreadsheet
  563. CopyPicture from Excel Range to Power Point
  564. Extracting data from an excel spreadsheet
  565. date tracking
  566. Pick numbers
  567. String of numbers
  568. Replace manual line breaks (Alt+Enter) with two spaces for selectedcells
  569. Help with DDE - stock feed
  570. Excel VBA Populatig UserFrom Contols as Design Time.
  571. How to retrieve value from specific cell value?
  572. How to set TIME condition for if-statement?
  573. Manipulating Table data
  574. How to code it in macro?
  575. Sort a Column
  576. How to code macro to disconnect internet connection?
  577. Prevent cursor/focus from moving
  578. Ribbon Customisation
  579. Extract last name from Last, First
  580. Build a String Sort Key, sort a 2 dimen array Mar20
  581. odbc connection lost
  582. Combined Cell Value
  583. RE: copy a hyperlink to another cell
  584. Time duration calculation
  585. Letters in the code
  586. How to code it on macro ?
  587. What is the bar and function name for refresh all?
  588. Hiding rows
  589. Calculating Distance in MIles
  590. Choosing a drop-down menu selection returns value to another cell
  591. Acos trig function
  592. Copy Paste with fiter and hide copies filtered and hidden
  593. Making my App only work so many times
  594. Reconstructing a table with Arrays
  595. onGetEnabled
  596. Hide Rows if all values are zero
  597. covert invoice.GIF to excel database
  598. Macro Error that I connot figure out
  599. Excel 2007 export/import datetime
  600. Object variable not set error
  601. How to make weekly totals change as the days in the week change ye
  602. Macro
  603. Macro to extract data from multiple Excel files
  604. HELP: Email body deleted when I receive voting response
  605. VBA: Insert rows
  606. Deconstructing a table
  607. SaveAs FileFormat
  608. e-mail issue
  609. EXACT function - but where does it not match?
  610. Data Entry Form
  611. Deconstructing a table - How to take a table back to the begining
  612. Macro to Delete Duplicate Cells
  613. SQL VBA Excel
  614. Dependant ComboBox on a UserForm
  615. saving And rename source file
  616. Copy question
  617. Advantages and Disadvantages of Referencing An Add-In Workbook
  618. vba format question
  619. Triming trailing spaces before using Match on columns of numbers withleading zeroes formatted as text
  620. prioritized assembly data
  621. XML Suppress Keytip Auto-Assignment in Custom Ribbon Tab
  622. Ribbon Customisation
  623. Select all rows till last row with value in Column A and CopyPaste
  624. Accessing Worksheet stored within Power Point
  625. Unable to change "Enabled" state of an Excel 2007 ribbon gallery b
  626. How to Reregister a given Excel version
  627. Cdate does not help
  628. problem with conditional formatting and VBA (excel 2007)
  629. How can I make this formula work?
  630. Can I freeze columns in a listbox
  631. Making a cell mandatory if another cell has a particular value
  632. create email when the cell value changes
  633. Prevent edit on combo box?
  634. Urgent Help needed!!!!
  635. how pass array to a function?
  636. How to do it in macro?
  637. Help!!
  638. Digital Signature?
  639. lists not populating userform
  640. Is there a way to test if a control exists on a userform?
  641. cell to have comma-delimited values based on text
  642. Excel 2007
  643. presenting a list to the users
  644. Number with dash is importing as date
  645. Closing workbook open as CSV
  646. Object doesn't support this property or metheod ERROR
  647. Macro Please
  648. update links - source file open
  649. show download progress to user
  650. Re Post Please help: Listboxes question
  651. Calcutate SUM of column in first blank row
  652. Bug with the function Round !
  653. need help writing a script Hiding a range when a cell with in is greater than 53..
  654. How to get notified when user inserts cells, rows, or columns in W
  655. Evaluate v. WorksheetFunction: best practice?
  656. Loop through a range Open a file
  657. Close Referenced Workbook if it's No Longer Referenced
  658. Simple IF give me nothing?
  659. Programable Controls on a Chart
  660. Unable to get TextBoxes property of Worksheet Class Error
  661. appXL = CreateObject("Excel.Application")
  662. ActiveWorkbook.PivotCaches.Create in Excel 2007
  663. GetObjects chokes on apostrophe.
  664. Run time error adding controls to form programatically
  665. Listbox scretch
  666. Data Validation circle cell position
  667. Pull data (sumif?) from an external workbook
  668. Copying and pasting values to the last available column
  669. Copy and paste
  670. How to set time within macro?
  671. How to do it in macro?
  672. question using SUMPRODUCT
  673. How to set time for processing the code?
  674. Create Range of Visible Rows only
  675. Create a list of pre-named tabs
  676. Create Hyperlink in VBA
  677. Referencing another field if result is N/A
  678. Auto copy and insert a defined number of rows as defined in a cell
  679. Automatic filling of data
  680. International Range style settings
  681. delete rows that have a duplicate id keeping the upper row
  682. selecting cells to produce a pivot table
  683. Problem copying named range
  684. VBA access to a series, after it was assigned to an empty range
  685. Declaring variables for use in a Module
  686. Automatically start a macro after data refresh
  687. DIR
  688. List of Displayed Pivot Items
  689. Excel Open window customization
  690. How do I code the cloning of an object in vba?
  691. Cloning an object which contains a collection
  692. How to simulate a click into a textbox (shapes)
  693. Filling right header/footer with barcode
  694. List Listbox data in column
  695. How to open a workbook into a new Excel application
  696. format on change event
  697. delete rows which have a one in them
  698. Macro to delete rows
  699. .Text .Formula .Value to replace copy_paste values?
  700. Set certain cells to print and others not to print
  701. Excel automation fails from PowerShell when PIa are installed.
  702. referencing a workbook using string var = error9
  703. Combo Box
  704. .pdf file not working in UserForm
  705. Need Help with a cell?
  706. How can I use a collection inside a class?
  707. Date dependent macro - run once only
  708. Clearing used range?
  709. Determine the Empty row and/or column
  710. List of tables in SQL server database
  711. Looping code
  712. change date in a sql statement from a cell
  713. Getting output from the TREND function using VBA
  714. Matching Data between 2 Tabs on Same Workbook - then calculating
  715. Copy subset of Range
  716. Determine number of rows with data
  717. Self Signed Digital Certificates.
  718. using excel formulas in VB coding
  719. Unload UserForms
  720. format a formula to general (not text)
  721. 2 Dim Array Sort, on any columns, ascend or descend. Guidance des
  722. Convert Pivot Table to Values in Macro
  723. Allow only one value in range.
  724. Password To Open Spreadsheet Used as Variable in VB Code or Macro
  725. What's wrong with this?
  726. Autofill Formulas
  727. Open hyperlink - how can I check the page has finished loading
  728. save as - location or default
  729. VBA Conditional Formating Using Logical Expression
  730. move row to next sheet
  731. Chart Print Footer :: Excel 2007
  732. Remove Focus from Form
  733. Code not working
  734. Change in Cell Value
  735. Return 1 of 3 different values based on multiple cells
  736. Simplifying an If(OR(…)) statement
  737. Stumped - Problem with Macro Security settings?
  738. Auto Populate a Template
  739. Addin instalalltion throught a vbscript
  740. macro pointing to wrong folder
  741. Multiple row insertion on various worksheets
  742. UDF Not working
  743. pdf file in a UserForm
  744. How to write Property Let for the single elements of an array
  745. Recall a file
  746. Code To Insert Blank Rows
  747. API Screen Locking
  748. Open Workbooks
  749. List Listbox items in column by macro
  750. Re posting Please help (Macro for Special Sorting)