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. Two Quick Questions
  2. Conditional listing & double selecting
  3. color of comment lines in vba
  4. copy & save desired data to a new file
  5. Counting by colour dilemma!!
  6. How to format text in a Text box using VBA code
  7. Need some help and explaination. Thks.
  8. Two Quick Questions
  9. Please help with code
  10. A VERY SIMPLE UserForm
  11. Import partial record from text file string
  12. find and delete text, find a 10-digit number and put it in a textbox
  13. Locals Window - Extracting Contents
  14. Populate Combobox in VBA form from worksheet - Tricky
  15. Cleaning up some VB
  16. Auto execute a macro if a cell value=1 ?
  17. Pesky Autofilter Toggle
  18. Populating a spreadsheet with Stored Procedure
  19. A VERY SIMPLE UserForm
  20. Memory Leak in C++ Excel RTD (same as in VCRTDServer)
  21. A Print Button macro that is based on Checkbox macros
  22. Auto Fit
  23. Filter by cell color
  24. A VERY SIMPLE UserForm
  25. Help ASAP myRange
  26. copying and skipping consecutive row data
  27. Repost: Any way to do this with a range?
  28. Code works within VBE but not from Excel
  29. Find Correct Subdirectory
  30. Error Message When running code but not stepping through it.
  31. compare student data over time
  32. Executing a formula?
  33. Please help.. lost in code.
  34. How can I delete a row based on Columns H and I
  35. Please help.. lost in code.
  36. Using a combo box to populate rest of a table
  37. OWC Message
  38. Limit text input in Excel 2003
  39. How can I delete a row based on Columns H and I
  40. database to store data entered from a spreadsheet?
  41. Programmactic access to Visual Basic Project is not trusted
  42. Can a workbook funtion without a missing dll ?
  43. Changing the Path In a Usage Log
  44. testing post .. please ignore
  45. drop down lists embedded in cell
  46. Setting HorizontalAlignment with VBA
  47. Autofilter - storing parameters
  48. Conditionally format
  49. Macro Security Setting not applying
  50. workbook contains automatic links
  51. Help: Cells.Select
  52. Please help.. lost in code.
  53. VBA killing my named ranges
  54. Script to locate unique reference help please
  55. Call other application from excel
  56. Installing Solver.xla in all computers by default
  57. Link to original cell, it is possible?
  58. Convert time cell
  59. Format of a msgbox
  60. .ChartArea.Fill.UserPicture PictureFile:="how to reference an obj.
  61. Simple Java script within the hyperlink
  62. VBA Excel 2000 issue
  63. Displaying an image without using external files
  64. populate Access numeric field with nothing
  65. Propagate labels from Worksheet
  66. MISSING: Analyze Timescale Data
  67. A Macro for copy with selection.. (please help me)
  68. Displaying an image without using external files
  69. help with sorting
  70. Please help.. lost in code.
  71. Hyperlink Headache
  72. Function
  73. Dynamic range
  74. 2 strange ones..
  75. Copy Entire rows with a difference
  76. Copy Entire rows with a difference
  77. Formula
  78. Please help.. lost in code.
  79. Hidden Range
  80. auto run macro on workbook open
  81. Formula Yields Slow response
  82. Copy Entire rows with a difference
  83. Label Scroll Bar Properties: Make Visible?
  84. Need to use an offset for x-axis in chart/graph
  85. Data comparison showing detailed output
  86. Character and number in a cell - Can you help?
  87. auto run macro on workbook open
  88. use of worksheet function average in VBA
  89. How to draw lines to seperate data
  90. Auto execute a macro if a cell value=1 ?
  91. Need to use an offset for x-axis in chart/graph
  92. link to word
  93. 2 Questions about code with excel 97
  94. More efficient method to copy-paste values in place?
  95. detecting open excel apllications and api qn
  96. Passing a range in a macro call
  97. Is there a formula that can pattern match?
  98. dictionary
  99. find result - only for expert
  100. Vba excel - autofill
  101. run time error 424
  102. Displaying an image without using external files
  103. Help with .Add specification
  104. printing via vba
  105. copy part of row
  106. add three parts of text with one date into a string
  107. reference to range in function within code
  108. RTD server stealing focus
  109. Displaying an image without using external files
  110. Copy Cells formats to another workbook
  111. macro help for a beginner
  112. Match Flies
  113. Blinking Cell
  114. Picture Viewer - Copyright Clearance
  115. Extract keyword from a string
  116. add three parts of text with one date into a string
  117. Scope of the arrays in Loops
  118. txt2xls
  119. macro help for a beginner
  120. Object-defined error???
  121. Can this be done? Excel output page problem.
  122. reference to column (not known) and certain row number
  123. How to format text in a Text box using VBA code
  124. Automatic page break
  125. Page break
  126. add "line" in a message box
  127. VBA - Find every occurance of string in workbook, write to 1st she
  128. Insert named range problem
  129. vba:Userform
  130. tutorials
  131. Creating A Trade Date Column
  132. Selecting a group of sheet tabs
  133. Excel addin problem
  134. InputBox vs. UserForm for Numerical Data Input
  135. Auto execute a macro if a cell value=1 ?
  136. Help with link
  137. Re: I have 15 floppies, I want to know the file names, worksheet n
  138. Checking cell for Dependents
  139. Finding CurrentPage in PivotTable
  140. ComboBox processing error
  141. run macros against protected cells
  142. Go To Location
  143. InputBox vs. UserForm for Numerical Data Input
  144. Error Handling Problem
  145. ado connection to access vs. sql server?
  146. XML
  147. Reading more than one set of data from a single cell
  148. Pop-up box..I think.
  149. Excel worksheet tabs
  150. Programmatically delete macro using a protected project
  151. getting cell value with all format without paste
  152. MsgBox Screen Position
  153. column sums
  154. run time error 424
  155. Capture network login ID
  156. column sums
  157. column sums
  158. Detecting Symbols in Textbox
  159. Create list (exluding blanks) from different fields?
  160. run time error 424
  161. VLOOKUP
  162. InputBox vs. UserForm for Numerical Data Input
  163. Mail Sheet as message body
  164. Microsoft ProgressBar Control Version 6
  165. Rows in a Range
  166. Delete multipage
  167. Subtotal function with Criteria
  168. macro help for a beginner
  169. Control Arrays
  170. Checking cell for Dependents
  171. Create arrays in macro?
  172. macro help for a beginner
  173. translating worksheet formula into VBA
  174. Copy/Insert Rows Help needed
  175. Using Excel is a SIN ! ! ! !
  176. ListBox index question ...
  177. Copy Multiple Selections thru Code
  178. setting column value based on if statement
  179. Conditional formatting?
  180. Mystery objects
  181. Password Prompt for VBA Project Appears After Excel Quits
  182. Upload file to the internet
  183. Checking cell for Dependents
  184. COmbo box and lookup list
  185. Hyperlink browser position
  186. Hyperlink browser position
  187. Run a sub or function on program start?
  188. inserting pictures
  189. Run a sub or function on program start?
  190. How do I print only the cells I need?
  191. InputBox vs. UserForm for Numerical Data Input
  192. Creating a Macro
  193. VBA List Worksheet Functions
  194. Copy Range
  195. Pesky Autofilter Toggle
  196. Creating Multiple Reports, One by One, for a List of Names
  197. Textbox question
  198. Using Excel as my database
  199. class events stop firing with ADO 2.8
  200. append 2 cells, delete old
  201. Column reference
  202. Missing VBA modules
  203. Password Applied to All Worksheets Confrimation Prompt
  204. Inserting .bmp image using VLOOKUP
  205. Sheet Compare Macro...
  206. Help with using the SUBTOTAL formula in a macro.
  207. Converting to seconds
  208. Importing external data
  209. Last Cell
  210. Reading Rows of Variable Length
  211. Microsoft ProgressBar Control Version 6
  212. conditional format?
  213. How do I auto-number rows in excel?
  214. InputBox vs. UserForm for Numerical Data Input
  215. Range Filtering
  216. copy part of row
  217. add three parts of text with one date into a string
  218. Checking cell for Dependents
  219. Autofit Comments
  220. copy part of row
  221. Checking cell for Dependents
  222. What statements introduced in what XL version?
  223. Converting to seconds
  224. Linking labels to cells and turning off events in userform
  225. To put value from txtbox to cell?
  226. enter value line by line
  227. Deleting/highlighting duplicate rows
  228. ADO Connection to ORACLE 9.2 through EXCEL fails
  229. Having a formula reference a a range
  230. print and save a single sheet from a workbook using a commandbutt.
  231. routine to convert to date format
  232. Linking labels to cells and turning off events in userform
  233. VBA to match Cell Colour to another Cell
  234. Cannot calculate
  235. Transpose after finding criteria assistance needed.
  236. The dreaded Sendkeys command
  237. Error Accessing File
  238. Convert values in a variant array to integer values
  239. IF Statement and VBA
  240. Button Code to Alternate Sort Order ?
  241. Getting a Cell Value from another workbook
  242. How do I check modifications of file on server
  243. Copying the entire sheet if columns H & G are equal to row.
  244. Spreadsheet function that mimics "LIKE"
  245. how-to use Excel to upload records to a MySQL database?
  246. 2 Questions about code with excel 97
  247. Combo boxes 101
  248. append 2 cells, delete old
  249. How copy specific range from one sheet to another using a Macro (V
  250. commnd button - when i rt click, "assign macro" isnt an option...
  251. VBA for Evaluating Integrals
  252. Module runs twice
  253. Formatting cells
  254. Combining Non-numerica data from multiple sources
  255. updating links to a password protected file
  256. how do I program for a 'generic' worksheet to open
  257. VBA to match Cell Colour to another Cell
  258. How do I link drop down menus to one another in Excel?
  259. More on my Coding Impasse
  260. Long Time Delay To Update NewsGroup
  261. How to create an add-in (xla) to load up my macro so it can be available to all users
  262. Copy/Paste Row
  263. How to draw lines to seperate data
  264. Excel Range issue
  265. excel template?
  266. Downloading image and placing in cell.
  267. Password Applied to All Worksheets Confrimation Prompt
  268. Excel 2000 - Function call causes Locking up/Crashing
  269. Select workbook with variable name.
  270. vb value to cell possible?
  271. Change of workbook procedure
  272. Macro to initiate a spreadsheet to email
  273. Excel Range : Row limit
  274. Coding Impasse
  275. InputBox vs. UserForm for Numerical Data Input
  276. get new file name when refreshing query
  277. How to prevent my Macro from opening up another Excel App when I open any other excel file
  278. if x = true then do y, possible?
  279. Excel VBA Newbies - Is there a better syntax to code the if
  280. 6 cells into 1
  281. Learning Macros and ActiveX controls...have a simple question...
  282. VLookup problem
  283. Problem about Form....
  284. help with sorting
  285. Coding help
  286. InputBox vs. UserForm for Numerical Data Input
  287. Protect/Unprotect ALL and/or SPECIFIED Worksheets in Workbook
  288. COMBO BOXES
  289. Lotus Notes/Export to email
  290. How do I check for a range name within Excel using C#
  291. Test for file existence
  292. Regional Settings with VBA - Urgent
  293. CheckBox and ComboBox controls move on previewing or printing
  294. "Last Changed By" Cell
  295. moving contents of cells based on criteria
  296. Command Button Anomaly
  297. Need help i moving one worksheet to another
  298. Test for file existence
  299. MapPoint Colors
  300. Difference between Select and Activate
  301. MsgBox Function and Arguments
  302. Is there any VB command to find out the total no. of days in a month?
  303. giving cells a nice color
  304. Can macro build new macro in another workbook??? Pleeease HELP
  305. VBA to linking data between two workbooks
  306. VBA and Business Objects
  307. Getting row numbers of a filtered dataset
  308. Msg Box Help
  309. Select Excel Range from Access
  310. Why does my code run but have no effect?
  311. Calculating days until an event
  312. Import excel tabel whitin Word into Excel
  313. MsgBox Function and Arguments
  314. Spurious decimals
  315. sheet code problem
  316. Find/replace macro
  317. Users printer list/ Dialog for print NAME
  318. InputBox vs. UserForm for Numerical Data Input
  319. VBA to match Cell Colour to another Cell
  320. Skipping blank cells in a column...
  321. Personal.xls "Before Print"
  322. unprotect VBA error
  323. How do I get data from one cell based on the value in another?
  324. Preventing Customization
  325. visible sheets
  326. getting cell value with all format without paste
  327. Add line between previous and current cells . .
  328. Solver VBA control
  329. "trap" a compile time error
  330. reset menu captions
  331. Msg Box Help
  332. Automating a data checking routine
  333. Preventing Customization
  334. advanced filter using VBA
  335. CDATE issues
  336. .Copy Destination:= .PasteSpecial ???
  337. PLEASE HELP!sorting data using auto filter & paste the results onto seperate sheets?
  338. Users printer list/ Dialog for print NAME
  339. Essbase + Excel + VBA
  340. Open, print and close workbook
  341. InputBox vs. UserForm for Numerical Data Input
  342. Find, Findnext VBA Loop
  343. Excel and Access
  344. Printing a Word document from Excel spreadsheet
  345. Excel and Access
  346. Macro newbie
  347. MS Excel 2003 and OpenOffice Spreadsheet
  348. Paste link and more
  349. Accessing a Text Box in a Word Document from Excel
  350. running vbs script from vba?
  351. Syntax To Insert A Number Into One TrxtBox If A Different TextBox Has A Date That Is => 1/1/98
  352. One Frame, 10 Charts, 10 Macros?
  353. Vlookup question?
  354. Convert number into text
  355. Format Columns
  356. permutation generator help.
  357. Referring Objects
  358. Changing the Protection prompt
  359. User Input Of A Number
  360. Optimizing a macro for speed- find and replace
  361. run time error 1004
  362. Way to by pass PW to hide sheet
  363. PrintPreview Question
  364. Add worksheet named as a date
  365. Newbie Pls help
  366. What formula can look in multiple workbooks and create a master l.
  367. sorry i put wrongly for padded leading 0
  368. padded leading 0
  369. User Input Of A Number
  370. Change information automatically since excel to powerpoint
  371. macro to create a worksheet for every name on a list?
  372. Conditional Formatting Not working (xls 2003)
  373. Counting and Summing with VBA
  374. Excel 11.0 Object Library
  375. form problem
  376. Optimizing a macro for speed- find and replace
  377. Counting and Summing with VBA
  378. Javascript functions in Excel output page
  379. Linking Chart directly to VBA function returning 2d array
  380. if x = true then do y, possible?
  381. Hide row macro
  382. Apply passwords to open on multiple files
  383. VB Script to remove row
  384. VB Script to remove row
  385. Hiding Columns
  386. Solver VBA control
  387. Looping Question
  388. Help Using Click Event
  389. Data Validation
  390. ADODB Question
  391. Out of Memory?
  392. Checking a userform for blanks
  393. macro to append one cell to another
  394. display data from a website in excel that requires a username/password
  395. web toolbar auto opens
  396. VBA ODBC connect to DB2
  397. worksheet calculation-anybody please
  398. Finding multiple occurances of a date within one column: Should be easy?
  399. Read And Write On A Closed Wbook
  400. Finding multiple occurances of a date within one column: Should be easy?
  401. Workbook in a Server
  402. Trace Precedents of Conditional Formatting
  403. Help with autoupdate....
  404. macro button
  405. Finding multiple occurances of a date within one column: Should be easy?
  406. Input Box
  407. Help with VBA on IF Then Else
  408. VBA to match Cell Colour to another Cell
  409. EXTRA large checkbox and labels.
  410. Help with an error
  411. Loosing combo box ListFillRange
  412. If Then Else looping problem
  413. batch convert worksheets in one workbook into csv files?
  414. Find method, After parameter
  415. Help with my excel spreadsheet
  416. Workspace faux user-defined type not defined
  417. Help with Custom Function
  418. Help with autoupdate....
  419. macro error
  420. Disabling Min and Max buttons in Excel Worksheet
  421. Finding multiple occurances of a date within one column: Should be easy?
  422. Deleting rows with #N/A
  423. Macro problems
  424. paste data to cells from html select box
  425. Find and Replace formatting inside of a macro
  426. help with sorting
  427. Problems usinga a variable in a worksheet function?
  428. Help with Custom Function
  429. Can macro build new macro in another workbook??? Pleeease HELP
  430. VBA to match Cell Colour to another Cell
  431. Paste Formula
  432. Merging two books
  433. Date specific Macro
  434. Copy & Paste Drop Down Box with Macros
  435. Create new Excel file
  436. Worksheet function
  437. Open, print and close workbook
  438. Adding quotes to the ends of a string variable
  439. Extracting specific data from cells
  440. VBA to consolidate multiple worksheets to 1 worksheet in running sequence
  441. Problems usinga a variable in a worksheet function?
  442. Recovering from temporary loss of network drive - Excel VBA problem
  443. User-defined Error Values
  444. Workbook open event
  445. VBA to consolidate multiple worksheets to 1 worksheet in running sequence
  446. run excell macro on add-in menu
  447. Extracting specific data from cells
  448. Importing tab delimited files into Excel
  449. Problems usinga a variable in a worksheet function?
  450. unique vaules
  451. GUI Expert: Excel-based User Interface or OO User Interface?
  452. QUI Expert: Excel-based User Interface or OO User Interface?
  453. OnAction calls to subroutine
  454. Copying sheets without code
  455. permutation generator help.
  456. Defining a variable within a sub...
  457. run excell macro on add-in menu
  458. Defining a variable within a sub...
  459. VBA to delete rows in certain order
  460. Open, print and close workbook
  461. vba - need simple function to delete ranges
  462. sending mails using outlook
  463. Add line between previous and current cells . .
  464. Conditional Formatting
  465. ¶¥¼¶×ÔÖú½¨Õ¾ÍøÕýʽÍƳö
  466. Formula '=IF'
  467. Simple beginner question
  468. Writing dynamic code - problem with VBA project protection
  469. Using a saved query to retrieve data from different sources
  470. Combine files
  471. run-time error 6 - overflow
  472. nomber of lines
  473. Defining a variable within a sub...
  474. Conditional Formatting
  475. Array Problem??
  476. Open, print and close workbook
  477. Capture Dynamic Range address into Modeless Form
  478. Calling of functions
  479. VBA to delete rows in certain order
  480. Capture Dynamic Range address into Modeless Form
  481. Dim MyArray vs. Dim MyArray()
  482. copy workbook
  483. assigning array back to range
  484. Simple beginner question
  485. Counting by colour dilemma!!
  486. User Input Of A Number
  487. sum cells based on multiple criteria
  488. Setting the Help 4.0 file name and path in a locked project
  489. copy range from each worksheet to seperate workbook
  490. copy range from each worksheet to seperate workbook
  491. can i reduce an array to size of 0
  492. Merge a list into a cell
  493. Open workbook with x number of sheets
  494. VBA to delete rows in certain order
  495. Macro Help
  496. Addin reference
  497. concetenate a single cell with a list of text in a text box into .
  498. Checking if an Excel file is empty?
  499. copy range from each worksheet to seperate workbook
  500. HELP: Access table linked to Excel - calculated fields?
  501. Format() doesn't work from a Form
  502. When Wanting To Replace Previously Saved .xls File
  503. Conditional Hide rows with zero
  504. Automatic Macro Execution Upon Cell Values Changing
  505. Deleting #N/A
  506. providing a sheet-copy event or copy CustomProperties
  507. Hints for working with budget and register excell worksheets
  508. Macro for Printing Only Displayed Data
  509. autorun upon activating a sheet
  510. How do I insert a row below the active row?
  511. selection.find shortening the procedure by skipping the "activate" part
  512. Counting Unique Entries Wit a Twist
  513. hiding the Menu bar
  514. HTML Questions
  515. Opening Outlook calendar files in Excel
  516. HTML Questions
  517. nobody seem to have answer! pls help
  518. how to delete to the end of line
  519. Calling addin Function from another workbook?
  520. hiding the Menu bar
  521. Create new Excel file
  522. Object Orientation / atpvbaen.xla
  523. Weird SQL Question
  524. Calendar Control - Display Issue
  525. Newsgroup problems...
  526. Creating a Macro that will Delete if anything less than 20%
  527. want a break in line graph
  528. Object definations/help
  529. Time delay function
  530. Bypassing OK/Cancel Dialog Box
  531. VBA: Look-Up Cell Date From User Input Box and return ALL matches
  532. AutoFill difficulty
  533. autorun upon activating a sheet
  534. Excel VBA Newbies
  535. Bypassing OK/Cancel Dialog Box
  536. Help! Bug-esque code behaivor on Windows 2K Server & XL2K
  537. Help with increment problem please
  538. Need Help using Max in a Vlookup function
  539. Need to beable to create a folder
  540. Bypass Msgbox from external vendor's Add-In
  541. Two Macros at the same time?? is it possible
  542. printing time literally
  543. Selectively Copying Information to a subset
  544. URGENT MACRO REQUIREMENT!
  545. open file, then call macro... won't work
  546. Macro Help
  547. Beginner VBA question
  548. Force Macro to wait till Refreshall is done
  549. Duplicate Record....
  550. Automate Worksheet
  551. Preserving data formatting when using VLOOKUP
  552. Separating workbook name from extension
  553. Macros stored on Personal.xls
  554. Find ActiveCell.column
  555. macro that loops till end of worksheet
  556. Unable to set the NumberFormat Property of the Range Class - ERROR
  557. Assign Macros to a dropdown list
  558. Conditional Formatting with more than 3 conditions
  559. macro to loop till end of page
  560. Userform: Combobox, dates, match required- can't get date format to work
  561. Pass Variable Question
  562. Selectively Copying Information to a subset
  563. For loop for each file in a folder?
  564. Error trapping
  565. Excel VBA: Subtracting TIMES
  566. Timed Interval Data Entry
  567. Open file on a specified Worksheet
  568. Force Macro to wait till Refreshall is done
  569. Excel VBA: Subtracting TIMES
  570. question about toolbar corruption
  571. Password Protection
  572. VBA: For Each... Statement, Expert?
  573. Insert Picture into excel
  574. For loop for each file in a folder?
  575. Preserving data formatting when using VLOOKUP
  576. Inserting .bmp image using VLOOKUP
  577. Pasting into an Autofiltered Block
  578. Excel 2003 graphics are invisible after loading xla
  579. Row must equal one of the following, or be deleted
  580. VBA arrays
  581. exit from a loop?
  582. Range
  583. DDE Startup Hangs
  584. DDE startup Hangs
  585. DDE startup hangs
  586. Range Filtering
  587. maxif function in vba
  588. Dinamically reference Acrobat Distiller?
  589. ###Error 57121###
  590. Excel function troubles
  591. Elapsed time to run code
  592. Assigning the Help 4.0 file path in a protected project
  593. Copy Paste Merged Cell Format
  594. Can not digitally sign
  595. simple formula
  596. Range Filtering
  597. hidden rows when running a macro
  598. Userform setfocus problem
  599. Err.LineNumber
  600. programme variables in excell VBA
  601. how return to last used sheet?
  602. hidden rows when running a macro
  603. efficiency qn: search collection or use on error?
  604. searching column "A" then Moving Right
  605. Worksheet in form
  606. convert number to text in Excel
  607. Err.LineNumber
  608. rank
  609. Time calculations in VBA
  610. Simple beginner question
  611. Time calculations in VBA
  612. Conditional Formatting of Scatter Charts
  613. Breakpoint in Worksheet_Change sub
  614. Simple Worksheets update
  615. how to upload csv to excel?
  616. Simple Worksheets update
  617. Time calculations in VBA
  618. Multiple Target as Excel Range
  619. How to make VBA code to self-destroy itself?
  620. Duplicate Record....
  621. export favorites into worksheet
  622. Time calculations in VBA
  623. Copy and Paste from Excel into Outlook Email message
  624. macro to append one cell to another
  625. ToolBar
  626. Help AutoFilter
  627. import and export vba
  628. How to create pivot tables using c#
  629. Checking whether a worksheet exist or not
  630. User directed graphing?
  631. InputBox Screen Position
  632. Beginner VBA question
  633. Just Excel VBA
  634. Position chart
  635. Copy sheet and strip all vba codes
  636. cells...
  637. VBA: For Each.... wont work correctly / is placement wrong?
  638. TO MODIFY A EXCEL OBJECT FROM WORD USING VBA
  639. Cut and Paste using Macro gives paste special method error
  640. Removing already used values
  641. Counting by colour dilemma!!
  642. In Excel,VBA. I need help to name a range.
  643. change the value of togglebuttons
  644. Macro Help
  645. CFPlus - v1.01.090 - Error 5
  646. Using add-in in VBA with another module?
  647. Using add-in in VBA with another module?
  648. Hiding Userforms
  649. Row must equal one of the following, or be deleted
  650. Borders
  651. how do I create drop boxes
  652. Excel Won't Quit
  653. Using add-in in VBA with another module?
  654. Add ability to excel to create dynamic drop-down(CTRL+L) lists us.
  655. Extracting data type from variable
  656. limit to possible array size?
  657. Exporting VBA DataForm Info to Word document
  658. Array of Arrays in VBA
  659. Referencing Excel.Chart.8 OLE Object in Access Report
  660. checking if a range has a name.
  661. How to save a new excel sheet using C#
  662. Using a cell reference in a filepath
  663. Combining Cells
  664. Sort list
  665. How do I have VBA return the trendline types possible for given d.
  666. Comments and Sorting
  667. Scrolling with wheel in combobox list
  668. Data logic/brain cramp
  669. Control Arrays?
  670. Re: I have 15 floppies, I want to know the file names, worksheet n
  671. Restoring Links
  672. How do you use the text command in an if statement ie. if....,tex.
  673. Checking existence of array dimensions
  674. writing to files
  675. turning auto calculate on and off
  676. Grouping without totals
  677. Barcode Scanner and macro question
  678. Retrieving Value From Column A
  679. run time error '1004'
  680. Bulk Row Deletion - Fastest method
  681. GOTO a Part Number
  682. Annoying Dialog Box
  683. ASP Dynamic Excel Creation
  684. Inserting .bmp image using VLOOKUP
  685. Automate Excel and Navigate Worksheets
  686. Reading long strings (with jdbc) from Excel
  687. Set reference to other sheet?
  688. macro to scan list
  689. Excel 97, text box Input Mask, local date format
  690. dec2bin
  691. Tab Order
  692. XL2K: How to reference workbooks that aren't open?
  693. Problems usinga a variable in a worksheet function?
  694. how do I set and arrange the tab order for text box objects
  695. Error when moving sheet
  696. range referencing
  697. Restricting access to data
  698. Sorting A-Z then AA-AZ etc
  699. WeekNum Trouble
  700. dec2bin
  701. Populating dropdown list 2 with data depending upon what was selected in list 1
  702. range referencing
  703. range referencing
  704. emulating xl consts
  705. Option Buttons and List Boxes
  706. Combining a MS SQL / ORACLE Query
  707. Bulk row deletion
  708. Range selection
  709. Error when moving sheet
  710. Open file on FTP location
  711. How to draw lines to seperate data
  712. wingdings characters and codes
  713. Macro to copy data
  714. how do I get the tab name into a cell
  715. Macros fail if file saved in another location
  716. ANNUITY PAYMENTS
  717. Change the font size for Row numbers
  718. Automatic Button Delition From Worksheet
  719. combo box empty after using .AddItem
  720. Rows to be moved from one flag to another flag
  721. Write Data from Control on a Windows Form
  722. Checking cell for Dependents
  723. How to insert: " into a string
  724. Cell Comment Summary with Hyperlinks
  725. Public Variables
  726. question about forms
  727. Problem with Excel97/Chart/Formula
  728. Report
  729. array length in VBA
  730. question about forms
  731. Counting by colour dilemma!!
  732. getting selected text
  733. Newbie Question - Excel VBA
  734. Import excel tabel whitin Word into Excel
  735. Duplicate Record....
  736. Excel 2003
  737. Problem activating OLEObjects
  738. Reading the separator from the regional settings in Excel 2002
  739. Select Inverse
  740. Retrieving data from Excel and store it into string variable
  741. Multiple Sorts
  742. Help with Commands and Syntax please.
  743. addins and vba
  744. Creating Workbook with 2 worksheets
  745. Add Barcode
  746. Recovering from temporary loss of network drive - Excel VBA problem
  747. please help
  748. import access into excel
  749. Re: Conditional Compilation using Application.Version
  750. Checking whether a worksheet exist or not
  751. show all changes of shared workbooks
  752. xlCellTypeSameFormatConditions
  753. Access table to Excel
  754. EXCEL close event?
  755. Comments and Sorting
  756. Retrieving data from Excel and store it into string variable
  757. Requesting formula help for dates/years
  758. refreshing a treeview control.
  759. Re: Option Explicit and Date Format "dd mmm yyyy"?
  760. Click Checkbox Event
  761. Copy & paste simple problem
  762. Simple VBA problem
  763. Read cell value and display
  764. Need some help and explaination. Thks.
  765. Getting KeyPress Event to work
  766. Easiest Way to do this Importing method?
  767. about worksheet
  768. Need some help and explaination. Thks.
  769. using ADO for database in sheet
  770. pivot table more than 1 column?
  771. Re: Problems usinga a variable in a worksheet function?
  772. Problems with Multiple Instances of User From
  773. Retrieving data from Excel and store it into string variable
  774. Referencing a general Cell(i,j) in an Add-In
  775. How do I check cells using index in Add-In
  776. help with debug "drop down calendar"
  777. Re: Copying a sheet, but preserving the formulas
  778. Re: List with Input Box
  779. Subtract based on Ending Time
  780. Re: Recovering from temporary loss of network drive - Excel VBA problem
  781. Re: Printing objects
  782. Re: Status bar event ?
  783. Re: Conditional Compilation using Application.Version
  784. Re: Autocopy row from several worksheet to another workbook
  785. Query/formatting problem
  786. need macro to output quatation mark...
  787. Changing right click menu on worksheet?
  788. Problem with calling addin macros in ExcelXP
  789. Problem with calling Excel2000 addin in ExcelXP
  790. Run Macro When Any Cells In Sheet Change
  791. Re: How to draw lines to seperate data
  792. Barcode Scanner and macro question
  793. msoFileDialogFilePicker but for directories
  794. Hiding controls with rows
  795. Trendline values display
  796. vba: How do I write a "For Each Statement" nested in a "With Statement"?
  797. Place Comment into a cell
  798. RE: How To Delete First Record In A Text File
  799. "Sum" function as Macro
  800. delete rows
  801. vba: How do I write a "For Each Statement" nested in a "With Statement"?
  802. Re: Call phone number in Windows XP
  803. Re: Protect from copying cells or worksheet
  804. vba: How do I write a "For Each Statement" nested in a "With Statement"?
  805. Re: exit from a loop?
  806. Counting by colour dilemma!!
  807. Subscript Out Of Range Error?
  808. Synchronize pivot tables
  809. vba: How do I write a "For Each Statement" nested in a "With Statement"?
  810. vba: How do I write a "For Each Statement" nested in a "With Statement"?
  811. vba: How do I write a "For Each Statement" nested in a "With Statement"?
  812. Barcode Scanner and macro question
  813. Re: Refreshing Autofilter
  814. RE: ActiveWorkbook.Sheets.Count
  815. prevent cells to be mark
  816. Re: How to eliminate spurious data in a string?
  817. Do using range vs. row iteration?
  818. RE: Is this possible?
  819. use variable as connection in query table?
  820. Format Today function
  821. Re: prevent cells to be mark
  822. Re: Can Not Insert Object
  823. Re: create a sheet but hiding it
  824. change active sheet
  825. "Sum" function as Macro
  826. array: subscript out of range
  827. Re: Default File Location
  828. Is this possible?
  829. Deactivating auto macros
  830. Re: Counting by colour dilemma!!
  831. Excel COM function list.
  832. Freezing a bottom row
  833. can share vba script using different workbook?
  834. How do I 'save-as' with an add-in .xla?
  835. range and cell
  836. How do I 'save-as' with an add-in .xla?
  837. How do you read a text file into Microsoft Excel 97 visual basic
  838. change function variable prompts??
  839. Saving in VBA
  840. Pinda
  841. Creating a template in Excel using VBA
  842. import access into excel
  843. Cell formula Help
  844. Cell Formula Help
  845. Using a result in the same formula.
  846. What must I do to get gridlines printed for both filled and empty cells?
  847. Using A Macro To Name A 2-dimensional Range
  848. Get data from cells on different worksheets
  849. Crash on Mac with Office v. X: characters.insert
  850. Resize and resample pictures inserted
  851. Dynamic range offset problem!
  852. Edit mode
  853. inserting images in excel
  854. VBA Code to copy a worksheet to another Excel Workbook
  855. How to input file name in user form
  856. simple formula
  857. Summing durations
  858. Can you get a log of the "thread" of lines used, when your macro run?
  859. User Forms data entry - MM/DD/YYYY
  860. Find All.... Then Select All
  861. How to hide rows and/or columns using a formula in excel
  862. Dealing with pop-ups
  863. Insert Mult. Rows
  864. Large project ideas, maybe should use Access?
  865. Conditional Formatting
  866. How do I insert a macro to fax using XP fax without fax wizard?
  867. Lock & Protect Cells With Data
  868. Iterating Thru Cells
  869. command?
  870. too many macros
  871. Excel macro problem on 'value' method
  872. Project still in "project explorer" window after file closed down!
  873. convert pxl to text
  874. form creation
  875. Importing a csv file
  876. Getting the sum of rows.
  877. set error
  878. Assign ID based on condition(criteria)
  879. Turning hyperlink warning off
  880. How Do I Get SetFocus To Work???
  881. Copy a value to the next empty cell in a column
  882. Find method, After parameter
  883. Change the color of an Excel Macro button?
  884. Help with sums
  885. How can I sperate the module into two part and connecte the two part and work well?
  886. automated continuous adding
  887. Saving using VBA
  888. Cell address
  889. Ado / Adox ?
  890. Using A Macro To Name A 2-dimensional Range
  891. Crosstab in memory
  892. 424 Object required error
  893. Ado / Adox ?
  894. Excel MAcros
  895. SUMIF Question
  896. Excel logical operator for a cell if another cell has a certain co
  897. open and hide
  898. Excel formula, 2 colons query to sum values in colon 3
  899. Inline formatting
  900. Ado / Adox ?
  901. Recommended reading DLL's VBA
  902. AfterUpdate
  903. using multiple dlls
  904. How to debug a VB dll used in Excel
  905. UserForm Question
  906. File Size Too BIG
  907. VBA MRU List
  908. unlock and lock VBAProject
  909. Filter/Advanced Filter
  910. Re: Forcing worksheets to be closed first when user trying to close excel
  911. How can I protect objects differently?
  912. Going through each item in a sheet
  913. Going through each item in a sheet
  914. Going through each item in a sheet
  915. Re: Going through each item in a sheet
  916. disable right mouse click on "Worksheet Menu Bar"
  917. Going through each item in a sheet
  918. Going through each item in a sheet
  919. Going through each item in a sheet
  920. Going through each item in a sheet
  921. Going through each item in a sheet
  922. Sql Refresh
  923. Going through each item in a sheet
  924. How do i select the first cell in a sheet
  925. Jump to new line after the first record is displayed
  926. Jump to new line after the first record is displayed
  927. use of function <target>
  928. Re: Jump to new line after the first record is displayed
  929. Jump to new line after the first record is displayed
  930. Excel macro to add /'s to a cell value.
  931. Tutorial and Excel and Access
  932. Jump to new line after the first record is displayed
  933. Presentation of my macros -how to in powerpoint
  934. Accept on condition only !
  935. import huge text file line-by-line?
  936. Help With Conditional Format
  937. Jump to new line after the first record is displayed
  938. Re: Jump to new line after the first record is displayed
  939. Cut & Paste with hidden columns
  940. Repost! Excel multiple worksheet populate from recordset
  941. Creating Multiple Reports, One by One, for a List of Names
  942. Input mask for userform textbox
  943. VBA - Help with Code (see message)
  944. VBA MRU List
  945. Delete Date data macro
  946. exit while?
  947. Why cell colors change when copying/moving
  948. How do I set up macro in VBA to choose worksheets?
  949. Printing Variable Length (but Not Width) Range
  950. reformulation question
  951. put on a eliptical fit for x-y points without a, b, e or the othe.
  952. Range Offset Error
  953. Validate values for Whole Number only
  954. Ado / Adox ?
  955. Text Comparison
  956. VBA: Text Box Property (MASK?) (Easy Question)
  957. VBA MRU List
  958. Find Hard Coded Cells
  959. Calling Procedures in other Projects
  960. Variable Reference to a Form Control
  961. WIZARD ARE YOU READY - UPDATING EXCEL FROM ACCESS IN REAL TIME
  962. this workbook before print
  963. Bitmap data of Image controls & Picture objects...
  964. Excel/VBA Programming
  965. Find method, After parameter
  966. Deploying Office Web Components 9.0
  967. VBA - AfterUpdate TextBox
  968. Move Copy sheet with cell having more than 255 characters
  969. Ado / Adox ?
  970. VBA and Validation Lists
  971. Selection to Array then unique with different fields/columns like advancedfilter
  972. Selection to Array then unique with different fields/columns like advancedfilter
  973. Iterating thru cells & comparing
  974. macro help...
  975. PrintOut workSheet
  976. Auto macro
  977. "Document Recovery" grey commandbar
  978. Some menus don't work opening xls in IE 6.0
  979. VBA Userform Textbox re-writing cells in Excel
  980. using Criteria with two possible values
  981. Starting add-in using vba
  982. Sendmail
  983. conditional insert image in a cell
  984. Trouble with Macros Assignment- anyone willing to help?
  985. Inserting sheet name into a cell
  986. Opening csv in Word
  987. Excel Add-In for Analysis Services and embedded Excel OLE object i
  988. treeview and laptops
  989. Text Comparison
  990. Help - applying macro to all files in folder
  991. Is column hiden?
  992. using Criteria with two possible values
  993. range referencing
  994. Run a macro shortcut from another macro?
  995. How to disable the Application Dialogs>
  996. Trouble with Macros Assignment- anyone willing to help?
  997. using Criteria with two possible values
  998. Deconstructing an add-in
  999. convert csv to normal Excel file
  1000. using Criteria with two possible values