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. Instructions within VBA Functions
  2. Annoying Pop up box in function
  3. Calculating the difference between hours
  4. Resources
  5. Formatting problem Excel
  6. Is there a macro function to find out if a cell contains a functi.
  7. macro help
  8. File Already Open Error When Executing A Macro
  9. Emptying cells containing a single blank
  10. Deleting a row by a column value
  11. Resources
  12. Data access using ODBC datasources
  13. Re: Trusted Security Tab
  14. ActiveWorkbook.EnvelopeVisible = True
  15. File Already Open Error When Executing A Macro
  16. Trusted Security Tab
  17. Annoying Pop up box in function
  18. MyHelp - VBProject.Helpfile
  19. Allow certain users to edit certain rows?
  20. Annoying Pop up box in function
  21. Previous Worksheet
  22. Declare Variable
  23. Calculating the difference between hours
  24. Multiple users using a single userform
  25. Annoying Pop up box in function
  26. Instructions within VBA Functions
  27. SheetList - Help with skipping sheets
  28. Instructions within VBA Functions
  29. Formula as User Defined Function
  30. Environ Function
  31. Trigger a sub when cell changes?
  32. new sheet ops in macro
  33. Instructions within VBA Functions
  34. replace a string in the worksheet
  35. Declare Variable
  36. how to export a function from a vb6 activex dll
  37. Declare Variable
  38. Instructions within VBA Functions
  39. reloading a userform query
  40. Clearing user forms
  41. Get rid of some message about macros.
  42. Pivot Reports (by date)
  43. how can I format a .csv file from external data?
  44. Remove digital signature with VBA
  45. Is workbook / sheet protected
  46. How do I autopopulate data in excel?
  47. How to automatically populate using Macro
  48. Object Numbering
  49. Ranking issue
  50. VB runtime error codes
  51. Require extra funtionality - existing code included
  52. Critbinom
  53. End Double Sub
  54. Introduction in file Send to
  55. User Defined Function - Title
  56. Commenting in Code
  57. Help
  58. Public variable defintion (newbie)
  59. sorting code problems
  60. Automatically update column - Autofill
  61. Help with Calculation
  62. Automatic change for time constraint
  63. ToggleButtons are strange
  64. AutoFilter
  65. Declare Variable
  66. Cell value controlled by button
  67. Using AND to eliminate IF statements
  68. Testing If password is being cracked?
  69. Colour Cells depending on time
  70. linking spreadsheet nightmare
  71. Selecting Workbooks
  72. TXT file to Excel
  73. Print preview in a user form
  74. Sage Excel Link Error
  75. How creating a color listbox in a cell?
  76. calculating undefined ranges using vba
  77. Pasting into a row specified by a value in a cell
  78. Centering the text in a message box
  79. Define Object Variable
  80. dfgdfgfdg
  81. Post from Excel?
  82. test
  83. dfgdfgfdg
  84. Pasting into a row specified by a value in a cell
  85. ADO - accessing oracle
  86. Better help in VBA for "NumberFormat Property"
  87. Access worksheet by name
  88. username & password check
  89. Pivot table - 256 character limitation?
  90. Reference not responding
  91. Access worksheet by name
  92. Test for char in string & separating if present
  93. Multiple Userforms at once
  94. Data From Two tables using SQL
  95. Excel formula - overwritten files and data
  96. VBA IN AUTOFILTER
  97. Extract data
  98. Macro to open all linked workbooks
  99. Simple Case Of Protection
  100. Saving file to compressed folder
  101. intermittent problem with clearing textboxes on forms
  102. SUMPRODUCT for 3D values
  103. SHARING MACROS VIA ADD-IN (.xla) FILE
  104. Read/write a Serial Port
  105. Trouble with worksheet_calculate
  106. Public variable defintion (newbie)
  107. Sending Personal.xls Files To Multiple Users
  108. Autofilter
  109. Macro Design Help
  110. VBA and Goldmine (DBase)
  111. 8th Order Polynomial Trend - Is there an easy way?
  112. linking spreadsheet nightmare
  113. sort cells with spaces to the top
  114. Macro: With Stop it works. Without Stop it doesn't.
  115. Click event to run only once
  116. Multiple print areas, one worksheet -need to print to PDF!
  117. Range question
  118. Range question
  119. Access Mask equivalent?
  120. How could I get the client's browser to refresh an HTML spreadshee
  121. protection annoying - how to fix it
  122. Visual Basic File selection
  123. Need macro to autofit height for merged cells
  124. Form & combo box question
  125. web spreadsheet
  126. Change it from 7,6,5,4,3,2,1 to 1,2,3,4,5,6,7
  127. Validation problem
  128. filtering resp. today()
  129. CTRL+SHIFT+END
  130. Mail to multiple receipients
  131. RP or TO - Add all files EXCEPT active file?
  132. Allow certain users to edit certain rows?
  133. Protection
  134. Hidind rows conditionally
  135. Is there a function to convert a string representing an integer i.
  136. PasteSpecial
  137. Runtime error 380: Could not set the List property. invalid property value of listbox
  138. VB6 Excel 97 code no longer works if Win2K SP3/4 applied.
  139. Problem creating a macro
  140. Evaluating Empty Cells
  141. Excel visual basic
  142. What is best method of filling in fields on an MS Word Document?
  143. Control Button is still selected after macro runs
  144. SHARING MACROS VIA ADD-IN (.xla) FILE
  145. how do i use R[]C[] notation in Excel visual basic
  146. Declare Variable
  147. Menu attached to a form?
  148. Vba printout
  149. PrintArea
  150. Can Anyone Solve This One, Please, From Liz
  151. Get Module line # for error trapping
  152. Allow certain users to edit certain rows?
  153. Variable results to new workbook
  154. Declare Variable
  155. long time to create toolbar in excel 2003
  156. does workbook contain worksheet
  157. Evaluating Empty Cells
  158. vba search
  159. PrintArea
  160. How do I make a value required in a cell in Excel? ex: Name, Last.
  161. VBA Excel
  162. Using add-in through intranet
  163. New Sheet
  164. Preserving Row Height with Paste Special
  165. return all worksheet tab names and chart sheet tab names in report - an example
  166. Hide shapes (buttons) before printing
  167. Run-time error ‘91’:
  168. Maintaining Macro Toolbar Button Properties
  169. Lookup List
  170. Calculating the difference between hours
  171. Duplicating a Workbook
  172. Paste txt to word
  173. Allow certain users to edit certain rows?
  174. How to make a more interactive spreadsheet?
  175. Another avoid the loop trick request - on fast fill (Maybe an Alan trick)
  176. # of Spaces macro
  177. Calculating the difference between hours
  178. Feet and Inches
  179. Macro to change list box input range based on selection made in another cell
  180. Custom Number Format for Feet and Inches?
  181. error handler in macro?
  182. Determine elapsed time between two dates
  183. Notification from Excel VBA
  184. Sheet selection
  185. Macro selecting rows.
  186. Resources
  187. Protect the sheet
  188. worksheet_change event fires multiple times
  189. how to find last row/col index within a selected range
  190. Refer to Range Name in Page Header
  191. preventing / converting 'illegal' characters in file-save text string
  192. Signaling the presence of a password
  193. Resources
  194. Unfilled data worksheet
  195. How to show/hide sections of a userform?
  196. Reference Library - Missing Library in a lower version.
  197. Protect the sheet
  198. xlodbc returning no rows & no errors
  199. Creating Directories
  200. Duplicates
  201. Calculating the difference between hours
  202. Keeping a workbook hidden when opened via VBA???
  203. "IF" syntax
  204. CellColorIndex - not working.
  205. Change event
  206. emailing attaching active workbook to it to myself
  207. macro loop
  208. Saving work sheet
  209. unprotect VBAproject, change library refs?
  210. IF statements
  211. CellColorIndex - not working.
  212. CellColorIndex - not working
  213. date format in excel
  214. my message in Status bar
  215. User defined functions
  216. Default formatting settings
  217. Excel Visual Basic Project Explorer
  218. VBA Automatically Changes Cell Format?
  219. Keeping a workbook hidden when opened via VBA???
  220. Current Row number
  221. Text Box Calculation
  222. Textbox calculation
  223. Enter Symbol showing on worksheet from text box entry
  224. Cell outlines missing
  225. SQL Keyword
  226. How to record a sheet change showing row column sheet name and date?
  227. Sql Table Join?
  228. match and/or index
  229. PivotTable After Refresh Event???
  230. Can I run a macro/program when Excel saves worksheet?
  231. checking variances in cells
  232. Copy Code
  233. How to set series data in VBA
  234. Copy Data
  235. Enter Symbol showing on worksheet from text box entry
  236. How to record a sheet change showing row column sheet name and date?
  237. macro not ending
  238. How to record a sheet change showing row column sheet name and date?
  239. Need Urgent Help Please
  240. Check Drive Space
  241. Excel formula: select value in column if condition in 2nd col met
  242. "Stop" not working
  243. How to record a sheet change showing row column sheet name and date?
  244. Colour Cells depending on time
  245. Automatically update column - Autofill
  246. do .... loop
  247. Make a Cell Act like a Button
  248. Worksheet_Change method not working in Excel 97
  249. Open as template only
  250. Open as template only
  251. Loop through selected cells
  252. Creating Trainees with macros
  253. Sending Personal.xls Files To Multiple Users
  254. Inter-process handling
  255. Dialog Boxes for Excel Program
  256. Software of scripting to grab data from MS word file and fill in Excel fields?
  257. do .... loop
  258. activecell
  259. Checkbox List in VBA?
  260. Change all text in a column to uppercase
  261. Can anyone help me figure this out?
  262. Colour Cells depending on time
  263. Click event to run only once
  264. Check for DLL Reigistration
  265. do .... loop
  266. Testing for existence of a worksheet in the active workbook
  267. Filter and copy
  268. XLA auto_open
  269. Deleting XLA codes ...
  270. computer name find
  271. cell values
  272. Run Time Errors
  273. Removing records from entries that begin with *.
  274. remove assemblies on save?
  275. Renaming macros...
  276. Shading cells based on Other Sheet Value?
  277. Custom Windows menu
  278. Hide colums based on dropdown list
  279. Need Help with executing a function based on time.
  280. Forcing an input in a pop up box
  281. Im so close. Need variable range for the pivot table
  282. code for printing
  283. RE: Run-Time Error 1004
  284. Retrieving Dropdown/Option Button Values
  285. Histogram / Count Programming Problem
  286. Code To find and run an EXE file out side of the Excel
  287. using a input box
  288. Macro to replace * with /
  289. Filename with date and time
  290. Sending Personal.xls Files To Multiple Users
  291. display long number as text
  292. Copy referral $ sign to other cells
  293. Copy referral $ sign to other cells.
  294. Percentile Value
  295. Clear contents if x is not in the row
  296. Parsing a String to get Numbers
  297. changing image control's picture path
  298. Parsing a string to retrieve numerals
  299. Retrieving Dropdown/Option Button Values
  300. Pivot table Programming
  301. clipboard pop up
  302. Nedd Help with an input box
  303. Using a macro to save a file.
  304. Excel auto-start macro
  305. xla add in issue
  306. Microsoft Jet workspace
  307. Validation
  308. Create macro to download access 2000 table to excel 2000 spreadsheet
  309. worksheet_change event fires multiple times
  310. Disable/ Enable Macro
  311. Compare Cells on Sheet to ListBox Selection
  312. Wanted: Data Analysis Workbook
  313. A Question about Listboxes
  314. Add-In
  315. Date Formatting in Code
  316. Protect Cell Formatting
  317. Conditional Filtering with cell format
  318. Macro to copy cells one row up then move down 4 rows & repeat
  319. worksheet_change event fires multiple times
  320. Format a Filtered range's header?
  321. Message prompt in VBA
  322. Wanted: Data Analysis Workbook
  323. Moving 'Closed' Rows
  324. How do I set up a template to assign a unique number?
  325. CELL FORMAT
  326. Run-Time Error '91'
  327. Looping
  328. How Do you Change The Color Of The CommandButton That You Just Prshed
  329. VBA Macro Help
  330. Transforming Excel data to Xml
  331. Centering the text in a message box
  332. Help !!! Pivot Change with Parametric data
  333. (Follow-up to earlier sort question) Further help required
  334. Macro to delete blank rows
  335. Looping
  336. TextToColumns Destination:=another worksheet
  337. Re: Array(arglist)
  338. moving table to next page
  339. VBA Macro Help
  340. Storing a Macro name in a Variable
  341. Add a Spreadsheet to a VB Form
  342. Copying worksheets across workbooks
  343. Linking check boxes
  344. Copy a formula to a range of cells via VB6 using .Range(Cells(row,col), Cells(row,col)).Formula= statement
  345. NumberFormat question
  346. Creating PDFs from Excel VBA
  347. excel vba
  348. Sorting by date
  349. .Net and Excel 2000 Protect
  350. Application / Object Error 1004
  351. Automatically update column - Autofill
  352. How to simulate worksheet rename event
  353. MATCH values on a subtotalled worksheet
  354. excel vba
  355. Auto ReCalc
  356. Macro Design Help
  357. Get data for only last three months
  358. Closing file and excel
  359. MoveAfterReturn is tricking me.
  360. On close and before save events.
  361. automatically insert rows
  362. Usage of Find function in excel
  363. Sorting based on a cell
  364. inputbox function
  365. Moving to another cell
  366. Excel Cell Select
  367. Excel Cell Select
  368. Sorting based on a cell
  369. Excel Cell Select
  370. Sorter macro
  371. How to record a sheet change showing row column sheet name and date?
  372. Sorting by date
  373. Random Draw
  374. Any quicker ideas?
  375. Re: Sorting by date
  376. Excel Library
  377. Make code more economical
  378. Catching NewSheet-Event in another WorkBook
  379. inputbox function
  380. Sorting by date
  381. How to record a sheet change showing row column sheet name and date?
  382. Insert code by code
  383. Sorting a value based upon the values that appear in row A
  384. Sorting a column regardless of whether a value if + or -
  385. If statement and Macros
  386. Using a range with SUMIF
  387. Add scrollbar control
  388. Scrollbar Change event
  389. Scrollbar Change event
  390. How to make a list of all shortcut keys
  391. Inter-program communication using SendKeys
  392. update a txt file if dta is new
  393. Get data for only last three months
  394. more than just conditional formatting
  395. Concatenate
  396. Using a Macro to Sum a Variable-Length Range (a Column)
  397. First Aid For Macros
  398. Accessing a non-active sheet from a userform
  399. Hide rows when quantity is zero
  400. Continuing Difficulties W/ Sum For Variable-length Column
  401. Chart links for copied sheets
  402. First Aid For Macros
  403. Problem with Excel plug-in
  404. How Do I assign a numeric value to a text entry?
  405. How do I link a .xls invoice to an access database?
  406. Continuing Difficulties W/ Sum For Variable-length Column
  407. Ungroup Sheets
  408. Using a Macro to Sum a Variable-Length Range (a Column)
  409. can it be done without notice
  410. Must be better way...Using Listbox Selection to Query Data
  411. Help With Autofill
  412. Drop Down List in Inputbox
  413. Getting values from a variable sized range into an array
  414. auto save on exit while at the same time rename workbook...
  415. Hi,
  416. Filter/copy based on criteria
  417. Drop Down List in Inputbox
  418. Click event to run only once
  419. How do I publish a Excel chart using vba macro?
  420. Code to change interior colour only if current interior colour is
  421. Automatically Parsing Fixed-width Text Import
  422. Open only existing Excel Files in a given Range
  423. multiple versions of Office references
  424. Excel Filesize
  425. system error when inserting UserForms
  426. GetObject function
  427. Re: Excel Window Zoom Problems
  428. Date Comparison in Code
  429. How do I modify a SQL connection string in an xlt file from a VB6 app?
  430. Worksheet events
  431. Identifying Pivot Table's Field
  432. can it be done without notice?
  433. Looping thru a range - storing IF not blank?
  434. Manuals
  435. Saving to Text problems
  436. Events, Class, Time Editing
  437. Excel VBA printing to MS Word cause MS Word to crash, why?
  438. VBA - MS VB Compile Error
  439. list box
  440. File Reference
  441. Use variabel as reference
  442. creating database from excel spreadsheet
  443. Directory Browse/Search information
  444. VBA - MS VB Compile Error
  445. RP - Add contents of cell A1 in all workbooks within a folder
  446. Rounding Entries From Range to Array
  447. Copy Excel Spreadsheet formula to a range via VB6
  448. Autofit
  449. Date Comparison in Code
  450. VBA - MS VB Compile Error
  451. moving table to next page
  452. creating database from excel spreadsheet
  453. Moving to another cell
  454. help with Pivot table
  455. Moving to another cell
  456. Re: Concatenate Textbx(s) Content HELP
  457. VBA - MS VB Compile Error
  458. Open only existing Excel Files in a given Range
  459. Adding a command button
  460. Filling command button with image
  461. selecting a file automatically
  462. "save changes pop up"
  463. Code Livelinks - Please help!
  464. Macro execution from Excel IF function
  465. Comment for ComboBox & Command Button
  466. Linking Button to a cell
  467. Hide Tab in TabSheet on UserForm
  468. Grouping Cells
  469. identify currency and do sum
  470. Calculating the difference between hours
  471. run macro in VBA code
  472. Insert rows in depending on criteria in variable columns
  473. Newbie VBA questions
  474. Drawing on userforms
  475. Calculating the difference between hours
  476. Pivot linked to large Access DB...help!
  477. How to referance a GroupName
  478. Re: Concatenate Textbx(s) Content HELP
  479. Error following Microsoft Article
  480. Formatting Questions
  481. Delimiters recognized by ADO for Text Files
  482. Looking for network-username with Excel macro
  483. Calculating the difference between hours
  484. Linking Button to a cell
  485. Check variance code not working
  486. copy multiple unkowns
  487. Assigning the Help 4, *.HLP file for a project programmatically in a protected Project
  488. Get data for only last three months
  489. Conditional Formatting in a Loop
  490. Calculating the difference between hours
  491. Getting dw20.exe error while openning excel formatted xml file
  492. savecopyas question
  493. Get data for only last three months
  494. Date problem
  495. Calculating the difference between hours
  496. Macro Help
  497. Get data for only last three months
  498. Mouse scroll in user form list
  499. Disabling Macro-Virus check
  500. range value with variable not working?
  501. for each loops
  502. textbox in a macro
  503. VBA Sub procedures
  504. Remove missing reference programmatically
  505. Locked VBAproject due to macro fault????
  506. Limit working area of a sheet
  507. Sorter macro
  508. dropdown list in an excel web page
  509. macro names not consistent?
  510. Disabling Macro-Virus check
  511. Create an EXE file.
  512. Disabling Macro-Virus check
  513. splitting names & email add.
  514. Locked VBAproject due to macro fault????
  515. Locked VBAproject due to macro fault????
  516. Not a valid Add-in - Error Message
  517. Tausendertrennzeichen
  518. Get a value from a table in an HTML document
  519. Accessing Mutiple TextBoxes
  520. Removing all Toolbars in one line
  521. macro with checkbox(i)
  522. Converting cells to data file
  523. VBA Macro Assistance (I am desperate)
  524. Option Button->Format Control->Cell Link...
  525. Protected Shared Workbook
  526. Printing part of userform
  527. >> Updating Links
  528. Using a Macro to Sum a Variable-Length Range (a Column)
  529. Urgent Help needed - On Formating a page
  530. Defined name range
  531. Average For Variable-length Column (w N/A value inside)
  532. Unprotect worksheet error
  533. Average For Variable-length Column (w N/A value inside)
  534. Defined name range
  535. Continuing Difficulties W/ Sum For Variable-length Column
  536. Close Dialog Box with SendKeys
  537. Excel - how can i reference a table using vlookup?
  538. Close a MsgBox
  539. VLOOKUP into a closed xls using VBA
  540. Help with a macro
  541. Change Cell from Validated List Not Firing Worksheet Change Event
  542. Path
  543. Worksheet events
  544. Path
  545. EXCEL HEL URGENT
  546. comparing data in different workbooks
  547. converting fractions less than 1
  548. Find Extents of Data
  549. Many spreadsheets to one with many tabsheets
  550. highlighting cells if value is repeated
  551. Re: Learn French in the Alps.
  552. highlighting cells if value is repeated
  553. Application.OperatingSystem Unix
  554. Unprotecting a Sheet
  555. Continuing Difficulties W/ Sum For Variable-length Column
  556. VBA Macro Assistance (I am desperate)
  557. Naming of MsgBox Buttons
  558. Sending Personal.xls Files To Multiple Users
  559. Focus sheet
  560. Continuing Difficulties W/ Sum For Variable-length Column
  561. Automated sheet copying and naming
  562. How do I create a logfile
  563. How Do I program Excel to Source a Database
  564. Continuing Difficulties W/ Sum For Variable-length Column
  565. Using a Macro to Sum a Variable-Length Range (a Column)
  566. Modified VB Code for Converting Number to Text
  567. Hide all menubars even 'Worksheet Menu Bar'
  568. Wish to apply "Save Preview Picture" in 300 files.
  569. looking at a cell before reffering to a table
  570. Splash screen and various screen resolutions
  571. Application defined or Object defined error
  572. Calculating the difference between hours
  573. looking at a cell before reffering to a table
  574. Calculating the difference between hours
  575. Function Help
  576. Function Help
  577. Help with Code
  578. referring to columns/cells using numbers
  579. retrieve data
  580. variable scoping - constants going out of scope - circular references
  581. Updating records in another workbook
  582. Printing A Chart
  583. How to check if cell value is displayed as hashes?
  584. Strange looping behaviour and Error 400
  585. Vba and excel, userform help
  586. ActiveX Controls loose left position after printing/preview
  587. Find the largest number
  588. HOW I CAN CONVERT NUMERICAL INTO WORDS IN CELL
  589. Copying from one SHEET to onother with the condition...
  590. Modified VB Code for Converting Number to Text
  591. is there a hotel management excel app.?
  592. Re: Naming of MsgBox Buttons
  593. Provide increment and decrement buttons on toolbar line
  594. different workbooks
  595. Allow formula access to the row/column information in the Name Box
  596. Using a Macro to Sum a Variable-Length Range (a Column)
  597. Problem copying checkbox values
  598. Function/Procedure dependence & order of execution
  599. Solution for ComboBox Code
  600. Define Name Truncates Formula?
  601. Advanced Filter Range Selection in VB
  602. Advanced Filter Range Selection in VB
  603. Edit this macro
  604. input data from 3 workbooks into a fourth
  605. retrieve and update data from a dbf file
  606. Simple userform help
  607. date cell from lotus is not working
  608. Can excel remove the duplicate rows in a spread sheet?
  609. Chart Title as a Cell in a worksheet
  610. not getting the "assign macro" shortcut
  611. AppActivate & Internet Explorer file download
  612. fmMousePointerHourGlass not working
  613. validation
  614. Query Hungs up Excel
  615. Edit this macro
  616. format cells with ### as number, then convert to string showing date.
  617. Macro that stops at a mid point occasionally
  618. Help with a macro
  619. On Close Macro - stop warning message
  620. Using Ranges to input variables to UDF
  621. Daily Analysis Report, Charts do not update Automatically.
  622. DAO Recordset in Excel
  623. difference between comm control on win 98 versus windows xp
  624. Help with a Form function please
  625. (new to the group) importing data into excel and printing
  626. Learning VBA Which Book?
  627. How Do I Detect An Entry In A Range Of Cells
  628. Automation error -2147417848 on windows 98 while using excel in VB ( works fine in XP)
  629. Help with IF
  630. Automatically close a userform
  631. Macro or addin for changing Number to words
  632. Finding A Desciption In Another Book
  633. Automatically close a userform
  634. Unable Export Data to Excel on Win 2000 Server
  635. Office Object Libraries
  636. stop execution
  637. Automatically close a userform
  638. Using IF in a macro
  639. New Range containing Unique names only
  640. Autorun a code when any cell is changed in a range
  641. Sub, module??
  642. changing cell format from number to percentage
  643. Macro to open other applications
  644. How do I automatically import CSV data on startup
  645. Zero Decimal Places
  646. Serial port interface
  647. chart in userform
  648. select all arrows or lines on active worksheet - an example
  649. copy multiple unkowns
  650. How do I automatically import CSV data on startup
  651. Send a String to a Web-Browser Window Using Macros
  652. Pasting records into Excel with QueryTables
  653. Auto Close Grouped columns
  654. Making macro functions invisible?
  655. Ending Sub
  656. Date spilt into four cells
  657. VBA new function doesn't execute
  658. skipping pop up box for saving changes when closing a file
  659. Search and replace
  660. sockets in vba
  661. Subtracting Dates in TextBoxes
  662. A question about textboxes
  663. Remove part of string
  664. Add contents of A1 in all workbooks within a folder
  665. renaming worksheets with a macro
  666. run time error 13
  667. A question about textboxes
  668. Run time error 13
  669. Macro for comparing two spreadsheets
  670. Excel 2003 won't fire Excel 2000 Macro
  671. Macro to bypass password pop up alert
  672. Import Picture from disk...
  673. VBA and F2 programming question
  674. VBA new function doesn't execute
  675. How do I test for the first character
  676. RangeExclude function
  677. Accessing Mutiple TextBoxes
  678. How to add images to a Combobox.
  679. Four digit numbers need to be split up
  680. Coverting dates
  681. Help creating a shortcut key.
  682. Sheet Name Character String
  683. Run Auto Close when Excel Closes
  684. Pivot Table Error 1004
  685. Excel 2003 - 'CopyFromRecordset' Error
  686. Object error on an Option Button
  687. Newbie, msgbox
  688. Number to Time
  689. Auto Close Grouped columns
  690. Deleting Rows
  691. RT Error 1004, Select method of worksheet class failed
  692. Clean up code.
  693. program control
  694. Deleting Rows
  695. Four digit numbers need to be split up
  696. Anyone see the prob in this code?
  697. Accessing Mutiple TextBoxes
  698. Link Formulas
  699. Is a sheet a worksheet?
  700. MSForm 2 - Creating labels and text boxes at run time
  701. End of previous month
  702. IMMEDIATE window
  703. Anyone see the prob in this code?
  704. MSForm 1 - Initial placement of form
  705. Custom View - TEASER
  706. User Input to open multiple files
  707. PDF FILE CONVERSION
  708. How do I keep a running total of time?
  709. Inline Carriage Return?
  710. 0x800A03EC, asp and excel export
  711. Remove letters from a cell
  712. how is the syntax to replace a date, recorded within a macro with a cell value ?
  713. Sorting regardless of whether a value is positive or negative
  714. Summing
  715. Accessing Mutiple TextBoxes
  716. assign variable
  717. Search
  718. Open File Variables
  719. Excel macro
  720. PivotTable
  721. Running cade on new file from template
  722. format caption
  723. Values from bold cells to combobox?
  724. Error in Copying and pasting data
  725. PivotTable programming help
  726. scroll bars in userforms
  727. Excel doesn't allow comments to be copied
  728. about more controls of a form
  729. Printing several worksheets as _one_ print job
  730. Combobox & Display
  731. How to obtain sum of odd numbered column
  732. filter on pivot table grand total
  733. printer selection
  734. List all comments in a workbook, by sheet and cell
  735. Using an array to select data
  736. stop code execution with button
  737. ADO Recordset to Text File
  738. 2003 Excel VBA on XP runs very slow vs Win/Office 2000 - why?
  739. Conditional Formatting Forumla
  740. Need help killing a remote Excel
  741. How to find speicial cell using macro
  742. Guru Help Needed
  743. Comparing two workbooks
  744. Moce rows with N in Col A to a new sheet
  745. how to return the value of a cell based on two criterias in two columns
  746. Filter/copy based on criteria
  747. unique entries code
  748. macro to filter sheets
  749. how to return the value of a cell based on two criterias in two columns
  750. Close without "Do you want to save changes" prompt
  751. Excel VBA - open text file, replace text, save file?
  752. VBA new function doesn't execute
  753. Click event to run only once
  754. Worksheet_Change procedure question
  755. How do I test for the first character
  756. Input Box - UPPERCASE lowercase
  757. Need code to insert cell value
  758. how do I get the current cursor position in a spreedsheet
  759. What is exel formula for future value of savings using constant i.
  760. problem with vlookup
  761. need code to insert cell value
  762. Problems with ADODB
  763. how may I copy color of a other cell
  764. MakeTable of Contents with VBA
  765. How do I test for the first character
  766. Help with a macro.
  767. Which rows contain certain text?
  768. How do I automatically import CSV data on startup
  769. problem with beforeclose event
  770. Help with Form function macro
  771. Printing same page twice with a subtle change
  772. Switch to worksheet view
  773. Using a Custom Function - determining the row that called it
  774. unique values
  775. can I call a worksheet function from within vba?
  776. How do I test for the first character
  777. Printing same page twice with a subtle change
  778. Close Workbook After 10 Minutes
  779. Check variance code not working
  780. Linking Combo Boxes
  781. Delete all files within a folder (incl subfolders)
  782. Creating VB OCX that uses MS Excel, but not always
  783. Converting Text files to Excel sheets with specific formatting
  784. Printing Word Document using Excel Programming hangs Word
  785. Copy a file into multiple dub-folders
  786. Forcing Save As: dialog box
  787. Anyone know of a Solver tutorial?
  788. How do I test for the first character
  789. webb visitor list - any methods to convert search engines query strings?
  790. Excel Macro
  791. Trim spaces on both sides
  792. Minimal Excel UI
  793. Little help with merged cells
  794. Can this work???
  795. disable conditional formatting
  796. MsgBox formatting
  797. Macros to run on a timer
  798. Need help with printing macro
  799. Printing same page twice with a subtle change
  800. Extract Number without quotation marks
  801. Converting 9/30/04 16:30 to minutes only
  802. Adding to Dates
  803. Check variance code not working
  804. "Status" indicators
  805. Email
  806. how to place formula to cell
  807. password protect vba code
  808. How to disable autoopen() programmatically
  809. Marco Run on File Close
  810. Application.Dialogs(xlDialogFormulaFind).....HELP! !!!!!
  811. Exporting to Navision
  812. Column listed as "Number Stored as Text" - Exported from Access
  813. Report Headings
  814. Download
  815. Equlivelent to .NewIndex Property in VBA Excel ?
  816. Semicolon problem
  817. how is the syntax to replace a date, recorded within a macro with a cell value ?
  818. sequential number based another cell
  819. positioning a comment
  820. Progress Bar
  821. Alternative to send mail
  822. Error 1004 Application Defined or Object Defined Error
  823. How to unload a form in excel vba?
  824. VB.Net to Execll
  825. Re: Last Row
  826. Printing a Word document from an excel macro
  827. Printing a Word document from an excel macro
  828. Bolding
  829. VB Code to Delete Unused Rows
  830. Macro , Unprotect-Protect -- Atten: Tom Ogilvy
  831. Saving an Embedded Excel Sheet in OLE Control
  832. Web Query Changes Format to Scientific in Excel
  833. statement to Exit Do if empty row
  834. dynamic chart
  835. coding worksheets for undesired selections
  836. Deleting a row based on the value in column A
  837. Inserting column headers
  838. Semicolon problem
  839. Max of integer vals
  840. Print Userform???
  841. Print Userform?
  842. Data validation question
  843. Cell Reference
  844. cell protection
  845. OLAP Reports
  846. Protection
  847. Semicolon problem
  848. How do I override a deletion box?
  849. Error only without references
  850. vlookup with VBA
  851. VBA to select multiple columns
  852. Get cell's print sheet #
  853. using For each loop to populate a range
  854. First text box in form not working right
  855. Array selection stopped working???
  856. .Find method not working???
  857. If Condition
  858. solver constrains in macro
  859. Highlight row
  860. Problem with Looping and Output
  861. reading data from com port into 2 different cell locations.
  862. formatting the view of a worksheet
  863. Workbook
  864. Change Cell Colour
  865. Error 1004 when pasting - Hair pulling time
  866. VBA in Excel: How to keep relevant rows only?
  867. Copying from excel to txt + formatting.
  868. how clear up this problem
  869. Excel 2002 - 2 problems
  870. Open Helpfile from Excel VBA or hyperlink
  871. Need func to display a cell + formatting in another cell
  872. Validating data in a spreadsheet control
  873. Validating data in a spreadsheet control
  874. Issue in Cell Value Alignment
  875. To: Harald Staff with Rgds to Your Code
  876. Click event to run only once
  877. Can you help with the correct translation of this code?
  878. strange prob: file not getting closed after vlookup
  879. Excel compiler and Excel password
  880. Text to columns -- reset delimiters, etc
  881. UDF, Array function, vertical output
  882. Cell Manipulation
  883. variable in excel
  884. Performing codes on different worksheets
  885. Add 2 more criteria's
  886. Toggle datafield in Pivottable
  887. Average
  888. Cell Manipulation
  889. Testing for Cell Validation
  890. Just Curious
  891. Moving between a cell that is selected to include a range of cells in that row
  892. Activate/Select Problems
  893. recvery msg and excel shut down
  894. Change named range value
  895. Extract Cell Comments?
  896. Max of integer vals
  897. syntax help
  898. InputBox Function & Cancel
  899. Print some Sheets
  900. Pasting formula with defined name
  901. Anyone know of a Solver tutorial?
  902. E Mail from Excel using a command botton
  903. accessing custom document properties without loading file
  904. How can I have a macros automatically run when I open up the file.
  905. Filename Function
  906. Make a Change to Code
  907. Combo Boxes and Tick Boxes
  908. Using Add ins for files downloadable through web
  909. Why ask for a password?
  910. Default path
  911. Disable Control in Tools Menu
  912. vba checkbox
  913. xOut
  914. formulas after insert row
  915. Open current database method
  916. Trying to delete macro -- 'reference is not valid'
  917. Re: pesty "Compile Error!"
  918. Trying to delete macro -- 'reference is not valid'
  919. excel macro
  920. Trying to delete macro -- 'reference is not valid'
  921. Unable to read file
  922. copying entire column
  923. Reference to Office 11.0 Object Library
  924. Filling cells
  925. GETPIVOTDATA
  926. Delete Empty Rows @ End of Template
  927. How do I create minimize and restore buttons on a user form
  928. to: Tom Ogilvy (Find and transfere values)
  929. Creating list of sheet names
  930. subtotals in a protected worksheet
  931. Problem Recording Macros in Excel
  932. Disable Message Prompt in VBA
  933. Re: pesty "Compile Error!"
  934. how to get a macro to run when the file opens
  935. C++ and Excel : Need Simple Charting Example (I can populate sheet with Data)
  936. Creating list of sheet names
  937. Query Results to UserForm
  938. Drag and Drop with Charts
  939. Extract Number with zero
  940. Drag and Drop between ListBoxes and Excel cells
  941. Method to pause VBA?
  942. Re: pesty "Compile Error!"
  943. HELP! cell validate
  944. Query results to message box
  945. Paste Command
  946. Executing code based on changes made to a form ?
  947. Problem with formula in cell
  948. Need help with empty cell in Macro
  949. User initiated break/actions during macro execution
  950. Range("A1") Question
  951. camera tool causes drastic slow down of macros
  952. Transpose Range
  953. Reference to sheet name in addIn
  954. VBA and F2 programming question
  955. deleting worksheet code in generated workbooks
  956. Excel Macro/Assembly i created in C# wont load on End user compute
  957. Prevent user disabling events
  958. Extract char from multicells to build new in another
  959. blank cell
  960. empty cell?
  961. URGENT! check if cell has only ALPHA chars
  962. VBA and F2 programming question
  963. .NET component won't show up in toolbar or menu
  964. How to modify excel setting using VB.Net
  965. IFBlank Formula
  966. I need a simple excel formula
  967. Method to pause VBA?
  968. Using formula to extract info
  969. change colour on value, 4+ colors
  970. Pass Version of Excel to a variable
  971. Disable/Protect Cells based on If
  972. Use macro to check a range of cells within a row and copy wanted data to new sheet
  973. Use macro to check a range of cells within a row and copy wanted data to new sheet
  974. Code to change the color of "Rectangle21_Click"
  975. Excel automation in VB.net
  976. Autofilter Multiple Criteria
  977. Macros
  978. Is Workbook read-only because of file permission or because file is already opened?
  979. Defined Names revisited
  980. Starting a macro based on cell value
  981. Use macro to check a range of cells within a row and copy wanted data to new sheet
  982. Help Please with Error 91message
  983. as that was so easy...
  984. Pass Version of Excel to a variable
  985. Click-event question
  986. VBA Functions acrosss multiple version
  987. Detect which UDF params was chnaged
  988. How to check if cell contents overflow.
  989. Time-interval protection
  990. Search and Replace With Formatted Text
  991. How to use macro to run excel, word, powerpoint, outlook, IE, etc?
  992. auto pivot tables and charts ?
  993. Union Method with multiple worksheets
  994. Auto fill
  995. textbox formatting
  996. Autofilter Multiple Criteria
  997. Excel2003 and xlListSeparator...
  998. strange behavoir
  999. Changing colors
  1000. Convert no. to time