Excel Programming [Archive] - Page 169

Web Query
test
Re: user event driven macro issue
Re: File Copy
How to +1 to a cell everytime the sheet prints?
Re: Delete Rows
selecting sheets in VBA - more info
Adding sales from a non working day to the previous working day
Formatting
Re: File Copy
Problem setting directory in xlDialogSaveAs
Re: user event driven macro issue
Can Excel operate as Database?
Need help with combo boxes on Spreadsheet
UsedRange problem
Re: Deleting duplicate lines
Sort By Date, Ignore Year
solver dialog box in VB
close excel after finishing task
Selecting sheets in Excel VBA
file transfer to/from a unix machine
Passing a variable to a Worksheet at open time
Re: VBA Code
Re: hope someonde is smart enough?!?!
Visual Studio for Office ??
Stuck on Custom Splash Screen
Writing a macro so that when saving a spreadsheet the data cannot be changed
Re: If Cell.Value >= [???] and <=[?????] Then
Re: If Cell.Value >= [???] and <=[?????] Then
Re: If Cell.Value >= [???] and <=[?????] Then
Re: loop through workbooks
loop error
Re: loop through workbooks
Re: pls help with macro
Macro to insert page breaks when values in 1 or more columns changes
Pivot Tables - Multiple Consolidation Ranges
word doc to excel and select 10 random cells, how
xl2003 and VS
Quick Q re: files in a dir
Counting visible cells
ComboBox Event Procedure problem
Macro To Copy Down
loop error
excel template to open from network
Input-Synchronous Call?
checking values in a cel
If Cell.Value Like "Hand*" And Cell.Value <> "Hand*lch*" Then???
Re: Formatting column
Conditional Links
Web Query
macros
make a sentence from words chosen at random
hope someonde is smart enough?!?!
macro upgrade
Workbook Open Vs Auto_Open
Re: Automatically Run a macro when a worksheet is selected
Re: help again please tom?!
Call VB6 DLL from Worksheet without VBA wrapper
aborting a sub
find ????
variable copy past area in vba
Link to fortran
Copy file from drive to webserver
Find Values > 0 Over Multiple Columns
Data - Table - row / column input cell
Re: Automatically Run a macro when a worksheet is selected
Worksheet_Activate
Copy down macro
flashing cells for just a few seconds.
Format to text was not sufficient
Re: Excel 2000 Automation Error
Help to match number in a column
Need code - scrollbars on workbook open
calling internal functions in VBA (i.e. chr)
Solver Macro
Need code - scrollbars when document opens
Application.Screenupdating not "always" working?
excel table to web tool
Copy & Paste to an Archive
Re: Copying/moving code in a macro
auto-filter change not triggering worksheet_change event
Re: Is this really hard?
Re: updating data in rows from master list
Chart Scaling
Help with Page fault error in MS097.DLL
Re: Is this really hard?
Copy Data to Rows instead of Columns
Re: Create a folder.... (Post Duplicated?)
Re: Add sheets that are unhide
Re: Add sheets that are unhide
Re: Error message
hyper linking
userforms
Re: How to automate frequently used macro?
Re: Converting .csv file to Database?
Prevent user from amending data
Copy only the number from a text string
updating data in rows from master list
Controlling cell selection during data entry
Re: When I Import an Access Table With an Excel Function in a Cell it Displays as Text not as a Function in Excel
add numbers in textboxes on userform
Excel Cubes
Re: A way to stop or limit copying ?
EXCEL.EXE has generated an error...when closing a workbook
Create a folder....
Unable to set Bold property of the Font Class
Re: excel labelling
Re: Drop Down List
INCREMENTAL MACRO
Re: Looking for Excel function to resolve userid to fullname.
automated macro
Adding and Removing Custom Menu Items for one file...
Excel to Database?
protecting excel macros from being changed/ seen by user
"Code execution has been interupted"
Batch files and VBA
Event After Printing
HOW TO MOVE CURSOR
Create Folder.....
If ... <> or ... <> then statement
Re: Password protect an Excel document
Frequently used macro-automating?
customising footers
display in memory data in browser window
Concatenate a list
Test
Re: Auto Email via xlDialogSendMail addressing question
AVI details
Re: Auto Email via xlDialogSendMail addressing question
Re: CommandBarButton.FaceId=?
Template form design.
OfficeXP locations of macros, add-ins, etc? lost coming from Office97
Pivot tables
*.XLB
so easy to create macros b4
SELECTION INFORMATION NEEDED PLEASE HELP
Making excel drop unused rows when linked to another WS.
merged cells
Excel as Database?
hiding Worksheet menu bar
Re: Excel 2000 Automation Error
Add total row below dynamic list
Inserting rows in sheet from custom application and keeping internal links
Links in Excel workbooks
Status bar for macro
Countif failing when referencing an external file
Go to a website and logon automatically
help again please tom?!
Re: Screen refresh problem.
Replace text in a cell with text in another cell
A VB Code instead of a pivot & sobtotals
Re: run word macro
Max Value from 2 different Ranges
dependency protected cells
Removing the RECENTLY OPENED submenu item
run word macro
Macro failing
UserForm help
Re: filtering, header and print
matrix multiplication
Using Web Components in Excel
Re: Determining the last row in a spreadsheet
Error with a Macro
embedded files
tales of woe
Screen refresh problem.
Re: Conditional/selective deleting
Getting Max values of like cells in a Range
Re: ListBoxes - correct syntax
Re: Comparing Collections
Re: hiding Worksheet menu bar
Re: hiding Worksheet menu bar
master file macro
master file macro
Re: excel labelling
#REF in formula when delenting source
Re: Linking with text string
Re: Cells(1,1).Text
Re: Combine Files macro
how to recognize SaveChanges Parameter
Xml and Excel
application.screenupdating problems and IE browser window
Accuracy
Test Only
labelling
mscal.ocx
Excel links
Remove time from date time
mscal.ocx
Referencing a textbox value
extracting information from populated cells
Strip time from date time value
Disable control down (cntl D) on a worksheet
Run Query statement in Excel
Ignoring some, but extracting others??
Why does this not work with shortcut (EX97)
internet explorer (ie) issue with activeworkbook.saved (save prompt) AAARGH.
importing text file in excel97
Running Query on a record set
DLL- application link
Populate listBox
Currency Format via VBA
Automatic Numbering
formatting cells script/marco
Updated Modeless Progress Bar Class Available
Re: copy non-coun. cell
Control record displayed in DataForm window
CheckBox data copy into sheet.
Excel Reading
Copy Formula Macro
Excel 2002 - Macro Security
Determining specific weekday in a range
Combo Box Value List
VBA Excel: Opening Very Large Text Files
saveas
Date and Time Stamp in Excel
Re: open Excel workbook from another workbook
Re: Copy Data to Rows instead of Columns
Equations
Format Cells dialog box
VBA Error
Simple Sort question
Option Button Control
Excel 2000 Automation Error
Re: Excel XML Spreadsheet
Personal workbook shows as read only
Re: Sendkeys
DDEPoke is not working
Disabling font color button
Excel validation for unique entry
Creating a drop-down menu
Creating a drop-down menu
Send To Feature
Equations
Multi column Data Validation List
NM, Got it
How to Prevent User from Unhiding Sheet
Re: Read Only File
Database Query
Best Way to Create Help Screens for Excel Forms
Programatically Displaying Office Assistant Balloon
Data Processing
How to send an alert message to other apps?
Macro to add cell value to referring cells formula
Cells.Find in Auto-Filtered range
Growth
Re: Import .csv (leading zero suppression not desired)
Opening a Word Document in Excel
Check Excel Macro
DialogBox
Tidy up macro!
Disabling Print on TOOLBAR
Re: Creating a drop-down menu
Autodial phone number from cell
Thumbnails on User form
Form Close button
Changing Page Headers with Variables
Linked/Sorted or Filtered Sheet
Confused
Updating Headers using VBA
For Each statement
Macro Help
Referring to OLEObjects (combobox's on worksheet)
Re: open Excel workbook using vbscript
VBA capture File SaveAs Event
Want to be able to click on a cell and have a list box appear to give values to populate a cell
memory issues with Excel
Formula not updating
extracting information from populated cells
Macro - square remains on screen
Error "52" bad file number or file name problem
Date format using VBA
Can't change formula to lowercase?
a macro to count coloured values and copy....
Cant find help!
Formula or Code Needed
Re: union method for non-adjacent ranges
excel 2000 append field error
Calling Solver from VBA
Cells Method Question
DisplayFormulaBar = True
maskedbox text to listbox
Excel 2000 VBA recordset manipulation
calculating minus working days
Re: autofill with dynamic range
VBA code
Bond amortization
Page Size
Timers
Re: Programmatically Add Reference`
Re: union method for non-adjacent ranges
Re: union method for non-adjacent ranges
Re: "Application.DisplayStatusBar = True" => ERROR
Re: "Application.DisplayStatusBar = True" => ERROR
Re: "Application.DisplayStatusBar = True" => ERROR
Re: A few problems Programming to the Visual Basic Editor
Workbook-Events don´t work with ChartObjects
ensure backup function occurs once a month
Creating an array from non-contiguous ranges
Auto delete all VB forms in current excel doc
autofill with dynamic range again
Calling variable file name
Direction for looping through a Selection.
Updating date
loop thru auto-filtered list
changing font in message box
Module Code Needed
sorting data in string
Saving a file within a macro but only when it does not have a read only attribute
A solution regarding "non-authorized" users
Copying Down and Across
Exporting from multiple worksheets to single text file
getting the date a directory was created
Color of Menus and subMenus
thanks a lot
Shift+Shortcut Key does not work
Toggle Control & Formula
Initializing variable vs. comand button
Re: trouble with cell choice
Correct a Stock Option Download Script
Generations Code Help
Excel screen resolution query
Closing a workbook with no alerts
messy text file-- how to automate import?
Migration of Excel97 to Excel XP
run macro on opening of workbooks
Excel in IE help
Re: Programmatically Add Reference`
Copy Data to Rows instead of Columns
dynamic value insertion - possible with menu??
ComboBox Problems
Type Mismatch Error Need Help
Command Button problems
Auto Importing of text fiel data
Re: Message Box II
Re: combining to cells and on one keeping date format
"Incorrect Add-in Format"
Add-in causing 'GHOST' cells to be selected
How does "Private" work
comma s separator text file
Windows Login Password
Re: SendMail and BCC
Create a background VBA Timer
Re: Autofill last row?
Using InputBox to change query criteria in Access
Help > Need VBA Education
entering formula using VBA
help with worksheet change event
Copying data down to next dirty cell, then copying that data
Re: Time less than 1 second in xl/vba?
default location for files open commands
Update Excel locked cell
Macro vs Manual save event
Calling Word function from within Excel
Screenshots Pasted into Worksheet
Simple Insert Picture question
Search orkbook
reformating worksheet
Macros
How to detect a col/row deletion?
Compare names in two different worksheets
Re: Can I disable Save?
Re: Form Control
Saving listbox values to a sheet then repopulate
AutoFilter Output
Runtime Error 1004
Disabling Shortcut Hot Keys
Datalabels on Scatter
shorter way?
ComboBox
Conditional Subtotal Macro
autosave
Excel pagebreaks
Multi Nested Menus
pivot chart formatting?
Have a list of Environ variables?
Macros in Excel and Lotus
Macro to protect with pword in 97
Append current date to filename
Disallow Copy/Paste Worksheet
Sorting
Formula or VBA code help
RE: Can a Macro...?
Hiding Macro from View
Userform.Activate
Filename search using Office 97 with Windows 2000
Re: Keyboard Shurtcut
Re: Keyboard Shurtcut
Comparing Worksheet ranges
sending email in Excel
Re: VBA code to delete VBA code in another Workbook
VBA Functions accessing value from worksheet
Re: Command Button problems
Automatic response to message box?
VB6 - ADO - Excel XP, cell formated as text
Re: Active worksheet's index number
how do you SUM in VBA code
Re: Userform.hide / show
MACRO Speed?
Re: e-mail range of cells
Quick Q about time in VBA
Coding a HyperLink
Turn this into VBA code
Re: Function not working quite as required
Defining Range
sub for reading
Calendar template
Excel to pdf by code
Referring to a local or global variable or constant dynamically?
Re: Function not working quite as required
Re: Function not working quite as required
Re: Sort and copy database
Application Error when running Macro on Workbook open
problem with selecting something
Re: Sort and copy database
Re: excel search a sheet for a value
Copying a file with VBA (or with a SHELL command)
Multipage control
How to sort in the worksheet?
Appearance of Data fields in Excel Charts
format compare
Fill Textboxex with Corresponding Record
More than one cells in row & column input cell
Looking for a cool book regarding Excel VBA Programming
Insert Date value in PageSetup ??
open/save excel on a local web page as an activex
returning an array from a custom function
Re: Prompt user to select file with default file selected dialog
excel forms
Excel running really slow on my machine
turn off messagess
Bolding specific text
macro to respond to clipboard prompt?
Sort and copy database
Macro to update Pivot Table
I need a macro that can copy
Re: on open goto cell with today's date
Re: How do I insert/update VBA code into a sheet? (using a CLS file?)
put zero value to unprotected cells
Copy only the digits from a cell
Form versus Control
Re: Prompt user to select file with default file selected dialog
Re: Prompt user to select file with default file selected dialog
Beta - unprotecting multiple sheets
text box tab problem
Excel and Text Files - Extracting
INSERTING ROWS WITH A MACRO
Query Counter
Link Problem
Several simple questions
Linked worksheet Query Counter
Selecting a Range Using a Variable
Duplicate Subroutines
Set Target cell is not behaving
Re: formatting a TextField as DD-MMM-YY format
q Faxing From Excel Using A Macro
Using the output of a formula to name a workbook or sheet
labeling
Time Format 0000 to 2400
help reducing lines of code
Re: default page size
Range only works when Sheet Name is "Sheet1"
Re: Strange problem with reference
UserForm1.Textbox1.SetFocus Question
Re: Hiding Rows in EXCEL (Conditionally)
Re: Hiding Rows in EXCEL (Conditionally)
Re: Forcing Correction of User Input Errors
Excel old style 4.0 macro
Dynamic Excel spreadsheet
Sending spreadsheet as attachment
scroll wheel
counters
.xll is not a valid addin
Excel only runs in Safe Mode.
Workbooks Index (Excel 97)
How do you refer to a dynamic named range?
Re: read the values in a range and store them in macro
How to suppress Time ?
Checking If Hyperlink Is Valid
Autosort Problem
Forcing a FileSaveAs
Workbook_Open() error
Timer Update
Re: Sorting sheet and linked cells
VBA: Pausing Code Execution
Database Form appearence
Activate event
Almost there
workbook icon
Proper syntax to Set a Workbook Object?
Re: Help with Excel97 formatting
Re: Subscript out of Range on Range reference
Union Query from Access
Disable close button of Modeless Userform
Re: Help with Excel97 formatting
Re: Excel Formula/VBA Code Help
UpCase in userform
Re: no x close 2
Re: Stops executing or keep looping
no X close
Formula dependant on month/date
How to add a tool bar to a spreadsheet
ComboBox filtered on partial match?
Testing for Screenshot
Re: VBProject events?
Documentation on the "DropDown" object
Workbook Events
Re opening Excel 2000 lost work book
auto protect or run VBA?
*** Password input?
Test for 3 types of data
contact data in column to rows
Re: Change hard code to Variable syntax
Re: Change hard code to Variable syntax
Delete Display Alert tagged to an individual cell
X, Y Graph
Excel 2002 Macro Run button disabled?
Re: Column Sorting
Excel "IF()" Statement Help????
Re: Form Control
Re: Help with VB code please
Re: Add-In Password when closing Excel.
Immediate window question
Re: Over protection in 2002 XP environment
Enumerating a multi-dimensional array
SendMail and BCC
count if question
Re: A mixed bag of questions
Time Sheet and Comp Time
Re: Enter data into a cell and dynamically update another cell
Re: getting same save-on-close macro to work from different networklocations
clipboard info
Label Caption Just Wont Work on UserForm
Re: Enter data into a cell and dynamically update another cell
Selecting rows with variable
how to switch on relative cell affressing
search for a sheet
VBA code help!
Exporting to PowerPoint
Re: SaveAs
Intersecting/Unioning Collections
Stripping Numbers Down to Bare Minimum
Text Import Wizard
Delete Code from Worksheet
Re: autofilter...
More info needed on deleting macros on save
error in my VBA (newbie)
fatal error
Fatal Flaw
Re: Buttons assigned to a macro
HELP!!!!! Date Calculations
Fatal Error in Excel with one line in a macro
Re: executing tasks prior to saving
VBA and multiple sheets
Open Ms Access File
do a `down arrow'
FTP
Re: 'Calculate' message at the status bar
Validation by counted chars
Re: macro save given range to .xlw
RTD in C# example?
macro error "can't find project or library"
Re: executing tasks prior to saving
Re: executing tasks prior to saving
Re: error 1004 Select method of Range class failed
Re: Text Box Format
VBA- Calendar Control Click Event W Specific Select Case requirements
Re: find the first cell in a list of dates for January
Delete Characters in an active cell
Need help with Search
Null value return from combo box
Re: find the first cell in a list of dates for January
Excel Spreadsheet Submit Button
Re: Text Box Format
NumberFormat Difficulties
Re: Run Time Error "28" - Out of stack space?
Re: Controling cell references in formulas written from VBA
Is there a quick way to see which objects have code attached?
Excel & SAP CSV Integration (Chip or someone else)
macro button refers to prev. workbook
listbox-combobox category
all cells in range > 0
If y = x Like "x?" Then
shift+(key) to run macro
progress message
run program
Put a value into variable
Cell right next to colored cells is automatically colored on entering a value
code to clearcontents of "0" values in cells
Run Procedure when Excel closes
How to set sheet1!cell = sheet2!samecell and set format?
Re: Countif
Re: copying areas and macro loops
Copy from worksheet to worksheet with Macro
A good macro that works wrong with keyboard shortcut
clear, copy and paste
Retrieve an array from a function?
How can I do this in a macro ?
Must match two criterias
ODBC
VBA and subtotals
MSG Box Repeating
Re: validation lists and protected work sheets
Re: TextBox SetFocus Problem
Selecting a cell
Adding text to a text file using an inputbox
Copy Range to new workbook
update depending on date
Language settings
email cell
AddIn
Sorting related numbers into defined groups for averaging
Sorting related numbers into defined groups for averaging
How to copy a file already open with VBA ?
Sort help
Re: Recovering the hyperlinks within the VBA Help File
Dynamic Form
how to randomly alter thes figures?
Making executable files
row source
User forms
Formula produces wrong result when data cells filled programmatically
Re: next cell
Re: Edit worksheet while a user form is on?
Re: Office 2k Excel.exe performed illegal operation??
Re: How to detect an insert/delete?
Re: The text length versus the cell size...
Re: checking for EOF in excel
question about "swtich" function
Re: Strange Cell behavior redux
Re: Strange Cell behavior redux
Make a window stay on top
Removing text
Re: VBA Help in EXCEL
Re: Ambiguous Name Detected:~
Re: relative path.
Macro update
Changes to UserForm do not "take"
combo box
Re: This May Be A Challenge
Re: This May Be A Challenge
Re: Help with a Loop please
UserForm - display text message then run code
Found a macro, but don't know how to use it
DDE Links using Microsoft Script Editor
Putting an image into the clipboard
Excel Printing Service
Possible?
Cant Update Boolean and Dates To NULL with ADO
Tips on selecting SQL data into a worksheet?
Marcro updating cell that is "locked"
How to force number formats ?
Passing a dataset from jsp to browser excel plugin
ser form question
Programmatically detect wrod-wrap?
auto import to multiple spreadsheets
Re: Excel functions?????????FIRST TIMER
Excel functions?????????FIRST TIMER
Selecting non-adjacent rows
problem with wkbk.VBProject.VBComponent
Re: Select Case in VBA not working
Question for Experts: Opening workbook with workbook references
Re: Count files in a Folder!
Ole commands using borland C++
Looping trouble
Running from web error
VBA: open PowerPoint and paste a chart
Re: RefEdit does not behave like Excel's built-in reference edit boxes
Re: Count files in a Folder!
Re: checking for EOF in excel
Mail merge
Read / compare MS Access data in excel
Extracting Specific Information in Cells
Transferring data between worksheets
Customize options in a MsgBox
Pages
Single vs. Multiple Workbook Performance
Summary sheet help
Code to refresh macro once monthly
RefEdit does not behave like Excel's built-in reference edit boxes
Automating GoalSeek - why doesn't this code work?
VBA: Sorting arrays in hierarchichal data structure: Help!!!
Copying on a filtered column
Printing based on a value of a range
Moving Columns
Checkbox values from a web client
Re: Macros Library
Re: Use button name in VBA procedure
Setting up data validation lists
Post file to Notes database
Printing vba code in Excel with row numbers
Cut rows from one sheet into multiple sheets based on a criteria in first column
VBA code scripts in macro
selecting sheets
adding restrictions on action Double_Click
"If column is empty" not working
90 min -> 1:30
SendKeys and Path Problem
Combobox; Display all entries when the down arrow is clicked.
string truncation
Cells to Columns in Text File
help with range in vba function
Open saved web page with ie
undo what a macro's done
All Sheets Unhide and Select
Is there anyway to shorted this formula, using a macro
Leave hidden rows out of sum
Re: counting a value within a range
Converting text to pdf file using Visual Basic
Find Personal.xls
Office Web Controls
add right aligned tab with dot leader to word doc from excel
autofilter's events
Excel Viewer 2002???
MidArrowheadStyle?
Print Ranges when Print_Area not set
Excel Formula or VBA code help needed
Excel 2000 and vb6
Excel process remains running
Same code in several sheets..
Re: Problem with VBE Menu -- Tools >>References
Graph with two scales - calling a graph expert !
Re: Hex to Binary conversion
HOW TO: Delete Rows with a Macro
Shortcut Keys
Re: Check if pivot already exist
Re: Check if pivot already exist
Top 5 customers
How to read sheet of currently opened workbook
ADO Recordsets
Finding negative numbers quickly
Re: Chip Pearson or someone
program speed problem
Re: SaveAs
Limiting access to a worksheet
Macro causes Excel to "not responding"
Sort_Organize two lists of variables
Macro for "Retrieve" in Essbase Menu
duplicate names
Combo box sorting
Programmatically changing cell color
VBA Help
Re: Unprotect a Workbook
Re: Textbox on a userform.. dispaly as currency
How to add via programming ?
Re: Range as array
Problem wirh excel
Re: Range as array
Re: Password mask
Digitally Signing Macros
multidimensional lookup?
Interpolation Visual Basic Macro!!!!
Stepping thru Cell References
Specify font for MsgBox display?
Use / Import Win32API in Excel macro
Re: Saving Range Locatoin into a Variable
Re: Date formating
Re: Saving Range Locatoin into a Variable
Re: Date formating
how create new rows
Re: Creating a shortcut
checkbox
Solver activates other worksheets - why?
Re: Input Box
export to word without tables
using VBA to go back to the original value before the cell was changed
Password mask
Help....
Visual Basic
Worksheet_Change event question
MS Excel - How can I summarize a table? Will Pivot Table Reports do this for me?
Workbook_SheetChange will not fire
Convert date to serial number in VBA
Consolidate Worksheet Data
Re: Multiple If's, one variable. And filename as cell contents
Re: Userform text box
shared workbooks - protected worksheet - insert rows
Re: Multiple If's, one variable. And filename as cell contents
Use VBA code to open a text file with the import wizard
Re: Multiple If's, one variable. And filename as cell contents
Builtin Properties
Comparing a value to an array
Pivot Table or Table Summary Help Please!!
Re: Macro to Print to a specific bin
Creating a Sendmail message
Question about user forms
protect formulas
Saving Registry variable to ini file
Enabling a Embedded Control
Excel.Application Instantiating Different Versions
Excel 9 XML file open
Re: Cell = cell value AND format
FLOATING BOX
Macro Security Error No Macro
Forms
selectign a range
Re: UserForm Calculator
Re: Need to detect cell shading
Adding a row to a subtotalled range
Re: Need to detect cell shading
Re: Conditional Macros
Programmable Web Query
VB Code to Add Comments to Cells from Several Other Cells
Re: Enabling a Embedded Control
Hide Macros from Users
Re: Cell = cell value AND format
Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH
CRUCIAL: Creating a Custom list 40,000+ lines????
Re: Switching userfoms
xlCoerce on multi-part xRef
AdvancedFilter Criteria question
Macro button
Sequential numbering on a form
Re: Recordset
Re: Operating system
Re: does a file exist?
Re: Operating system
Property Get with argument
Re: Conditional Macros
Pesky Ckeckboxes !
Re: Calendar
Application.GetOpenFileName
file names
Saving a file in a macro
Dropping leading zeros in character fields.
Re: find a cell, jump to next roll and clear all cells
Write a function call into an Excel cell from VBA
VBA Query
Combo box
File System Object
Load a Userform
overriding the print button and File/Print
Selection of range
Re: Thankyou
Re: Sorting players of cards
macro problems
Use of ROW() in array formula
transpose/rearrange data
Does formatting raise an event
mscal.ocx
Importing from MS Project -- problems with commas
Re: Called macro runs twice in excel 2002
Re: Simple conditional macro
Re: StatusBar Msg?
Lock cell in ASP
Change to SQL of Pivot Table on shared data
Re: AddIn
Sending an Outlook e-mail due to a condition in a cell..
screenupdating command ignored
Re: VBProject events?
Chart embedded in UserForm
word table
mot de passe (programmation)
Re: New to Macros
[Help!] CSV(s) --> xls
MsgBox saying Excel is calculating
Cannot Paste formula to cells via VB
DV error message with a cell value
Counting 2 Separate Columns With Unique Data
Numeric data on forms
Excel Programming
searching for values in excel and copy them to another worksheet
How much data could be entered and search trough
Excel Programming.
How to call SolverSolve portably for Excel XP and Excel 2000
Probelm with Data formatting
Password feature in command buttons
How To Change rowhight or columnwith long measure?
Re: Clearing the 'Recently used file list'
VLookup error message while accessing range in closed workbook.
Excel Programming in VB
Limit input in a textbox
Delete Pivot Table
check if a worksheet exist - VBA
Appending Excel file to an Access table
property in objectplaza
delete all EMPTY cells along each COLUMN
Excel 2002 VBA App fails in Excel 2000 Environment
xl97 and Worksheet_Change event ?
what is the difference
EXCEL As VS.NET Math Engine
Re: PASSWORD PROTECTED FILE
trapping keys when pressed by user
trapping keys when pressed by user
trapping keys when pressed by user
trapping keys when pressed by user
trapping keys when pressed by user
Re: How to keep a Userform available while the user interacts with a spreadsheet
How to detect an entire column/row delete event?
VB app and Excel: Deployment options?
Copying varying values down through rows
VBA to save range as a HTML fife
Re: how to enhance this macro (really short)
Re: User defined function & formatting
Turn Button On
DLL - Using a DLL to update cells in excel
editing text in contents of joined cells
Re: Copy cell value from another worksheet
Creating FileSystemObject
Getting data from one spreadsheet to another
Controlling Outlook from Excel Using VBA
XL:2000 - VBA Sum Formula
Re: How to get User input from Userform Text box
Trying to add a row after the last value and count
Re: Coding Assistance
Over-Eager code is pasting 3 times
Creating mail message with a button click
unable to create embedded object on a userform
What have I overlooked?
MsgBox and User Input
Passing Parameters through OnAction
Reading a cell into an array
Data I have Excel 2002 as part of Office XP Standard. I tried alidation, I think
Re: Retaining text formatting in TextBox
How to get Maximize and Minimize buttons on Userform
Re: VBScript Automation of Excel Spreadsheet Sorting & Filtering
formula in one cell needs to use a figure from another cell but it crashes
Macro for Sorting
Re: How stop the navigation to other cells?
Re: temporary cell format event
Re: testing if a sheet is protected
Checking if a workbook is shared
Maximum text length?
Re: How stop the navigation to other cells?
Pivot Tables - Refreshing with data??.....
add a menu bar when document opens
Re: Toggle ShortCut Key sequence
Re: Deleting blank lines in a range
Re: Excel macro
whats wrong with my array?
Re: Using Network folders
Re: Deleting blank lines in a range
adding items to combobox using "Tag" control to limit
Validation against two criteria
Re: A Problem with ethernetdirectory
Re: Please help !
Re: Excel macro
Runtime error '327'
Re: using mid and find
Navigating cells in VBA
ComboBox.Value To Range
Retrieving Source Data From Pivot Table
complex Cell
How do I programmatically know the current cell's address
Could one of you experts answer an easy question...
Row number
Re: error 1004 - metod Copy of class Range was failed
Find button on worksheet
Re: time serial number problem
compare values between workbooks and copy values
Excel Vba Books????
Re: Class and object persistence
Visual Studio Tools For Office(VSTO)
Autoexecution of a Macro
OWC10, XMLSS and Excel97?
VBA Number Rounding
Changing Reference Dynamically
SaveAs without name change
Re: Dynamic DMax criteria in VBA
Error Message
Protect sheet with filter
Problem with formula - Taking too long for calculation
Disable commad bar options
Protecting data rather than certain cells
finding duplicate data in multiple spreadsheets
format values in MsgBox?
combobox
Date Flag/Trigger
Re: Excel Programming in VB
Re: Get Object
Print2PDF with "ChartTitle" as name
How Is This Done
Image in a header
Excel Programming in VB
Thanks stephen
Allocate Files to Sheets and Build a Master Sheet which Summarises All Sheets
Re: library not found?
Re: SheetChange event starts before .calculate finished
Number of days between dates (Calendar)
Error
generation of word file
Writing "shapes" to disk file
time limited add in
MACRO Relative Reference
Use Excel as Maath Engine for VS.NET
multicolumn Listbox and textalignment
Re: getting same save-on-close macro to work from different networklocations
Not-so-simple Find task
Re: Excel references in another program
Auto load macros
Re: Excel references in another program
setting formula property
VB code to find the selected cell
what's wrong with this sub procedures?
activesheet - select rows
auto copy
Drawing toolbar appears when it shouldn't.
Re: FormatZipCode
Gurus: What's wrong with this code?
text conversion in cells and setting color in rows.....(excel 97)