Microsoft Excel Programming [Archive] - Page 4

Re: Copying a UDF from an Add-In module to a workbook.
Calling Button click event from Form initialise event?
Code to 'unbundle' and array
QueryClose event of a form triggering Exit event of a textbox on that form
Save with ref. to cell A1
Using the Find method of a Range object
sort duplicates in string
Re: Excel range read/write
Date and Timer Picker question
quicker way to execute?
Saving file with ref. to one cell
Dynamic Nammed Range
Saving a .xla File
Signatures in Excel
Runaway Macros!
Filter on Day
Text to columns and comma delimited text
Re: Worksheet or Me. Why the difference?
Mac Excel compile error method or data member not found
Accessing VBA Group via NewsReader
3 csv file to one & linking to find unique rows
x=inputbox
User inserted value
Select Named range
Re: Better Understanding of XIRR
fill range with formula
Launching macros from the right mouse button
VBA re Graphs required plaeas
Running a Telnet session within Excel VBA
Graph - Runtime Error 1004
check if a cell contains a number, not text
Re: Better Understanding of XIRR
Re: How to choose Random rows??
keyboard up/down arrows to select items in this list box
Application.OperatingSystem returns what?
Re: How to choose Random rows??
AutoFilter Criteria using named range
Re: Is cell outside printable area?
Re: Is cell outside printable area?
Changing File Name
sending an array to Excel
dropdown menu ? other ideas?
Excel process still shows in TaskManager
Autofilter Get selected cells value
Adding string to PrintOut?
Add value to the content of a cell with Vlookup
User Defined Function - reformulated repost of an earlier question
Exporting Worksheets from a workbook and saving them as a .prn file
Exporting Worksheets from a workbook and saving them as a .prn file
Macro speed decreesing after each run
Template opens instead of copy
.INI versus Registry
Useform won't Show with dynamically added controls
/ key not displaying in cell
Re: Check if UserForm is loaded?
Better error message when a user enters a value in a form comboboxthat is not valid
Using functions
Energy Saving Tips
Need vba code to Update Data in Powerpoint 2007 charts
custom error message
Project Code Communication
If named sheet exists then delete it
macro question
adding verbiage to the end of a cell
Re: Check if UserForm is loaded?
Back up files? in excel 2007
Clear contents of a 3-d (three-dimensional) range
vlookup in VBA
vba macro help!
Code to display a true or false value in the cell containing a check box
HOW TO APPLY GRAY HIGHLIGHTING TO RANGE, BASED ON ENTRY IN ONE CELL
Copying diagonally opposite value from the known cell/range.
Converting European number formats
VSTO Paste
To Determine the 2D array
Re: how to compare formula's values?
Different uses of AND function
Formula,Function, or VBA
Print variable number of rows of spreadsheet
Dropdown list from all worksheets name in a workbook
Formatting macro runs real slow due to network printer - best workaround?
Rank Data using VBA - having trouble with R1C1 notation
Macro to retrieve values corresponding to the value selected in Dropdown box
Re: Easy way to merge 5-6 columns
Form, Dual Monitors
Re: Easy way to merge 5-6 columns
count duplicats, display incremental count, restart count at changein value
Modify Ron de Bruin Code; Save Specific Files to Specific Folders
Re: Synthetic Speech in Excel?
Employee Schedule with multiple options.
Square brackets to specify a range
Excel File; CanCheckOut <> True in SharePoint
CDO.Send failed to connect to the server
Neat code for pasting filtered data to a separate worksheet
macro is to update column 13 and 14 of worksheet "Voice BB Pending"as per column 2 and 3 of "Activity log" .
macro to fill cells
Find a Pattern and Parse Text
Opening PPT deck in background
Re: Windows Query working on some computer, and not working on others?!?
Re: Delete all user numberformat?
Re: Delete all user numberformat?
read the Windows version
ead the Windows version
How do I get something like IE > View > Source . . . Navigate therewith VBA
Macros Disabled by 2010 Shared Workbook
"Set" statement with variables?
UCASE... with Office 2010
Date Variable in Macros
Save Preview Picture
Compare Userform inputs
Help with Cell Formula
Excel sort ranks text above numbers
Generating XML files vs. code page.
Column is overwritten
My excel Generated .tmp file
Use "Tab" within a cell comment
Post disappeared from this forum?
Re: Running Batch File from within Excel
RoundDown function not working in code
VBA to read HTML; Search for TDelement
Get filtered range into array
trying to email workbook from VB6, getting error 1004
Custom Form
Successional Plus Signs - What's going on?!
Reducing "Set" statements
Macro to send Workbook as Email to Users thru MS Outlook 2003
How to write a VBA function which returns an integer
Dynamic chart problem
How to use a subset of a range?
All Workbook Saved except This Workbook - Part2
Macro Help - Looping & Deleting
Function Help
help with highlight code
UDF Not Recognized
Convert a range of numbers to strings
Can I use variables in the text portion of a message box?
UDF function with Optional Paramters Problem
Help with macro to populate blank values
saving to WK4 registry error
Workbook_BeforePrint Stopped Working
Doube click cell to run macro
Re: Import from a HTML file
Dominate Mafia Wars
Macro delete columns satring row 23
Excel is Running Too Slow. Can I run a Diagnostic?
Easiest way...use shortcuts and internet explorer
All Workbook Saved except This Workbook
Always on top and Deactivate event
how to cread invoice tracker
I am getting the following error message "Microsoft Office Excel hasstopped working", when I try to run a macro to load my Userform.
Dynamic add formula
Delete Method Of Range Class Failed Error
Need macro to play sound in Excel 2007
Highlighting (formatting) 4 lowest cells in a named range to differntcolor
trigger formula execution based on user entry
Macro specifying file name when printing to PDF?
Retrieving data from online excel spreadsheet.
InputBox to resize all charts of active worksheet
unhide Rows when question is answered via a drop down box.
Re: Check if an Excel or Word file is "read only"????
error 9 - related to an array - adding delimiters back to a cellvalue
Re: Check if an Excel or Word file is "read only"????
Not able to initiate printer from checkbox
Worksheet_change or Worksheet_calculate
VBA Validation between two Times
IE
Compare two worksheets in the same workbook and highlight difference
Macro works but also runs original spreadsheet
Create several charts in one go using VBA
How to format cells to General via vba
Excel open from VBScript does not display Windows pop-up when file inuse
Workbook Page Numbers
Cells(row, j).Interior.colorindex
Force Recalc
Exporting multiple tabs as .CSV files with the tab name being the folder and filename
VBA equivalent for XLL?
delete last-line help.
Copy/Paste from Sheet to Browser; Then Copy/Paste from Browser toSheet
continue processing a link has opened another IE
consolidate data (i.e. a single cell) from multiple spreadsheets intoa single sheet
Automatically changing default formatting upon opening new workbook
Import Word Table Macro running very slow
slover for a 5x5 logic puzzle.
Sum Columns with Specific Headings
To color string of variable size
VBA Code to run when any cell is updated
AutoFit not working properly
Macro to update on web refresh
How to read the contents of an OLEObject (dropdown list) in excel
Start value of dropdown
Excel Recalc All except one sheet
Building a formula from another cell
Macro warning with no macros
Grey Fill for all cells that contain a certain string in hyperlinkaddress
from pivot table to vb array copy to new table
Excel Macro delete certail column's
WebBrowser
I want to loop this macro
How to properly read Value2 Range ?
Programmatically identify a particular formula (VLOOKUP) in a cell
Adapt this Directory Listing working code to insert a file namepattern prompt.
Re: Transpose
Saving a String as an html File
VBA Excal start powerpoint on mix system of 2003 or 2007
Excel Macro error
Combine/Merge Rows, Multiple Worksheets
message
How to reference a file in a different instance of Excel?
Printing page 1 from each sheet in workbook
Getting Run-time error '445'
Open CSV File
Open a New Instance of Excel
Getting to the bottom of it
just trying to copy 6 rows to the right
summing through end of row
Lookup a value within a range
To disable Right Click Q
Re: Font selection dialog box?
Delete all Excel workbooks from a list on worksheet on condition.
Advance Filter data to store array
Re: Autofilter with criteria from userform
Cell to macro
Adding multiple combo boxes to excel cells
parse a string and do a simple comparison
Convert A Formula to Value Until A Value is Met
Insert rows by group and copy value
how to avoid user to save in .xlsx
if I create a BSTR in C++, do I need to release it ?
Need macro code to pick data according to year selected
Use concatenated String as input to Data Validation List
excel ADODB.connection to itself ? how?
Remove digits after colon
Set a reference to a Workbook w/out opening the Workbook?
I have created a vba script for a document registers
IE automation
Save a file to SharePoint
List of objects with properties & metods
For Dave Peterson
Saving a CSV file
Check an a file; SharePoint
Copy with a macro
PERL script for xlsx
IE Automation
compare column color row
Macro to copy
Open a file from share
Problems copy data when using filter in place
Multi Select List Box based on Advanced Filter
Check a file into SharePoint
How can I force a workbook to close?
Trouble using VLookup in VBA
Continue macro from current workbook
Re: How to save a WorkBook to SharePoint?
Re: How to save a WorkBook to SharePoint?
How to save a WorkBook to SharePoint?
Delete all Links via VBA
Advance Filter with Multi Criteria
Re: Next Without For
Trying to recover deleted macros
Populate Listbox on Userform with file names
Macro Help : copy + selct
Input Data to Webpage
Shortening code
Problem with date formatting
Array by getrows to listbox - date format problem
How to replace numbers in sequence without sorting?
Count Number of CF Q
Count Duplicates
Re: Deleting blank columns
Re: Deleting blank columns
How to run macro from an exe?
Free microsoft excel templates and macros
Issue with Multiple Graph Creation in VB
Control program flow
Issue with Solver in Macro
Automatically create names from values in cell
Re: Copying 1 worksheet to new workbook with data and formats only
Stop Auto Calculation Q
Number of months
Code for auto fill (\-) stopped working
Help- Simple function fails working with pasted values
Making Functions in a DLL visible to the outside world
Progress Bar won't work in Excel 2007
Split a text file with more than 65536 lines over many worksheets
Loop within worksheet array
Weird screen refresh problem in Excel 2003 - bits of differentworksheets display.
keep duplicated numbers, eliminate single occurances
download info from a web site to Excel
All Combinations of cell values in a single Column
counting CF cells
Adding New Sheets
Macro for Multiple Worksheets
Macro for dialog box from pivot table
Using a Table in my VBA User Defined Function
Delete all Conditional Formatting Q
Removing duplicates but leaving data on following rows
Turning into normal proportions
Lookup formula for retuning multiple values
Group By Calculations and Labeling
Can a Sub/Function print the names of its callers?
Function created in VBA not listed in worksheet existing functions.Pleae Help
Userforms & Excel 2002 Crashes
Using XLM Macro Sheet in Excel 2010
.FindNext problem
Disable the cancel option while saving the excel sheet-Excel 2007
Speed of Macro on 2 PC
Best Excel Development Architecture? VSTO vs. VBA vs. VB.Net/C#.Netvs. ???
Populating a form from a spreadsheet
Combing Student list and Classes they took to one sheet
ControlTipText
VBA Macro in Excel 2010 - Curve lookup
Calculating the current time in Excel 2007
Select value on a cell by matching value of two cells
need a macro to set the print range only for visible rows
Re using same macro accross other spreadsheets
Converting an Excel file to PDF Q
Code to Remove Form Control buttons Q
Transfer data from Excel Spreadsheet to Outlook
Help with UDFs in Excel 2010
Can you use ADO from Excel to run an Append Query in Access
Combining formulas
Macro to Call A Subroutine on a Sheet Sometimes stops?
How to use Excel VBA Help
Addin - Invalidate Error
Mark if checkin date is within 30 days of checkout date where name isthe same.
Return to Excel after Automatic Email
Function to Sum colored cells values not working
formatting problem
Lousy routine to get the first available day of the month
SOLVED Excel 2010 not using Options:Open Registry key to install
Excel 2010 open in full screen
Save all content of folders Alpha, Charlie on drive C to externaldrive Il
"On error" within While loop failing
Need help creating a listbox in Excel that can delete unwantedcolumns
Insert new row with drop-down box but problem with cell linkreferring to the original drop-down box
wrong Hyperlink-Values
OT: File Find Function missing in File Explorer
Referencing Userform in VB6
Generate RGB combinations from Rng.Interior.ColorIndex vlaue
Microsoft Excel VBA: Concatenate without formatting
Re: convert selection variant idispatch to something useful
Re: Converting Time
Search array for string
BSTR to char* Help!
Corrupt xlsm
Userform problem with "Run Time Error 75"
grabbing and pasting cell formats
Do I need DLL or COM Addin, Excel Addin
Identical Solver for Many Worksheets
Excel 2010 not using Options:Open Registry key to install
remove text between [ ]
Excel Complicated Problem
.NET "Isolated Storage" from VBA?
Problem with progamatically defined named ranges
Re: At each change in data concatenate text values in contiguousranges
How secure is SaveSetting?
OleObjects very urgent issue
Macro to combine worksheets
writing formula w/ variables
Macro to add up values in COMMENTs
bug - named ranges point to wrong column after being moved inside anMS Query Table
Command to toggle Control Toolbox on?
How to make ImportXML run faster
Print Preview Freezes
Macro to count numbers in COMMENTS
connection form Excel to mySQL
Check that date exists
SheetCalculate fires all the time
Copy row to new sheet if cell data is repeated more than 3 times
Why is file suddenly "Read Only"?
Formatting macro required
Re: create a spreadsheet from another app
Copy files in sub folders to a specific directory
Calculation of Monthly No. of shifts available per operator forunloading work
Re: create a spreadsheet from another app
Excel 2010 not using Options:Open Registry key to installAddins/Add-Ins??
Calling Procedure from Cell value
Where is the personal.xls file located in Windows 7?
Add "paste values" to right-click shortcut menu-how do? Excel 2010
Fill in the blanks
Locking down a combobox
Re: Test post 2 no reply needed
Re: Test post no reply needed
Macro: insert rows anywhere in the sheet
Sort and align 2 ranges
Going to website & Entering username & password
Re: Error Trapping Problem
trying to format if AHT is found in a range of values
Finding external cell dependents works in a Sub() but not a UDF.
Hide button in a combobox dropdown
I need to give index number to charts
Sum values in a range to a result
How to wait for addon to load
followhyperlink happening twice
Creating new sheet and renaming problem
Copy rows from Sheet1 to Sheet2 when Column B values equal "X" andColumn C values > 100
Scroll Bar- Move one cell to right
CheckBox values based on Worksheet condition
Setting a column of a 2D array = named range
help with macro for checkboxes
need help with macro (checkboxes)
Re: Help with this macro
Renaming worksheet on the basis of workbook name
Copy yellow shaded rows to another worksheet
Re: Combination and Repetition Not Allowed
Combination and Repetition Not Allowed
Renaming worksheets
fixing a run-time error'9': Subscript out of range
Button to print XLS file as PDF
Formula Help within Code
Re: Excel weblinks live or not
Calculation of Overlap Outage Hours
two charting problems with excel 2007
arrange da data in 1 column
Macro Doesn't Work When Worksheet Protected
Blank user form issues
vba running slower if i'm not looking at it?
Can I run a macro in an xla from a button on a sheet
Print as pdf and save as xls with filename from a datafield
copy recordset to CSV file
nested function
Re: Excel 2003 > Disabling "Refresh All" functionnality
Border looping macro
Change language on Ribbon in Office 2007
how to keep the oiginal format of charts intact in excel vba afterdeleting a series ??
Pulling multiple arrays from worksheets
Simple hack to get $1000 to your home
Extract item numbers with suffix -09 and copy them below the actuallist
Select Range
Your Birth Chart interpretations
Re: Addressing ranges
Re: Addressing ranges
resize of combobox does not work
Trying to delete sheet code with VBA
Changing multiple PivotTable filter items based on a cell value
Re: Test
Y axys not properly displayed
Vertical lookup with a lookup value that returns multiple matches
error trying to use GetFromClipboard
Fueling your car with natural gas from home
Disable Ribbon command while WB is excel 2003 format
PivotCache.refresh not working
Can't disable RIGHT CLICK
ribbon events
ribbon events
Re: AutoFill without sequential order
All MVP's & regular contributors
VB copy files from one folder to other
Macro to find the value of adjacent cell from a range of values
Is it possible to override totalling function/values?
Re: Test post for access
How to execute macro when selecting user-defined menu in ribbon
How to get sequence number in the next column?
Grouping a range of sheets
opening other workbooks at the same time
Re: Test post for access
Is it possible to intercept pivot table SSAS query or extend SSASprovider?
Regarding questions
Pulling specific Data from one WS to another WS based upon 1 criteria
Icon Chalange
Self Signed Projects
Self Signed Projects
Re: How to do this with macro?
Excel/Cellphone
Floating text
Deleting Duplicate Rows
Macro if criteria
External Data from SQL Server
Code not working in a PROTECTED Worksheet
VBA Code to select and format range
Save data before printing
Can use VSTO to reduce the size of a file?
Change event does not fire
Trouble with dynamic named range
Sort Routine Macro for Excel Worksheet
Drop Down with hidden values
When this NG migrates to forums, please consider ...
Worksheet Cell Reference
Solver
Need largest number
How to do this with macro?
RE: Using counter "i" in for loop gives error
Multipage, controls-collection and events (XL2003, VBA)
Compare two columns using loop.
Selecting certain Rows and Copying cells in those rows to new work
Macro to run based on criteria
Fill Down to Last Value
Sharing Macros
another filtering question
macro to insert row and type data
Copy and paste sheets to new workbook
Shading cells that contain formulas and conditional formatting at thesame time.
Recalculate a worksheet following an autofilter selection.
Passing dates to Sql Server 2005 stored procedure
MsgBox refer to seperate worksheet
RE: MsgBox refer to seperate worksheet
Environ("username") in 2007
Can I 'toggle' a toolbar button
automatically unprotect vba-project
Why does saving take SOOO long?
Re: Using counter "i" in for loop gives error
Sync parts of two worksheets including formats
Adding matrices
Float Menu Excel 2003 vs 2007
How to add a "running count" to cells with matching data
Functions newsgroup
Graph not plotting correctly if source not selected
How do I set up timer for sheet?
timer for sheet
Most Recent Custom View
Automatically Saving created FILE
Actively select cells/ranges/sheets and Paste Link
Selection.Cut Destination:=Columns("B:B")
3d column chart dynamic range
open several workbooks at the same time
paste special macro stops working when run a 2nd time
Hyperlink Function
EOMONTH compatibility issue (workaround?)
Merging of rows.
How to open a password protected powerpoint file by Excel macro
Convert 24/03/2010 date into 03/24/2010 date format
Add a date to a Userform
Quiz test
Find and Replace with contents of cell
Arrays of Controls
eliminate leading quote in SAP download
Setting the default directory using getDirectory
Referencing conditional format is another workbookHI
date & time formulas HELP !!
SelfCert
Class versus Another Way, Wbk and Sheet Custom Data Needs
RE: User form Default value in text box
Delegate constructor compiles in VB.NET, but not in Excel VBA
form not opening when started from command line
Variable refers to a workbook
Sorting and Date Format Help
Date lies between
Excel template similar to MS Money less investments?
Declaring Variables
Can't Edit my Excel Comments
Search Macro or VB script
Vba Date$
Re: Where am I going wrong ?
Data Validation based on Cell Value
RE: Where am I going wrong ?
Trouble with UserName
Vlookup in vba - how to use absolute rows not relative
Automatic Prompt for Users to Save
using ADO from Excel 2007
Sorting Problem
Compare and Copy/Paste b/w Two Workbooks
Separate code from workbook?!
Different kind of cell reference.
Accessing the call stack in an Excel VBA macro?
Macro to filter on most current date.
"Optional" output of a Public Type record
windows resize event trap
OverFlow
"Unable to set the LineStyle property of the border class"
convert letters to numbers
I need to use the last row of data in a formula
Copy and paste to other worksheets
nXn matrix creation
How to deliver an Excel tool training
Re: Please Help AutoFilter
Run-time error 1004
Re: Please Help AutoFilter
What equation that i need to use to group in vba
A Sub in another Sub...
add eventhandler to sheet in code
How to assign unit for TimeValue?
select and paste data based on creteria on previous cells
Re: Excel 2007 User form Enter Data Last Row @Table
Find Min and Max in variable length arrays
select and move columns by their name in header row
Popup Menu Item
UDF: how to tell if optional *range* parameter is empty?
Making .jpg's
Save not triggering Before_Save event
Creating a Pivot Table via Macro - Errors on Recorded Code
Customizing Shortcut Menus
Active X Controls Shrinking on Excel worksheet
Help with this error "PasteSpecial method of Range class failed !!
Use 'like' or regex to match number-letter pattern substrings
Summing Range
Finding File Extension from Full Filename (VBA) (2007)
Copy data using macro (with worksheet protect)
Updateing Access DB
Filter event
Scaling Charts
how to open a password protected powerpoint file by Excel
open excel 2007 refresh query from batch file
Find and Replace
List Open Workbooks In All Excel Instances?
Macro for Deleting rows with balnk cell
Copy/Paste cells containing only numbers with .50 in it
Formula Not Working Properly
Re: Data Validation combo box click - 2007
Pivottable
How do I make a macro seek the botom of a list?
Update link on vlookup from closed excel file
SaveAs
Update datasource links programmatically
Disable print from standard toolbar button
Disable print from standard toolbar button
Adding to a list of codes
pool league table setup
Excel Formula help in VB
Server Busy message during printing from Excel after Off. 2003 SP2
How do i create a macro using copy
How to open a password protected powerpoint file by Excel macro
how to open a password protected powerpoint file by Excel
Macro Record problem
filtering two pieces of data
Parsing a String - Call to Ron Rosenfeld
Passing Information to and from Forms
Excel 2007 - VBA Password Input shows after Excel is closed
RE: Looping with more than one condition
HELP: Unable to clear values for control of type text in a userfor
Change color of row (Col A thru Col Q) based on text value in Col J
How To Use External VBA Custom Function In Excel ?
Working in Sheet2 with data from Sheet1
Controlling worksheet protection via VBA
How to change to active sheet on macro?
how to load a file
AUTOMATIC EMAIL
How do I print xls file into two separate columns on the page?
Re: active control box name on worksheet
Sort tabs numerically
Sheet codename not working
Just a test
Vlookup from closed excel file
Equal list values.
VBA Conditional Formatting
XL 2010: Parent of a Range can be a Shape?
Addressing HTMLText object in Spreadsheet VBA Script
The last day
simple reszie
Delete all rows where there is no entry in Column 'C'
Alterations/corrections on userform
How to create a function in a code sheet
Evaluate problem
Formatting previous selection
Problem with existing workbook with macros
Problem with - sign in sheet name??
Replacing spaces with underscore for specific expressions
Parsing (again)
Coloring Alternate lines
Help - Need a Macro/Popup to Find a Date in a Sheet.
How to open & copy paste a word document in excel using macros?
How to Show/Hide Columns or Rows with no data via VB
Change Color for Drawing Line Object
Day of Week from dd/mm/yyyy
delete file in addin directory
Case Studies
Running macros when multiple Excels are open
SOLVER Reset command does not work in 2007Excel why???? Two Questi
Swap Two Values in one Command
dim
PLAY RACE GAMES
Menus & Hot keys - works in Excel 2003 but not 2007
Move data between ListBoxes
Stopping a timer
Web pop up
Auto_Open over Private Sub Workbook_Open()
Problem with the "Or" operand in Excel
Problem with offsetting one row down
How can this crash Excel?
restrict a product eg 10*5=40 because 40 is maximum
Need List of Embedded Files
Input box to find date
Method 'OnTime' of object'_Application failed
Protection Problems
Using a modeless form to show status
Make (save) a file by using macro recorder.
Need VBA Code to Select text boxes in spreadsheet
Best way to copy and paste row of controls on userform
Save as PDF not working on a domained Windows 7/Vista box
export data between spreadsheets
Need VB code to edit cell values
Need Help Remove Duplicate Values In Array ?
Refer a column in the 'sumif' function
Help again!!!
Thanks Everyone
Lookup Cell Interior
How do I stop my conttrols from resizing
Indirectly referring to a variable
Print sheets based on cell value
Worksheet_Change?
Automation of Excel Report using Access Data
Error 1004 - Application or Object Defined Error
NumberFormat not getting changing onFly changing the regional sett
Alternate Column Shading to be applied only to visible columns
VB converting UK to US dates, randomly, ignores cdate func!
Find "invisible" conditional formatting
Grouping
VBA - how do I pass info from dropdown list to a string??
Export Table Records to txt file
referencing controls in userform from a different workbook
Help with IIF statement in macro
Macro for hiding all rows accept those selected by a dated column?
Default Ribbon on File Open
Exporting charts outside excel
Code corrupts file (XL2003)
Array - retrieve certain amount of recods for query
How To Assigned "SelectionChange" Event To different Worksheets
How can I use a IF Array combination to return values?
Identify excel file on taskbar
Odd VLOOKUP Error
Macro to merge cells of the same colour/pattern index
how do i allow fields to be either input or output in excel?
autofit with wrap
VBA problem.
XL file opened using automation - how close?
In a cell find words, copy and paste in another cell
Find word copy and paste
RE: How To Assigned "SelectionChange" Event To different Worksheets
close excel; leave access open
Automatically OPENing (GetObject) and Closing EXCEL via VB calls
Help with VB code
Showing Excel Cell Data in PDF Document
Remove spaces
RE: Array - retrieve certain amount of recods for query
String search on two tables
not in array
Conditional Formatting v VBE code for desired effect
Resize commentbox in VB
"Do you want to update" msg
Macro to delete rows
RE: Code corrupts file (XL2003)
MODI printing and combining files
Protected project visible
Using excel to Determine if a File Exists in SharePoint
How to move worksheet into specific position?
RE: Automatically OPENing (GetObject) and Closing EXCEL via VB calls
RE: not in array
RE: Odd VLOOKUP Error
Pass Parameter from Excel to SharePoint
testing for password protection
RE: Remove spaces
RE: "Do you want to update" msg
RE: XL file opened using automation - how close?
RE: Pass Parameter from Excel to SharePoint
RE: testing for password protection
Formula for Data Validation
Send a worksheet to an open email
RE: Macro to merge cells of the same colour/pattern index
RE: Resize commentbox in VB
Converting a HEX string
Can you calculate delta time using different entries