Excel Programming [Archive] - Page 107

error message
Software for Distribution of XLAs
Writing Workbook_BeforeSave into workbooks from an XLA
Command Button Color For Next Loop
Daily and Monthly Average Macro
Excel VBA error
newbe VB application in Excel
Macro Compiles Sheets to One Book...Small Modification Needed
SetFocus not working
Cell name
Here is a tough one!
Macro Help
Paste ranges with offset Excel 2000
help with a do while loop
Using a macro to copy certain cells
Mass Email
vba excel fileopen
Order in which add-ins run
Is this difficult???
loop with array
Using a cell reference to select a worksheet within a macro
Fastest load of new Excel instance
some code help please
Excel 2003 & add-in programming
converting excel to xml
row location
Replacing an Error
sort issue
identify text type: is it a phone nuber?
Sum Unique Values Across SpecialCellType Visible Range.
Populate a ListBox
Userform
Signatures
Please help with passing values
OT - Collaboratons
Weekday in English when using foreign version of excel
Prevent deletion Comments
Loading sheet names in Combobox
Re: Pasting date in a range
Code bombs at line indicated, why?
Stop Macros from Running When Workbook Opened via Automation
Can't make this VB work plz assist :p
Pasting date in a range
RangeFromPoints
Timing loop help please
Help please?
Searching for locked/unlocked cells
Forcing an OnKey
Need Macro for Extracting Unique Name from a Sheet
Problem: populating listbox items
Text madness, Spinbox and Textbox?
Go to an Access form
can excel webpage link in a website be edited at user end
[ann] chexcel -- embedding C/C++ interpreter ch into excel released
loading a form
Info. in a function
Book on Class Module
Completely getting rid of unused macros in XL?
Posting code with IF
Save As Text file
Implant macro coding into ASP coding
Free-standing macros
cell reference using macro
VBA VLOOKUP
The myworkbook.xls Auto_Open() macro won't run if started by a VBS
Loop & add number list
Linkage data between two spreadsheets
supressing system warning messages
excel macro to move minus sign
Userform: listbox and controls' data entry validation
Open an Excel Workbook from either a BAT (or VBS) without pausing.
Why Won't This Code Work????
Macro Help
VB Macro writing a formula to a cell
Charts.Add - Run-time error 1004 pls help
dynamic "this week" macro
excel linked to access
Is there a VBA Event to Detect Change in ActiveCell Focus?
Converting xla to xl COM add-in
Reverse Userform
Excel Icon Programming
Macro: Copying Formula Help
Deleting Personal.xls macro
Correct VBA syntax for cell function formula
InputBox - search for value and jump to cell
get the parent folder of the working folder
Refer to a different Worksheet regardless of which Worksheet I'm i
not urgent
Efficient way to copy a range in numerous sheets within a workbook
excel macro to move minus sign
Select Row of Active Cell
need help with formula
Macro to Merge and Sum Rows
Macros Don't work anymore
Hide and unhide columns
Changing cell color
problem with a named list
input current time
VB Code Works Perfect...but Not when the File is Shared
Pull Cells From Sheets
Collection Issue
RE: IF formula problem
Macro - Need location of XLS itself to be set as default
VBA to zip excel spreadsheet using xp's compression system
Shape Selection Name
need help with macro modification please
Displaying mail with Excel
mixing absolute and relative references
A variable that save its value
Macro Help
User entry correction
Save filename as new file name
Make table query works intermittently
Code running order
help with sumproduct function
Syntax of VBA Code
Clipboard clear
Hide an entire row - Not working
Formula to rank / lookup from list
excel error? - second post
look up for values in the cells
InputMask for Textbox in UserForm
showing userform with excel minimized
Edit multiple workbooks
Help With a Looping Task
Compare values in 2 worksheets
Automating XL charts from VB.NET 2003
get selected row number
Toggle AutoCalc
Wondering if....
Help With a Looping Task
Password removal
For Each offset range
Array of files
Grouping Sequential Numbers
Capturing Decimal Values in Variable - Losing decimals when summin
Separate multiple entries in cell to individual cells
Scrollbars on a Userform
Goto Button
Visual basic 400 error in IDE???
UpdateLink giving error 1004
Deleting Sheets Warning
Make Table Query into Text File
countif
Close a message box
Consolidation Problem
Lining up data from two sheets
Macro
Assign macro
Renaming Zip files
Determine last row before end of page on worksheet
Extract Row if data exists
Vlookup syntax
When to kill an object
Macro Help
Open an existing Dropdown
Shell Function - Syntax
ComboBox
Zoom - VBA Code
fault message
Exporting from Outlook Tasks to excel
File lists
combobox querie
Retrieving VLookup Values
Dealing with data in rows and columns
Cell position / pass values
Insert binary image file to Excel
worksheet image control appearance change (and back) with mousemov
Excel as a web based shipping calculator?
Importing text file to array?
change the data label of an chart to show qty
Calculations in VBA
Recognize text in message box by "Net send"
VBA Macro
select listbox item automatically
HTML Code cleaner
(Leo) preventing MDI file to be opened
Excel Macro to take user back to page 1 before saving
not allowing a file to open if macro's are disabled!?
Populate fields From excel file to Web form/objects
list related files, select which to open form
Not a valid add-in file???
Disable the Close Window button of the worksheet
change data validation
Retain Variant / String value
Need small help with excel macro please
Auto Size Wrapped/Merged Cells
Fix format to text not number
Re: converting dates to numbers and numbers to dates
Passing the value of listbox to other Subs
Office 12 new GUI
Showing the total in a ColumnStacked chart
Icon Programming
InStr Function Question
register any "mscal.ocx" using vba
Error Routine
Changin values in another cell
Excel-97 SR-1 calculation=automatic iterations Workbook_Open
Fill in a form
How can I......
Intermittent missing reference problem
Repost: Speed of inserting pictures and Excel memory
Re: Strange VBA speed issue based on whether overwritten file originally existed or not (?I think?). Excel from Access VBA
Lookups using 2 workbooks
Tools | References file type
If...then structures
functions that don't function
Macro not performing
Identifying version of Adobe Reader
close without saving automatically
Range Variable ?
solving inside macros
To Chip Pearsons
Copying Protected Worksheet
How do I create a macro to put "-" between existing numbers?
RE: Range Variable ?
look up for values in the cells
text
How to identify variable workbooks in an excel Addin
Incremental Numbering: Compile Error - Variable not defined
VBA code to create "variable" worksheets within a workbook
how do I share a priavte key with other computers?
RE: Range Variable ?
matching duplicates then looking up corresponding amounts
How to pivot and display 'text' in the data section, no Counts!
combobox update
RE: Range Variable ?
automate data transfer from hyperterminal to excel
How to program on check box
Need
method range failed
Help with populating a text-box with a pull-down box
Mouse Control
ot check out a screenshot of excel 12
Identifying a cell that has changed
Extract and Transpose
open folder statement?
combobox rowsource as code
311983 to 19830101 (YYYYMMDD)
How to macro simple graphs
Conditional Compilation Based On Excel Version
how to add a formula at the bottom of a pivot table?
look up for values in the cells
Loop question
VLOOKUP From Another Worksheet???
create a button and assign a macro
Excel Locks up at end of Sub
how do i prohibit user's from accessing formulas (lock the formula
Listbox
macro {r 1} command in lotus
Macro giving runtime error on one PC and not another
working with 2 different worksheets, how can I verify the data
RE: Macro giving runtime error on one PC and not another
look up for values in the cells
suppressing passwords to edit linked files
Explorer Hangs on "Reply"
width of Merged cells within un merged cells
Cracking Passwords
multiple worksheet data into 1 worksheet
VeryHidden
Intersect, Union... where's Deduct?
what's wrong with this paste line??
Problem with OpenText in Excel 2000 (date format)
Applying Macro to only certain sheets
simple loop question
Quick question on multitasking
Excel loop to delete redudent rows
Creating Name for a Command Button
How can I auto-center checkboxes in cells
Formula Help Needed
Macro to combine data based on IF,THENs?
Complex Userform - Step by Step
How do I hide a row or column with a macro
Selecting proper week
Macro
how to insert and color these rows
Macro for Ctrl-P to print
Auto Sort Columns on Workbook Open
Help with this error Unknown reason for error with Range().Select
How to add right-click menu in excel.
how to insert and color these rows
Re: Error on ExecuteExcel4Macro Page.Setup
Macro runs in source , but not when in Personal Macro Workbook
Excel 2003 operates differently on FILE SAVE AS?
autofill with dynamic lists
Truble Attaching PDF Files
How can I rewrite this using an Array?
page break preview and form button
Add Excel data to Access
Permutations, Array, For...Next, etc.
WebBrowser1??
Re: Strange VBA speed issue based on whether overwritten file originallyexisted or not (?I think?). Excel from Access VBA
Code not working
Simple loop?
Unable to Unhide Personal Macro workbook
List of all User Defined Functions
Quick Start to working with checkboxes etc within a worksheet
Excel Won't Open Lotus Files
Manipulating text of an equation
Fetching user-defined fields from Outlook
VBA to change VBA
Chart question
(1) VARIABLE IN POSTING CODE (2) LOOPING
Changes in Excel file by *.VBS script without Excel installed
Changes in Excel file by *.VBS script without Excel installed
Changing Cell Text/Data
Sheet Rename (day 2)
Extracing Data from Unopened workbooks (DAY 2)
How to work a year on year figure
How to work a year on year figure
CopyRecordset in ADO
More efficient code advice needed
How to attach an Excel spreadsheet to this forum for help
Word Doc locked for ediiting
Common dialog control
Resize Range without Select
Breaking up a string
File not found - error
could not get solverget working
3 Part Question About Sending E-mail
Excel memory and speed when inserting pictures ???
i need help!!!!!
Building a better Mouse Trap
changing sheet in window without activating it
Protect File Saved
Popup for cell change
Autofit Column Headers with wrapped text (Not a merged cell issue)
Font size (Excel-Autocad)
openning Access via Excel
Debug - last leg of project
Excel VBA rounding / time handling questions
date range for pivot
location for add-in files
select first empty cell in a range
Position of MyBar
Find negative value & Clear
yield code
a With missing and I don´t know where and how to put it
How can I assign a macro to each name in a drop down list
Controlling Acrobat From Excel
Unmerge cells and place contents of first cell in all cells
edit word doc
Copying to another workbook
Can I test dynamic array for empty?
VB for "conditional" formatting when recalc occurs
Controling recalculation - or how to solve my speed problem?
Spin Button control change capture in ThisWorkbook Module
.Seek
How do I conditionally lock cells?
Automation Error - Element Not Found
438 - Object doesn't support this property or method
Message box for cell change
Loop problem
Printing a Word doc from Excel VBA code
In Excel, how do I change Column Hdings to words not A, B?
Find value (31.12.9999) and clear
ListBox MultiSelectMulti mode
VBA sort records occupying 2 rows each
Find number of spaces in a string (instr)
macro for clearing autofilter
Random range averaging
Last day of the month
to: John Walkenbach - Face ID add-in
Range Comparison
Can a variable be used in a Worksheet().Activate method
Printing Question
Using a DO loop to add values into a textbox
Save File
open folder _open file code?
VBAProject still visible after closing workbook
printpreview
Data Analysis Question
monthly compound of yield
Deleting Rows with Sum of "0" in 4 columns
DATA VALIDATION - for data which is the result of a formula
How to make a particula cell ACTIVE using C#
Retrieving Names of Worksheets
Userform assistance please
change DAO code to ADO
A value between 2 values
cell ranges to userforms
link cells in multiple worksheets same workbook with excel vba
Conditional Formatting to HIghlight named ranges - error
Colouring autoshapes mapped to cells in excel
Tough Excel/Access/VBA Problem! Please Help!!!
formatting a specific character or number in each cell within a rangeof cells
Running a Script upon Saving a File
Writing values to worksheet from array
Web toolbar moves
Oracle database login
How do I calculate hours worked on 3rd shift?
Userforms
Bug in Excel 2000? (CurrentRegion property triggers events)
Copy Cell from Row Above
Extracing Data from Unopened workbooks
Help with Formulas
Naming a sheet
excel programing error?
auto filter
Size Limit for ADO query?
For Next Question
Why do I receive OLE errors when saving an Excel file in VB?
Looping Problem
Delete columns not required
IF or LOOKUP
Forcing recacalculation
VB or C#
how to open xla file in automation way with disable macro
Excel Time issue
Draw a circle to select a desired collection
Draw a circle to select a desired collection
ASP & EXCEL2003 - RUN-TIME ERROR 1004 in Export method
Userforms
VBA Dates help
Evaluating Conditional Formats
Convert a wokbook to shared mode
Exporting excel cell contents to word document
Macro works, identical Function doesn't....why?
Make a Better Userform
Calendar problem
Drag and drop event
Inputbox's and Prompt value
A mixed request
Function to calculate an average
can you link a hyperlink to a macro?
Dumb question of the day.
Strange behavior of InStrRev() function
Auto Sort
Add to CmdButton
Prevent / Disable Worksheet Copy or Move
calling excell from an external program
can pictures be inserted into comments
Sorting records in Pivot page field
Hide worksheets at startup
Dynamically adding a macro to a new worksheet
New Line in code to worksheet cell?
adding rows across multiple worksheets within a single workbook
Code needed big time!
add and remove rows from a called range
cell reference in C-API xll
Do not email sheet if nothing on it.
sumproduct question
Collection Object, 255 item limitation
Detecting if OLE object is displayed as an icon
Running Excel module within Access
UserForm-New one or Reuse Original?
Push range against right screen edge
Adding and using a calendar
how to link excel cells across the internet?
Return to Main Page
Tab Order
Values from a ListBox
Set Focus on Cell D8
Subtotals macro
Test
option button?
Blocking Error 3021 No current record
Test if the active cell contains a shape
Array Code to Delete Worksheets
replace in a string
scroll
parameters AddTextbox
Problem using pivot tables in win forms
Database access & querying
Exclude one range from another
Call other sub in the same module
Pass string value to another form
Re: Status Bar : Display both Sum and Count
cell references
return sheet name to cell.
Tax calculation formula
Hide/Unhide in Code; Protect, Unlock, etc.
VBA Code To Import Historical Stock Quotes In Excel
Getting Forms button caption
Text File to Excel Cells
Copying Data Another Try
Sheet Checkboxes clear
Question about querytable vs copyfromrecordset
Loops are Great as long as they work
Match cells by columns
Help with messed-up code!!!
Cater for unregistered DLL
Status Bar : Display both Sum and Count
VBA calculation question
Date Stamp Save
Create UserForm programmatically
Getting information from a file
Passing Procuedure to Userform
Stop Execution
how do I get: What number _____*11.2%=19.86 ??? Thank you!
Forms
Filtered List as Listbox RowSource
Identifying Blank Excel Sheet through .NET code
File dialog box
Why this code works and other do not? Newbie here.
Email from Excel with Outlook Express
Excel app as child form in VB.Net
create custom menu with addin connect/disconnect
running excel macros on remote computer
Trouble with Declaring Worksheets
Select non-consecutive cells for deletion
Userform
If column width is 8.43, what should the row height be to make a square?
Calling variable files
selecting multiple sheets in a macro
Creating an If/Then macro?
Add to sheet
The missing link
Hide and Seek
Picking up Date formats for use in Filenames, Etc.
Excel <> HTML Web page - How ?
How to reference a Class Module located in an add-in or another workbook?
Sum Formula
Saving ranges as GIFs
Range problem
0.25
Change reference style in line of code
Worksheet_Change Not Detecting DDE Updates
Checking dB for New Records Using DAO??
Input box that ask for web address..
Buttons click in Code
Unable to set installed property of addin
copy rows programmatically from one worksheet to another
Autofilter protected sheet
Formula Help with Lists
input box that ask for...
Opening Excel - File Error
Trouble with Formula in Cell
webquery-cookie problems
VBA Excel: Problem w/ Loop
Need help writing a printing macro
How do I remove a non-toolbar custom button from a sheet?
ComboBox Problems
Copy Cell from Row Above
Encryption of data in cells using AES 256
Question - Repost
Excel forms button "click"
compile error: Expected: = ...Why?
Forms
PASSING VARIABLE TO .xlT FILE FROM .xlA FILE (CONTAINS 'Auto_Open' PROCEDURE)
Is scripting the way to go here?
Syntax of If statement in before print event
Macro for copy Word into Excel
prevent saveAs dialog
Thanks a ton, Bernie!
Password Protect Macro?
Automating production book creation - many procedures to run
Linking Multiple Cells $$Hire?
Run macro but let user update spreadsheet while it runs
List box ' VBA
Hiding a Button
error '438'
Creating PDF Files
SetFocus problem
protect/unprotect worksheet
Adding quotes around text, i.e. "text"
How to make a multi-column label?
Date Copy and column adjust macro
Create new book..paste data..save..close
How can I run my spreadsheet on someone else's computer?
Macro add Hyperlink formula
Importing excel values to word document
Spreadsheet with multiple tabs, same headers
error on second pass of loop
Macro codes security
Run-time Error '1004
control formula with a macro?
Class Module vs. Arrays
Toolbars
FOR Statement Issue
Interact with Spreadsheet Model via the web.
Arrays problem
Printing Multiple Pages Based on Different Cell Criteria
Subject: Excel VBA .Lookin Error 9/9/2005 7:14 AM PST
Automatic top of sheet?
Is it possible?
Pass parametres from Excel to Access query
Macro to clear combo box values
Add value to conditionnal formatting
ListBox value limit
Reference Issue
add column of numbers for each row
can com port data be imported & sorted into cells?
How to modify loan amortization template
User select row?
Time sheet with 52 tabs
Fill Down
Change year value in a date column...
cell validation with list drop down by using a makro - Excel bug?
Scan a Directory
Dynamic pie chart color
method 'open text' of object 'workbooks' failed
List of all Macro's in Personal.xls
how to open xla file in automation way with disable macro
Resize Comments Box
Run macro on cell edit
crystal32.ocx
restructure long to wide
Automatically insert signature in worksheet
Record a Macro through VBA
Verifying Printer with Excel VBA
check if file already is open
Put MsgBox text in a worksheet for printing
Return to Excel after shell an application
Adding Objects to PrintDialog
textbox trouble
How to make a new function category?
excel object in visual studio
how do I create a macro in excel?
Looking for Excel VBA gurus
How can I remove all traces of XLM macros?
Code to different object models
Need a way to display a descrete number of rows from a list.
Copy two sheets
Adding and naming new worksheets
Closing a external legacy program using VBA
saving changes to addins
HELP! - Can't Copy Cells With VBA
I have no Idea how to do this in Macro.. or if it can even be done easily
Like to put it in VBA please
commandbutton_click problem
combo box pupulating macro
Include Excel Application Inside Winforms
My Microsoft Office Excel 2003 disappeared
Compare Multiple Numeric Values
user-function not returning any result (newbye)
Need formula - conditional formatting - ran out of conditions!
Copying Data
Need help writing Excel macro to solve a cell in each row of a spreadsheet
Why isn't this macro giving me proper results?
VBA Macro Versions
Question about ExclusiveAccess
Type of macro (Excel Version 4) that cannot be disabled?
Automate a button click event
Rounding currency
What is causing "Block if without End if" error?
how to replace drawing with text in that cell
Insert Picture Macro
Keeping excel visible
Inputbox question
Are 2 dates between today's date
Macro hangs my excel (not responding)
Is this possible?
Problem with Workbook_BeforeClose event
crash on second pass of loop
Looping
Why doesn't this code compile?
use macro to hide or show bitmap image
Confusion with security
search and offset?
Need loop help
VB script to sum up amount
Disable Sharing mode in VBA
Tiering Macro, Should be easy?
Macro / Custom View
R1C1 Helper Instr / Mid
Links Utility
Delete Unwanted Macro1 Sheet
On open, resize page
Listbox and Collections (Again!)
Passing Arrays in User Defined Objects
Add Password Using Access
Excel 2000 VB
Deleting Cells
Macro Security
PivotTable Pivot Fields CurrentPage
GetSaveasFileName
Creating TWO-WAY E-Mail Attachments with 'BeforeSave Events' in Code for 2nd E-Mail
Efficient Copy/Paste
Application run help!
Runtime 1004 Sort method of range
SourceData for graph
Extract data question
return data to specific columns?
Conditional Formating by truncated values....
Help with VBA Password
Finding the last nonblank cell in a column in VBA or VSTO
If a formula is too long then refer to the cell after a TRUE resul
Simpel commandbutton question
error
VBA fault finding
XL - Oracle Connection error
Greyed Out Graphs...
Sort Question
Removing column borders from an invoice
Module name
Function Call Specified at Run Time rather than Compile Time?
Create Format documenr from Web With out Installing Excel in Serve
C# open xla file with automation
Please Help!!!!
Selection
InputBox
Pls Help Me!
Clear Clip Board Memory
Comparing Text to Numeric Vals
How to make chart embedded in active sheet?
Print Button
Deleting rows with VBA
Capture Network Domain Name
Run-Time Error 424 - Object Required
2 Things, CommandBars & Windows
Possible to have sheet to convert roman numerals?
Using Find/Replace in Visual basic to adapt the code
Automatic saving of worksheet with unique names
Horizonal Line Chart
Application.wait... won't!
Format of CSV File in export
Any comments on TurboExcel?
Using ADO to run an action query from excel
To copy from a range in another sheet to the active cell
Write " to a string
Pagesetup. Is there no way to control the LeftMargin of the LeftHeader ?
limitation in the path + filename length
EXCEL VBA tutorials
Data Retrieval
CHECK BOX HELP NEEDED
tranfering value if...
Are macros interchangable between Excel and Access???
Incrementing Rows in columns
Hyperlink
problems finding "~" in text
Pivot Tables - counting instances of a number of words
Automatically Create XY (Scatter) Charts
VBA Array display problem
Pivot Tables - updating drop down lists
Excel fails to open workbook using Automation from VB 6
Differentiating Cell Drag Copy
Adding image
How to delete all page breaks?
Character Limit
Question
How to calculate # days between business days
configuration files for excel add-ins
Closing Excel Safely within a Web Environment
Test for an empty selection
Copy MTD info from YTD detail and paste to new tab Macro
Formatting data in Msg
Delete a selected area from a non-contiguous range
Duplicates, Comparison and Condensing
Fill ComboBox with File Names
LOAD userform
How to end when test condition met?
Sumproduct & Array Formula?
Activating workbook without naming it specifically
worksheet looping with varying labels (aka Need to Find the John!)
VB for conditional formatting more than 3 conditions
Hide AND Exclude?
Need Help: 'sheets' function with a variable in a formula
Help
"Outlook.Application" vs "Outlook.Application.11"
Dynamically Add Combo Boxes
I'm just starting to play around with VB and would like some help.
Saving macros
saving option
Excel & VBScript
Retrieving Data Problem
Excel file as an executable?
How to click the button from module?
append file on e-mail
Error Trap
Inserting rows at variable points
Help deffining public variables in userform1
Macro help
Formulas in Sheet
Public Variable not maintaining value.
Macro on Button needs syntax help
Formulas for dates and static data
Menu /toolbar question
Sort by colour
Error Code 6
Macro execution time
SetFocus testing
vba code in Excel
Copy text from Ms Access record to Excel text box
sheetname search question
CHECK BOX HELP NEEDED PLEASE
Time displaying as decimal
Problem opening excel file with VBA
Help "438 - Object doesn't support this property or method"
Compile an Excel 2003 Application with VBA 6.0 Code
Compiling Excel 2003 application written in VBA 6.0 Code
XML mapping programmatically
test for field that just has spaces in it
XLStart and VB
create a pause in print macro to allow user to select printer
Listbox columnhead
set up a pause in a print macro for user input
Sorting a column
Shading Rows
Range.FormulaArray drops relative reference ?
VBA in Microsoft Excel: Find & Replace method macro across multiple files
Iinsert value into column L ...
Insert value into column L if...
If Then Else
If statements
Working with files in directory...
Command Bar Tools, Protection Protect & Share ID
Simple Declaration Question
Range Value ie: (A1:A100) The Option of?
Runtime error 1004
Excel Command Line Options
R1C1 riddle
IF function based on True result with large formula.
Custom Menus in Chart Sheets
Deleting an entry from a ini file
Why can't i filter two different columns with different criterias like this
Grrrr...Range on another sheet trouble...
Trouble with Arrays / Collections
Macro to copy internet page
Class module question
Show values only in a pivot table
SaveAs Maceo - Specify Folder it Autoselects to Save In
Allow disabling of password, but no setting of password
Newbies and Menu Bars
summarize
don't want to have page breaks in union
MsgBox To Read A Value of a cell
How do i know the name of current view?
AdvancedFilter on cells with formulas, returning values and not formulas
Printing multiple ranges w/o page breaks between
Wait less than a second
Pass a variable into a range?
separate text and digits within a cell
Dealing with a Locked Cell
How can I specify workday capacities in a dynamic calendar???
Excel VBA Library
Excel VBA Library
Getting my VB custom functions to support usage within an Array Formula - How do I ge
VBA for excel
Selecting Columns
Programmatically putting text in title without using labels
Excel split window refresh problem
How to remove and old Add-in from list of avaiable Add-ins
Expressions in Microsoft Query
incorrect Format Date mm/yyyy in excel 2003
dynamic combobox
Circular reference error
USE MACRO TO SAVE WORKSHEET SELECTING FILENAME FROM CELLS
Worksheet Protection
spelling check on a protected spreadsheet
Defining a Property
search and extract within text
problems with a userform
Printing Selected Worksheets
Activitate sheet 1 and make all sheets read-only
RE: spelling check on a protected spreadsheet
Row Color
Save As selection in Active Sheet
MSG Box - Stop Macro
macro that opens a number of workbooks and close them
Suppress Save Dialog Box
RE: problems with a userform
RE: macro that opens a number of workbooks and close them
RE: Activitate sheet 1 and make all sheets read-only
RE: problems with a userform
Sorting with a list
how do i set up a Cobol Comp-3 data field in Excel?
RE: MSG Box - Stop Macro
Mesage based on table
List of File Saved
How can I delete multiple sheets in VBA...
Command Button Freezes on Reopen
Separating a string to two fields
Using workbooks
Auto Open sheet function
Simple constraint problem...
Modify a Worksheet
basic
Function Key F5 - go to reference
unique filenames in macros
Stumped - What am I doing wrong?
Working with an array
Application.WorksheetFunction.Match
Log uses of Excel
Please help with Macro
Excel 4 macro conversions
Exclude some worksheets when using UsrSht function
Shade cells with links to external workbooks
colouring cells that are between two dates
copying value into alphanumeric table
Trying to revive this question... Help :)
Combo box
Input Box Help - Validate Date Format
Time Help
Update and Add
Excel VBA Need to rotate players - find / copy last 3 rows and move to the top
Can Anyone Explain This?
Question about intervals and results
Problems with a formulas
Tough Excel/Access/Windows Problem, need Help!!!
Copy and Past to Differerent Work Sheet
Keyboard shortcut to auto insert $ sign into formula?
Macro Help - Deleting two characters per line!
More combobox questions
Print Sheet Array from List Box
OLE or Automation Printing of Excel
Beginner needs help, Look inside!
Empty Date
Module name change
Run-time error’-2147417848 (8001
Macro help...
Easier way to insert columns
Running VBA Code not written within the currrent worksheet
save as latest excel format
Excel and VBA how to call a procedure from an excel "cell"
Formula
Excel Filldown problem
Last record in collumn.
Distributed Addins
Control Not Licensed Error
Conditional formating
Autorun a macro
Return Information from Shell Command
Toolbars: Hide now, display later
Need help with Add-ins!
How can i combine combo boxes
Sumproduct.....
How To Create a Document in Excel from a Template, Using a Macro
need macro\method that would allow user input to a data filter
Using VBA Functions in a worksheet
Using a macro to delete all blank rows
two space rounding
Range.Insert query
Macro To Create Hyperlink from html text
Excel Userforms Textbox query
Add a tamplate sheet automaticly when I have copy in a new sheet
Select specic no. of rows down
Generating inserts out of 1.5 million records CSV file
Excel 2003 changes protection when saving
Data validation with several fields
CubeField Member Properties for Excel 2k?
Value or formula in cell depending on input...
UserForm PrintPreview & Print buttons
Save file as sequential
find first data entry in range
automatically copy selected data from one excel to other excel
Sheet scroll based on variable
re : Possible ???? Pls help
Create mirror workbook???
VLOOKUP 2 CELLS
Save Worksheet as Text File
Fix or touch up heading so that it could be imported by Access97
Sight Unseen
Print all pages in a Multi page userform
Parent Folder
Copy outside Clipboard contents (html page) to a cell in Excel
Formating X Axis on Chart using VBA
Enable grouping in protected worksheet
How to run a private sub in the workbook from another workbook
partial derivative of a function
Make date show
Range names
Names of Grouped Shapes
Generate auto increment number from VB form
form.show switches to debug mode
VBE causes excel and word to crash when closed
Tips for copying picture?
Insert right pointing triangle
Know exact position of a cell in the Sheet
Option button help
There has got to be away!?
Inserting value with increment by 1 from previous value
Error Handlers
I want to verify data in 2 different worksheets
I need to verify data from 2 different worksheets how do i do it
Export Linkedcell
File encoding problem
multi text search question
To Multiple Excel Files
my first attempt at R1C1 in vba
If, or on 3 conditions
Files and Folders check
Import data from two workbooks with similar names
Remove Autofilter
Protecting worksheet-Unable to view comments
Telephone number data type?
closing userform automatically
Protecting worksheet-Unable to view comments and use a filter
Using a Macro to delete all rows containing #N/A
Using a Macro to perform a VLookup on varying number of rows
Animated selection border
Disable Tools, Protect, Protect Workbook
access specific areas of a protected worksheet
Option Buttons/Refresh
Capture a cancel button
rounding error
v-lookup error
DLL Entry Points
Repeat Title Formatting With Macro
Scanning objects
Error: Out of memory
how to keep focus on txt_box in userform
Can anyone recommend a good free online excel
Copy and paste between workbooks?
error message: compile error, argument not optional
I NEED A FUNCTION TO FIND IF THERE IS AN INTERSECTION BETWEEN 2 DATE RANGES
userinput is wrong (check in vba)
VBA Code works in Excel 2003 but won't work in Excel 2000
How do I make a ComboBox use a list from another sheet in Excel?
VBA Code works in Excel 2003 but won't work in Excel 2000