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. Counter
  2. Alternate to ActiveWorkbook.Close
  3. Dynamically Freeze Panes
  4. RE: Type of charts from Access
  5. Open another WorkBook
  6. Force Excel to close
  7. Listbox selected
  8. Can I do this autoselect with GetOpenFileName or the Dir function?
  9. Unlocking Aspect Ratio For images
  10. Three-way Lookup Help Please
  11. Solution required
  12. Converting a grid of data to linear
  13. Troubleshoot access - excel linked table
  14. WEBSITE ACCESS AND VBA !!!
  15. Google query
  16. Help with Tooltip on clipart
  17. COUNTIF function help please
  18. Macro issues - trying to get an array to a column
  19. Help with VB macro
  20. Vlookup Help Please
  21. RefreshTable vs PivotCache.Refresh
  22. Problem With A Pesky Question during a Macro
  23. vbOKCancel Problem
  24. Macro recently quit working
  25. clear contents re value
  26. Re: Extract base domain from an URL?
  27. check for links
  28. check for links
  29. Re: Extract base domain from an URL?
  30. Renaming the Excel windows taskbar
  31. 100% quandry
  32. Finding the biggest number out of 8 variables
  33. Data Validation - List
  34. listbox with multiple selections
  35. Re: Extract base domain from an URL?
  36. deleting sheet
  37. Delete sheets
  38. RE: Extract base domain from an URL?
  39. path to macros being changed
  40. sumif in vba
  41. Copy a command button
  42. Rename Tab
  43. Download data from web page
  44. Input Box Location
  45. Email Using CDO - mixed results
  46. Window Manipulation
  47. Driving me Crazy
  48. .dropdown problem
  49. Print to PDF code for both Cute PDF and Adobe
  50. Need to meet criteria
  51. Efficiency, Workbook objects in User Defined Record
  52. "Limited Use Question?"
  53. Add problem
  54. Preventing Duplicate Records
  55. RE: Compare cell value with string
  56. RE: Compare cell value with string
  57. Re: Compare cell value with string
  58. RE: Compare cell value with string
  59. Compare cell value with string
  60. Form Startup Position
  61. Autofilter using a value from a list.
  62. Spell Checking on a protected sheet
  63. Call a sub in a modeless userform from a code module?
  64. VB script line graph
  65. ControlButton Size
  66. multiple column Listbox - look like table
  67. Adding and Protecting a Totals Column to a Table
  68. Dim Array as Byte
  69. Re: Copy range on multiple sheets into one sheet
  70. How can I modify my code to offset the defined range and repeat theprocedure instead of duplicating my code?
  71. Looping through file names of a csv and then through other csv
  72. Insert formulas
  73. RE: Stack Space Problem with On Worksheet Change Event
  74. RE: Stack Space Problem with On Worksheet Change Event
  75. OpenOffice macros
  76. .CurrentPage = "(ALL)"
  77. Stack Space Problem with On Worksheet Change Event
  78. Stack Space Problem with On Worksheet Change Event
  79. Image Stretch While Printing
  80. Custom Properties for Worksheets and Workbook
  81. Code debug
  82. Hide Columns
  83. Horizontal scroll bar
  84. Workbook_close
  85. Auto_open User Name Log
  86. Tiered Cumlative Commisions By Month
  87. Is there a command to 'Hide' the Activeworkbook?
  88. Re: What application do you use to write VBA on?
  89. Format Zip Codes Correctly for a Mailmerge
  90. FRom Pivot table select multiple items under report filter
  91. module won't quit as expected
  92. Force users to enter a range of cell in dd/mm/yy hh:mm format
  93. Re: What application do you use to write VBA on?
  94. Re: What application do you use to write VBA on?
  95. Copy contenst of a cell into a string
  96. Open file from same path
  97. all permutations
  98. parse Excel
  99. A way of capturing the new path a file is stored in
  100. Fully Populate Tree View Control
  101. Bizarre option button behavior
  102. How do I calculate the age of a person from their ID no.?
  103. Find method without "With / Set" in a For...each: error after 1st run
  104. Address of Excel.Range & Range
  105. using excel from c++
  106. Re: macro to send you to a specified worksheet
  107. Replaced text count
  108. API code for 'Renaming a Directory'
  109. Picture on Worksheet Cell
  110. Cannot find project or library
  111. FIND method , versus FOR EACH ...
  112. File check on FTP server
  113. Import through dialogbox
  114. Auto_Open Code on Worksheet
  115. Application.Quit Not Working in Office 2007
  116. Main Sheet
  117. Check for duplicate numbers from ones entered and anoter set
  118. Multiple of a Variable in an If function?
  119. RE: code to hide/unhide rows
  120. How do I add iserr or iserror to this
  121. Wavfile playing trubcated
  122. Change a web query
  123. Run-time Error: '438'
  124. Print Userform - fit to page
  125. 20007 issue?
  126. Create list of files with hyperlink from a folder with EXCEL 2007
  127. Lookup and match color of corresponding cell
  128. Slow Updatelink off Networked Open files
  129. Capture
  130. Activate a Workbook
  131. CDO to Retrieve E-mail
  132. new workbook add and save by a modified name based on original fil
  133. New to excel macros need help with selecting ranges
  134. Is somekind of Slider Selection possible?
  135. RE: Error in excel com: Microsoft.Office.Interop.Excel Exception from
  136. RE: macro to redirect to another worsheet within the same workbook
  137. Manipulating Strings in a Macro
  138. Open Sharepoint Hosted Excel File, in Excel, Using VBA
  139. Show a value for Listbox1.Selected(i)
  140. How do I force user to enter their ID# before filling other data?
  141. Problems With Page Breaks
  142. Copy/Paste dynamic ranges
  143. Copy/Paste dynamic ranges
  144. Paste
  145. Automation: Invoking Excel Financial Functions Without InstantiatingExcel?
  146. Delete All Blank Rows--A plea for help
  147. Change cell with command button
  148. Re: Auto code in VBE when pressing F7
  149. Re: Placing a few spaces between syntax
  150. Re: Comboboxes with multiple values
  151. Passwords
  152. Placing a few spaces between syntax
  153. Read in Data
  154. Help with inserting automatic comments
  155. Removing automatic(Default) page break
  156. Auto code in VBE when pressing F7
  157. Re: macro to send you to a specified worksheet
  158. Macro
  159. Grouping Based on Indent
  160. Macro to run Command Buttons
  161. Rearrange Data
  162. macro for deleting specific columns & rows. Help. Please. No Clue.
  163. CellPointer (rectangle around selected cell) not visible
  164. Code Help
  165. using one macro to edit another
  166. Add data to 2007 table based on column names?
  167. Autofill Help Please
  168. Copy sheet and rename tab
  169. Looping Help Please
  170. Visual Studio 2010 (Creating Excel DLL) "warning" no build
  171. macro to transfer from excel to word
  172. RE: Visual Basic - Invisible Command
  173. RE: Delete VB code from a worksheet
  174. Visual Basic - Invisible Command
  175. RE: is array redimmed?
  176. 5 months prior to date macro help please
  177. Delete VB code from a worksheet
  178. is array redimmed?
  179. 2 Autofilters
  180. FreeFormBuilder Bug?
  181. Hard code the workbook name in macro
  182. Macros Being Re-Directed
  183. Check URL exists in Webquery
  184. Query 2 excel files with ADO
  185. Selection after copy sheet failed
  186. How do i password protect my VB Code from users
  187. Worksheet Function
  188. Button - Assigned Macro
  189. Retrieving Current Row,Columns & copying Format from Row,Columns a
  190. "Web" Command Bar always appears on start up
  191. Moving the cursor around with a macro....
  192. Hide value of cell if value same as other cell
  193. Adjust Zip code to 9 Char fmt.
  194. Need to run a Macro to ....
  195. Need to run a macro to ...
  196. Code to select all worksheets (variable number of sheets)
  197. Send an email from Excel using Outlook
  198. 2 columns w/ text data that i want to do a wildcard comparison
  199. Re: Return Column Number
  200. How to run this macro
  201. Maintaining selections in UserForm
  202. Run-time error '424': Object Required
  203. Conditional Selection.Find
  204. Cell reference in User Defined Function.
  205. Running a Batch file from VBA
  206. variable in application line
  207. Userform - Label
  208. Copy if adjacent Cell has data
  209. Fast AND Accurate
  210. Compile error in 2003
  211. setting a variable to the offset of another object declared variab
  212. Loop to delete shapes
  213. RE: Return Column Number
  214. Re: Sorting Macro Loop
  215. Re: Return Column Number
  216. RE: Sorting Macro Loop
  217. RE: Sorting Macro Loop
  218. Website problem
  219. Sorting Macro Loop
  220. RE: exit form and close sheet
  221. Copy a mamed range in one worksheet to the first blank cell in a c
  222. comparing data without unique identifier
  223. Re: alternative to using the 'chart method' to exporting range as .jpg file
  224. exit form and close sheet
  225. Highlight Duplicate Rows (In Series)
  226. name ranges in array
  227. what VBA command is used to go to the next blank row in Excel?
  228. PLease Help!
  229. When this happens, do that, then do the next thing
  230. query criteria based on a changing list of values
  231. Spliting Data into Months
  232. Combine and Convert to Multiple Rows
  233. If Formula & Vlookup
  234. AutoShape color
  235. Re: Coding, Formula, or Conditional Formating?
  236. Check for duplicate values
  237. Copy code
  238. making a worksheet & certain ranges within a variable
  239. Selecting worksheet and ranges within sheet to run macro on
  240. Coding, Formula, or Conditional Formating?
  241. sheet update date
  242. Keeping XML data in workbook?
  243. Hide and Unhide
  244. Hide and Unhide
  245. Change Print Margins in VBA for Printing an E-mail
  246. Change Print Margins in VBA for Printing an E-mail
  247. Extracting specific data from a string
  248. What is the meaning of this sub
  249. Problem with UDF
  250. Application-defined or object-defined error
  251. Excel OLE Automation: How to access constants ?
  252. Workbook which having unreadable contents is not getting opened
  253. environ username vs. application username
  254. Help with hyperlinks
  255. Re: Create own properties?
  256. Scroll Bars on Worksheet
  257. using the same range name on different worksheets in a workbook
  258. Cursor and Sheet Protection may09
  259. Named Ranges vs. Constant Addresses, sheet protection, Guidance.
  260. Modifying Sub SortMatch
  261. "Do You Want to Save Changes" message window
  262. Paste Special values for entire workbook
  263. Missing Printer Method in VB6
  264. Add in does not Function in Excel 2007
  265. referring to a row that contains a single cell
  266. Problem using DLL written in C++
  267. Speed up Array Transfer to Dictionary
  268. Searching a cell for certain contents
  269. Variables in a Userform
  270. How do I know that Application.AutoRecover.Enabled = False works?
  271. RE: macro to automatically remove blank rows
  272. RE: macro to automatically remove blank rows
  273. How do I print to a printer line by line from VB6?
  274. list or combo box?
  275. Tough one - image and embedded html document
  276. Re: Automatic transfer of row info to another worksheet
  277. How do I print to a printer in VB 6?
  278. Input box for multiple entries
  279. ComboBox and multi sheets
  280. Run Excel with VBA code from Website
  281. Re: Copy all worksheets to another workbook, excl. duplicate sheets already in other workbook
  282. Re: Delete Row if value in row changes
  283. Delete Row if value in row changes
  284. Re: Automatic transfer of row info to another worksheet
  285. personal.xls in Excel 2007
  286. Shell Command
  287. I want to define the use of Unicode globally in a VBA macro in Ex.
  288. removing duplicates in a row
  289. Form Names
  290. Input box help needed
  291. disabling macro message
  292. Locking cells, Excel 2003 SP3
  293. Execute a macro automatically when checkbox is clicked
  294. Re: Automatic transfer of row info to another worksheet
  295. Macro instead of lookup
  296. Re: Pivot Excel 2007 - Change data source Table head's cells' values ...
  297. Macro for creating a formula
  298. Pivot table - eliminate rows out of the table
  299. How to check the decimal number of each cells vaue in the column
  300. Modify all pivot tables in one sheet
  301. reference with variables
  302. Check that only ASCII chars are used
  303. How to check the last digit of each cells vaue in the column
  304. Is this right?
  305. Enter smallest amount in row
  306. Re: Generating new workbooks based on data
  307. Re: Generating new workbooks based on data
  308. Generating new workbooks based on data
  309. 3D averaging / histogram
  310. Enter the smallest amount in row
  311. Re: Transfering data
  312. Ignore Case without using Regular Expressions
  313. Conditional "If Not ... Then" Statement not working properly Help!
  314. Help with this macro please
  315. Public Variable Question
  316. New range overwrites other range in create sheet macro
  317. New range overwrites other range in create sheet macro
  318. Assigning macro buttons to macro code in another file
  319. Error 4605 when trying to copy/paste a table from excel to word.
  320. Problem with formula
  321. Re: Filtering data hides row
  322. Defining multiple ranges as one range
  323. Re: Transfering data
  324. RE: Transfering data
  325. RE: Transfering data
  326. RE: Transfering data
  327. Code to change PivotTable selections, based on ActiveX CheckBoxes on a worksheet.
  328. Re: Macro to define range names
  329. Unable to Compile a Macro
  330. XMLSS document to Excel document in .xls format
  331. Unable to Compile a Macro
  332. Shell comand
  333. Problem reading text file
  334. sheet code window
  335. Updated sheet content is not copy pasting from sheet1 to sheet2
  336. Delete VB issue
  337. Selected listbox item
  338. Save As Macro
  339. When
  340. Get "Large" from List
  341. Error: "Compile error in hidden module: Main"
  342. VBA project not viewable
  343. clipboard excel
  344. Using function to change a cell color
  345. Text Formating
  346. Re: alternative to using the 'chart method' to exporting range as .jpg file
  347. RE: ActiveWorkbook.close problem
  348. ActiveWorkbook.close problem
  349. how to open a workbook when application excel is running ?
  350. Finding TWO things
  351. UBound array problem
  352. If Selection is one cell
  353. data summary & macros
  354. Re: alternative to using the 'chart method' to exporting range as .jpg file
  355. Using check boxes
  356. Check if Range EXISTS
  357. Re: Sub or function not defined
  358. Re: Sub or function not defined
  359. Re: Sub or function not defined
  360. Lose Cursor After Protecting Sheet
  361. Re: Can a macro do this job?
  362. Get data from closed file... Cont..
  363. Re: Check cell range for a fragment
  364. Check cell range for a fragment
  365. Open a Workbook using VB
  366. Re: Sort
  367. sOURCE CODE REPOSITORY
  368. WinZip 12 page
  369. arrays
  370. VB career advice appreciated for self-taught newbie
  371. RE: Skip Errors
  372. Skip Errors
  373. Activate Workbook (Windows) with keywords
  374. Use Bcc
  375. using variable in subject when send mail
  376. RE: How do you get the selection in the VBE Active window
  377. Opening a new workbook via a macro
  378. How to access VBA variable from active worksheet
  379. Give a sheet a name from data in a cell-saving to a specific folde
  380. Copying a worksheet with macro buttons on it
  381. Copying multiple worksheets to another workbook
  382. Can an input box do this
  383. ListBox question
  384. insert 3 rows between data
  385. macros
  386. a formula to go in a macro
  387. Looping Question
  388. Refreshing pivot tables according to scroll menu result
  389. How can I selectivly delte rows with a macro ?
  390. Why is this Worksheet Change Event triggered?
  391. scramble names on work roster
  392. Command Button misfire
  393. Looking for a way to Set Range to Entire Column
  394. XL2003 find and replace broken?
  395. Change delimiter position based off of Last Name
  396. Memory Management in VBA
  397. Fill down Error
  398. Ghost in the Machine - 1004 Vlookup & On Error Duo Trouble
  399. ScrollBar - set MIN/MAX cell value
  400. Column grouping and hiding being over-ridden when sheet opened
  401. Subtotal Function response is slow
  402. send an outlook task to colleagues
  403. Insert Contents
  404. Need Calculations Done Event
  405. Copy sheet to next un-named Workbook
  406. Runtime Error 13 - Mismatch
  407. Sample VBA code to open an Visual-Studio-2008-created VBA DLL
  408. Excel 2007, Custom Right Click Menu Doesn't Work in Table
  409. Outlook and bcc
  410. Create User-defined Template
  411. VLOOKUP in VBA
  412. To Enable Macro in Excel.
  413. CNA
  414. Run-time error: '9'
  415. Referring to same cells in all worksheets
  416. outlook task recipient
  417. RE: Log-In Credentials in a Macro
  418. Events
  419. Vlookup based on Combobox in a Userform
  420. How to implement the progress bar to indicate the Macro start to finish
  421. How to Upload a Workbook on my website
  422. How to Upload a Workbook on my website
  423. Excel XML Time format & arithmetic
  424. Excel XML Time format & arithmetic
  425. Excel XML Auto Column Width
  426. How to hide rows in a range that have a certain value, withoutfiltering
  427. Open files Error in Excel 2007
  428. Concatenate many cells without zero's
  429. Create a Private Const Array in excel 2000
  430. Microsoft.Office.Interop.Excel.Application
  431. Maximize Sheet1
  432. autofill to visible cells only
  433. Macro to Define Name on a changing selection of cells
  434. Inserting a Picture from Folder over cell in 2007
  435. For... Next loop problem
  436. How can I PERMANENTLY get rid of the Excel clipboard?
  437. Lookup Function in Macro (VBA)
  438. Re: Where can I learn to convert VBA to VB scripts?
  439. Selecting different Worksheets from a Loop
  440. Cancelling But Macro Still Carries On
  441. Date Conversion Help
  442. Unsure of my error?
  443. Grouping According to IndentLevel
  444. How to add additional worksheets to a directory of workbooks
  445. Re: How can I make VBA scripts compatible with browsers other than Internet Explorer?
  446. CommandBars
  447. User defined Nth_Occurence function fails when new data is loadingvia macro
  448. sing Data Validation
  449. Using Data Validation
  450. Worksheet selection
  451. Variant and Array
  452. Excel query not responding
  453. Improvements to code
  454. ShowDetail on PivotTable does not work in VBA
  455. XL 2007 - Macros won't run when security configured to allow macr
  456. XL 2007 - Macros won't run when security configured to allow macr
  457. Loading pivotfields from an array
  458. Counting the Occurances and find the Latest Date
  459. RE: Print UserForm?
  460. Automate searching and then copying files to a folder using excel
  461. Re: Print UserForm?
  462. Stop Refreshing/Blinking Chart screen when running Mouse over even
  463. Automatic Hide/Unhide Programming
  464. Sum values based on criteria in another column
  465. stop refresh of cells during an optimisation/calculation
  466. OOOOPs.
  467. Look at, Find, then go to
  468. Naming fixed range versus a List
  469. Re: Print UserForm?
  470. Help accessing msgbox prompt via function
  471. Clear Cell Contents based on Criteria of another cell
  472. Macro to copy and paste cell into text box in PowerPoint
  473. Delete file within a zip file
  474. Error message when I open any other excel file
  475. RE: vlookup workbooks in a folder from master book and save them
  476. Filling a macro button with colour ( color)
  477. Emailing range in message body using VBA - problem
  478. New Batting Gloves
  479. Denim Crib Bedding
  480. Perfect Fit Electric Blanket
  481. College Basketball Books
  482. call new workbook
  483. Bath Toys Com
  484. Excel 2007 - Links between worksheets
  485. Do While Loop
  486. Which Oracle home does VBA use?
  487. display calculation next row
  488. Excel 07 issue opening MHT format
  489. Lookup for multie tabs
  490. how can i change colour of a cell
  491. VBA Excel - Run-time Error 50289 – Can't perform operation
  492. automation excel to access
  493. How to read the current grouping of a pivotfield in a pivottable
  494. Copy Values to another Sheet Q
  495. Unable to exit Design Mode
  496. Need VBA Script to Open URLs from a list in Excel
  497. Unhide rows macro
  498. delete rows that dont match values in named range
  499. Must VBA be manually converted to VB.NET (C++;C#) to create a DLL or Com Addin?
  500. develop UDF in Xll, Automation Add-in or VSTO
  501. Create a pivot table in excel 2003
  502. .SubTotal: Controlling where the caption goes?
  503. If Cell = X then name sheet Tab GHI for eg
  504. Loading Data into an Array
  505. MS Access Query Question
  506. Possible to Transfer/Open "Read" a text file into VBA Module?
  507. Missing Headers
  508. outlook task
  509. Creating pivot table dynamically
  510. Find internet explorer is installed using vba excel
  511. Macro Button Dissapears
  512. Removie .select
  513. First Error works but Subsequent Error Handling Does Not
  514. empty cell / copy and paste
  515. Macro for moving arrow shapes
  516. VBA Test on Array - Find a value
  517. Problem with Parameters In External ODBC Data Queries and Userform
  518. loop and some more
  519. Hide Next row based on Cell Value
  520. Last row function....with a twist
  521. How to change old data source reference from copied pivot table
  522. How do I come back to my First Sub?
  523. Making an IE Window the focus for Excel VBA
  524. Wolfram Alpha
  525. Playing wavfiles from excel
  526. Emailing select data from Excel automatically
  527. Not enough resources to display completely
  528. Test for Shape is part of a group?
  529. After checked condition, add the data to adjacent cell automatically
  530. SaveAs Confict Resolution Help ?
  531. Macro Error Handling
  532. LISTROWS problem in userform
  533. Emailing using code
  534. Checkboxes disappear after macro is run
  535. Process steps to compile current VBA macros into a DLL or COM Addin
  536. Excel 2003 - Recovery of Lost Tool Bars
  537. Userform Option button lost
  538. Hiding Rows with Blank cells
  539. Adding Options When User Cancels/Cannot Find
  540. Delete a row where a cell in the previous row is a duplicate
  541. Is it possible?
  542. Maintaining Macros on a sheet when it is saved as a new workbook
  543. Maintaining Macros on a sheet when it is saved as a new workbook
  544. Converting data into multiple rows
  545. Running Word (and Excel) code from within Excel, to process both file types
  546. formula or macro to change a formula in muliple spreadsheets
  547. Copying from another worksheet
  548. VBA code to email active work book
  549. RE: Copy Dependent On Cell Value
  550. XL 2007 - Custom Toolbars
  551. search all open workbooks for sheet name
  552. Adding user defined range in macro
  553. array
  554. Issues with UserForm Box
  555. Copy range from one open workbook's worksheet to another.
  556. Deleting Rows in Case Statement
  557. creating macro that works in any open workbook?
  558. Cut and Paste Macro
  559. Setting Colors Using Other Than ColorIndex?
  560. Declaring Decimal
  561. Clear Clipboard command in Excel 2007
  562. Place a date in another cell only if adjacent cell = "X"
  563. Event to add a date if "X" is entered in a cell
  564. Userform checkboxes
  565. AddTextBox Position Fix
  566. Syntax issue
  567. Substitute() & Char() in Macro
  568. Workbooks Open Statement
  569. Re: Run-time error '1004' general odbc error
  570. Opening a workbook opens two
  571. Column Cell character number checking
  572. Put Value in Close Excel
  573. Retrieve Outlook mails from Excel
  574. Very slow Excel Macro
  575. Strange French hour format
  576. Filling an Array
  577. Declaring Variables Twice?
  578. msg box to apply filter
  579. Strange macro behavior - result is correct every other time
  580. Re: Copy range and paste into MS Paint
  581. copying multiple images from excel to word
  582. Out of Memory Error in Excel 2007 but OK in 2003 - Please help.
  583. ADO.NET truncates excel data
  584. Problem referring to a particular sheet in VBA
  585. Refresh ListObject Linked it SharePoint List
  586. how do I change page layout in vba
  587. Download file to computer from FTP
  588. Open folder
  589. Opening .xls that runs macro on open
  590. AddressOf
  591. comparing data between 2 worksheets with no unique identifyer
  592. convert string to value and sum
  593. Please help with "Username"
  594. Using a Calculated Value from a Custom Function in the Calling Sub
  595. Using Data Validation List
  596. Truncate a cell value
  597. Detect if current select is a row
  598. Auto Fill Equations in VBA
  599. Verify Column Letter Selected
  600. Move a worksheet position
  601. Change it to a variable
  602. input the date range for update Pivot table
  603. Setting and removing page breaks
  604. How to check the value of a Column
  605. Cell Border
  606. Deleting rows
  607. Column D x 2
  608. Help list box to update pivot table
  609. print macro
  610. Move last names to front
  611. Rename & Colour Sheet Q
  612. Matching 2 lists
  613. Call Macro from PERSONAL.XLS
  614. TextBox Click Event
  615. outline question
  616. Take value from active cell to make formula
  617. Path name problem with pivot data source
  618. Adding a Custom Command Button to the Excel 2007 Ribbon
  619. Trying to use serialdate in database array
  620. a way to print
  621. Copy data from a user form to a comment
  622. subtotals give zero
  623. select data based on date range
  624. Duplicate phrases in one cell
  625. Who has folder permissions
  626. Join multiple rows data into one row
  627. copy array to range
  628. Use of Variable in Sum
  629. Interfacing PHP and Excel using OLE Automation: file access proble
  630. Recording additional processes within a recorded macro
  631. Find last row in workbook sheet & move data to it from another sh
  632. Using list or macros to input predetermined values
  633. Pre-Setting the number of characters input in a whole column
  634. Macro button for all files
  635. Macro library in XLSTART: Why does Excel 2007 fall over?
  636. Type mismatch error - 'run-time error 13'
  637. Creating Macro to group data
  638. ms query editor question
  639. Copy Columns from multiple workbooks
  640. Re: Where can I VBA and VB scripts?
  641. Strange problem in Excel combo box
  642. Missing Component (Converter)
  643. RE: Macro to save 2007 file in 97-2003 format
  644. Re: Macro to save 2007 file in 97-2003 format
  645. User defined data type (losing its data)
  646. Send an email message from my website using VBA code
  647. ActiveX control dilemma
  648. Referring to an ActiveX control
  649. Update Record
  650. Use mouse to select sheet
  651. Spreadsheet in Userform
  652. Re: Pass on cell address to an UDF?
  653. Spreadsheet translation
  654. Adjust Chart Size
  655. Re: Working example how to create a DLL using Visual C# 2008
  656. Preventing file overwriting
  657. Re: Working example how to create a DLL using Visual C# 2008
  658. looping colums and rows
  659. Making a directory if one doesn't exist
  660. use formular to create a cell address
  661. Re: Select current region less 2 rows at the top
  662. Re: Select current region less 2 rows at the top
  663. Extracting specific items from large IE table
  664. How to display a custom menu item
  665. Microsoft error
  666. auto filter list selection
  667. method select of object range failed
  668. Advice on With-End With
  669. Repaint worksheet - or Cell select outline.
  670. macro to date stamp to the right of the macro command button
  671. EXCEL.EXE process does not end after adding an excel chart
  672. How to change what version of Excel starts when double-click aworkbook
  673. Save As.....
  674. Delete 0 - Column D and Column F
  675. Get data from closed file
  676. Column All Upper Case
  677. PasteSpecial column widths with different size ranges
  678. Inconsistent Macro Security
  679. RE: Macro ignores IF statement that refers to cell value
  680. Macro ignores IF statement that refers to cell value
  681. vsto08-ExcelAddIn-Performance Increase while Dragging Excel Window
  682. Re: Pull down menus
  683. RE: Pull down menus
  684. Pull down menus
  685. Subscript out of range error
  686. One Entry Cell area, to add items to lists
  687. Delete Rows
  688. Hidden rows loop
  689. Between Function
  690. RE: Prompt User to Select Macro to Run?
  691. Re: Prompt User to Select Macro to Run?
  692. Re: Prompt User to Select Macro to Run?
  693. Prompt User to Select Macro to Run?
  694. special character in vba
  695. Can Excel directly access .mdb?
  696. RE: Run-time 1004 error
  697. Run-time 1004 error
  698. Cell contents check and prompt out message (By using Macro)
  699. ScaleType error
  700. Changing case and also changing entered data
  701. Find Character Codes
  702. Way to output list of macros to file
  703. RE: dynamic range question
  704. Large macro "drops out" part way through
  705. dynamic range question
  706. SPEED....2003..V..2007
  707. Userform leaving a trail
  708. RE: Moving a Userform
  709. Moving a Userform
  710. Converting a String into a date format
  711. RE: Edit csv text file with VBA
  712. VB code for autofill
  713. VB code for column fill matching weekends
  714. List box
  715. Edit csv text file with VBA
  716. VBA Advanced Filter - latest lines for multi criteria
  717. USING FIELD DATA FROM USERFORM
  718. Hidden Property 1004 Error, Union of Rows
  719. Macro to Group andor Ungroup rows and/or columns
  720. Save to My Docs
  721. Delete sheet code
  722. identify drive letter
  723. Retain formats in userform
  724. Search location and sub dir's for file, then open it.
  725. pivot table by useing Oracle view
  726. Copy Array Formula
  727. Can't see macro list
  728. How to get actual sheet in my workbook?
  729. Calendar control
  730. RE: How to obtain Cell Address and/or Select all sheet-cells with xlEx
  731. How can I check if the ActiveSheet has keyboard focus?
  732. Problem with go to
  733. strange behaviour
  734. Comparing Dates
  735. Excel file using unusual amunt of resources
  736. trying to build in a check
  737. for x 2 to 100
  738. Hard Return
  739. Protected Excel File manipulation
  740. Inserting Columns based on missing headers
  741. Drop down Ref another sheet within the Workbook
  742. activate code on single click
  743. Macro question
  744. If statement help
  745. Advanced Excel Conference - Atlantic City - June 17 to 18
  746. Re: combobox list of sheet2
  747. Is it possible to multiply a chart series formula?
  748. 2003 and 2007
  749. Character symbol meaning
  750. Activechart.parent.left