Excel Programming [Archive] - Page 168

Re Post: Use the Same UserForm for several action..
Selecting data to move to new worksheet
Creating a Pick list
Re: Delete all cells with a "x" in them
Format fonts on sheet automatically
Best way to search/filter a column?
select visible cells when printing
Excel developers mindset
reverse text
Footer
loading a template from the network on toolbar
Speed-up macro
Macro to filter on today's date
clear clipboard after Add-ins Toolbar creation
probleme autorisation d'acces sur Sage 100 gestion
Excel 2000 crashes after "touching" a userform with the mouse and closing it
Printing Consecutive Numbers
getting the value into a cell instead of the formula..
Use of MODE Function -- Not Working
RE: Recalculate in a macro
Re: How to Quit an Excel process?
Need help autopopulating next new record with previous record data
Permission Denied
copy current cells to the right
How to hide rows
Inserting a File Name into Worksheet Ranges
How to protect single cell or cells range from being over-written?
Uploading data from .xls to .mdb (and not from .mdb to .xls)
disabling Auto_Open macros
emailing recipients from a list in Excel
Re: rng(1,1) syntax doesn't work for set rng = arange.columns(1)
Inconsistant Macro Behoviour
Strange Occurrence
2nd request
finding/highlighting empty cells
Re: Mergeing two Arrays
Macro trouble finding 'empty' cells
when IF equals multiple values??
Multiple Workbook Links
ComboBoxes and Formulas
ActiveCell to top left cell of a sheet
Long-winded code
Unloading an Add-In
Vlookup multiple results in one field???
question about =IF()
Concatanate variable name
how to select two separate ranges into range object
Multiple colours in a Textbox on a Form.
Can't get connection string right
Creating a list box in a user form
How to program to resolve the following problem. ..thx
Re: Pause macro
Re: Recalculate in a macro
Maintaining a simple database
Conditioning Formatting Based On Due And Overdue Dates
Re: Pop Up box
Re: rng(1,1) syntax doesn't work for set rng = arange.columns(1)
extract info from XP File System
Custom Character or re-defining a character
Re: How can I delete the end of line (result of shift-enter)
ClearClipboard? Does a method like this exit?
Re: rng(1,1) syntax doesn't work for set rng = arange.columns(1)
Message no longer available
Lookup and match against separate workbook
Excel 2000 - VBA and fiscal periods
ANSI codes
Chart in Excel XP doesn't refresh
Searching for neg. #'s on different sheets
How to compact an Excel file with VBA
Re: using sendkey to enter vbe password in Excel 2000
declare type and value on one line?
1004 App - defined or object-defined error
Code to enter formula w/ relative row ref?
Excel VBA forms on Intranet
changing 4 digits into 2 digit year
AutoFiltering for Top10
Write to Array from other closed Excel file
Messages not available
Excel Front End , SqlServer Backend in the web
query 2 dbf files with vba
updating a table in html
Can't change in-cell dropdown property of cell...
Adding and deleting Range Names
Re: Select
Listbox Sum Procedure
Finding the elements of the sum
VBA returning a cell address
access-excel
Problem running macro from add-in (xla-file) in a shared workbook.
Avoiding Overwrite Confirmation
Select
Enable macros.....
cell information
Macro to filter on today's date
Use same UserForm
macro to copy and paste cells
Counting rows
Macro to execute on WEB Query Refresh
Lingual solution?
Change end of month to 24th
Screen flickering when updating textboxes
Track Changes Collection - Does it exist?
Transfering data from form to database
Cell selection with hidden rows
access linking
subString function in Excel(Urgent)
Using Nothing and Null
Honor Roll Help
Excel Versions, File Formats, VBA ... and your job.
Disabling popup boxes
Spreadsheet size
Formula recalculation speed
VBA loop cells
Solver via VBA on protected sheet problem
is object chart?
Add-in windows 98
Show data of another datasheet BY colours
Using Nothing and Null
Pivot table conditional formatting
Code to get hyperlinks from open web page.
Adding cells in a range based on format color
Lock / Unlock Cell
Determinging the Format of a cell
Sort and delete for a random sample?
Serach and Replace across multiple files
Writing from Excel to Access DB
Re: Convert a string to an array
an easy question (to some of you, but not to me) on named ranges
Re: Excel 2000 Vs Excel 2002 - Compile Error
Sort names into another worksheet by a property
Re: Mergeing two Arrays
Pop up message control using macros
Re: Mergeing two Arrays
Re: How can you wait for the SHELL command to terminate ?
Saving a WK1 file as a .CSV (or something)
crash when exit excel 97
opening and running macros in an Excel file in a new instance of Excel
program a function key
Negative dates or times are displayed as ####
Need template source path
SaveAs method fails when saving to FTP site.
Calling macros in another spreadsheet
Problem with Pivot Table and Dates
Basic Question of Excel
opening an excel file in works
linked cells
Re: linked cells
Extract Workbook name from pathname ?
Re: 2 questions again
Upload Excel data into online database
Automating excel file update
Rounding Again
how do you select the "last" sheet (created) in a workbook
reading an arbitrary selection into a 1D array
Macro Help
Aborting Excel Exit
Excel Formulas and Functions
Sheet_activate event (to another Sheet and back again.....)
OLE Page Setup Question
Re: Ranking Grades
variable that keeps its value until reset
Code won't work?
Re: create a source table from a special pasted value dynamic crossed table
Re: Dynamic TextBox ActiveX events
Files
Unset shape checkboxes with VBA
Re: determining if Now() is within Daylight savings time
Re: Entering Sum formula into a cell
can one write one's own Excel Function?
return a value from VB to a spreadsheet
macros to archive outdated rows
Macro won't work today?!?
write a line from Excel to a text file
Comment Default Font Size
can someone explain what the below macro does
Testing cell values...
Better way to write this VBA
Macro execution linked to cell entry
Documentation for VBProject
unhide sheet using macro
Rounding in functions
Lost in addin hell
Re: Deleting lines really deletes lines!
Re: referencing external workbook using variables
Multipage on userforms
File size is increasing
Manual Calculation Problem
Using Visual Basic form to enter data
Re: User forms in VBA
Re: splitting filename with VBA?
Re: MsgBox Question
Application Error - The Instruction at "0x77fcb5bf"...
value of option button
writing its own function
Filter Module
Data Processing
periods of time in excel
Excel funtion to create a unique list of entries ?
Re: Convert a string to an array
Re: Growing CF Problem
Newbie : Comparing two spreadsheets
Re: 2 questions again
Re: Printing
2 questions again
2 questions
multiplication macro
Re: Entering Sum formula into a cell
Are multiple filesearch objects allowed?
Re: Month -End Formula in VB
if statement
Conditional Row Select and Delete
Re: Entering Sum formula into a cell
Populating a worksheet
Filtering on Color
Obtain full path to a directory
Condititional Formatting Range Address
Macro to run
Automation Excel & Access
Use a UserForm to preview data
Importing ODBC Data .. anywhere??
Run macro from IF function
HELP delete duplicate rows.
Calling functions from dll
adding worksheet with spcific name
Generating File Names
Modeless userform
Vba code to print all sheets ?
Crash on every 2nd run
Crash on every 2nd run
VB Script to Hide Command Button if Bitmap is True
Warning -- Do NOT open any newsgroup postings with attachments...
NOW & Time Zone Differences
Do module name changeable?
what's wrong?
Nested formulas and combo box
Execute stored procedure using DAO
Auto Open and Passing variable value(s) to MS Word
how to produce a csv file from a unicode-saved text file
How to open a zip file and extract its contents in a macro?
Click away from a form?
Click away from a form?
Help with "WITH"
Sounds in Excel
Catastrophic failure HELP!!
New to VBA - help required please.
Excel as front end to an Access database - is it possible?
Problem finding duplicate values
Find a directory
Extracting Comments?
Question in a function cell to cell
Unprotecting a menu bar
Userform/Cell formatting
Need help data consolidation multiple workbooks
Sum Function in Macro
Userform Formatting
Conditional Lookup and copy loop between worksheets
Question to experts VBA
Re: Shorter code
Shorter code
ListBox Rowsource Limitation??
Class Modules vs Modules
How to call a MS Query (.dqy) in a macro?
How to call a MS Query (.dqy) in a macro?
Excel as a cheque book record
combobox value
Turn off Excel Visual Displays
Test if a folder exists
Macro to open multiple macros
Send menu call to explicit Sub
Add Selected Items
Re: Important news For all webmaster,newsmaster
Re: Important news For all webmaster,newsmaster
Copying TEXT from Textbox to other location
Variable Type - help me to solve this
Formula Help
Create a TOC for ALL names in workbook?
Menu Font
Formating to Percents in a UserForm
Excel hyperlink file associations - GIF
import data time format
Run a macro of another workbook
Re: Series Category Label in Pie Chart
Searching for Data Values in a Column - Formula Only
PASSWORD PROMPTING CODE
Dynamic Sort Macro
LARGE File Size
Excel add-in and Win98
MS Works and VB
Excel Find Macro Help Needed
Save single worksheet?
Getting comment boxes to display in linked sheet.
excel 97 : automatically inserting a specific value for a range?
Date problem
Re: How to hide Excel window when activating a Shape object
Question about Input Box and how to use the entered value
tableau croisé dynamique
Redim MyArray
Prompt to enable/disable macros
loop?
Re: Run macro when cell contents change
Extract values from a multi-select multi-column list-box
combine cells
decimals in textboxes
Catalogue of fields' connection whit external fields ( sheets)
Catalogue of fields' connection whit external fields ( sheets)
Catalogue of fields' connection whit external fields ( sheets)
ADO in Excel
Loading values into a form on open.
Consolidate Group Into a Single Line
Cell onclick make cell value increase.
excel & charts (retrieving all chart-values automatically)
Using Excel Spellchecker On a Locked sheet
Problem trying to us a range variable as an array variable
creating drop down menus in a data form
error in registering msadox.dll
DATALISTS
How do I delete Word Picture with macro
Build a Macro
Run macro when cell contents change
Protect contents in a cell from deletion
Start macro on open
Re: Enum in Excel 97
Setting AutoFilter to 1 row of data
Constantly Run a Macro
Re: Hide row with empty cells
Re: Enum in Excel 97
Data string ends up in first cell instead of Comma sepaerated CSV format
Variable
Forms Toolbar Programming
COPY CHARTS
Writing variable from a Macro to a Cell
Please Help with RTD server over network
re: SolverOK Problem after SP-3 Update
determine what sheet user is viewing
RECIEIVNG MESSAGES
Delete Modules and Userforms
Formula defines range or runs macro
Excel Macro - How to Select Next Row
Re: Hide row with empty cells
Insufficient memory error using shared excel spreadsheet
call VBA compiled code within vba
text & combobox info into worksheet
Re: for loop exiting out early
Run a macro problem?
Change picture according to cell content
Hide columns
help!!! how to place value in seperate field when this field is true
Problems with SendMail or automation of Send To
Help: a routine for launching an allarm in excel
Getting Duplicates in ListBox
Left Justify Cell
How is listheaderrows supposed to work?
Urgent!!! -- Reference libraries
URGENT - Visual Basic Out of Memory
Linked Cell Macro
Search and Cut Text
How to save Excel files which have passwords
Excel XP - VBA crashing because of Exception handling
Re: Look-up formulas?
Converting Column CellFormats in a script file
Vba code to print all sheets
how to make subs/procs can only be called from within the workbook they belong to?
excel workbooks.close returns 1004 error
how to wrap "blocked text"?..
Urgent: Hyperlink Issue
Number of Occurences In range
lockup value
Countif
Help me ! Basic VBA Query ......
give a cell a function with a macro
Digital Signing of Macros in Excel 2000
Auto run macros when opening CSV files
Digital Signing of Macros in Excel 2000
Make one column Invisible.
VBA tutorial
RE: ActiveX Chart Properties in Excel 2000
syntax for relative cell change and looping
Timecode in Excel
how to wrap "blocked text"?...
Free addins
Custom Tool buttons
NEED HELP WITH FORMULA FOR CALC HOURS AND OVERTIME
help with excel programing
Create new commandbar with call procedure
Type into one cell and automatically clear contents in another cell
Re: extracting IF
first name and a second name - In Sheet2 I only need the first name
Commandbar Mystery
What's the difference between parameter and argument??
Re: extracting IF
Remove Macros from Workbook
how to link to a bookmark in a htm file in excel vba.
Re: Please help
SQL statements in EXCEL
WorksheetFunction fails in 2003 !?
call to WorksheetFunction fails in 2003
Following a custom protocol hyperlink causes a warning in Excel (Office) 2003
Links, removal & locating
how do you concatenate two variables in VBA
Copy information from other sheets to one special sheet.
finding last row number of UsedRange
EXCEL FORMATTING
Sorting a column in a different worksheet
requiring parameters to be of a certain type
formula help
Menus on a User Form
Export picture as gif in Excel
Pictures in Cells in Excel?
Excel VbA FTP Transfers
Pivot table showing #N/A
VBA Code to automate "Save As"
Prompt user to save their file
Unable to change plot area size
Automatically replace existing file on save
Follow up For loop exiting out early
Code runs every other time
Fill down based on rows in region
how can I count duplicate entries in two ranges?
Macro as Custom Menu Command
problems with additional controls
Re: Opening Add-in files manually
Preserve original workbook, but add new sheet?
trimming whitespace
Create Excel worksheet in .Net
Deleting duplicates across sheets p. 2
Text Box to Excel Cell
posting data from a form to a sheet depending on month
VBA User form
compare data from one column with another and compare result to yet another
VBA macro (pipe delimited) code help
Re: Excel 97 Macro Compatibility with Excel 2003
Consolidating multiple files into 1 target
Best way to extract data on one sheet & populate it on another sheet??????
References not staying checked
Deleting duplicates across sheets
Depress Icon Faces and not the Caption on CommandBarButton
excel macro looking for file that doesn't exist
Automation error running an excel add-in
controlling cell borders in excel using VB
variable retaining value between subroutins question
regex string matching
DISPLAY RANGE AT MSGBOX
Remove rows based on any selected criteria
A drop-down box and dependent values
OE not downloading new messages
Returning value from function
macro to insert rows.
identify items in a list and create sheets
SheetSelectionChange Target size Limitation?
Importing numerous files
FTP Transfers with VBA
Dynamically add Checkboxes to worksheet columns
RTD BUG ON Excel FUNCTIONS?! FOR HELP
Validating a Formula
Worksheet Name as argument in Custom Function
Problem with Microsoft Excel
macro
Saving a sheet as unhidden in VB
Looking for help with MFC and Charting
List of Printers
Old XLM Macros
Given a cell, find the named range it belongs to
Dynamically Adding Code to Buttons on an existing UserForm
Re: Decimal separator
Categories in Excel.
AutoFilter and Hidden Rows
Printing all worksheets with sheetname in footer
xll file
VBA closing one file
Need CF Help
loop error
delete dublicate entry.
caseinsensitive data validation
copy non-contu.data into new sheet
Manipulating Pivot Tables with VBA
Highlighting
NEWBIE: Updating values in Excel from Web page
Re: Exporting to Word
Get ranges from sheets interactively
Hyperlink to New Window and SSL Question
Excel worksheet size - changeable?
Colors in Columns
Printing using VBA
Import into excel
protect module and work in activeworkbook
Custom toolbar + open Access Db
Custom toolbar + open Access Db
Need Query Help!!!!!
How to quickly format dates from text input
cell clearance
Problem with opening a excel file in asp.net.
Sending email WITHOUT attaching a workbook?
Expanding the outline of one subtotal
Argument can be a variant or an object
HELP!! URGENT!! How to CHANGE TITLES IN CHARTS
Decimal separator
Size of custom toolbar
Re: Grouping and Subtotals
hide contents of an unlocked cell
Excel and option buttons
Re: Can not shift objects off sheet error
How to avoid "large data on clipboard" message?
Select / Filter Data
Query Table - weird results
Workbooks when to use
Check all lsitbox entries are filled
Re: Reading List Box Value
Re: Compiling different worksheets, via automation.
Re: Applications impacted by upgrades.
Re: Disabling a cell for editing or deleting
Re: Can not shift objects off sheet error
Re: Reading List Box Value
Re: How do you lock a cell?
Re: Populating Combo Boxes
Re: Code Editing Code
Re: hyperlink - cell population
MACROS
Re: Excel 97 - Clear Method Of Range Object Failed
Re: Protection
Problem when getting the printing zoom ration in Excel
Re: Need listbox to choose sheet to duplicate
Trying to convert a used range into a current region
Question about sorting and "key" range values
Re: Date formatting XML datasets in Excel 2003
compiling?
Remove calendar control
Test
Printing to PDF
Fill series macro with different steps
Macro to Refresh Pivot Table AND Delete Old Items
Tab from one Text Box to a different Text Box
Excel 2000 - VBA - Stop recordset Data from auto converting
Calculating Maximums
Re: Force Enable Macros
Macro stops when another workbook is open
Autofilter Question
Re: Force Enable Macros
How to determine JPG size in pixels?
Re: Force Enable Macros
add combo box at popup menu
Lotus 123 conversion
VBA summarize
refined question
Using Worksheet_Change to Auto Run a Macro
Increment a variable while looping
countif constants in a Range
OE not downloading current posts - Urgent Help needed.
GetSaveAsFileName Not Working
Fill Searched array with text
Conditional hide rows macros
"for each...next" and adjacent cells
OnTime event not firing in Workbook_Open event procedure
Save active worksheet to CSV file
Excel memory
DayOfYear Function?
Excel Charts
Copy paste formula up to a cell using VBA
Convert array
cell incrementing by a specific number
lock macro (make grey)
Excel: unlocking buttons & checkboxes
linking Excel to txt file
GetOpenFilename
cd serial
Copying a selected used range
cell clearance
Workbook_BeforeSave() in xla
How not to plot zero in graph ?
Finding a string
macro to automatically check spelling before printing and before saving
Automatically locking cells following data entry
Delete all cells with a "x" in them
Have a lookup pointing to a CSV file
MVPs needed!! Persisting metadata...
code a macro to go to a specific website
Copying modules
KeyPress Event
Autofilter Limit to 1000 value
Adding / Deleting from toolbars
No CustomizationContext in Excel?
Need a formula schedule time spreadsheet
No CustomizationContext in Excel?
Microsoft Support Information - 159780 and 214232
vlookup function in vba
Close, Minimise & Maximise Buttons
Auto update pivot tables.
formula in vba
To get Service Pack Detail
Adding a pop-up help to a user-defined function
Launch Macro in Access via Macro running in Excel???
Baffled!
Changing Case
Lookup from first row, return last row value
Limit fill-down rows
inserting worksheet and name
Help with programming question
Closing a workbook without saving
Problems with active cell after saveas
97 and xp
Re: Excel 2000: Workbook has lost VBA Project
Activesheet.Pictures.Insert
assemble excel workbook
lookup array and paste value
Macro to limit fill-down rows
Simple password function - unprotecting sheets
How to keep from going dizzy when my code runs
Creating a txt file from a macro
Copy Range with no formal updates
Is refreshing listbox rowsource in listbox click event possible?
Turn AutoFilter off by code?
need help on following nested if statement
Printing to PDF
Checking to see if Folder exists
Can't select another cell after running a macro....
Protecting certain fields in workbook
Multiple Column ComboBox using Additem
using vba to update vba form
Using the "IN" function in Excel
Excel Queries.
turning "1 day, 1 hour, 30 minutes" into 1530 minutes
How to find the version of Excel in code
turning lines on/off on a set of charts
Problems with SendMail
Changing Format Of INPUT MESSAGE
BeforeClose event - Savings
#DIV/0! error using VB
Re: VBA to get List of Unique Items from column
Re: VBA to get List of Unique Items from column
Searching a spreadsheet
Clicking on a List item
Re: VBA to get List of Unique Items from column
If no FIND value is found, then a Msgbox to say so and exit sub
Re: Excel 2000: Workbook has lost VBA Project
I've asked this before...(x-axis day of week)
Re: Excel 2000: Workbook has lost VBA Project
Listbox and Array questions
Pulldowns or pick lists for filling cells.
Queries in Excel?
dll in VBA
Changing the sign of cell using a macro
mail program & operating system
email to each person with attachment
Convertion to Hex
Emailing using VBA
Re: Error Msg into a cell as text
Subscribing programmatically from Excel via VBA
Device I/O Error (Error 57)
VBA example to cut/paste .txt files to multiple worksheets.
unable to set formulaarray of range class ERROR when using Conditional Sum
Re: How to release the EXCEL.EXE procedure?
Spreadsheet in an Userform
Raise Error from ActiveX dll to VBA
GetFileOpen
Re: Golf Handicap Software - Beta Testers Wanted
Simple arrays with If statements
Modification to code
Excel 97 / Digital Signature Problem
VBA for matrix operations
Rank Formula
delete word picture with macro?
Signature Macro
How to add two sheets in a new sheet using VBA
Worksheet change event
How do I stop a macro
Run-time error when trying to work with different sheet
Interior Cell color
Linked Spreadsheets through Public Folders
data validation in excel 2000
ask user to choose
ask user to choose
Help copying a range with spaces to a range without spaces
Getting zoom ratio (printing) in Excel macro
Run a macro of another workbook
Read text file
Spin Control
Auto_Open Vs Workbook_open
query page with javascript
Embedded Text Box
Intercepting Paste Function
How to sort a sheet with more than three criteria
Moving selected sheets
Bring up a UserForm to the front
Exporting Chart to the selected location
drop down nemu
Suppress the Disable Macros / Enable Macros Dialog
Hyperterminal and Excel?
Set Tab to specific textbox control
Data analysis of imported Report
how to use the same cell with IF() function
Set default Printing setting to Entirebook, not Activesheet
Column searching using macro or VB
Comparing Worksheet Names
Finding locked cells
Multiple text criteria with FileSearch object?
sort data by name in first column and copy to individual worksheets by name
Excel Macro Fails Accessed Through IE Browser
Flaky Input Box
ok in 2000 not in 97
Max value in Do While counter
How do I pull multiple queries of external data from the Internet into Excel?
Using contents of cell to refer to a worksheet
summing
Calculation Problem
VBA code for CreatedBy ("author") and CreatedOn
VBA Excel objet indexed
Re: Save, Save As, Print Grayed Out when instance created via VBA/VB6
What's the best way to deploy a VB business logic with Excel?
How to force Workbook's macro unloading?
Consecutive Numbering
Formating Cells in VBA
Excel ADO connection opens read-only instance of opened Excel
Re: vbModal, VBA version, StartUpPosition Setting
Re: Save, Save As, Print Grayed Out when instance created via VBA/VB6
VBA Programming with Pivot Tables
Comments
Best Way to Modify current IF() statement??????
Re: UserForm Interaction
Changing the mouse pointer in code
Using VBA in Excel to Make a Folder to Save Workbooks in
importing text files
array worksheets
Printing through the Excel Object Library
userform text boxes
help with macro to open and close workbooks
Insert code into each worksheet's "Sub Worksheet_SelectionChange" Function
Cell comments
Define a Range depending on where the EOF is
constructing a copy-paste loop that skips rows
Persistance
expression.Insert(Shift, CopyOrigin) ?
How do disable OLE timeout in EXCEL
EXcel, create a list from extracted data, Conditional
Proper Case with .
Transfer control to new module in macro
Re: Auto_Open vs. macro
How would I fill a several columns with the value in the first row
Build Add-in in C++
I can increase to the number of columns in one excel table
Macro Code Question for Newbe
Re: Forms, TextBox
Formula = "=5"
On Error Statement
Re: Selecting ranges with a text box
Copying worksheet to another workbook
Hide Rows Across Mulitple Sheets
insight about excel programming needed
VBA References Problem
Dec2Bin Function Max length of 16 bits
LINKING A WORKSHEET TO AN AS/400
Type mismatch: .Cells(i).Value = "=rc[-1]" / vl
Multi-column list box with headers question...
Re: counting entities with the same values
Copy worksheet, code and all, into workbook?
Re: Delaying calculations
DELETE RANGE NAME
Creating manual outlines
Zipping Excel files
Hide rows with VBA
Re: excel 97: copy and paste values from one worksheet to another worksheet
breaking a loop
Macro/Macro interference
Output while working?
Re: Reference for emailing out of Excel
about delete
DELTE RANGE NAMES
publish as webpage in excel 97
(PLZ REPLY) copy checkbox name into sheet
DELETE NAMES
Re: counting entities with the same values
Excel - BeforeClose Problem...
save cell as gif
Re: Reference for emailing out of Excel
comparing elements from 2 arrays using VBA code
Problem with creating a Word Document
Export SQL Server data to EXCEL cause all column become TEXT
Appending to File
Newcomer to VBA; trouble with strings?
Selecting Named Ranges
Out of Memory on simple range copy!
Using Autofilter with VBA
Excel 2002 GetSaveAsFileName
Editing date in textbox?
Re: confused...
Public Array
Changing fixed date with a variable in a ODBC Query
counting cells and using a variable filename?!?!
Opening of an excel file is also giving a run time error
Distinguishing cell formula from value.
RE: Date formatting XML datasets in Excel 2003
Re: Open file to write and read at the same time
Multiple lines in a Message box
how to use vba to mk stickers..
Worksheet_Change Event - Macro kills copy and paste
Setting data type
Width property
Can column width be different sizes?
Re: subtotal of row field in pivot table
Re: copy paste
listbox.Columnwidths question
Set parameters for JPEG export by VBA (to improve quality)
vbModal, VBA version, StartUpPosition Setting
Re: Proctecting =NOW() cell from auto update
Re: excel 97: copy and paste values from one worksheet to anotherworksheet
excel 97: copy and paste values from one worksheet to another worksheet
AVI FPS
#REF! Halting my Macro
Versioning Question
Need help for time saving!
Re: Sending messages
Re: Sort coloured cells
Sending emails from Excel
Hours worked on job/per shift
OnAction and Sheet Protection
Paste text from a ComboBox into a cell
Adding a date to a cell
how to use combo cascading box
xlCellTypeSameFormatConditions
Rename Active Sheet
VB6
Query App
Re: MVP Help please
Re: Copy values from file A, Find/Replace these values in File B
VB Excel file multiple opening from a folder problem
difficulty with logical - if - and
vbCritical and vbExclamation on Userform?
Getting rid of scrollbars for listbox
Finding row count and filtered rows returned by Autofilter
Syntax advice
FILTERING VALUES THROUGH VBA
Re: Close Button on Userform
creating automatic hyperlinks in a worksheet
Vanishing Pivot Table
"On Error Resume Next" Question
excel 2000
Range format question
end sub in If then macor
Add Button to msoControlPopup ?
listbox rowsource
Fun with Macro
SetFocus Problems
Macro name listing
Randomize a game schedule
Tooltips
run SQL queries on arrays?
Forcing Macros to Run (Else Deny Access to Workbook)
collision avoidence
Auto saving after changes.
disabling cells based on cmd button
Re: small GIF massively increases excel file size
copy checkbox name into sheet.
How to display status and keep code running
Predicting that Excel is closing using events
ListIndex = cell value?
macro question
Problems with Macro to convert to CSV
Changing Workbook Name without Save As?
help with solver or macro
userforms again...
Opening Outlook Express attachments w/Excel
Selecting ranges with a text box
userform inputs
number formats
Textbox - search
Not enough Memory running macro
Re: Code to Select Row
Re: userform inputs
Filtered Cells
Help
Help Requested: Count Array with Multiple Text Criteria.
Re: Excel4 Call to get Function String
Re: macro not working on 1 PC, ok on others
Excel to Access Question
Formula links in text boxes?
Help on VBA.
Filter VBA Help!
Re: MVP Help please
Save file path in cell
Searching through several sheets in a workbook
Date formatting of xml in Excel 2003
Re: correlation addin to macro
Compare Listbox values with Collection values
Pop up dialog box
MSflexgrid data
Re: UDF - Macro Interference
Macro to increment invoice number
Adding a popup to specify a filename
Data Validation
Need print code please
need help creating "AutoSubtotal" toolbar button
Re:I need help urgently
userform frame control
Saving and Sending Custom Buttons
Re: MVP Help please
Re: Reading formatted cell values into an array
Re: Handling WorkbookBeforeClose and WorkbookBeforeSave
Re: Set Folder permission by macro
Setting a macro button for a Worksheets
Showing SeriesCollecion as a Spot with value
Re: Set Folder permission by macro
Re: Full path in custom footer. How?
How to change case automatically in Excel
Viewing Snapshot Files with Snapshot Viewer Control on Excel Userform...How?
chip pearson are you there pls, problem with your RunWhen
Re: file transfer using ftp
Re: Unable to set Properties in Excel
Re: macro only runs on fresh open of excel?
GetOpenFilename - Default Folder
code to add module
Excel/Word Mail Merge Problem
Re: Shell function II
Re: XLL Formula Reference
Re: MVP Help please
Re: MVP Help please
Re: Shell function II
Re: MVP Help please
Re: MVP Help please
Keep Data filtering functional when protectiong Worksheet
VBA functions not calculating automatically
page break at empty row
"Spreadsheet" Web Component
Select other workbook to select data in a macro.
delete rows if dublicate cell value in column 2
Re: Help to copy values
Re: Help to copy values
Re: Hiding sheets in Excel
Macro to copy a range
Shell function
Macro to run macros
toolbar position
Prompt for text entry in Cell B2
compare two lists in two workbooks
small GIF massively increases excel file size
Please help
Problem in closing Excel App with translated excel macro
Re: Hiding sheets in Excel
Re: Questions about Macro and filters
Cancel buttons in Msgbox
Capture listbox selection to a cell in a different sheet
Copy text from a List box to a Cell!
Questions about Macro and filters
Renaming Files
Exporting data from ASP page to Excel Tmeplate
Re: Custom Menus
Error Message
Copy text from a List box to a Cell!
formating sheet
Web Query Refresh - Automatically Run Macro
Go to sheet based on column
Re: Range.Formula and Range question using Excel Automation
Re: Copy text from a List box to a Cell!
PAGEBREAK-MACRO
Multiple instances of Excel and VB
Re: Help Me - Array Failure
Re: Full path in custom footer. How?
Excel 2000 (Linking Data?)
Remote Cell Reference with Value & Format
Check if Userform exsists before deleting via VB
Re: Migrating from Excel VBA to VB
Re: Finding cause of multiple copies
Re: XLL Formula Reference
Re: XLL Formula Reference
MS query links removal in VBA
Forced Refresh on a Linked Sheet
Macro not working
DirListBox on VBA
Corrupted Code?
Message box icons
marco
Action A Carraige Return To A Text File
Re: Application or Object Defined Error when trying to change a Range's text
last day of mounth
Warning triangle
page break positions ...
Worksheet object assignment
Re: Excel Function to Interpolate a List
Workbook Security
xl2003
Conserving Size
Range problem
macro works in .xlt but not .xls
delete a row
Code to make a New line in a message
Sum command in VBA
unique units?
Pause macro for user cell address input
Win Explorer to Excel
sql.request
Action A Carraige Return To A Text File
Delete Rows
xlDialogSaveAs
Combining 2 autofilters with an OR
Re: How to add a variable in a range for a Combo Box
Formula Writing
is workbook open
Re: Excess Format Cleaner 1.0a locks up excel and vb editor
how do i compare values line by line??
Re: macro to read from Project
Re: NETWORKDAYS in a distributed file
Re: Excel Function to Interpolate a List
Re: Excel Function to Interpolate a List