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. Const?
  2. Using functions in string formatted cells
  3. fire an event; SelectionChange
  4. Worksheet_Change() and Range question
  5. Runtime error - goto
  6. Sheet name
  7. Converting Header Rows to Add'l Detail in Rows
  8. GetOpenFilename - Prevent delete
  9. Name work sheet
  10. Show Custom AutoFilter Dialog with VBA 2007
  11. Copy and Paste link between workbooks
  12. Problem with Excel add-in and .NET
  13. Difficult problem (for me !) Lookup or something that i need to use ???
  14. HTML Text retrieval
  15. How can I use this expression "=SUM(RC[a0]:RC[a1])" work in Excel
  16. CommandButton - Created using Forms, Not Control Toolbox
  17. Copy text from cell and paste it in a separate text box (contents tobe linked)
  18. Copy contents of a cell and paste it into text field
  19. Problem with sheets that mirror each other
  20. Range object does not support paste method
  21. date and time picker control in excel vba
  22. RE: Run-Time Error 3075
  23. VBA referencing disappears with 2007 upgrade
  24. Changing the value in one ComboBox also changes the value of anoth
  25. Excel 2007 & Custom Shortcut Menues
  26. Count values in Visible ROWS only
  27. Timer causes run-time error '6' overflow
  28. VBA Loop Code
  29. UDF to return as text
  30. Add number to a list
  31. Vlookup Error
  32. RE: For Next issue with repeated procedure
  33. Fix Column width in spreadsheet control?!
  34. image help
  35. Different Ways To Reference Ranges
  36. Re: For Next issue with repeated procedure
  37. DNS lookup in Excel
  38. RE: Vb Assistance
  39. For Next issue with repeated procedure
  40. Vb Assistance
  41. find match then change cell value
  42. Disable Minimize/Maximize button for Excel 2007 Application
  43. Autorun Add-in
  44. Very Slow Worksheet Calculation
  45. user defined charts
  46. xlsm SaveAs xls
  47. Spin button
  48. Select column that matches a value entered in a User Form TextBox
  49. Date Format
  50. 90 day reminder
  51. auto refreshing sheets
  52. Eliminate Taskbar updates
  53. Rename files with VBA
  54. Address Transposing
  55. Identifying anc saving workbooks from more than one Excel applicat
  56. Trying to convert text to number
  57. thiscell and udf
  58. Logging onto a website
  59. Controlling the number excel gives to charts
  60. Range error
  61. Static global varibale - where tu put it?
  62. Interupt code with message before it runs
  63. Declaration w initialization - for dummies
  64. At each change in data apply formula
  65. How to Connect a network Drive
  66. 2003 xls(macro) occured error when opening with office 2007
  67. count number of rows in 2 worksheets
  68. get number of rows
  69. Dynamic Data Validation
  70. Piping data to other office applications
  71. Read and write access database
  72. Read and Write Access Database
  73. User form Text Box & Combo Box.
  74. Running a report using a macro
  75. Excel automation, change Category (X) Axis Labels, VB6
  76. Clear Format problem
  77. RE: If *Total* make row white
  78. Some help with a workbook please
  79. Re: If *Total* make row white
  80. Re: If *Total* make row white
  81. Why do windows go blank?
  82. Macro Not Showing in Alpha List
  83. How to flush file buffers or ensure reliable writes?
  84. If *Total* make row white
  85. Does variable set to cell value automatically becomre cell value?
  86. How to overwrite data in file?
  87. Countifs for color format
  88. copy value only...Copy Destination:=Cells(3, 2)
  89. Creating a variable range in Visual Basic
  90. ending "html" or change
  91. Delete all rows where column A is blank
  92. Advanced Filtering Problem
  93. Programmatically copy Conditional formats from one cell to another
  94. Possible offset issue
  95. Copy named range based on variable
  96. multiple "IF" statements in function
  97. Writing Data to an External File
  98. Subtotals by Column
  99. Passing parameters to a Web Query
  100. Matching Columns
  101. Change cell value between EMPTY and X when i click on the cell.
  102. Make a Button Blink????
  103. copy-paste information from different workbooks
  104. Formatting Imported Data
  105. Re: Split workbook into multiple workbooks
  106. extracting data from a pivot table
  107. If Column M is less than 15
  108. Groupuing User Requirement
  109. excel image help
  110. reference an open instance of IE
  111. Embedded chart location address
  112. Call a cmdSend_Click macro; non-click interaction
  113. charts; myChart.SeriesCollection(10).Name; lots of quotes
  114. How do I add a function category
  115. action on open
  116. Match and Reconcile
  117. Insert a space in all blank cells of the first column
  118. GoToEnd Macro
  119. Excel hyperlink that links to web which opens a new Excel book pro
  120. Set workbook name not working
  121. Making a frame visible or not using a command button
  122. File grows
  123. Collecting data from multiple sheets
  124. Macro filter multiple criterea
  125. Help using indirect addressing in chart series
  126. convert longitude into time
  127. Publish embedded chart XL2007
  128. Format some, not all, text in a comment
  129. Worksheet Change Event - track changes
  130. Text labels on a Userform
  131. Find Total and insert one blank row below
  132. Opening Files
  133. Opening Files - Marcro
  134. Opening files - macro
  135. Opening Files - Marco
  136. Re: Formatting Col C based on data in Col B
  137. revise to not include attchmnt
  138. General question re Error Handling
  139. no attachment
  140. ChartObjects Insanity - Excel 2007
  141. question about excel formulae
  142. Color rows based on date in a cell?
  143. ModifyAppliesToRange
  144. Bundling Hardware Request
  145. Populate Combo Box with Access Table Data
  146. hiding columns; dynamic
  147. Remove a "0"
  148. vlookup is not the answer
  149. Linking Combo Box Values to Access Table
  150. Overstrike problem
  151. Formula for vlookup and then sum
  152. setattr
  153. Display a userform and have program continue
  154. finding next number in a sequence
  155. copying sheet name
  156. Macro to concatenate columns
  157. Microsoft Query is not importing all data from an excel file
  158. Locating my personal.xls
  159. Enter key functions differently after different macro behavior
  160. Application.DisplayAlerts = False does not disable alerts
  161. Page footer
  162. How do I calculate number of colored cells?
  163. Name of values
  164. I need an Excel Genius !!!!!!!!!!!!!!! Headers/Footer Changes
  165. User can't see Input boxes
  166. Using Range names in selecting chart series.
  167. VB Help
  168. Automatically opening file saved to someone "Documents&Sett' direc
  169. Catching check/uncheck event accross multiple checkboxes
  170. Hyperlink powerpoint object to excel range?
  171. command button controlling a range of dates
  172. Print Range
  173. How to ignore embedded linefeed in CSV quoted text fields?
  174. Excel 2007 VBA Pivot table fetch records
  175. VBA Excel data to SQL Sever table
  176. How to prevent list item selection
  177. Check for >0, then offset down 310, left 4, Check for = 0
  178. losing date format when referencing date cell on another sheet and
  179. Hyperlink from HTML to a specific Excel workshhet
  180. Using a Variable in a SORT statement
  181. Move Flagged Row(s) to a Different Sheet
  182. Embedded Chart protection
  183. Change jpeg Picture in LeftHeader
  184. Comparing to tables of data to confirm they are the same or not
  185. How can I specify more than 2 criteria in AutoFilter
  186. How do I Loop and Change Button Color???
  187. Find a vlaue, shade another cell
  188. 45 seconds to save a file, why so long?
  189. Userform hide help
  190. HELP: Display a message when one of the names is displayed in a ra
  191. find user's computer name
  192. Reset QueryTable error on empty text file
  193. Arguments within loop
  194. Using an iputted array across multiple worksheets
  195. Change Header/Footer w/ Worksheet Option Buttons
  196. Userform List boxes - editing - then option to save changes (or no
  197. MS Excel VBA Pivot table link cell fetch records
  198. Creating New Worksheets & Sorting Order of Worksheets
  199. Read/Write to OpenOffice
  200. Animated Clipart
  201. Excel 2003 (8316.8221) screen corruption
  202. Range.Value2 in C# (Excel 2007, VSTO 2008)?
  203. Macro to open a workbook as read only
  204. I have to compare two sheets for changes
  205. Syntax of Commands Created by Macro Recording
  206. Working with Excel 2003 from a Visual C++ program
  207. Fun with Userforms!!!!
  208. How to filter the QueryTable from a Web query
  209. How to obtain the row count of a QueryTable from a Web query
  210. Date format converted from UK to US format
  211. Detect Excel minimize and restore?
  212. Calendar and userforms
  213. Screen position of commandbar button in Excel 2007 ?
  214. Code condition
  215. Re: Compile Error using Dmax funtion
  216. Copy/Paste Controlled by Timer
  217. vba to convert htm tags
  218. Go to worksheet upon opening
  219. Prompt to select from a list in another workbook
  220. User Form Problem
  221. message box - title change
  222. Using custom charts with other computers
  223. Uaing custom charts with other computers
  224. compare two files and merge rows base on a matching word within thesetwo rows
  225. IE code
  226. Coloring a row
  227. Problem with Bob Umlas sub total code. Coming up with user define
  228. Find a value and color that cell
  229. next column
  230. Characters same length in column
  231. ListBox issue
  232. Use Scheuled Tasks to fire Event Code
  233. Compare two columns in a different worksheet
  234. Excel 2 web
  235. command not found when using excel VBA function format
  236. Pivot table - unwanted lines
  237. Specify certain length(characters) when defining a column
  238. Last used Column
  239. Userform - Title bar formatting options and other attributes
  240. Specify certain length(characters) when defining a column
  241. Specify certain length(characters) when defining a column
  242. Position Chartobjects in Chart sheet
  243. Change font and/or font size in headers, footers and body via VBA
  244. Height of shape
  245. If column contains a value - Error Trap
  246. Hidding zero values
  247. application.displayalerts
  248. Formula R1C1 in VBA - Strange Results (Dynamic)
  249. Closing FIle with Command Bar Button Problem
  250. Saving time on calculate
  251. Hide form page
  252. Find all Hyperlinks present in a sheet
  253. Calling a subroutine - how to?
  254. Problems with add-in after upgrading from Excel 2003 to 2007
  255. different color for duplicates!!! how?
  256. File Path
  257. Get Formula
  258. Copy Formula Down until last row
  259. Buttons in another window
  260. update links in Word from Excel
  261. Changing the text of a label on a Userform
  262. Pivot Table - Add calculated field using field number (index) vs n
  263. Test if a Userform is loaded or activated??
  264. File Path
  265. Sort problem (Excel 2007)
  266. File Path
  267. Keeping from declaring a direct path
  268. Printing Contents of UserForm
  269. Menu Maker and Excel 2007
  270. User Form Appears Blank
  271. Menu Maker and Excel 2007
  272. How to make a number indicat a persons name on another sheet
  273. Time formatting issues
  274. Changing "Office" theme colors
  275. Locked cell Change Message
  276. Waiting for an external app to finish
  277. listbox inconsistencies
  278. Help needed with 'Save As' dialog
  279. excel formats
  280. Enter code by a macro
  281. Re: Update to Access Multiple tables via VBA
  282. List Box - part 2
  283. Excel 2007: getItemLabel not working
  284. Trust access to the VBA project: Excel bug?, workaround required.
  285. Set Status bar back to "Ready"
  286. File calculates with each cell input
  287. starting Word with an Excel macro
  288. View Code for pointer?
  289. User form problems
  290. RE: Picture size increase/decrease in size using code
  291. Path and File
  292. Path and File
  293. File Path
  294. File Path
  295. File Path - Macros
  296. When "Save As" is selected
  297. Common dialog not registered
  298. Shorter way to do this
  299. Floating userform appears on task bar???
  300. Is this Multi-Search Macro Possible?
  301. Constantly loaded userform??
  302. How to save contents of cell range in an array?
  303. "Do you want to save changes?" question
  304. Re: Update to Access Multiple tables via VBA
  305. If no default printer Open Print Diablog box
  306. Sheets changing name
  307. Sheets changing names
  308. Password concern
  309. macro help on find and replace
  310. find number and replace after multiplication
  311. excel pivot tables
  312. Unique Problem?
  313. list box help
  314. Excel To Web
  315. XLT vs XLS
  316. Sort data from smallest to largest
  317. Excel 2007 Chart Colors
  318. fill a variable sized range
  319. Excel Query of Access Q
  320. Stopping warning message
  321. User Form Input Question
  322. Can I Have Beter Code For Search Than This
  323. Copy Range and Assign a Defined Name to the Pasted Range
  324. date of JPG photo file which is taken
  325. Workbooks.Open() error handling
  326. passwords - userforms - remembering password has been entered
  327. To Capture the time stamp on entry of a value in cell.
  328. VBA worksheet references
  329. VBA Digital Signature not working
  330. Clearing background color in printed copies
  331. Form load/initalise error
  332. Using a single cmdButton to perform different tasks
  333. All cell contents within a range of cells turns white if Sheet1!A1 =1
  334. Appearance of Controls misbehaving
  335. If Column T contains then
  336. charting, adding a random gridline
  337. Issue with QueryTable.Refresh Causing CPU to Spike to 100%
  338. concatenate formula result with text ?
  339. Where is the Treeview Control in Excel 2003?
  340. If Column T contains then
  341. Read and find
  342. Hyperlink Macro / Hide Tabs
  343. set rowheight property
  344. Convert cell contents to number
  345. UserForm + Dropdown
  346. Grid / Spreadsheet like control in 2007?
  347. Changing the Year in formatted Date
  348. Populate TextBox with Change Event
  349. Auto detect the range depending up on the input date.
  350. Next Function in Array
  351. Combine rows of data and use if/then with results
  352. Create a textbox that displays a list of possible items as we type
  353. Application defined or object defined error - Not Caused by Code
  354. Unwanted Calculation
  355. if workbooks exists delete
  356. Insert formula and copy to a range of cells above
  357. User Created Menu
  358. Excel limits question
  359. macro copy and paste
  360. Parameter queries
  361. Excel date / time picker control
  362. VLookup Formula's
  363. intersect question
  364. Calculate week from current day
  365. Export(Save AS) workbook without macro on browse location
  366. Matching records based on multiple columns
  367. Crash of Excel 2007. Prog. only wil work after manual start in VBA
  368. popup warning
  369. How to update all headers in Excel
  370. Rename a .txt file via Excel macro
  371. summing text boxes but do't include disabled ones??
  372. Command button - compare computer name with a pass code
  373. Deriving a name from variables
  374. Run macro upon opening document
  375. Referencing a cell in another sheet through the use of variables
  376. Skip the Zeros in a chart
  377. Exit For statement in nested For ... Next blocks
  378. Move row last on change of value
  379. Transpose 100 sheets in a directory automaticaly
  380. Create a smart textbox that display a list as you start typing in
  381. excel language version
  382. CountIF by Background Color
  383. How to Filter a column & Indent all but the 1st header record
  384. Dissable Workbook_Open Event in certian cases
  385. RE: Hoping a VBA master can help with this...
  386. Set an Object
  387. Help setting a File Name
  388. Format Shape Using ThemeColors
  389. getting info from a pull down menu and looking up column to get co
  390. Excel 2007 Chart SeriesCollection(1).Interior.ColorIndex
  391. stopping a macro
  392. macro to exit design mode
  393. Re-protect sheet
  394. Multiple Worksheets Protection
  395. Command button - check listbox contents before activating?
  396. RE: pivot table - date problem
  397. Locate Value in a set Row, with Dynamic Column
  398. Progress Bar
  399. xl2k vs xl03 code difference
  400. Saving Multiple Tabs as CSV
  401. disable CUT in Excel
  402. Excel to Visio
  403. Lookup Function in user form
  404. Format text box with check box
  405. VB Code
  406. How it must fix ?
  407. How to check a list for single letters between text
  408. Combo box listing in same colour as list
  409. Want to blank some cells when an AutoFilter is active.
  410. Reference Global vars in cell formulas?
  411. Merge Append all sheet
  412. Get name of active sheet
  413. Copy range with offset
  414. How to reduce excel file size having pivot tables
  415. what does pvargColumn and pvargIndex mean?
  416. VBA Macros and Windows 7
  417. Copy selected columns from .xls to a .txt file question
  418. how to close Printer status bar
  419. Call up computer name
  420. Data connections properties include column headings
  421. Trapping Error Message
  422. Refer to a named range
  423. rows in a table?
  424. Finding last row
  425. Format Center Header
  426. Find function for a listbox table in a userform
  427. Send Element to Back
  428. vbe-disclaimer
  429. Excel found unreadable content
  430. Deleting rows triggers the macro :(
  431. Find Reference Workbook with Code
  432. Take out dates that are not current month
  433. Ribbon toggle button issues
  434. How does Excel Know Where a Referenced Add-In Wbk is Located
  435. Notification of replies
  436. Trouble with toggleButtons on ribbon
  437. Disable/enable recalc
  438. Named Range, hidden row, auto-filter & macro buttons
  439. FTP File Size from wininet
  440. FollowHyperlink
  441. RE: Code to copy cell values from one sheet to another
  442. workbook file name
  443. How to get rest of characters after last certain character?
  444. FINDING DUPLICATES - CROSS REEFERENCE 2 COLOUMNS TO FIND UNIQUE EN
  445. sheet name
  446. Excel VBA SQL Query Filename
  447. Comments - with unprotected sheet
  448. Worksheet_Change() and range question
  449. Case statement comparing two ranges
  450. vlookup: file moved or new one. keep cache
  451. Make Userform Caption equal textbox contents
  452. Location of SQL in an external data connection
  453. Email excel - 1 sheet in body 1 attachment
  454. Dreaded Runtime Error 1004.
  455. Mid and Left Statements Issues
  456. Shakersort & my modifications that don't work :(
  457. Copying Data between Spreadsheets based on a rows value
  458. Autofilter in a macro
  459. vba for find last column with hidden columns in worksheet
  460. Summary Grid
  461. FindTextInsertCol Excel
  462. Remove double quotes from text file
  463. Converting/inserting values, without changing the other contents.
  464. Create array
  465. Get sheet name in any workbook
  466. Goal Seek Problem
  467. set on / on autocalculation
  468. Why is Access VBA syntax different from Excel syntax?
  469. Option Buttons
  470. copy worksheet
  471. Calling a Macro from multiple places in Excel sheet
  472. RE: HELP: Syntax error (missing operator) Query Expression
  473. Sorting columns
  474. How do you Determine if a Worksheet is protected?
  475. Deselect a single sheet
  476. Help with Immediate Window
  477. Re: Clear check boxes?
  478. RE: Clear check boxes?
  479. Compare entries in 2 worksheets and list what does not match
  480. Historical Stock Close Value
  481. Default entry in dropdown on Ribbon
  482. How to apply data formatting to a chart
  483. Spreadsheet calculation problem
  484. Clear check boxes?
  485. RE: church visitation
  486. HELP: Syntax error (missing operator) Query Expression
  487. Re: More then 1 Private Sub Worksheet_Change
  488. Out of range problem - I'm stumped...
  489. Re: More then 1 Private Sub Worksheet_Change
  490. Re: More then 1 Private Sub Worksheet_Change
  491. Re: Automatically Spell Check Before Printing
  492. RE: concatenation
  493. Re: Automatically Spell Check Before Printing
  494. Concatenate text from columns
  495. Position of a Shape
  496. RE: Testing for formula or value (constant)
  497. Testing for formula or value (constant)
  498. Automatically Spell Check Before Printing
  499. fixed column data
  500. RGB fill color not right
  501. Array problem
  502. **finding duplicates from multiple columns and highlighting**
  503. Macro Help
  504. RE: concatenation
  505. Run-Time Error 1004/ unable to set the hidden property of the rang
  506. including references; how portable?
  507. Set a reference to Microsoft VBScript Regular Expressions(vbscript.dll)
  508. RE: concatenation
  509. Identify application version (not Excel)
  510. Use spreadsheet cells for global variable space?
  511. Pass variables to Worksheet_SelectionChange
  512. Open password protected ppt files
  513. How to calculate Yield using Yield Function by C#
  514. Convert cells reference to string reference??
  515. Add a comment when cells are changed
  516. .LookIn problem 2007
  517. SOS! how do I write a customized function to do multiple-value lookupin Excel 2007?
  518. Paste value in new workbook
  519. Simple code question
  520. XLSM to XLS conversion
  521. Checkbox click margin suggestion
  522. how to get the format of this cell right?
  523. Finding the last column
  524. SUMPRODUCT troubles
  525. Search always ends in a find, but should not
  526. Return All Sheets to Cell A1 before save
  527. Add row dynamically
  528. Userforms - automating the naming of frame and page tab captions
  529. DateSerial vs Date??
  530. Calling Crystal Ball Predictor from VBA
  531. Run MS Access macro from Excel VBA
  532. Received .xls with macro I can't find.
  533. FileDateTime
  534. What is a user form?
  535. Worksheet Crashing Excel
  536. Conditional Formatting not recalculating
  537. Userforms - listbox gridlines?
  538. Custom filters that filter formula results?
  539. Have we set a Precedent??
  540. Deleting sheets
  541. Attempting to call a sub from another wb using a Userform option b
  542. Rows in named range?
  543. insert data after page break
  544. Insert Row and Formula
  545. drop down menu
  546. empty arguments recalculation
  547. Problem getting Excel formula to Calculate
  548. Excel Number Formatting
  549. Run Macro button after info is entered in a cell
  550. Moving 2003 Custom Menu to Quick Access Toolbar
  551. separate string into letters and numbers
  552. XLStart File doesn't open when Excel Opens
  553. Data Entry very slow ... Slow to start WOrksheet_Change
  554. Excel Macro to Populate table from Data
  555. User Form to Create a Pivot Table
  556. UserForm loaded twice in VBA Project Explorer
  557. In Excel, comments cover the data line. Can it be moved?
  558. scaling a range
  559. Getting the address of 'MyDocuments'
  560. Identify and Paste Down (autofill) a Formula- Help Please...
  561. Not to run macro if row 1 selected
  562. Error 1004 opening workbook 1004
  563. how to choose a part of the text in a cell???
  564. Import Text file Data into Excel Sheet
  565. VBA code to delete cell contents
  566. Alternate way to refer to sheets???
  567. VSTO Excel 2003 to VB 6.0 Type Mismatch
  568. Export Data from Excel into existing Table in Access
  569. IS there any short cut key to select all shapes
  570. VBA to create series of workbooks need to add code to skip creating areport if no lines meet criteria
  571. Scheduling
  572. Vlookup with Reference cell from Sharpoint
  573. Copy and Paste Formula from ActiveCell to cells in 13 columns priorto the active column
  574. Checkbox value in a custom ribbon
  575. Absolute to Relative Referencing
  576. empty arguments
  577. hyperlink button on a userform
  578. Functions & Formulas
  579. Pre-select visible sheets in listbox
  580. Can't set column width
  581. Reset Color Scheme
  582. Importing 23 Excel Datafiles to one Excel Datafile at The Click OfA Button
  583. File Save Properties
  584. How to move down cells...
  585. Excel 2007 Chart colorindex?
  586. Retrieving values from existing worksheet
  587. Save file in XL97 and 2003
  588. Check box to change the format of a text box
  589. sheets that mirror each other
  590. Using functions and subroutines in other modules
  591. pivot table connection access
  592. Show a named range within a label (not VBA)
  593. VBA code to write current workbook to file
  594. listbox - code to adjust column widths
  595. listbox -shows table of information - option to select and edit ro
  596. Combobox will not show list
  597. office 2007 scroll thru the items in a cbobox in the ribbon
  598. Active Cell problem
  599. Nested if/and
  600. .cells reference?
  601. Forms
  602. SpinControl on PopUp CommandBar ?
  603. Problem with "Application.Goto Reference" code line
  604. new excell will not read old excell file
  605. DDE Links
  606. How to fix the code for macro?
  607. Absolute value
  608. RE: "Paste Special" does not work??
  609. Error 400 in VB code execution?
  610. 2003 & 2007 Differences in Locking Cells Syntax
  611. RE: Data in f a Merged area
  612. Help with OptionButtons on a Userform
  613. Editing multiple controlsource references
  614. Data in f a Merged area
  615. Preserving number format in userform textbox
  616. Re: "Paste Special" does not work??
  617. Re: Looping through TextBoxes
  618. Add to an Existing formula in a Cell using VBA
  619. putting a picture onto a userform without using the vba window.
  620. How can I rewrite IF IsError Function to Work in VBA
  621. Looping through TextBoxes
  622. Overriding the menu "Save" option?
  623. Set sheet viewpoint on workbook_open()
  624. "Paste Special" does not work??
  625. Activate a moacro subroutine from a userform command button
  626. Pivot table warning dialog suppression
  627. Pivot Tables - refresh from Userform command button
  628. Email a Merged Worksheet or just required cells
  629. Re: Breaking One workbook into many Tabs
  630. building array
  631. Re: Breaking One workbook into many Tabs
  632. Breaking One workbook into many Tabs
  633. "Flase" overwriting value in cell...want to preserve existing valu
  634. Re: delete rows in a given range
  635. Combine Ranges to Draw Borders Issue
  636. RE: Increasing alphabectically
  637. RE: delete rows in a given range
  638. Re: delete rows in a given range
  639. Re: VB excel help needed
  640. Re: Increasing alphabectically
  641. Removing duplicates
  642. breakpoints
  643. Error on Autofill
  644. delete rows in a given range
  645. Increasing alphabectically
  646. Update
  647. [VBA] Dynamic target stock
  648. Re: VB excel help needed
  649. VB excel help needed
  650. Checking to see if a user form is hidden
  651. Re: Best book to start Excel Visual Basic?
  652. Best book to start Excel Visual Basic?
  653. Create a public variable
  654. empty data from a pivot table
  655. Proper VBA code to open Excel template
  656. Append name in the same cell with ' '
  657. How to code the macro?
  658. Autofill Based on a Changing Column
  659. activate pivot tables from a userform
  660. Cell Values Not There ???
  661. Run Time Error 13: Type Mismatch
  662. Pivot Table not pulling all fields or data
  663. count cell with background color 36
  664. UserForm show question
  665. Compare two arrays
  666. Newbie with a desgin question
  667. Re: Use VBA to change row height or width??
  668. Use VBA to change row height or width??
  669. Extracting data from one sheet unless it is also on a second works
  670. variable variables
  671. create sheets from data
  672. Sum column with count formula
  673. Save As without VBA project
  674. Indirect addressing
  675. Accessing Named Ranges
  676. How can I define my own Primary Key in Excel?
  677. Extracting names and titles
  678. Re: Delete Rows from sheet 1 from values in sheet 2
  679. Another Error Handling Question
  680. Keyboard shortcut for add-in
  681. Data Validation. Multiple.
  682. Want a Macro for Date
  683. save a copy
  684. Verify range is square
  685. This is probably something really simple!
  686. Create Named Range for each unique value
  687. VBA equivalent for Excel "indirect()" function in UDF
  688. Copy /Pastespecial Textboxes
  689. VB to get to top of page
  690. Duplicate procedure in other sheets
  691. Need help developing a Excel VBA Macro to Vaildate data entered intoa textbox
  692. find a word in sheet
  693. Copy and Paste Loop
  694. Skip password protect files and open non protected files
  695. Wait for action
  696. get complex data from other xls file
  697. Adding shapes to worksheet
  698. RE: Converting 2007 to 2007??
  699. Date conversion doesn't make sense
  700. Sheet selection on Autoclose
  701. When useform is openning, I cannot open another workbook.
  702. Updated Calendar Tool (No Macros)
  703. RE: Macro to Un Hide filtered rows
  704. RE: If(vlookup statement
  705. Converting 2007 to 2007??
  706. RE: Help with Excel 2007 Interface programming
  707. Re: Formula throwing up an error
  708. RE: Formula throwing up an error
  709. Macro to Un Hide filtered rows
  710. How do I create a TextBox on a DialogSheet in VBA?
  711. Want to Change Range Selected in Formula
  712. Formula throwing up an error
  713. Using VBA to change Excel layouts
  714. Re: smart tags
  715. Start up file doesn't open
  716. Quotes in a csv file
  717. Re: How to Sort Merged cells for worksheet?
  718. smart tags
  719. How do you send data to the same row of a text file everytime?
  720. Capture data from cell before Enter
  721. If(vlookup statement
  722. I need help with VBA and a CSV file output
  723. Show userform at spreadsheet open
  724. .PrintQuality = 600
  725. How to Sort Merged cells for worksheet?
  726. Help with Excel 2007 Interface programming
  727. Grouping rows with the plus/minus icon in the first row
  728. ADO connect mysql
  729. RE: Rows().AutoFit starts a calculation, but Columns().AutoFit doesn't
  730. Loop without Do
  731. RE: Macro to import external data from Access query to Excel
  732. RE: Worksheet Ref.
  733. Rows().AutoFit starts a calculation, but Columns().AutoFit doesn't
  734. Macro to import external data from Access query to Excel
  735. Worksheet Ref.
  736. add customui ribbon tab to a existing workbook
  737. Count occurrences of filename in column
  738. Calender sizing
  739. Re: Using String as Code for new Module
  740. AutoFitMergedCellRowHeight Limitation
  741. Using String as Code for new Module
  742. Pivot Table Formula
  743. Marco help - emailing
  744. Formula assistance
  745. MACRO help
  746. AUTO SUM ONLY SPECIFIC COLORED CELLS BY CONDITIONAL FORMATING
  747. Macro Help
  748. Excel 2003 - Macro Help
  749. to make column letter dynamic in charts
  750. Convert column # to the letter of the alphabet