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. Using VBA to track workbook changes
  2. List all the named ranges & the cells they refer to on a blank she
  3. Problems with saving WorkSheets that have External Links
  4. replace VBA run-time error message with custom message
  5. Excel Macro
  6. need to make code more efficient (if possible)
  7. Excel import
  8. Macro using Save As Problem
  9. How do I get dates automaticaly inserted when editing excell
  10. Can't get past Line 3 of code
  11. VBA & User Form modules vanish
  12. Select columns when drilling into a Pivot Table
  13. Loop for copying data, then pasting in a continuous row
  14. macro to print a sheet if a cell is a certain value
  15. Keep calculation time down in large Workbooks
  16. End if with block if - Pivot Table Problem
  17. Loop and name
  18. Configuring Excel 2003 to control access to Trusted Publishers
  19. Export from excel into an invoice template
  20. Event when selecting an item in a combobox?
  21. Got the Copy/Cut Code But what is the Paste Code
  22. Runtime Error -2147417848 (80010108)
  23. better way
  24. Return reference from object function
  25. Global Variables
  26. Search and open feature
  27. Insert VBA code user a macro
  28. Return Array Dimenions
  29. Closing Excel Program correctly?
  30. Chart making
  31. addressing type in FormulaR1C1
  32. Hide columns in macro while protected
  33. Error loop through #N/A values
  34. Quiting Excel program?
  35. Changing the row and column in R1C1 formulae
  36. call macro X by cell value
  37. Macro to extract the data in a certain cell
  38. Can one close Excel progarm with a macro
  39. load event when specific workbook is opened
  40. Legend moves across chart
  41. Function returning null value instead of string value
  42. Help with MAX code
  43. positioning charts
  44. Put worksheet names into worksheet Excel 2000?
  45. TextBox question
  46. How to format cell's borders by using VBSCript?
  47. using a the active cell in a range command....
  48. VBA script to add text to cell.
  49. VBA script to delete content in merged cells.
  50. Can I get VBA script to read a word with both lcase and ucase lett
  51. Opening Excel workbook via automation doesn't fire event procedures?
  52. CommandBar control ID help.
  53. VBA excel using arrays and loops
  54. save as
  55. rounding out "time"
  56. Excel 2007 problem with macros
  57. userform copy data to more than one location
  58. Amateur VBA developr seek Professional similar for exchange of insight
  59. run time error 9, subscript out of range
  60. run time error 9, subscript out of range
  61. WriteReservedBy Location
  62. VSTO Form Issue
  63. Search a range to find cells containing formulas
  64. How to know if a validation dropdown exist
  65. Choosing multiple Series for a XY Scatter (simple?)
  66. Find ALL WorkSheets according to 2 ComboBox Values.... Help with Code
  67. Open Access form from excel hyperlink
  68. Average If statement
  69. Variable IF statement (in VBA)
  70. Matching Cell Colors (Cond. Formatting)
  71. Moving Excel Macro Problems
  72. Breaking Into Seperate Files
  73. Concatenate Problem
  74. Date formatting in Excel VBA Text Box
  75. Using Shell To Get File Info
  76. For next loop carries on after criteria is met changing other cells????
  77. saving email with CDO
  78. UNC Database Query
  79. option view (Sheet Tabs)
  80. Scanning barcodes into a worksheet
  81. Need macro to autofill when there are blank cells
  82. Module, create toolbar/handle clicks
  83. help! user form issues; can't find subroutines; appearance issue
  84. can I use a pivot table and update my source data (like Hyperion)
  85. Loop without Do error
  86. returning the activecell's page number
  87. How do I set data validation in VBA
  88. How to access muliple tabs of sheet as variable of an Array
  89. Variable in function problem
  90. Problems During Load (XML file Open)
  91. Auto Grouping of Option Buttons
  92. Macro Fault - Excel 2002 sp3 Portuguese
  93. how to receive data through textbox and save the same in excelshee
  94. Email Hyperlink
  95. excel and data access
  96. Text alignment in a cell from VBA
  97. odd sort issue with numbers
  98. web query data
  99. Combobox: Make "Enter" = Select
  100. Move Selected Rows To A Different Sheet
  101. Activate cell in column B after performing Find
  102. Sorting By Largest Value In A String
  103. Need syntax for RUNning a Word macro with an argument, called from an Excel macro
  104. rearranging data
  105. Advanced Filter Error
  106. Help needed replacing multiple cells from a list of values.
  107. Print pink sheets
  108. Type Mismatch!!!
  109. Open workbook macro if time is between???
  110. How to extract email addresses to new column
  111. trade tracking
  112. Excel 2007 Conditional Formatting
  113. Faster way to code this
  114. Trouble with Code to change sheet name
  115. Numeric Userform Help
  116. Character Locations in Strings
  117. Combobox: Autoload property: WTH is it???
  118. Running Macros
  119. ListObjects.Add error
  120. Database Connection with Informix using VBA
  121. "Subscript Out of Range" Errors For Ranges
  122. refEdit and Excel crash
  123. Ignoring comma when creating validation lists
  124. Hyperlink in access from excel code
  125. Send Xl Cell info to Word
  126. Placing buttons etc on userform
  127. Macro for Counting the number of records in a worksheet
  128. Listbox not refreshing on update
  129. Pictures.Visible question (after adding many pictures, they stop disappearing)
  130. Remove 0D0A from cell with word
  131. Print Refedit range?
  132. Use excel vba to Call macro from Access
  133. renumbering a column
  134. Save/Load txt files UserForm question
  135. Assistance please. password on opening excel file
  136. Please help! Copy sheet to another sheet from cell value
  137. Automatically Saving A Workbook
  138. Type Mismatch: array or user defined type expected
  139. fill down multiple cells in the same column
  140. Saving and searching Macro
  141. rename cells with a macro
  142. Automating a workbook ???
  143. Automating a workbook ???
  144. ultiple if Statements
  145. Function
  146. finding which cells changed after a calculate?
  147. Force to enable macros
  148. "Frozen columns"
  149. Runtime error 1004
  150. How can I refer to the ActiveWindow
  151. R/T 1004 Error
  152. Excel11.xlb
  153. calculating values based on text in other sheets
  154. Move shape, object, pic to center of new cell based on cell value
  155. Increase columns with interop
  156. how to trace through VC++6.0 code which is called from Excel 2003 VBA
  157. Easier said than done
  158. Changing background color when changing value
  159. Exclusive choice checkbox
  160. Automatically copying rows
  161. check/uncheck a checkbox
  162. Replacing cell ref with active cell
  163. Formula should retain
  164. Help Plsss
  165. Workbooks within workbooks
  166. Remove blanks
  167. Multiple IFs
  168. Excel Automation : numbers Copy/Paste issue from VB6
  169. Userform- Formating numbers in Textboxes
  170. Looping a macro x times(x being activecell.value)?
  171. initials + increment
  172. Copying parts of sheets
  173. VBA CODE: consolidation of excel sheets
  174. disable control
  175. disable control
  176. Indentifying the last row in a sheet with data in it rather than formulae
  177. Changing Sheet("Name").Select Name
  178. macro to delete zeros and formulas
  179. Use a macro to merge cells in a column that are the same
  180. Copy to next empty cell in another workbook
  181. Linking to Excel
  182. Connection object vs. Opendatabse on Databaseobject
  183. Dumb question
  184. Replacement or deletion of data after filter
  185. how to link to DB to update data?
  186. breakeven formulas
  187. Change a row of headings based on other selected cells
  188. Return top 3 occurances of word in list
  189. Rename closed workbook
  190. Selecting Just Data
  191. Date formatting cells w/ VBA
  192. Date format changes...
  193. Page Breaks based on cell data
  194. 1.Open workbook. 2 copy data. 3 replace data. 4 save workbook.
  195. Convert IF formulas to their values
  196. Convert numbers (numerals) to words (text)
  197. Simplifying my previous Request for Assistance
  198. Resize DataForm
  199. Removing All Formulae From a Workbook
  200. Pivot tables macro
  201. Excel and VB.NET Help!!!
  202. Invoke Java from Excel
  203. Excel and VB.NET Help
  204. Problem writing formula
  205. DSN Connection with OpenRecorset
  206. excel, visual basic and serial communication
  207. adding and copying rows
  208. import data (html files)
  209. Using Redemption to email cells with Ron's mailing code
  210. closing subroutine
  211. Adobe PDF ActiveX : shame on Adobe..!
  212. Updating Linked Data in Excel
  213. Problem with code for merged cells
  214. Rearranging columns
  215. Contents of Excel11.xlb
  216. Trying to run macro on the BeforeSave event
  217. Execute Macros from Other workbooks on current workbook
  218. One sheet to another..
  219. macro problem???
  220. Compare 3 lists
  221. How do I create a form based on a list using vba in excel
  222. How do I do? A personalized form, similar to Show data Form
  223. Automatically Creating Worksheets
  224. Deleting rows as if there are no qualifiers!~
  225. Temporary file open; not visible at all
  226. One IF, Two THENS
  227. Inserting Rows
  228. Limit Find to a single column
  229. Hide Columns Based on Condition
  230. Hide Columns Based on Condition
  231. Where am I
  232. Return codes from called macros
  233. Script Newsgroup
  234. Publishing Excel Macros to Web Pages
  235. Error Creating Chart
  236. In need of a formula
  237. using code variable to write cell formula
  238. Excel desktop shortcut to cmd button in worksheet
  239. Create programmatically list of combinations for choices from data sets in excel vba
  240. Changing Sequential Object names
  241. One column to multiple columns - with a twist
  242. One column to multiple columns
  243. Type Mismatch error - tried .text & .value
  244. Object Library References not transferring
  245. Error with Calculating date difference using TODAY()
  246. Cursor change during code execution
  247. Open Word From Excel, Different Actions
  248. VBA Script to search for a specific cell - Help needed
  249. Log when cells are copied
  250. Can anyone help finding two obscure commands?
  251. macro for rearranging data
  252. inserting columns, writing in cells
  253. How to get a tick in a drop down menu
  254. Get Properties Of Closed Workbooks
  255. Filters
  256. Populate Combobox with Pivot Table Data
  257. Correct find syntax
  258. Can I insert cell values into an email message this way?
  259. Breaking password on VB Code
  260. Run-time error 1004 - General ODBC Error
  261. Use Excel as a network packet sniffer?
  262. Need some help with a silly error...
  263. Word document.
  264. break line in text cell from ASP
  265. Hidden sheets and macros
  266. How to del clients fm spreadsheet using a list fm other sheet?
  267. Automatic Functions?
  268. Need help with Text to Column in a macro.
  269. Stacked Graph
  270. Excel ComboBox / Copy Error
  271. Excel code for exported spreadsheet
  272. Macro deleting certain cells
  273. Format(Time, "h.mm AM/PM") question
  274. Need Help with Run-time error
  275. How do I calculate the distance between 2 postcodes?
  276. Cannot set ColumnWidth past column 148
  277. Cannot set ColumnWidth past column 148
  278. how can i create quiries in excel from ODBC data source
  279. Count spaces in front of text
  280. Copy Data into Template Worksheets
  281. Force use of standard function
  282. how to write excel macro for repeated dynamic data
  283. Data Validation...A Multiple of a number
  284. Testing a range for blanks
  285. Checkbox connection with Macro
  286. automatically moving data depending on date
  287. Automatic Updates to Spreadsheet - HELP
  288. manipulate color with code
  289. Import Excel data with .NET
  290. Column number
  291. live time on userform or within frame
  292. Column number
  293. only cells that are colored yellow
  294. Refreshing Worksheets
  295. on time macro
  296. Is it possible
  297. How do I update without sheet select
  298. unload userform problem
  299. paste data in cell after user has defined where
  300. Need macro for protecting individual rows in a worksheet
  301. excel runtime 1004
  302. Paste numbers
  303. Efficiently Generate 88 Chartsheets
  304. Simplify Cell Formulas - AGAIN
  305. need macro for create new email message and send it
  306. if macro is made disabled.??
  307. Use of Subversion / CVS / Source Safe
  308. Find and remove blanks
  309. Drop down box with associated passwords
  310. how can vba detect what is currently selected?
  311. coloring columns in pivot table
  312. Is it possible
  313. Userform SpinButton problem
  314. when to use a module & when to use a project
  315. several scripts in one single script
  316. Next without for
  317. Userform Gallery
  318. How to calculate: sumproduct / db??
  319. Is there any way?
  320. Using FormulaR1C1 to find fields begining with spaces
  321. Absolute value
  322. is there not a simpler way
  323. How to protect few cells of the worksheet from editing?and few other doubts also plz help
  324. Close workbook
  325. writing excel
  326. USE OF DROPDOWN in Combobox-a problem
  327. excel vba word merge printer error
  328. Want to connect to Outlook Program; but can I keep my Web Page?
  329. Protect/UnProtect Project (code) via VBA?
  330. Enhance your domain skills required for the job
  331. Multi Dimensional Array
  332. please help someone (again posting)
  333. Remove space and "-" character
  334. Printing Problems
  335. Workbook_Open() and Object Not Found
  336. Command Buttons and not Printing Them
  337. Re: ComboBox Row Source across ALL sheets
  338. Next Known Date
  339. userform multitask ?
  340. ols
  341. Dependent ComboBoxes as Critiria for VLOOKUP or OFFSET
  342. Help. Getting error retrieveing version number
  343. do not allow same data twice
  344. Options Button for Excel Userform
  345. Simple VBA question (?)
  346. Help! Stupid CommandText Problem
  347. conditional formatting and VLookup
  348. column and row autocorrect?
  349. Inadvertent macro
  350. Split date into Variables
  351. Workbook_BeforeSave Event
  352. duplicate data
  353. Case Selection Example
  354. Taking multiple information from one cell.
  355. Excel - how to prevent new office version from upgrading word object reference
  356. Delete Row Based On Two Columns
  357. AutoFilling To A Variable Number Of Rows
  358. How can I activate scrollbars in an own userform?
  359. Macro - IF command
  360. Currency Converter From Website
  361. Date format change
  362. Copy and paste macro
  363. moving data
  364. 2 VBA enhancements
  365. Paasing Values from one Array to another
  366. Disconencted recordset for DSN less connection
  367. Using Msnstockquote from excel VBA
  368. Application-Defined or Object-Defined Error
  369. cell name - macro
  370. View values; ignore header database
  371. Modification to existing Code
  372. write in excel
  373. Auditing Code
  374. How to exec a commandbar button while cell in edit mode
  375. Designing a spreadsheet
  376. How to exec a commandbar button while cell in edit mode
  377. Frames and buttons
  378. How to take a range input in a function and find the frequency of data in it.
  379. Change the line color based on the value selected in combo box
  380. Excel add-in that may help the color blind
  381. Frame
  382. delete contents of visible cells only
  383. A 64-bit variable from VBA to VC++ dll and back to VBA
  384. Formulas within pivot tables
  385. Placeing buttons on spreadsheet
  386. Having a cell display certain text or formatting when the worksheet is protected or unprotected
  387. Help with open files
  388. Locking panes
  389. Runtime error 91?
  390. Help with coding please. Newbie.
  391. Digits after the comma in Userform
  392. Form
  393. Is there a way to unlock a project in VBA if you know the password
  394. Manipulating Text File
  395. excel add-in write text
  396. How to write to the VBE of a closed workbook?
  397. Freeze pane
  398. RefEdit problems
  399. Referring to a row or column
  400. Delete blank sheet
  401. NickHK
  402. VBA and Printing
  403. Calendar Control Addin
  404. Disable excel message
  405. Calendar value
  406. Scrolling a Text in Worksheet
  407. Calendar value + 30, 60 or 90 days
  408. Wordart in userform??
  409. Numerical integration to a maximum value using VBA
  410. Modifying a database based on changes in an Excel document
  411. Macro for sorting color data
  412. Add Hyperlink
  413. Expression Difference?
  414. How to run a Macro specified number of times?
  415. Updating a cell based on contents of two other cells
  416. ComboBox Row Source across ALL sheets
  417. Deleting WorkSheets MANY
  418. Keeping buttons stationary when unhiding rows.
  419. Setting Default Save Path
  420. Zip codes and Distances
  421. Catching an error
  422. Open Excel with a XML file and SaveAs XLS
  423. macro for sumif formula
  424. Copy Excel chart into new ppt slide
  425. Math involved. Excel speed optimization question. UDF vs. longer excel equation
  426. Prompt for Action before closing workbook
  427. Event Change Question
  428. My macro won't find the last row !
  429. Check the content of a textbox?
  430. Find and remove blanks
  431. Combining the IF and List functions
  432. "If Yes then Proceed..." Macro
  433. formula that takes part of a cells contents to another
  434. Choosing offset on condition found in combobox change colour of cell??
  435. Syntax Formula help
  436. Get VBA procedures from DB
  437. Date format to decimal format?
  438. Best match macro
  439. Evaluate Range of Cell
  440. Macro to Consolidate Worksheets
  441. Sequence of numbers
  442. executing macros upon opening xls files
  443. MS Access Query Identify Friday's records.
  444. RefEdit problems
  445. Format Part of Text Cell using VBA
  446. Pivot
  447. Dynamic Named Ranges - LINKING
  448. List box VBA script to clear cell in other sheet.
  449. RefEdit ???
  450. using excel to query asp page
  451. RefEdit ???
  452. copy unique rows
  453. msoButtonUp / Down for sub-menu items
  454. Adding a row on Open
  455. Pls Help on from date tranfer amount to month
  456. Adding a row on Open
  457. Is the list of Worksheets limited to "This Workbook"
  458. UDF sharing
  459. Newbie needs help on excel formula
  460. Changing format of cells
  461. query result through array on worksheet
  462. steping through all cells
  463. compatibility to EXCEL transformation
  464. Changing format of data
  465. Chart size
  466. how to execute a macro automatically
  467. Teaching Sub-Levels and Excel Nightmare
  468. UserForm
  469. Excel Icon??
  470. Filling TextBoxes
  471. Linest(known_y, known_x^{1,2,3)
  472. Copying and Pasting Using Row Counts
  473. pull rss feeds into excel
  474. how to use FTP in VBA
  475. Combo Boxes
  476. where can I find the trace precedents button on the toolbar
  477. Macro to "archive" cells
  478. Replacing macro buttons with a new set of buttons
  479. Textbox: Number of Characters
  480. peculiar error with Range() object
  481. Detecting abnormal values in a moving range.
  482. Searching array for date and changing offset colour depeding on combobox content?
  483. Problem with a converted office 2003 file with user defined functi
  484. company calendar: start date problem
  485. How to repeat a macro
  486. Modify Yearly Calendar to Monthly Calendar Excel 2000?
  487. R/T Error 1004
  488. Adjusting individual icon size in commandbars?
  489. Excel experts needed
  490. Converting data from row to coulm
  491. Transfer data as per there date in there month.
  492. Error trapping
  493. Sending Mail using VBA
  494. Row number of a specific value
  495. Using COM objects in Excel or VBA?
  496. protect formula
  497. Loop with Time
  498. Calendar Control
  499. printing macro,want to use beforeprint event?
  500. Grouping objects
  501. Printing labels from names and addresses in an excel
  502. is sheet protected?
  503. Window>Arrange>Tiled - all xls in directory
  504. Linking and embedding question.
  505. Sheet protection
  506. Trouble with lots of IF THEN statements???
  507. How to create a Delete method which frees memory occupied by my object
  508. How to find an excel sheet by its name???
  509. Custom button to call a macro in Personal
  510. Can't get the find statement to work correctly
  511. Last Row In Column..
  512. How to format userform label at design time?
  513. Making changes to most worksheets?
  514. string variables in file names
  515. Problem with macro speed.
  516. Basic VBA Question with Array
  517. moving xls files with macros to another directory?
  518. Command Button from Control Toolbox
  519. How do I stop the SQL Login screen when refreshing a query.
  520. Use of sheet codename in codeline - How?
  521. DATE
  522. Setting "r" to = range selected in an IF statement?
  523. Spellnumber Function
  524. COMMANDBAR MANIPULATION....
  525. Web Querry stopped working
  526. HIDE ROWS IF..
  527. commandbar scope
  528. VBA Code--------!
  529. ChartObjects Macro excel2000
  530. If staement and macro
  531. how do you create custom buttons in office 2007?
  532. VBA Help required..........!
  533. Import tab text data(more than 65K rows) into excel by VBA
  534. find and highlight
  535. Convert an Excel table to a list with VBA
  536. Save button
  537. listbox.value is empty even though there is data!!!
  538. How to automate with macro multiworksheet File using array variable?
  539. "On Error GoTo" syntax problem
  540. macro to open csv file on the web with password
  541. not your average activate event
  542. Retrieving data from Web page 2
  543. Right click event
  544. Formatting numbers in a text box
  545. how to determine if user has Outlook or Lotus Notes
  546. VBA versus Scripting
  547. Community versus Newsgroup
  548. Remove object from memory
  549. subroutine variable decleration issue
  550. #N/A in 150 WS
  551. reading data from thumnails
  552. Cell/function manipulation
  553. Pic Macro
  554. copying all of a row & Attributes
  555. Wrapping text in an Excel Interactive Web page
  556. Macro Code required..........?
  557. Counters
  558. protect Micro
  559. Macro in body of workbook. Can I create XLA?
  560. Copying Formulas Down Rows
  561. Getting 0 to not equal False
  562. .Precedents don't work in UDF
  563. Offset with variable?
  564. Offset with variable?
  565. delete rows with dates between
  566. Filter for 4 criteria only need data from one column
  567. Error when deleting rows
  568. Explicitly passing a .value
  569. Formula to Excel VB
  570. Transposing time series data
  571. Linked Workbooks
  572. Exporting to Excel
  573. Finding the right column
  574. Windows version language and Excel version language
  575. Help with storing data
  576. Dir command not consistent
  577. UDF Can't return more than 255 chars???
  578. Vlookup
  579. Please help
  580. Dictionary troubles. Declaring and checking .exists
  581. Need Help
  582. Validation List
  583. Transposing time series data
  584. How long do variables retain their values
  585. 1D Array Problem (Subscript Out Of Range)
  586. Fastest way to get keys from collection
  587. Hidden cells
  588. Considering Holidays
  589. Data Import ODBC at 30min intervals with Macro trigger
  590. Run-time error '1004': Unable to set the CategoryNames property of the Axis class
  591. Run-time error '1004': Unable to set the CategoryNames property of the Axis class
  592. Run-time error '1004': Unable to set the CategoryNames property of the Axis class
  593. Need help with Lookup
  594. Object Variable with Block Variable Not set
  595. Re: Initializing a dictionary and then modifying it.
  596. Add a second condition to loop
  597. Compile error in Excel
  598. Excel VBA's are there but not recognized as macros so they can't b
  599. Copy and paste row based on cell content
  600. opening multiple xls files in a folder
  601. Initializing a dictionary and then modifying it.
  602. Need to get modified date
  603. Need help with changing data after it has been imported.
  604. VLOOKUP
  605. Programming Cells To Change Colors
  606. Standard length of a line of VBA code?
  607. Shell for Outlook
  608. Problem with Auto_Open function
  609. Chip P.
  610. Problem with Auto_Open function
  611. SUMPRODUCT statement only works sometimes
  612. Record the date on which the record is made
  613. pictures in exell
  614. Run-time error 1004 Method "Range of object_global failed
  615. Multipage Part of Form
  616. Printing a Background
  617. How To Maximize A Window From The Task Bar
  618. Form
  619. SpinButton1.Max quick question
  620. Opening a word document
  621. No 'Click' for CommandBarPopups, so what should I do?
  622. How to make a cell containing a macro call to be recalculated?
  623. Macro for Drawing
  624. Elastic array
  625. Macro to insert copy and insert formulas only to next blank row
  626. Control array
  627. Counting worksheets with a particular name
  628. AnyOne !!!!
  629. How do I add a button to an excel document?
  630. Re: macro for converting number stored as "text" (or preceeded with ') to "number" formatting
  631. LadyHawke
  632. Execl VBA
  633. How to stop all Excel funtions for a period
  634. An old question about Office 97 to Office XP upgrades and Bloomberg
  635. problem with calendar dates format
  636. Irina
  637. This simple userform is driving me nuts
  638. Ending session
  639. Window Object - Subscript out of Range
  640. Detect # scrolled-out rows and column
  641. EDIT>GO TO...>SPECIAL...
  642. Syntax error..
  643. User defined chart
  644. I need some help with userforms
  645. Code to modify find/replace
  646. Need syntax help!
  647. Disable the alert
  648. Help please
  649. How to find Windows login name with code?
  650. The same IF (SE) formula give me two different number: why???
  651. how can i perform interpolation on a data set?
  652. Userform loses its capabilities...reset???
  653. Check to see if a file is already open
  654. Treeview Question
  655. How to programmatically test whether VBA code exists in an Excel file
  656. VALIDATE WB NAME
  657. Coding to make a transpose values button
  658. need codeto view the 56 colors of ColorIndex
  659. public function to sum input and return total sum + 10%
  660. autofilter syntax in VBscript
  661. IF formula with correct formatting in result
  662. Quick Question on This Code
  663. Event Procedure (re-activate automatic calulation if disabled)
  664. Toggle FIND criteria
  665. Newbie VBA Problem
  666. CommandBar 'Insert'
  667. Highlight duplicates
  668. a sensible, descriptive name for activex
  669. Saving Changes to Excel App
  670. macro as and moving files
  671. Hex to ASCII converter in Excel?
  672. Controlling Outlook 2003 with excel
  673. Triggering UDF
  674. DATE Formula
  675. Lotus 123 to Excel
  676. Importing Text Files of 100,000+ lines, many blanks
  677. How do I build an excel query? (something like SQL)
  678. Capture AutoFill...
  679. UserForm to Hide/Unhide Rows
  680. ComboBox Lists
  681. Crystal xcelsius
  682. Retreving data from Web page
  683. Loop & Cell Reference
  684. Using a formula in a SUBTOTAL Line
  685. In excel can I display a cell based on a calculation (eg M(14/2)?
  686. Error 424 Object Required when passing range as parameter
  687. Problem Naming Worksheet
  688. Is there a way to WAIT in Excel without using 100% CPU?
  689. Code to show a graph
  690. Validation of cell results
  691. String Array initialisation
  692. Filter Macro with Cell reference
  693. choose default macros Not Enabled / Macros Enable Setting
  694. VBA select default Don't Enable / Enable macros Setting
  695. VBA function got name error in excel 2003
  696. How to print fitted 1 page width and 1 page tall
  697. Adding Number
  698. Restricting copied text to one Column
  699. MKDir not working
  700. String array initialisation
  701. Assign my own sound from a list to a command button
  702. Referencing code outside of current sheet
  703. Dictionary and saving workbook/ reopening
  704. Hideen Worksheet
  705. Mouvement macro
  706. Locking a sheet & Menu Items
  707. saving changes
  708. Variable Decleration
  709. random dates showing up in userform
  710. File properties (size date)
  711. Missing Help Files
  712. Printing selected pages in a Word document
  713. Do loop error while using FindNext command
  714. Macro to send email through Lotus Notes
  715. Problem with ListItem Width
  716. General Mail Failure for "ActiveWorkbook.HasRoutingSlip = True"
  717. how do i add weekly averages in excel
  718. Adding a counter to ranges
  719. Trouble with dynamic named range
  720. Combo Box - auto complete and the bound column/text column propert
  721. Email From Excel/VBA
  722. veenob3.hlp
  723. Creating Variable for a Sheet
  724. Find Last Value
  725. email in XL XP
  726. Insert & Sequentially Number Column
  727. unable to record macro
  728. Type mixture error
  729. code help
  730. Sheet Name to Cell Value
  731. Print macro
  732. To block "to "eliminate" of the picture of form, information
  733. update all the pivots at the same time
  734. calculation semi auto?
  735. Save a single file webpage of each visible sheet in a workbook
  736. Reg : Excel
  737. set up multiple prices for drop down list
  738. Inputbox Default to be Upcomming Sunday
  739. dynamically assigning QueryTables.Add.TextFileColumnDataTypes
  740. Default Transparent color for bitmaps on cmd buttons
  741. How to loop thru cells in a row
  742. Userform loses its capabilities...reset???
  743. To block "to "eliminate" of the picture of form, information
  744. Call VBScript from VBA, pass variable, return result to macro?
  745. Incrementing a field
  746. Array data to Range: Only first value written
  747. Date Comparison
  748. Shapes into List Box
  749. will 2007 multithreading capability help the vba<-->worksheet tran
  750. Combining two sheets into one
  751. highlight with right click?
  752. How do I set up macro to truncate column/field?
  753. VBA: Date Comparison
  754. Chart placement
  755. VSTO Excel -- Urgent Help
  756. Create New Wk
  757. Custom properties not showing the value when set programmatically
  758. Opening Workbooks in a Folder
  759. Macro help required.Can any body help.........?
  760. Inserting a text character via a menu option into...
  761. Macro help
  762. Automatic File Download using CuteFTP
  763. Can anybody help on Vb Macros please..?
  764. Can anybody help on Vb Macros..?
  765. RTD wrapper functions do not work in Excel 2007
  766. Replace fuction replacing all instead of selected cells
  767. Is MAPI or CDO installed?
  768. Circular Reference?
  769. Count backwards
  770. .ext file
  771. Can anybody help on Vb Macros..?
  772. *.csv to *.xls
  773. Setting size
  774. Making charts
  775. Changing color of tabs
  776. how does a macro use an inputbox ?
  777. How to stop Excel from animating range selections?
  778. Macro to add a combobox?
  779. Charts
  780. Search Goto Feature
  781. Logon Dialog prior to Open Database connection
  782. Change combobox properties
  783. Theuns
  784. Theuns
  785. Small problem with GetopenFileName
  786. Placing charts
  787. Making charts
  788. Speeding up macros
  789. Error while populating a combobox from Access database
  790. Changing color of tabs
  791. New WorkBook Macro Looking to WRONG WorkBook
  792. MouseMove & Click event over an image control
  793. runtime error 75 when I run the application for second time
  794. XP question
  795. How to simulate "Data>Form" in VBA
  796. Can't find Project or Library
  797. To block "to "eliminate" of the picture of form, information
  798. Array? IF? LOOKUP? VBA?
  799. VBA and Displaying Chinese
  800. VBA Function won't work!
  801. different between CreatePivotTable and PivotTableWizard
  802. PivotTableWizard using SQL Analysis Services
  803. Problem with Macros!
  804. Add value when checkbox is ticked
  805. excel applicaton closes showing complietime error not allowing to edit
  806. Compare two workbooks and Copy missing data
  807. Screen Updating on Open Workbook
  808. Conditional Format
  809. Handling the 'Cancel' button..??
  810. Table with Excel
  811. If/Then
  812. Question related to Recursive Formula Execution
  813. Field Data Validation in VBA Forms - Here's a way
  814. Advanced Data Maintenance Dialog Question
  815. sql string, +'/'+convert(char(3)..)
  816. 2 IF THEN STATEMENTS TOGETHER IN ONE FORMULA
  817. Help with List Box
  818. Swapping two ranges
  819. Reminder Emails
  820. Opening Outlook and PDF from excell
  821. Summary Page
  822. How to send HP printer escape codes from Excel?
  823. OLE automation with PivotTable and external Data Source
  824. A way to simplify this please
  825. Help with Advanced Sorting Macro
  826. keep column's information consistent in different worksheets in same row
  827. NEED a PRO: Screen Epilepsy
  828. Using Excel as a data base
  829. Find next blank row
  830. Macro: Convert to PDF & E-mail. Possible?
  831. SelectionChange and Pivot Tables
  832. ~~ Help with Userform and Combo Box ~~
  833. Replace left header
  834. Merging Worksheets
  835. PrintToFile from spreadsheet
  836. How to skip "unrecognizable" msg when opening Workbook
  837. file name on worksheet
  838. VBA Coding: Date Consideration
  839. Set Column Width Based On Total Width Of Other Columns
  840. Working Days
  841. Looking for faster way to find minimum value
  842. selection.value <> "A list of values"
  843. Pivot Table Data Connection
  844. Save as cell with path
  845. Can't get Application Events to work with .xla
  846. Incrementing Cells with Macros
  847. Using a Sheet Name
  848. Select all cells in a column up to a blank cell
  849. Using row() in conjunction with a column number.
  850. VBA Loop Excel Record Extraction
  851. Unable to set the locked propert
  852. How to Get Excel Command Line Programmatically
  853. summing a range in a UDF
  854. Sort Multiple Sheets by Category
  855. copy duplicate rows to new sheet in WB
  856. How to split the active sheets into two different work windows?
  857. macro to delete on a condition
  858. How to capture autofill?
  859. Finding Last Cell that Has Data
  860. Summary Page
  861. Access transfer to Excel
  862. Removing quotation marks in a txt-file
  863. Open Outlook from userform
  864. Assure entry is numeric
  865. How to use PivotTable as a source of selection?
  866. Calculating a growing formula
  867. Save As Macro
  868. Control for selecting cells in worksheets
  869. Loop that Copys from one sheet and pastes to another
  870. Check validation on SelectionChange
  871. How does one create a delete property of a user defined class?
  872. Import Problem
  873. Need help using a toggle button
  874. Find/Replace Macro with format changes to the replacing number
  875. How to read DBCS from a cell in VBA
  876. Need an Excel VBA script written
  877. Identify duplicates and move to new sheet
  878. Find value in bottom cell in a column
  879. VBA Loop
  880. Data Validation Returning only distinct values from a list
  881. ChartObjects
  882. Saving Excel as latest version
  883. Placement of charts
  884. Automatically transfer cell contents
  885. Identifing Locked Cells
  886. Removing a collection item via key name check
  887. Paste Array to .xls : All at once
  888. Updating data from one workbook to another
  889. trying to find #REF! in a formula to replace with a sheet name
  890. Help with using ADO to connect Excel to Access
  891. Searching for exact text
  892. Using Active Cell Value in a Calculation
  893. Copy Paste Macro
  894. event after worksheet unprotect
  895. CopyFromRecordset Error If More Than 911 Characters
  896. Converting number to text
  897. From cell/combo to combo/cell
  898. SUM in VBA
  899. "Automatically" get name of selected autoshape into formula? Impossible?
  900. Cannot destroy Word Object in Excel
  901. Copying Data Between Two Spreadsheets
  902. inserting colon
  903. Recursive Loop -- How to Stop It?
  904. Calculating Rents and Months past in 1 cell???
  905. Get, Set and Let
  906. Counting rows in a range
  907. Name of month
  908. Passing references
  909. Pivot name changes automatically
  910. Making worksheets
  911. word files with embedded excel objects
  912. Macro to paste row number in cell
  913. Bring up an error message
  914. How do I add a search box
  915. Re: Pausing macros
  916. Add-in Description
  917. Printing a Userform
  918. Loop help
  919. How to save the option button value
  920. London Excel User Conference - Register now, it is not too late
  921. Need help with an if statement
  922. Cell adress for next non-blank cell in a range?
  923. slow macros
  924. Forcing user's to use the most current workbook!
  925. Re: Forcing user's to use the most current workbook!
  926. Summary Worksheet with VBA
  927. ComboBox ShowDropButtonWhen error
  928. Select columns of active cell's row
  929. A couple of questions (formating & Collating worksheets)
  930. Named range in a sheet referred to from another sheet
  931. autofill method of range class failed
  932. Addition of a macro to an existing Excel file
  933. get values from combobox in excel.
  934. read string from database and divide result into cells?
  935. Saving Protected Workbooks
  936. insert row on next sheet
  937. Secure Macros
  938. SelectionChange stops working
  939. AS400 copy problem
  940. Creating a macro to open as save other selected Excel sheets
  941. cocatenation
  942. check cell for #REF!
  943. Compare strings in cells and highlight difference
  944. CMD prompt output
  945. Selfcert.exe cannot create a certificate
  946. Keep text color
  947. an earlier post
  948. Validate WorkBook name
  949. Excel 2007 vba question
  950. how to make this in Excel...
  951. Application.Dialogs(xlDialogSaveAs) = res ???
  952. Hide Rows By reference to a cell
  953. How to save compiled version of VBA macro
  954. Hiding rows bt reference
  955. Programmatically defining dynamic range
  956. Data Validation list in Input Box... Possible ?
  957. >> Defining a range
  958. help with IF statement
  959. Dates
  960. Require some codes for variable in formula
  961. Create Calendar Wit Data Auto Fill using Excel 2000!
  962. Altering code to accomodate empty space
  963. Input Box value saves wrong WorkBook file & AUTO Sheet Numbering (1,2,3,4...)
  964. Graph Source Data
  965. Use a button to copy the values of one range to another
  966. help creating helper column
  967. Sub that has an input of an array of ranges... what's wrong?
  968. Paste Append?
  969. Flash a label
  970. Open Hidden sheets to specific point
  971. >> Listboxes on a worksheet
  972. A class with two objects?
  973. Conditional Formatting 4+ conditions, format rows based on cell
  974. Close All and Workbook_BeforeClose events
  975. Unhiding all worksheets
  976. Unshimmed Automation Addin and Shimmed COM Addin in same App Domai
  977. prevent a special cell from being deleted
  978. lookup
  979. Protect sheets via VB6 automation
  980. Application.Transpose in VBA EXCEL 2003
  981. Single Macro containing multiple subs
  982. Volume Calculator - Button
  983. Filter on cell value?
  984. Validate Workbook Name
  985. Little Macro help
  986. Can I use a cell reference to provide a value for a scenario?
  987. Conditional Formating on Worksheet Change
  988. Auto Load an Add-In
  989. Print Format
  990. Using Currently Open Lotus Notes Mail Server Info in Excel Macro
  991. Merging XLS Files
  992. Select sheets based on what is in a range.
  993. Re: I said "Keep this text! Not a date!"
  994. Re: I said "Keep this text! Not a date!"
  995. find duplicates between rows, keep or delete entries based on ranked relevance
  996. Userform initialize combobox using Chr() function.
  997. Searching Database
  998. Countif
  999. Cleanly Trimming text...
  1000. Calculate event using chart data