Microsoft Excel Programming [Archive] - Page 4

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
Remove add-in
RE: XL file opened using automation - how close?
Print Preview slows my code?
RE: Macro to merge cells of the same colour/pattern index
RE: Pass Parameter from Excel to SharePoint
How To Remove VBA Code For Distribution of an Excel Sheet
starting a function will not allow comm_button
RE: Remove spaces
Show / Hide items in Pivot Table as required
RE: Macro to delete rows
RE: not in array
automatically number a table in word document
RE: XL file opened using automation - how close?
RE: Odd VLOOKUP Error
RE: Macro to delete rows
Have VB Code "on" for all workbooks
code to delete vba code
Can we set the UI color scheme via VB[A} or XML?
Change checkbox value
Conditional Formatting with Hyperlinks
RE: Remove spaces
Rotate application
RE: Can you calculate delta time using different entries
Calendar Control
Linking data with variable cell location
using the cells property for use with Application.WorksheetFunction.Sum
How to access macros via tool buttons?
Sorting stuff into alphabetical order
can I use code to make code in another book
VBA to insert .xlborder if cell value not equal to previous cell
Optical Character Recoginition
To show a message box if the mouse is over a particular cell??
Fix Broken Cell Formula with VBA
Cosmetics
Reading system log files
Icon in Notification area
Icon in Notification zone
Next weekday ...
Next without For Error
Copying worksheet from hidden instance of Excel
Delete Columns if sum is 0
Conditional formatting if condition of an if statement is true and astring value is displayed
Looping Open and Save as CSV
Calendar Control 12.0 help
Reading properties from closed book
Addins attached only to selected workbook(s)??
Still need help with a code reference problem - Excel 2002 XP
Timer question
date handling problem with International issues
Advanced compare of two worksheets
Calling a sub on another worksheet
Programmable Column Sequencing?
Userform ComboBox Row Source
Excel 2007 sorting ribbon is not working with .Net save code
Problem With Code...Still
Text Formats
AutoFilter macro
Macro for merging rows
Code "crashes" after dynamically adding control to worksheet
sumif help
Email From spreadsheet
Hand Icon when sheet protected problem ?
VLOOKUP VALUE ERROR
Printing sheets based on a cell value
Autofilter macro
MultiWorkbook Change Event Detection / Spell Checker
Automatically Copy Information when data is entered
Open Excel file from SharePoint; opens as ReadOnly
For statement behaving very strangely
Newsgroups going bye-bye
Non existent code reference problem
SendTo
EXCEL 2007 - export to dbf files
Exporting to .txt converts single quotes to double quotes
P.S.
File not saving
Autocompletion For UDFs?
Autocompletion For UDFs?
New functions needed
Comparing Apples and Oranges
GetOpenFilename code execution interrupted
Copy data in table to column in worksheet
Create a list with multiple criteria
Parsing a string
Register HelpID via Categories dll
Using Color as Criteria in Countif Function
Finding the end of Data
Protection
Answer Message Box - Other than Y/N?
Running another program
Controls in a frame within a frame are always invisible - What am I doing wrong
Pivot Table Macro Run-time error
Button to add Rows on Form in Excel
Protection Tutorial
Macro to rename Tab and then save as
Need Suggestions - Find < 30 days & Mult-Location entries
View what macro is assigned to a tool bar button
Fire a macro
please help.. highly important...
Excel wait for Find Replace dialog box in Word
Re: Drill down pivot table data via VBA macro
Using Trim in a Userform
Date programing in a cell
Creating a formula which references a dynamic cell location
Sort Order Doesn't Seem Correct
Latency on the move - without tripping down the stairs!
Save in different folder
Help with forcing chart axes scale
How to code it in macro?
Blinking Text
BKF files
autofilter master copy data to worksheet
Coding for inventory
creating a pivot with external data source (from access)
pivot table with external data
"000" reverts back to "0" even with a string
Entry data sheet automaticlly updates or adds data to differant sh
Re: Maintaining Text Box Font Setting (Excel) using VB
One line is killing my program!
Testing/Finding .Hidden for Rows May21
watermark
Check out Excel file from SharePoint; if no other Excel file is op
Maintaining Text Box Font Setting through VB
Problems with ACE OLEDB provider
ounces vs. pounds
Using Select Case on Single column only
I need VBA Help for Excel spreadsheet -- Please!
General Question on one line of code - parentheses and quotation marks
RowSource property in cbox
Open Add-In (.xla) workbook as Read Only automatically
Change Gradient Fill Colors of Bar Chart data points
RE: Count Workbooks that are open; Prevent another from opening
delete single occurances in a string
xlPasteValues is also pasting Formats
Open & update another file (through macro) while running macro
Conditional Formatting
get Control of a Butoon placed in the Sheet
How to prevent a graph update
Redefining a table range with a macro
value of value of a variable.
Get control of a Userform by the Name
Command Button to import worksheets
Getting data from a closed wbook (adaptation of rondebruin's)
Identifying other users
Help changing Keyboard Shortcut assigned to Excel Macro
how to disable update links message when opening files
Macro to add / delete column
Public Variable problem
Save BeforeClose
Check numeric char
Prevent Save/Publish
String Search
Disabling Built-in items on a menu
visual basic excel 2000
Application.VLookup and External files
Capture Date from External Sharepoint Portal
SaveAs *.txt - Outputting with Text quantifiers
launch instance of excel without loading personal.xls
Disable Save
Running formulas with data from mulitple workbooks
DTPicker controls missing from userform
Re: Calling Excel shortcuts from VBA
Columns("C:C").Value = Columns("D:D").Value not working after adding16th page
Setting a reference to the Ribbon
Unlink chart from sheet
Option Group actions
How to read Checkbox-Value if only position is known
Re: retrun an RGB value to a specified cell
Calling Excel shortcuts from VBA
Autocomplete Custom Functions and functions arguments
Export Several Worksheet Groups (Values Only) Macro
Fails to delete empty rows
Code not working as expected
Can I put something in the footer that reads from the sheet
Cell colour format according to date
Application.Visible=False
dynamic range definition
"Update" calendar on userform?
Send data to serial port
Modify sub to work on cells with formulas
Re: Number of lines in the Immediate Window
Set object with a function
Open_Files_In_A_Directory
match two conditions to return value from pivot table
Macro to sort, format, sum, a dynamic set of data
VBA to check omissions and show/hide form
Save as cell reference then email
VBA Workbook Open Function
Not sure what to call this
How to display a macro generated menu in Excel 2007
How to update .xlam file (add-in) while it is in use?
use Excel Now() in VBA
Option group controlling objects
Sheet change event to return sheet name just left
Insert Page Break After Partial Text Match
Excel ODBC driver created table/inserted data lost on application
File folder info. in Excel workbook?
Custom validation rule - must be 15 increment of time
What does Compile VBAProject do
Autofit row height in only some rows
Conditionally count unique values
Bug Report: VBA runtime Access Violation
VBA in IE window
retrieve data into a spreadsheet from a copy of that spreadsheetwhich is saved as its own xls file
Convert number to letter 123 to ABC
Checkbox or Option Button
Search Option
Application.OnTime - Macro Cannot Be Found - Internet Explorer
Application.OnTime - Macro Cannot Be Found - Internet Explorer
UserForm_Terminate problem
loop through all worksheets
stop VBA in solver when maximum iterations reached
save(append) to an excel file
Change Pivot Table Page Value
Tracking an email when sent directly from Excel
Creating a common starting point
.PutInClipboard
Help with VBA and SUM
If no activity, display a UserForm; 10 seconds later close Workboo
UserForm1.ComboBox1 to initialize
Copying a sheet fails
XL 2007: How to find out what keyboard shortcuts I've assigned tomacros?
Special character in Input Message - Data Validation
VBA Macro fails when Excel Not in Foreground
Run-time error 1004
Kill Open Read Only Message on Open
Re: Data entered in several cells before proceeding
Array Sorting problem
Lost horizontal scroll bar
Probelm with Code !!!!!!!!!!!!!!!!!
Browse to select a folder
USE THE "IF" STATEMENT IN EXCEL
VB codes
Pasting Variable cell info into a macro
How to code it in macro?
Dynamic VBA for dynamic Forms
RE: Exporting from Excel to Access DB
Macros Menu in Excel 2007
Runtime error 1004 application-defined or object-defined error
Nested If Function to be converted into a user-defined customfunction
#ref error
Problems with Read Only Workbook
Macro to merge workbooks onto one worksheet
Get Standard CSV File
How to enable "enable automatic update" security setting by VB cod
Replace more characters using replace
Differences between VBA in Excel 2007-2010
cell formula question
Pasting
Converting digits to characters (123 to ABC)
VB code to open other applications from templates
Import Data from SQL server to excel
Extract data from SQL Server table into excel using Listbox Selection as criteria
Populating listbox on the basis of Combo box selection.
Opening Files on other User's Desktops
SEARCH IS NOT WORKING
Resize a password protected page
Re: understanding
How To Clear Drop Down Selection
Help With A Variable And Functions
Summarizing multiple workbooks to other multiple workbooks
How do you programmatically hide/unhide a command button in Excel?
Marksheet
Getting data from a closed wbook
Check row above for information if it has contents copypaste empty
Test variable range for 'Delete'; then delete the row
DTPicker control - Initial date
Find and replace
Type Mismatch Error
button for saving all workbooks
Help revising slow code
Export Only Values
Find and replace
Solver for Inventory Control
Stop Emailing Before Save
Keyboard shortcut too slow
Track and write the number of times that sub is run into a cell
how to query my web site from VBA and return a value to VBA
Opening and Naming Files
Recorded Excel Macro not working
Call a subroutine from ThisWorkBook
Stop my timer
Basic Looping
Simple Problems
Keystroke Speed Cancels Shortcuts
Arrow-keys don't work after deleting OLE-object
Handling the WorkbookAfterSave Event in VBA
Comparing data between files
32 bit DLL with 64 bit Excel 2010
Page numbering
Cracking VBAProject Password
Select / Copy / Paste
Question - I think not sure. but there are many ways around it - SQL and Excel
Get AutoCorrect Options with VBA
X = SHELL
E#xcel 2007 problem
Calling Macro
Call Paste function with Undo
How to write any registry key
formula needed to extract data from another file
Changes to working code
Insert a custom function in a cell by runnig a sub or through amacro.
Windows update
Re: Save a backup file
Macro to Formula
Call random UserForm from list
Count Unique Combinations
help with formula please
pasting of variable cell value into macro
RE: Select a worksheet based on cell value
Re: drop down fill in
copy a from a cell to another with desired format
Calendar stuff
Select from a list of workbooks that are open
insert cells
.value
if-then functions
Test to see if a workbook is open
Removing or deleting Checkboxes from workbook
Macro to add worksheet
Deleting a Command Bar 14May
Macro to control Print area/view
easiest way to parse column and row info?
Find Text and Insert Row Above
Ignore error
Search and display based on cell value
Error 1004
formula to VBA