Excel Programming [Archive] - Page 158

Find Last Row Hidden
templatae wizard
Help with figuring out last date
advanced filtering
DataType Conversion
Excel close/save/prompt problem
Making combobox listing containing values larger
worksheet change tracking...
How to open a Word or HTML document using VBA code in Excel
add rows to data based on situation
List comparison and update of values
Linking data across worksheets???
Change text in legend
SendKeys, Windows Active screen Question..Pls Help!!!
Conditional Sum Tool
More games than work
Using the Sum Function in VBA
Textbox Enabled but not where you can type in it
Notation on Revision of Projects
Input Boxes
Adding commandbutton at run time
Pixels values
Auto Sequecing in New Work Sheet
Cut & paste editing problem.
Merge two pieces of code into one
Checking a cell for a specific color in Excel VBA
Message box at file open
Re: Select & step
Re: Add a Column Macro
"Unload" selection after running macro?
Re: counting cells in a column based on thier color
Write VBA code into a sheet module using VBA
Visual Basic Code in Excel
Relating Worksheet(I).Name with VBComponent(J).Name
Excel within the body of an email
Import text file without specifying a path macro won't work
CommandBarComboBox.AddItem - String Length Limit?
Displaying Unique Values in a Combobox
convert word files to excel file
Error 49: Bad .dll Calling Convention
bloomberg API
custom functions
Workbooks.Open(filename) : Returning err: Object reference not... (in VB.NET)
unExcelling Excel... well almost...a twist!
Save a file with Protected Macro
copy a sheet
VLOOKUP and IF
InputBox and Password
Need some help with enclosed script
vba question.. matching in columns
ClearOutLine Method
Excel VBA - Error handling problem
Excel charts on the fly with ASP
not for the newbies...
Duplicating rows and changing cells
why!?
Command Button Function - Macro
Checking to see if a Range Object exists?
PivotChart formatting: macro for multiple unique charts
How to find and sub total a specific number of cell above the target cell
How does the ActiveChart.Location() work
Brain teaser
VBA Code works in 2000 not 97
Excel VBA - Range value of the Clipboard
Duplicate Object Name Lockup
Count Down Timer in 1 sec. increments
SHEETS
Parse formula
Hyperlinks to Excel File from Website
Trying to save as tab delimited
key board short cut for validation list pulldown.
RE: Error causes Excel to shut down
Printing code
Macro to re-calcluate and count times run
Re: Using MS Newsgroups
Re: Copy Sheet w/o VBA code
AsktoUpdateLinks Property
Macro, autofill formula to end of column
Excel Format documentation
Missing References
sorting dates by month
Re: Working Days
Combine 2 macros
comparing 2 sheets
Re: OpenDatabase-Problem
the retun button
Re: Changing a macro to save as Unicode text
Offsetting from the Reference of a Cell, not the cell
Reading all files in a folder
Re: Standard Deviation with a macro tool
How to capture row number
date stamp
refresh a cell automaticaly each second ?
Calculation problem in pivottable
number and text format
Creating and using a config file
Unknown Formula
closing excel after 5 mins idle
Word.Document - user defined type not defined
Unique numbers in a range
Run-time error '91' on Cells.Find()
TextBox
"minimize" button for userforms
How can I do this? Please help
Convert Text to Formula
looping through text boxes
saving/creating a directory
How to Clear value a listbox!
Graph As Status Bar
refrence in vlookup
How to add an argument to every cell in a range containing same type formula??
startup macro on condition of filename
RowSource Problem
Open Another Workbook and Call Macro
Please, any help with a problem finding vba code
how to add formula to this macro???
reading cell contents in a macro
passing text box stiing into variable
Question about releasing memory
save clipboard as wmf
Run time combobox control in excel
Comparing data in Excel with VBA
Can a function returning a date return an empty value?
$ in front of text in a textbox
Drop Down Menu (non Data Validation type)
Assign Chart Title w/ VBA
Copy and Paste a Worksheet Range to Email Body
Add cells if values are the same in multiple columns
Todd Huttenstine
Sending email via VB - address length
Can MsgBox Do This??
Sending email via macro- setting the importance setting.
$ format in cell
Date to nothing
all macros into one..
Problem occurs when upgrading Excel from 97 to 2002
password protect on workbook problem
Whoa horsie Slow down
Disable recalulcation upon open
Excluding numbers
relative cell references in vba macro
Group Controls
Excel 2003 macro names
How to access a called sub program to edit?
calling VBA functions from a cell
Conditional Formating
password protect on workbook
Help in Excel VBA
how to run a macro only if a cell contains a certain value
CopyFile usage
Show data with line's like a IP-network
Newbie - cell contents B4 change event ?
SetFocus Problem
dde link update in vba macro
Combo box formula - how do i include it ?
Syntax error on codes
Delete rows that DO NOT contain certain text
Web Query
Contional Row Delete on Interior Color
Protected sheets
Inserting Page Breaks every 40 lines...
Data from One Worksheet split into Multiple Worksheets
Combobox array
Macro to combine several worksheet formulas
How do I copy and paste ranges from VB 6.0 in an Excel spreadsheet?
DDE Links...
Refer to a column
Data Refresh Issues...
Lotus 1-2-3 {Windowsoff}
Auto remove specfic excell attachment from email ?
Syntax error on codes
Date and string help
EnableancelKey=xlErrorHandler not working in UserForm
PasteSpecial takes too long
Adding Range to List
Date re-format
Pinpoint pixel
Copy a Macro
Howto Improve speed?
How do I not "SAVE a WORKBOOK"
How to have a userform displayed and be able to work in a different spreadsheet
Excel 97 Send To
VBA project unviewable in office 97
Copying sheets
Moving relative
What is the decimal value of xlDataValidation constant
Macro assigned to custom button - keeps changing
If Function
How do I Launch a Macro on a different sheet
shell out of excel into another app
Borders - non-contiguous ranges
To have an entire row highlighted to some color if any cell in that row is selec
Running a macro from a hyperlink
Exit a macro from an error condition
Conditional Formatting a Button
Problem with updating of texts
Renaming FORM button
Adding image with code
My last week question: how delete the Office Clipboard (XP)
Troubles opening a CSV file from code
pivot's table problem
Problem activating a sheet
How to check if the directory exists?
Worksheet_Change - loop within a loop
Macro running before all others
Regional settings problem with TEXT(value,fmt) function
An easy one!
Text to Form Textbox and back
Help - Selecting and pasting into range
Chart Questions
excel add-in called Vision XL
Invisible linked workbook?
VBA newbie - can i search the spreadsheet based on the active cell?
Breaking text on the basis of condition
VBA AVERAGE/IF condition
Delete Text Box
single dimension array
Directories
Date Match Input Macro
TO TOM OR KEN: macro to calculate selected range
HELP - lost post
Run-time error 6 Overflow
Macro in Excel
convert Works 3.0 database spreadsheet into excel 97
Selecting or Entering a Textbox
Need Help Modifying Code
Question to Chip Pearson
Comparing 2 Lists
Question about references
Dynamic Web Queries
SUB ROUTINE
input form
Call a Web Service ???
Macro to find an occurrence and create blanks rows
Gathering info from saved files
Disabling Menu Options
Colors in a diagram
Populating ComboBox Methods
Copy to a specific row
Macro to search a column for a specific word and replace with
Date format
UserForm as Progress Indicator
UserForm Checkboxes
Populating Combobox Methods
cursor position
Drop down list
Very New in Excel Programming
Macro to find row and delete it
VBA won't recognize form object
On Error function
Multipage Error Handling
Trapping Workbook OPEN errors
Find display the result
remove all blank or empty rows
Macros with shared workbooks
Combine all text file in directory into one file.
Copy Value in Excel
Using Char() in Macro
When a value is changed manually or dynamically in a cell, how can I tell?
Excel Closing Problem
Unique generated alphanumeric number
Search In Sheet using macro
Setting a value from a formula
setting a formula in cell on a totals sheet using VB
Referring to a worksheet using variable
Activating a listbox in a dialogsheet
Activate sheet event
Preventing partial row deletions to avoid row data shifts
time specific data
time specific date input
printiing range
Macro print range
Paste formula into selection
Vlookup and text
formula does not work in macro
Problem with VBA help
Loping through files in a folder
Question about disabling message boxes if possible
checkboxes on userforms
Worksheets hidden
Can't Unhide Rows
Password protection
Change text color
Help with Excel and MS Sql Server
Median Function - Compatible with Subtotals?
Cell Event Handler
Copy/Paste to file of same name
One Record Only
Problem with EventClass
Limiting number of instances of a workbook
Code to return the data a chart is based on
Printing sheets with populated fields
Duplicating data from sheet 1 to 2,3,4 etc
Creating Command button Conditionally
Setting VBA passwords from within code
vblookup newbie question
Combine Sheets From Different Workbooks
Question about comparing mixed case string values
how do I link Textboxes in a userform to a Cell in a Worksheet?
Parsing Data
Userforms
Make counter invisible
Lock/Unlock problem
Type Mismatch error
list box record select
VLOOKUP Problem
Excel .xls files
Range Names associated with Sheet Name
macro to sub total a unique cell value
Dropping a UserForm
Delete new sheets?
New to vba trying to assign # to strings
Excel file inflation
How can I select all Controls in a wooksheets
Shown Drop-down list if login user=C
Subdividing 1 grouping of data into 6
code code
Sharing data on a worksheet over the internet?
Replacing One Sheet in Several Files
schedule help
Saving an external file without making it active
TO ROB and anyone=IF(LOWER(A1)="john",B1,"")
Outlook Automation, Deleting Tasks
Follow up question for Tom Ogilvy - re: linking a text box to an external workbook
Capturing Sheet Events
How do I read a date from another page
User Form Question
COleSafeArray
custom round function
C C+ Excel Coding
protect only part of a worksheet
forget file password
User Forms
Using Application.Run in VBA
reconising matching no's in 2 seperate lists
Blanked Password enter
Excel VBA - Pivot table - Hide calc items when shows 0
AutoExec - Enable Macros
VBA Macro to "paste special"
Worksheet_Change sub causes funny results
When DIM statements don't work
Run macro at specified time
Help sending active sheet to email list
update links when copying files
Sending Excel Form to Exchange Folder
Sending Excel form to Exchange Folder
Need to identify object selected.
Linking a table in Access to a table in Excel using MS Query
Dynamic text in Mail Merge - any idea?
Dynamically adding an in-cell drop-down list (i.e. Validation Object) to a cell?
comparing or matching corresponding value
Create Paste Values Button
VBA programming guru needed - HELP!
PivotChart formatting: macro for multiple unique charts
see if dynamic array used
Trouble Opening Workbook
Trouble Opening Workbook
Coding Format and Organization - VBA in Excel
Formula help needed please
automatic counter or auto-increment
Find out Operating System
VBA - Reading the file name and path from cells
Add Icon to Toolbar
open file dialog-select file-import worksheet
Modeless Wait ?
Exporting data to text
Help Crafting an Inventory Spreadsheet
write records to another worksheet based on criteria
Code to run an Access query from Excel
What variable controls wheatehr a cell is visible?
Date Specific Input
Nested if /and formula
Call macro from active workbook-duplicate shortcut keys
Macro
"Reference is not valid" error when using analysis toolpak in an add-in
Problem w/.EnableCancelKey = xlErrorHandler
Compare checkbox with cell value
How do I combine these two?
Custom toolbar in C#
Using for loop in a macro
Problem with Worksheet_Change event
How to find a specific inform with some cells and return total
Another question..
limit textbox to numbers or spaces?
Excel Macro for VLookup Function
PLEASE HELP!!!
Continued Cell Formulas Across an ODBC
help with a billing sheet
Sheet copying not working
how to import data from text file which has more 70k rows ?
Q: Declaring a dynamic array
Solver code does not save results to sheet - What am I missing?!
Re: Link to ACT! customer database system
Which routine called Sub()?
Excel 2002 CDO Email Problem
Setting timeout for Web queries
Identifying cell types in column using .SpecialCells(xlConstants, xlNumbers)
Print enveloppes' address from Excel
Closing Excel Object
Mailing from Excel and message question
Need help in excel with "Statement invalid outside Type block. " error
MS Month View Control for use in XL Userform
Extract image from toolbar button
Converting VB arrays to IXRangeEnum
Help Tom Ogilvy
Set background color of a cell in VBA
UDF Question
return value from a fucntion
Connecting to a DB in VBA
Not allowing an Excel Worksheet to be opened in Word
Select blank cell
Out of Memory error
Help with Document Not Saved message
One line of code messed up!
Waiting for a valid input
IF Command to Stop Macro
Copy a file in VBA
Moving a variable number of Sheets to another Workbook
Fill Down Blank Cells From Imported Reports
Open Workbook
cursor or mouse move
2nd Conditional Formatting?
Conditonal Formatting VB Code?
VBA autofilter bug??
Error msg "Microsoft Excel is waiting for another application to complete an OLE action"
Excel Crash - page fault module
Input Box error when scrolling
How can i autofill cells
Copying Sheets
Combobox - add manual entry to future list
autofit rowheight after auto change line
question about - excel macro copy chart to word document
Copy generates an automation error.
John, Bob, Chip...
How can I...
Preventing linked cells from updating
Can macros alter locked cells in excel?
List files in A1 Cell Downwards??
Store variables between XLA sessions
Find a Min positive value
Referencing labels dynamically.
Activate first blank cell
Excel doesn't find DLL under XP
Disabling Commands
How can I name the Module or class after I insert it into the Excel
Open Copy Close
How can I share my function with others user easily
how can a user form be made that can find show and edit info for inventory
ex - list box display sheets
Finding the last entered value in a column
Referring to a user-selected range
"Mouse Wheel Trouble in Excel VBA"
Linking a text box to an external Excel workbook
Never show User Defined Function Qualifier
ACCESS TABLE EXISTS-ADO
How to tell Who Opened Excel File.
Put subtotals in a different column
Extractind data from external database
Question on Removal of Column Filtering Upon Closing of Spreadsheet
SetZoom in PageSetup
Unicode string parsing? Please help!
Excel VBA extracting data
Automatic Vlookups in Forms
insert data into macro code from text input field?
help on insert rows and fill down loop until end
Excel Object Documentation
Spreadsheet component in an ActiveX dll
Referencing password protected worksheets
Grades
Use Office spreadsheet component in a ActiveX dll
Array multiplication in VBA
workbook issue
Not Enough System Resources To Display Completly
Layering and staggering UserForms
Import several txt files into separate sheets within 1 workbook
Silly I know
I Need Help with my loop macro
Updating sheet
Toolbar lives on
Sheet Name Confusion
Public subroutine called from a private sub
if_worksheet function help please
Importing Multiple files nearly there
How to change the first letter in Capital letter
VB6.0 and Excel
hex3dec
help with a formula please
New spin on old problems
Difficult Sorting Equation
Need to identify the start and end of range
File list macro
Can I disable autocorrect from within a macro?
Auto_Open only on initial file open
PLEASE stop Excel version popup!!
Histogram and macros
Sub Routine Names As Variables
Opening multiple workbooks
Combo box
Importing multiple text files into single workbook
rounddowns
TextBox Focus
Multiple txt files import
Routing Slip - Prompts Yes, No, Cancel
Creating an ID number
counting and some what
I need smaller code.
Closing ReadOnly file using VBA
Identify Document Being opened from an Add-In using Auto_Open?
COM Add-in ?
Alerts
Linked files not updating
Links Break in Protected Sheets when going thru email
Data validation on print - need code
Copy from one to another
Text Font Selection Inside Combo Box
Problems With Paste
API Timer Function Issue
Newbie
SAVING
Need help with adding a button to sheet
Error Loading DLL
Slow formula's
Excel VBA issue
Event Raised by Paste Special + Link
Down one cell at a time
Re: How to covert to text files
executeble file
VBA Coding problem -text boxes (more)
Automatic Macro
Identify an Word/Excel file without the doc/xls extension
Identify an Word/Excel file without the doc/xls extension
Identify an Word/Excel file without the doc/xls extension
Extract Informations inside a Borderframe
Identify an Word/Excel file without the doc/xls extension
Where do I find my digital CERTIFICATE
Quit Method do not kill excel process
Quit Method do not kill excel process
Where do I find my digital signature
Conditional Copy From One Sheet To Another
Adding Worksheets
Macro not starting
PasteFace-Problem
Can't insert any controls on an unprotected worksheet
Displaying OLE Objects retrieved from MS Access
Re: Validation/Macros
Re: Validation/Macros
Re: Validation/Macros
hiding #N/A
Resizing of Userforms
Excel fails me - upgrade to database?
VBA to add group divider to custom menu
Linked Templates in Excel 2000
data base
slow save time
How find all formulas on tab?
Keep Object with Focus on Display Screen
How To: VBA Cells.Find(..... also look in hidden columns?
Using VBA to update Chart Sheet formats and axis titles
Dos commands from excel
Excel don't load macros from add-in
Solver
Select Range as far as.....
worksheet_SelectionChange Event
Loop Statment help!
Loop for changing cell formatting
Username's almost there!
XlPrevious Translation Code
Characters in a cell
how to completely remove an add-in?
Add-on to last request
Break Mode query
Error stepping through Autofiltered visible range
How delete the cliboard
Saving a spreadsheet without any VBA
Automatically enter Password in Macro
UserForm_Initialize
Excel macro for delete a clipboard container
Saving and copying results
VBA Coding problem -text boxes
Continuously accessible form
API TIMER
run macro from custom menu
which FormField called a macro?
Looping through the F2 command
Email from Excel
Closing a workbook
Highlight/Select contents of object with focus
Multiple worksheets search
Re: Access from Excel using ADO
Scroll Combobox with MouseWheel
Conditional Formatting
Removing a Btn macro
Select and Delete Columns
Select PivotTable Page Problem
Can i setup cells to only accept caps
Username The Sequel
Selecting a Printer in VBA
protecting cells against cut and paste
Counting in a range
EXCEL OR ACCESS
VBA+Doing MailMerge with Excel (Off97)
Dynamic update of UserForm TextBox
Update the row when type at a cell
Showing Values on Charts
Directory Programming
excel executes only a part of a macro
Linking a text box to an external workbook
Copy and Paste - Last Row
Macro to Keep Linked Workbooks Updated
check for valid file
how to overwrite a write reserved file?
Default printer
selecting sheets in vb
How to set equivalent of Visual Basic "redraw = false"
return value from MATCH
Making cells change color after a specified period of time.
verifing entry is numeric
Making cells change color after a specified period of time.
Count each group of values
testq
detect last row of data
Re: Save Method
Filtering ComboBox
Disabling the CONTROL + BREAK shortcut key function - HAVING PROBLEM - MY CODE DOES NOT WORK
Excel spin button
Double-byte challenges. Please help!
Access Automation to Excel
Count duplicates needed
Unhook (then rehook) workbook events???
Grouping Sheets in VBA
VBA ??: ctrl-arrow shortcut
counting conditional numbers
How do I limit the rows returned into Excel from a query
Date time conversion
Displaying part of a sheet on a user form
return the next row
Value of ComboBox on Custom CommandBar
Macro Help
import mail messages in excel
can't find error in macro logic...
How to pull specific data from HTML?
How do I select this range using code....another try at it.
Resetting the Active Printer
macro to move cursor
removing a Worksheet - memory leak (?)
validation command
Macro to access Lotus Notes witih attachment -
get for loop to go on after blank cell?
worksheet function in VBA
API Timer Problem
Excel query in a macro
XLA problems
Call Excel Print Function, But Not Through a Macro
Trying to create VBA script to run Report Manager function.
Button taking over sheet
VBA Reference Book?
Can you use code to Send excel spreadsheets via Lotus Notes??
Sort Listbox Items
Narrow the range a Sumif references
dso framer replacement
Copy text files into multiple sheets of 1 workbook
Adding ToolTip to a button
Worksheet Calculate Event
VBA Coding problem -text boxes
Extracting whole word from cell
Font Sizes
transfering info from one sheet to another based on info being transferred
Kill statement problems
Re-Calc
How can I test when any worksheet within a workbook is selected
Bar placement
Excel Comments
running a Database Query
Extract number from name of cell
Launching a website from Excel
Quick VB Help
Running time VBA Excel 2003
Accessing Word from Excel
Select sheet
capturing a cell value at a specific time of day
Font errors when performing multiple web queries
Any known Add-In to find/replace......
Pivot table
Select sheet based on cell value
Now problem with autofilter
RE: NEED HELP WITH LOOP !
copying range column widths
PROB: Grouping Shapes With An Array Loop
Copy select sheets to another Workbook
Mailing Excel workbooks that are not active workbook
Searching a text and filling a cell with the result
How do I select this range using code?
vba signatures being discarded
Insert a Range name
spell check a textbox
Run Query, then Protect Spreadsheet
checkbox identification
Command Button Password
Explanation of code
Creating an action button
Converting a Text file to Excel
checking a web service
backwards find function to find character in a string of text
Assign the content of a cell from excel to a variabele
Link to ACT! customer database system
Reduce file size
Placing "DRAFT" just on Certain Sheets
Can comment indicators be counted?
ROUNDDOWN function reference
FUNCTIONS
Bmp vs Gif in Userform image controls
Check Box Code Does Not Work
API Timer
Auto updates of textbox
xlSheetVeryhidden - still option to copy if you know the name of the sheet!
Sheets Back Up
Problem with autofilter in VBA
VBA Autoselect problem
Back Up selected sheets
Conditional Row Colours
Check on the input in an inputbox
excel VBA save file
Distinct Count in Excel Pivot Table
Sorting changing a table searching
Inserting a combobox
Importing Data - overriding auto format
Redundant Macro warning or hidden macro?
Date Error
search question
Sorting
How do I tabulate between textbox controls in EXCEL?
Modeless but waiting form
Loop with two workbooks
formulas
Would like to apply the code to protect cell
file attributes via macro
Vlookup - finding more than one matching criteria
WS function
Complicated Time Formula
VBA Newbie, Positioning according to R1C1 format
hot copy
How to get desired format in textbox linked to a cell
Zip Files
Select File Copy/Paste Macro Help....
unable to close macro using auto_close or application.quit
Set Print Area
Set Print Area
macro to close excel application other than application.quit
Active sheet?
SPREADSHEET FORMULA VIEW
Browse Save As Feature
Help File
AutoFit
Using Excel Add-in functions
help in codeing
Any way to "Save As" without setting the archive bit on original file
Check Box Code
protect sheet macro - can't have it enter password
Column Number/Letter Substitute
Complie Error
Compile error
select column cell in same row as loop result?
Data tracking import to Access with more than 25 tables
Cell format
simple question, hopefully a simple answer!
RE: Checkbox Code
Selecting a cell range
Newbie question about web page
add a range of items to a combobox
NEED HELP WITH LOOP !
precision calculation
Run-time error '9"
Userforms Positioning
Log On Screen / Form
Excel Driven Access Queries
FillDown from unknown column
Adding an Array
show the current year
Help 'splain unusual behavior in simple procedure
UserForm Activation
Control toolbox toolbar
Hiding/Protecting the code of macro
Formula with multiple conditions
Excel 2002 workbooks for Excel 2000
Help with find then copy macro
Using a Loop Statement to Pass Data between WKS and Output File
Automated Year-to-Date Comparisons
OR
Euro Converstion
SIMPLE DATE FORMULA !
Macro to save file and print document
Hiding Rows with Formulas
How to pars non-ascii (e.g Korean) strings?
Problem running macros in Office/Excel 97
Removing a module with code
error trying to create excel macro
Questions with 2 workbooks
Coding in VLOOKUP function
Varible in a Range
Unable to set the PrintQuality property of the PageSetup class.
Access from Excel using ADO
Get SQL data to Excel without ODBC
how to extract text from a TextBox
Opening Access from Excel
Template Wizard and Data Tracking in Excel 2003
Print Area propery
Formula
Recalulate on format change...
Save file to Network Drive and prompt for name
code to check for project references in VBA
Fetching VBA "Source Code"
Controlling VBA
Help with moving cells of info around.
Excel 2000 VBA Sort without Select
Parsing data in cell ranges
Macro-eating monster
Using the API Timer Functions
odd question
cell.value ???
search
scientific notation to text formatting question
Call Function From Different Workbook
Printing Text to Printer
textbox query
Custom comments?
Formatting cell and doing date arithmetic
Is it possible to call a UserForm multiple times?
batch file
Unable to Assign Data To A Cell
xla/xls help needed!
Save xla as xls?
backup
stretching cells
Automatically fill a cell with predetermined
Populating a Temporary Array
Macro for recalculating
Auto update...
Create Copy of Current Worksheet
Sort By Date and Save
Excel VBA error on protected worksheet
API Timer
Exporting Data from Excel
Loop for checkboxes
Comparing three columns in 2 sheets
Saving an Excel worksheet without getting the confirmation box
On Exit Command
Count number of manual and automatic vertical page breaks - examples
bar vs. line chart
Gathering data
BeforeSave Sub
Advanced Filter does not work in this one
Clear the content of a worksheet using VBA
Setting ScrollArea in Auto_Open()
Dashboard Display
Need function for checkbox in loop
VBA Error
Addition of rows in table with loop
Maybe a repost----Creating Summary
grafic symbol in cells
Apply a macro to a pre-selected range of cells
Create directory
Function doesn't calculate
WorkSheetFunction.CountIf & WorkSheetFunction.SumIf with 2 conditions?
How to open large HTML FILES IN EXCEL In quick Time
How to open large HTML FILES IN EXCEL In quick Time
Asking for a group of cells
Help with VBA syntax
capturing a cell value at a specific time of day
Excel - Time in Minutes between dates
Macro speeds in 95 vs 98 vs 2000
What is "Cancel=True"?
boolean to integer
Number formats in CSV files
Dynamic Pivot
Who can tell me how to programmatically insert an image into Excel by C#?
Loop - for each sheet not working?
Assigning New Name For Each Cell That Matches Criteria
Vlookup in user defined function
Pop-up Error Messages
Linking Headers & Footers
Dynamic Pivot
data sort macro
Error querying for open VBprojects in XP?
Query for data in an array
change a xla macro for a new version in XP
Workbook backup before opening?
prevent duplicate in Data Validation
auto pick date & time as i enter name help me
Problem with TextBox & ControlSource - Please Help
ProgressBar Out of Sync
VBA function returning multiple values?
macro question
too many external links give "Not Enough Memory" error
Sort and Save File by Date
Append to Comment
sort 2 columns with "large"
Graphing functions
Function "User()" to provide access to workbook
Multiple lines in MsgBox
Removable drives
find a string inside another string
MACRO TO SUM DATA!
Newbie Needs some help
Please help me to solve auto-scan of worksheet
Output to Notepad
Search and Replace columns using Case?
Tracking Document Usage
Run macro after data changes
macro to determine colour of text in rows
Sheet Tabs
Excel VBA loop until eof
Mapping a drive through a macro
Conection with AutoCAD
Excel Find All
Passing array of strings from DLL function to VBA
Unique adding of cell from .csv to .xsl????anyone?
Cells.find
link formula
Excel VBA - Import Data for manipulation from multiple text files
File's last modified date
Re: Use cell in calculation only if offset cell contains data
Adding arrays
Re: ScrollArea Property Won't Save
Use cell in calculation only if offset cell contains data
Excel/Outlook
Can't Dim As DataObject??
Offset in User Defined Function
AutoFilter /specialcells
Set new row height based on current height
Pause during a Macro
Excel Error Handling
Triggering Macro Execution
Turn on Comment Indicator Only
emty excel frame
How does one add text or icon to bottom of Excel Window
focus on commandbarPopup
Emailing with a message
Excel automation in a VB app
De-Activating the menu option, Window - Unfreeze
Double Quotes
Double Quotes
Creating an array
Before Save Requirement
Strange date formatting problem
Creating a table in Word
Control ToolBox ListBox Irratic
? ABTAIN FILE ATTRIBUTES WITH MACRO
Re: Help creating mimic input box
WorksheetFunction.CountIf & Worksheet.SumIf with 2 conditions?
Userform
Combobox to cell navigation
Disable Excel's Auto Formatting
Importing text columns in csv file
How to find the clip art file name
retrieve data from from a variable wrkbook
slow file to open
General Question
Select Case for Conditional Formatting
Remove a command bar
Asking for Help
Use Windows Script to run Windows Explorer Search?
Pausing a macro to select a cell
passing strijng with double quotes
WinAPI Functions
Use Word VBA string in Excel macro?
"Static" Methods in Class Modules
VB to register an Active - X control
sorting
.NET or VBA Course
ChangeLink
Removing an addin from the addin's list dialog
auto filter question
Matching headers and inserting values from a table
En Dis drop down menu.....
can't get vba to change shading when protected
FTP site
Control Toolbox ListBox Properties Blank
editing a subroutine
Unable to Assign Value To Cell
Returning an Array as part of creating a cell formula
Footprint size
Identify User Selected Range
Re: VBA code to finish this form, Thanks
Select current region less one column
Date Range Selection the ODBC connection to database
Cell data required upon close
calliing seriescollection by name
Can I do graphic manipulation with VBA?
Question about an event
Print Macro
Launch form from Array
Macro tool for solver
VBA Own Function
how to detect if user has a dialogbox open
Checking data with a loop
Confirming existence of dependents
Display MsgBox thru automation
Using VBA to Write VBA code
Viewing worksheets/workbooks
Copy formula in active cell