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. Userform Combobox Excel 2003
  2. Countif array
  3. Initializing values in a Listbox on a Form
  4. Library Not Registered
  5. How to read settings from xlDialogPrint
  6. Code help - search / copy-paste
  7. Colors Palette ActiveX
  8. Delete Consecutive Rows if counta(row #) is =
  9. Sort breaks when columns are move around
  10. Cell Selection in Macro
  11. Filter - Just like Access
  12. assign filter inside macro
  13. Help with calling an Excel program in a Excel cell
  14. Excel 2007, I write macros in 2003 is 2007 similar for VBA? Pros andcons please
  15. SUM does report correctly
  16. Content.MSO error
  17. CopyPicture on a Shapes range
  18. use macro to copy formula with value and not formula without value
  19. Clear Row
  20. Excel Charting with Pivote Table Data
  21. Function procedure too long
  22. Excel 2007 Transposing Multiple Columns
  23. Pie Chart
  24. Sub to compile data from col A in many identical sheets
  25. Default ID and passord using macro
  26. protecting multiple sheets
  27. UserForm_Initialize is not recognized??
  28. How do I change the row/column format in a macro to beyond letters?
  29. plotting data in separate window
  30. Re: Collection of Ranges and Arrays
  31. Need help with a formula
  32. COPY/PASTE to body of email the format of Excell cell
  33. Color Cell
  34. resetting a listbox after a macro
  35. LOG FILE RECORDING USERS TIME
  36. Vlookup and Type Mismatch
  37. Calendar Object in Visual Basic
  38. find a "." then
  39. How use AutoFilter function to query the right range of excel data
  40. Select Non Contigouos Ranges
  41. Delete range of Worksheets
  42. Repeating the same routine
  43. HELP=>VB 'File Already Open' ERROR (run-time 55)
  44. inputbox
  45. How can I reduce repetative code
  46. .ShortCutText in menus in 2007
  47. Managing list using dates!
  48. vlookup to a table on a website
  49. timer
  50. Repeat
  51. Re: Excel crashes when I add VBA code programatically<a98bb77b-c60b-4bbe-b5c2-dcd28125ea02@k37g2000hsf.googlegroups.com>
  52. Rowsource from another workbook
  53. Calendar question
  54. tab colors in 2003
  55. Getting Data from Web - where the URL is the value of the active c
  56. find files and open db
  57. RE: List help
  58. Excel2007; workbooks.count is not counting all open workbooks
  59. Pop up
  60. Find Macro
  61. Error Copying File or Folder message when copying file to CD
  62. VBA code for Chart with x and y axis
  63. VBA Project to the Specific Computer
  64. RE: Extract top 5 elements from table
  65. Re: number of lines and characters in a text file
  66. refresh a folder
  67. Re: Extract top 5 elements from table
  68. How to followhyperlink to a folder with a minus sign in the name
  69. last used row.
  70. save as macro for same file name
  71. Workbook code to Module Code
  72. Multipage error
  73. Data Entry for 50 Rows only
  74. Hiding / locking access to VBA code
  75. Formula to reference another sheet using a string in a cell
  76. Object Variable error
  77. RE: Example Formulas
  78. Return to active cell after sort
  79. Function to read text file; find string; delete same before import
  80. Setting Cursor Active in Cell via VB Script
  81. VLOOKUP - when source empty, get "0". Change to complete emtpy?
  82. compile error with Mid() function
  83. Accessing Remote registry in Excel
  84. Locking Macros
  85. MatchLast function
  86. Saving data in pull down lists?
  87. Help with this marco
  88. One item in alt+Tab dialog per Excel Instance
  89. Adding a counter to a variable name
  90. Creation and property manipulation of Control Checkbox using VB
  91. Sequential numbering for forms
  92. Scenario Manager question
  93. Advice needed on autocalculation
  94. Pivot Table Drill-down click opens another Excel Doc
  95. Extend values of a chart series
  96. API for a user to select a folder?
  97. with, end with
  98. Application.ScreenUpdating
  99. Create Named Ranges (Headers) - then using range name in formula
  100. ADODB Problem with transferring data from Excel to Access
  101. detect empty rows or columns
  102. How to check sheet text for UNICODE?
  103. Close Shell
  104. Print Non-Contiguous Ranges From User Input on All Worksheets
  105. Select only columns
  106. HELP!
  107. Multiple Criteria for CountIF
  108. stuck at a loop
  109. Inserting Bold text into a cell
  110. Signing Code
  111. Help with excel 2003 formula
  112. Assign and clear value to unlocked cells in a protected sheet
  113. Solver -Macro
  114. Macro to put data below data in a and b from columns c and d
  115. Why am I getting run-time error '3256' when Excel workbook is shar
  116. Print Macro Function
  117. Why am I getting run-time error '3265
  118. Re: Hide non-contiguous cells
  119. Copy & Paste Named Range Contents
  120. Macro for Removing Characters
  121. VBA and Excell – really need you help
  122. Copy rows where cells contain red and black font.
  123. Save As
  124. Convert text to number
  125. Re: ComboBox
  126. Last improvement in my project
  127. Excel Sheet Always at Top
  128. multiple rows need distinct value and adjacent row
  129. webbrowser object causes crash on sheet change
  130. Adjustment to count cells (in range code)
  131. Proper way to create new macro
  132. Dynamic range generator
  133. Problem when Combo box has linked cell as a number
  134. Copy selected macro(s) to a different workbook
  135. string and numeric
  136. SetFocus back to textbox after exiting
  137. how to open visio file by Excel VBA
  138. Conditional Cell Lock
  139. Creating further drop down lists after a selection from a list
  140. compile error
  141. How to Cancel the Protect of Excel with VB and save it with a new password again
  142. Developing Macros
  143. Stopping Outlook alerts from Excel when emailing
  144. Which is more efficient?
  145. Streamlining my code
  146. Extracting Data out of a string
  147. Can you set up an automated counter in excel...
  148. how to test if an object is dimensioned
  149. Macro to hide empty worksheets
  150. Asking user to continue?
  151. Excel 2007 ActiveChart formatting erases graph
  152. Excel4v API behaving differently in Excel2007 vs. previous version
  153. Trying to get a macro to run when cell selection changes.
  154. Getting text string into userform
  155. Excel 2003 crash after install XP SP3
  156. Transposing data into new format
  157. Check for unnecessary Public variable declarations and duplicate Set statements
  158. Can Hyperlinked Images Be Converted?
  159. Really need some help - Creating a table without manually typing in1000's of cells
  160. macro comparing two different lists
  161. Need to know syntax of SQL.REQUEST Excel statement for SQL Server
  162. RE: Command Button Caption - VBA
  163. All macros have stopped working
  164. Make all variable values in a Array equal to 0
  165. LOGIN ID AND PASSWORD
  166. Named Range Collection
  167. In cell drop down type ahead
  168. selection_change adding text to target
  169. Merged Cells Question
  170. Hiding/Unhiding Rows in a worksheet based on the value of a checkbox.
  171. SumProduct with options
  172. macro to make current date remain fixed
  173. Select multiple ranges of data
  174. Marco for printing to file/saving to file
  175. Using combo box
  176. Complie error: Wrong number of arguments or invalid property assi
  177. Help with writing macro
  178. Show all data
  179. How do you do a range selection dialog like those many in Excel?
  180. Remove SubTotals Confirmation
  181. User Form Text Box - auto delete prompt text
  182. Run time error
  183. Expand a range
  184. Search & Replace macro
  185. Using - Private Sub Workbook_Open()"
  186. Macro to copy current worksheet to pre-defined wookbook
  187. Modules to be used for several different spreadsheets
  188. Looking for a way to export to tilde (~) delimted text format.
  189. Autofilter show all
  190. Edit entry in one cell dependant on another cell
  191. Application.Run, doesn't return to calling procedure
  192. Assigning cell value to range variable
  193. Saving Problem
  194. Looping and saving pdf
  195. Variable as subject of SET
  196. Permission denied when adding script object (seems Excel bug)
  197. Print Screen
  198. Returning values from OnAction
  199. Find & Replace
  200. Find "386", but not "386c"
  201. Run-time error '9' - doesn't occur when unallocated array is Watch
  202. VLookup problem
  203. Setting range using vlookup
  204. Add pages to a multipage
  205. Is there a way to auto convert a time stamps to Eastern Standard T
  206. Saving changes to Excel file when using VSTO
  207. slideshow
  208. addin menu button xl2007
  209. Macro Workbook Copy Query
  210. copying data from one worksheet to several based on criteria
  211. SCROLL ON CELL CHANGE
  212. Open a .csv file, parse text and display on more than one sheet
  213. Automatically Accept Replace Values in Text-to-Columns macro
  214. Toggle Button
  215. Create multiple worksheets
  216. Is there a auto-graph generator functionality in EXCEL/VBA? Hi all,I am not sure if this could be done, but in my mind, I want the folllowing
  217. Interrupting long calculations in Excel? Hi all, I am having a verylong calculation in Excel using VBA. Of course I know I can hit ESC orCTRL+BREAK to interrupt the VBA program. But I found due to too long runningprocess, the Excel window stop to
  218. Excel 2007 - When running macros
  219. Personal workbook
  220. help writing a macro please!
  221. Error Copying Range/Cell with long Text String
  222. Populate Cells With Range Via ComboBox
  223. update column
  224. Frustrated with learning add command code...
  225. Please refine this to use lowercase instead of Proper
  226. Using Find over entire workbook
  227. Excel macro - personal folder
  228. Listbox Initial Values
  229. Filters - I want to delete single addresses and leave all the dupl
  230. filter in a filter
  231. Assemble monthly periods between dates into a string
  232. Copy Without Code
  233. userform incorporates string data
  234. Need help with formula to lookup number based on multiple criteria
  235. VBA chart formatting
  236. Days in a month?
  237. Update master spreadsheet from various single spreasheets
  238. Data sorting problem
  239. Application.Run "[TemplateName].[ModuleName].[MacroName]
  240. Help Needed
  241. Apply same filter to all sheets in a workbook
  242. VBA - Child process - Redirect STDIN handle
  243. Update validation list based on end date
  244. Find a Cell Value
  245. Assign Cell "B5" Value to Macro (activation function)
  246. Test for Folder Path. if it doesn't exist, Create it
  247. Page X of Y in Worksheet
  248. using Addin in C# To Change a Range of Cells
  249. Odds need period, evens need semicolon
  250. Open files which contains given keyword
  251. Access Key
  252. code to attach a macro to a newly created worksheet
  253. Cancel an exit
  254. launch internet explorer from excel
  255. Finding a string of 7 numbers in cell contents
  256. Loop throught closed workbooks and break a specifc Link in each.
  257. How to Stop a Macro if a 'Call' macro was used
  258. data structure help
  259. My first year trading
  260. Dim cells in a sheet as a range
  261. stopping a print macro
  262. Re: Web Query
  263. Excell 2007 performance issue
  264. linked worksheets
  265. Copy problems
  266. formula for high lighting rows
  267. If cell in column C = "insert" then OFFSET+CONCATENATE
  268. How to delete QueryTable in VSTO?
  269. outlook email body formatting issues from excel vba
  270. Sort Worksheet Records By Column
  271. Console.Writeline output in VSTO
  272. Code does not seem to work, but it should.
  273. Tally operations question
  274. vacation formula
  275. Reorder the columns in Excel
  276. Insert New Sheet De-activates Current Sheet VBA Workaround?
  277. Help with a nested IF statement
  278. Can I increase the limit of of nesting levels allowed in a file?
  279. 'Run' return value
  280. Mirror value to another cell.
  281. Accessing VSTO Workbook Methods
  282. Multiple selection in listbox
  283. Go to a particular Cell -Date
  284. Clear listbox
  285. Listbox Scrolling
  286. Disabling Pop Up Menu Options
  287. formatting issue
  288. Need VB help
  289. current IE window using VBA
  290. Wont keep changes
  291. Adding row data from one Excel file, to another, when not existing
  292. Populating IF Formula while looping - trouble with index interpret
  293. DTPicker Date format
  294. find and copy from a list
  295. HELP replacing cell references in equations with $X$Y format
  296. Help with syntax in line of code
  297. New worksheet position
  298. Excel VBA toggle Outlook '03 Word email editor on/off
  299. late binding - creating worksheet object
  300. Multiple Macros at once different output
  301. ActiveChart, Data!R code
  302. stuck with my code !!
  303. Date variables and empty cells?
  304. Mapping the macro path
  305. Where do you learn this stuff
  306. Lookup and copy paste
  307. Help with Cut-Delete-Paste to other sheet
  308. SYSDATE in Sql vba Recordset error
  309. how to copy as I type and then lock?
  310. Delete Row based on 2 duplicates
  311. Clearing Variable Values in Array using For...Next
  312. Bold Last Row
  313. Using ADO to get data from Worksheet in Same Workbook
  314. Using ADO to get data from Worksheet in Same Workbook
  315. Using ADO to get data from Worksheet in Same Workbook
  316. Linking a ComboBox
  317. C# Form exposed to Excel does not like CalculateAll (F9)
  318. SaveAs xltm programmatically
  319. lookup a number based on multiple criteria
  320. RE: Am I missing something?
  321. How do you copy a pivot table into a new file and have it work?
  322. Direct data tracking
  323. Color Count Macro discrepency
  324. 2008 East Coast US Excel User Conference
  325. Mailmerge with excal as datasource
  326. Move Row if cell is not null
  327. Limit worksheet for 50 rows only
  328. Checking for conflicts in schedule
  329. Input Validation using VBA
  330. Summing a dynamic range between two points
  331. Format number to fixed decimal place
  332. maintaining cell references
  333. Formula error
  334. Direction of looping through objects
  335. Sorry off topic but what is Ctrl R in Excel?
  336. Loan Schedule - Specific Requirements
  337. how do i create hyperlink from range of filename
  338. Run time Error for VBA Project,
  339. Re : Excel Code to Reset a Shape
  340. Can't get the If and Else statement correct
  341. Record Macro in Excel, run macro untill last column
  342. How to insert subform in main form in excel 2003
  343. Re: How to inhibit save, allow save-as?
  344. How to inhibit save, allow save-as?
  345. Date from DTPicker
  346. Sumif Macro
  347. Fast record searching in array
  348. event procedure
  349. Maximum number of variables allowed in Excel VBA
  350. Overflow error when using FOR loop
  351. A simple question for anyone but me
  352. Automation of COM objects in Excel
  353. Replace a word with hard return code
  354. Pivot table row labels
  355. grouping rows
  356. Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene
  357. Create input box with 3 fields
  358. Access a VBA global variable/constant from a worksheet cell
  359. How can I verify if "Trust access to visual basic project" is chec
  360. Multiple text in range into single column
  361. Nag screen pop up
  362. navigate to different link
  363. display columns
  364. selecting cells dynamically (range/cells...)
  365. Determining the nth Column
  366. Opening PowerPoint shape in excel
  367. Opening PowerPoint object in Excel
  368. range(cells(...))-question
  369. Offset & Select
  370. how do i keep sort settings?
  371. Copying set of cells with a condition
  372. Count a column "unique value only"
  373. Loking Cells by Date
  374. Custom Form: Copy from one list box to another
  375. changing a macro so it's not cell specific
  376. Make all variable in Array = Empty each click of a Button on Userf
  377. Re: Avoiding nested if statements?
  378. Re: Avoiding nested if statements?
  379. Macro to open up two maximized windows side-by-side?
  380. Re: Avoiding nested if statements?
  381. MACRO TO GET COMPUTER ID IN CELL
  382. a solver problem
  383. RE: User Form
  384. RE: User Form
  385. do while, do until?
  386. DTpicker number format
  387. Help, can you have two arrays?
  388. Proper way to call/pass excel.shape as a parameter?
  389. The Developer Ribbon Tab - buttons inactive
  390. Run Time Error 424
  391. Update text box in real time
  392. Pivot table filter fields
  393. Active cell chart
  394. Emailing multiple excel files to multiple recipients
  395. Code to loop through the Workbook Links
  396. "Object Library Invalid" Error occurring...why?
  397. Re: Change based on date
  398. checking if a combiantion of values exists on a different row
  399. How to include Excel charts in Outlook email *body* with VB
  400. Creating an "F" Statement
  401. R/T Error - Why?
  402. A1:B(xlDown)?
  403. sorting multiple-area selection
  404. Eliminating non-matching cells
  405. VBA Code return value in Excel
  406. Sheet Protection & Password
  407. Weighted Linear Regression
  408. copy only value and not formula
  409. ComboBox problem - Excel 2003
  410. How can i set the following variant to be a Tuesday on an Excel calendar
  411. In VBA, how do you format selected code all at once?
  412. RE: 1004 Error with Range/Array
  413. Problem creating a named range
  414. RE: 1004 Error with Range/Array
  415. RE: Do Until using date
  416. email vba help with attachments
  417. When a time goes into the next day, negative hour error
  418. What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu
  419. Re: Function going wrong
  420. how to highlight changes in my data from one block of cells toanother block of cells?
  421. Saving workbook to a website
  422. Displaying a flash screen image on start-up
  423. handling #Div/0! errors
  424. Running macro on a protected sheet
  425. If Pivot Table Exists, Delete on Close
  426. Listbox refreshing
  427. Open Word file by Macro
  428. Pasting stuff into new workbook
  429. How to Export all Macros & Forms from vba project.
  430. Excel summing question
  431. 'Uncheck button'
  432. 'Uncheck button'
  433. error message
  434. Formula
  435. add new rows
  436. Nissan Website
  437. controlling sheet number not sheet name
  438. Save text file with value from Excel Cell stamped with date and time
  439. Inputbox when cancelled
  440. Pop-up photo in worksheet
  441. mail different files to different persons .to .cc
  442. combo box or list box? How to do this
  443. Function Access Keys
  444. Command buttons visiblle if data is correct
  445. Adding a formula to a macro
  446. Move or copy sheet without including the code?
  447. Auto message
  448. HELP NEEDED: Class Modules Vs Focus/Enter Event on Combobox
  449. VBA Code - Excel & Access
  450. Count of email messages
  451. xlChart returning wrong value
  452. VBA clueless - conditional colors and shapes
  453. Dynamic placement of multple MS Queries into 1 spreadsheet
  454. Application defined or object defined error
  455. Delete certain rows to "merge" pages
  456. VSTO Excel 2003 - Action Pane
  457. Transpose addresses to columns
  458. Make 1 UserForm macro target different predefined cells
  459. Split HyperLink
  460. Select all Data on Active Sheet
  461. Form / Field Arrays...
  462. Date Stamp when info is updated
  463. Super Easy - adding a button to print
  464. RE: Get reference to a file opened in another instance of XL
  465. e-mail range and controlling font size and style
  466. Progress Bar in Excel using UserForm created at Run-Time
  467. Option Button with VB code, not working
  468. Saving Custom Menus
  469. Getting data from Word forms into Excel
  470. Reading/Disassembling a String of information
  471. Can I create pivot table with just one label column?
  472. Textbox labels at runtime
  473. Can't select range
  474. capturing date for a change in a row of data
  475. Textbox labels at runtime
  476. Macro for Formatting
  477. Sort of range leaves range "selected"
  478. RE: Check cells for validation list
  479. Maximize and Protect Worksheet
  480. autosort left to right
  481. How to program a macro that moves my chart as I scroll through myspreadsheet.
  482. Change all label controltiptexts in userform
  483. Insert Row After Series
  484. Check for NumberFormat = DateFormat
  485. Input the filename into Excel Sheet
  486. find
  487. Referencing Checkbox Name
  488. #NAME? in cell when opening a Workbook
  489. importing another file
  490. Set Pivot-Table Visible Items
  491. Create range names with names in column heading
  492. use only numbers and '/'
  493. RE: Check cells for validation list
  494. Find entries in one column in another
  495. Andy Pope's button image editor; pasting icons to sheet then toolbar- why does image quality degrade?
  496. Formula bar is hidden, how do I unhide it?
  497. Median of all combinations
  498. Textbox value
  499. compare oldvalue and new value of a cell
  500. Slow procedure
  501. Problem setting each parameter in an Array = Nothing
  502. OldCell colour
  503. Mutually Exclusive Option Boxes
  504. Why doesn't this work?
  505. Printing style
  506. PLEASE HELP WITH AN SPECIAL AUTOFILL
  507. can same data in different cells be replaced by any formula
  508. Copy From HTML prgramme figures
  509. Detecting the change of a certain cell
  510. If one range changes, update the other
  511. Excel crashes
  512. Email with Notes
  513. Compile Error: Procedure too large
  514. Sheet sub to fire after DV selection is changed
  515. Enquiries about calculation formula
  516. Adding Label Numerical Values correctly
  517. Subscript out of range error
  518. Frame without background color (invisible)?
  519. I hope to get many responses on this.
  520. Comparing worksheets with non-identical rows of information
  521. SQL ORDER BY issue
  522. Moving Columns Macro
  523. Data sorting to a new sheet
  524. Macro not ending?
  525. delete alternate column
  526. Control button display issue
  527. AutoIncrementing a Column like a database in Excel 2007
  528. VBA - Modify data in selection
  529. Creating a working program / application from an Excel sheet
  530. radio button with VB code
  531. excel macro to open Sharepoint list in excel and save in my folde
  532. macro to compare few columns data of two spreadsheet
  533. Find End of Range,
  534. Help to code Macro to Copy fron one sheet and paste in other sheet
  535. count formula problem
  536. Transparent .XLA?
  537. Cycle through all worksheets in a workbook
  538. time box
  539. Search for cell color, copy values in other columns
  540. Top Property in Excel 2007 Not Working Properly
  541. VB Generated Hyperlinks
  542. xla export classes, modules and forms
  543. Need Alternate Code or Formula
  544. IF a condition is met
  545. How can we look for a number in different workbooks?
  546. Custom toolbar, setting docked position
  547. Jim Rech's SheetToHTML function doesn't work in Excel 2007?
  548. Variable not Defined Error for Sorting Excel: 2000
  549. Referencing .NET DLL built for COM in VBA
  550. Excel 2007 Scatter plots
  551. Please help make this Archiving Macro work...
  552. Concatenate /w Chr(10) error
  553. Unhide VBA Toolbar
  554. Map ActiveX
  555. Macro in 2003 vs 2007
  556. Excel 2003 vs Excel 2007
  557. Serial Number start and end range auto-fill into cells
  558. code for printing pages
  559. XLA development best practices
  560. error on add validation
  561. How to make Computer name as a Password by VBA
  562. simulate pressing enter not working
  563. Getting External Data
  564. Linking spreadsheets
  565. How can we look for a number in different spreadsheets?
  566. Scroll to selected cell
  567. Automatically resest variable values = 0 after runtime
  568. File Browse Function?
  569. AddItem to Worksheet ComboBox
  570. Print + autochange info contained
  571. Picking part of a cell based on cell contents
  572. MACRO TO POP UP SAVE AS WINDOW
  573. Question regarding the use of SUM in relation to text cells
  574. Highlight text in textbox
  575. Conditional formatting based on different sheets
  576. Need help on checkbox and textbox on userform
  577. Cannot open the DBF created from the SaveAs option of Excel
  578. Screen looks strange
  579. Save as DBF 4
  580. how to run macro on opening of file
  581. Popup in excel macro
  582. togglebutton to act like optionbutton
  583. Excel Calendar to ONLY allow for Tuesday's in any month to be selected
  584. Adding Rows
  585. vbApplication-NOT-Modal
  586. Help with Selecting multiple Checkboxes on a form
  587. RibbonX Customization Question
  588. adding data from two colunms
  589. Need help to read data from a text file
  590. How to Display UserForm on Full Screen.
  591. Range.find performance
  592. Find and replace cell values Macro
  593. Stupid array question
  594. ComboBox displays last selection
  595. Re: Formulas into VBA
  596. Togglebutton
  597. Deploying custom toolbar and custom icons
  598. Populate Deposit Record from another worksheet
  599. Reading field values selected by a Page variable
  600. Run-time error 1004 since upgrading from Excel 2003 to 2007.
  601. Radio Button Size and Print Features
  602. Fill down two columns...C & D
  603. Distinguishing 0 formatted as "na" and as 0
  604. Error using..... .Value = .Value
  605. Set StartRange and End Range
  606. How to return a column number?
  607. Setting Range = Array of User-Defined Types
  608. Use VBA to Enter Break-Mode?
  609. Userform input question
  610. Change "With Worksheets" to "Activesheet"
  611. VBA Email Cell Contents When Filled In
  612. printing same tab from multiple workbooks
  613. SQL Query to Excel
  614. Redimming (preserve) a 3D array
  615. Change NumberFormat and Cell Fill Colour in SELECT CASE Construct
  616. Gathering data from multiple, non-contiguous ranges
  617. Like operator in SQL with Excel Driver
  618. Problem with Userform the second time
  619. Copy the value to the next open cell when the original cell changes
  620. move data from rows to columns
  621. Build Pivot Table with VBA; Keeps Throwing an Error
  622. Copy Current Month into YTD Spreadsheet
  623. SheetCalculate Event
  624. Search for strings
  625. submit web form
  626. Re: Trimming worksheet name from an imported data source
  627. Re: Trimming worksheet name from an imported data source
  628. multiple Insert Shift:=xlDown
  629. Code help
  630. Countif and
  631. Detect UPPERCASE in cell value?
  632. Last KeyStroke
  633. Send e-mail from Excel macro problem
  634. adding automations to Excel (doesn't seem to work properly) !
  635. macro = Can't perform requested requested operation
  636. For Next Loop Function for Creating New Spread sheets
  637. Use of a range as an email address in a .SendMail array
  638. How could I have saved memory?
  639. Show UserForm ScrollBar
  640. VBA Help
  641. Status Progress Bar
  642. From Outlook to Excel with VBA
  643. Never Looped before
  644. MACRO: Multiple Find / Replace
  645. Command Button
  646. Grayed out or disable?
  647. Change isAddin to false or true
  648. cycling through all the possible criteria in an autofilter column
  649. Data Validation in a Custom setting and forcing Upper Case
  650. Properties Window in VB Editor
  651. Time and Minute formulas
  652. Showing Processing Form while running macros
  653. Find position of a character within the worksheet cell
  654. Change cell colour based on an IF statment
  655. Add sum to dynamic range in Macro
  656. REFRENCE A TEXTBOX ON A SHEET IN EXCEL 2000
  657. Start Excel anytime
  658. put the program on server
  659. Intersect or Union?
  660. Copy and Paste Pain
  661. Clicking on a Cell
  662. Need help turning Macro Workbook into "Application" I can sell.
  663. macro to delete all digits to the right of decimal place
  664. Re-scale a bubble chart
  665. macro to copy data to master workbook.
  666. Data Validation List Hide Unhide Rows
  667. GetObject when more than 1 Excel is running
  668. forms - how to fill each line in a record
  669. refer to a cell for password
  670. parse excel file
  671. Problem with drag and drop formatting
  672. Move Cursor Up
  673. Set permission to a folder
  674. protecting cells
  675. need macro: erase the last 10 digits of active cell then down 1
  676. Test to see if Workbook requires a password
  677. Inconsistent behavior when applying conditional formats
  678. Link a cell in another workbook using a file name in a cell.
  679. User Form Cmd Button in Excel to run Access macro
  680. Manipulating Text in Rows with COUNTA and CONCATENATE
  681. Error!!!
  682. a Vlookup question
  683. Delete All Characters in Text String After xxxxx - HELP!
  684. Assign a value to a variable by next selected cell?
  685. ChDir behavior
  686. Conditional formatting works, but also on empty cells! Fix, or is there a better way?
  687. macro to Subtotal by Group
  688. Create Hyperlink in Current Cell
  689. Bad code?
  690. VBA code sort problems - recorded macro does not work with userform
  691. Urgent language problem
  692. Getting FileName from Search
  693. random numbers
  694. Data Fields in Pivot Table
  695. Why wouldn't listbox's values in Excel stay selected at restart?
  696. Showing a progress message
  697. Insert row if cell contains caracters
  698. Is it possible to do a v-lookup using similar data?
  699. Evaluate text string as formula
  700. AutoFilter and Sharing
  701. Interactive Find and Copy
  702. Extract first four letters from string....
  703. Hide macro List from Alt+F8 window.
  704. Command Button Help!!!
  705. If tab exists "Yes", else "No"
  706. Clear if "#N/A" and Find End of Range, Fill Blanks
  707. VBA Multiple Criteria Lookup
  708. Struggling with code modified to delete invalid rows..
  709. Looped Find and Array Doesn't Find
  710. Create a new range from existing range
  711. A beginners Elseif question
  712. Workbooks.OpenText - Disable Use of ThousandsSeparator?
  713. Transposing
  714. Copy row to first empty row in new sheet
  715. Auto-refreshing results of module-calls
  716. passing data
  717. Unable to parameters in MicrosoftQuery
  718. Select Embedded Documents
  719. using a formula for a column vs. looping over each row - speed difference?
  720. Verifying a worksheet has no dependants
  721. macro to enter data into different line
  722. How to write FIFO Function in Excel programming
  723. web box address
  724. value in range
  725. Copy & Paste from one Worksheet to another without giving focus?
  726. Re: search for capital letter at end of text string
  727. Re: search for capital letter at end of text string
  728. track changes
  729. Re: search for capital letter at end of text string
  730. Identify what Combobox was changed to update the correct item on the previous Form
  731. Excel 2007 Solver Addin Error 400
  732. setfocus
  733. Run-time error `91': Object variable . . . not set
  734. PivotTables AddDataField
  735. How do I add additional cities to this drop down?
  736. PivotTables.AddDataField
  737. How to get source data range for each series of an active chart
  738. Return ListItem via HitTest
  739. Nested If/Then Help
  740. COlor Coding specified time frames
  741. Excel VBA AdvancedFilter Question
  742. Excel Macro 'Sheet.Range.Value' Syntax Questions
  743. Excel loses mind clearing VBA global variables
  744. Code not working, copy in Select Case section not copying over.
  745. Printing Problem
  746. form submit
  747. Protection Issue
  748. reference cells related to the current cell
  749. Excel 2007 chart question
  750. Application.Intersect