Excel Programming [Archive] - Page 109

Pivot table - Charachter limitation
Excel Forms
delete toolbar
Copying values from cells if another cell contain value
installed toolbar?
Pivot table to launch Macro
All sheets calculate after saveas
Acknowledge a messagebox programmatically
Is there a list of constants and conditions available anywhere?
Printing all files in a folder
Programming an unusual action
need macro help
VBA Code for Selective formula writing
List Box - Option If wrongly selected
order sheets
CANNOT OPEN "OPTIONS" IN THE TOOLS MENU
Re: Alignment and format in listbox columns
check value with array, Application.Match
clear cells unless contents are in bold
Goalseek "may not have found a solution"
How active the tab's color menu ?
Specific cell
change a formula
Reloading values in optionbuttons or checkboxes
Web Browser Control for Animation.
payroll Clocking in and out
customised printing of multiple pivot charts & tables - unsure how to progress
Date and Time conversions
Re: Remove spaces from a string variable
Remove spaces from a string variable
Compile error: Procedure too large
Named range for chart range value?
Capturing Cancel button on save file dialogue
Finding the Excat text in a range
Control Toolbox Controls
access workbook protection password in VBA
Getting Range to move 1 column left and resize by 1
how do i autorefresh a datasource every 5 seconds in Excel?
Saving to subdirectory using date()
Need help with List Box setup construction in Excel
date drop down box in vba
validation all cells different format
HEX2BIN
Unable to set Hidden Property
Impossible to set security policy for VSTO Excel?
Update pivot tables automatically
Font
SQL Query - Ability to Refresh Data is Lost
macro video
copying from word and pasting into excel
Calling a Public Subroutine in a Different Workbook
Apostrophy Detection
MS JET database engine error: workgroup information file is missing or opened exclusively by another user
Excel Application.SetReferenceStyle
How do I randomly assign values in a grid?
Changing label caption in a Userform to an opterator value
VBS script to add xml data to excel
Another invalid or unqualified reference
Macro Problem?
Pull info from access to template in excel?????
Procedure similar to VLookup - need help!
Copy Formula with a Macro
Need help with my code!
Color Background cells in workbook
Excel resizes images with no apparent reason
Keep Consistent cell positions on screen across tabs
Books
Excel 97/XP Issue with numbers and French machines
Macro to find a comma in a string
cutting a row and pasting to a column
Application Level macros
Password on Commandbar menu list
using variable as object name
Saving to a netword folder without mapping drive
Purchase entry (Invoices) in Excel, quick and easy. Does anybody k
illegal field name using advanced filters after inserting a row
Conditional formatting based on one cell in a row
Determine sheets in file
Do Loop
Application.enable
Workbook Loop Headache
Excel 2000 required multiple user name and password logins
Re: COUNTIF / AND functions
Find method - finding multiple values
And/or Functions /Countif Function
error 400...
Replace conditional Formatting with Shapes
enable menu command not working
$
RE: Simple Question
Custom Header
RE: Delete all visible sheets in workbook...
deleting rows
Format text box and move across date time picker
RE: Delete all visible sheets in workbook...
Format a Userform textbox to Military time
Shuffle Array
Re: Return file from a path string
Re: Return file from a path string
OptionButton Check
Matrix Ops Type Mismatch
Paste Values
How do I create a macro to color a cell only when I click on it?
Finding all hyperlinks in row a, copying to new worksheet
Pull a list from a box
Spinners aren't cutting it
File truncation with VBA
Web Queries from different sheets
active cell
how to make a magic square in excel?
select only non-matching rows
Open file and print sheets based on data in cell
Selection.Find.Replacement.ClearFormatting
PrintTitleRows Problems
Macro to change filetype .dat to .xls
Creating a PivotTable in VBA
Inserting large amounts of data with VBScript...
Changing Range with Months
macro only in active sheet
windows.activatenext
browse to find file
.Find Across Multiple worksheets
How do I use a macro to save to a specific drive in Excel?
Excel03 - empty cells and SpecialCells ( xlVisible )
HTML issue
Macro does not work after the program has been restarted in excel.Run time error 2147417848 (80010108) Method visible of object_worksheet failed
Remove "Refresh external data" from template
Slow Code
CountIF
Call GoalSeek from a user-defined-function
Bloomberg
What is the Status Bar used for
get reference to cell from mousedown event
Excel vb help: How to grab the right Data
Writing to An Array or Collection
User form problem
Problem with Macro/Protected Sheet
Application.Quit
add text to AutoShape
PivotTable Does not refresh individual items
Kill
Using OWC VBA programs in excel 2000/2002/2003
refering to worksheet cell under shaoe object
Two Quick Questions: Calling Subs & Text Input boxes
Referring to a TextBox
NUM LOCK status
Object Type of a selection... counting rows in a selection
Wrkbk already open by whom?
Setting up a simple loop to fill labels?
Create a workbook
Passing Values
Number of employees function
i am interested in buying PDA that support micosoft excel macros
Count conditional formatting
update prompt message
Move the position of spreadsheet on the screen
want AutoFilter to default "on" for all columns
Date/Time picker methods
Declaration problem
Record Merge Macro
Checking whether a field is bold.
Assign click functionality to dynamically created textboxes?
How can I use VBA ADO to check if a table exists in an Access DB?
Reference cell address of Hyperlink
Record Excel 2003 Macro?
Run-time Error 1004: Application-defined or Object-defined Error
Drive, Dir and File list boxes?
how do I select cells in column A thru F in the active row?
Linking to, and copying from, a web page
Problem running macros in Excel filenames containing special characters like []
Dates in Chart Axis
Excel VBA expert required! Small to medium job.
On Event calendar with error handling?
Automation Error
Collection Code
Data Points on Charts in MS Excel
delete worksheet with chart?
Moving ranges by start date
adding cells
PLEASE help me with a simple budget formula!
E-mail Attachments
Re: Detecting spaces in UserForm textboxes
Convert numeric part of text to number
Command Button Macro Execution Failure
Detecting spaces in UserForm textboxes
Object Required Error
rounding to the nearest half ( .5)
Referring to a TextBox
VBA project password on close
Combo boxes
macros
Required cells??
drop down list that i can also type regular text in as well
mulitple checkboxes - changing value of all of them at once
COM automation in CPP question about array
Want to open only one workbook
open dialog box for file path
Hyperlink to open password protected file?
Why does Match statement in VBA fail on cells with errors in them.
GetObject error 429
Simple question to find min value
Multiplying 2 columns- one with numbers only, one with a number &
VERY off topic - Visual Baler Software
looping through worksheets, sorting and subtotals
Error 430: Class does not support automation...
mortgage payment
VBA (arrays problem)
sum current months values
Disable Click event
macro to save to network
Embed spreadsheet in IE
Programing Help Needed
Progress Bars
Page breaks
HELP! Problem with combinations
Annoying web toolbar
HELP-Dictionary
Flow chart of code? Is there a way to produce a graphical flow chart?
Getting a Select Range class field during a macro setup
Editable, Linked Combobox.
Auto update of cell value after insert row?
Assignment to Constant Not Permited
Putting Page Number in last page text
TextBox problem in a UserForm
Adding + Multiplying 2 Colums' Rows
Compile Error On Exit (can't find form controls)
Referring to a Date in SumIf
Web Query
What does this do?
Setting one Column's Value Based On Another Column
xsl stylesheet formatting
Error with a For loop with arrays
Excecute Macro if cell changes
Schedule Excel to Update
Automate AutoFill in Column
What's faster -- array formula or UD function?
Web Query
Excel 97 automating web query?
Open method of worksbooks class failed
Loading graphic into top left strip of userform
Can't pass publically defined variable to a function
GREP in VBA
Need to force unshare of workbook
i need a quick answer.
Tool to pick from currently unsaved files?
Can't Get Match Function to Use on Array
transposing data
Run a macro when updating a cell
Search Facility
Select variably-sized range which contains empty cells
Assign hyperlink to new commandbar control
design question: array of elapsed days per month
count number of rows (variable range)
Adding CheckBox Caption to a Listbox
Listbox Problem
joining macro
Change linked cell reference to absolute
mouse move event
Excell automation - How to move sheet using late binding and VB.NET
paste
Error Message.
Pivot table, two data sources.
Excel.Range.Name gives error an exception
Simplify a macro
Allow multiple read access and only 1 full control
Looking for a value using FIND and WHAT
execute macro in other workbook
Application
jump
new workbook
Option Button
Listbox problem
Application
Cell colour
data from external webpage
deleteing a range from one cell within it?
Form 2 Form data transfer
Problem with Range.Cells.Offset and Range.Cells( row + offset, column)
Having a macro recognize when an option button has been selected
Need Help on Lookup Function
Duplicates
ActiveSheet.Unprotect
Protect spreadshet, but allow user edit range
Macro to transpose column to row please.
API Function Call - GetFreeDiskSpace
Job Numbers lookup
NETWORKDAYS problem
subtracting AD and BC dates
macro to plot charts of >1000 records automatically possible?
Football League Table
VLookup in VB?
VB to copy invoices
Setting printer in VB
Real Estate Rent Record Databast
Macro to list numbers
Macro to list numbers
macro to list numbers
Checking for Duplicate entry using VBA (?!)
Select anything from IE and store in Excel
Find the Record
variable help....
Assigning name to current region
Reformatting incorrect dates
printing pre-printed forms
application.sumproduct help please
application.sumproduct help please
Cycling through controls in worksheet
Excel icon
Range names
Formula errors solution
Worksheets Select
Merged Cell arithmatic
combobox problem
Run on cell change macro question
Calling sub procedure
Command button to get a Word document
How to pass a variable from Form back to calling procedure
Passing more than 255 characters
Bug: Command Button Text Size Changes
Worksheets.Add won't let me specify a template
How do I formulate colored cell from master sheet?
load/unload userform
Excel can't execute minimum / maximum scale property
Executinh Addin Sub Menu Command
Duplicates in column
VBA coefficients of an equation
Best Way to Implement Data Mapping?
Adding a cancel button
Compile error in hidden module: security
Atomatically moving the cursor 2 cells to the right.
retain table formatting when writing excel table to a txt file
Assign Personal Digital Signature Macro to files
File Append Row by Cell value
2 part question
Updown control question
Re: Magnificent Problem
unProtect some cells on the spreadsheet
Loop thru some worksheets
I need a liitle help please
copy PROTECTED worksheet without referencing original
count only the visible rows in a data table
Changing number precision of a trendline equation
OnKey Method
How do I enter a not to exceed number 1 in a formula?
Overwrite Prompt with Save As
organisation chart + vba
xlCellTypeBlank Problem
Creating an array of sheets to print
Storing Data in code? (relative primes to MOD as example)
Code to access Controls via variables?
Reset alerts when closing workbook?
Validation rules base on formula on other cell
Match Command
AutoFilter Pull Criteria from one sheet and custom filter on other
More help with Custom menu's 2 problems!
modification for the code
multiple results
Problem refering to Add-In sheet
Copy paste WkBk/sheet 1 to multiple wkbks/sheets
Re: Writing Excel to Access
Copy
Sorting columns
vnd vnd.ms-excel
ADODB Connection String
Global array declare
Re: Code won't execute...
If Cell equals text Copy Cells, B2,B3,B4
Re: Writing Excel to Access
Working with Access Dabatabases through VBA Codes in Excel
Functions not Functions
Multiple large .NewSeries lead to Run-time error 1004
Arrays and range references in VBA
Automated mail merge macro
WithEvents
End a loop if text is not found
How do you Subtract dates in VBA
Goto Previous worksheet
Clear spreadsheet cells format
Copy between workbooks if statement is true
User Upgrade Procedures
How Close Excel from CMD prompt?
Deleting SeriesCollections in charts
Disable Clipboard Memory Saver
refresh worksheet code
Format on New Database Query
i have a sheet with invoice data on it i want to duplicate
User Form Option & Command Buttons
CommandBars disappeared
CSV Newbie Question
string functions disappear after upgrade
In Project Explorer why do closed workbooks still appear?
defined name ranges
TYPE Library issues.
Do Loop
recursive output if amount > x
ComboBox Help
Do Loop
Linking Pictures located externally, to change links based on vloo
Fuzzy icons from PasteFace
new to vba
Sumproduct
Weekday Help
Insert blank row and issue a sum
Using For loop to condition
Range(Selection...question
Paste a value (SUM)
Excel OLE automation
Data validation
Problem with hiden workbooks
read access db using excel vb
Checking to see if a worksheet exists
Selecting Cells With Sumproduct Formula, Then Pasting Its Value Over Top
Associating a sound to a MsgBox ?
Color Index
Passing variables from one sub to another
Simple Question
how forrmating
VBA buttons shift around when using Print/Print Preview
Updating a database with macro
Sorting sheet problem
Help with path in VBA
Validation rules
Help with mscal.ocx XL2002 vs XL2003
3-d space triangulation
Restricting data entry
Inserting Excel OLE Object
How to create a formula in VBA to assign to a cell
Need a little more help with formatting!
Obtaining Info From MS Outlook
Lookup an email address in Outlook based on Username (newbie quest
Using Offset on Variable Dinensioneds Object
Easy Excel Macro?
Simple Question
Addin out of range error
Extracting items from Autofilter drop down
Trouble with Sheet Deactivate macro
Creating custom face ID's
Exit Sub Question
Re: Accoladeds
Compare 2 files and Update
Is ADO dead?
Array Formula question
Can't set font.colorindex from VBA
new sheet
Toggle Calc Button - how to make it work OK at startup
Lookup up active cell value in passed range
Disable automatic saving of VB Project
Need an easy way to remove all commandbars
Exporting to access but no error message
Combo Box Not Refreshing View
Running form procedures from sheets
Make selected row visible to user when out of screen view
Excel forms And combo boxes
Textbox input interpretation
How can I create a Floating Command Button
Status Bar Reset
Pls. reply Sort Data and copy to next coulmn when sort order chang
How do i use VBA script to control macro security level
Default value of a List Box on a UserForm
Data Validation on UserForms
Command Bars
Tom Ogilvy or somone else, please help
checking input on a textbox in userform to be a %
how to use an excelsheet that is already in my userform
filters and macros
application.quit
Addressing a UserForm sub in a VB dll
Running Userform Procedure
Getting paragraphs of text into a textbox control
How to disable Macros in VBA code
Use of LOOKUP in VBA
how do I set up a cell to choose a number from a pop-up calculato
Toggle Calc button - working, but want it showing "depressed"
Runtime Error 380 – Could not set the list property. Invalid property value
rounding formula
Help - Deleting Rows on Text Criteria
Short Description in my Excel VBA Function Dialog Box
Wrong date-formating while using data fields?
sharing a workbook hosted in a server
relative cell address
timing a sub procedure
Combine 2 macros into 1 Please.
Excel Embeded In Ie
Hide Empty Rows When Printing
Copying a Userform within the same project
emailing problem
Testing for Hyperlink
Color Codes: Localizing a number format string
Size of array
URGENT, Stuck Smart Indenter
Using function keys in macros
How can i bring data from one sheet to another:
VBA for selecting continuous cells from relative starting point?
Calculating Time
Typecasting Range from excel to work
Typecasting Range from excel to work
Adding .xla button for Toggle Calculation Button
Looping through a range of cells
Locating end of coloumn to add more data
Maintaining cell 'variable' values even after the the macro has en
zoom
Scrolling an Excel worksheet embedded in a Visio diagram with VBA
comparing text in if statement
Clearing text in TextBoxes
How-Import 41 CSV files into 41 sheets?
opening file
copying files
To named Sheets
Protecting VBA Macros
macro pauses
link_location from contents of cells
grabbing data from MS Word
cells property
Customized components
Grabbing data from diff window w/o activating it
simplify SUMIF stmts
question on formulas
a question regarding cell format
Copy format of a referenced cell
Trying to repeat a procedure
Help with the following code
Use a macro to create a new list using another worksheet
Contitional copying of cells from one tab to another
Excel automation from C++ and big numbers
match text and add up from rows and columns
How do I change the paper tray from an Excel macro / vba module?
Color Pallette
Update Spreadsheet off hours
Help finding data from userform
Pivot Table Macro Help
Capturing Data from a Com Port or Printer Port
How to generate ms word doc files from excel sheet.
setfocus sometimes gets error 2110
Disable Save Workbook popup
How do you extract the VB name for a sheet in another file?
Getting values from anotjer workbook
Searching an array and finding sum
Silencing Excel popup messages
Updating Pivot Table Column Date Data
Marcro does not work when original workbook is deleted
Sort Data and copy to next coulmn when sort data changes
Returning Array ...
copy rows based on cell value
Setting .OnAction of a command button terminates my macro.....
Re: Length limitation of cell formulas
Items Added to Right-Click Menu Only Visible From Some Sheets
Items Added to Right-Click Menu Only Visible From Some Sheets
On error resume next and cdate problem
File already in use by another user
Possible for users to open file at the same time?
Opening in a new book
Error Handling of system codes
Using formuals to combine worksheets
Name sheets in VB and Selecting them.
which is excel web server
Delete row if certain column of that row doesn't contain value
Separating Words From a Text String
VBA/SQL date variable problem
Can select range of sheet
Choosing Only One Of Three OptionButtons
Email
Smart Documents - XSD and Namespace
Copy a userform to a different workbook with VBA
Conditional Hide/Print Worksheet
How to remove characters from a cell
copy and paste matching by using ID's
how to do this?
And once again: X and Y Screen Coordinates of a Range
multicolumn listbox - 2002 to 97
Two UserForm Questions
Formula string OK, formula not OK
macro that uses data on diff. worksheet
active cells in range
Coloring row
Sort Data and copy to next coulmn when sort data changes
Mouse Over and Back Function in Excel
Cell Data Validation with dynamic Range
Searcing throught using part of string
Fixing Excel Pivot Table Crashes
Deleting selected macro buttons
PERSONAL.XLS won't take custom functions
Syntax help please
Restore all formatting in one step back to a cell?
Confirming password
adding controls to userform at runtime
VBA to show or hide columns in one worksheet conditioned on value in other worksheet
macro's and data analysis add in problems
"Sum only the colored cells" custom function
Access Array by index
Help Please
Can I Somehow load a Spread Sheet thru a Scanner
object does not source automation events
Setting # of Spaces for vbTab
web interface for excel
AttachDispatch?
Column letter
Change Directory Help!
Line in Macro doesn't work.
Macro won't execute from a Command Button
Generate a unique form number
Combobox_change event problem
Macro Crashes
printing multiple print areas with a print dialog box
Save Sheet and Remove from Workbook
problems defining a global variable
detect cell change
PrintPreview Zoom
Code Stops Prematurely
array and CTRL+SHIFT+ENTER
add in questions
% of Running Total to Grand Total in Pivot Table
Unprocteting a Workbook
hourglass remains after macro runs???
Check cell formula
VBA combo box
Read Only Workbook
In VBA set Slection.AutoFilter show all
pausing vba for refresh
Password protected
Finding data in another workbook
disable and enable macro execution using VBA in another workbook?
DoEvents??
write to external workbook from userform
Object library feature not supported....
How can I format an Excel cell with a "save" or other command?
combo box not showing selected item..
Change Caption of Button
Linking two cells
VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox)
Save As - changes worksheet name
Returning array ...
WB before save event problem
email from cells to outlook - code not working
Pay Stub Problem help PLEASE
excel file format
Function arguments dialog box
Add a new Sheet in a Add-In
Generating Code in Excel / Macro Recorder Manipulation
Activate code in cell
Using VBA to copy range of cells
Refresh Pivot Table Crashes
Help with Coding a Formula Please
TimeStamp Conversion
Sort method from Javascript automation
Using Vlookup to add values to a spreadsheet
setfocus on control works on some computers and not others
sorting by sector and find largest 3 number each macro help needed
Global macro hotkey
extracting a single char from a string of chars
Deleting macros with automation
new sheet
Vlookup more result
Workbook Protect/Unprotect Strategy question
help - How do you program many pivots to sink to same page field
formula to gather non-empty cell info?
Custom buton for macro in an Addin file.
Insert value in cell if another cell contains specified value
Find emty cell in column and insert value
how to sum a column using vb
Panes sequence. Pane Index 2 & 3 depend on how panes are created
Api to console application
disableing a macro after it saves workbook
no menu's
Delete empty rows
Before workbook close
Selecting only unlocked cells to clear
Control Index Numbers
Hilight The Currently Active Cell
Get UDF to Re-calculate without entering cell
Problem with UDF
Financial workshops on Optimisation
selecting a dynamic range
Variable Type and Speed in Updateing Status Bar
multiple criteria in one column VBA urgent need!
excel code tweak for outlook - confusing
Kind of embedded macro
multiple worksheet and copying data from one to another for use in a formula
function malfunctioning using countif and a variable
cell format text
Hi All, need urgent help please.
Extract only non-matching data
Can I unprotect / protect a shared workbook?
Disable and enable auto calculation
Help to improve macro
Reference a cell as part of a file name
Conditional Formationg Macro
Exit Workbook
MAX FUNCTION
why can i use 3 conditions in SQL statement only?
VBA in Excel & ADO: some problems
IF(VLOOKUP("MYDATA", MYNAME, 4) = 0, "TRUE", "FALSE")
Text to speech nuisance
BUTTON CAPTION CHINESE CHARACTERS
DLOOKUP AND VLOOKUP IN VBA
Excel crashes when programming to the VBA Editor
Event Macro Calculate Does Not Work
Local excel file to update website
VB.net/Excel/MSSQL Solution - Help!
To delete the rows if certain cells contain the following
Excel Macro cannot Run at Internet Explorer 6
VBA - ODBC database access help?
Field value from Function.
write a formula to a cell using VBA
Need some Help
re : Help Need on my codes
Put in respective worksheets
get current directory
Microsoft Visual Basic File not found (error 53)
vba and antispyware
excel and dates
Out of Memory
Save Variable Values even after the macro has ended
Determining if a Solution was Found Using VB & Solver
Making functions
XlDown: Go to next blank row
Create 2nd, 3rd , 4th worksheet and so on
2005 Excel User Conference - Sept 16/17 - Ft Worth, Texas
Logic Programming
ActiveChart.Axes(xlValue).Crosses = xlMinimum
UserInterfaceOnly in 2000 versus 2002
Loop through all files on a floppy drive
Repeating a task automaticaly on each file on a floppy drive.
current toolbar file path?
Macros in personal.xls not all showing up in Tools|Macro List
Formulas withing Formulas
vba timer
Restore a deleted Excel Workbook?
Problems with implementing onKey
Retain cell number formatting in Word Mail Merge
Referencing Embedded Worksheet in Visio?
Creating a formula with a hyperlink
access query to excel
Looping through named ranges
Reading complete Excel using DDE code
Showing Group Delimiter in text field
open work book
Offset with variable
a button to open up "My Computer" on an excel sheet
Formatting
ComboBox question
Working with protected Databases Access through Excel
Automatically Updating Cell Links On A Shared Workbook
Using ColumnNumber in Range syntax
Macros-How To ?
Re: Want add color to the cell depending on the value selected from th
Re: Help with bolding and copying text to anf from sheets!
Re: Autoshape Macro
Re: Replacing Formulas with Values
Macros for Navigation
hide excel...but not quite...
2 instances of excel
Making a C++ like if statment case for excel in VBA
Re: UBound of multi-dimensional array?
Offset
Excel volatil functions questions
Different way of selecting range
count and limit radio button selections
Inconsistency in how Range object is accepted?
Excel ignoring legitimate code, AGAIN!
Excel ignoring legitimate code, AGAIN!
Excel ignoring legitimate code, AGAIN!
Excel ignoring legitimate code, AGAIN!
Excel ignoring legitimate code, AGAIN!
Excel ignoring legitimate code, AGAIN!
insert formula
Insert Blank row and paste information
Repeating Reformatting Macro
Is the active worksheet protected?
Re: Text box linked to excel
workbook events
Look up sheet name determined in cell
Text box linked to excel
using find with variant?
Getting rid of update links popup?
Help on VBA Page Breaks
Unloading a form using the ESC key
SQL Query - only applying to one where statement!!!!
Where is the best place to learn about excel programing?
Error:Unable to set the visible property of the PivotItem class.
How to use Object.Copy(Destination) method PasteSpecial(xlPasteVal
Re: Lookup & then paste cells
Simple looping question
Simple looping question
Determining Excel Version
Looping through a column
Newbie Q - outlook & Excel
Hyperlinks to other Sheets
Adding a function to strip the address from a hyperlink
The best way to specify time interval ...
Pasting Personality issues
preparing data for statistical analysis
searching function
How do I execute other application(*.exe) from VBA(Excel) ?
TextBox copying not like windows copying, heh?
Apply same template to other sheet
SendKeys from Numeric keyboard
Need Help On My codes
Print a WordArt in a Frontpage
Disabling ALL commands on CELL Shortcut menu
Super piece of code..At least for me!!
The application SendKeys
Code runs in 2002 but not in 97!?
Using VB to get only those records that match values from a long(2000)list
Do you want to replace it?
Problem opening a file
Re: Excel with Outlook Express
Merge and print
Excel with Outlook Express
code for hiding rows-(coloured)
Application.Goto reference:="MyCell"
Syntax error found in vba vlookup
How to keep an instance of Excel away from the user?
Adapting some code
Macro for changing path in macro
Sort data and move to next 5 column
Disable CommandBar buttons while editing the cell
User Defined Function (UDF) Tooltip
VBA Code to check formulas in a range
Where can I save Excel templates .XLT files?
Calculate Summary dynamic name range
Trying to count text for filtered column based on formula
Question on Text to Column Function
Copy Rows To desinated Sheet Please. But First Creating Them.
Saving Excel in more than one location
Why do Labels added to bottom of Chart Area disappear?
If-then statement that checks for existence of series 2
empty cells
Empty cells after assigning C# .NET strings
Curing #DIV/0!????
Trying to count text in a filtered array using this function
copy range cells to a new spreadsheet
copy variable length cells to a new sheets
How to realize "enable macro" by VBA when opening a file with macr
Undesired change of active workbook
Dynamic userform at runtime
Cell Validation "Ingnore Blanks" doesn't work
Worksheet Revision Date update only once in the same day
Need Help Using cards.dll with Excel VBA
How to use ADO to issue query that more than 250 characters?
Importing Excel worksheet in VC++ w/out ODBC driver
Getting row height to change to match word wrap
extract time from text import
Declarations variables, Dim, some guidance please
Pasting Blanks using a macro
FILTER PARTNUMBER Where it match all 3 Regions
Pasting to Cells from TextBox User Control
Alignment
Help on Excel-Word project
Collapsing Code
Suppress 'Printing page' popup
Re: change the number of rows to a variable
User Form Error
change the number of rows to a variable
Copy Row based on Column
sum, not count money column in between date columns
Summary Page Macro
How to insert Excel sheet to a DB2 database
Values vs. Formulas
Stuffing Numeric Variable Values into Footnote with formatting
Setting a CheckBox Value to False
How can VBA retrieve user's IP Address
Transposing Data in rows to columns (complex)
Finding y-values in budget curve app w/ Excel & VBA
Capture Auto-Filter Change
check is input textboxes is numeric on userform
If formulas when text is used
Cell reference question
WHERE DO I START?
Data Import and Filter
So Close Yet So Far!!!!!
Efficent way of setting sparse array of formulas?
Formulas not filling in without F2+enter
return cardinal number from ordinal number function - an example
Insert Row into MS Word Table
Select range fails
custom icon buttons
custom icon buttons
Problems calling macros in addin from within macros
A Macro to replace a string in a cell with a string from another cell???
NUF schedule
mouse pointer . . . again!
Advancing outer Loop Based on criteria of inner loop
customer database
button caption font shrinking
Pivot table field settings
how do i delete rows when cells meet certain criteria?
copy row to another open workbook
emtpy cell
Drag Attachment file from Outlook to OLE Object
Dynamically Change Row Count Using SeriesCollection(n).Values
keep menus in excel macros that are copied to another computer
Using a variable in formula
Workbook::SaveAs() in MFC - Please help!
Renamed EditBoxes keep reverting to their old names in UserForm
Splash Screen Causing Problems
Pivot Table Drop Lists Out of Order
How do I add up row sums in a systematic manner?
How to print a page of a multipage userform
How to get a calculated value on a userform
Slight problem - routine to add quotes to a column
Excell Database Seach By Drawing Number
Is it possible to expand the formula bar in excel?
Do Loop until empty row (column "A")
Attribute in "hidden" header of macro: MyMacro.VB_ProcData.VB_Invoke_Func
validating input in textbox
VBA keyboard action, formatt no, no info windows
pivottable: how to change source
XLL and "New Form" command error
how can call up solver with a button
Sort data and move to next column
Does Userform exist?
Counting blanks in range using VBA Offset
Newbie problem :(
File opening via Macro with varying file name
preventing endless loops
Ghost Links which force Excel to update on File Open
Loading JPEG to Excel
Combobox Value
inserting variables in code????
Cell with Dynamic Multiple choice pop up
work roster setup
Filesearch for hidden files
How to add leading zero's to number to make char count = 6 ?
Help on Macros, Excel, Visual Basic at Yahoo group Bawatchers
Visual Sourcesafe and VBA
Delete broken named ranges in sheet
Sub "Fill cells using file name" ()
Why can't you use this VBA w. array & cell value instead of copy paste?
Ascertaining the directory name (2 levels up)
excel to access and back
Simple for you hard for me (newbie alert)
Trigger "Worksheet_Change" for specific column?
Using Find & FindNext in a form
if else statement
Parse Directory Filenames
Comparing 3 lists
Is active content in an excel workbook (embedded object, not VBA) a security risk?
Can a template be copy protected?
How can I use a Macro to set a Page break after a character.
Outlook Automation Error Problem - Can't locate Outlook Module
VBA to simulate the enter button?
Can you use QueryTables & iqy file to post web data?
automatically change the order of fields in a sheet
Add In Questions
Dynamic Dropdown list During Data Entry
Recording a macro
Object required error
Another very difficult question; sorry!
OWC need help loading and saving with javascript
IF statement
userform?
NoPrompt
Moving files in Netscape
Queries from web sites that require login
Copying sheet and generating name of new sheet
Autofill method of Range class failed
Worksheet Change help please
SheetsInNewWorkbook
Excel VBA AUtofilter arrow (blue) on wrong column
textbox setfocus and select current contents
testing whether a sheet is present
Merging data
Sort Datas by 4 columns, Day, Hr, Min, Sec
Run worksheet module code from workbook module?
Adding Columns in Excel Sheet
copying unique values to different cell
largest factorial that can be computed
HTML versus MHTML pages
Separate data into 2 output ranges
Saving VBA Code
how are formulas created and why are they the power behind workshe
Merge two Excel files
Code to query data
Multiplying a row with the verticle sum of other rows
DTPicker calendar control
Removing characters
Re: Selecting the first empty row
Cannot get Excel to Quit correctly
Create Add-ins
RefersToRange.Parent gives back an error(from book written by Bove
detect invalid cell reference
conditional formating
empty cell = above cell
Macro that runs entered value through "low" and "high" range
pls reply Parick Molloy
hightlighting rows
Excel Error Help!
length Calcs
Saving with Today's date as part of the string
Formula in macro help
Running a Powerpoint Macro from Excel
How do i timestamp comment fields
Moving Data Between Worksheets
Help with a crashing Macro needed
Algorithm Problem
Open/Import ASCII file
Error while controlling Word from Excel
creating/manipulating form controls placed on a spreadsheet in excel using vba
Current page method of pivot field failed
UPDATE DATA FROM ONE FILE WITH DATA FROM ANOTHER