Excel Programming [Archive] - Page 135

How to use macro?
"unexpected error" when running solver from a macro
On entry
screen updating
Determining path to document template
Function to display a cell containing an underlined number
VBA Array Formulae
Work sheet function -average
Dynamic controls
saveCopyAs
problem Excel VB Macros
Convert no. to time
Worksheet_change Target Address is Reference Cell
Word from Excel
How to Rewrite these Code?
Worksheet code if-color-statement
Active printer
Check File Name before Save Event
Searching a range and copying values into a new range.... **Please help** :(
change colour on value, 4+ colors
Worksheet_change Target Address is Reference Cell
Random Sorting
Problem in setting Cell Interior Color filling.
Using the sum function with a blank total
Hox to control Comment Shape Sizes?
VB vs VBA ??
Worksheet_change Target Address is Reference Cell
Copying Worksheets
ComboBox, referring to content
html markup to add comments to excel cell
Copying Worksheets
password protecting macros
Query on the Use of Absolute References
Add-In
How to cycle through a series of similar objects with a for-next loop?
Date
Search and Replace With Formatted Text
How to Rewrite these Code?
Access to Excel Automation ADODB Problem
VB Programming, trying to save as lower version
Excell FileOPenDialog from another App, and listbox multiselect problems
how can i retieve stock data in an excel worksheet?
Defined Name
Open all files question
How to Rewrite these Code?
Query Automatic Refresh
Edit Excel TextBox using C#
Combine .textorproperty and select case
Use variable across workbooks
Using rng.Value & RefersToRange to pass data between worksheets - SLOW!
Error# 11004, Unable to set the property error
XP activesheet.paste error on VMware servers
Prevent control & break
How to Rewrite these Code?
reference to a cell within a string
Re: OptionButton
placing formula in cells
Finding an underlined character among several characters in a cell
Union across multible worksheets
Autofilling from one sheet to another
Delete row macro/VB
Copying files in VB
Find, Copy, Paste Into Different Workbooks
MDX Query
textbox not updating when controlsource cell changes
File created with VB is hidden
Re: OptionButton
Windows message text font
Paste Problem
Sheet Formatting
Comment Font Size
Calendar Control
Preserve Formatting crashing excel
sugestions
Combo Boxes and Tick Boxes
Run Macro
pastespecial
conditional formatting
Please, help! Anyone? ImageComboâ€™s BorderStyle OR images to ComboB
Beginner programmer problem
get cell's print sheet number
HELP, dont know how to describe this in a subject line
Adding a table to an excel form
unique values
web query data post to ASP
Listbox Properties totally blank
Worksheet_Change procedure question
Value translation
how to remove double quotes?
Data Consolidation
no puedo
email shortcut to active workbook as an outlook attachment
change Company property
protect add-in after workbook closes
Import and run Macro
aligning a form on the screen
Need a Special Sort Routine
If Then to Add Row
check to see if sheet exists
Passing a string aray as an argument to a function ?....Help!
Using the VLOOKUP function
help with vba please
Page Headings
vba to count
The equivalence of EQUIVALENCE
File Open Dialog
Changing Default Module Location
help with vba please
multiple sheets into 1 pivot table
Find data in Column D, add L in Column A
User Defined Functions
Mouse Position
"unexpected error" when running solver from a macro
Visual Basic for Dummies
Generating content on the spreadsheet from an Add-on issue
token/type count?
change colour on value, 4+ colors
copy and paste
coding question
Code to add today's date in subject line VBA
Programming A formula
Formula help please
Check File Name before Save Event
Who has read/write
Worksheet activating
controll and skip duplicate...
Special printing
Execution speed for UDF
Help with macro!!
Check boxes
User defined functions
Excel causing exception error upon opening the document
Excel causing exception error upon opening the document
Programming A formula
Macro buttons disappear when I print
select method of range class failed
Find Command
Please, help! Changing ImageComboâ€™s appearance or alternative. Tha
Need help with file opening formula
Worksheet activating
Populating column N where is is blank or null
Passing Solver a Macro
Comparing cell values
Sort Routine VBA
Ron, Send Mail, Desperate
Shade a region in a X-Y plot!
Event class doesn't fire in embedded VBA
Pivot Table help
Help with Array compare
Problem with post-style web query
Common Controls Color Dialog Box ...
Default File Path
Excel, VSS & VBA ... = problems
MFC Automation
Saving an array
Add file name somewhere in worksheet?
select method of range class failed
Reverse link ComboBox?
Creating a Function
Run an excel macro when a cell value is changed
Use "Data Validation" after data are entered
Stopping the screen drawing
Stopping the screen drawing
Seeking example code
select method of range class failed
take Active Sheetname
stubborn macro
Macro to select Quantity Printing
Clearing Clipboard
Modeless for in Windows XP
Jump to next sheet if not found
Spell Check Within a UserForm?
Stop until Calculationstate = xldone
VBA to "answer" spesific msg box
Data Consolidation
Excel Print Macro
Excel Print Macro
Unprotect and protect sheet in a macro
Retrieve File Name before its saves
Unable to use the function Left in VBA
Populating column N with a formula if column A is Null or Blank
Spell Check Within a UserForm?
Prevent Particular File Name during Save
XL2002 / XP : Crashing problem
Compile Error
Private Sub Worksheet_Activate()
sendkey problem
CopyFromRecordset method
Stop until Calculationstate = xldone
Excel and MapPoint
Calculating and copying data into new sheet
Compare 2 cells in 2 worksheets, rewrite one of the cells
Jump to next sheet if not found
looking for autofilter with code
Public variables and separate library files
Worksheet events - when are they triggered!
XP activesheet.paste error on VMware servers
How can i write TSR code
DBL click over an excel file
Range.delete method
How to password protect several excel workbook pages using a macro
date range vba code
The TEXT function in Excel 2000 VBA
Put file name in column
The TEXT function in Excel VBA 2000
Transparent user form
Command Button OnClick
Print Excel Form In Landscape Mode?
VBA (or other) worksheet function parameter insight
Store text file in workbook?
conditional copy data from workbook to another workbook
Parse database into several files based on column D
Help with OnTIme Event Issue
How to create a macro
Removing (trading) an item in a listbox
Excel Query
Save a Range of Cells as Gif???
If, Then, Cut, Paste, Delete HELP
Help with code
Test if Active Cell is in a named range
Colour shade an area in an Excel graph!
Add-in toolbars
FR - Reprendre le format d'une cellule
Need Help
Find and Delete Blank Cells Formatted as Text
need help in writing a statement
How to deal with an error question
Shade a region in a X-Y plot!
Using a VB.Net interface to turn excel spreadsheets into a working
Finding Real Worksheet Name After Access Export
Using a user form in various workbooks
Urgent - Pl help code for assigning a shape to cells
AutoFilter and copy
Stop message to UnProtect
Re: ListBox filter
HELP, dont know how to describe this in a subject line
conditional formatting & a loop
VBA code not working...
Counters
please help simplify
add worksheets
Excel causing exception error upon opening the document
Remove duplicate rows and sum cells
Runs fast then slow
Hyperlinks in Excel
listbox question
Vlookup in Multiple columns
Clipboards Overloaded?
Data Consolidation
Macro to list files
Removing references
Move worksheet
Calculating and copying data into new sheet
Calculation bug or is it me
exit sub after insert row
Delete Filtered Rows - without deleting column headings
How do I code a "self-destruct" triggered after a certain date?
Calculating and copying data into new sheet
Changing button appearance on custom toolbar.
Re: for next loop not working
Conditionally Delete Cells From Named Range
Macro programming
Converting Excel Formula to Macro
Linking graphs with macro
worksheetfunction
Calculating and copying data into new sheet
Pivot table help needed
storing / appyling pivot chart formatting
Duplicate value with blank space
Export to MS Project
Entering static Date/Time
OLEDB Help Excel 2002
Macro to activate all cells in a range
Calculating and copying data into new sheet
Entering static Date/Time
Variables From TextBoxes
please help simplify
Entering static Date/Time
Spreadsheet web component
How do I automatically change currency depending on another cell .
Setting cell borders
File Path Macro
Restrict Sort on a Particular Sheet
Using a macro to populate a cell with a formula
Dick K - Move e-mail to different folder
An 'event' of zero activity?
Hyperlinks
Automating the summing of columns
Error Message "Formula is too long"
Calculating and copying data into new sheet
Link to Pivot Table with specific page value
Series Collection Points
Remove Userform Deactivate Button
How do Macro to EDIT cells?
Redraw Application Window
Expected:= ???
Expected:= ???
graph
Is this possible ?
[VBA]Inserted value does not get formatted
Collection does not work with strings?
Sub, not function!
Sub, not function!
Sub, not function!
Options
Hyperlink TexttoDisplay
advanced summing
Delete rows from activecell
paste as device indep. bmp in powerpoint
excel truncating leading zeros
ActiveSheet.Protect
Is it possible to automatically run a macro upon a spreadsheet
Save Macro
Copying Worksheets
How to insert an address from Outlook 2003 address book ?
Problems with auto_open
Save a Range of Cells as Gif???
Create a menu to List the Name of worksheets in a Workbook
Sub, not function!
Spaced out
Can it be Done ??
Data (entry) form - expose properties?
fileformat not working with Object
error!
Macro within a Macro help
error!
Sorry for the vague question
RE: Replacing cells that have 2-3 letters: Sorry for the vague question
Replacing cells that have 2-3 letters
activating the cancel button on Input boxes
ClearContents not clearing :(
Replacing cells that have 2-3 letters
Accessing VBProject Property
ClearContents not clearing :(
Convert Cell References in Formula to Values
List Data to Single String
Suspending MAcros
ClearContents not clearing :(
Returning actual page field changed in pivottable
returning pivottable object from a range object
interest rate when compounded daily for 5 years
Finding Values Too Slow
Stop 'Disable Macros'
Move a row to the centre of my sheet Excel 2002
Assigning a shape to cell
Simple Macro - I Think?
Need Help with a Menu Item .OnAction property
Excel97 Userform to be system modal/equivalent
Date Problem
Sloooow loop
Copying Temp List to cell
Writing a .txt file
HELP, dont know how to describe this in a subject line
How are Marco Stoaged
Bank Formula for CD that is compounded daily for five years
HELP, dont know how to describe this in a subject line
UBound not in Intellisense. References problem?
identify the name of the activecell not its address
Error on printing
Excel case
Clearing DropDown Lists & Removing External Links
Looping through text boxes
Excel case
Retrieving data
inserting a date in a form
Re: Calling subs from different workbooks
workbook_open
keeping track of a range of cells in another spreadsheet or access database
Late binding with VBIDE
OnAction procedure
web queries
Excel case
Cutting Data from cells changes Cell Formatting
VBA Security
Excel - Protection
referenced file
Inserting Picture into protected Sheet
Looping through text boxes
Looping through text boxes
saving files
Ant ideas?
Close a userform
Creating my own undo
Showing a calculated Date as a string
Please help me with this email from excel
How do I hide an Excel module or macro from other users
Sort & Subtotalling isn't working?
Extracting Data from CSV files
all chr()
MArgin in printform
Alphabatizing Combo Boxes
Macro that copies range to new sheet
setting Select (Un)Locked Cells in Worksheet Protection
Need macro to set duplex option
Looping through text boxes
Comparing Two Columns?
Ant ideas?
Can't get userinterface variant to work on mac.
UserInterfaceOnly on the Mac
How do I set up an Excel file to save automatically and give a fi.
Run time Error 1004
Re: Formatting code for a spreadsheet
Excel should calculate and display numbers properly, but doesn't.
Interdependent flow scheduling
Shapes question
Runtime error 13 type mismatch ?
CheckBox1_Click()
Runtime error 13 type mismatch ?
Runtime error 13 type mismatch ?
hr,min,sec
Range objects in a collection
VBA Help Problems
Runtime error 13 type mismatch ?
UserInterfaceOnly on the Mac
Extracting Data from CSV files
Moving Code
Football Predictions Spreadsheet formula problem
Runtime error 13 type mismatch ?
commandbuttons on worksheet move to the left
Macro or excelfunctions
Looping through text boxes
Email
Username
Copying multiline textboxes from userform to worksheet cell
remove excel-icon
Header Row 1 is displayed in split screen - Way to keep
Copy values to multiple destinations
Outlook vs Outlook Express
OnTime function
HELP, dont know how to describe this in a subject line
reading data from com port into excel spreadsheet
Email from Excel
macro help
Newbie needs help with if statement
HELP, dont know how to describe this in a subject line
Newbie needs help with if statement
Extending Named Ranges
HELP, dont know how to describe this in a subject line
Looking for a way to run a macro when the workbook is opened
Re: for next loop not working
2 things
Windows XP default path for temp file
HELP, dont know how to describe this in a subject line
using the Find method in a VBA macro
last cell on row
Assign macro to toolbar custom button?
Splitting cell contents
Supress certain 'cells in Pivot Table
Summing loop for multiple worksheets
removing duplicate rows
?Application.Evaluate("max(len(A1:X20))")
Range question
Converting Excel Formula to Macro
data feed text delimited
Tom Ogilvy or anyone that can help
Help with macro!!
Conditional Formating of cells based on value in another cell
update links (ignore previous post same title)
Link updating
VBA Excel - changing series source.
VBA Excel - changing series source.
Opening a workbook if not opened, going to it if already opened
How could it be?
Inserting Picture into protected Sheet
Excel replace text.
change event procedure
Problem with .CreateField in DAO
Checking if value is a number
Re: wait for user action in VBA code
Count of results in AutoFilter
prevent duplicate results (database query)
How maximize open excel workbook
Re: Checking if integer
ListBox selection
Checking if integer
How can I do this?
Re: Calling a procedure in a protected VBA Addin Project
Mission Impossible
Excel replace text.
need help
Dynamically setting Print Area
On error End Sub
Opening a workbook if not opened, going to it if already opened
What's Wrong?
Re: copy to another wb and name the target sheet (XL2000)
Newbie question: function call
Userform List Boxes Load Very Slowly
Summing Cells with a BLUE font (or any other color)
Error - End If Without Block
RE: Looping through Sheets
RE: Looping through Sheets
It worked!
It worked!
Programmatically detect a syntax error in a macro?
Re: column hint
Re: Trapping Insert Row
Opening a workbook if not opened, going to it if already opened
Re: sumif question 2
Re: Find Command
Excel replace text.
sorting code problems
quick question on a checkbox
sorting code problems
Filename changes daily, anyway to link to most recent file
sorting code problems
Userform data to Excel sheet.
RefreshTable vs PivotCache.Refresh
Value of a cell
XL remoting issue...
ListBox drag & drop
sumif question
Why "Worksheet_Change" dont work under DDE link?
how to delete cells without shifting and rows/columns
Find Command
RE: Why doesn't this work?
keeping rows together after query
look up
DISABLE CLOSE MSGBOX ON CLICK "X"
sorting code problems
number ZERO in a cell
Adding TextBox to UserForm via code
Moving a range to end of list
quick question on a checkbox
Macro to save as using two cell values inside worksheet
Inputbox "choose password"
Add a column to a selection
sorting code problems
Excel2003 and xlListSeparator...
Master to Report Tabs
find open workbooks
Serious Crashing Problems in Excel 2002
Delete Empty Rows
copy to another wb and name the target sheet (XL2000)
can you hide macro code??
VBA Error Message
help with rowsource
Removing item from combobox with vba
sorting code problems
VBA and FormulaArray Runtime Err <is not more than 255 Char>
carraige return within a cell & capitalization
Macro protection
Removing item from combobox with vba
Remove .xls from selected files
Data from listbox to Excel sheet
disable or hide the close window icon 'X' in the corner of a userform
Removing item from combobox with vba
Minimum route from two nodes
Can you get a Merged Cell with Text Wrap to Autofit?
copy only from a cell with data in it
Can you get a Merged Cell with Text Wrap to Autofit?
Minimum route from two nodes
Minimum route from two nodes
Disable Right click
Run code after entry
Insert a line in word from excel
Conditional Formatting adjacent cells
How to go to a predetermined sheet on opening
Userforms/Macro search
looking for autofilter with code
Email Excel File Automatically using Outlook 2000
Serious Crashing Problems in Excel 2002
row reference from selection
Looking in 1 list and copying from another lfile
IF referance multiple criteria Formula Help
open workbook
Add Menu to a VBA Form
Enter a "checkmark" in an AutoFiltered cell
Need help please
Re: VB solver
VBA help file not found.
Help! Overflow Error 6
copy only from a cell with data in it
open workbook
transfer data in listbox
To include Depot
To include Depot
data entry with userform questions
Unprotect via prompt
Word VBA Code to Excel Code
Apply Macro on Multiple Worksheets in a Workbook
validate a directory or file exits
looking for autofilter with code
Call from a Main program
prompts for the user defined functions
copy only from a cell with data in it
Check for any data changes in a form with multipage object
SUMIF
In Excel 2000 can you write VBA code to pull data from a webpage?
In Excel 2000 can you write VBA code to pull data from a webpage?
Gross Faults/Errors With Put and Get
Change from Numeric to Alpha
Scanning Text files for specific words
Call up Powerpoint using Excel 2002
find command using variables
Error with Activecell.paste
How do I get my Excel to act normal?
Need xlodbc.xla in Excel 2003
Worksheet change sub procedure
Pl help - Graphical Indicators in Excel reports
What are the cells in a Pivot Table range?
help with choosing and calculating time data
Executing sub procedure when Excel starts
Selecting Last Worksheet
help writing macro
Pivot Table from VBA or VB6 - Field Settings
Why does sort always default to include a header row. I want the.
Max worksheet exent width
Info Only: Formula Freeze Module
How do you Sum the range of two lookup values?
cell ref w/ varaibiles
Master to Report Tabs
web query
Iterating through Page Fields of a Pivot Table
how can I write ascii code in Excel?
Initiating a macro from a control button
validation date
Recommended Read-Only Property
position mouse cursor in msg box
Web page
RE: External Queries - Excel 2000
Printing PDF from Excel Error
Enter Key
xls filename with a number in brackets
Waiting for OLE action
VBA auto fill problems
Import Access records to excel (parameter is a called funct) v.20
custom menu bar doesn't work
blank rows macro question
Late Binding help, Please
select populated cells
help with code!
Choose several sheets in VBA
Data Validation Question
Templates
Collapse Dialog Box
View previous cell value programmically
Export Entire Excel Sheet with headers, footers, etc, to Word
Replace conditional formatting to use 4 conditions
View previous cell value programmically
How do I define the same name to a number of different worksheets.
Object Name
Object Name
Userforms/Macro Search
insert lines into CODEMODULE gives error
Object Name
Rotating a Table
Can't seem to create a Pivot Table with VBA ?
Apply Macro on Multiple Worksheets in a Workbook
help! code for a cell
Object Name
How do I resize a named array in Excel from a MxN array to a mxn .
Copying files from PC to PC
Date selection loop
Macro to Search and Replace
Validation
Help Please! Macro Error on Select Worksheet
Help! Animated gif-image in form does not show animation when form loaded
Help please! Animated gif does not show animation when form displa
Excel Copy/Search/Paste Help Needed ASAP!
Validation data
Wild Card Path
increase the size of a worksheet
Serious Crashing Problems in Excel 2002
Excel should let me change format of the cell when it contains for
How do I automaticaly update the current day's date each day?
copy Excel worksheets into one text file
Moving a range to end of list
viewing code
Copying meaningful data only into new worksheet - VBA
vba routine in Excel 2002 to create varying size email in Outlook
RE: OWC version control
Need help with loop to import data
Re: Master to Report Tabs
Master to Report Tabs
Need help with loop to import data
Date.
Macro's Flicker
2,560 cell limit???
Save & Install AddIn with VBA
Need some help
count the number of times a value updates in excel?
VBQ and macros executable in Pocket Excel
validate phone number
Sorting data automatically
combine two records
Save CSV File without prompting
Simple Paste Question
Deleting columns based upon the value that appears in column A
UserForm code help needed.
VB Is a workbook open
Visible Property Pivot Item
Userform to be always on top of all Applications?
Remove reference from code
PivotTables/VBA
Convert -1 and 1 formula
UserForm code help needed.
Error loading DLL
preventing use of F9 (recalculate)
If Statement based on Alpha or Numeric
Change the properties of a non selected cell?
Looking up two conditions
Pivot Table problem
VBA - Insert new sheet as the last sheet
Vlookup on named range
10% Match
Copying spreadsheet data to WORD
some final help
VBA - Insert new sheet as the last sheet
preventing use of F9 (recalculate)
simplification problem (only for expert!)
timer
Deleting columns based upon the value that appears in ROW A
Automatically Add Foorter with full filename in Excel
communication with MS Project
Activex control security message
Sorting data automatically
color index
Caption
finding a cell
UserForm code help needed.
Re: Extract a table from Crystal Reports into EXCEL
Adjacent Cell Value Theorem Help
finding a cell
Using defined names in VBA...
Using Excel softwware to draw construction mappings
VBA Help
Using a variable file name
vlookup
determine row reference from button
Sarbanes Oxley 404
RE: fill randomly cells that verify contion
Setting WEEKDAY function to Exclude Friday in Calculation
vlookup
Copy visible rows with data to new file
Ignore Blanks
Change Form Size after Click
New Workbook
getting value of range problem
Unprotect via prompt
fill cells, merge cells
fill down to next change in value
texttospeech
texttospeech
excel formulas to count and sum
Re: datalabels collection crashes Excel 2003
mismatch error in returning concatonation of numbers and characters
Incorrect code...
copy only from a cell with data in it
fill cells, merge cells
Draw Buttons
Calculate the time difference in minutes
check if item exist in olap cube
mismatch error in returning concatonation of numbers and characters
Selecting Sheet1 by index rather than sheet name
Apply Macro on Multiple Worksheets in a Workbook
looking for autofilter with code
Hide font in formula
How do you round to 0.5 in excel
Test if Sheet Exists - Tom Ogilvy
Row # of active cell
Writing strings to a text file ?
Apply Macro on Multiple Worksheets in a Workbook
Open File Read Only
Help with VBA
To their respective sheet.
VBA Code to identify contents of a cell
Re: how do you combine worksheets
automate sending graph/pivot report in body of email
how do you combine worksheets
Path to a dll as a variable
RE: Find method
RE: Why doesn't this work?
? for Ron de Bruin
Conditional Formatting
Re: Find method
Selecting a worksheet from a macro in a different workbook
RE: Find method
Why doesn't this work?
Re: Find method
Password window popping up when saving
Find method
Why doesn't this work?
RE: Run Array.. run array... (Which to use?)
DSN UserId and Password Prompt
Control Deletion of Range Names
Task Scheduler
Creating connection documents
Conditional formatting
Re: Workbooks.Open(URL)
RE: VBscript
Cell selection code
Workbooks.Open(URL)
Properties information
VBscript
blank rows macro question
Userform text box query??
OnTime problem.
OWC version control
Need Help w/ Print Macro to Print All Visible Sheets (including Charts) in a Workbook
Return MS-SQL database names to excel?
Function not visible
Re: How do I show number of hours as a negative using formula?
blank rows macro question
Re: Absolute cell references
RE: Run Array.. run array... (Which to use?)
Re: Application.Match problem
Date question over 3 years
Is it possible to update XMLMap's schema?
Re: Run Array.. run array... (Which to use?)
RE: Creating References To Excel Objects
DSN UserId and Password Prompt
Timestamp from Outlook
VBA calculate manually
Re: Auto Fill Option button
Comment créer un TreeView dans une Toolbar Excel ?
Application.Match problem
Run Array.. run array... (Which to use?)
a challange for the "real" programmers
Deactivating Insert/Delete Row/Column
fill randomly cells that verify contion
Auto Fill Option button
Workbook Open Event
macros create temp files
Error Handling driving me crazy. Please help
Creating References To Excel Objects
How Do I Make multiple Pie Charts
Trim function in VBA
Saving question
Moving a range to end of list
Display Clipboard in Excel
Need some help
Inserting 10 Rows
Error in Excel 97 when running Excel 2000 macro
Creating connection documents
distributing xl with vba code - how to know what's needed
RE: Absolute cell references
How do I show number of hours as a negative using formula?
Absolute cell references
Why this don't work
Getting a Proxy Class into VBA
How do I show number of hours as a negative using formula?
VB UserDocument on Excel sheet
Updating High/Low Values from a set of streaming data
Help in saving a formula.
How do I get rid of my form from the screen?
Multiple criteria Filesearch function
timer
Moving Columns only
UserForm code help needed.
list date in the form and vlookup
That "out of memory" error
RE: Extract a table from Crystal Reports into EXCEL
Error in Excel 97 when running Excel 2000 macro
code to convert date from TEXT format (03-02) to DATE format (200203)
copy range on every worksheet (diff names) to a master worksheet (to be created)
Error in Excel 97 when running Excel 2000 macro
Re: Exporting excel worksheet to access table
VLookup Not Picking Up Entire Phrase
Re: Userform text box query??
VBA coding
Re: AutoFill of empty cells
Userform text box query??
Multiple criteria Filesearch function
OnTime problem.
VB message
Protected cells
Subscript Out of Range
stopping an excel application from vb 6.0
copy range on every worksheet (diff names) to a master worksheet (to be created)
Error in Excel 97 when running Excel 2000 macro
AutoFill of empty cells
Add a category to the Insert-Function category list
Group Dates with Code
Re: What is the Visual Basic command to select an entire row in Excel.
Re: What is the Visual Basic command to select an entire row in Excel.
Re: What is the Visual Basic command to select an entire row in Excel.
Re: What is the Visual Basic command to select an entire row in Excel.
Re: Cannot Query MDB!
Re: What is the Visual Basic command to select an entire row in Excel.
Re: Task Scheduler
What is the Visual Basic command to select an entire row in Excel.
How to change worksheet direction
Chart properties
Conditional Formatting
Excel - using VBA
Showing built in dialogue boxes
Re: Pick Lists
looking for autofilter with code
error message
VB command in the "Control" file
RE: Pick Lists
Fine tuning if statement....
Re: insert page breaks
Pick Lists
random number generation
What are ....
Pivot table doubt
Date in Pivot table
insert page breaks
How to creating certificate for the compagny only
Control Deletion of Range Names
Numeric data being ignored
Excel 2000 - Files corrupt after saving via VBA
ActiveChart.ADD Fails
fill cells, merge cells
auto open text files
copying and renaming a worksheet
Re: debug
how to copy entire row into next row
How to copy entire row into next row by macro
RE: Print problem
Need some basic help
Deactivating Insert /Delete Row/Column
debug
macros and pivot tables... help please!
Working with Pivot Tables in VBA
Help: VBA macro for worksheet formatting
Hide font in formula
User form upon opening
Add click event with code
Draw Buttons
excel office web components
Hide font in formula
Excel 2002 closing by itself???
Opening Multiple Workbooks
How can you create a Pivot Table using vbscript
Error Handling with Nested Loops
Custom Function on Personal.xls
VBA Help File search not working
Re: calculate weekdays only
Find cell and paste data
Plotted data changes in XY Plot if first cell is in X data is blan
find a path
Simple Macro - I Think?
Nudging controls in UserForm Design Mode
image edit control
Re: calculate weekdays only
Re: Print problem
Re: Sorting with Drop-Down Menus
RE: Print problem
Building an Array
How can one test against merged cells in VB.NET?
Sorting with Drop-Down Menus
Cannot Query MDB!
Re: HOW DO I CHOOSE MULTIPLE ANSWERS FROM A VALIDATION LIST?
Re: 1st line is the header, how do I have it print as the first line
calculate weekdays only
XL2003 "paste method of worksheet class failed"
Re: calculate weekdays only
Missing Data in a Range
Re: HOW DO I CHOOSE MULTIPLE ANSWERS FROM A VALIDATION LIST?
Re: 1st line is the header, how do I have it print as the first line
HOW DO I CHOOSE MULTIPLE ANSWERS FROM A VALIDATION LIST?
1st line is the header, how do I have it print as the first line
GetSaveAs Method
Searching for keywords
Preserve formatting setting in VBA crashing Excel
Problem coding a Sort
VB error message
Cycle through a folder of excel files
calculate weekdays only
Sending e-mail - Ron, you still there?
Re: Custom Views based on sheet name
X bar chart in Excel
Comparing two lists
Custom Views based on sheet name
Check to see if sheet exists
Re: Trying To Store Shapes/Objects to an array ??
Parse Data - Bernie
Form Error & Q's
Underline font not reporting properly
Importing data
export/import excel data to word doc. properties
Re: Excel Freezes
Trying To Store Shapes/Objects to an array ??
Print problem
e-mail links follow up T.Ogivly
Variabel and caption in userform
RE: Variabel and caption in userform
VBA deleting Macro
Need to make this simpler.
Re: Variabel and caption in userform
Macro help
Variabel and caption in userform
e-mail links
Task Scheduler
RE: Exponential Growth
RE: Exponential Growth
de-select range in other workbook?
Re: =Why AddIns.Installed can be out of range=
CSV Excel 2000
RE: Code instead of foumula.
RE: Please help me with this error
Enter simulation-related HLOOKUP formula in cells
Re: How do you sum values in a coloumn when it contains #N/A in a ran.
Please help me with this error
Re: Can I use ISERROR with VLOOKUP function?
Re: Update SQL db directly from Excel
=Why AddIns.Installed can be out of range=
How do you sum values in a coloumn when it contains #N/A in a ran.