PDA

View Full Version : 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 | 

  1. Is there a "ChangeCell" event?
  2. Run code from within a UserForm
  3. Testing for Digital Certificate in VBA Project Programmatically
  4. List unique values from multiple sheets
  5. What’s wrong with this countif procedure ?
  6. PDF file size
  7. Can you auto populate a cell by clicking on it?
  8. for x to - next x question
  9. Combox Help!
  10. Using Text in a Formula or FormulaR1C1 property
  11. Running macro from another sheet - VSTO
  12. How do I create a macro to remove blank rows...
  13. Delete Specific Rows Using VBA
  14. Macros
  15. Importing Data from Access Query to Excel Sheet
  16. userform combobox rowsource from database
  17. need code to copy text from workbook and paste it in a new outlookmessage
  18. Accepting solver solutions automatically under VBA
  19. Go to top left cell of selected range
  20. Disabling "group edit" mode in Excel
  21. how to clear my content in cells but keep the conditional formatti
  22. programming etiquette
  23. RE: Button Text Gets Smaller When Button Clicked On
  24. Looping through a listbox
  25. Dynamically create drop down box when cell value changes
  26. Triple Number
  27. Data Validation doesnt work with Copy/Paste
  28. Close Match
  29. VBA and loading forms (Excel 2002)
  30. Create new pattern in Excel programmatically
  31. Can I create a new pattern in Excel programmatically?
  32. if formula
  33. Querytables.add with sql query text stored in separate text file
  34. Redim preserve does not work for me
  35. Sum the Variable Range
  36. Securing codes by corrupting the file (Leo Asked)
  37. remove space
  38. Custom Number Format
  39. Add new Patterns to AutoShapes in Excel
  40. Security
  41. Seks v polnolunie
  42. Seks v polnolunie
  43. how to clear my macro tabulate content?
  44. Copy/Paste Problem: Runtime error 1004
  45. Which references am I missing, to call Outlook from Excel VBA?
  46. Pivot date, that's all
  47. Can read all threads other than those I want
  48. Fill in of cells excel 2007
  49. Step thru a function procedure?
  50. Determine if Sub Exists
  51. loops
  52. Number pad onkey IDs
  53. udf for returning names of wrkshts in active workbook
  54. Finding the Max Number in a Table based on Other Criteria
  55. HELP: Error Occurs With Macro Making a Pivot Field Visible
  56. macro issue
  57. Automated google search
  58. Auto fill cells
  59. Using a Form to control variable fields.
  60. Time Tracking problem.
  61. faster method to delete rows
  62. Public Range Constant - how do I?
  63. IF HELP
  64. assigning macro
  65. Need help with merging a range of cells
  66. ELAPSED TIME BETWEEN TWO DATES
  67. DETERMINING NUMBER OF DAYS / MONTHS / YEARS BETWEEN TWO DATES
  68. Match or Lookup
  69. Test if an element of array is empty
  70. Embedded chart alignment
  71. Input format
  72. Using flowchart in simulation
  73. Shift+F9 results differ from Sheet.Calculate
  74. Reference for Trim$ ???
  75. Sort Macro
  76. tabulate output data from different combination of input.
  77. change image in picture object
  78. display pivot refresh date?
  79. A bug : Run-time error '1004'
  80. Clear value if cell changes
  81. Java screen
  82. F9 not working
  83. Re: Lookup dates
  84. Job Ideas?
  85. Finding a specific text
  86. macro adding
  87. Message Box - Yes/No
  88. Lookup dates
  89. a doubt
  90. conditional formatting
  91. Autofilter used programmaticaly causes error
  92. Auto emailing of files
  93. Exiting listboxes in a userform
  94. Making cells mandatory to fill in
  95. Match Files
  96. Date/Day VBA Calculation
  97. Excel 2007 Custom Right Click Menus for Connectors and Shapes - Re
  98. Macros 2
  99. Change Control Toolbox Button Caption
  100. how to catch these events?
  101. (Repost) new order of table
  102. Macros
  103. rows to columns
  104. Quotes and CSV files
  105. Importing Text File problem
  106. Include function arguments (like range finder) in Add-in
  107. string manipulation
  108. Teach me to Merge Data
  109. How to call GetPriorityClass,GetThreadPriority?
  110. DEC2HEX
  111. OrderThenFindEmptyCell
  112. Find and Delete
  113. Count every group of numbers whose sum is zero & put number next toeach number
  114. Using a variable in an If statement
  115. ADO to XLSX file from Excel 2003
  116. Pass a worksheet as a parameter to a function?
  117. Remove custom menu
  118. sum a range
  119. Text Box not showing inputted value
  120. How can I align pictures to the columns in code
  121. Macro to Copy Defined Name range as a Picture file
  122. Chart Source when copying sheets to new file.
  123. Clear Contents of Specific Cells in Last Row
  124. Open Document Format (ODF) and Office Open XML
  125. Formatting Macro using rowcount
  126. Macro/Trust Center Settings
  127. Cell reference in code
  128. Synchronize sheets by row?
  129. VBA - Programmatically Open SP Files
  130. Clear a range of data
  131. Password To Run Macro?
  132. FormulaArray in Excel 2007
  133. Copy range values in C#
  134. VBA Check Spelling doesn't highlight misspelled word
  135. Autoamate Concatenate Function
  136. gallery in 2007 UI Ribbon w/xml
  137. Variable menu with single "on-action" procedure
  138. Excel 2007 Custom Right Click Menus for Connectors and Shapes
  139. pivot table show items with a value
  140. assure that calculates ends before save to pdf starts
  141. Create list of duplicated numbers
  142. filter and delete
  143. Lookup closest to
  144. How to assign a macro to a pivot in Excel 2000
  145. Match file names listed in column with file names in folder
  146. customised userform
  147. Merging data
  148. how to get excel to combine numbers to a given total
  149. VB for Chart Axis
  150. How do I reference a Worksheet from a Form (Add-in for Excel 2003)
  151. No Index Violation when adding data in Acccess from Excel
  152. progunta
  153. Automating Excel from Word - How to Sort a Range of Cells
  154. Macro to Open excel file when file name is entered in cell
  155. Extract Data Code Modification Request
  156. Reporting Service
  157. Add Number to variable date
  158. how to access data from excel to/from another program using Vb
  159. VBA Quick Question
  160. Enter
  161. Named Range or through cells
  162. How to stop Macro warning on opening workbbok
  163. Excel 2007 Print Preview
  164. Why does this not stop when I push "yes' or "cancel in the message
  165. Problem opening folders with hyperlink (URGENT)
  166. Check Refresh Status of External Data Query
  167. Import URL picture into Excel cell
  168. Save Method Of Workbook Class Failed
  169. Strange cut and paste result between worksheets
  170. Find a sheet within a workbook (If/Then/Else)
  171. Form temporary variables
  172. MsgBox
  173. Format Text Boxes within A User Form
  174. Multi Select check boxes and drop downs
  175. Delete Specific Contents
  176. Problem Opening Folders (again)
  177. Excel Spreadsheet
  178. Upload Excel formats to database
  179. Offset Ranges
  180. display text when mouse passes over a line
  181. change line colors on multiple sheets.
  182. Run a Macro within a Macro
  183. Import data from multiple files
  184. For each worksheet in workbook problem
  185. Opening a folder with VB
  186. Cross Excel Updation
  187. copying blocks of data from one sheet to other sheets in same book
  188. Adjusting a Macro
  189. Compare and replace if equal
  190. Message Box Warning
  191. How to close Immed Window in odd situation?
  192. Jump to Yahoo Mail with Active Cell Contents, and then perform asearch in the Search Mail Box
  193. Import picture into Excel cell
  194. Vlookup error in VBA, 2042
  195. MS Excel MVP?
  196. open email template
  197. Index is not in range
  198. Matching !!
  199. define UserForm properties
  200. Sum Function
  201. Workbook Summary Sheet2
  202. Getting Excel to Logon to a Website
  203. Retain value of userform option button
  204. Workbook_open not executing
  205. How to set up a delay to Private Sub Worksheet_Change(ByVal TargetAs Range) event
  206. ActiveCell offset delete
  207. Userform Terminal Error
  208. Item rows into order sheet
  209. how to calculate set theory in excel functions
  210. Save a File with a Password Q
  211. Automatically clear web query message "unable to open http:"
  212. Sorting and Filter in Multiple Sheets using Hyperlinks
  213. Two File Dialogs
  214. Exception from HRESULT: 0x800A03EC - COM Exception Unhandled
  215. Why does timeGetDevCaps fail?
  216. Assigning a button to SAVE a sheet
  217. Random Copy Paste
  218. Data from cell viewed in message box
  219. Compare the number of elements in two different arrays
  220. Userform - what am I missing?
  221. Copying a row from a table
  222. Dynamically adding ActiveX controls via VBA kills global VBA heap?
  223. Excel 2007 vs. 2003 differencies for custom format [h]:mm:ss
  224. RibbonX ToggleButton Pressed State
  225. Advanced Excel to pdf Automation
  226. VBA pull an online .Dot Template?
  227. Identify months/periods applicable to Date range
  228. Lookup Table
  229. Detect Autofilter Change Event
  230. Assign macro
  231. keep objects from overlapping
  232. Macro to delete lines
  233. Extract Duplicates to create another list.
  234. Variable sorting
  235. Importing Data from Access to An Excel Sheet
  236. Find the Empty Cell Macro
  237. Warning Macro
  238. delete line based on combo box
  239. Change Code to Match Tab Name? Is this an okay idea?
  240. help me to look the following code
  241. Function Shift Pressed not working in Excel 2007
  242. Auto refresh data once a day?
  243. OO programming in VBA - VBA equivalent to the "eval" function
  244. pallet building??
  245. Run-time error '1004': Application defined or Object defined error
  246. Record line number in macro where error occurs
  247. how to select a shape obj on the sreen
  248. new order of table
  249. Hidden rows
  250. Lock Cells based on Data in another cell
  251. Swap 2 lines
  252. copy formula across while skipping columns
  253. Capture Filter 'AfterUpdate' event in Pivot Table
  254. How do you use a button to launch a macro?
  255. Using Column Name
  256. Excel Macro Using "Like" comparison
  257. Run-time error 438
  258. Workbook Summary Sheet
  259. Enable to hide Worksheet Menu Bar
  260. Copy List Columns
  261. Need simple macro to copy and paste values
  262. Create Word Docs From Excel Cell Data
  263. Use VBA to create new sheet with event handlers in sheet's code
  264. Hide and seek
  265. Protected Worksheet Permissions
  266. Create multiple dropdown list for multiple colums; select more tha
  267. array values not matching
  268. One to Many data
  269. Export store list to new workbook
  270. Worksheet program to convert parent/children data to string(s)
  271. functions in personal file
  272. Range Link and Chart Link Macros
  273. Run macro when user selects a different sheet
  274. Quick Method to Find Chart Sheets?
  275. macro problem
  276. Loop macro in selected range
  277. Refresh Query Table causing debug error with Background Refresh pr
  278. keep formatting
  279. VBA working with excel
  280. How to Pass a Form to a Function - 2007
  281. array - type mismatch
  282. Office Basic vs Pro
  283. UserForm remains visible after Unload - 2003
  284. Are rows hidden
  285. Followup to sheetname object questions
  286. Is there a way (encryption type) to really protect my worksheet???
  287. Filter Macro
  288. Copy, paste, transpose depending on variable
  289. Pivot Table
  290. rearranging a table
  291. File not found when opening
  292. Correct VBA for DO WHILE i.e. X=X AND NOT RS.EOF
  293. Compile error
  294. sum a range in VBA
  295. Re: lookup
  296. Excel 2007 Pivot tables
  297. Question for Joel
  298. Advanced Insert Cells Function?
  299. Saving with toolbar macro
  300. Size of file changes when saved
  301. Appending a file
  302. Excel 2007. Trust Access to VBA Project Checked, still not truste
  303. AppActivate for IE not working
  304. lookup
  305. Finding source data column of pivot field
  306. Select the next item
  307. Populate userform combobox with option button
  308. Lock userform for editing
  309. VLookup in two Excel 2003 workbooks
  310. Inconsistency in Macro Speed
  311. Aligning Pictures to a cell
  312. MACRO for cell protect after a date is reached
  313. Add and summarize function
  314. Excel 2007 hangs on programmed file close
  315. Excel 2007, Custom Right Click Menu Doesn't Work in Table, Help!
  316. PasteSpecial (format only) Selection is too large
  317. Runtime Error '9': Subscript Out Of Range
  318. Macro to Print Active Pages in the Worksheet
  319. Adding selected items from one list box to two different list boxe
  320. WeekNum Trouble
  321. Is this Possible
  322. Multiple Sheets / Pivot
  323. rename active sheet based on cell
  324. comparing two files
  325. Help!! Copying/pasting
  326. extract a portion of data from a cell and paste back into same cel
  327. Analyzing data in collections of classes?
  328. Assign function return value to an array
  329. PrintTitleRows 2
  330. advanced VLOOKUP command?
  331. Print Macro
  332. Inserting cells in MS Excel 2007
  333. Unable to make my custom toolbar 'float' in Excel 2007
  334. Trying to disable a custom commandbar button
  335. How can I find Pivot Table Sheet for Pivot Chart?
  336. Stop Excel From Formating Text Starting with A Zero
  337. Activate .. Select .. Initialize
  338. CPSCount
  339. Complicated Lookup Code
  340. Need Excel Macro to Find Specific Text and Characters
  341. Shortcut key for add-in macro (Excel 2007)
  342. Designer
  343. Copy used range from one worksheet to another (and lose the pivot)
  344. Cell Lockouts
  345. Finding automatic page breaks in new, blank worksheet
  346. Screwed Up my Right Click Context Menu, Please Help
  347. MsgBox "Choose one ", vbYesNoCancel, " Three Options. "
  348. Filling Blanks only with ABOVE nonBlanks
  349. Cell reference for year in formula
  350. Send unattended email from Outlook using Excel macro
  351. conditional formats using named references
  352. Fill with random numbers
  353. Deselect Row in ListBox
  354. How to change built-in shortcut for "Save As..."
  355. Command Bar
  356. PrintTitleRows
  357. UserForm Keyboard Control
  358. Trendline on only part of the data.
  359. copy one column of data after another
  360. date entry stumped
  361. Excel 2007, adding a macro in an add-in to the ribbon
  362. no page break in named range
  363. need a Timer in an Excel Form
  364. Filter by predefined list
  365. Excel 2000 compatibility
  366. Why R/T error 1004 - 7 rows from the end of this code
  367. Delete Rows
  368. Hidden sheets
  369. How to use auto fill in a macro
  370. Two good URL ...
  371. Returning Data From ADO
  372. Open File Macro
  373. colors in a listbox
  374. Clustered Column Chart Containing Stacked Data
  375. END IF in a macro
  376. refedit controls and R1C1 notation
  377. Error with code that paste on next available row
  378. Conditional formatting based on numerical values of adjacent cells
  379. Macro?
  380. Saving Workbook with Password using SaveChange
  381. MSCOMCT2.OCX error
  382. if header row leave a statement
  383. VB.NET: How to declare a parameter in a worksheet-function
  384. Prevent copy of filename
  385. Hiding rows
  386. Change default F12
  387. Variable range union
  388. VB Date Format
  389. Invalid characters in cells
  390. Passing Arrays to a Sub
  391. Cell formatting when converting from DataGridView to Excel
  392. code for overlaping time
  393. Working with tables in Excel 2007.
  394. Populating Validation Lists
  395. Format cells using C#
  396. Adding a column to a table
  397. autofill without a destination range
  398. print titles
  399. Make zeroes in Selection nothing ""
  400. macro to search & open file
  401. Copy user selected files to new folder.
  402. Getting Automation error
  403. Can you calculate the Median without each value in separate cells?
  404. SubTotals
  405. Type mismatch error
  406. Type Mismatch error
  407. string compare to array
  408. VBA code to open web page then enter number and postcode then subm
  409. Column Offset
  410. Barcode suffix & Prefix
  411. Macro to delete unwanted colomns
  412. macro creating new pivot table
  413. pull down menus in spread sheet
  414. modify existing macro
  415. Macro that worked stopped working
  416. Removing the Sub-Total Levels
  417. Add code to paste data to next available row
  418. Sorting a Workbook w/ Links
  419. Excel 2007,
  420. Placing a regular excel function in VBA code [HOW?]
  421. Issue passing data from sheet into userform
  422. Macro to Find File in Subfolders and Open it
  423. Question What determines if publlic variable content is destroyed
  424. Date/Time Question - After 5:30 PM?
  425. Help With MS Excel 2007
  426. Sorry My PA was on.
  427. Excel IF/ELS to all Macro
  428. VBA Editor Window(s) size challenge
  429. Reduce sheet size
  430. Pivot Table - change page field help
  431. Copy range if match
  432. Indent and fill color based on other columns data
  433. Avoid using macro's from other workbook(s)
  434. Automatic email to recipient
  435. Context-Sensitive Help
  436. Code Interpretation
  437. Getting elapsed time
  438. Application.Wait Not Working ???
  439. Combine several like rows
  440. Assigning AutoFiltered Range to Range Object
  441. VBA code in one Module referencing Public Variables Declared inanother Module failing
  442. ListFillRange
  443. Protecting a VBA project
  444. How to enter in Edit Mode programmatically
  445. VBA Convertors
  446. Delete Blank Cells in a Row
  447. Deleting a row
  448. Error Handling function
  449. Copy Non-Consecutive Rows and Paste in a Seperate Worksheet
  450. Selecting columns
  451. Grouping data in excel 2007
  452. print 4 pages on 1 page using vba
  453. View Columns with filter enabled
  454. How do i get a MonthView or DatePicker object in my VBA toolbox?
  455. Event Handlers & Validation Lists
  456. Print Button Macro with Multiple Conditions
  457. Filter a List
  458. How can I create a list of links (A to B) & search for both A & B
  459. Possible to automate copying active cell in Excel, and pastingcontents into Search box of webpage
  460. CopyPasteCode
  461. Macro Takes Long Time To Run
  462. retaining variable values across modules
  463. Worksheet Jump
  464. Recordset - Urgent help need
  465. Print using ExecuteExcel4Macro
  466. Taking value from one array and assigning to another array
  467. Printing
  468. Setting up a Login
  469. Lines user forms
  470. Reading Excel 2007 Rows in C# / .Net
  471. delete unwanted colomns, empty colomns
  472. Printing
  473. "LARGE"
  474. Loop not working properly
  475. Exporting data from MS-Access to Excel
  476. select pivot table range
  477. pivot table?
  478. How do I hide a cell's formula?
  479. Yield VBA function missing in Excel 2007
  480. Running macros automaticaly
  481. How do I unhide all sheets on the left of Excel
  482. Cancel if the first one is found
  483. Conditional Formatting - 6 conditions
  484. How can I format a cell to automatically assign a new number?
  485. TTF File
  486. Arrays and Macros
  487. This must need some VB programming.
  488. How to put lines with certain text (from a file) in an array
  489. display a timer while an ODBDC connection opens.
  490. Leaving a blank row
  491. names of variables in array
  492. Determine if filter set on specific column
  493. Runtime Error 32809
  494. Recording Macros
  495. Find duplicated values and paste range results on next sheet - nextavailable row
  496. RESIZE range to exclude totals row
  497. Change Button Color
  498. Formula needed for date range report - Excel 2003
  499. getting data from two excel file
  500. copy application path to clipboard
  501. Problem programming a formula
  502. MS Query + last 5 instances
  503. Value not matching
  504. Formula error; was working
  505. Use one Macro on multiple workbooks
  506. Automate Data-entry in IE application
  507. ADO Recordset
  508. Compare and Merge
  509. Macro creation help
  510. Listbox Value = Null ??
  511. Retrieving Data from another sheet
  512. Help whith Data parser
  513. Macro pack
  514. Set value of cell to calculation
  515. Joining SQL Server Stored Procedure to SQL Server Table
  516. Alphabetize Columns
  517. Toggle between original background colour and none
  518. decimals: in Europe they use a comma
  519. Create and print simple maths problem sheets for kids.
  520. Pivot Table problems Excel 2002
  521. Time, Distance, Speed
  522. Problems with date format when reading external excel sheet
  523. add cells value base on word's color
  524. getting value in one cell by typing such as like 'M' or 'F'
  525. GetOpenFilaName
  526. Data define and search function request?
  527. Combo box source from other workbook
  528. Print referenced file
  529. ERROR HANDLING question
  530. Need Help writing Print Macro
  531. Attach files in an excel spreadsheet column
  532. ERROR HANDLING
  533. VSTO Excel Rows to SQL Server 2005
  534. Problem - Lookup returning value of last cell in range when no matchoccurs
  535. prevent creating a copy of file
  536. Need User Name
  537. Need macro to move cell contents from one sheet to another
  538. creating new function in Excel for Medians
  539. Substitute Programme
  540. passing a value back to original routine
  541. Re: Find date of 3rd Wed of month
  542. Copy a procedure from one project to another
  543. Basic user form question - hjow to write to a text field
  544. What proportion of users on each version of Excel
  545. Download #1: World's Major Stock Exchanges Tracker
  546. Find date of 3rd Wed of month
  547. Formula
  548. Excel waiting for OLE action - driving me crazy. Help appreciated
  549. Consolidating via vba not updating properly
  550. Highlight (ie Select characters in a textbox)
  551. Re: Problem with macro
  552. Opening subfolders in sequence
  553. Normsinv funciton
  554. Handling an array
  555. Sharing modules on Server?
  556. Adding hints to my vb functions
  557. [Beginner's] Increasing numbers in a table
  558. [Beginner's] Adding a letter to a cell by clicking the cell
  559. need formula for average of rolling 4 rows in excel document
  560. how to find value on the cross of row and column
  561. playing wma files
  562. Macro wont run on cell change
  563. prob in IF then else statement
  564. Personal.xls - File error: data may have been lost
  565. Problem with setting object using session ID (emailing ffrom VBA)
  566. FORMATING NUMBER FORMATS TO EXACT NUMBERS.
  567. Publishing XCL Range to HTML to insert into Email Body
  568. Inter Macro
  569. Reference Excel UDF from Outlook
  570. Runtime error on a PC: Selection.Borders(xlEdgeLeft).TintAndShade =-0.14996795556505
  571. xls name reference
  572. Visual Basic Excel How do I determine if cell is numeric or text
  573. Queing Math Problem using VBA and Dictionary Object
  574. How do I delete spaces that follows data
  575. Disable "Cut" and "Drag & Drop" but not copy
  576. Freeze end of mont results
  577. Input/combo box
  578. Worksheet Change event on different ranges with data validation
  579. calculating nonblank cells with conditions
  580. SQL Server Stored Procedure
  581. Launch a program from Excel
  582. Embedded blank rows
  583. How do I filter 50,000 rows with out frozen the screen.
  584. Format
  585. Copying Charts - Memory Leak - Excel 2003
  586. NEW Worksheets - Limitation on Creating and Deleting (-fes)
  587. COMPILE LOG FROM INFO WITHIN MULTIPLE TEXT FILES
  588. MAKE A EXCEL LOG SHEET FROM TEXT FILES (10000+ FILEs)
  589. Worksheet_Change after validation
  590. Using a different Comment Indicator symbol
  591. in-cell on-the-fly list/combo box
  592. Unknown sheet in Project Explorer
  593. How to upload data from a spreadsheet to a Enterprise Managerdatabase
  594. Set Find to look in Values instead of Formulas by default?
  595. get rid of slashes
  596. The Dear x at the top is formatted as times new roman font...why?!
  597. Workbook_Open - AutoCorrect Routine Doesn't Work
  598. Comparing columns for no match
  599. Automatically updating MS Query Tool results in excel
  600. Making Find ignore parts of a sheet?
  601. Exporting Data from MS-Access to Excel
  602. sort dates
  603. hiding a row
  604. Error Handling then continue running
  605. How we resize image in harddisk ?
  606. delete row
  607. xls to exe
  608. Do not Run Macro
  609. different text colours in listbox
  610. How to get e new line in html email (Ron De Bruin's code)
  611. Compare Kotak Credit Cards
  612. match
  613. Allow paste special only to one worksheet and not to all
  614. finding matching cells (Excel 2007)
  615. Can't create sheet when importing Excel
  616. Problem with .send from microsoft example for vba send mail from excel code
  617. Run-time error '1004': Method 'Range' of object '_Worksheet'failed... again!
  618. Macro loop with messagebox
  619. Create Appointment in Outlook
  620. Run-time error '1004': Method 'Range' of object '_Worksheet' failed
  621. Excel VBA Array Function...What's wrong?
  622. don't allow row to be copied twice
  623. Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard
  624. Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard
  625. Advance filtering Update
  626. Input box copying the wrong rows
  627. Dynamic sum
  628. App.Datevalue function not in VBA
  629. Excel application for backup and sync of files between folders and computers
  630. How to add username in excel
  631. excel.interop insert a column in between existing columns
  632. loop issue
  633. filldown with formula
  634. Macro Keyboard Shortcuts
  635. How to store the reference of Workbooks in an array.
  636. How to find max cell location
  637. dynamic pivot table selection
  638. Macro in one workbook that names a range in a different workbook
  639. Excel VB to open Access DB
  640. Hard code Listbox Header Text
  641. How do you get a parent collection object to listen to all if it's child objects?
  642. XML Maps and List of Complex Data Structures
  643. How do I find the first unfrozen row in Excel using VBA?
  644. Calling Embedded Object macros from Excel VBA
  645. Keyboard alternative to 'break'
  646. Macro for pasting on active column
  647. Merge data with Multiple-to-1 relationship
  648. filter macro
  649. Error -2147418113 (8000ffff)
  650. RE: Invalid or unqualified reference error
  651. RE: Invalid or unqualified reference error
  652. Invalid or unqualified reference error
  653. Invalid or unqualified reference error
  654. Invalid or unqualified reference error
  655. Invalid or unqualified reference error
  656. changing the default background color of selected cells...
  657. Change Pivot Table PageArea Selection
  658. Copying exact formula from one worksheet to another within a macro
  659. copy external data
  660. InputBox doesn't allow non adjacent rows
  661. Disable Userform Events
  662. I want to change Excel, not just the current Workbook
  663. Forgot where I put the Select all VB code, help.
  664. Splitting records
  665. Conditionally Hiding Comment markers.
  666. ChartAdd event for embedded charts
  667. Storing data in an add-in for use later
  668. in range
  669. TextBox gets contents from dynamic user pick?
  670. How to set Optionbox value from code?
  671. programmatically edit workbook internal data conn. file location
  672. copy from external sheet
  673. Show "Summary" when macro has run
  674. Conditional Protection
  675. Fill 5 Column Listbox from Range
  676. Userform loading, but Content (Inside border) is BLANK?
  677. Running a formula & For...Each
  678. Delete enter key rectangles in a cell.
  679. Remove add in from inactive list excel 2007
  680. R4 ds/dsi firmware-drivers de R4 Sdhc. R4 ultra, R4 new, R4 III upgrade, R4 v3
  681. error when running an excel 2004 macro in excel 2000
  682. Mac Excel 2008 Problem Using Excel 4.0 XLM Dialog Box Option Buttons
  683. Command button position and screen resolution
  684. WinSQL Query - Syntax for use in Excel
  685. Bold font in shapes
  686. Referencing cells in another worksheet
  687. autofilter on a protected sheet
  688. Word wrap and cell size
  689. Interactive Code2
  690. Switching workbooks with Personal.xls
  691. How to code macro to shut down my computer?
  692. Positioning a Comment
  693. date stamp
  694. End of Column
  695. Excel waiting for OLE action - how to resolve
  696. Macro Dialog Box
  697. Opening files with variable names
  698. List all files in a sub directory
  699. Help With MS Query Sum Distinct
  700. Macro Security
  701. MZ tools Msgbox uses "Call"?
  702. Transpose macro
  703. select rows & copy into a different sheet
  704. Assistance with code
  705. Enter VBA multiple sheets
  706. Trying to make loop to create series of charts in Excel 2003
  707. What formula should I use?
  708. countif for multiple criteria?
  709. Calendar Function in Excel
  710. Unable to Record Macro in 2007
  711. Speech.speak Can I change the voice in code?
  712. Run the macro once the cell value changes.
  713. ISNUMBER Logical test
  714. Help with Excel UserForm
  715. Writing Changes in XL Worksheet to AccessDB
  716. Re: Excel 2007 - ADO - More than 65536 rows - Problem ?
  717. Objects, Cell Referencing and Sorting
  718. MSG BROUPED BY GROUP
  719. Accessing Excel Documents on a SharePoint Site
  720. Print Dynamic Report: Macro
  721. close form
  722. Running a SQL query off an excel table of data
  723. Excel 2007-Pivot Chart Expensding data source
  724. chartobjects.activate fails
  725. Paste Once No Format Change Help
  726. Filling in a chart from a list
  727. Run-Time Error 1004
  728. Require answer dependant upon earlier cell information
  729. Macro to print series of dates
  730. Resize CurrentRegion by 2 rows at the bottom
  731. Excel 2007 - ADO - More than 65536 rows - Problem ?
  732. e-mail notification via Outlook
  733. how to get the value object back from 'customproperties'?
  734. Reset Followed Hyperlinks
  735. Print Preview
  736. Transferring XLOPER from VC++6 to VC 2008
  737. Macro for displaying formula
  738. how to send key "press" a key in a dialog?
  739. chart - in order of high to low
  740. How to remove last character of each value of an array
  741. Formula issues
  742. Workbook backup macro
  743. Help with random numbers in gaming system
  744. Auto file naming with macro
  745. Copy row grouping from one worksheet to another
  746. SPC XL and VBA
  747. Another VB Code Question
  748. Using SQL command to access Excel
  749. Data storage in arrays
  750. Macros in Excel 2003
  751. VB Code Question
  752. Allow Macro to Work by Selecting Cell Description
  753. Tell whether or not Sub B was called by Sub A?
  754. Cut off end of a string
  755. Is it possible - find all of a named range?
  756. Unable to set the LeftFooter property of the PageSetup Class
  757. Switching between open windows
  758. Last Column
  759. Link PivotChart to PivotTable, whilst hiding fields
  760. Assign Range passed to fuction to an array
  761. Array assignment
  762. Macro to delete duplicate cell
  763. RE: URGENT! Range.find not working...
  764. need help fixing macro
  765. Get Part of String
  766. Conditionally format header when column is filtered
  767. What is the VBA for the Excel 2007 "Switch Window" command button?
  768. Wildcard Usage in Combo Box Programming
  769. Simplify code copy based on condition
  770. xmlHTTP.Send Questions
  771. Excel waiting for OLE action - how to resolve
  772. how to call a vb.net dll from VBA
  773. WorksheetFunction.Index producing error
  774. combo box control source
  775. Problem with Worksheet Activate and Sorting
  776. How can I read an Excel database in C#
  777. Fill Listbox Columns With Other Userform Control Values
  778. Delete Entire Row
  779. Updating
  780. Making the source of a Hyperlink the Active Window
  781. VBA to pull information
  782. CuteFTP
  783. VBA Excel 2007 SQL query
  784. slow macro help
  785. Sending a variable to another workbook?
  786. Excell VBA Macro with Symbols
  787. Macro to insert a cell after the selected cell
  788. Range on Userform only if on worksheet
  789. Userform design
  790. record cell activity
  791. VBA Excel: Trigger a refresh upon data change in sql connection
  792. Progress bar & explanation of code
  793. Run Time Error 1004
  794. Deleting macros by running a macro?
  795. Emailing a Hyperlink of an Excel Workbook.
  796. Macro to copy cell contents to comment
  797. add-in timing problem?
  798. Excel Versions
  799. Linking cells between worksheets in same workbook
  800. Slidebar (scrollbar) insertion through VBA
  801. Difficulty with Arrays in Excel's DECLARE statement
  802. How to print LinEst result to a spreadsheet using VBA
  803. "Out of Memory" error
  804. How can i include a .vbs file in another .vbs file
  805. Adjusting the size of a picture
  806. SelectionChange problem
  807. Wait with TimeValue using the seconds from a worksheet cell
  808. How to disable a workbook?
  809. Excel
  810. Hoe to disable a workbook?
  811. edit range name
  812. compare two Excel files for differences
  813. How to add Chart_Activate code using VBA
  814. Japanese in Macros
  815. Shortcut to compile VBA Project
  816. Return to UserForm
  817. RE: Exporting to another excel file
  818. Format Row Conditionally
  819. Variable number of copies to print
  820. Unable to read cell value when cell contains a string using CSharp
  821. If ODBC DSN connection fails
  822. Add-in to improve goto->Specials
  823. Difference between xlSheetHidden and xlSheetVeryHidden
  824. detect userform
  825. Sum row totals for multiple items in a worksheet
  826. How do I use VB to adjust text box internal margins?
  827. Where I can find a list of all office com Interop errorcode?
  828. Print Setup Not Set
  829. Grab the right please
  830. Exporting Code
  831. Excel Import
  832. This seems like it should be so simple! (PivotTable "Show values a
  833. Freefloating ActiveX comboboxes
  834. code for box
  835. Tom Hutchins macro- Filter
  836. problem with macros using Excel 2007
  837. How to launch a live map application using selected Excel data
  838. Accessing SQL Server in Excel Macro
  839. Setting cell colors using variables
  840. Prompt user for file to be opened
  841. Changing a menu button in my XL template
  842. Find Replace Visual Basic
  843. Excel Macro user function used in several sheets in same workbook
  844. Access doesn't always close (Excel VBA) & passing parameters
  845. Splitting cells
  846. Interactive Online Statistics Courses start Friday
  847. excel button to save sheet contents to new workbook
  848. Column Split and Extraction
  849. Email Multiple Files to Multiple Email addresses
  850. Launch an .exe like notepad.exe with a macro?
  851. Delete Rows for given conditions.
  852. VBA .activate
  853. Code lost when email to another site
  854. sum value of four textboxes into another text box
  855. Conflict with Valid Range Reference Error in Microsoft Excel 2007
  856. How to display alert message in Excel 2007
  857. Vista HP + Excel 2003 code = Lost VB Project
  858. Print rows with special value only
  859. Insert excel sheet in a powerpoint presentation
  860. Sorting with worksheet activate
  861. User Defined Functions in Automation Addin behave differently in 2
  862. Lookup, match dates and confirm fase
  863. 0x800A03EC error during Application.WorkbookOpen event handler
  864. Copy rows that matches cell value
  865. How to store a reference of a excel workbook in a variable in vbsc
  866. Condition formatting
  867. Need a hand with date calc
  868. protecting multiple shts with separate pwrds
  869. Set Rng = Range("S2:S293")
  870. sharing a file b/w different users
  871. new to date
  872. When Class object get created
  873. Range into ListBox excluding blanks
  874. Positioning the selected row in a listbox
  875. Hyperlink in Commandbutton
  876. Formatting values populated by VB Code
  877. Screen tip indicators missing - Row Height, Column Width
  878. Csv date format problem
  879. SumIf ( range, criteria, sum_range )
  880. Com Interop Errorcode
  881. How to copy only one value from range to worksheet
  882. Need assistance with code, please
  883. wrksheet selection change
  884. Remove row in list based on user input
  885. Re : Excel to by-pass Private Sub Worksheet_Calculate()
  886. Telephone and Floor Plan help please
  887. Disable Button When Worksheet is Locked
  888. Cells.Clear
  889. Broke my Beep
  890. How to copy Range and Paste as Values (from hidden sheet)
  891. How to copy range and paste as values
  892. Custom CommandBars
  893. GoTo won't work - why?
  894. RE : filtering problem
  895. Looking for a more elegant way to program code
  896. What are VBA consequences of moving workbook?
  897. Value compare problem, As Single variables Feb09
  898. Creating an array of strings
  899. Textbox linewrap with vbCrLf problem
  900. Abbreviate Workbook/Sheet/range
  901. moving to new cell and scrolling
  902. Macro Copy cells and Insert/shift down
  903. Tab functionality in VBA form in Excel 2004 for Mac / Macintosh
  904. GetSetting and SaveSetting
  905. Cell referencing in Macros
  906. Excel 2k7 VSTO Addin
  907. Deploying Excel 2007 VSTO Addin
  908. Click on a hyperlink to hide or show a spreadsheet
  909. Data define and search function request?
  910. Pentium serial number
  911. How can I save variable when 'end'? The user then reactivates the
  912. .ReferenceStyle=xlA1 Converting Relative to Absolute References?
  913. Internet Exlporer and Vista
  914. Time format
  915. identify first macro run
  916. Context Menu Customising
  917. DeleteModuleContent doesn´t work in some computers...
  918. Testing parsing of code tags to newsgroups
  919. Copying Cell Conflict with Worksheet Change to UpperCase
  920. Auditing Excel sheet - Message Box on exiting excel
  921. VBA code causes Find and Replace dialog box to lose focus
  922. Horizontal Scrolling
  923. Interactive Code
  924. Auto pull data from a website
  925. Realign Comments
  926. =hyperlink causes file opening to change window size
  927. Pivot Table VB code?
  928. Need a click, beep, or a burp
  929. Need a click, beep, or a burp
  930. file converters
  931. Conditional Formatting Macro within a Chart
  932. moving charts
  933. Greater than Less than question!
  934. Reselect a TextBox
  935. Can I Sort (A-Z or Z-A) Pivot Table Data or Fields using VBA?
  936. Excel 2007Chart updating problem
  937. dispay dates return in cell
  938. Text wrapping
  939. Logic statements/Pulling data
  940. Deploying an Excel 2007 VSTO Addin
  941. How do I add Microsoft DAO to the referenced lib in Excel 2003
  942. Verify Canadian Postal Code ~ make the code work
  943. Check if file is open, if yes close woorkbook
  944. How can I change the Macro Security level in Excel 2003 viewer?
  945. array error
  946. show sheet1 on startup
  947. Temporary Files While Importing Data In Excel
  948. Supress message window
  949. copy/paste without highlighted cells
  950. Clear value in cell when the "enter" key is pressed
  951. DSUM I think
  952. combobox in user form
  953. Macro to paste value to a file same as A1
  954. Excel value onto word userform
  955. Unzip message box supression
  956. autofilter macro
  957. Original read only file not closing
  958. User Form Flickering
  959. Select Named Range in Worksheet
  960. Bubble Charts - Series and Bubbles Missing (sometimes)
  961. Macro Help
  962. disabling automatic startup of macro in vba
  963. missing library makes Format() disappear
  964. Row Deletion
  965. how to reference selected cells in SourceData
  966. Web Import
  967. Controls
  968. Command buttons DEAD
  969. Function to calculate dates
  970. Pivot tables - edit pivot table and updating master data
  971. Refresh CRM data in Excel 2007 using VBA
  972. Looping Through Worksheets Given in a List?
  973. Load Behaviour of Addins
  974. Button Event Handler in Excel cell
  975. Strange exception when automating excel
  976. how to remove the outlook confirm window when use excel to send email from outlook?
  977. listing excel file in a folder
  978. Printing a Page Automatically When All Cells are Filled
  979. Save As Help
  980. Userform help please
  981. Macro to take cell ref of the object
  982. Export Large Data
  983. Update Data in 3 other Workbooks via Macro
  984. Access to spreadsheets with VBA User Form up
  985. Toolbar to launch Macros
  986. dtpicker to display current date when form opens
  987. Ato move row and checkboxes visible by user
  988. how to lock/unlock certain cells
  989. Beginner VBA user asking advanced questions
  990. Recycle Bin path
  991. Save as
  992. RE: How do I set up a macro to help me to do bank reconciliations?
  993. RE: visible method of worksheet class failed error
  994. Count merged cells as if unmerged
  995. variable number of rows.
  996. RE: SQL statement not working
  997. copy row if contain keyword
  998. Best way to solve my issue
  999. RE: Respond to Excel message box from macro
  1000. Respond to Excel message box from macro