PDA

View Full Version : Microsoft Excel Programming


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 [35] 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236

  1. Naming Check Boxes
  2. Run a procedure in all the sheets of the workbook.
  3. Select item in dropdown using VBA
  4. Hiding columns with shaded headers
  5. SelectionChange Question
  6. Re: Workbook has [Group] at the end of teh file name when opened
  7. sort alphabetically a combo box list
  8. Correction Needed in Macro
  9. Special sum of texts
  10. Clearing Validations from many worksheets
  11. Re: sytokromi-c wikipediassa
  12. Marcro
  13. excel does not opens on IIS
  14. Probklem with code, when merged cells
  15. Multiple if statements in one cell
  16. Question for the Probability Mathematicians
  17. Automatic Alphabetical Sort
  18. Simple Macro to "Lookup -> Repeat"
  19. Matchv values on two different excel workbooks
  20. RE: Office Assistant 2007 ?
  21. Input box with dropdown list of all sheets
  22. RE: Office Assistant 2007 ?
  23. Re : Excel AutoFilter Drop-Down Window
  24. Download & Upload to Online Sheet
  25. Use a VBA function to return a factor
  26. Runtime 1004 Error Help Request
  27. Reading from a protected range in Excel
  28. Hyperlink syntax??
  29. Creating a macro
  30. Autofilter
  31. simple code
  32. Parsing a string
  33. Remove an obsolete worksheet from an addin.
  34. Macro to grab data from a chart
  35. Weibull function return an error
  36. Deleting Rows
  37. Taking Flat Data in Excel and Making it Relational in Word
  38. Excel Macro Help
  39. Problem loading an array
  40. Macro to Break into Seperate Columns
  41. Help Modifying Ron de Bruin's MergeAllWorkbooks Subroutine
  42. Range syntax help for a VBA newbie
  43. Find and Replace
  44. Cell coloring giving me fits
  45. Workbook_Open command fails and blows up all cell formulas
  46. Excel automation failure
  47. Date Computation
  48. Data Search
  49. 2 dimensional array
  50. VBA Help
  51. RE: Demya.com - Promote Your Website, Service or Products on Targeted
  52. RE: Demya.com - Promote Your Website, Service or Products on Targeted
  53. Print Area Range Selection
  54. Nested Do While Loops
  55. Replacing code
  56. filedialog in conjunction with printing to a text file
  57. Chart Type - numeric values
  58. Problem with list not showing after a macro running
  59. Can warning messages be suppressed in Excel?
  60. Adding values to a range
  61. Receive data from barcode reader in VBA
  62. Folder size
  63. RE: Leading zeros in IP address?
  64. RE: Leading zeros in IP address?
  65. Run-time error 9
  66. Why does the following custom function always return a "value" err
  67. Resetting Keyboard Shortcuts
  68. Need to save a range as a text file
  69. skip rows depending value of a particular cell in that row
  70. GammaDist function error in error
  71. Help with deleting rows
  72. Get Data from One sheet to Other
  73. Launch IE with Table
  74. Method 'Height' of object 'ChartObject' failed
  75. Focus problem??
  76. custom function closed workbooks
  77. Finding Chart Series Problem
  78. Question on using Ron de Bruin's Excel menu sample code
  79. Open a new file and format the tool bar.
  80. Hide rows that doesn't match cell
  81. Unable to access complex arithmetic functions in VBA for Excel 200
  82. Assing a Name to a Range
  83. multi Loop efficiency
  84. Msgbox Close with vba
  85. Combo Box font Change
  86. Reading the characters in a cell
  87. I need help with VB code
  88. vba run-time error between 2 difference releases of excel/access 2
  89. how to display 2 lines depending on one cell
  90. Formula with MID() not working
  91. Condensing working code
  92. Autofit / Remove formats VBA Code
  93. Copying and Pasting a picture from one sheet to another
  94. Object required error
  95. Macro to remove rows
  96. 2 columns processing
  97. Extracting the Time from a Date/Time Stamp
  98. Replacing via macro
  99. Reset a User Defined Types Values
  100. Re: What reference is needed to select the progress bar control?
  101. Macro that opens an xls file then saves it with another name
  102. RE: What reference is needed to select the progress bar control?
  103. Re: What reference is needed to select the progress bar control?
  104. Find the minimum and maximum date in a list
  105. Problem with Lifeboat Hang error and DDE
  106. Macro for removing error values in cells.
  107. Data Validation - Do not want to allow pasting into the cell
  108. pick calendar date and day
  109. Inserting cells using VBA
  110. Formula in Excel to get additional column values associated with M
  111. Deleting Duplicate with a Msg box which displays no of duplicates
  112. How to save current filter of Table(ListObject) and to apply it la
  113. Using VB, remove a certain section from ThisWorkbook
  114. Lotus Notes CreateObject
  115. Turn off read only attribute on shortcut
  116. ignore error
  117. Formatting a Chart Based On What Values Are Displayed
  118. Duplicate Detection with Message Box
  119. Vlookup in a Macro
  120. Access command from Excel
  121. xlValue et al.
  122. Incorrect name on pivot table
  123. Automatic formula entry, file save and cell blanking
  124. Pasting Selections from Multiple Sheets along with their Sheet's Name
  125. Poor Performance on LARGE Excel workbooks containing formulas
  126. fill weekdays with date
  127. Hyperlinking to a hidden workbook
  128. sumifs to other workbooks
  129. A Question on Ron de Bruin's "Copy a range from closed workbook" function
  130. Copy data from range
  131. Time issue
  132. Select range
  133. How can you change cell attributes in a function??
  134. convert US date format to Excel readable
  135. Programmatically modifying code using VBE in a protected project
  136. drop first row in range and return a new range object
  137. Custom NumberFormat - international version
  138. dropdown box item to display a message
  139. How to set LastCell?
  140. Events for CheckBox inside Excel using ExcelAddIn project
  141. Last cell in column
  142. Inserting Dashes
  143. Any body to crack it ?: Print Week Category based on range for mon
  144. Marco that will run if the condition met
  145. Labell Height
  146. How to calculate time difference in hrs
  147. Print specific ranges in several sheets
  148. last row in column
  149. range.createnames method
  150. how can i count multiple variables in multiple columns?
  151. macro- keep value in cell and add value for adjacent cell
  152. Select Case (Choosing Columns)
  153. Date selector combobox
  154. Enlcosing code inside if- then no longer works
  155. Match 1 cell of record and Transpose 2 cells to another sheet.
  156. delete the non blank rows
  157. Edit cell value
  158. Function to retrieve embedded URL link?
  159. Why this "error 9"?
  160. code to automatically compress photos
  161. Edit Column Letters
  162. Sorry for this: How do I stop receiving all the emails about newposts?
  163. VBA Code for Custom Date Filter
  164. Resize problem
  165. Constant execution of ListBox.Click
  166. How to generate on a chart or spreadsheet a date line marker
  167. How to control if a cell references versus list box or another cel
  168. trying to create a form that will stop you if you leave a cell bla
  169. Filter Records based on the value selected from a drop-down list b
  170. Problems with repeated call of userform
  171. VBA Expected end of statement ERROR
  172. Help with macro
  173. Formula... like text
  174. Dates between two sheets...
  175. Macro to take latest data
  176. Excel not recognizing module.
  177. Re: Print all Sheet2 of all Workbooks in Folder
  178. Execute code on a range of cells, then move down and do again?
  179. Help Modifying Macro - Merge multiple sheets based on a condition
  180. Re: Macro Adjust Based on Dataset?
  181. Adding MAcros using C#
  182. Sheet Protection Properties lost
  183. Macro Adjust Based on Dataset?
  184. This clever code ain't doing nothin, why?
  185. Trying to create err msg if cell is left blank
  186. slow (and wrong?) For...Next loop
  187. Excel/Access Question
  188. How to write Excel GUIs with VS2008 Express
  189. Excel selects multiple cells with mouse click - how to stop this
  190. Excel Matrix problem
  191. XL2002 - ActiveWindow.Zoom = TRUE (to selection)
  192. How to bind events for formsControls inside Excel
  193. Print all Sheet2 of all Workbooks in Folder
  194. sending excel worksheets by email
  195. After Running AddIn - continued
  196. After running AddIn, application needs to be re-drawn
  197. Open file with custom button
  198. Want delete rows if A have value and O not
  199. Zoom problem with shapes in Excel 2007
  200. Copying Chuns - A part of the whole Field - from Access to Excel
  201. Use macro to delete worksheet without specific name Eg:Sheet 1
  202. Code pause when disconnecting from Terminal Services.
  203. Opening word from within xls
  204. FollowHyperlink causes error
  205. delete the non blank rows depending on Column
  206. Print Week Category based on range for month
  207. Password on forms
  208. combobox list range
  209. Problem using =HYPERLINK() formula rather than literal hyperlinks incells
  210. Pivot Table help
  211. Excel 2007: macros disabled on new Vista machine
  212. Match Entry
  213. approve email macro
  214. Data Validation List
  215. Form Location on Screen
  216. UserControl
  217. SeriesCollection object
  218. comibantion of various functions
  219. Close Projects in Project Explorer
  220. Question on Custom Views
  221. Parameterizing a query
  222. modify existing macro
  223. Macro to iterate through rows in a worksheet (problem)
  224. Turn off Autofilter but leave rows hidden.
  225. User Type vs. Variable
  226. Issue with my Loop Function
  227. Delete rows based on date input
  228. Name disappears after Application.Run
  229. Tool bar to follow spreadsheet
  230. Custom Format use with MATCH function
  231. Command Button or Macro that will email a spreasheet
  232. How do I create a multiple selection list box in Excel with VBA?
  233. How do I create a multi selection list box with VBA code?
  234. Count Unique Records in Filtered List
  235. Pass Worksheet Button Caption or Identifier to Sub
  236. Clearing an integer variable
  237. Code to Minimize the riboon
  238. Visual Studio and Excel
  239. refer to active window when more than one window open for a file
  240. VBA Userform - Editing Controls (Similar to Dataform) (Excel 97)
  241. Re: Conditional formatting ... or VBA programming help
  242. Search and Replace via VBA
  243. Question on copying a range
  244. Re: Converting number into words
  245. Remove All White Space
  246. Excel Sort changing 10 to 1
  247. ActiveWorkbook.RefreshAll waiting time
  248. Reading more than 255 chars from Excel.
  249. Problem accessing Sub routines in Addin modules
  250. Use of UCase
  251. Start a macro when a vlooup formula shows a new value
  252. referring to columns by number
  253. Modify a remote cell
  254. Dictator Apps and Excel 2007
  255. Run-time error '-2147352571'
  256. Create a macro which populates a powerpoint slide from excel tabel
  257. Subscript out of range
  258. Macros from C#
  259. Copy and paste data using macro
  260. Build Array
  261. Find Yellow error code
  262. Problem with For Each loop
  263. Extracting file from a zip file
  264. Clear frame color
  265. RE: Swap values in userform txtboxes
  266. Re: Swap values in userform txtboxes
  267. Macro to FIND/REPLACE
  268. Data crunching according to criteria
  269. custom function color
  270. ello:
  271. insert label in worksheet
  272. leading zero issue when converting to time format
  273. startup macro does not execute
  274. Compile error - help
  275. Reading Chunks of Excel Data
  276. Prompt for saving a saved workbook
  277. MS Access Records
  278. Renaming Worksheet
  279. onmouseover event
  280. Where (menu) find "fill color" and define/add a new color?
  281. Run-time error ‘-2147417848(8001
  282. userform size
  283. Select a sheet and return
  284. Range referencing incorrectly
  285. Change Inches to feet and Inches
  286. fibbonacci series, with time function
  287. tooltiptext on textbox
  288. With statement question
  289. Can I use worksheet data in headers?
  290. Re: Speaking error?!?
  291. RE: Speaking error?!?
  292. Trouble pasting
  293. HOW DO I ADD ONE COLUMN TO A SECOND WITHOUT DELETING THAT VALUE
  294. Creating working with Class
  295. Re: Speaking error?!?
  296. Macro in add-in runs depending on if sheet exists in workbook
  297. Copy Name Range in single Cell
  298. How to apply SQLOpen Function - Excel 2007
  299. Numbers in words
  300. Selecting a worksheet
  301. Problem with formula
  302. parsing email address into another email string
  303. Remove an inserted picture
  304. Array Code issue
  305. how to write this in vbe ???
  306. Remove shape at series point (2007)
  307. Fill Array from a Range
  308. Get the Name of the Add-In Workbook used as a Reference
  309. How to Fill a String Array
  310. Extracting Specific Numbers in a String of Text
  311. Inset a picture
  312. Hiding All Checkboxes when I open/close the workbook
  313. Text to Columns - Saving User Settings
  314. Hide/Unhide CommandButton by cell criteria
  315. Track Changes using xlt file.
  316. Creating Custom Menu in Personal.xls Workbook_Open
  317. Macros always available in Personal.xls?
  318. Re: Userform Question
  319. Update Access 2007 Table Using Excel 2007 VBA
  320. Save As Macro
  321. Modifying a range of cells
  322. Difference between times (Answer in minutes)
  323. Set Array equal to Range
  324. Searching across columns
  325. Product of 3 Cells based on criteria
  326. How to replace the background color of all cells from light green to light blue?
  327. filter
  328. Run Access Subroutine (or Function) from Excel
  329. .bat file to enter password protected .xls sheet
  330. COUNTIF accross multiple worksheets issues
  331. scroll so that the upper left cell in a range moves to the upper left of the active window
  332. select cell after sorting
  333. Macro should run on a specifi time.
  334. chart range to include variables - Macro
  335. Cell = "YES" then CommandButton2 Visible
  336. Keep the track of persons how opened the sheet and made changes.
  337. How do I require data entry in a combo box in Excel?
  338. How to code "Switch Row/Column" for Excel Chart
  339. setting constant path
  340. Command Button not copying with attached macro, help
  341. How to inhibit non-interactive MsgBox display
  342. copy data
  343. refresh combobox
  344. What am I doing wrong with Ranges named within Macro...
  345. Excel 2003 & 2007 menu compatible menu by Ron de Bruin
  346. Hidden Characters
  347. Auto height adjustment to fit on a single printed page
  348. excel unique values in column
  349. isolating TaskPanes between documents
  350. Can you make Range Equal All Values in an Array?
  351. Using Excel as Interface for big SQL Server Tables?!
  352. sheet selection without knowing name
  353. Trapping errors.
  354. Put numbers in column B cells when Value Change in Column A cells
  355. Can Sendkeys be used to send a selected no. of characters in a sin
  356. Delete selected worksheets
  357. DDE automatic refresh
  358. Application.Speech.Speak
  359. Nothing selected in my list box?
  360. Interior color disappears
  361. Count Dates in a range
  362. Code to assign a macro to hundreds of option buttons at once
  363. Please help with macro
  364. Stop a simple macro
  365. Last cell in active row--I know, I'm sorry
  366. Custom Function Add-In not working
  367. RE: Last cell in active row--I know, I'm sorry
  368. :
  369. Macro Letters
  370. workbook event, only to certain sheets
  371. Populate Combo Box with Values from CSV File
  372. macro's with if function included
  373. Refresh data causes reference errors?
  374. C# Excel Named Range Cannot be Found Due to Web Service Data Delay
  375. Can Excel Link two tables on seperate sheets?
  376. cells with null or no data
  377. copy shortcut to desktop
  378. VB control's text/caption is ugly - keeps resizing
  379. Day test question
  380. vlookup few books
  381. Re: Split Print Area - One Page Print
  382. Runtime error 1004
  383. Merge Multiple Files
  384. named range
  385. VBA code does not copy and paste to next row for each zip code
  386. Capture the Source Address of copied data
  387. Average last seven if not zero
  388. Error Msg - Object variable or With Blockvariable not set
  389. If Range ("C22") <> = 0
  390. Order of Drop-Down Menus
  391. Can you Filter using names from a generated list???
  392. Where to store lookup table
  393. SENDKEYS and brackets
  394. PasteSpecial error message
  395. Find Workbook in multiple instances of Excel
  396. help Vba
  397. Blocking column insertion
  398. Automating mail merge from excel
  399. Macro for deleting rows and serialising the remaing rows
  400. Load Values from Worksheet to Userform Controls with Loop
  401. Macro
  402. Question about checkboxes
  403. Perform calculation in Excel and store in Access
  404. Date formatting
  405. Pivot Data fields - removal of all (value) fields
  406. Grouping data with VB script or function?
  407. Excel 2003 : Problem accessing childnodes in XMLDomElements
  408. Re: word wrap from shrink to fit
  409. Set a counta function result in a for loop (Macro Excel)
  410. Macro Help!!!!!!
  411. Merging cells and copy!
  412. Re: word wrap from shrink to fit
  413. Script works in forms element but doesn't in normal option button
  414. Seems a bug in setting Style.Orientation property
  415. Find & Replace with two condition in VBA
  416. How to create a Linked (text) table in xl vba to a .mdb
  417. Cell Color condition using IF... ELSE statement in Excel
  418. Calculating Average Daily Balances
  419. Does Rowfields exists?
  420. GetOpenFilename() errors
  421. I want to insert pictures from from file
  422. Bug in my code
  423. Underline and Bold 4th numeral
  424. Display data from a cell in User Form
  425. Need help on Excel 2003 Macro Visible Property
  426. Copy Column D from all worksheets in WB1 and paste in sheet1 WB2
  427. E+16 in number
  428. disable EXCEL macro runtime-error
  429. find and findnext
  430. Club membership list / database
  431. 3-position switch control
  432. Repeat Character in VBA
  433. Userform errors
  434. Replacing Values
  435. formula doesn't work
  436. find duped value <> 0 and change to 0
  437. Combine multiple cells into one cell.
  438. How to use Header "Text" as Sort Key
  439. re: optimization for formatting worksheets
  440. Char(10) or Char(13) in body of email
  441. Load Userform Control Values from Worksheet
  442. Edit Button image
  443. Macro stops running at an unexpected time
  444. Load Userform Values from Sheet with Array & For...Loop
  445. How to copy and paste a partial row (i.e. not the EntireRow)
  446. macro to find data from one sheet & copy in another sheet
  447. Best Practice for disconnected data?
  448. Paste values only
  449. Autochart top 20 percent
  450. Filling/referencing cells from User Form
  451. macro to send email
  452. Delete rows based on date criteria
  453. Assistance with Loop construction
  454. chart help
  455. What's causing error message?
  456. Help with Slow Print Routine
  457. help on creating five folders
  458. VPN Connection
  459. Looping Checkboxes in Worksheet
  460. Excel 2000 and XML
  461. Macro to set an html anchor?
  462. Help! Ungrouping Excel Charts --> EMF/WMF. Can't edit objects in 2007 (Freeform issue). Steve Rindsberg?
  463. RE: remove duplicates, keeping latest dated record
  464. Re-driecting a pivot quarterly
  465. After getting value from a cell need to make five folders under th
  466. ActiveSheet.Shapes("Rectangle 23").Select will not work in 2007
  467. Module protection & Shell issues
  468. named range
  469. Auto Check-out / Check -in
  470. How can I create five folders after this with a spacific name
  471. Check Out / Check In
  472. Loop web query & pivot table...?
  473. block printing of defined tabs
  474. Searching in excel
  475. If 80 in column A and date >= today...
  476. how can i find ' as the first characture in a cell using vba
  477. C# and Excel: how to get reference to Excel VBA form
  478. Need SUBSTRING like function
  479. Autocad & excel
  480. Alternatives to VBA for Excel programming
  481. Controling Chart Names
  482. Event Handlers: Getting a handle to the calling object
  483. Excel Date Issue
  484. C# For Excel Courses - London UK
  485. rename & hide worksheet problem
  486. Name of Pivot Table
  487. My own fiscal year
  488. Precedent arrow - link number
  489. Code will not run
  490. Get data from existing sheets in workbook
  491. How to create an 40230 error in the VBA Project?
  492. microsoft script editor
  493. MS Query
  494. Cannot open 2 projects at the same time
  495. Preventing Auto_Open() runnng on vpc -Holding "Shift" doesn't work
  496. HELP with macros
  497. Devolving code to a DLL
  498. How to disable keypress in combox?
  499. CDO and Exchange Server 2007
  500. Macro to change Userform Textbox Font attributes
  501. Can a vlookup be done on a 2 dimensional array?
  502. Zoom Q
  503. RE: creating a new folder with a value of a cell on the C directory
  504. creating a new folder with a value of a cell on the C directory
  505. Inputting a formula with a Macro
  506. VB code to fill next available cell
  507. create a macro to move one cell to the right w/o specifying range
  508. Find and replace in code
  509. hep with Loop
  510. excell novice needs helps
  511. Print each column seperately in Excel
  512. error message
  513. Cell cursor neglect cellinfo.
  514. New to Visual Basic
  515. Insert Dynamic Formula
  516. Accessing Grouped OLE Objects
  517. vba script to logon to another application like iseries
  518. macro runs fine but error message is displayed
  519. Spreadsheet Object in VB Form (Excel 2007)
  520. Filling Zip by City
  521. How to select info based on date
  522. Re: Invoking "cmd" from VB macro
  523. Shift down and then to the right
  524. How to use a pointer in an IF Statement?
  525. covert xls to xml
  526. r/t 2110 - Can't Move Focus to control
  527. VBA corrupting Cell A1 in CSV file
  528. How do I call up a line of code that references a cell/range in theactive workbook workbook where I am running my macro from?
  529. UserForm cancellation
  530. Re: Hyperlink
  531. RE: Hyperlink
  532. RE: Hyperlink
  533. Backup Addin
  534. Can't get rid of multiple project references in VBA
  535. code to mark coloured cells in excel
  536. Insert space before CAPITAL letters
  537. Error with Selection.CurrentRegion.Rows.Count?
  538. Ole timeout
  539. Method 'Range' of object '_Worsheet' failed in Union of 3 Ranges
  540. Formatting for the whole worksheet
  541. Worksheet CodeName property
  542. Screen Update
  543. Copy from a text box
  544. Programming on excel sheet
  545. deselect one of the shapes
  546. why won't this work?
  547. ShowAllData error
  548. Is my ListBox empty?
  549. message box on cell content
  550. conditional formatting
  551. RE: search locked cells
  552. Getting r/t error
  553. Last Cell In Row
  554. Cannot Dechiper Encoded String
  555. Can you apply a comment to a range of cells (as opposed to just one) ?
  556. look to do an Offset of something like a offset
  557. Range problem
  558. Data Consolidate duplicates data...
  559. Rename Sheet tabs from list......
  560. Code error
  561. Outlook - Pull contact from Outlook into Excel
  562. Text Box colours
  563. Input Box
  564. Concatenation of Text
  565. Auto run macro when file is saved
  566. Run-time error 9 - Subscript out of range
  567. Helps on Custom Views
  568. a problem with savaas method
  569. Macro needed to copy groups of data from one spreadsheet to anothe
  570. Can I create a link from a cell to take me to another worksheet?
  571. Retrieve result of query from Access
  572. Varioable in SQL statement
  573. Switch to Excel workbook in a separate instance of Excel
  574. Populate worksheets fro a Master List
  575. macro not found, but it is there
  576. Data Validation
  577. macro not found, but its there
  578. Programatically get to Named Ranges in Name Manager (Office 2007)
  579. file name as specified cell when save as or save is clicked
  580. worksheet to track vacation accrual by employee and cost/job cente
  581. Copy Sheet causes Combo Box change event to fire on original sheet
  582. Should I use sumproduct function?
  583. Convert Decimal to Feet and Inches
  584. Excel Date Format Macro
  585. Access Data Entry Form
  586. data validation based on cell value
  587. Stop recording toolbar
  588. Code Takes Forever to Run - Why?
  589. Simple question concerning VBA functions
  590. vba unprotect sheets with different passwords Help Thank you
  591. extract right side of string
  592. Assign value with DOWHILE (variant of TRANSPORT METHOD)
  593. VBA connected vs disconnected from network?
  594. Count Uniques in Col H, Result in Blank Cell, For Each Next Loop
  595. Copying Worksheet to New Workbook
  596. Test for files existing
  597. Looking for a shortcut
  598. Email a statement
  599. display message while code is running
  600. Text Box Value From ActiveCell
  601. Using vbYes or If statement
  602. xlVeryHidden
  603. Syntax To Update ComboBox List From TextBox
  604. Query Problem with Read-Only Workbook
  605. VBA Excel how to assign name in variable range
  606. Formatting via VBA
  607. Shift the Left Boundary of Named Ranges when Inserting Columns
  608. How can I use Shapes in 2007?
  609. Comparing Wookbooks
  610. LOOKUP PROBLEM
  611. VLookup error - Sub or function not defined
  612. How to sign a Macro
  613. Paste Special error in a Macro
  614. Command button color
  615. Compile error: Variable not defined
  616. rename a worksheet adding a sequential number at the end
  617. Find consecutively and copy
  618. Error when copying worksheets
  619. .pictures documentation
  620. Search and find all "$" in a string
  621. Need help with *lookup*? (or something else) for making a calendar
  622. Worksheet_BeforeDoubleClick Stops Working
  623. Get Active Object or Textbox Name to pass to sub
  624. Deleting original sheets
  625. SpecialCells(xlCellTypeVisible) driving me nuts
  626. Help to copy files names in a column from one directory to another directory VBA
  627. Excel VBA Print Command
  628. Hide Sheet when cell equals
  629. userform dragging problem
  630. Shif cells to the right and down within limits
  631. How to disable tempory an automatic Worksheet_Change Event
  632. Worksheet Change Event Triggering Multiple Times
  633. mean calculation of each column of each group
  634. Scroll bar update
  635. Scroll bar with text box
  636. RE: Unable to set the LeftHeader property of the PageSetup class
  637. RE: Unable to set the LeftHeader property of the PageSetup class
  638. RE: Unable to set the LeftHeader property of the PageSetup class
  639. Bad File name or number
  640. RE: Unable to set the LeftHeader property of the PageSetup class
  641. RE: Unable to set the LeftHeader property of the PageSetup class
  642. RE: Unable to set the LeftHeader property of the PageSetup class
  643. Sorting data using 2 seperate columns
  644. XL 2007 GetEnabledMso("Undo") is always True
  645. how to insert microsoft equation 3.0 with vba
  646. Has AutoFiltering Been Applied?
  647. creating and saving data from a userform
  648. mark to market
  649. Re : Excel HyperLinks to WorkSheets & Chart-Sheets
  650. Array sorting
  651. Network DDE between two excel
  652. Getting the Kalendar Week within VBA
  653. SUGGESTION - IF command option
  654. Filter or Sort??
  655. VBA Source code librarian or versioning system
  656. Re: Ungrouping Excel Charts --> EMF/WMF. 2007 can't edit objects as 2003 (freeform big issue). Steve Rindsberg help!
  657. Slow code to copy a row x # of times
  658. Combobox
  659. Webpage conversion
  660. Certificate breaks when file is saved
  661. Prevent User from saving Changes to a spreadsheet
  662. Exporting Chart sheets as gifs
  663. Auto calc. the bottom 20% with a twist...
  664. External:=True
  665. How do I identify range of filtered sheet?
  666. Stop a user navigating certain sheets
  667. ribbon question
  668. Working with Range
  669. Deleting rows when cell text reads "Research"
  670. can vba look up a value in the f distribution tables?
  671. SQL Syntax
  672. Show Minimum value
  673. Worsheet selection
  674. Select entire rows if between date/time range
  675. Autofilter not working with multiple field selections
  676. Can the Text on a button form be referenced from a cell?
  677. Save ONLY 1 Sheet in a Shared Workbook
  678. drop down list in .htm format
  679. Listbox - works 1/2 time
  680. clipboard - backup and restore
  681. For/Next Text to Columns
  682. Strange formatting on one machine only
  683. Find row and delete following rows
  684. How to get the current module name and Sub in VBA?
  685. Switch to diff workbook with file name LIKE based on value in a ce
  686. Code to find the max value for a cell while looking at other cells
  687. run time error when inserting Excel sheet into word document
  688. I want to learn excel programming
  689. iterate my rows
  690. Can I make Bills of Material that deducte given QTY's fron invant
  691. Active Sheet Error Message
  692. Run Time Error '1004' General ODBC Error
  693. Putting wordpad document into cell office 2003.
  694. updatelinks method?
  695. access selective data...using query
  696. New Sheet based on condition
  697. conditional formatting Do anyone have a work around for this probl
  698. Re: Save embedded object?
  699. Auto Ranking
  700. Linking xlb file to xls programmatically (or other trick)?
  701. Formula to hyperlink to match
  702. VBA - Select: current cell + next 19 cells (down in column) = rang
  703. Time Range Summary - parse data
  704. pickup the amount from the workbook
  705. Conflicting event procedures launching at the same time
  706. Select row in formula in excel 2007
  707. skip actions within a macro if a cell value is zero
  708. Scroll bar (Floating, Changing Sheets)
  709. Protect a shared workbook
  710. Creating Word docs from Excel with VBA
  711. Gain senders email address from an email sent to me
  712. Using Dir function to find folders
  713. Axis title text direction stacked
  714. Excel IF "formula" - SUGGESTION
  715. Freeform Object Failing
  716. Automate the Tools...Reference ?
  717. Excel keeps shutting down using code
  718. Need help creating a count macro
  719. Macros
  720. Help with a loop please.
  721. Combining several workbooks into one file
  722. Help/Advice Required
  723. Excel vlookup function with complex copy and paste
  724. where is download sql.request
  725. Disable update links prompt
  726. Change paste to only paste values
  727. QueryTables.Add() not returning text from SQL Express table
  728. EXCEL IN WEBPAGE
  729. Run DOS command
  730. BeforePrint
  731. Sorting
  732. Creating a macro for date range.
  733. check box sort
  734. Function to Check Borders
  735. Find a single "0" (zero) in find command
  736. Delete a filtered set
  737. Finding document title
  738. Complex copy and paste in excel
  739. Protection Malfunction?
  740. Two Saves for one event (sheet1.xls)
  741. Add-in Question (common code)
  742. VB 2005 User Defined Function (via Automation Add-in) Generates #V
  743. Referencing year portion of date
  744. Help with creating a time sampling loop
  745. Combining cells
  746. Web Query Results to an Array
  747. Count Uniques in Column G Until Change in Column C, then Restart C
  748. Changes made in first tab-automatically update through subsequent
  749. save sheet as pdf and email it
  750. Unique Filter Macro not working correctly