Excel Programming [Archive] - Page 159

Calling a C++ DLL which returns a String
Confirming existence of dependents
Lookup a value based on two keys
Blank rows appearing at top after sorting
xlSheetVeryHidden issue
Contracts....
Excel - VBA Error
Excel-VBA Error
Modeless property
Copy from User form to Sheet macro
Cell Address
Error accessing the system registry
calling seriescollection by name
Sort and Add Columns
edit/find menu in a macro
Macro forced to run by data?
Endless Loop when using ComboBox1.BoundColumn = 2
Range help
VBA to create an Array of all Sheets in workbook
How do I calculate percentage from seconds?
Onkey Error
runtime Control and code in VBA
Mail Worksheet as (html) message body
Problem with FIND
Change the "Delete" key to "BackSpace"
Another simple one!
Change the "Delete" key to "BackSpace"
office icon
Excel to Access
Database function / formula question
Generic questions about variable scope the Initialize event
Coloured Cells and Dates
Problem with Data Validation not working
Sum of Rows when columns are added
Accumulating elapsed time
VB user forms
Set print area with code
Conditional formating
how to speed up excel workbook
Banding - visible rows only?
userform
IF statement macro
Passing Values Syntax
Enforced entries code
worksheet function to vba
List Box properties
Multipe sheet search
Print Preview all pages at once
Deleting Sheet without message box
Calculation on array in VBA
Dialog Query
How to modify the comment pop-up behaviour.
Combining Files
Confirming existence of dependents
How to find first and last cell in a Sheet with an entry
linking cells (2)
linking cells
Urgent: How to use CheckBoxes in ListBox
Screenupdating
Determine the type of currency in a cell
Excel VBA - Calculating average problem
Need help to find the last row of data
Forcing Integers into Textbox
updating links when vlookup is used and..
Cursor Tab Order
Need a macro for selection and sort
data transfer between VBA arrays
I may have found (yet another) bug in Excel
Application.Match with Times
Application.Match with Times
Macro help, again!
Can this Macro be done?
Printing only what can be seen
Create custom function and add to the
Importing/querying data from .mdb file into Excel
Identifying Bottom-most Entry (And Other Questions)
Quick VBA method for looking up data
Need to combine first and last name from two columns
Run a macro at startup
Extracting email addresses from Outlook Contacts
filename and path as constant
ScreenUpdating Problem
Cell A1 in Upper Left Corner
Organizing words, willing to pay $ 100
Program
Cut Paste Undo Failed
Code Run-time error '1004'
Switching woorkbooks & and invoking a macro from within a macro
XLA Unload problem
Saving Workbook in Visual Basic Hides the Worksheet, Why
How can I modify the color of a cell?
Number Switch Code
how do you loop through each worksheet?
S1.Range("D65536").End(xlUp).Select
Code using Format Function
how can deactive cells to input data
how can deactive cells to input data
Visual Basic For Applications
I lose my content of MSDN332.inf and msdn331.inf
Lookups..
Installation error Access add-ins
VBA AVERAGE formula, ignoring zeros
Automation error in win 98
Multiple hyperlinks via macro?
Position of Cell on Screen
Compile error: type mismatch
dynamic arrays in excel
File Name List
Password to get access to certain sheet
Trouble with columns and for each
Create and Link check box with autofilter and sum, average of filtered raws.
Ignore formulas
Get a value from a list (Database) aka DGet
Fastest way to do this?
Back Button Macro
Deleting the spaces before and after a number in Excel 97
Disabling Macros
"Run-time error 91: Object variable or With block not set"
MID macro
How to upload the file to Yardi Program
Need a Basic tutorial for Excel VBA
Additional toolBox controls
Protecting Multiple sheets with prompt for password to unprotect
creating dynamic mirrored worksheets
Numbering Add-in
Excel 2003 Bug!!!
Array <---> Range
disable the worksheet read only temporaily in VBA
show the working file
Toggle text to be visible and not visible
excel
Icon change
Writing Array Formulas in VBA
Selection.Copy Destination:=
VBA and Autofilters
Simple Listbox question - how to remove items
Error using "Calculate" function in VB
VBA References List
Problem pasting a row from a hidden sheet to the first free row on another visible sheet
Macro to Force Response in Dialog Box
Move Cell to Top/Left Position on Screen
Excel Limitations
Macro help, again!
Array and Named Ranges
Newbie : Help with sort via Excel code
application.quit will not shut off application
Linked table message in VBA
Need a macro to delete selected rows
Cell reference
Arrays
VB project protection
Value of a cell in a range if color is yellow
Text box
Re: Closing the save changes box
Rename active sheet
Creating a macro to use the text import wizard
code for having sub rows
Help with conditional formatting and referencing workbooks...
Formating column cells
scrollbar control of a chart, live or not live
Retaining Formats
Automatic Sheet Name Read and Rename
Advanced Programming
Find, Offset, Enter Number
Basic Macro help needed!
Closing DOS window after shell command
Toggle Text to be visible and Not visible
Automatic word wrapping on the formula ... don't know its name
Re: Run-time error '11' & Run-time error '1004'
PERSONAL.xls is opening as active when Excel starts - why?
Before workbook open
How can I distribute Workbook with VBA code and library references to other computers
Macro to quit excel and go back to original application
FBI IS TORTURING ME - PLEASE HELP
Seriously need help
First Sheet,First column as template
Getting rid of all negative numbers on a worksheet
Installation error Access add-ins
Add signature to files exported to Outlook
ComboBox on worksheet-strange outcome
Re: excel 97
Tired of Excel's Interface limitations...??
Hiding toolbars but keeping the Windows Menu Bar?
Run-time error '11' & Run-time error '1004'
Need help.
Can you hide forms checkboxes
Msg Box Qquestion
Query OLEDB Provider for Excel file info?
Pivot Tables
Filling a cell with values from another worksheet
Macro to save file
VBA : VBA code for summation formula
code to hide check boxes
Locking other cells based on values in a cell.
macro that closes excel application and open another app
Search code
Web Query Parameters
Re:Macro to insert and delete rows
Type Mismatch
using SaveAs to save 'only' one sheet from one book to a new file
Change directory for DOS window
Select certain rows of sheet & delete the rest
office web components error
formula for avarage with a variable divider
Macro to Rename Multiple Sheets
External Database Lookup via ODBC
Personal.XLS path problem
Where to put code
Identify Range Selected By User
Re: web query
Re: Closing the save changes box
VBA problem -
mutiple strings from a drop down menu
Text file closure
Where to put code
Using FileSystemObject to get File
Possible?
xl Dialog
Excel currency
Transfering Acces Tabel to Excel with Visual Basics
Change Autosum to use subtotal(9,....) ?
Search for common data lines (loop)
Multiple workbook recap
Different Values & Printing.
Sinple one.
Trouble exporting chart to htm file - need help
help with code
password recovery
Lookup Tables
Macro to insert and delete rows
Events in Excel for executing functions
Visibilty cntd
Auto_Open/Close Mods
What's new in 2003?
Running out of memory
A Question for Ron de Bruin
Multi line Select Query
Visibility
How to delete a row depending on a script
vba function description visible in Formula palette ?
Can I toggle this Code - to Stamp and to UnStamp?
help with algorithm
How to DISABLE THE CONTROL BREAK shortcut keys
Coding help needed
Search more than one result
Pre-checking checkboxes in a dialog box
accelerate in loop
Newbee Q: How to make search field in excel sheet?
message box while macro is running
Why my cell format is not copied when I copied workbook?
Using same code for Multiple cmd Controls
Looking for some source code for navigation bars
3 conditions if else statement.
how to add message box after a macro is completed
date in color
username and password for form excel vba macro
Someone please Help!
Multiple commands from single IF.
unable to edit macro!!!
Move a sheet
macro disable and enable.
How to Cancel a Save?
Anywhere to see list of predefined functions available?
Programing with a "Find"
Help, Unable to start Excel
Help with Run-time error
Removing and replacing toolbars...
Re: View the data in a cell on a userform
Tracking changes made in cells
Removing a user form with code
Upper/Lower Bounds
Upper and Lower Bounds and Rnd
search value not formula with .Find
Parsing data - variable length cells
Help with the basics. Starting out.
VBA-Graphic
Run module ON OPEN event??
Ascii file import round 3
Still stuck with importing a delimitted file.
Want to hide check boxes
Delete empty rows in a worksheet
Coping all cells with data.
Change Cell Data of a Required Column
Newbie needs help in VBA ;creating a click() function
Compare items in 2 ranges
Simple hiding columns with vba does not work with a checkbox
Newbie needs help in VBA
Macro Help / Question
Subtotal using VBA
Generating a list of all possible number/letter combinations
Excel VBA - Graphics
Normal Distrubtions with Upper/Lower Bounds
Macro Dialog Box Help
Copying Data onto sheets
Rounding Logic Question
MultiPage control: Easy question
Where do digital signatures reside?
Split query
Access Report
Excel 2003: Changing an XML Map
Get…UCase or LCase ???
Identifying Duplicates
ascii file import round 2
VBA with EXcel 2000 and series line colors
Userforms and Print Preview
Annoying prompt: ActiveX and app initialization
Creating a PivotTable Report from an Another PivotTable Report
continue to move data until all moved
Identifying and deleting all but the first and last cells for certain date
Looping thru files
Excel VBA - Trying to change color of cell conditionally
How do I have excel not to prompt user to disable or enable a micro
Macro to hide formulae
Get…UCase or LCase ???
Going Bananas
Calendar Control
loop to name ranges
Option Buttons
Re: How To Get 1 Million Visitors
Excel macro - Help with duplication validation macro
SQL data access help required?
FINDING LAST ROW OF THE DATA
Using bold and normal font within one cell
Simplify
All open workbooks
Creating an "update" button and using a macro to copy data from multiple sheets
VBA Excel Function
Alternate to Range.Find
refering to option buttions
Write new VBA code from within a MACRO
reading variable "from" and "to" ZIP codes
Get address of cell clicked
Re: Unhiding rows in Excel 2003
Re: Driectory changing
Add spaces to end of field in save as PRN
Hyperlink Macro-links to other excel files
Macro to Start on a New Line Each Time
Excel Embedded Links
reverting to first page on exit
Deploying a .NET add-in in Excel 2002
Clearing shading before printing
Changing from lower to upper case
Removing duplicate entries
Creating Specific Excel Formula Question.
Date format on import
Requiring Cells be Populated
Reading the pin voltage fm RS232 port into excel by using VBA
Converting Values
How to find out if a button exists on a sheet
PivotTable selection
Problem with quitting Excel opened through automation
Bad or Missing References
why doesn't this work?
Installing XLA on Win200 Server (Office XP Developer)
method vbproject of object workbook fail
Hyperlink
Macro Error Message
Macro Error Message
Sum Filtered values
Fixed Columns
VBA created formulas won't autocalculate
Toggle Text in a column to be visible or not visible
Macro with in a formula
need a loop
Passing SQL Query Result Into A Variable
Application.WorkSheetFunction.DafeDif (not DateDiff)
Adding all the data to one sheet
I can not find the msexcel.olb file for Office XP?
Buttons Control Tip text
Find First Cell In A Range
Assign macro to button in EXCEL 2003
Re: Other undocumented VBA changes?
Function Definitions
Passing Values to Function
Excel Macro Help!
Custom ToolBars
Msg Box Question
Inserting rows macro
ODBC connection by udl
Using classes defined in an add-in
Copy without borders!!!!!!!!!
Need a macro to run sort automatically
Excel VBA- Get user input, search the for match, output to text file
Help with Solver
Opening Files based on list
Comparing two times (HH:MM:SS)
Pass string as Parameter in OpenText method
Loop command in Macro
Can we Pass String to FieldInfo Array to OpenText Method.
Com with Word
System asks to save when no changes made?
Adding colour background to control
Opening a text file for input
Find Value in Array and report on Location
Check for sheet name
Error with Target.Name.Name in Worksheet_Change event
High Tech Question ?
VLOOKUP with a Boolean membership condition??
Excel hangs when trying to open a file
Copying workbook
Macros to hide/protect formulae
Replace Functions not working
Import ascii file
Question about scoping variables
EXCEL FILESEARCH
tickler for date + 180 days
Query Sheet using a WHERE clause?
Offset function with merged cells
Export method question -- Spreadsheet ActiveX component on user form
ActiveCell not recognized
help with user form that won't go away
Exceeding the limit of Nest IF's
Comining lots of functions into one User defined function
OptionButton type name?
How to references objects that exist on local or network drives that aren't open.
Cells().value is null but I can see data
Protecting & unprotecting worksheets
Calling functions from Excel worksheets and the Find function in XL '97
auto fill columns
Control on worksheet to display 2 col's of data
close work book via macro
ReDim Problem
Command Prompt
When to use .INI files
Re: Using a macro to write modules
Switch between workbooks
Using a specific range to populate a list/combo box
Re: Using a macro to write modules
Copy value and fill blank spaces below it until new value is encountered?
Open File with Links?
App Close and File No Save
Creating a dynamic list
PivotTable selection
Installation error Access add-ins
Digital Signature
Help with the Excel-object
VBA DAO 3.6 Database - How to release resources on the PC after multiple Queries
Macro to protect/hide formulae
Using cell color as condition in equation
Range of cells
Tricky vba Raffle Ticket Problem?
help with type mismatch error
How to loop through all ranges in a worksheet
Macro or VB HELP!
VBA reference error
formula for rounding
Easy Q: Visual Basic and Excel
buffer overflow
VBA Code statistics
Run code for multiple worksheets in a workbook & Column Formatting
Retrieving data from Access via SQL/ODBC
Trying to *simply* programmicly get a bmp file to be the plotarea backround
Error trapping don't work
Control on worksheet to display 2 col's of data
Code Bug
Macro to protect/hide formulae
copying sheet with macro
Excel VBA Calculate Problem
SUMPRODUCT QUERY
Creating a Data Entry Userform
Saving template as non executable file
Listing External Worksheet references to your sheet
FileSystemObject CopyFile with UserID/Password
New Workbook New Session
reading/inserting variable dates within a macro
How to trap the error message "Remote Data not accessible"?
Find, Lookup, who knows???
Sorting data based on validation cell
ABS Excel Function
excel sqr function vba
.saveas and .close methods from Access
Protecting and Unprotecting multiple sheets
test
Finding last number in cell
cleaning up a field
Creating a PivotTable in a Different Workbook
xlDialogFormulaFind Dialog Box
Emulate C/C++ struct in VBA?
Excel database access
Importing a Directory Listing from CD to Excel
Text box on userform
SumProduct function
How to run a macro in word web page
Bi-weekly date calculation
Set No of Sheets in new workbook
Excel and Dbase
calculation in menu/tool bar using option buttons and pull-down menus
Filename with current Date()
Controlling Word from Excel
Re: Filename with current Date()
Week Numbers
Modify duplicate code
Printing non-adjacent areas on seperate sheets in one print job
Combo Box Question
Crash Using Watch Window XL2000
Pivottable, month, sorting
Concantenate using VBA?
Copy Sheet - Paste Values
Macros
Cell identification in x,y coordinates
Excel to Visio to Word
Using datetime fields as parameters in a query...
Help with formula please
Picky/Choosy
Message Box if cell value not in specific range
searching for a null cell in a column
Cell access
color coding largest in a list
EXCEL 97
Counting using conditions
excel windows 97
Changing XL97 Application Icon
Keep cell reference when picking up information from another database
Testing for contiguous cells
Keep cell reference when picking up information from another database
Excel don't quit in ASP.net Code
Excel Programming
auto filter and auto fill
replace doesn't
Visual basic (combining wrkbks)
User selection
KeyPressed Event
How to prevent pasting to every sheet in workbook
Solver and VBA in the same model
Slow Looping
listbox problem
How to wrap text in combo box?
how to run a macro in word
Same code, different line
setting up excel for multiuser
ADO and Excel versions
Removal of spaces
macro to export files but not replace an exsisting file name
How to define a print range?
select last cell in used range
one macro calls the other
Autorefreshing excell external data while opening from VBA code
Solving Circular Reference Formulas
Moving multiple row cells into one row
Prevent entering duplicate cell data in a column
Copy a range of data then E-Mail
Rows and Columns View
Rich Textbox not "trusted object" in Excel 2003
Publish Excel Pivot Chart
How do I deactivivate a workbook?
Calling VBA function that is in another module
RE: Selecting to end of column
Passing a Range to a Function problem (still not working)
Inserting Rows
Excel 4 Macros in Excel 2000
How to pass values from a userform to a standard module?
question
editing code with code
vlookup problem
Excel XP removes AS part of statement
Apply password to multiple Excel Files?
Formatting Codes for header and footer
Creating a Range object in .Net
Subscript out of range when adding worksheet
Comparing text instead of values?
Displaying all the states in a VBA combobox
COM + Excel + Win2k3 Standard Version + IIS6
CopyFromRecordset does nothing
How to find lost macros?
Module Names
Displaying answers that are off screen
How to prevent the MS Excel error dialog by errorhandling ?
Cell Color Change
Silly Question
Using a Macro with the sheet protected.
Input Box Cancel Button
Changing one range on multiple sheets.
Help me make a function dependent on current sheet?!?
copyfromrecordset performance
Information Positioning Problem
Sorting Range Help
string manipulation
Macro security question
automatically fill up a cell?
help worksheet event code
Automatically run a macro when opening an Excel file
elapsed time in msgbox
Need help with check box coding, urgent!!!
combining data from two sources
VBA code in multiple workbooks
Screen Updating
Need help with check box coding, urgent!!!
Color of Cell Background
finding the last row populated in an excel object
Library references
Passing a Range to a Function Problem
Range Name Found??
Printing To A Specified Printer
Applescript Problem
Using up, dwn, end, right, left in vb programming
PASSING DATA FROM USER FORM TO EXCEL SPREADSHEET
macro for conditional number formatting
system error &H8000FFFF
Change cell format programmatically
Protecting Multiple Worksheets
Subtotal and Total Columns
Chip Pearson: A Question about RegServ32 and DLLs :)
Importing fractions with proper format from CSV
Finding referenced worksheets used in a worksheet
Ckeckbox size
Macro To Create Other Macros And Buttons
Detect Password Protection on a Sheet
Declaring as Object rather than Excel.Worksheet
Saving using a path
Macro to Finded Defined Names with #REF
Combobox programming
Password Protecting a Macro
Interacting with Explorer
excel vba interface with outlook (office 2000)
Cell Protection fails with validation lists
Postioning combo box
More questions about variables and procedures...
How do i change the format of a cell based on the condition of another cell in same row?
How set column width using mso-... in style sheet ?
Check Box Macro
True - False
Refresh label on user form with RefEdit
VBA - AutoFilter - 'nonblank'
Recording macro to activate other macros
Progress bar in statusbar
Lost toolbar
Macro or VB Code
Password request to run macro
How do I drop an Open connection in Excel
CSV (Comma Separated Values) delimiter ?
auto filling relative worksheet references
Compile Error in Hidden Module:
combining data from two sources
Sorting into Surname order (alphabetically ascending)
Resetting Excel commandbars on close event
Propogating errors after closing Workbook.
problem with change from excel 97 to xp
help !!!!.. Excel object not closing
Insert row with macr
Multiple excel windows
How do I refresh a form in excel?
Ctrl-v doesn't work after changing Application.DisplayFormulaBar
ActiveX message XL2003
Adding Code Module to Workbook
Help! Please help with my code
Run Excel add-in on client side
Basic UserForm question - please help
Total Line in Report
change VBAProject References Library
Search and Compare two Workbooks
How do I display text in a (popup) window?
Range Selection with Arrows Keys
help !!! please... closing excel application using automation
Autosaving Workbook
<Pass the Torch> from a Closing Workbook
<Pass the Torch> from a Closing Workbook
application.caller
AutoFilter Question
Copy/Paste Function for multiple columns
Loading a web page on a web browser control
passing value with button to macros
Determine File Type
Autofilter across two workbooks?
HELP!!! Beginner needs help with VBA coding
Workbook Deactivate Event
Chart title
New Data Type - Latitude and Longitude Calculations
excel - formula anb VBA
create a user input form
Copy/paste text in cells into a textbox
How to step through top row of a Range object
Monitoring application-level event problem
I'm having some trouble with variables in Excel '97...
Conditional data move syntax
Does an open dialog box slow down or stop a Macro?
COPY MACRO
Class Module Scope
Ampersand in front of font name
MultiPage
Class Modules
loop command in Macro
loop command in Macro
Export PDF information into Microsoft Excel
user's page doesn't show on screen unless a print preview is done?
sub vs. function bhavior regarding 'Workbooks' obj. functions
Excel automation "Error loading DLL"
Excel VBA - Chart title problem
OnChange Event for a Cell
Copy a Sheet without physically opening the file
Force Delete a Sheet
How to verify the existence of a file with formulas in Excel 97?
Excel and COM
Changing data returned from an autofilter
entering individual array formulas with vba
Add a Column Range to an AutoDate Macro
Possible to generate a GUID in Excel?
Source data of a pivot table
using variable as cell location
ADO & semicolon delimited text file?
Disable Add/Delete/Move Worksheets
Last saved
VLOOKUP Issue
Excel Display Problem???
Currency
With ActiveSheet.QueryTables.Add
Count of unique values in a filtered column using 'find'
Re: Add-In - Component not correctly registered
Scroll Bars in UserForms
Functions in Statusbar Won't Display
Excel Addin help!!!
last Cell in a selection?
Error Trapping
Excel 2000 Find without select VBA
Macro Button??
SaveAs command when a file already exists?
Run a macro in the active cell.
Insert Rows Macro
ActiveX Component Can't create object - Any Explainations?
Selecting the first cell of a row
Pivot Table Chart
Variable in a VB Code
Animationen
System error &H8007007E (-2147024770). The specified module could not be found
VBA insert messing up Vlookup and Match
Text Box exit
DAO Nomatch in office xp excel vba
Seperatin data ffom one column into another column
DDE equivalent in Excel 2003 / .NET ? (push technology)
application is not getting closed through automation
Workbooks in multiple running Excel applications
Visible Property
Run Time error '1004' when running Calculation method
Selecting multiple columns
ado connection string for excel 2002
Excel 2002
Shift-Control Arrow and RefEdit Control?
Same macro in two files
How to permanently delete a custom toolbar?
Formula for regression
Cancel in Save As and Open
Time Calculations using VBA.
Q. Pie Chart problem. Want to add series, from another worksheet.
Modifying text in Chart Tips
Excel file embedded in Word doc--limitations of work area
Hide/Unhide sheets
What is the hierarchy of code execution?
How to supress a Save prompt?
Excel 2000 to Excell 97 Vba Problem
Vb Code not working
How to retrieve the name of a picture within a worksheet?
thanks TOM. How to run macros and make the workbooks invisible
(Thanks alot TOM)How to run macros and make the workbooks invisible
Copy from Column to Column
Save As macro
Adding code to worksheets
Code Cleaner
Tom Olgilvy Question
formula for numeric order
How to run macros and make the workbooks invisible
DIM is what i am
How to save each sheet as a separate excel-file
Looping Macro to remove data where value is 0
Userforms - Display result of a calculation in a textbox
Stop Highlighting a Range
vbYesNo
Pasting the same Value into a Range of Cells
sqr function in vba
Next Blank Cell
control element
Creating a User Form to update a list
CRLF in text box
sophistication with graphs
Protect Code
How to view graphic files from excel?
loopig in Macro Programming
Online Tutorials about Macro
Opening A Folder Using VB Code
need to remove zero while joining two strings
DateDiff("w") -- problem
Identifying commandbar names in non-English versions of Excel
Comparing Ranges in two worksheets
How to tell : how many rows a merged Column run over ..
MACRO TO UPDATE CHARTS !
Macro Help
HOW to run marco without displaying the workbooks
Help::how to run macro without displaying workbooks..
cell format
Can't open an Excel document
Auto Save
how to run recorded macro without showing processing excel sheets
Changing Thumbnail Pictures in a UserForm
isempty
DAO Late Binding?
Disable Doubleclick for a range
GetSetting & SaveSetting in Thin Client Environments
4 variables to one sheet, then back to original sheet with answer
Frame Border Color
Re: Re: vba date & data formatting problem
Create Excel Worksheet in C# / VB
print labels diff date on each
Stubborn Link Data/Value Problem - Help Appreciated!
How can I activate a combobox by keyboard strokes ?
Excell 2003 - COM Add-in - Tools | Add-Ins
Print if populated
Restricting cells
how can I insert jpeg file in the cell?
Hide and show
Using Solver in Browser
excel file format specification
For Tom Ogilvy re Copy Sheet Problem
Form titlebar height
Objects and Variables
Browse function
Paste a sheet as a link
Scripting.FileSystemObject LAN
Displaying Cells Comments
Conditional copy & paste
using outlook distribution list from excel vb
UserForm TextBox Decimal Places
Disable Doubleclick
Re: entering data
Chart Fill Effects
Need help with a simple problem
timing a recorded macro
running macro at the background
Compare and Append
macro programming problem
reference an ole image control's .Picture filename?
VBA --- Corrupted xls file
Gradebook and Individual Report
Macro to Open and Compile Multiple Worksheets that are password protected
Common Dialog Error ! (Please Help me ! urgently)
worksheet name
Extracting Data from External Source - Automatically
Detecting open files
Open Windows Explorer and select item
Re: Window Animation
Can you use an IF statement to launch a macro?
relative position in macro
How can I use data formatting in VB?
How do I dedect a right click event?
Send mail from vba with the outlook distribution list
Macro to compare values and return exact matching value
combining 2+ wkbks into 1. Code needs tweaking please
Import IE/WE Favorites programmatically
MsgBox
bug in printing excel worksheet!
data records in a table extracting
tricky rand situation
I need assistance please
Crystal Ball CorrelationMatrix macro
Error when printing to Acrobat
Reference using Excel with VB.NET
Autofilter and protection
extend vlookup
AutoScale on Charts
Module
Create a drop down calendar in a cell?
Invisible/unfindable Comboboxes creating .emf file problem...
Excel linked to Access
Left Worksheet Function
to add new usernames
Re: need command
Visual Basic HELP
creating new workbook from single worksheet
adding a line at the end of a macro to name the cell
Differentiate between "" and Empty in array elements.
Reading information from all workbooks in a folder...
Close file
Re: Width problem with Form
RunAutoMacros does not work correctly from vbscript!
copy all pagesetup settings?
dot value
Declaring a variable?
import array text to row data in excel
How to know the excel's constant
Filter and Delete Picture
problem with dates
Autofilter
Condition added to Sort Code
Running Code looses focus to Outlook and stops
Help please....
Deleting every sheet in workbook after Worksheets(4)
Averaging formula help, please.
Data Entry Validation in Excel
Macro to delete charts
Escape for special characters in string
Message to Tom Ogilvy regarding SelectionChange
problem of asp to dll then to macro?
Numerical Data vs Text
SelectionChange - What am I doing wrong?
VBA reference to Outlook
printing
Comparing two Cells - using Offset and compare - Stuck!!!!
How do you change the default printer?
Remove commas from Windows buffer
opening or activating another workbook file
Re: Window Animation
Run Time Error, FormulaR1C1
Disable Macro
Sum up
FormulaR1C1
UserForm question
WorksheetFunction
FormulaR1C1
Copy Sheet Problem
pivot tables: multiple consolidation ranges
rename folder o files with value from inside each wbk
VBA - Put data in cells
Macro to enter formula with text
Windows XP freeze
selecting multiple sheets
negative value
Excel sound alert problem
Website about excel macro programming
Sheet Protection
Google Search 6.0
un merging
How can I copy the FORMULA in a cell to a different cell?
numbers in words indian number system
copy\paste with vba
VLookup erro
Function return a Date, wrong format
Re: Error of ClearContents
OUTLOOK from Excel
Sheet code
Looking ior the commnds for several things....
Copy for Backup Purpose.
Listview in Excel 97 vba.
Fill column macro that stops
Formatting a ComboBox selection
How to create a macro to copy data from a column to a row in another worksheet?
Making numbers display as currency in lables
Listbox default
Downloading data from a web page
Prevent more than one check box select
missing link
VBA Code Printouts with PageBreaks
Type Mismatch Error help understanding
Urgent!! Combo boxes 2 spreadsheet?? Thx
script for Jolly Giant
Password Macro
Renaming a standard module
SaveCopyAs macro
looping through range and deleting cell contents.
How do I paste data to an variable row?
Text problems
data from combo box in userform to spreasheet???? URGENT!!
Listbox Propery code
Macros Problems
Checkbox Macros
Test message
Conditional statements
Show Macro list (tools->macro->macros)
Macro Writing Help?
How to by-pass password ?
Changing color on a range of cells
VBA Path Confusion between Appl and Personal.xls
Access automation from Excel
Loop macro for a Newbie
DisplayStatusBar when DisplayFullScreen = TRUE
Unselect data in a Listbox
VBA has "lost" some datatypes
Re: Protect All Sheets code not working
Using the Back Button when viewing Excel through an Intranet Browser
ASP to Excel
Embedded option buttons
selecting a range in vb
Formula pasting is not working
I Can't Get VBA to Work
MS Excel 2000 - Data Delete Help Needed
Re: File size problem: standard remedies not working.
Toolbars
Excel sound alert
Pass an ADO recordset
Better Use of Dim statement
Rows ColorIndex
Detecting Macro Code behind a sheet (2)
Directing data to new worksheets
Inefficient Space Removal
pastespecial in vba
Absolute references
test
Copy worksheets
open word file?
Looking for sample of VCR or Navigation buttons for use on UserForms
Help - Run Macro on Calculate
Generate powerpoint slides from excel automatically
Running command button click event code
compile error using Left() function
Option Explicit Error
a string object
Desperate -Lookup function needed!
Find errors
Combo Box Item
find & delete + fill to end code?
Excel random sorting query
Sortin Numbers as Text: How?
ActiveSheet.Copy
Macro for several worksheets