Excel Programming [Archive] - Page 174

More UserForm problems
"Microsoft Excel has encountered a problem..."
Exporting data from Excel 2002
Re: get value of a cell with a mouse click
Re: disable pop up when overwrithing saved files
Custom Functions used through the wizard
Re: disable pop up when overwrithing saved files
i need help with a formula
"Store" ufm.checkbox values for later use
Re: activex component can't create object with SAP 6.20
Default recordset type?
Better way to 'unhang' my workbook
Windows Common Dialogs in VBA?
Re: save txt file
Replacement for INKEY$
Re: Import and transpose tab seperated data from text file
Check my code to use template?
en-/disable macros pop-up
macros disappeared
Re: Excel macro
Printing Multiple Ranges from Multiple Worksheets
Send Mail
Automating Acrobat from Excel
subtotalling - # of columns vary
"window scroll" event
Time Format & Unload problem
Macro fails without VB help files
Re: unprotecting pswd protected sht
addin a module on fly
Re: Change Sheet By Macro
Re: unprotecting pswd protected sht
COM addin call missing
Re: Help with selecting a range...
Re: Help with selecting a range...
Re: Freeze Panes with Object Model
Re: Help with selecting a range...
syntax for a sub ( )
Randomize a list
List Box catalyst to cell reference
Re: Stuck myself - can't bring back very hidden
Loading text file
Re: Stuck myself - can't bring back very hidden
Re: How do DLLs Work?
Multi Select List Box
Opening CSV Files
If Worksheets("Test") Exists Then Delete It
Re: grey ghost toolbars in Excel
count cell styles
Magic Shrinking Listbox
DataCombo seems locked after changing TabStrip
DataCombo seems locked after changing TabStrip
Saving only active sheet
Re: Approach to a Menu of Multiple Print Ranges
Re: How to set focus back to sheet after showing a user form
About disabling Excel window size-change ...
How can I get the record from excel whit asp?
After save event
Re: Text Boxes on Userforms
Re: external range in VBA (user defined formula)
Selecting A Range
FYI - VBE Breakpoints Skipped due to Conditional Format
Scrolling text
Linking two userforms
HOW TO: embed binary data in Excel - an odyssey
Bitwise And
Control tip text
Macro to Select Pages & Show Print
Re: Clear destination, then copy betwen workbooks
Re: Save CSV as TXT
Re: Selecting A Range
Selecting A Range
Microsoft AccessLinks add-in
Application.save gives a workspace file?
Re: how to assign ranges on different sheets to an array
Re: Find button in excel worksheet
macro that loops to multiple columns
How can I start a XLL using VC++?
Re: external range in VBA (user defined formula)
Event triggered by Hiding/Unhiding columns?
Running a macro on a template
Stopping pivot table refresh
How to enable macro when Excel doesn't give you an option
CommandBarButton.OnAction prop fires when set? Arg!
Fill & Filter in VBA
Disable a command from with in a workbook
Conditional formatting
Userform Textbox writing to a cell
file search with excel vba
Is it possible to assign a macro to a pivot table?
Option Explicit and Arrays
Re: Color Coding Cells
hide #VALUE! and ######
Stuck myself - can't bring back "VeryHidden"
Commenting custom formula fields/formula on formula editor
Time of Day Update
Re: right right$ left left$ mid mid$
Two AddIn Questions
Getting Application.Sum to act like =SUM
Excel crashes when created files open ...
importing prn file
selecting a range
Re: right right$ left left$ mid mid$
Finding a cell
Re: right right$ left left$ mid mid$
code for lookup,& triggers.
Error Handler not handling error...
excel chart embedded in asp page
Force Read-Only?
User Defined Type Structure - want it to be variable not numeric literal
Force File Read-Only?
looping from one column to the next
Using the Vlookup formula
time of day automation
copy/paste macro
deleting rows, takes a long time!
Re: How to set focus back to sheet after showing a user form
mail message 1.0 Type library
Exclude directory from .FileSearch
add-ins error + setting workbooks
Script?
XP vs 2000 macro error
Frequncy of unique values in array
Any way to grab a .csv file from a folder using Wildcards
Cell Formula
Macro to change security level
Copy Word table to Excel
Compile Error! Can't find project or Library --- Help!
Macros disabled on all but one of 3 windows in excel
ListBox Populate
Trouble with Focus
Break Modes
use shell function in vbscript
Re: PAYMENT CALCULATIONS
Re: Save CSV as TXT
long IF statement with lots of OR's
api call routines
Excel97 cannot access file
Copy and Paste ranges between files
VBA Excel 2000 - one shot multiple cells modification
Replace Excel-Icon on Worksheet Menu Bar
sum with two conditions and a wildcard
Counting selected entries
Re: Set Value for Date/Time Picker
Menubar locked in Internet Explorer
exception at 0x6503999b (VBE6.DLL) - Please
converting workbooks to worksheets
Changing SQL Statement for PivotCache linked to multiple tables
Re: Automatic print area
Random file name
Re: Simple Question
Event Question
Re: Replace Function
Replace Function
chart titles
Default Date: Today
Auto_Open disabling
List all Functions
create column & Row in userfrom
Whole vs decimal
Resuming code after closing a print preview
Building a form on the fly
Re: 3 problems giving me grief. Any help appreciated.
protect sheet blocks filter
Web Data
User Defined Functions
Free animating ActiveX control
error with data validation
DATA VALIDATION
Re: adhere to cell menu left-margin
DATA ENTERING IN DATA VALIDATION
Start Excel from Java
DATA VALIDATION
XLL support discontinued?
Re: Find button in excel worksheet
Click event on Scrollbar
formatting
Need help creating a userform with optionbuttons
Controlling the mouse
subtotalling where # of columns vary
Form control not working
File save location with Application.GetSaveAsFilename
auto add column
how to assign ranges on different sheets to an array
Data validation using calculated list
Excel not warning if another user has the workbook open
Re: looping through worksheets
locating and separating out duplicates
Macro records in R1C1 style
VBA Runtime Error
C# (sharp) and Excel
programmatically close help file before Excel closes?
utility to add standard comment
INDIRECT reference
add VB6 Clipboard object
Randomize a list of names
relative vs complet reference
Copy VB code to other workbook?
icons
SumProduct or Array Function for summing by month and year
Randomly fill in rows
looping through worksheets
Templates
Re: Problem - Deleting a Picture from a Cell
Checking Listbox Items
Re: Duplicate values
Re: Duplicate values
scraping text from the active window
Validation code not functioning correctly
Enable Macros
Evaluate OptionGroup in XL Dialog
Re: CONCATENATE
re ControlButton numbers , Id:=???
Re: Hiding rows quesion
CONCATENATE
Exception 0x800ac472 when accessing Excel
Apply macro to closed workbooks
...................................WOMAN IN DESPERATE HELP!!
help
Running a batch file from Excel VBA
Comparing Groups
Comparing Two Columns - Multiple Words in Same Same Word
Re: cannot get total
Using Arrays in InputBox Method
Extracting values from multiple EXCEL spreadsheets into one
Re: cannot get total
Hyperlink question
text box on a form
Change location of where file is stored
Help files will not display
Insert colum with 0's
Undo & ErrorHandler
Re: Unwanted Protected Code
Macro Help, Please
Re: icons for custom menu choices
Line numbers
coloring limits
Re: VLOOKUP
Re: VLOOKUP
data validation
CommandBarControl class
backup file
hide row automatically
Help with some code please
Variable Filename/Worksheet/Workbook
Use list box to navigate to different sheets...
Newbie : Advanced Filter Criteria
inserted code into project but can't run it in run dialogbox
counting non-empty rows in a column
Contect Menu Help
execute code for all 12 months
send page by email
Starting a macro by changing a cell in a column.
Re: finding a range of cells to match a date
Help Creating XLL
Assigning Selected Cells to Code
copy to protected sheet
Re: copy to protected sheet
How can I get "File Close" to prompt me to "Save Changes" ??
Excel 2002 to automatically e-mail me a reminder
Please help
copy to hidden sheet
Re: Hangs on Outlook after sending excel ss
Re: finding a range of cells to match a date
Data Entry on a Form
Re: Delete the row where the activecell is located with VBA
Delete row where active cell is located using VBA
Pivot Table Problem
Re: Dynamic Values in Procedure
Age function how to
Re: Programming a current procedure
SUMIF
Unable to launch html helpfile
Why am I getting NA
code break
Re: UserForm not passing Boolean variable
Re: Date Created reported as wrong
Re: Userform button options
SUM using Three ranges. Two Comparisons and the SUM Range
CLEAN function does not work
passing variables from excel to word
Creating a new word doc and putting some VBA code behind it
Re: Enable Macros Warning
The Macro Window
RunTime code problem
I can't solve this one...can anyone help
Pivot Table - Change SQL Statement Problem
Re: marco variables or substitution
Proper way to pass errors up the line
Deleting a Prompt Message
using end and down keys when recording a macro
Copying ranges
Re: Unlocking Cells
Re: marco variables or substitution
Unlocking Cells
Re: Naming Worksheets in VBE
Re: Naming Worksheets in VBE
Copying files ...Network to Network
DateLastModifed and Open File
Re: Does destroying the ADO Connection close the database?
variables in last cell
Re: Does destroying the ADO Connection close the database?
Conditional Formatting
Form output naming
Keeping original data format in a pivot table
Non-absolute named ranges
Close database if it is open
Excel Web Query
Please help: Running a macro only once
User Form
debug errors....
Re: Macro to print on both sides
Re: Formatting Problem on Double-Zero String
Saving macros before re-install
Sort method of range
Passing a value to a variable from Userform
Re: Loops
column drag-and-drop
ON ERROR
Application.Calculatefull function
Worksheet_Change Event "Circular Reference"
Help with Formulas
Re: Macro to print on both sides
Re: This is just a test!
Rename a sub
Rename attachment
Symbols in UserForms
Print Macro : Object not set
Calling a function from within EXCEL
Re: Automatically generate a unique file name via macro...
show a userform
Re: Enable Macros Warning
Richtext Control
Re: Change hyperlinks en masse?
excel 2000 workbook.activate not 100% reliable with alt+tab
Programming behind a button
Popup form from Excel not VBA
Cashflows
Conditional Formatting for Currency
Deleting Macros
Web Query
Protection
run exe program and locate current workbook
Hide/Unhide a row in Excel
Re: charts
Highlighting 'corresponding' cells
Number format in a message
cell color within a function
Toolbars
Customizing the Legend
FindFormat
enabling custom meu items?
Key behaviour
How can I create several instances of Excel ?
Re: Unload from Memory
Data Validation
FormulaArray and Formula prinicples
Re: How to: reset the pull down menus to item 1 on start up?
How to: reset the pull down menus to item 1 on start up?
Breaking a word by each alphabet and inputing it in different cells
Re: Sending data to Outlook for emailing
to kill a excel process
Re: Beginners' Question : How to move selected columns & rows to a two dimensional array
LTrim
Re: Empty Cells!??
Re: cboBox to read data from a spreadsheet Range
Re: Value of Zoom print setting
InStr used in SQL query
Pop Up Screens
Possible to delete or edit a desktop shortcut?
Re : Excel event handler Worksheet_SelectionChange
writing to a cell
Searching / Calculating Multi-Dem Arrays
Excel tries to reopen the file
Re: Save as CSV without being prompted
Custom Toolbar (Macro path changes)
Re: Page Formating & Macros
countif and AND
run a macro on an in-active workbook
Spin Button
How to Pause or Stop a running Macro
Determining the immediate caller of a function
Re: pull value from last cell in a column
For Each
Re: Automatically generate a unique file name via macro...
Re: Formatting in VBA
Re: Save as CSV without being prompted
Re: retreiving number of e-mails from public folder in Outlook, next step
sorting zip codes
Printing question - Spreadsheet......
Re: Scroll
Re: how to kill excel using a vbscript
Sorting Names in an Array
retreiving number of e-mails from public folder in Outlook
How to make drop-down lists show more rows
Re: cboBox to read data from a spreadsheet Range
Embedded form?
Re: Enable Macros Warning
Re: Sheets(array) method for printing grouped worksheets
Re: worksheet tab - rightclick choices
Re: Automatically generate a unique file name via macro...
Re: hiding vba code
Unprotecting worksheet in a macro.
Copy formulas to certain sheets
tool bar problems
sql.request for secured Access Database record retrieval
Obtaining Series Name and X/Y Value Ranges for Charts
Programatically Breaking Links of Copied Chart Sheet
MSForms cancel
Re: Formula probs
1.)Input Boxes 2.) Condensing a Code
Trendline Equation
Format a cell IF...
Formula Problem
Running macros
Re: Userform with template class module problem
Re: Userform with template class module problem
Pivot table not refreshing
upload a button image
Thank you all.
Formula Probs
Re: Unhide row
Selecting Cells to set up Advanced Filter
Put copy/paste between books in macro
Disable Control s
expected sub, function, or property
Re: Macro to Paste Special
Project won't compile...
Re: Zero out the cell macro
Countif Function
Countif Function
Cannot shift objects off sheet
executing macros with variable names
Re: Designing Multiple Spreadsheets with scaled data access.
Re: Countif Function
Custom formula
Excel Getobject error
Re: Countif Function
Activate Column after locating text in a row
Re: Automate Control Tool Installation
Recommend a good book for vba for a beginner
Revisit "Close without Saving Changes", please?
Macro to Paste Special
Re: Countif Function
Re: writing a variable to a cell
References question
Re: writing a variable to a cell
Macro Questions: Returning multiple results, description of parameter syntax et al.
Re: How do I set the name of a WorkSheet?
writing cells with variables from vba
Import and transpose tab seperated data from text file
Re: Excel Page count
Re: Excel Page count
open for append
Running a VB Script
run macro for all files in the directory
Excel 2002 and 97 compatability
Finding Duplicates
Counting Colums with Data
Decreasing/Increasing decimal places
Date function and combobox
DCOM98 and EXCEL2000 collision
Need Code Enhancements
Mouse Click Event
Re: DCOM98 and EXCEL2000 collision
Re: Need Code Enhancements
Re: curious date results
Close button on Custom Menu Bars
Excel Spreadsheet Corruption
Looking for break even axample.
Search For Data In An Excel Sheet Thru Code
Problem with using Protect when userinterfaceonly:=True
Koppeling Excel en JPG-Afbeeldingen in aparte map
Re: ComboBox items
Spinn Button
Excel returns blank values using ADO/VB
DCOUNTA formual in VB Script
Copy with NumberFormatLocal included
Setting values in another workbook
Sending data to Outlook for emailing
Re: DDE and application.caller help
Re: Network drives
Re: Run-time changes to subtotal parameter list
Re: Empty Cells!??
Permit DoubleClick but prevent other editing
Re: Worksheet name used in a formula
Re: Collating Sheets question..advice plz
Do Until loop with if statement
Single command button to select one of several choices.
Command Button Properties
Adv. Filter & Worksheet Change Event
Macro
Determining whether function called by Excel or VBA
Code help.
Excel 2002 Automatic Macros
Re: Counter
Re: Counter
What order does VBA look at userform controls?
_How could I get the code to find out the resolution that user has in the computer
disable menus on opening Excel
Re: macro that runs for multiple files
A code problem with short Estimating worksheets
Re: Delete cells in row A with just zeroes
Re: Button To Cancel Macro
find data on 2 different sheets?
SetFocus method in VBA
Excel macro on a DOS command line
Delete userform/module using VB
Determining if a worksheet exists within a workbook
Personal.xls only partially effective?
Using a variable to represent a Checkbox Name(OLEObject)
Changing Author Name in an existing cell's comment
User-defined function creating circular reference
Re: Worksheet name used in a formula
macros, functions, and command buttons
I need help
My Apologies
Creating worksheets then name it
Replace File
newbie programming
Re: Joining text in multiple cells
Automate macro
Sorting with worksheet protected
MS Excel - SQL Parser with VB .NET
Re: UserForm Control
Re: UserForm Control
Hide worksheets on start
Vlookup issue
Responding to Enter Key
Web Query & Cookies
VBA to Find & Delete
Re: Excel VBA
TextBox.SetFocus
Using Built in Functions in VBA Code
Re: Code for Grouping Text Values in Pivotfield
Excel VBA
RS232 to Excel
Formatting the default Excel sheet
Re: Finding Empty Rows
Re: Displaying Folder Structure and Files from WIndows Explorer to Excel
Re: Finding Empty Rows
Re: Displaying Folder Structure and Files from WIndows Explorer to Excel
Re: Paste in Find and Replace Dialogue
Re: Importing files
Opening a worksheet with a button?
Re: Paste in Find and Replace Dialogue
Excel 2002
Control Source
Creating a directory from a date
Re: Logic Question - Can you help please
IF ___ then fill color???
Re: Macro - Pasting clipboard in a find box
Re: The Find Method
setting label to open folder
Re: dynamically linking cells
auto find xls files and values
Modify Calculation
Sending an array to DLL Function
Re-assigning the value of a variable for a for loop from
Re: Code to copy chart
PivotTable: AddDataField method
Open Method disabling Macros
Beginner's question
End loop macro with count
Re: Newbie. Please help me find a loop solution
Msg Box
Code to copy chart
removing text within a cell
Code to Hunt Linked Cells
tough problem - working out if data is within certain boundaries
Two really easy questions
Web query timeout
Web Query fail to Refresh All but individual refresh is ok
Re:Find out from a date if it is a red letter day or not
excel and powerpoint instructions. Possible?
Converting XML data from SQL Server to Excel spreadsheets for reporting purposes
Newbie. Please help me find a loop solution
Accessing/Clearing range in hidden workbook
row highlighter
Excel textbox problem
Re: How to create picklists programmatically
ResetColors failed
Copy selected data to new workbook
ComboBox Values
Worksheet Change Event Help Please
problem (bug?) using =HYPERLINK in database query column?
Beginners' Question : How to move selected columns & rows to a two dimensional array
Re: Quasi array formula
what is a vb script
ActiveX Controls on Excel sheets
Copy Multiple Spreadsheets into One Workbook
control toolbox
A question on read the record from excel
find next unused row
The Tab Function (Take 2)
The Tab Function
Demo of Wheelmouse Scrolling Listboxes
Combo Box Values
Assigning the name of a userform/control to a changing string
If..Else Statement in Excel
Importing data from the web
Old button code not working in Excel2002
Returning single/multiple values from array function
Re : Excel event handler Worksheet_SelectionChange
VB code for printing one page at a time
Location of Help File and SQLDMO
Camera_Toy_Videogame_Laptop_sale
Re: Print Landscape AND Portrait Orientation in ONE Worksheet
5.6 Scripting
VBA Question
Print Landscape AND Portrait Orientation in ONE Worksheet
out of memory error
excel.exe error with query
Changing font color based on the values
Locked/Protect in Workbook_open not working in X2002
Re: Email using universal naming convention
Modify Find Code
Page Header with Fit to 1 page wide
Changing PivotCache SQL Database
Having problem getting date into format: yyyy/mm/dd
Re: retreiving number of e-mails from public folder in Outlook
Re: shape grouping text
MultiPage UserForm
Format text
Link code
Event - RaiseEvents Within Class Modules
Can't find project
Load Vb Functions
Re: An Excel environment started from a VB script .vbs file.
Open Microsoft Word and get Page count.
Code Text Into Chart Lines?
Making menu item changes temporary
Re: The Find Method
Get.document(50)
Displaying Last Editor's Name
Unable to set the Locked Property of the Range Class
Re: Frustrated with Factorials
CUT And PASTE
Events for workbook close
Code for existing links
Re: List box initialization
Re: window minimize
List box initialization
Re: Naming Chart
VBA for Dialog Box
Events for cell deletion
resetting worksheet properties
Excel on a Form
Re: How to tell whether a cell contains a formula?
Extracting PDF report into Excel
Naming Chart
Re: How to tell whether a cell contains a formula?
vb simple formula
Code for Links from Excel to Access
VBA Code for Links to Excel workbooks
Re: Need Macro to Copy Visible Cells to New Sheet
Re: Need Macro to Copy Visible Cells to New Sheet
Re: Can't set manual HPageBreaks
Re: Registry
Control Bar
Zero records in Filter
Replace in VBA Excel
different places to put excel code?
Outline and hide feature
Filtering on Formulas (makes messy sheets)
Count # of Times Sub Executes
Event macro
Pivot table
Can't terminate the excel instance from VB
Data Validation
IF then formula
Re: Setting zoom for all worksheet pages
Delete row and Excel locks up
Auto Path in Footer
Re: Automatically incrementing invoice number from template?
Re: Auto Path in Footer
Copy range of many files in directory.
Re: changing setting of tool box
OnAction
Re: Registry
Right function disappeared
Dropwdowns not working in Excel XP
Custom checkbox
Modeless form for user interaction
Question: Range().Select for more than one row?
sql results in excel
COUNTIF criteria
Re: Automated Print in Macro?
Is something wrong with the code
Automated Print in Macro?
Translating spreadsheet formula to VBA
Copy Method of Workseet Class Failed
Re: Accessing the Desktop
Value is not displayed on the screen
Macro Error
Time Stamp
Row Deletion Using Text Trigger?
need help with simple syntax error
problem with user form
Data validation with the Select Case statement
Blank Rows at end of Worksheet
VBA Advise
Strange problem - extremely slow application.
Setting zoom for all worksheet pages
Re: Setting zoom for all worksheet pages
Manipulating a spreadsheet opened in IE using VBA
Re: Display on cell
Detecting Calculation State
Simple problem refering to variable in For ... Next loop ...
Row Number
Re: Excel changes file modified date when opening my add-in
User Interface
Declaring Dynamic Multi-dimensional Array
Re: user form controls
Picture in Web Page (saving to disk)
Automatically Generate a unique file name...
sort multi-dimensional array on numeric data?
Histogram parameters VBA
Hide command button on worksheet
Invisible Range Names
Excel Addin with drop-down menu
Re: Application.ScreenUpdating = False
how to declare a class module
User Input File Name
Custom defined formula
How to print Worddocuments with Excel VBA
Re: Active Cell plus number of Rows
Re: Active Cell plus number of Rows
Deleting a file using VB
String length of Inputbox user input.
Find First and Last Row Number in Column
Re: SetLinkOnData help?
Help Evaluating Cell Values and Changing Colors
Re: can i insert a picture
formating a cell with a conditional if statement
Re: Convert Excel to text
Re: Can't set manual HPageBreaks
User-Defined Function Unusual Operation, Again
Using a variable as a row reference?
Size and location of chart
Worksheet/workbook protection property?
Lookup table in addin
Help with Inputbox Function
Lists and masks
Lot Of Code
Disable Worksheet change event
HELP - Communicating between C++ and VBA
Clearing a merged cell
Adapt an array routine or a better way?
Running a macro from a desktop icon shortcut
Bugs using combobox 2-fmstyledropdownlist
Adding figures in excel if text is a certain colour
saving excel table as text file
Cell properties
Multiple IFs
Hidden Command Buttons
VB Project
Re: Macro for Pivot Table - Apply to multiple workbooks
Move a "picture" object
see the full comment on a cell
How to check if the Excel VBE is opened within Excel?
Finding first Null value in range?
saving macros to a common folder for all users
Re: Multiple IFs
Turning off System Messages
Re: saving macros to a common folder for all users
Mandatory Cells
A problem to solve, a little help
Dynamic Row Selection
Excl 97
Re: Create Command Button from Code
macros for other applications
Re: Disable Menu and command buttons
How to get the PivotCell object??
Menu toolbars
Re: Using a variable with .LookIn
Re: Checking the result of a formula
Deleting multiple columns slowdown
sql results in excel
ChangeLink command
Checking the result of a formula
Re: Checking the result of a formula
VBA Project Security
check if range containing values
Re: Combo Box causes system resources error
Dates and Arrays Driving Me Nuts - Help!!!
Combo Box causes system resources error
Declaring Global Variables
Delete characters in cell
Header problem!
Re: access 97 to excel 97: execute macro automation
User-Defined function not working
Error Msg: Permission to use object denied
ARRAYS
Selective protection of charts: permit only BeforeDoubleClick ?
Calculation for Dates
Placing an array on the active sheet
Copying an array variable to a sheet
Nested Find problem
Conditional formatting
FileSystemObject to get last 10 lines of text file.
Error Msg: 'No Cells were found'
Re: add separator bar to right-click menu
Recalculating Cells error (and more)
Re: Sorting Odds & Evens
Re: COUNTIF FORMULA
Object required confusion
sorting
Macro To Update Data Table On DDE Link Change
PrintForm Problem!!
Re: VBA Hyperlink Question
Re: access 97 to excel 97: execute macro automation
Re: worksheet_change vs. calculate, and worksheet_change not running
Re: Email using universal naming convention
worksheet_change vs. calculate, and worksheet_change not running
How to import more than one text file into Excel ?
functions
copying blank cell
Problem using XNPV from VBA
Problem using XNPV from VBA
Re: Why doesn't this function return TRUE?
Re: Sorting Odds & Evens
Copy worksheet from multiple files in one DIR to another DIR & rename
using excel 5 dialogsheet in excel 2000
Re: How to open another Excel spreadsheet to copy data into current spreadsheet ?
SelectionChange code always available
Re: Add new sheet and Name it
cannot close workbook
Re: Expiry Date for further updates into Sheet
Offset Formula
Macro to send mail to email id mentioned in a particular column
Re: capture shift-double-click
determine page number in Word document
Re: Sorting Odds & Evens
How do I Clean up this formula?
Re: creating a chart in a form
Re: Excel 2003: XML Validation upon editing ?
Slight adjustment needed for Macro
Re: logging excel events?
Maybe an array ?
Need VBA Routine
How to copy rows using fontcolor as bookmark?
Summing cells based on run-time criteria
Re: VBA & Solver Memory Usage
Code to Email with UNC in subject line
lock-out rows from scrolling
Behaviour of "Replace"
Controlling Font Name in a personnal Commandbar
Re: Listbox lists
As Addins load question
Re: Create help for user-defined function
Splitting data in a cell
Re: run Excel on schedule
Conditional Summing Cell Range
Re: compiling multple worksheets
Excel cannot save my digital signature
Adding leading zeros to a calculated value
Re: Need help with decimal places
help with VBA code re comparing cells and generating message with detailed info
Reply to Tom
Re: count pagenumbers?
Don Selecting cells
Checking Military Dates
vba date XL2000
Image Variable
Re: Help with copying please.
Setting up a Month Array
Help with some sheet code
HELP sending email from Excel
Re: Round error on home comp
Re: Newbie Seeks VLOOKUP help
Selecting Cells
Direct manipulation of TextBox
Re: Small programming task in Excel VBA
opening webpage in excel
help whit hyperlink
Re: Small programming task in Excel VBA
Randomize the order of the contents of an array
column header click
DATEDIF
Controlling two different printer trays
Re: oRange.Interior.Color
Re: Determine maximum length of a page
Re: Sorting a 2-dimensional array
Re: Using Named Cell References that aren't present yet.
passing data from one sheet to another
How do I find which cell called a function?
Keeping macros neat
Re: comments
Can MS EXCEL remove duplicates and separate by color coded items ?
Re: vba
Close Browser window with VBA
viewing VBA behind existing pivot table
Pivottable date parameters ...
Excell HTML Conversion Needs Refresh to Correct Format
SaveAs method
retrieve data from SQL server and populate excel sheet
lock one cell when data in another
Cell data format in an e-mail
Re: "Can't Show Modally" - Run-Time Error '400' Problem
Menubars
Re: setting ctl to array of checkboxes yields type mismatch error.
Landscape print with Letter paging
Protection UserInterfaceOnly reading Hidden Formulas
Reply to Tom
Re: Windows
Thanks - creating a commandbarbutton with a custom bitmap
UDF, Type it or use Insert Function
Stop Problem
unticking option buttons
Re: msgbox prompt when user selects data from combo box
Re: creating a commandbarbutton with a custom bitmap
Re: setting ctl to array of checkboxes yields type mismatch error.
can not open and can not delete excel files
Get External Data, Import Text File, File name problem
printing comments
Automating printing to PDF
Making Hyperlinks Unavailable
Listbox lists
Getting the coordinates/ size of a bar chart element
Upper & Lowercase
Check for duplicate entries
Re: Referencing Named Range in Other Sheet
Help understanding the following VBA code......
Re: Finding the last row of chart....
Date bug
Directory checking
Code for Page Footer Font Size
sendkeys
Using VBA, subtotal a column only if there is more than one qualifier
enormous file size - VLOOKUP function?
Excel / VBA
webbrowser control tab navigation
CopyFolder
re-enable macros
contouring
Re: Help with sheet protection
mortgage amortization formula
preserving type library references when distributing macros
Re: Formula help please
Re: Detect more info when workbook does not ack right.
Logitech's newest mouse scroll fails in VBE code pane
Mismatch!?
Formula help please
Re: Formula help please
Re: Unicode StrConv/Substitute routine...
Email question
OLE Excel data handling from VB
Re: sort for variables
Is there a "cell change" event?
macro for e-mailing excel file using outlook
Header - only on first page
VB question...
Help with If Not Intersect
Data Box
Re: Looping through each directory
Code to display dialog for unhiding sheets
Re: Code to display dialog for unhiding sheets
Re: VBA button click need help. Need LEN help.
Re: VBA button click need help. Need LEN help.
Re: Macro to list all Formulas in WB?
Open Searched File
Excel data to Access
Macro to rename all worksheets with cell value in each sheet
Need HELP to modify code (need more automation)
Re: SaveAs "subscript out of range" error (COM -> SOAP)
Re: Excel / VBA
Re: Expiry Date for further updates into Sheet
Handout of Excel Object's Properties and Methods
Re: Opened File
programming outlook 2000 from excel
Re: Opened File
Re: Search Methods
O.T. Copy Protection
Creating a drop down window
Re: Help coding userform
Activiating and Selecting Excel Cells in VB.NET
Listing files in directories.
Preventing Duplicates using VBA (code)
Distributing code
Hide Slide Bar?
Put a timer on a MsgBox?
Re: WScript object not found (???)
MOD function
Object doesn't support this property or method
Re: combining sumproduct and average
Please somebody help me...
Email one page of information on the same sheet
Adding a category to the Function Wizard
Closing Excel Completely
optionbuttons
How to set global constants and get path of spreadsh ?
Link Excel range to PowerPoint Application text box
Trend function in VB
Newbie question about iteration technique?
Re: Consolidating multiple files using a row column range
Re: Closing Excel Completely
Re: Closing Excel Completely
Re: SaveAs "subscript out of range" error (COM -> SOAP)
Re: Closing Excel Completely
Re: prevent second copy from opening