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. Re ordering help urgent!!!
  2. Unprotect Worsheet
  3. How to write STDev formula in a macro
  4. Enforcing Macro-enabled saves
  5. sum a range from a starting point that varies
  6. interactive column width
  7. irregular image map
  8. Custom Vlookup Function
  9. Add-in Already Open
  10. Single line of code with line separator
  11. suggestions for parsing a string
  12. countif or please advice
  13. Countif or please advice
  14. Left, top, rigth and bottom points dimensions in a 3d Chart
  15. Recorded macro fails after save, close, then reopen
  16. To get row id
  17. Sorting and the Worksheet Change Event
  18. Excel 2007 embedded in VB app
  19. excel programming
  20. While doing multiple cell copy paste the Selection.PasteSpecial overrides the protected formula cells
  21. Validation of 2 rows of cells, only 'X' or 'x' allowed.
  22. Insert and Copy
  23. Prompt user to select a shape
  24. PlayWavFile
  25. Excel default module when opening visual basic editor
  26. Pulling files by the creation date
  27. Saving the contents of a worksheet table to an xml document when theuser closes the workbook.
  28. Passing Paramiters and UDF Question
  29. How to leave Selection.Sort Key open....
  30. Excel Sheet Unviewable ~ able to open, but sheet proper all blue
  31. Using Replace to remove part of a string
  32. User form varible passing
  33. Run the macro until activeSheet.previous.Select = Sheet2
  34. Save as Macro
  35. Save as Macro
  36. Excel Form for updating records
  37. Hide text in a cell.
  38. drodown selection
  39. Subtotal macro in each worksheet
  40. assign the formatted cell value (date) to another cell?
  41. sum values in multiple ranges
  42. my macro is remembering specific range instead of 1st to last
  43. dictionary count is greater than number of keys?
  44. Can I abbrevate the following (would I Dim and Set it as a Range?)
  45. Have a problem with "Find" code
  46. Copy data from all the file file from a folder.
  47. place cell value in header
  48. Deleting columns on multiple sheets
  49. Copying results to clipboard. Is there a better way ?
  50. Socket component in Excel 2007
  51. adding all the cells in a group of cells
  52. Macro to insert multiple images at specific cells and resize all i
  53. disappearing querytables
  54. Selecting Column Until End of Another Array
  55. run time error 53
  56. Macro Code not reliable
  57. InputBox methode
  58. May I called a Programmer if...
  59. Using a value in a cell as a Reference in a formula?
  60. Save problem with multiple workbooks and event workbook_deactivate
  61. Requesting Help Please on Auto Worksheet Setup
  62. Find all in one sheet
  63. Place wingding on specific coordinates - possible?
  64. How do I convert an Excel template to an Outlook form
  65. Add subfolders and name - Possible?
  66. Text box date format
  67. Mutiple comboboxes on user form
  68. beforeclose
  69. =IF Color
  70. Create scripts from Excel
  71. Autofill with Column as a variable
  72. Assign Web Query Result to a Variable
  73. Function writing cells
  74. combining several sheets together
  75. Ribbon visual state gets refreshed when multiple like workbooksopened
  76. look up
  77. Changing number format to remove %
  78. Inserting a Row after finding a Name in colum
  79. AutoFit
  80. Custom function to find top sellers
  81. Find Column Letter - When column header is found
  82. delete and replace
  83. How do I Get a String... or any variable for that matter?
  84. looking for true result if number is a %
  85. Object variable or with block not set Err 91
  86. CONTROL WORD FROM EXCEL
  87. VBA Auto correction Issue
  88. Help with UDF to search through a table
  89. Macro to insert Rows
  90. Chart Question Using VBA
  91. Macro to find and log all formula errors on all sheets
  92. Sound files VBA programmed from Excel
  93. Pivot Table - Show All
  94. Cannot find macro file
  95. Assign a folder path to a variable
  96. Okay, want to learn this once and for all, how _do_ we get rid of zeros formulaically?
  97. Update a cell based on the pivot table refresh date
  98. Can you set 2 ranges to both be from the same cell?
  99. Getting new empty row ?
  100. run time error 1004
  101. Disable "On Open" macro
  102. Run-time error when path parameter changed
  103. Disabling clipboard prompt
  104. RE: checkbox for commandbar
  105. Filtering Dates in a table with input boxes
  106. VB macro code does not save
  107. Looping though sheets in workbook
  108. Problem with (One location = Another location)
  109. type mismatch
  110. Check boxes in drop down box
  111. email code
  112. Macro for adding text from one cell to another cell
  113. Terminology Clarification: Is It Correct For A Spreadsheet ContainingVBA Routines To Be Called A Macro?
  114. Sub before and after 'Get External Data"
  115. Problem formatting header font size
  116. Creating a table based on user input
  117. automatic change cell's colour
  118. Variable cumulative R1C1(??) notation
  119. Go to Error (what is this? Is it for findign #DIV! erros in Excel?
  120. Sort Sheets
  121. VLOOKUP!@#$%^&*
  122. WorkSheet Selecteion Chage Event to prompt Input Box
  123. deleting rows based on criteria
  124. Determining which Print Button was clicked
  125. vba xcel
  126. Selectblank cells
  127. Command button executes without code???
  128. multiple ranges in cell notation
  129. capturing the values from a combo box into an xml file
  130. Refresh Pivot Tables without refreshing functions
  131. Adding time by a Numerical Value
  132. Macro not running correctly
  133. Find/Delete skipping rows
  134. Assigning string values to a range
  135. Error when running VBA Help's Find method example
  136. Code lagging with LastRow
  137. Print Area Pivot Table
  138. selecting relative ranges
  139. maintaining the value of a variable outside of an if construct...
  140. Expected end of statement error
  141. Delelting previous row
  142. The best way to import data from Access (Performance) ??
  143. Path Name issue for file opened from Z drive
  144. Selection.Value Error when multiple cells selected
  145. Sheets to new WorkBook
  146. Some Excel dates can't be imported into sql server?
  147. Adding sount to a macro
  148. Paste year as a specific date
  149. Boolean Variable Definition
  150. List Box
  151. Follow hyperlink to show form
  152. Adding sound
  153. excel date format problem
  154. userform comments
  155. Find first non-blank cell
  156. Restrict Prompting for Macro Security
  157. Unload a UserForm
  158. Copy All Workbooks Sheets(2) Formats & Values only from Folder A toFolder B
  159. Re Post - Please Help (Excel WebBrowser Control)
  160. Divide two numbers in data subtotal function
  161. Rightborder
  162. No borders/gridlines around some cells
  163. Graph with variable range
  164. xlDialog to select Cell/Range
  165. MACRO QUESTION ????
  166. Using case
  167. Increase the number of lines buffered in the Immediate Window?
  168. Get rid of SaveAs prompts
  169. VLOOKUP Object error
  170. Vlookup and print loop
  171. How to store formula in Access table ?
  172. Show userform from another workbook
  173. how to "synchronize" VBProjects & VBA.Userforms?
  174. highlights cells that are not a dependents
  175. Auto set value/formula in entire column cell
  176. Macros
  177. Loop through files in a folder and unprotect sheets
  178. Updating path in defined name
  179. Formatting columns of data with alternate font colours
  180. Copy Destination parameter issue
  181. Access a Variable from the Worksheet
  182. How to create a function?
  183. Validation list driving macros
  184. Workbook_Open Event won't work
  185. Storing configuration data in XLA file
  186. filtering unique value
  187. How do I activate the visual basic editor in Excel 2007 ?
  188. Copy Formula down x Number of rows
  189. remove button
  190. Excel to Word Macro
  191. Need general directions
  192. Find Column without Changing Refs in vb
  193. ComboBox last selection
  194. VBA - UserForm Reset Option
  195. Excel XP: sending data to SQL Server 2005
  196. Worksheet Listbox selected item?
  197. Formatting cells within VBA
  198. "Compile Error: ByRef argument type mismatch" when calling my function from another module
  199. Copy Column data to Page Header
  200. Iterative process of running queries frequently abends for no clr.
  201. What am I missing - Workbooks.Open
  202. baffling find method problems
  203. What am I missing (Opening Workbooks)
  204. Const or Variable that doesn't change
  205. Need Help in cut/paste data from text file to another using excelmacro
  206. Find Cells with Specific Format
  207. Macro for Opening Reuters, Opening Excel File, Closing Excel File
  208. Select method of Range Class failed
  209. OLE Question
  210. VBA: How do I find a value within a selected range?
  211. Wait time between Saving and other activity
  212. Formula, quotes, and variable
  213. how to use variable that should be in "quotes"
  214. Programmatically removing data filters
  215. Inserting Rows - Complicated
  216. Filtering with VBA
  217. Click Colored Cell -> UserForm.Show Question.
  218. Importing XML through web-based query
  219. Get All Files from a Directory
  220. How to use the worksheetfunction Vlookup
  221. Slow spreadsheet
  222. Trying to get worksheefunction match to work
  223. How to retreive the name of a named cell in an excel macro
  224. MATCH
  225. Sendkey not working
  226. Combo Box Event code self triggering??
  227. Problem using Copy:=Destionation across different workbooks
  228. Excel hangs with userform
  229. ActiveX Toggles
  230. Tab between ActiveX controls
  231. Launch Excel On Event?
  232. Macro To Avoid Link Update of Open Files
  233. Using VBA to sort a column of data
  234. Using VBA to sort a column of data
  235. Finding the first cell in a column that is not hidden
  236. Why won't my loop recognize empty cells?
  237. Something in this is causing a crash
  238. Application.CutCopyMode = False
  239. Creating new workbook from different workbook
  240. Add a name based on a number
  241. What in the edited code below makes it crash?????
  242. Challenging Task Ahead
  243. HDI capture multiple selections from a comi-box into cells?
  244. count unique values in a col
  245. How To Insert 3 Rows and Total
  246. Can you open Office 2007 docs in Office 2003 from code?
  247. Trying to cobble together two bis of code (Unsuccessfully)
  248. Find Text in Cell and Copy
  249. inverted commas
  250. Splitting one single cell into pieces
  251. how to bind access database to listview
  252. Link excel 2007 chart formatting
  253. Invalid name Error
  254. Variant Array - Possible Bug?
  255. If Statements
  256. Freeze the value of one cell for secs while worksheet auto updates
  257. User form code question
  258. Prompt for cells on open
  259. FUNCTION SYNTAX
  260. using filename or a cell value for a custom menu
  261. Date format cannot change
  262. editing/deleting text
  263. find concatenated values question
  264. Substitute the value from another Workbook
  265. Vlookup to a table on a webpage
  266. Copy text box contents
  267. memory problem of Excel 2003 copy & paste
  268. Listbox problem agaie
  269. recordset question
  270. Convert macro that runs against entire column to run in current row
  271. want to change tab color based on the info in a cell.
  272. Button Problem
  273. Need Help
  274. How do I set an environment variable to a string
  275. How to delete a "return" character (a "box") in cell of imported d
  276. IIf Function
  277. cell value syntax
  278. Re: Check hour format
  279. Re: Check hour format
  280. Assigning values from source cells
  281. how to check if sheet has graphs?
  282. mod error in VBA
  283. Identify cells based on format
  284. Center result on screen
  285. Really Help with existing VBA code...
  286. For...Each loop not working
  287. List Box Columns
  288. determine dropdown value
  289. Zoom window to selection (further clarification)
  290. PivotTable: How to reset the CurrentPage to (All)
  291. Need assistance with Excel 2007
  292. Zoom window to selection
  293. Pictures in comments Sub MyPix modification ??
  294. How do you document a function (like built in functions) in VBA?
  295. write to column A depending on which Radio button is selected.
  296. Watch not working for action on other cells
  297. Paste Special, Values only
  298. Loop Macro??
  299. calling a routine to declare variables at start of macro
  300. Eliminating commas if they are first characters in a string
  301. Whats the difference between usign Named Range and Cells.Find
  302. delimited text export
  303. Math and action via VBA
  304. How do i use Xlstat for clustering data into segments
  305. Find out what windows are open
  306. Run Code Line by Line
  307. Display Alerts
  308. Moving text from a line to a new line based on a condition
  309. Sumproduct troubleshooting (new to me)
  310. REPOST: Need help with XL2007 FormatConditions, please?
  311. Input validation using VBA
  312. how to create a bookmark automatically in Excel?
  313. Disable Auto Calculate w/.enablecalculation?
  314. Third party .xla interferes with Worksheet_Change
  315. Position a Window
  316. Horizontal to vertical ( 1 row to 1 column )
  317. WebBrowser Control Question
  318. RE: Fill a cell with abbreviated text from a list
  319. RE: Fill a cell with abbreviated text from a list
  320. Accessing Data from an oracle database on a different server using
  321. AdvanceFilter Problem
  322. creating a function with a for loop
  323. Concatenate
  324. code to navigate IE7 runs on XP but not on Vista
  325. Universal open
  326. Delete row 2 cell criteria
  327. Using Option buttons with vlookup
  328. Can't figure out formula error
  329. Add comment to command button
  330. Locking Excel Sheet with Control Toolbox controls
  331. Controls on Excel Sheets from Control Toolbox
  332. Need help inserting formula with macro
  333. VBA process to run in intervals in Excel
  334. Import XPS file into Excel
  335. Calculate the result of an array in vba
  336. Macro
  337. Find SearchOrder?
  338. Msgbox button captions
  339. Listbox problems
  340. repost Split fullname into First Middle and Last
  341. Sorting rows
  342. Concantenating Text with | and ' (vertical slash and single qoute)
  343. vba pivot table sorting
  344. VBA: Using a range in a formula
  345. Modify each cell in selection
  346. Subtract day and time w/o weekends or holidays
  347. VBA in a webpage
  348. macro running on timer fails to select proper sheet
  349. help needed with Countif....
  350. Macro to add a new row if text length is over 30
  351. Formatting cell base on free form or standard inputs.
  352. Call the property of a class using a variable
  353. pass parm to another userform
  354. Identifying last filled area ('row') of an array via VBA?
  355. A macro locates files on one PC but not another - why?
  356. Cell text color change event
  357. Can this be done with VBA ?
  358. editing .xla files
  359. 2003 Excel Windows XP to 2007 Excel Windows Vista
  360. Changing cursor outline color of active cell
  361. Random Range with no duplicates
  362. Pivot Table Refresh
  363. Disconnected Module in VB
  364. Mouse Click to Run Macro
  365. VBA store location as variable
  366. Range("E8:E53").FillRight how can I make this .Value?
  367. insert multiple cells every ### rows
  368. change custom view when leaving a sheet
  369. Interop over Portable excel
  370. macro web
  371. Two parts of the same thing
  372. Named Ranged, help please
  373. Calendar Issue - Out of Memery
  374. Creating list of duplicates
  375. How to check Operating System?
  376. Copying with .Value
  377. range.copy not working as expected
  378. Programmatically copying array formulas
  379. Label Click to open Word Document
  380. How can I simply the following, must I keep .Select?
  381. How do I cut/copy paste without using the clipboard?
  382. Array declared with the Static keyword clears itself between calls
  383. Whats wrong with this? MyWBAccRep.Sheets("Volumes").Cells.Find("latest").Copy.Offset(0,
  384. character.delete doesn't work
  385. How to replace single cell references with row names?
  386. Re: Missing Zero
  387. Missing Zero
  388. Protecting & Unportecting the sheet.
  389. Find cells containing multiple values in random order
  390. how to run macro in double click on a particular cell
  391. Excel shape changes in printing
  392. import table access to excel
  393. Listbox how to get to appear left of cell?
  394. Tips to speed up VBA with several workbooks open.
  395. Tiered Pricing Calculations
  396. toolbars - button
  397. How to disable all controls in form?
  398. Split fullname into First Middle and Last
  399. How to open workbooks in different Excel?
  400. running a macro in Microsoft Project
  401. first non blank cell
  402. RE: OnError - what generated the error?
  403. picture Format in excel
  404. Multiple pivot tables on same sheet with common report filter
  405. error 9 'subscript out of range' using workshhets function
  406. Loop through expanding range
  407. Re: OnError - what generated the error?
  408. Re: OnError - what generated the error?
  409. pop up during calculation
  410. Sum the first character in a range
  411. A search tool to the wishlist
  412. I need help again
  413. Print time
  414. Code error to mirror data from one table to another
  415. Formula = problem
  416. want to change cell background using RGB data in a worksheet
  417. Help in printing a sorted list of customers purchases
  418. if and help
  419. Re: VBA Library
  420. If function in Macro
  421. UserForm Prob
  422. ROW CELLS SHOULD HAVE VALUE WHEN WORKBOOK OPEN
  423. How long to open xls ?
  424. Excel Checkbox Help
  425. Displaying the value of a string
  426. automatic counting
  427. List all macro shortcuts in Excel
  428. Can Alt-TAB taskbar icon be changed for a Bullen FormChanger?
  429. DOS output
  430. Copy files to dbf files
  431. Vlookup macro
  432. creating pages with 1 click..
  433. min and max in a text box
  434. Compile Error: variable not defined
  435. Map XML Element
  436. Open a userform of one spread sheet with another spread sheet
  437. change named range
  438. Pause between sheets
  439. Delete string if string has only one item
  440. Subject: Grid view/spreadsheet on userform. Q for the MVP's
  441. Running an excel sheet which uses RTD calls as a service?
  442. Name error trying to use add-in
  443. OLEDBConnection Properties
  444. Is there an object property that will return the file type?
  445. Importing Files into Excel using VBA
  446. Setting up a formula
  447. Vlookup
  448. Pass workbook name to ActiveX DLL
  449. Text box in a userform to equal a cell
  450. How to force an application to be visible?
  451. Userform - Return Control Clicked
  452. Startup code and keys to break execution
  453. Multiple versions of Excel same Computer
  454. Sheet Add/Delete and Build Pivot Table on the Fly
  455. annoying pop up windows
  456. Can't get this to work
  457. Inserting some sort of sorting tag that doesn't display as text
  458. Sorting by Date when some dates span over several days
  459. Creating a range that indexes in a For loop
  460. ByRef Argument Type Mismatch
  461. Unable to unhide hidden columns
  462. Combo boxes go all funny!
  463. SaveAs CSV - Pipe Delimited
  464. Selecting all cells in a column between two cells
  465. Copy rows based on specific criteria
  466. Custom Range Method
  467. Function macro
  468. Delete VB code
  469. IF statement Question
  470. Sorting an indeterminable range of data
  471. Eliminate Variant Array Elements
  472. find multiple or by different words
  473. Ever wondered how to work with large text imports >256 columns?
  474. Passing values to a string
  475. record a macro
  476. TWO AMENDMENTS NEEDED IN MACRO - PLEASE HELP
  477. How to appy range names to formulas which use single cells in rang
  478. VBA ErrorBar method does not allow custom minusvalues
  479. Macro
  480. Request help with Arithmentic UDF
  481. Click Anywhere Do Something - WinAPI?
  482. How to activate InputBox Cancel Function
  483. Need a formula: If TIME is > or < than a cell enter TEXT
  484. Open Web page from a button on a form
  485. Worksheet Object Protection
  486. link click not working
  487. Problem referencing a cell using 2 variables
  488. Same function in add-in and workbook module
  489. Form buttons and Control Command Buttons
  490. Insert number of rows based on cell value, and fill
  491. Program to record where you've been?
  492. Excel is forced to close when run a marco???
  493. Run-time error '1004': PasteSpecial method of Range class failed
  494. VBA: Attach a variable to a range after executing Find command
  495. Different Results running the same macro??
  496. Recording a macro
  497. Count charts on Worksheet
  498. Get outlook to start a userform in excel.
  499. .all
  500. Macro to password protect and allow autofilter
  501. Changing color of a shape
  502. how to sort a row instead of a column?
  503. formula
  504. Set print area for all worksheet except first two worksheets
  505. search BuiltinDocumentProperties routine
  506. vba: attach a variable name to a selected range
  507. Splitting Paragraph into two columns w/limit of 256 characters
  508. Loop thru sheets copy and then paste in other sheet
  509. Grid view/spreadsheet on userform. Q for the MVP's
  510. Change event for multiple rows
  511. Macro lagging when copying columns to other sheet
  512. Hide VB Scripts & macro from user
  513. Export to XML when closing workbook.
  514. Column width & Row Height changing using macro/vb
  515. Update Excel Objects
  516. Is there a way to make the VBA code invisible to end user?
  517. How do you show UDF parameters while typing in formula in Excel?
  518. OPEN EXCEL FILE ACCORDING TO CELL VALUE
  519. MessageBox
  520. Close almost all workbooks
  521. Please help with simple function
  522. Turn "spell check before sending" off in Outlook from Excel VBA
  523. Import Data - from Excel
  524. comparing rows
  525. Scope of range names
  526. Retrieving custom document properties - Excel 2007
  527. How to name many rows by values in a column on the same sheet at o
  528. Displaying a Graph
  529. Generic Macro that can rows of zeroes
  530. Embedded Word Doc not printing completely
  531. Run Macro from a list
  532. Sorting a table of data into one column in ascending order
  533. How to convert all 3d references to normal references in a workboo
  534. How to write macro to set the chart scale min/max property?
  535. Macro to insert formula using cell reference/text - Urgent
  536. Put Value in a cell next to the active cell
  537. two criteria to match
  538. VBA question create Excel Object and run XLSTART startup excel
  539. Vlookup funtion in Userform
  540. Help with Application.InputBox(,,,,,8)
  541. Language Settings Issue
  542. Making Frames Visible (or not)
  543. A new Semantic Power Tool for working with Multiple Excel Spreadsh
  544. change font color by groups with VBA
  545. Option Button Code (Highlighting Rows)
  546. Button on a sheet
  547. Referencing Database Fields
  548. Subtotal data of various lengths without entering Sum(...) manuall
  549. VSTO BeforeDoubleClick edit mode
  550. Macro that uses a value as the range
  551. Way to print every worksheet in a workbook except the first two
  552. Need Help hiding rows
  553. 424 Error whem trying to change Visible property
  554. UDF ...VBA Formula built ...please help
  555. Run time error 91 when trying to add controls to a collection
  556. message box
  557. Error 80010108 when using FolioExportOCX from Excel 2007
  558. 4-5 digit numbers to display leading zeros totalling 6 digits
  559. Conditionally enable/disable a custom menu
  560. Excel 16 bit limitation
  561. Percentile on filtered range
  562. Watch not working
  563. Formatting An Existing Open Spreadsheet With A COM Add-In
  564. Error when cell A1 is not active and xlInsideVertical border formatthrowing error 1004
  565. Macros created in earlier EXCEL version, do they work in 2007?
  566. Copy, Paste and Print Cells from a Named Range
  567. VBA URL
  568. Copy Tab Names from Several Sheets and Copy Last Row from Same She
  569. separating cell values deliminated by a "/"
  570. Recorded Macro Works, Code Doesn't
  571. UDF help
  572. Enable Copy and Paste Functions in a protected worksheet
  573. Creating a graph - Screen sizes
  574. OR statement on macro
  575. IsEmpty function in VSTO
  576. CAN ANY BODY PLEASE HELP
  577. Insert Rows
  578. sort by grand total in pivot table
  579. Questions about opening a workbook in code
  580. Export from VBA form to Access
  581. Automation C++ code works for Excel 2003, not for Excel 2007
  582. Add-in load up
  583. Can I set Insert Options programmatically?
  584. Remove Pivot Table Borders with Macro
  585. Redimming 2D array to 1D while preserving the data?
  586. compare rows
  587. VBA & SQL
  588. How do I Designate a number with letters?
  589. Pop Up Message before printing
  590. Message box to prompt for file name upon save
  591. How to write binary data to a file
  592. macro help
  593. top 10
  594. Running a For function in a For function
  595. Macro to create PDF
  596. lost macros
  597. Converting Excel SS to a Web Form
  598. Trouble with a VBA code
  599. Add pdf attachment to new mail
  600. locking cells
  601. How to alter the code to copy to the same exact cell destination?
  602. Error 1004, pasting merged cells
  603. Citrix and FullName
  604. Coding to choose the previous completed cell in a column
  605. Database Workbook
  606. Excel formula
  607. Copying sheets to new workbook, merged cell issue?
  608. blank data when using macros
  609. Identifying a uniques entity composed of two columns
  610. OPENING SEVERAL HYPERLINKS
  611. Control a Table in Word From Excel
  612. different password protect for different worksheets
  613. PROTECT MACRO IN NEW WORKBOOK
  614. MsgBox FOR SELECTING WRONG FORMAT FILE
  615. Compare two sheets, identify values, calculate delta - Pls help
  616. Get values from 15 sheets in a Wbook
  617. how to setup web service reference in excel 2007 vba?
  618. Corrupt XIRR formula
  619. Error filtering for unique values
  620. How to find that Excel work book contain ActiceX control through c
  621. copy and paste challenge
  622. paste to word
  623. Excel 2007 VBA and Text Boxes
  624. How to Format the entered Numeric Values of a Excel sheet's column as Text
  625. Open other applications using code
  626. simulate clicking OK in msgbox
  627. InputBox - finding the input in a range
  628. Pivot tables wont work in protected sheet?
  629. CommandBar image remains in Clipboard after PasteFace
  630. Explain code
  631. VBA Project not close after file closed
  632. Can't call a subroutine
  633. Copy and Paste in Macro
  634. Need help copying certain cells from current row
  635. Issues when opening excel through access
  636. Setting PW Before Saving?
  637. Font size on ActiveX controls
  638. Culture problem with Excel english version
  639. Publishing a Range
  640. Set default date on calendar control
  641. Copy chart to new location
  642. Passing a string to excel from a C app
  643. Automate Pasting Charts from Excel to Word
  644. Format a sorted character string
  645. Password Protecting Sheets
  646. Message Boxes
  647. Determining what menu item called a macro
  648. Macro Limitations
  649. Auto Filter
  650. selection.cells(1).value
  651. Converting LOTS of xls to xlsm
  652. how to skip printing pages in exel by cell value
  653. Insert/Embed PDF File automatically via VBA
  654. Delete any Lables with "0%" value in pie chart
  655. simple print loop crashes
  656. how to dynamically get sheet name
  657. Help! Excel 2007 and Excel 2003 are not compatible?
  658. How to zoom in VBA
  659. outlook vba
  660. Help! What might happen if Excel spends a lot of time pasting?
  661. Add Controls to Control Collection at Run Time
  662. Pasting Selected Excel Cells into a Word Doc
  663. Check Boxes
  664. help needed. what kind of formula I need to use that I would....
  665. Re: Calculating the R2 from a scatter chart with Power trend line
  666. Access from Excel ADODB.Connection
  667. Merge 7 files to 1 workbook/7Sheets and then 1 sheet of the newworkbook
  668. Merging Two Sheets - VLookup?
  669. Dates & VB
  670. Update multiple textboxes on userform
  671. macro
  672. Multiple labels on userform 2 update
  673. Autofill 1 column with changing data and changing range
  674. Print area problem
  675. Breaking a Reference Error
  676. Slightly Urgent: Problem Resetting Chart Value Ranges
  677. proper case using Microsoft Office Professional 2003
  678. Using .Row help please
  679. Need macro to drag values down to blank cells
  680. macro to open file
  681. copy/paste to new blank sheet according to criteria
  682. remove blank cell from a range
  683. UDF behaving oddly
  684. Printing to PDF question
  685. Copying records to another worksheet
  686. How do I run code on startup before Excel re-calculates formulas?
  687. Create unique 'number'
  688. Survey Software
  689. vlookup function in VBA code
  690. autoupdate macro
  691. run macro on pivot refresh
  692. Count non-zero values in a Array
  693. Disable or lock page field
  694. Dcounta
  695. Closed File Still "Working"
  696. merging tables/columns from several of workbook into one workbook
  697. Need Help on populating a newly inserted row
  698. Onclick button actions
  699. Error: "The specified module could not be found" but DLL is in place!
  700. Where have my macro links gone?
  701. Using HiPortfolio 3 via VBA
  702. Delete values colored cells
  703. random numbers but normal distribution
  704. Pubslishing excel 2007 to MOSS with c#
  705. mirror table depending on cell value
  706. Enhance sub to copy cols of variable length into 1 col to snake results into other cols
  707. redim
  708. Immediate textbox validation question
  709. Date sheet first used
  710. If formula help
  711. date list in excell with e-mail notification
  712. Allow Edit Objects in protected sheets
  713. Excel 2007 Pivot Table Filter/Check Box
  714. What is wrong with this code? Screen capture and export as image?
  715. Macro does not delete all the required rows
  716. Runtime Type mismatch Error 13 when object not found
  717. Try Catch errors locking Excel
  718. Error on password protected sheet.
  719. TextBox Color Red if Less than 50
  720. Variable inside function range
  721. Ron de Bruin's Copy to Worksheets
  722. The difference between the enter key and .Calculate (perhaps Evaluate?)
  723. removing extra spaces in excel
  724. Automatically hide rows with 0 value....faster?
  725. Reference to Microsoft Outlook VBA
  726. Worksheet Event Problems
  727. Sum part of range passed to UDF
  728. macro
  729. Want to add a user defined selection
  730. find out if its a folder or file
  731. Random generator using a range with range frequency
  732. What's wrong here?
  733. If Begins With - Not Working - Please Help
  734. TextBox Value
  735. stacking data
  736. Page orientation - Upsidedown?
  737. Placing TextBox text in cell
  738. Copy data automatically from another workbook
  739. Using a UDF within SUMPRODUCT
  740. Assign xml map programmatically
  741. Add Border to the right side (xlEdgeRight) of a large number of co
  742. help! subscript out of range error when trying to return multiple values from function (as variant array)
  743. Re: Cell A1 to sheet name
  744. selecting more than one cell
  745. Re: Cell A1 to sheet name
  746. PDF basics
  747. tab indexing
  748. Userform Combobox Excel 2003
  749. Countif array
  750. Initializing values in a Listbox on a Form