Excel Programming [Archive] - Page 162

Excel memory problem
Re: Using variables in worksheet.range
How to create User Defined function in Excel
How do you extract the top ten values in a table?
Can't Exit Design Mode
How to handle Blanks (empty Rows)
calendar already done?
Is there a "replace" or "Substitute" command in Excel's VB?
Trapping Excel Close event
A problem of Excel.
Pivottable database connections
Toolbars
Column Number to letter in Row Source
Goto...Return question
Offset Code
Textbox Text is Truncated
What's the equivalent way of "Cells" method for the C++(ATL)
how to print a chart from values calculated in macro
Trapping Worksheet Target
writing to txt files
Three Axis' Charts
calling a dll from excel macro
Recording Page Setup macro
VBA Excel Functions
copying macro
COMBOBOX
rename file macro
unzipping a file
Assigning Different Caption to a Check Box
Compilation error question
Avoid printing blank columns
Disjointed formula/macro code must be mended
"Unspecified Error" with CommonDialog in Excel 2002 after updates.
Screen Area Resolution
selectively copying ranges from one sheet to second sheet
Installing someone elses UDF
Re: SetFocus using variable name
Today()
Using vb to create an excel object and save it as a CSV file
SetFocus using variable name
I am in need of a Programming Consultant
extend selection
IE to Book1, to book2, then close Book1.xls
Re: table preps for xls external data refresh
Copy formula without changing all values
Drawing a Curve programmatically
update...."object required" rt er 424
Move Data Between Excel and Internet Explorer
Grid Lines vs. Borders
VB.NET insert row in Excel XP
getting and error with autofill ":=" ?
Visual Basic Question
A line from MSDN Library
Copy until new value
Get External Data Query
Don't know where to start
Excell's options
Sharing workbooks
Hiding Ranges
Reading and writing from/into several worksheets
Save As based on cell value
Excel and Pocket Excel
Re: Excel Programming
excel and Pocket Excel
VBA - Form Text box value
using hyperlinks in a protected worksheet
Opening browser window
Trouble with Union
Automating defining names
Show user form, leave wosksheet active
How to connect to SQL db & update cells
Open a file o the program that was created
How to web query a login required site
Set up an Ordering facility for a Buying Dept
data selection query no2
data selection query no1.
OleDB returning DBNull for numeric cells
check if a file exists / is open
Combining Two Ranges
Error Method Cell of object global failure
Excel as Image Browser
Macro closes excel and therefore won't run anymore
How to establish a trial period?
reading html when hyperlink address not hyperlink text diplayed
Check if directory empty OR no of files in directory.
Change sheet reference
Re: Autofill in a form
Populating cells
Hide Columns
Copy Button with worksheet
Re: Greying out cells
Re: Greying out cells
Essbase VBA Macros - Help
Excel 2000 Dynamically Set Print Area
locking and unlocking a row of data based on whats entered in a cell
.exe-ing excel files
Freeze Conditional Formatting
Getting data from DB via FTP
Stop a VB program from running
trouble opening websites
Range Offset setup (follow Up)
Flat File formating with Print# Statement
unexpected problem in VBA Code
Re: Excel 2003 + Solver + C#
Excel: VBA userform is shown but not loaded/initialized even though it was first unloaded?
Referencing variable
Excel 2003 + Solver + C#
OfficeXP "Cannot open pivot table source file" when refreshing pivot table
Hexadecimal Calculations
Timer
Delete based on results of formula
Copyinng & Renaming Worksheets
Refresh Pivot Table message
application.displayalerts
Re: Heres the proble...
Re: Heres the proble...
Re: Question Regarding Name Function
Re: Heres the proble...
Re: Heres the proble...
Re: Heres the proble...
last cell of a closed file
Validating Entry into Textbox
Help: Question Regarding Name Function
Deleting a query
Type Mismatch on Date
(trying again...) code stops executing
VB Code Cleaner
blinking cell=> in ms excel
Probably not possible, but... (XL -> PP, and gray border on pictures with VBA)
OptionButtons
Formatting when doubleclicking in pivot tables
RefEdit irregular behavior - corrective measures wanted
cell naming not showing up in drop down list of formula bar
GetOpenPathname???
Highlight blank cells
***UPDATING MORE THAN ONE EXCEL WORKBOOK****
Run Time Error 1004
Unable to CC more than one recipient when sending a Lotus Notes mail from Excel
Single message box for multiple IF statements
Creatiing a Combo box (ActiveX)
Using code to calculate a value in the next row
Fitting the used area to a page
Adding rows to create list from DDE data
Return string array from function in excel 97
positions
GroupName
Refering to a cell in the Header /Footer
Which one is faster?
Hebrew inverted characters macro
Re: Control for Range
Help Please
Re: Control for Range
Conditional Formatting
Defined named range to array
Filters
Print to File
Excel - adding control programmatically.
ListBox with variable width columns ?
list of opened workbooks and selection
Getting Details from 1 field
HELP! Custom Random NumberFunction in VBA
charting cell references
Pivot create
Passing an unkown range to a function
replacing a range with a variable?
Is this possible in excel 2000? - Excel doesn't quit when using a particular file
Macro short cut key
Another Date Format issue
Hanging on sheet close
Cross reference?
Click Event
Combo Box
AS400 Date value conversion to Excel
Graph macro question
Excel automation and shared workbooks
Macro control
Calculate time
Copy Current Region
Option Buttons
Sorting Worksheets
Open a file with Front Page from Excel
Updating Data Retrieved from an HTML file
Functions and Ranges
A Drag drop question
anyone have any improvements for my Weeks Function?
Filling rows
excel keeps crashing
testing the state of a checkbox in vba code
How to graph a 2-dimensional array?
Creating dymnamic named ranges
Excel crashes with .Close command
Variable life
Set to Read Only
macro help?
Populating Sheet Data From A UserForm Combo Box Enabled For Multi-Choices
Delete all rows with designated word
Error when string length > 1024 and starts with -
Coding a button or hyperlink to insert a predfined row
Assigning a Unique number
FormulaR1C1
Hiding rows in a protected sheet in Excel 2003
conditionally delete some elements from an array
Combobox or Listbox
Returning by Function
Macro to insert a row, copy info from another row and autosize the row
Macro to insert and name a new worksheet
ip calculation using excel
Appointment calendar in Excel
Launch Word for Excel
Notification When MSQuery Returns Data to Excel
Autosave & Rename
Preformatted array returned by custom function
Code Help
How to insert a column...
Dynamic combo box
Detecting Cell Edit Mode
Check Box Help
Syntax question
conditional formulas
VBA code stops executing
Exporting Excel VB code
Data validation
Copying Data across a network or internet
Number Display
Auto Quick Info
Macro to delete record and validation problem
Automate Password Protection for Excel
How to password protect an application
Return value from a pivot table
HELP: Running two Macros, one before the other
How to get file name from long directory
Protect cells in Excel so that users can only paste in text
Protecting cells in Excel so that users can only paste in text
Saving over an existing file (updating an HTM file)
LastCell Function
Fill blank cells with 0
appending data from an external text file
Data Validation and Macro
filling every tenth row
Check whether a worksheet exists already
Filling every tenth row.
Using a macro to create a pre-linked combobox
Re: copy and paste to doc
subtotal calculation
SpecialCells Doesn't Work in a Function??
Advise re: VBA
Refreshing Pivot Tables QUery
subtotal function
Refreshing a dynamic range variable
Adding New record
Excel Controls Toolbox - Checkboxes, etc
Pause a macro to allow editing of a worksheet
Sorting Protected Sheet
How can I grab data from a SQL Server stored procedure
Re: Truncat the file name in long directory using macro
Re: Macro that copies values
Re: Restricting Macro Execution
Re: Restricting Macro Execution
ComboBox List Fill Range
Declaring Public Procedure
Test if Cell is within Range (name)
Date Formatting
Sort
Paste, clipboard
Data validation in several levels
Dynamic Graph Title
how to make a link to a function or subroutine...
SendMail Method
Vertical Scroll bar position in Text box
Outputing Excel Module Codes
Rename Batch of Files in VBA
textbox selection to relative row?
copy html data to spreadsheet
Code for Printing Hidden Sheets
Infinite Loop
Assign value of cell based on text box
Yet another question naming ranges
Seek and destroy
excel mailsystem
Pocket Excel supports only some functions
Hyperlink coding?
Flashing Cell
how to
Validating Cell
Help with a loop
Variable in a range.
Delete a row
macro
arrays and others..
Different VBA versions
Autofilter Testing
very difficult code that will close original workbook and leave another open
Graph of 3 diffirent data
Wie kann ich aus einem Access 2002 AddIn eine Excel Datei öffnen???
Collections Lookups
VBA
help creating a macro
getopenfilename
Functions and Ranges
addins
Copy rows then delete them
Radio Buttons
Pictures
Help with LastRow
When i open my Excel file this message prompt:
Identify and Delete all Rows and Columns NOT in Print Area
Excel VBA
Error on SaveAs Macro
Using default file locations in VBA programming
macro
Chip's example about vatPtr & objPtr
Adding items to a spreadsheet from a user form listbox
run-time error '9'
Spell checking text boxes
stop enable macro message
Unknown Error - HELP
Unknown Error - HELP
Access Violation when closing Excel.
Objects not showing up in VBA properties
Multipage control on Excel VBA forms
VLOOKUP/Validation box macro
Wildcards
Re: Changing the text in a list box in an Excel Spreadsheet
#N/A
Changing data source passwords in workbook ?
Run Macro on External Data Refresh
Run time error 1004
Delete entire row based on cell content
RowSource in ListBox
Drop Down List
Limitation
Turning off Cut and Copy?
Re: How to stop macros in 2nd workbook?
VBA code - protect and unprotect a sheet
Office Chart Component and Excel
Loading Excel Arrange into VBA array
Trancat file name using VBA
Writing a text file from Excel using VBA ... a small issue
execute multiplication when data entry
SUMIF QUESTIONS
Merge cells
IF: color of cell > color next row
What is the VBA equivilate to Excel worksheet function MAX?
How to stop macros in 2nd workbook?
Excel File Extension
lost objects in Excel
Stepping through a column using FOR/NEXT
Copy Macros and VB code from one workbook to another
Determining Chart Series Number using VBA
Updating a textbox without erasing previous data
Dynamic data ranges and Charts
Creating a toolbar using VBA
Excel Combo Box - Data format
Volitile Formula
check for selected columns in a macro
Excel Programming
Number of rows not empty
Access data form through command button
Find 1st Empty Cell: How to?
Name a Sheet through Macro
add a print key only
Using OWC10 to access an Excel file with linked SQL Server
How can I get RGB color values?
Formula - shorter, neater, faster ?
Next column
Run Macro on External Data Refresh
Exporting CSV files
Copying values not formulas
HELP: Running two Macros, one before the other
Comparing
Copying Formatting using macro
Blank Line in Header Text
forms in excel
Command Bar (help!)
Another Syntax Problem
Multiple Recipients
examine print queue from vb
Append Data To Access Table
Referencing Sheets
Hiding Macro List - Using Shortcut Key
Help, i can't figure out 2 "And" operators!
Pull email addresses from SS, by domain, into CSV format.
force text in a cell based on value of cell in a range
headers
Visual Basic
Misbehaving 'Worksheet_Open()' Event
Help, i can't figure out 2 "And" operators!
Temporarily Disabling an Event Macro
Use Array to activate workbooks
run a procedure when opening a workbook
Macro for Graphing Data
Helpneeded in writing special function, "IsBetween"
Histogram VBA Code won't run in Excel 2003
Anyplace Online With Excel 2002 Object Model in PDF File ?
Querytable
OWC Formating Columns
Custom function to return output in multiple cells
Finding strings within strings
dynamic range reference and use of common code
Finding strings within strings
Quotes in formula
Activate Workbook
Input Mask
Re: pivot table refresh
Mp3 Player
searching date
Return of row and column
Pivot Table Error
creating folder
exporting
Selecting cells by color?
Automaticlly Running Macro on Changed Cell
import text file
Copyi8ng format after row insertion
Calculations Return by SQL
How to get last entered value in a ROW?
Run A Macro based on changes in cell
obtaining the name of a button
RefEdit irregular behavior - corrective measures wanted
deleting extra spaces in a string
Grab a key and use it to query another worksheet
Shapes In ActiveSheet
for-each-next loop
PrintPage OFFSET problem
Enhancing performance of excel jdbc: odbc driver
Make button to print Multiple occurences of item based on input
Generate an event when a cell is pressed
OLAP Report viewing fails to Launch using EXCEL XP
Cutting, copying, and pasting my selection
Using ExitSub to stop a Save
Finding a given string in a cell
How to set chart PlotArea to marry up with fixed rectangle, for any screen resolution
Application Error when using GetCommandLineA
Can not open file (Critical)
When you select a range with a macro
Runtime Error
Looping Through Records.
USERFORM and MENU
EXCEL.exe stays open after Quit method in an HTA
creating controls at runtime
Excel and Pocket PC does it have any interface?
Resize and a question
Append Data In Worksheet To Access Table
Where is Excel VBA Help Info?
Problem with macros on Mac
Is there anyway to undo a save?
referencing other work book using the INDIRECT function
using variables to set ranges
Opening a Workbook
The MAX value of certain type ?
Database Filtering and Import or Copy to Remote Client Workbook
Deleting Rows beased on Values
Detecting Input Change on User Form
Left Lookup
Hiding columns by Macro
Programatically saving an excel .csv file to .xls file...
Path where Workbook is saved
A code to modify the system time ?
Columns To Rows
call .DOC from an Excel VBA macro ?
UserForms compatibility problems
How to combine Vlookup and MAX ()????
Using Webquery via VBA
text files
workbooks().open halt
referencing worksheet functions
open text files as a worksheet
Keeping inputs in proportion with Solver
Q: Changing a link without link validation
Combo Box value changing when query refreshes
Closing Access
How to insert columns with macro
General Field Format - Need to change to decimal
From worksheet enter DO-Loop start & end code
Creating a button on Excel Toolbar
ShowAll Data
vba clearing out values stored in array
Naming a Range with VB
Re: Comparing Values in Range M
Pasting Data
Validating number of entries
Conditional Column Hide
Making a query and a chart on the fly
auto date
Duplicates Value
Stoping an Auto Open macro from running
Amend code or change it completely?
Hidden macro
Bypassing Protections
Hide cells
Checking for valid date
Sending Mail from Excel: Body Text
Clear contents of worksheet before populating
Getting information from a different worksheet
Multiple users
Multi save
Pulling Info from a No of Columns
Linking two Excel Files
Capturing the directory when a workbook is opened from Explorer
Splash Screen
clear the Form
Can't get this syntax correct, please help.
Arrays
password protect
How to count checkboxes and use in .Recipients.add?
Invalid characters in Excel
Export range to html
Adding browse button to userform
Search all sheets
Adding spaces to a text field
Exporting macros to a different users PC query
Closed workbook remains in memory.
Excel - DotNet - Variant Arrays as Params
Start-up userform
Lookup Formula for "When Negative ... "
removing a row if it is non numeric
opening websites with random addresses
How to tell wich object/shape was clicked
Automating Excel with Java Script
daily csv file needed into automatic web charts?
ChangeLink
FOR EACH
Calculation Method Failed
Deleting a row if column K is blank
Problem writing formulas - please, please help!
Convert VBA to VB
Find blank cells and calculate sums
Switching off 'Save preview picture' in Excel
Copy cell contents into Macro code
print a form
Multiple comparison of list items.
write data to access
How to export pivot table to a plain table?
Macro
Write data to access file through EXCEL
Trying to find a value from one sheet, on another, then compare rows
Range naming
Newbie: Libraries for Excel?
xlLastCell question
Comparing Values in Range M
Write data to access file through EXCEL
Forms Controls
Query AS400 and unknown character
Changing Toolbar and Menu Items
Last cell in range
Date & Time format
Converting MouseDown Coordinates to Chart Point Coordinates
Comparing Values
Embedded ActiveX controls
Tools For Office - Excel Menus
LISTBOX'S
RE: Take a look at this corrective patch which comes from the Microsoft Corp.
copying cell text to non-Microsoft application
Search and return value
Macro to find last datafield
How can I batch print Excel files?
Command Buttons on Sheet moving with cells
Working with 2 drop down list
Count number of HPageBreaks on worksheet - examples
copy a worksheet to another xls file
Making a form with only a certain amount of rows used
Mac Serial Port Communication
Input text
Date or datetime
calendar control
If Range.Name question
multiple selection
refresh sheet2 with a sorted data from sheet1
How to: Add blank row at bottom of range
Find Method question
PASSING an array to a sub in VBA
Option button querry
Re: Correct declaration of variables
VBA Masters
Formula for colors
What is the problem in this formula
Can Columns Resize Automatically???
Correct declaration of variables
A Function to Compare Values
Range names being deleted and altered
Scripting.FileSystemObject Networking
Disable Code
Deleting a column based on a value
Time Formulas
new macro
Need help changing Range
Form
Help Fast! Can I add chart to user form in Excel VBA
Icon in menue to start macro
Form
Divide By 0
Named Range Cells vs. Absolute Cell Addresses
Chart Object Caption
Specifying 2 sheet names
Adjusting VBA code for some flexibility
Force Acceptance of Macros
sending/receiving data over TCPIP
Macro column selection
DLL libraries msadox and msador15: Versions Problem
DLL libraries msadox and msador15: Versions Problem
Index Formula Question?
Can non-Excel users run a VBA Excel program?
Named Aray Formula
DMS
Doevents Application
Compacting Excel-VBA file
userform titlebar and closing form
Text printing from VBA Excel macro
Programming Excel worksheet function
Create a "key"
Delete text from cell containing text and numbers?
Convert -ve numbers to +ve
Excel97 workbook crashes after changes to columns
Automatic completing of names and ID numbers - Problem.. help
Excel97 workbook crashes after changes to columns
Amending code question
Missing Question
Adding OLE objects from VBA in Excel
custom function
Code to allow user to enter criteria for autofilter
Macro to delete a workbook.
first Tuesday in the month
Compare databases
comments AutoSize
How to pass value in cell between workbooks ?
Oracle Date format
How to make the invoice number increase
Calculating date overlapping
myMenul.Caption = "P&L Report"
Macro works from RUN but not from shortcut
Automation with Delphi
How to disable a macro
MISSING:shappmgrp 1.0 Type Library
Formula to macro...anyone??
Can error 1004 be trapped????
Worksheet_calc
Using variables to select a range
COMPUTE CHANGE IN PRICE BETWEEN CELLS IN A ROW
Can't quite get this syntax to bring in the required information.
Mask input in input boxes?
buttons???
Easy Value listing code
Path Not Found
Returning value of a cell containing a formula
Inputbox Cancellation
autorun a macro
Inserting value at end of range
buttons???
find and copy
Multiple Filter in VBA
Snailspace Macro Needs Rejuvenation....Anyone?
manipulating the built-in Data Form
userform with date searching in worksheet
Best book to learn excel?
Problem getting excel to work in Visual Studio (C#)
How to cause userform to display
Userform to select start date and end date
ON ERROR RESUME NEXT
Conditionally clearing a cell
Calculating and re-calculation a matrix of 100 numbers in Excel
Web Query and Line Break <BR> tags
run-time error
Scrollbar
PrintOut with Adobe Acrobat 6.0
Why does this work and not work
On Error Resume Next
delete an excel file
"Find" question
Probably a stupid question..but Im just starting out
renaming sheets
Empty Modules
Inserting a Row with VBA - reply
ListBox
Using linked workbook as a parameter in a user defined function
Modulus and the Mod function
Extracting data from a single cell
Help with user function please
deleting rows in excel
Remove Close Icon ?
Newbie
conditional printing
Confirm Open After Download - Reading Registry
Why some forms not available?
group name for form controls
checking errors in the formulas
making macro resident in memory
CommandBars("Insert").Enabled question
classification in column
Inserting a Row with VBA
Checking values already in combo boxes
Autofill userform textbox
Testing a cell
PivotTables, Page Fields & VBA
MISSING: shappmgrp 1.0 Type Library
Very basic macro question.
How to pass value between workbooks ?
Any Development environment for Office 2002/2003
test_for_xmas_day - i think there must be a better way
Worksheets in alphabetical order
Hpagebreak help needed please
why does't this work? (chart in excel)
How can I copy formatted text from an Excel textbox into an IE .htm document ?
Replace cell of column with cell of other workbook
Code for printing footers
Creating a loop from my code
Cancelling the BeforeClose Event
Userform and controls locked property
Match Function(Code modification)
listbox.row source
Remove default formating and extra data
Re: Find Replace
Holiday Formula for an Employee time sheet
Columns To Rows On Another WorkSheet
Reload Typelibrary? .Remove() & .AddFromFile() fails
file information
Re: Find Replace
Deleting Rows
Help with text box limit (1024)
Re: Passing data back from a form
Precedent/Dependent in VB
data into an array
comparing data and write values if true
Excel and the Serial Port
my big chalenge - import acces data in excel
Ping anybody
Query Table Problem
Modifying Code that deletes a Row
Dialog Sheet not updating
Trapping Events generated by a Worksheet
selecting sheets
Text box in form truncates information. Please help
formula help
Programiclly copying worksheet to another workbook
Worksheet codename
validate data using code
Help with some sheet code
How can I list the results of my macro without overwritng previous results?
ROWS() returns 1?
Clicking 'Cancel' on an Input box
Formula
Aircraft Scheduling Problem>> VBA code needs adjustment.
Disabling messages from Project
Simple VBA spreadsheet within Frontpage
Inserting Date In Filename Using Macro
Userforms.....
conditional formatting with a twist!!
Conditional Formating with VBA help needed
Setup Userform
Setup Userform
when a Find statement is successful
Inserting specific data into moving cells
Setting list box contents
Checking for invalid dates
Count the number of just the horizontal manual page breaks
closing workbook
Creating Listbox
HPageBreak dosen't f...... work
view comments in cell
copying ranges etc
For next
Global Variables Not Accessible
Re: Formatting Cells Dependent on Contents
Limiting values in comboboxes.
Newbie needs help
FileSearch Problem
Formatting Cells Dependent on Contents
Re: Formatting Cells Dependent on Contents
Re: How To: Get Last Cell
How To: Get Last Cell
Net send
Cells V Range
Text format alignment problem
Very simple Select problem?
Multipage Object on User Form
Select Case Picking up number
Bypass macros in Read only
regarding Excel 97 to XP migration / conversion??
Using enumeration with controls
Is workbook open anywhere in network?
Hi there...
Correct syntax for use Replace command via DDE?
Is this possible?
How To: Check if a cell value has changed
SolverParameters behaviour different in VBA and Excel?
Function parameter description
Sumproduct error
Converting figures into words In Excel
Re: Formula needs tweaking - HELP!!
autocreate chart
How can I build a Excel Function that acts like those built-in
Sort Code Modification
Keeping Linked Info When Tabs are Renamed
Formatted printing
Extracting records that meet multiple criteria
Formatting Cells that contain Matches to Data in a List
Combining Modules
excel 5 dialog sheets
How to hide Excel's Top Menu Bar
Can I program a userform via spreadsheet?
Can worksheet data be exported/imported to/from flat file?
Storing Variables
Determining active conditional format of one cell
Macros in this project are disabled
Custom MsgBox using values from 2 different cells
Forms
Scrollbar updating
Avoid "...contains one or more links that cannot be updated" message.
Inserting TextBox1 Value into Conditional Column/Row4
Worksheet.Protect Question
User form question
Create worksheet index
Refedit question.
Error 91 - Object variable with block variable not set
is it possible to jump to the souce of link in sheet with mosue click??
How to refer a Variable across Workbooks ?
comboBox
inputbox
Excel runs slowly in the background
If then MsgBox
Best place to declare variables
Is Excel Typlib backwards compatible?
Highlighting Textbox1 Value when form initializes.
replace line of code in vba protected project
Excel Logic needs a Doctor !! FORMULA FIX DESIRED!!
How to group or organize dozens of macros?
I'm sure this is easy but i can't do it...
advanced filter
Txt Import problems.....
MS Query - DB connection
Variable produces a complie error
Re: Clearing clipboard
XP is deleting Forms
Disable Prompts
Message Box
Data validation code
Re: Clearing clipboard
Very basic question... I MUST be having a brain fart....
Hiding Sheets
Auto accept a value in a cell
Printers & LPT
Excel 97 VBA: tracing a run time error
Deleting Workbook
Cannot use range objects
Controlling and setting images
Excel 2003 VBA Help not working when automating via VB 6
Individual point standard error bars on chart
VBA code for Userform
Allow user-entered file reference
Inserting & Deleting rows can take ages in Excel 2000
Tricky Graph Question
Exercises and tutorials
Excel Reporting (Graphs - Generating)
ADO, VBA and SQL
Problem opening .htm file from Excel 2000
deleting objects using VBA
named range not specific to worksheet
Use Current directory to store file
Macro that will autofill a column with data, up to the last row of data in previous c
VBA in 97 vs. 2002
#Holding values in different format#
Display Current File Name in MsgBox
VBA filesavename
Array of page ranges
vba...finding location of number
Page set-up when selecting multiple sheets
bitmap for buttons
Loop through checkBox on worksheet
VBA Speed question
bitmap for buttons
Create dynamic variable names?
Replacing Carriage Returns
find files and copy to new directory
Two cells into one
Two cells into one
mail workbook
RefEdit - cannot select range on another workbook
Changing Calculation Method
Userform Textbox - Date Problem
Saving in Excel 97 a workbook developed in Excel 2002
RTD Callback and CIS with firewall
Date Reference in VBA
Look up Headache
Help menu in Microsoft Visual Basic
Calling objects
linerar/integer programming problem
vba code problem
using date ranges in a pivot table
Personale Number Rounding!!!!!
detecting a vertical page break
SaveAs didn't work in VB protected mode
counting rows to an empty cell and making a chart
Extract name, dates & number as criteria Then paste to current file
Converting time to numeric number
test
Write data to access file through EXCEL
access the solver reference library
List Boxes (Help!)
Reading .csv file into array
System Resources
Turning Calcuation Off Completely
Autofilling a formula to a variable last cell
VBA code to save gives error 1004???
Search or FIND on a userform.
Reclaiming VBA Code in a corrupted file
simple conditional find, copy and paste
array of rows
Need help on Logical Statements
protecting cells with macros
Save excel file with filename = cell text
Run Macro from another X number of times
Text Import & Current Range problem.....
Variable Array Problem
range.address ?
invalid picture file
Adding Records to Access Table
Email Workbook
how to programmingly insert a new row in excel sheet?(using VB code)
Change sheet reference in formula?
Disable app window controls
vblookup and type mismatch
Learning resource for VBA
unlock project with VBA code
Format dates
changing case
Data validation using code
selecting a range from a list
Need help with two Execl VBA problems
Show Grid lines
Removing the little Excel icon in left corner
letter salutations and envl. address.
Macro to copy formula on worksheet close
Find in Excel VBA
How to run a excel macro from SQL
How would I convert the following into a excel sheet?
AddIn Project for Excel
Compare and identify new data
Open Dialogue Box to a certain folder?????
Excel XP removes AS part of statement
Sorting Names
always trust macros from this source - is disabled. Why?
Combobox not writing value if next selection is same
Comment Box Sizing
easy combo box question
Rankings within a database
listbox please help
opening text file triggers vb error
Check calculation status
*Easy* question this time!
Tooltip on lineshape
Display message in macro
Embedding command buttons in cells
specify an input directory with GetOpenFilename
Using Userform object in Excel via automation from VB 6
Hide macros executions
Hide macros executions
Hide macros executions
Warning Statement to Delete Macro
Application.FindFile
Worksheet Object Name
how to find out if text in the Excel cell will be trancated?
Application Calculation Error
Mouse Scrolling in VBA Module
How do I run an external program?
How to create date format in vba
How to Create a Document and Save it from a WinForm
Linked worksheets-Help
Missing References between Excel Versions
Need help with IF statement ! ! !
zoom to a range of cells.
Passing variables from module to userform
Disable the opening of another workbook
VBA - Normal project file
Searching for data on seperate worksheet
Protect Code
How do I Freeze information to keep from updating
100 x hundred
Selecting a certain cell
using xlColumnField
Survey Forms and Excel
Notes and Closures
Re: delays in macros
find in closed workbook
Correcting #NAME errors
Selection from list with worksheet names
Close routine
closing a file without saving
delays in macros
Excel Global Variable Setting
Excel macros
Simple question
TRICKY ONE FOR YOU CODEMASTERS!!!
listbox value not initialized
Run-time error '1004' - Unable to set the Visible property of the Worksheet class
timed macro
Help!!-combobox with Text
button to call website
Progress Bar Help
input(1m#1) strips the null characters
help!!
Open a file