Excel Programming [Archive] - Page 124

Code To Insert Cell Reference
digital signing for authenticode
Addin Close problem
Custom menus
activesheet paste error
Vlookup of VBA Array
RE: quarterly reports
problems with userforms
Import Access data into Excel - Looking for programmer
Matching sheet name to value in cell
Automation of Excel to perform simple tasks on many workbooks.
Format cell to uppercase using code
xla with password.
Public Functions As Worksheet Available Functions
Looking for a convenient source of VBA expressions
.End(xlRight)).Select Doesn't Work
select block of rows w/data between blank rows
Formatting a cell
End If
Range Names - help
disable X button in main window
order number
2pcs of code, a button & a checkbox
Referencing same cell in calculation
Combo box
Extract values from certain Cells to a Master Worksheet
tried to change my code but cant get it to work.
Small square in the cells of CSV files - Text to column
New
VBA code
Automatically Insert Text Into Macro
Fourier Analys
activating correct worksheet
"Translating" values in a cell
Re: last digit
Retrieving Value
Userform with 2 Listboxes
Excel 2000 macro Assistant.NewBalloon
RePost - Calling a Macro from a key
How to loop through controls on a MultiPage
Help with Solver & VBA ?
eliminating zeros
Macros
date formula
Any experience connecting Excel with a terminal emulator
Password Protect Directory
I NEED A SIMPLE IVOICE
Type mismatch accessing variant array too many times
Automating Modification of a Cell Link
Re: Msgbox delayed using AFTERUPDATE
excel charts
Creating Pivot Tables inside a Macro
user form and frame control
function and combobox
IIS, Excel, client server Excel... what direction to take
another listbox question
auto run macro
Automate multiple series line graphs
Disabling Row Select from Header
Querying Data from Secured Access Database with VBA
list boxes
Inserting time into cell in excel and have it not change
PivotTable using Named Ranges
Attachments
vba filter dates
Can't Exit Design Mode because CommandButton2 cannot be created
help with web query
Maximum Number of Bloomberg DDE Links
Filling a cell with today's date (Datestamp completed marco)
ToDo utility in Excel VBA?
Does VBA round .5 up or down?
Search Cell Address and Cell Names in VBA Editor
bad arithmetic
Control to Choose Row and Column in spreadsheet
Function limitations?
Detect Custom Menu
Re: Updating Column
Send Mail question
Execute on Cell Change - Problem
Calculating Minutes and Time
chart
Using formulas in Excel
Autofit of Row Height with Merged Cells - AGAIN!
User forms in Excel
Multiple Occurences within a range
Removing every second instance of comma sign
Using Trendline Formula
UserForm Viewing
Workbook_Open() problems
Re: Dir("D:\") refresh problem
Re: sendmail macro help
how do I import macros from other users
OnTime method
Application Run Time Error 1004 and Stack Error
Re: quarterly reports
"Type" statement and arrays
Re: Formula that referance a Cell
Re: how to stop "On error resume next" ?
i sent by mistake
Beep when Messagebox is displayed
Looking up two variables
Input box used as password input
Select Until Empty Cell From VBA Code
Select a cell
Move an Excel macro to another Excel file
Calculate on Status Bar causing VBA to run very slow
Why get Ref in my cells ?
Import Text file
shortcuts to excel files.
terminate a runnig macro
Code behind worksheets
Frozen Status Bar upon Errors
Re: Get range value active workbook on open add-in
Autofill
Re: Workbook_BeforeClose problem
Increase macro speed?
Select Case on a range - problem
Problems with BeforeSave and Application.EnableEvents = False
ADO recordset error
Re: Excel Charts into Powerpoint
reference to cell left of a cell...
How to know whether it is using ADO ?
Time Code
trying to find random drive letters
Copy/paste range without resizeing cells
Re: last digit
RE: computing ratio for samples with many subrecords
Renaming an Excel file using a macro
IE in Excel with intellisense
Re: Closing Excel within itself
Write Procedure With Logic Test To Open File From Given Directory
RE: last digit
Language
HELP WITH CODE
Erroe on Geting External Data
Running code from list
need to remove last few characters from data in field
How do I sum hours from multiple workbooks?
Can we use "*" to replace string in VBA excel macros ?
Code to trigger drop down-select event
Obtain value of a control on a shortcut menu
Cell 255 character limit & VBA
Delete Rows on cell content?
Any takers?
don't find my message : connect to oracle db (4.2. 19:39)
Suppressing events
RS232 to Excel woorksheet
Lookup in VBA Array
mouse position in EXCEL
Merge rows with similar data
Dave Peterson
Tracing and reassigning macro short cut keys
Calling a macro on a remote computer
Add-in Asking to be Saved
Button Control Jumps Around
Select and Move based upon keyword
Automation Errors
How to trap automatic link prompt when an excel file is being open
Trimming Email addresses
Run-time Error "13" - File Type Mismatch
Select Case with Text
VLookup problem when a new row has been inserted
data validation cell
Change Event Track
validation cell
hyperlink to a button
Convert net tons to long tons in an Excel Spreadsheet.
Copy Method of WorkSheet Class Failed!
How to consolidate/sum a list
Shortcut Menu With Toggle Control
How can I get a larger list height for a combobox while drop down ?
XML creation via a macro
File Always Asks "Save Changes Y/N" even when no changes made
hide or unhide pivotfield using a checkbox
help
Button to stay on screen as you scroll
Select numbers between two numbers...
OWC Spreadsheet focus
Run Macro
Problem running code behind a userform
Find the zero(s) and remove from a concatenation
Default column separator
Check for an item in a collection (without looping)
For Each Loop with Exceptions
MSChart.chartdata + Excel Names
Function or VBA required to extract cell info from an unopened fil
Open a Workbook
Generate Random Number Table
Macro to combine data in a column
critique my project
VBA protection
Need help with VBA
Need help with FORMULAR1C1 property
test
user form and frames
Populating a select group of cells with randomized names...
Msgbox delayed using AFTERUPDATE
Help!
Make a Fresnel Zone Calculator
Time sheet
Formatting SUMPRODUCT
making drop downs "volatile"
Passing a range into a VBA function
dynamic named ranges
Convert Text Column to Date?
Docking Project Explorer Vertically
Absolute vs. Relative Cell References
How do I create a formula
Event question
Reported problems with Office 2000 Service pack 3
Drop down list disapear
Reference to analysis toolpak addin
Personal.XLS MACRO Workbook
HELP! Sh as Worksheet
Size of worksheet
Financial Calculation: Return on Investment
add-ins
OFFSET and SUMPRODUCT
Renaming Worksheet Error
Recording a macro within existing macro.
copying deleting in excel vba code
copy photo
Export table to SQL
Use of public variables vs. passing arguments
Unable to embed control - Microsoft Map is no longer supported?
saving blob
Pasting from Excel Clipboard with VBA Macro
QUESTION with Match command and OFFSET
Prevent Excel VBA Code from being Interrupted
Private Sub Running Other Private Sub Inadvertently
Moving data between worksheets in VBA
The Web query returned no data
Add-In
UF within a loop
Worksheetfunction help
Please help with do while
Programatically sending a sheet through Outlook
winsock lag error
Can I have an array of arrays and access an element simply?
format cell in excel as to convert any numeral into words automat.
More than just time
Listindex strange problem
Refer to selected cell in custom function
How to prompt user to set password that protects their worksheet?
algorithm creation
Public vs Global
headings in a combo box
Combo box column widths
I want to combine a "match" command with a copy and paste command.
Round number to 5
Macro Excel 2000 do not work in Excel 2003
Open a specific file
Wondering why the following ADO connection to Access isn't working...
Calling an excel spreadsheet from within a browser
Need Help Please: EXCEL+Vb Programming Newbee Question
What Causes DSUM to Report #DIV/0!?
advanced filter
cells automatically colour differently with 'what if' scenarios
Re-formulating the problem: Dynamic Button Names!
Set a Reference to a Type Library
How do i insert lines into a worksheet depending on if data exist.
easy problem for programmers
Comditional Formatting Problem
How to transform float to percentages within an array?
Colouring Stuff, Toggle Buttons
Fix column widths in Excel template
Button to allow a search
Row color change
Date Format Problem
Manipulating embeded exccel in word
Type Mismatch Error when running a SELECT SQL
Delete Line Macro - IF Function
excel macros running slow with XP
auto refresh
Trapping NO selections
Type mismatch error
insert variable number of rows
Workbook activation code
link cells
Toggle Buttons
For...Next Question
Default browser for web querys?
Start macro by Command Button?
Time Calculation - How long a macro takes to run
User created control for use in Excel?
IE not detected
Can't think tonight - for a friend, can you help?
Function for summing values of a field by date criteria
To read from an Excel sheet using simple ASP
printing
Network activities while runnung macros
trusted source/publisher
Visual Basic commands for email
how do i use the excel function search in excel vba?
Put text on clipboard?
Saving file
Comments in cell (try #2)
Better way....
open Goldmine email msg from Excel VBA
Assigning values to words, then referencing them in a formula
WS formula for Julian date not converting well to VBA??
Excel 2003 Memory Leak
Macro, if then next
Custom Worksheet Header
Function in another workbook
roster
Loop a macro
Format As TIME In A TextBox
Question about Excel
ODBC imports numbers as text
changing value of a list box
Offset.Value
populate a validation List?
filtering question
OFFSET in Excel VBA Function
querytable connection
Suppressing or turning off the Printing dialog
Creating a toolbar for my add-in
Dynamic Button Names?
Picture resizing
Report--anyone???
Email/Excel Website diff. methods
time problem
In excel, I am trying to copy a column to another sheet automatica
Delete String Element
Can Cell X be modified by Cell Y?
Using SUMPRODUCT in VBA
Running an excel spreadsheet from a website
Clearing objects in a VBProject
RangeSize set by macro
Row parts and range confusion
macro stop before end if I use a shortcut ?
Adding additional rows in VBA based on character strings
Photo in a sheet
Re: Copy cells without splitting column
Copy cells without splitting column
non-duplicated values
Using .Find with Hidden Columns
Shell command ignores parameters
IsNumeric Test
Copy Sheet Limit
I need to execute the SQL.Request with SQL strings larger than 512
Speed up code
Getting a File Date & Time stamp
Too much for Excel?
Format A TextBox For A Phone Number
Adding custom faces-icons to toobar buttons.
install a macro for all workbooks
Message Box Pop-Up
To Read from an Excel sheet
Copying formulas in a column
Run macro in another workbook
Excel file gets corrupted
Search and replace for non printable characters
Stopping Display Alerts
Automatic timesheets
Weighting random allocations within a range
Buttons work (but don't work in a cell)
IE not detected
Custom button starts new instance of Excel
Formula in loop stops working
PasteSpecial Paste:=ColumnWidths
How do I stop the cursor from scrolling?
Programing cell comments
Using A Macro To Add Event Procedure To A CommandButton
Detecting a printer is connected
Copy sheets
Add In target directories
Insertline Macro
IE not detected
macro - how to make working for colums D:X
How To Imoprt Text File With No Delimiters?
Calling a macro from a key
Averaging specific data in columns
Time
List valid values if a condition
How to transfer the length of one column to a formula in Visual ba
Please help to correct syntex error
MAKE WHEEL MOUSE WORK ON USER FORM FRAME WITH SCROLL BAR HELP!!!!!
I don't get it, Whats going on here?
paste image into a form
Password
Question about multiple data sources
Renaming a cell name
Distance To Margin
Re - Excel Loading Multiple Instances to Trigger Events amidst Switching-from-One-to-Another
a macro that launches another workbook automatically
Pivot Table
display contents of a worksheet in a form/frame
Test if Cell is Empty or Doesn't Exist
Workbook_Open
MsgBox Syntax
Format a txt box.
How to prevent routine from running on certain sheets
copy worksheet to new workbokk & save
Macros
Evaluating a Sting in VBA
change directory for refresh data
Range name as varible
% Formated cells randomly changing to hh:mm:ss format
vba coding for formula in cell
Help please
how do i write a macro to automate some scenario/what if modeling
Missing functions and commands
vba code
Formula Replacement
maximum days in a month
Need VBA assistance for Excel Open Dialogue Box
To Bob Phillips ( Filesystem)
Message Boxes.
Open file - How to test the path ?
Function behaviour, can someone explain please?
Date and day
Can I add a description column or alternate column in a validation
How do I populate this list
Adding a Chart or Worsheet??? with VB.NET
Updating an Add-in
Problems with R1C1 referencing in buildling indirect references
Counting how long a Macro takes to run
function trouble
How can I export cell content in Excel to a text file?
Delete a Worksheet
Looping through Worksheets
Custom date formats
Insert variable cell in the formula
regarding filter
Move down one line
Linking to hyperterminal
Code to Send BCC
How to set Axes Min/Max values in C#
Counting cells in a schedule.
Setup a macro to select a specific column within the same row
splash screen macro problem
Beep or Make Sound after Calcing
Finding column again
Table Caption
Dim as CommandBar Does not Work
Update Complete Message
Conditional formatting with imported data
Outlook and Excel
Changing a Macro
Getting value of an Autosum
Addin Menu Question
Counting CheckBoxes on a Userform
Count Rows
Merged cells numbering
Checking the number of files in a folder using VBA
Application Error 1004
User form/ to show please wait
Menu Issues when creating an Add-in
Check sheets name and open goto workbook
Formatting text in a a cell with selecting it.
Can You Change A CommandButton Code Using A Macro?
Create User Defined Folder
how to get rid of selection of cells, after pasting
Error exporting data
Embedded chart along with DATA to powerpoint
Coping dates
Copying an Excel Graph to PowerPoint
User Form - frame scroll with wheel mouse and cut & paste from tex
Preventing screenupdating from modfiied
Sumif Help needed
Re: Frank Kabel: A Sad Day for the Excel Community
How do I link the spreadsheet with data in MS Money 3000?
Is anyone having problem with Excel 2003 Application.ScreenUpdatin
AUTOCALCULATION IN EXCEL IS NOT WORKING WHEN FORMULAS ARE COPIED
How do I stop duplication of cell data from a list (you can only .
Re: A repost - Permuting SPACES within a String of words
Dynamic copying & pasting of rows
Web Query Query
Change color depending on cell value
Find the range of a SubTotal
Excel Start-up parms
VBA/Vlookup with workbook defined in a variable
is word really smarter than excel?
Formulae
How do I determine if conditional formatting is applied to an exc.
auto start filtering
Error in code re case construction
Nesting ,Ands
ListDir
Lookup/Progamming Help!
Extract formula from Text box
vba 2003 cut copy animated border
Hidding macros
Getting info off the Web into my spreadsheet
msg for ron
Export Excel Data to an Outlook Email
overflow error 6.. the macro just stops any idea why?
excel freezing
messagebox problem
find highest number then select next cell
Networkdays
How can I set up a page tracker?
include empty sheets
creating a collection of Sheets references
ontime method?
ontime method?
Excell 2003-How Do I get custom drawn shapes into Autoshapes file
How do I write a macro copies a column to another sheet but that .
New to VBA
Some help w/ simple loop, please?
Clear then move text up
Button flicker with screenupdating
skip empty sheets
Regular Expressions in VBA?
count non-empty rows
If statement
VBA Equivalent of ASP 'Execute' Command
How do I enter Unicode characters in Excel?
Macro asking for input
Changing Text in PowerPoint
conditional reset
Redesign for hitting limit argument in a UDF
Copying a range of values between worksheets
Protecting non contiguous cells
dialogue box problem
construct range?
Lookup Outlook Contact to Fill Excell Cells
how can I add a print dialogue?
Select file after GetOpenFilename
Userform1-Can I override the need to click on the form?
Using 'On Error'
Check rows for duplicate references and add related data
Why is ActiveX invisible in Design mode
how to reset a value in a cell after another
how do i auto date a page in excel
Calculate Number Attending
Insert Row Condition
Change cell formula & assign to VBA variable...
Naming columns
Extracting Custom Menu Code
Automatically Replacing existing file on save
Best options for importing text file
Find a String in a Cell
excel and access melded would be a wonderful platform for medical.
Online VBA Training
names changed somehow
Using VB in Exce, can I loop through all worksheets?
Excel Linking to Access
Recently Used File List Doesn't show saves
function for finding position of numeric character in a string
Excel97 How do I enter a formula help please
Import txt file
So close! Problems with Loop
word more intelligent than excel???
Coverting Dates to Text
Ecxel Macro to summary and eliminate duplicates
moving cursor to text box
msgbox
Strange Log base 10 results
Hyperlinks - They seem to work fine - just cannot find the cursor
How to return the xlConstant for a number
Sort and Combine
Failure to open workbook via automation
Enable Warnings
Incorrect templates path
moving cursor to a text box
How do I switch between windows in the active workbook inside a M.
Internet Explorer & Excel
copy temp sum in bottom right of excel to clipboard
Is this imposible for VBA to perform?
Macro Auto-Fill Field.
VBE Weirdness
sum over more then one sheet
Delete method
splash screen
File name a variable
Shared Workbook; Update-on-Save not working when called from code?
IF Statements
Excel Access VBA
Automatically copy down a column
connect to an oracle db
Comment indicators - web translation
Unknown address change
VBA VLookup Problem: Run-Time error '1004'
Abandon invoice
Copying Workseet to NewWorkbook
Insert the same value in other sheets
Formula - Time, Cell
scrollbar on a text box
Add shortcut key or hot key via vba
Run-Time error "70" Permission Denied
Restricting User Input...
excel
Microsoft Query: retrieve data by dates
Microsoft Query: retrieve data by dates
2 Worksheet Comparison Across 2 Workbooks
GetOpenFilename
Analyzing Text file records in VBA without importing into Excel spreadsheet
Auto-set Chart Data Range
excel VBA
Moving Access Mini App to Excel
Copy picture from image control
Rumba/Excel
Saving in a location
Erase Code
Problem with if statement
Path names to xla file in formula
Only print worksheets with data in B2
Do you wish to clear clipboard memory?
copy last row without header
Argument limit in Excel Function Wizard
Save Filename
how do get rid of a selection after pasting
Text file to measure file usage
Text box
Deleting AutoFiltered Rows
Application-defined or object defined error
Range selection problem
Properties with Intellisense
prevention emergency kay - for experts
Re: Passing var types, groups and properties to a sub
ScreenUpdating & DisplayAlerts
Change event help
Hiding All Groups
Finding column of a particular cell
Mass update VBA macros with batch program
How can I set up a dashboard in Excel from which different worksh.
Re: Date Time Picker ActiveX Control Version 6.0 (SP3)
Re: insert sheet and naming it
4 column sort... Fools rush in....
Run/execute VBS and pass arguments
Exporting to Word
Wrap Text
Can I save my Excel sheet with Macro as webpage? It seems the Mac.
Storing variable in Option.Tag
Delete a file
Loading Excel Data into PeopleSoft
Reading dates from text file
inventory location flow sheet question - formula needed
Row color by grouping?
Sorting Problem Need
When MultiLine Txt Box Returns a square to the formated wordwrap cell
Re: Problems with sorting a pivot table
text box
Retrieving the state of a checkbox (form type) from VB .NET?
Re: aligning data lists with code
Error on refresh backgroundquery - help please
SQL Query
Excel Addin and Windows Profile
Query on implementing drag-and-drop with VBA
Re: RTD returning arrays
2 Quick Questions
GetObject() returns different types of instances
Excel 2003 VBA question
Sort Filter & Create Text File
Waking up a Printer
Working with columns of data
Modify Name, Title, Author, etc. of an Add-In
List Worksheets & Chartsheets
Naming and Adding Worksheets
String Function
UserForm positioning to second row
Using Excel Spreadsheet to Survey Customers
Using Excel Spreadsheet to Survey Customers
merging cells and comments
another "400" error
Re: automatically select object references
Random entry from list
String manipulation and creating an "offline" excel workbook
String manipulation and creating an "offline" excel workbook
HOW WOULD I GO ABOUT ADDING SOMETHING LIKE A SHOPPING CART TO AN .
vb "400" error
displaying info on a form
disabled list box text color
shared files
Total Row Not Calculating Correctly
Import External Data
passwords
Re: how can I return the active row and active column?
RE: ? for Jim Thomlinson
Using listbox as menu on userform
For each Checkbox
RE: Moving rows to 2nd tab when worksheet is protected
Programatically access Excel's Solver?
Format NOW function
Re: Simple Checkbox Question
RE: Help with imprting a csv file into excel
Refer to Elements in an array
Re: Custom Menu
RE: How to require entry in a cell or group of cells?
Re: Moving data from Col B to Col A
Re: Interaction with Internet Explorer
Re: Simple Checkbox Question
Re: macro to white out (to change a font in selected cells)
How can I make a custom button in one Excel form to e-mail easily.
De-link a cell reference in a formula.
Pivot Tables - Percents in subtotal
Help with Condensing 10 Digit Number Please
Workbook activation issue
#Name?
Excel97 Date and Time Help Please
Relative/Absolute Formula writing in to a cell.
Inserting formula programatically
Using Array Index function in a sub
Passing an array in a user defined function
RegEx Replacement patterns
recover worksheet
Test for end of array of objects?
Passing a Range
I need assistance getting VBA code to do the following...
My Excel formula is using my text as a cell range.
Visual Basic Error
display sheet choices in combo box
Argument limit on user Function?
Error Loading Add-In
matching items on 2 sheets
Rename Sheets
Finding a match
Ex03 Custom views don't work
Application-defined or object-defined error on copy
Range Name
Removing Excel Add-Ins
returning filename in excel
Turn Rows into Columns
Turn Rows into Columns
Automatically enable macros for particular template
How do I split "A1B2" into "A1" and "B2" using text to column fun.
Special Index/Match formula
Making Workbook_Open macro conditional
Help required putting borders around cells.
How would I set up a Genealogy tree?
merging or cancantinating worksheets
Error unprotecting worksheet
Rename sheets
Please help me to adapt this code.
updating a text box
Two big size excel file
Count Days Worked
VBA ActiveWindow.WindowState Problem
Find and Open Workbook then copy and move sheet
VBA Code to Import VBA Modules
Open PW-Protected MS Access db using Excel VBA
Avoiding 400 Error code
Format to percent in msg box
error on ActiveWorkbook.Close
auto add rows to ranges
Esc out of userforms
Setting up autorecovery problems
How do I format a text box control to display the source in time .
Copy Column A
matching items on 2 sheets
another question for Tom
Prevent running macro upon closing Excel
Macro to change cell borders
Data Form (ignore previous one)
Data Form
VBE Question
Parse String
combobox to drop 'up' not down
Inserting Hyperlink
changing pivot table views with a macro
More than 65,000 lines and ACCESS
Difference between Word and Excel
Excel Wookbook naming
Sort Contents of Moving Range
macros code & color based functions help
data entry template
Formula in given via input box
rename worksheets after copy
Anzeige "Bitte warten" während Makrolauf ?
Can I list which sheets/cells have changed?
Between values
.AddShape(Type, Left, Top, Width, Height)
Auto move scroll bars of listbox
Excel VBA
Userform handling
Find, Match, Compare or Search.... Help!
VB msg box - can it have a title?
greying-out item on custom popup?
Macro to Extract Values from Master.xls to Report.xls
Event Procedure again
without for loop
Event Procedure
Hidden cells
making normal text to hyperlink.
Autofit excelrow
Limit User scrolling
show messagen when running a macro?
How to calculate this on all rows?
First Empty Row
troubles when 2 webbrowser navigate simultaneously
Numberformat for Cells using Automation
Excel SendMail Not working in XP Office 2003
Copy changed rows into a new sheet and save them
Reverse VLookup?
Finding new entries in list
Macro to Count how many times a number occurs on a day
data validation quirk
how do i programmatically insert a button on a worksheet
How to know a row or cell is blank...
copy active worksheet plus another worksheet
How to get enique records from data list?
Range of even/odd rows
problem importing data from another file
sending the active worksheet and an additional new sheet
how to set random numbers that add to 100%?
create a right click menu in excel 2002.
Spreadsheet with merged cells - how can I unmerge the cell and re.
Dates to Worksheets
collection of sheets
Opening a dialog
hyperlinks out of a combo box
Userform runs other subs when initialized
Macro Start Autorun without Enable security
VBA project in Intranet
Removing Defined Names
Selecting a variable number of cells in a row
The disk is full error message
Formating of Numbers
Logging activity
Number Formatting when joining two strings
VBA Help
How can I get this code to work?
Display history in user form
How to add control to toolbox
Form writing blanks!
R1C1 and the $ sign
stack space deficiency
Relative referencing in macro won't work
Is There a Function To Reset Macros?
Page Break
command button move worksheet from one workbook to another
How to keep a workbook visible
update label or text box
Copy cell data Workbook to Workbook
VBA Excel project won't work when opened in intranet
Adding and Changing 'CustomDocumentProperties' from VBA on other f
Passing argument to another Sub
TextBox in UserForm with > 24h time format
Validate Data in VBA "How to get lost focus cell address"
Outside Data Sources
Application.Selection Is Range?
USING SOLVER IN EXCEL
stop recording toolbar
Displaying cell contents based on input?
how to copy formula without changing reference
converting a cell text to date
insert or update
Hiding Workbooks
How can the range.calculate macro be run with "iteration" and "ma.
How to detect another application
Displaying Custom Toolbar in Specific Worksheet
Passing CheckBox Value from Click Event to Main Macro
Recordset Filter by Array
disable right click menu
File get bigger when I save in excel
How do I plot a scatter plot in 3 axies?
Extracting footer informatiojn from unopened XLS file.
Extracting Footer information from unopened XLS file.
Stripping out contents of a cell after 8 characters?
Do loop without do? Why?
Set certain rows to Bold
Changing Sheet Name
Import xls file..vba excel2000
VBA Form Button Closing WorkSheet
Disassociate Macros when saving under different name
SelfCert
Adding checkboxes programmatically to a worksheet
Adding checkboxes via code to a workheet
Save without prompts
Cell value prefix
Jump to the next count in a FOR Loop
Preview of Spreadsheet/Document
Stuck on a validation loop
Creating a (Modal) version of File :: New :: Contact from Excel (into Outlook)
Finding Last Column in a given Row
counting items in a range
Footer info from unopened workbook
Capture footer info without opening a workbook
Model Audit
Convert a String to an number
Check cell contents then format as locked
Want a simple VBA code.
give back times of current month automatically
Autofit, Centre and Text
Populating the combo from worksheets
find value and copy column to new spreadsheet
about "GET.CELL"(cel interior color)
Removing Password using VBA
Commandbar - how to find out which msoCommandButton was pressed
command to be run at a certain date
Help needed with this autosave macro problem
Using .formular1c1 with the Range/Cells Method
Renaming a Module
Changing data in a column
ActiveSheet in a Macro?
Font Examples via a Macro
replace cut command
UnMerge Opened Workbook from Add-In
How to Determine if column of certain rows in a text file has data?
Beginner looping / summarize question
Macro one workbook to another
converting from text to number
VBA question: editing alpha characters out of numeric values
Need help with a macro
Remove a Reference
union problem
opening consecutive files
Resources problem with VBA & charts
Create an Adobe PDF from other PDF files
Saving A File
Must be first
'Right'
Refering to Desktop
VB in Excel
List Box - MultiSelect
Coding with pivots and Multiselect list
EquationType Property
big counting problem
Using VBA to Paste items copied within Excel
Format
VBA Range Issue : Cannot programatically select more than 42 columns
Validate mm/dd/yyyy
macro extracting text
printing and viewing
Changing font color of textbox text.....
Fill in the blanks
Code Line Number in VBA
Add-in Auto-Generation
Error Trapping
RE: Fill in the blanks
code line number
Adding text file to a user form?
Count elements in array
Trust VB projects setting Grayed out
Can I get a chart to an image file?
On a PDF Note --- Check this out..
extending excel named range with vba
Problem getting info to transfer
Close Adobe after printing
Selecting range based on values
Running code on hidden sheets (revisited)
IQY
loop calculations in excel?
Set row heights to values in cells
How do I invoke a VB subroutine that exists in an Add-In?
Formats: Too many different cell formats error message
Multi Selection List?
Passing String to Formula1 Method in VB
Array or Pivot Tables???
Problem with the round function
Adding files to an array using Dir
Splitting string into letters and numbers
Returning Cell to Upper-Left-Most Corner
VB question
Open Save & Close All Files in Dir
Auto_Open question
Select Visible sheets
manipulating a textbox in charting area
Running code on hidden sheets
Renaming Forms
Cells(r, c) syntax and horizontal alignment
autosave before close
Is Validation?
Selection in data range
Sum of Variable Cells in a Column
Conditional Hyperlink?
Filesystem again
Error Handling with a Match Function.
Programmatic indication of file to be PROCESSED.
sumproduct or other way in vba, help and thanks
delete values in cells
mutiple same lookup values
Bulk processing
"Formula is too complex to be assigned to object" ?
VBE toolbar not ready for cutomizations
SQL Connect
change worksheets through code
is it a microsoft prob..can it be resolved or not?
Qualifying OptionButton with ro without MSForms
Macro for Emailing a spreadsheet
Protect VBA codes
Macro compatibility problems between PC and Mac (Excel 97 and Exce
string output needed
Combination of 2 combo boxes to populate 3rd
Automatically run a macro when a cell = FALSE
Programming the Progress Bar problem
Does folder exist problem
Macro?
define a database path
Is worksheet open
VBA 2003 Save|Change|Restore builtin menu OnAction
msoControlButton tpye problem !
How do I have an image in a cell based upon a referenced value?
Determine if it's a leap year
second file/Workbook open
Toolbar Icon Size
Input form question
Loop Through All Open Workbooks
VBA Code to Print a Variable as part of CenterHeader Problem
Must be more than 1
Workbook_BeforeClose
Installing a Custom Add-In
Search by rows and then go to selected row...in a frame?
Menu Item Deleted
Saving a column of data in another file format
Creating a "To Do" List
Corrupted Macro