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. pause macro
  2. VBA problems
  3. Range
  4. moving thru a noncontiguous range
  5. UDF programming... PLEASE HELP!!!
  6. Toggle Autofilter
  7. manipulating SQL data through Excel
  8. VBA compy base on range
  9. Sending Conditional EMails from Excel Which Copies Information from One Worksheet
  10. Run-time error '424': Object Required
  11. "Excel cannot complete this task with available resources"
  12. VBA Class Modules
  13. Formula is evaluated as a constant instead of a formula
  14. Selecting Each Row and Creating a New File
  15. Automate PDF creation
  16. Various error 1004's associated with copying ranges. Excel Gurus please help!!
  17. Multiple Sheet Help
  18. VB to go across and then select columns
  19. change in combobox not firing
  20. Delete Blank Rows
  21. Consolidating data from many spreadsheets and comparing results over time
  22. Ending an automation session between Excel and Access
  23. Late Binding to a dll
  24. Context menu for chart is missing
  25. RE: Transferring data from Access to Excel in VBA very slow
  26. Reply to different address
  27. Tom Ogilvy - Need a little change
  28. Dispersing a value over multiple cells using a macro
  29. Use of Range Property
  30. VB code for selecting all rows below filled column
  31. Reduce Flashing
  32. Error finding match looking for intersection
  33. Add borders to certain cells using VBA
  34. Picture Size Variation
  35. Worksheet in Userform
  36. Digital2k Poster
  37. Link cell contents to a Macro?
  38. How do I set up a date to update individually on each worksheet?
  39. MS Query Problem
  40. Shared Add In Project, Cannt get it working in Word or Excel
  41. Combobox Error Handling
  42. Check if file exists / open it
  43. Change name on modul
  44. Get external data by dynamical url -> no update
  45. Refering to another module
  46. How to Change External Link to Internal Link
  47. Shockwave Flash ActiveX / CallFunction method fails
  48. Multiple Active Worksheets
  49. Hide Window Caption Bar
  50. Sorting points
  51. Cell reference
  52. Defining a function to use multiple places in code
  53. listbox
  54. EXCEL MACRO
  55. Sheet array based on cell value
  56. Importing and splitting large text file
  57. Adjust charts dynamically
  58. Selection Column
  59. VBA syntax
  60. Detect lines in specific sheet at load time
  61. Change variable permanently
  62. Visual Basic programming in Excel for conditional formatting
  63. UnauthorisedAccessException
  64. Cell format changes when a saved sheet is opened on another machine
  65. Need some help with excel
  66. slow macros when sharing workbook
  67. Stop select and copy of excel sheet in protect mode
  68. Search and Display
  69. How to SCHEDULE A EXCEL file usign Windows scheduler
  70. Send emails through VBA but skip outlook "Yes" button
  71. what is difference between "=" and "=+" in excel function
  72. Unable to release Excel COM object
  73. NEED HELP - Auto Email file from diff locations, I donno server na
  74. how to enter another language word below the English?
  75. make macro "invisible" to end-users?
  76. recognising if a number is in a list
  77. recognising if a number is in a list
  78. Which is faster... or better programming
  79. How do I run a macro when cell value changes? WorksheetChange?
  80. Color Pallete in Active X control Properties Excel 2007
  81. Enabling/Disabling SubMenuItems on the Menu Bar
  82. Changing cell values in a range to Hyperlink to sheet in workbook
  83. How to use a Range in a Loop
  84. Get Add-in Description with VBA
  85. Find Range>>Copy>>Insert into Sheet
  86. How to bypass Excel error message
  87. Problem with a selection in a matrix-function
  88. Remove emty values from a array
  89. missing red brackets for formatting
  90. Loop & Calculate
  91. Excel dosyaları arasında bilgi paylaşımı
  92. Include/Exclude Holiday - Repost to Programming Section
  93. change label on multipage
  94. inputting text to textbox in cell not userform
  95. Calendar range and date intersect
  96. Web Queries in VBA
  97. Erratic behaviour of [Sh+F10]
  98. apply a discount
  99. lookup problem
  100. For Next loop faster with counter after Next?
  101. Shrinking buttons
  102. How to put values instead of formulas into matrix?
  103. Footer Date and Time......to include seconds.....please advise
  104. Hiding the userFormDuring Print Preview Advice Please
  105. How to move pictures to the center of window?
  106. How can I monitor CPU time of algorithm I developed in Excel vba?
  107. Exit Event
  108. Click an Optionbutton
  109. Runtime (Latebound) control withevents
  110. Help replaceing input boxes the custom forms
  111. Enable False
  112. HELP WITH AN EXCEL PROBLEM
  113. Syntax error
  114. Pass Info Between Macros (Re-Visited)
  115. excel macro
  116. scroll lock?
  117. Preserving HTML Column Widths in Excel
  118. Working with multiple workbooks.
  119. Looping Macro Doesn't Work
  120. change colour of Excel title bar
  121. Object Required error
  122. Quite the challenging question
  123. Show Format Cells Dialog Box?
  124. Writing Batch File
  125. What is VBA programming code in 'Excel12' format?
  126. Create a new function...
  127. Status Bar does not display in Excel 7.0
  128. Validation is not working
  129. macro to download a csv file
  130. Go all the way along a row and then delete...
  131. UDF's Problems; Is my Fundamentals Skewed
  132. Sub unexpectedly jumps to another sub
  133. Can't watch userform code
  134. Query while Importing web page table
  135. Faster way to loop through two ranges
  136. Hide column if particular cell is NOT a certain value
  137. Help on xl* and mso* Help ?
  138. Formatting Textbox
  139. Import text file
  140. Why is this so ?
  141. Date Math if then
  142. Passing Info Between Macros
  143. Control size of input box
  144. GetOpenFilename type mismatch
  145. Web toolbar comes on by itself when opening a file
  146. Error while moving sheet
  147. i need to learn how to do pivoting in excel, how?
  148. Macros to copy formulas
  149. Mileage Chart
  150. Input box cancel
  151. ASP.NET - can i use it to build dynamic Excel forms?
  152. How do I "if statement"
  153. How do I get the content of the cell left of the active cell?
  154. Opinion on Size/Length of Macro/Function/Sub
  155. Find Text in VBA if it is IS Nothing then...
  156. How do I copy data from a closed file.
  157. automatic cell comment
  158. converting formula to text
  159. need help replacing string with "."
  160. Functions
  161. Restrict Recorded Macro to a Particular Worksheet
  162. date criteria with SUMIF or SUMPRODUCT
  163. Find and offset in named Range
  164. Custom Function
  165. AVERAGE formula. PLEASE HELP!!
  166. Macro Help: Word doc into Excel
  167. Problem w/ Code- Error 91 @ run-time
  168. Listbox Event for selection/scroll change
  169. alphabetically sorting an array
  170. Problems checking for an Addin
  171. string.matchPattern ???
  172. workgroup access connection from excel
  173. How to get the user name
  174. Copy Formulae across...
  175. Curious Find/FindNext Behaviour
  176. Macro to clear range contents when cell contents are changed by us
  177. Canceling the rest of a Sub
  178. ENTER keys to execute code to add menu
  179. Timing VBA code
  180. Can you help me please
  181. SolverOK / SolvOK function does not compile - SOLVER library is referenced
  182. Error opening another excel file using vba
  183. Listing/Selecting/Viewing Range Names
  184. search and delete unwanted text
  185. Copy and paste from several Workbooks
  186. Copy and Paste all workbooks of a file
  187. Macro to delete specific rows above selected cell
  188. Chart Sheet/Axes
  189. Error using 'Union'
  190. Beginner Array Question
  191. using excel on a website
  192. Clearing/Resetting UserForm Values
  193. Error handler resume
  194. Passing a value from 1 userform to another when you dont know who called it.
  195. Pivot Table Nightmare Urgent help required
  196. Check difference
  197. Format Problem
  198. Is there a faster loop than this
  199. Error in Excel VBA Code (Error 91)
  200. Refer to worksheet
  201. Get info on toolbar button by clicking on it
  202. Referring to a cell(Newbie)
  203. Problem with 2-dimensional array
  204. hyperlinks
  205. Newbie: VBA problem when copying cell range
  206. Loop through range issue
  207. Removing an Addin from the Tools Addin list.
  208. Name sheets from a list
  209. Office 2000 Automation Events.
  210. Global variable destroyed when form closed
  211. HRESULT: 0x800A03EC exception when trying to hide a sheet.
  212. Add cell value from cell above when cell is empty
  213. calling data from access
  214. Text Dates with 2 Digit Year
  215. data from cell
  216. =WEEKNUM
  217. Assign keyboard short cut to subroutine
  218. Newbie question: show value from drop down in another sheet
  219. Automation Error: The system cannot find file specified
  220. Display ALL Names of Drawing Objects
  221. Macro Skipping a column?
  222. put the company logo in "A1" of sheets 4 to 44
  223. buttons
  224. Make form controls private (ie. hidden from intellisence)
  225. working with ranges
  226. Database ?
  227. Changing cell color based on cell value
  228. Stop showing the Folder explorer bar?
  229. text box data entry
  230. Help with runtime error 424 Object required
  231. How to cancel the Edit status
  232. Refreshing web query that is password protected
  233. Setting focus on User Form Listbox
  234. programming
  235. programming
  236. Returning to the last sheet used
  237. Almost there. Help printing multiple sheets as one print job..
  238. Poblem with a macro
  239. Simple Question
  240. how to select ALL named shapes in range
  241. macro to delete rows on condition
  242. Need to convert Characters between Unicode and ANSI
  243. Changing file formats while saving
  244. del dupes in a split cell, outer loop
  245. CONDITIONAL FORMATING/COLOR CELL WHEN FILLED
  246. Conditional Formatting
  247. Integrating data into VB code
  248. RE: CONDITIONAL FORMATING/COLOR CELL WHEN FILLED
  249. Run-Time Error 91
  250. FILL ARRAY ONE ROW AT A TIME
  251. Excluding a string
  252. Insert rows in linked table that are added to secondary table
  253. Trying to figure out IF formula
  254. Extracting Data from Multiple worksheets to a single worksheet
  255. Save file with new name(Save As)
  256. Need help Refining a Macro & make more Robust.
  257. Conditional Formating Bug when using HasFormula UDF
  258. Conditional Formating Bug when using HasFormula UDF
  259. How can I add macros and/or key shorcuts to VB Editor?
  260. Does rounding work at all?
  261. Number of lines
  262. How to call adobe acrobat file conversion from within Excel VB mac
  263. VB Study Material...?
  264. Range selection
  265. i have a good tool to add to excel
  266. how to import a 2-d array into excel using vba?
  267. Macro to Save worksheet to new document
  268. Universal CommandButtons Accross Worksheets
  269. replacing dynamic currency amounts with a character
  270. Distinct Query
  271. VBA Code Help
  272. Paste values from TextBox to ListBox
  273. Problem with Setting Bar Chart Colors (> 56 bars)
  274. Macro to record date on sheet data is entered in a cell ?
  275. Copying a Worksheet from an Addin
  276. Show/Unload Userform
  277. How to bypass startup form of access db via visual basic app/XL
  278. Access DB sub instantiate from excel vba
  279. RE: Programmatically Adding Code to a Workbook
  280. Gather data from multiple excel files in mutiple folders
  281. Passing a Forms Control to Function
  282. Why doesn't this color set work?
  283. Re: How to avoid rounding when comparing numbers?
  284. help with vba code please
  285. Cell click
  286. Still trying to find the date
  287. VBA Calculation Button
  288. Need some help with more effective range manipulation
  289. Comments and Pictures
  290. RE: Programmatically Adding Code to a Workbook
  291. Basic Spin Button Code
  292. Need help writing do loop
  293. looping puzzle
  294. Copy contents of one file to multiple destinations
  295. Application-defined or Object-defined error
  296. update links not being removed in when open in excel 2000
  297. IF Function
  298. Class Module?
  299. Define a range end based upon current cell location?
  300. Security Question
  301. OLAP: Security Error when updating a Cube
  302. copy selected cell
  303. 'equals' for non-numeric data
  304. Results of Advanced Filter to Array
  305. format text in imput box
  306. Creating a list of Subfolders and sizes
  307. How do I insert a HTML file in a VB Form?
  308. Validating Cells
  309. add a date in a row from row above
  310. VB and Excel
  311. Populate form combo with unique values
  312. Grup and subtotal in VBA
  313. How can we tranfer data from iSeries in MS-Excel 2003 with SP2?
  314. Hiding Row and Column Index in a Worksheet
  315. Is This Possible?
  316. Ogilvy or someone else please advise me!!!, KeyDown event
  317. Excel to Play Flash Animation or GIF in User Form???
  318. Validate user input with specific date format
  319. Create a comma-delimited file to be opened in Excel
  320. Javascript Question
  321. Import Text File Directly to an Array
  322. How do I set up a "Unit" conversion system in EXCEL
  323. Recalling a previously active worksheet
  324. Page Break After 7 Inches
  325. RAM Question
  326. lock cell after value is automatically placed when workbook is ope
  327. verify a path exists
  328. Entering Data into a spreadsheet via a UserFrom Advise Please
  329. How to create seperator in Right click..?
  330. Call up build in excel command using macro
  331. Pausing and resuming a running macro
  332. To use AppSentinel to set-up XL Macro for a dll; still need VBA 6.0?
  333. Execute macro for weekday
  334. Dynamic Charts between Files
  335. Cell = variable+1
  336. display userrform label for x seconds
  337. Create an array of all open workbooks
  338. Need to revise this Sorting code a bit.
  339. Extract Data From Active Directory
  340. Hoping
  341. show form for very short time
  342. Shared Workbook with user code lookup to display sheets
  343. change cell color based on a tab color
  344. Re: If Then condition on Values
  345. Prompting for a Directory Name
  346. need help w/ macro prompting with info and pasting the info based on user input
  347. Formula if Column E in Sheet 1 equals Column M in sheet 2, = Colum
  348. Mess-up When Exporting to an Excel in Query Analyzer
  349. File Size Problem
  350. If Cell equals "XXX" Then......
  351. How do I change a number to a written number?
  352. SolverSolve return values
  353. Macro to Transpose 1 col into 3 cols
  354. Code Reference Issue
  355. Is it possible to prevent error message displays?
  356. Force a cell to display as Text
  357. Public Const to refer to a range name
  358. Using a macro to locate a user given value
  359. Condensing Code
  360. Select Distinct from Array
  361. Detecting scrolling in listboxes
  362. Trouble with Advanced Filter
  363. Function to Return File Name of Active Workbook
  364. Why does my formula bar display a lengthy string, but my cells display #####?
  365. Macro to toggle text orientation
  366. Manipulate Excel file via scheduled task?
  367. DDE link to outside application
  368. Formula using Days (DDD) in worksheet name
  369. RE: Formula using Days (DDD) in worksheet name
  370. Using a Macro from one workbook within another
  371. How Do You Pronounce "Jelen"?
  372. Macro to merge open workbooks
  373. Macro to merge open workbooks
  374. Check Box Moves
  375. refer to worksheet by index number in formula
  376. Errortrap for WorksheetFunction.CountA - "No cells were found"?
  377. excel data to word table
  378. Looping solver for recursive optimization
  379. find word
  380. userform initialization problem
  381. move within ss by active cell position, NOT by cell names
  382. finding cells excluded by autofilter
  383. I need a Macro for Sorting workshhets
  384. 'OR' in Formula & # of Parameters
  385. Add workbook variables
  386. Excel sheet to PDF Macro = security question
  387. Transferring Data from a UserForm to a worksheet
  388. Backup only one worksheet
  389. String Comparison using Like Problem
  390. Force Calculation
  391. Force Calculation
  392. is there a basic profit sharing formula available for a sml office
  393. programming to the vbe question
  394. Run-time Error 9: Subscript out of range
  395. Check date and act on it
  396. ParsingFullName
  397. Setting Data Validation Programmatically
  398. Bob Phillips Excel Site
  399. Creating a macro to formatt data
  400. Redundant
  401. Run time error '9'
  402. What am I doing wrong?
  403. Text from within a sheet into right header
  404. Programmatically detecting presence of named macro in workbook
  405. closing all files
  406. If Sheet Exist
  407. subtotals
  408. How to make a llistbox selection to open another listbox?
  409. excel wont let me create a formula between worksheets
  410. Preserving Comment Box Formatting
  411. Referencing Excel Cells
  412. Consolidating ROWS instead of columns HELP PLSE...:)
  413. Changing code to Consolidate ROWS instead of columns
  414. Possible to link servers with ADO or others?
  415. format time in messsage box
  416. Number Combination
  417. Loop through Columns
  418. Hand Cursor / Disabled Mouse When Sheet is Protected
  419. how do i covert number to words in excel?
  420. tab order related
  421. Need Help with Call Shell("cmd /K netstat") Function!!!
  422. Joining Text from two Cells into One
  423. Credit Card Calculator
  424. How can I use SUM in a user defined function procedure?
  425. Emailing Worksheet with VBA Code
  426. Formular Is Too Long
  427. Excel File open
  428. show multiple rows on a user form
  429. vba for paste special
  430. Store Multiple Cell Values (Cell History)
  431. File Saving macro ?!?!
  432. delete row syntax
  433. How to reset checkboxes from control tool box?
  434. plot graph from multiple worksheet as embedded chart object on every worksheet
  435. if then statement with 16 constraints and 1 equation
  436. need to delete all rows that are gray
  437. parsename
  438. fr default color index, need color #
  439. Data - Group - Hide Details
  440. I can't find a specific add-in!
  441. nested while not working any more...
  442. Routine works on first sheet but not second
  443. Insert Sheet Code
  444. Can I build a Find function into my spreadsheet without a button?
  445. Help with pivot chart calculated field
  446. Value extraction problem
  447. Modfiy row of VB to select range of columns
  448. HELP NEEDED...
  449. Optional Variant
  450. Limit characters in an Input Box
  451. Uploading an XML Doc in Excel
  452. User Form with CheckBoxes
  453. Store data JUST entered in Activecell after clicking command button on worksheet
  454. Retrieving name from command button on Worksheet
  455. Stepping Through Rows
  456. how does vba relate to vb.net?
  457. Print Button Macro
  458. Update sheet1 with Data sheet in same workbook
  459. lifelines on multiple people in EXCEL with Timeline output?
  460. How to hide workbook in background...
  461. loop does not work correctly
  462. altering URLs with code
  463. Code to pull data from webpage
  464. Group data and pick a particular row based on a condition
  465. List box error
  466. How do I get balance forward to work in check register?
  467. Excel is crashing
  468. Not enough system resources to display completely
  469. delete macro and auto save/quit
  470. COUNTIF formula with date range
  471. HOW TO: Check if a picture exists?
  472. Excel 97 not running macro that runs fine in 2000
  473. Using ActiveCell to specify a column
  474. Excel Worksheet Protection
  475. Formula to add cells from external file
  476. VBA code to move contents from one cell to another
  477. Macro + Dates formatting issue
  478. How do I ref OutlookCOM in my Excel2003 PC and run it on Excel2000
  479. range.offset generates a Run Time error 1004
  480. Extract file names from folder
  481. Text-align in buttons userform
  482. Last Cell on a Worksheet
  483. To include quote marks in selection.formula
  484. Select and merge cells with duplicate values
  485. Replied to post which disappeared?
  486. Another Auto Fill variable length column
  487. Delete the contents of columns if the month changes
  488. Losing Cell Protection When Saving Workbook
  489. Delete the contents of columns if the month changes
  490. ReDim=overwrite?
  491. How can you write a formula that searches for a particular word?
  492. Syntax for multidimensional array
  493. sumproduct
  494. writing excel macros
  495. Test if Function is Run from worksheet or from VBA
  496. HOW TO: PivotTable.SourceData
  497. Last Cell on a Worksheet
  498. Creating and using an array
  499. Chinese characters - UTF8 CSV files
  500. Pop up window prompt for name/address upon opening of file
  501. Slow RowHeight behavior
  502. macro for graphing - should be very easy...
  503. HOW TO: PivotTable.SourceData
  504. Looping through items in a submenu
  505. Looping through items in a submenu
  506. generare a pause in a macro?
  507. select specific rows
  508. Find worksheet
  509. Passing Variables within For loops to other modules
  510. Progress indicator while saving a file.
  511. Integrating xls with vba
  512. worksheet change and DDE
  513. Goods In Sheet Problem
  514. Creating "grouped" checkboxes
  515. Find a specific string in a cell
  516. Macro help
  517. Checking Active Sheet is in an approved list
  518. Simple String Question
  519. changing Pivot table name via macro
  520. Delete Excel File
  521. ReDim string in loop
  522. Select all duplicate values in a row
  523. Possible Combination
  524. find within a named range, then deselect the range
  525. Why does this mouse menu call a sub from another workbook?
  526. Identifying a blank cell with existing value
  527. Adding data to a worksheet from a UserForm
  528. Shared VBA code between workbooks
  529. Pivot Table Help
  530. Excel to load COMMAND and type a Run Command?
  531. alternative for =0 and =""
  532. Override
  533. Excel crashes with long file names
  534. Avoid counting rows/columns with formula but no values
  535. Sort table based on array
  536. Named Ranges
  537. Two digit week numbers in VB
  538. What a silly question !
  539. "Method 'Worksheets' of object '_Global' failed "
  540. NEED Help - How to capture the Event's progress in Progress Bar
  541. VBA - Chr(13)
  542. Excel to load COMMAND and type something...
  543. Run macro from command line
  544. Returning newline from a function to a cell
  545. ReDim Matrix
  546. email format plain text
  547. Text-to-columns. Destination:=matrix
  548. Destination:=matrix
  549. Consolidating several sheets into one.
  550. How do I check if a sheetname exists in a file?
  551. Placing text-to-column data in array
  552. Excel macro "loop"
  553. Check if workbook is already open...
  554. How can I copy grouped data
  555. find a date using several worksheets
  556. Inserting and deleting spaces with a macro
  557. Linked Databases
  558. Copy row data based on drop down list selection
  559. Activate Spin Buttons with Keys
  560. macro for inserting a row
  561. Adding Time
  562. vba filter question
  563. Office Automation - 2000
  564. Enable Macros - Trust my file on my PC
  565. Saving a workbook - vba
  566. calendar/journal
  567. help with addresses in rows
  568. Reference Outlook in Excel2003, but not working in Excel2000.
  569. Linking Embedded Sheets
  570. Opening Access without declaring a Global Object?
  571. formula question please
  572. Looking for solution on Printing multiple sheets
  573. Time weighted investment returns
  574. vba - working with autofiltered ranges
  575. vba - working with autofiltered ranges
  576. vba - working with autofiltered ranges
  577. vba - working with autofiltered ranges
  578. Find and replace in every folder.
  579. Installing Add-ins
  580. countif (2) conditions
  581. Office 2003 vs. Office 2000 performance
  582. How can I force the file to over write the existing file
  583. John Walkenbach's Custom Menus
  584. I want to use the List Box to go to certain areas of the workshee.
  585. Decimal Places for NOW() in VBA versus formula
  586. Delete Picture VBA If Then Problem
  587. SQL
  588. Trying to execute function after negative if conditional nested in For each loop
  589. String Contains a Value
  590. Accessing every option button on a frame
  591. how to merge cell please help
  592. Modification to code to consolidate two sheets...
  593. How do I bypass the message to save when closing a file by macro?
  594. Limit to field size with .CopyFromRecordset
  595. VLookUP ARRAY , how can I make it not relative in macro?
  596. is there worksheet Int function to round decimals up instead of do
  597. Match function and displaying results
  598. write WorkBook_close event dynamically
  599. # of Days in a Year
  600. Take Action Based Upon # of Rows in Another Worksheet
  601. UserForm Data to Worksheet
  602. Exact lookup formulas, VB Instead?
  603. Go To Next Worksheet in Loop
  604. Subtotal multiple columns
  605. formula help
  606. Comboboxes on userforms
  607. how to suppress "update links" message for workbook with no links?
  608. Deleteing a portion of a cell.
  609. Date to refresh in chart title
  610. Some ideas
  611. Macro form
  612. Reset workbook counter to "0"
  613. Copying Regions with Filters/Hidden Columns
  614. Confused - Range and Cells
  615. AutoFill Using a macro
  616. conditional statements
  617. how might I tell a user they did not enable macros for excel?
  618. Passing a list to an array
  619. Passing a list to an array
  620. MsgBox Interactive
  621. permutation of values in 2 dimensional array
  622. Reply to outlook email from excel script
  623. Interop - "Unable to set the Color property of the Interior class"
  624. MultiPage change CRASH!
  625. Keeping 0 at beginning
  626. Count different values in a column
  627. Need one miracle
  628. Combo Box / VLOOKUP
  629. Reviewing a list of defined named ranges
  630. Copy data in named ranges to a newer version of the same template to identical ranges
  631. VBA for Cell locked please help
  632. replacing defined names for ranges
  633. Help with VBA...
  634. Displaying all Named Ranges in workbook
  635. conditional formating
  636. Convert Binary to Hex
  637. activate last worksheet in a different workbook
  638. Separating text and dates.
  639. Userform with spreadsheet control will not load
  640. How do I test if the weekday is between Monday and Friday ?
  641. Macro for comparing Hotel Prices
  642. Search a string
  643. Modifying code to Consolidate only 1 column..
  644. Print ranges based on cell value
  645. How do i count date cells without duplicate values in excel?
  646. Conference pictures
  647. VB Code to Send Workbook to a FTP
  648. Creating a Macro for refreshing data in a columns
  649. Creating a Macro for refreshing data in a columns
  650. Conditional inserting content in new rows in other file/sheets
  651. Conditional Minimum value
  652. Sorting list
  653. search for duplicates
  654. vbOKCancel box to close
  655. Building an application on top of Excel
  656. Macro to sort values in list without 0's (zeros)
  657. "On Error" help required
  658. Timing/loading bar
  659. About Excel Version
  660. Value on worksheet with fullstop either side
  661. How do I get User Form to run at start up?
  662. Get all files from folder
  663. How do I print hidden pages?
  664. extracting data from excel
  665. Provide a check in VBA for backward compatibility of commands
  666. Reporting several Bugs for Excel 2007 Beta 2
  667. Commands for cursor moving right, left, up, down.
  668. Save as .pdf
  669. Intersect Method
  670. NumberFormat for date axis is not working
  671. Unvisible checkbox
  672. How to add data to separate worksheets?
  673. Need help with an excel formula
  674. where to place undo-function in vsto-projects?
  675. Copy worksheet name into cell A1?
  676. Array Formula cell via Excel VBA
  677. Line numbers in VBE
  678. Find a cell and then insert a formula into adjacent cell
  679. I am getting Unable to record
  680. Reset Checkboxes from Control Tool Box
  681. Command button auto select after pressing Enter
  682. Excel
  683. tabstrip name format
  684. Check User
  685. Chart Hide/Unhide Series
  686. Visual Basic - active macro on cell click
  687. How to find a particular cell using macro?
  688. Need someone's help with this issue...much apprecaited!!
  689. Button to print non-active page - How?
  690. AutoCorrecting in VBE ??
  691. Referencing Diff Sheet in Formula in VBA
  692. Label = whole number - How do I set this?
  693. RE: Formulas or VBA?
  694. Controlling scroll bars in file dialog
  695. Vlookup/address question
  696. Text box caption=Cell Value (without command click)
  697. Locating Matches & Highlighting Background
  698. Manpower Schedule
  699. insert rows in multi sheets
  700. Lock single Module ONLY in workbook; without locking VBA project?
  701. Help! I can't get a spreadsheet to open
  702. How to use send keys to unprotect VBA project
  703. Clearing row colour & row data
  704. macro Cell designation
  705. Identify non-alphanumeric characters within a cell in Excel
  706. Worksheet_SelectionChange Question
  707. need help on delimited
  708. Detect Cell Changes
  709. Need help from Excel and SAP expert!
  710. Formula Problem Summing Data in Cells on Previous Worksheets
  711. dynamic web queries with vba
  712. FullName vs FullNameURLEncoded
  713. Range.Text/Value returning the number 3?
  714. GetOpenFilename FileFilter
  715. Recording highest value dynamic cells
  716. VB.Net - retrieve actual formula string
  717. Creating and Naming a Folder and populating it with files
  718. Creating and Naming a Folder and populating it with files
  719. Copy Data
  720. Macro =sum function not working correctly
  721. Highlight text (interior color)
  722. Userform and Goal Seek
  723. Need workbook w/ VBA to open in new & separate application window
  724. Such a thing as CurrentCell..? ThisCell?
  725. Adding shape-type textbox into excel chart sheet
  726. Printing Multiple Sheets
  727. Printing Multiple Sheets
  728. Accessing Image Pixel Data
  729. Stock Quotes from web
  730. Remove Holidays as DateSerial using Case
  731. Excel and launching userforms
  732. Excel functions and programming
  733. do i need to macro this function? seems too simple
  734. How do I create a excel Template to enter data into same workbook
  735. How to Use Chip Pearson's Text Import Code
  736. Recovering the ribbon in Excel 2007 after an error
  737. how to use if command with time in function?
  738. need help for a golf spread sheet
  739. Need help with loop code
  740. how do you create a bell chart for sigma using excell?
  741. Referencing data from another workbook
  742. Initializing UserForm which uses MultiPage controls, part 2
  743. "Renaming Form Buttons From Macro"
  744. Convert Time Decimal to standard time.
  745. Conditional Formatting using cell from another worksheet
  746. My 1st IF-THEN-ELSE Procedure
  747. Using Built in Functions in VB Code
  748. Delete Rows With Specific Text
  749. More RGB Woes
  750. Command reference manual(s)
  751. run macro upon clicking a cell?
  752. Help with VLOOKUP / VBA code, please...
  753. Autodate worksheet problem
  754. what is the problem" TOO MANY DIFFERENT CELL FORMATS"?
  755. Lists in excel
  756. How to paste HTML code as text into a worksheet?
  757. AutoFill Macro
  758. ActiveCell.Row in Range().Select?
  759. couple userform questions
  760. Sum after sorting
  761. If event When a specific cell changes
  762. How to embed a macro in a flat file?
  763. Info from User Form to Data sheet and back
  764. Find text in a cell and select whole row question
  765. worksheet linkage
  766. sum function
  767. Need help setting the worksheet header/Footer margins based on string height?
  768. Need Help with printing multiple sheets Please
  769. fonts names in loops
  770. Upload Workbook to FTP ???
  771. Setting Funtion Value to Cell
  772. How to avoid volatile hyperlinks?
  773. How to arrange that macros are from THIS w/book?
  774. On Error Resume Next
  775. The most powerful computer security tool
  776. Worksheet place in workbook
  777. prop. scale images - have code, just need slight mod
  778. Listindex problems in multicolumn listbox
  779. Parsing a name
  780. Custom Quoting
  781. VLookup Error
  782. Error handling in VBA 6.3 in Excel 2002
  783. pivotable drill down
  784. command to do "nothing" in If/Then statement? #2
  785. Templates and passing functions
  786. command to do "nothing" in If/Then statement?
  787. Setting a value is slow
  788. Macro that AutoFilters based on Cell value
  789. Pasting from Excel to Powerpoint
  790. Clear color but not pattern?
  791. I need to Round Cells up to next .99$
  792. Delete row data and cell colour
  793. Combine date and time
  794. Add/Delete rows based on count
  795. Macro to insert object into spreadsheet ??
  796. Sumproduct Error
  797. Worksheet_Change problem
  798. Macro that adds records
  799. delete row of text with 3 macros & [placeholder]
  800. How can I duplicate conditional formatting
  801. Excel - User Defined Function Error: This function takes no argume
  802. Vlookup
  803. Problem placing embedded charts
  804. CORRECT SYNTAX FOR RUN...
  805. CORRECT SYNTAX FOR RUN...
  806. Embedded Excel Object - Containers Path and Name
  807. Recording date Excel file is attached to e-mail?
  808. count of rows
  809. add prefix to filename - macro to loop down column
  810. PivotCache
  811. select one value from drop-down and return multiple corresponding values
  812. select one value from drop-down and return multiple corresponding values
  813. select one value from drop-down and return multiple corresponding values
  814. Excel spreadsheeting
  815. Lost Basic Excel & Word
  816. Problem with discussion group
  817. Challenge of the day: linking VBA code to combo box selections
  818. Macro to test characters with block of cells and change font
  819. selecting data in combo box
  820. If column B not empty, value in column A = L
  821. selecting data in combo box
  822. Drawing Program Collaboration
  823. Finding window handle of data validation listbox
  824. DEFINED NAMES AND FORMULAS
  825. Linked Workbooks
  826. Make field Fixed lenght
  827. Sumproduct Problem???
  828. overlapping picture problem
  829. Incorrect usage of VBA WSfunction
  830. Open all files in subfolders
  831. VBScript MS Excel Problem
  832. inheritance
  833. NEED HELP - For run time error '1004'
  834. NEED HELP - For run time error '1004'
  835. Changing the value of a protected cell
  836. Excel Macro
  837. Download with Active X
  838. copying name box to another sheet
  839. Formula not evaluating immediately
  840. "Can't enter break mode at this time"
  841. Post File Size In Cell
  842. SaveCopyAs - Timed Capture
  843. Can this code be modified to delete rows?
  844. writing to a DB4 file
  845. Why can't locate the file?
  846. Application.EnableEvents help
  847. Auto Jump to Cell
  848. Workbook close event
  849. Help in VBA
  850. Command Button Created from Forms Menu Question
  851. Dim i,j,k As Integer
  852. HOW CAN i HAVE A CALENDER POP UP WHEN i CLICK A COMMAND BUTTON
  853. =NOW() Returning military time
  854. Deleting cell values
  855. Application.GetOpenFileName
  856. Returning reference of frozen cell
  857. Alt Enter vs. Chr(13)
  858. Do While True "Select" problem.
  859. Using XmlImport/Export Fucntions for excel
  860. Populating form dropdown at run time
  861. Clearing A Row
  862. Error handler that does not end macro
  863. RefreshAll not quick enough
  864. Read
  865. Re: VBA counting colors, errors
  866. Replace all values in a column with values using a mapping from another worksheet
  867. Compare Columns and Copy Data
  868. Re: Problems loading and AddIn
  869. Re: Applying changing cells colour with different two cases of statement
  870. Re: VBA counting colors, errors
  871. RE: Detecting "CallingCell" In Function
  872. Re: Unexpected result copying an array
  873. Re: Detecting "CallingCell" In Function
  874. Object error when using Excel in IE
  875. open file
  876. MsgBox date
  877. Hi Trevor :)
  878. trim and vlookup dun work
  879. How to make TAB key work in a protected worksheet
  880. Time Countdown
  881. How do I name a spreadsheet from the value in a single cell
  882. VBA code to filter data
  883. Formating and Precision...I think
  884. Manipulating Formula
  885. Data from ASP to Excel
  886. Excel VBA UserForms in in Mac OS X
  887. Autofilter for multiple sheets
  888. Go to current date upon opening Worksheet
  889. VB Function Round vs Excel function Round not behaving the same Od
  890. Looking up a value and returning another
  891. need some help clearing a range
  892. Code not working NOW ? But it was before???
  893. Still Looking for help on printing multiple sheets
  894. Set sem__ = Sheets("template").Copy(before:=Sheets(1))
  895. combox question
  896. trouble setting plotarea size
  897. Type of Drill-Down View
  898. Help with Code
  899. Transferring information from one user form to another
  900. Weird sorting results
  901. help with a macro
  902. Here's a quick and easy one..
  903. VB.NET - Showing a form from a thread
  904. unzip
  905. OFFSET() function with external references
  906. Question on Logical IF statement
  907. What language is Office Suite written in?
  908. Exclude Sheets from Macro
  909. Excel IV macro sheet
  910. ReDim an array AFTER it's loaded into another array
  911. PASSING MACROS WITH ARGUMENTS FROM OTHER FILES TO BE RUN
  912. VBA Programming in Excel
  913. Transfer Cell Value
  914. cell changed -> worksheet name changes
  915. Menus in Excel 2007
  916. RE: cell changed -> worksheet name changes
  917. Average of range help
  918. Adding to a Row Range
  919. Formatting Via a Macro
  920. Macro to locate/modify text
  921. Macro Question
  922. cmbobox shrink to fit
  923. VB Code is working for row1; how to apply to row2?
  924. Modify ADD ROWS Code - Excel 2003
  925. copy on the next available row
  926. Change a Function
  927. How to enable javascript in Excel?
  928. userform text box and a scroll bar
  929. auto refresh
  930. Auto Fit in Spreadsheet XML
  931. if-than statements in excel
  932. How do I delete some rows while keeping others
  933. Array Help
  934. Rounding
  935. Macro for locking cells after worksheet is protected
  936. Does Conditional Formatting create macros in my workbook?
  937. marco help
  938. bottom border every second cell in range
  939. border every other cell in range
  940. border every other cell in range
  941. Tracking Users
  942. border every other cell in range
  943. border every other cell in range
  944. Insert formula into a cell doesn't work :S
  945. serial time
  946. Problems with Excel via IE
  947. menu ids
  948. need to access the xldialogprint object parameters
  949. Discrete random numbers into an array?
  950. Windows.Activate
  951. how to reccognize what day is it ?
  952. Disable Mouse During Macro
  953. opening files
  954. Arrays - declaration, adding values to arrays and calculation
  955. Remove Every Other Friday
  956. autofilter based upon combo box
  957. copy to new workbook
  958. Can you get excel range object off the clipboard?
  959. Userform Text Box
  960. Exporting from access into excel
  961. Re: Sheet name ref in cell B2 and then!
  962. Command Button Invisible
  963. Speeding Up Excel Performance-VBA Loops
  964. Add a text to a line
  965. Exchange the content of a .NET DataSet with Excel VBA
  966. updating data location to build a VBA graph
  967. adding coloured cells together
  968. finding last cell of data
  969. Links - Why is this happening
  970. Golf Challenge Continua... Cert Printing inteferes with UDF
  971. Yet Another VSTO Publishing Problem
  972. Clear button adds to combo box lists
  973. Real Users Name Not Lan ID
  974. Setting LeftHeader / CenterHeader
  975. Dataimport to Excel
  976. Toolbar FaceID
  977. Passing a .NET DataSet object to Excel to be used with VBA
  978. date in arabic ?
  979. nRows range within SUMIF
  980. Add-ins Referencing
  981. Print in one page
  982. Selecting a data range using a variable
  983. VBA Loop until certain cell!
  984. Average to be copied into specific cells
  985. On event macro
  986. File error some number formats may have been lost
  987. excel "web query" timeout
  988. protect sheet
  989. Excel Add-In for Analysis Services - What-If
  990. Passing arguments from VBA to DLL
  991. Load Excel.xlb
  992. Deleting rows when a certain cell has a certain value
  993. lock moth for a date column
  994. sql vba applications
  995. Plotting more than 32000 points on a chart
  996. sql that will refer to a cell in excel
  997. RGB color palette
  998. Pivot Table type mismatch
  999. Open a sheet rename and move to another workbook
  1000. Runtime error 1004/ Save As method help