Excel Programming [Archive] - Page 91

Copy data in new sheets from criteria using VBA
VBA Refrerences which interfere
building a search tool
optionbutton with worksheet change
Hyperlink verification message
Capturing text in a command bar as it is entered
USE OF DISTINCT COMMAND IN MS QUERY
Macro needed to set macro security in Excel to minimum
macro that waits for prompt
posted data in a range of cells can't change after three days
Posted date in a range of cells that can't be edited after three d
Workbook won't save
speech with if formula
Fill Problem
Matching and Moving Data From One Spreadsheet to Another?
Matching and Moving Data From One Spreadsheet to Another?
Help with ??
Macro?
Copy worksheet to another workbook
UserForms and double-clicked worksheets...
Insert Row when zero or Positive value
dynamically loading external macros, on the fly
Macro to add rows at a change in data
Delete Directory Contents/DOS Shell
Creates table instead of exporting data
number of months in a period
VBA Question - Applying values
vba copy number to Column as letter ' B '
is it possible to run a macro using a cell reference?
Remove password from VBA project
VBA code to Paste into a specific text file
UDF is updateing cells on another sheet with count from current sheet.
How can I refer a particular Sheet in a work book from a word doc
sorting w/ blank cells
Help w/ project. Counting upper and lower case characters in a cell.
Closing Excel documents
UserForm
VBA for Consolidated Worsheet
Arranging 3 windows ... Regardless of Monitor Size
Help with macro!
Menu ID of Shortmenu (Right click)
COMBOBOX VALUES NOT BEING RETAINED
help system
Clearing Macros from Workbook
Can I save multiple email attachments using excel automatically?
macros in excel 2003 won't work in 2000
I can't delete my worksheets
VBA Question: Move cell contents if...
VBA Question - Run this code on another column
Creating a User login Log file for an Excel workbook
VBA Assistance _ Summing
Forcing Dim Requirement
VBA to make a workbook Shared upon opening
Copy cells to new sheet
Searching for 3 variables
Selecting array element.
Locking a toolbar location
command buttons
Dynamic Chart Via Code
Checking access to Sharepoint prior to use
Help please...
Unable to get the Vlookup property of the WorksheetFunction class
Can Paramaters be used w/ OLE SQL Query & Excel
recognizing names
Select and Delete Every Other Row in Excel Sheet
Convert SpreadsheetML to binary .xls
Intersect check range
add a new line above a certain "keyword"
Macro To Lock Certain Cells... Please Help
How to Set a Variable in Another Module?
Strange untrappable error
Standard deviation and other formulae
Possible to hotkey/underscore a VB button on a worksheet?
Lock out worksheet
Macro to only allow pasting of values and not format??
Check value and add to list
Protect selected sheet(s)
An Easy Mod For Sure
Userform formatting
DDE Commands for EXCEL
RE: Error messages from user defined Excel worksheet function
vba conditional loops
Protect Comments from deletion
word to excel
can data be sent from a cell in excel to a database table?
Help with text file
Save without 'Replace' Prompt
Every 4th cell is blank and stops my macro!
VB multiple criteria countif change event
Excel in Perl VIA OLE -- saving workbook(s)
Subject: VBA Question If column contains keyword
Change Event with Check Box?
formula not showing up
Automation (error 1004)
Look ups, a prompt box and fun all around
rename a workbook using a macro
copy / paste
help!! reset a form
Pattern / Combinations
delete spreadsheet
Deleting a sheet if it exists?
values
Unhide sheet based on NamedRange?
permutations/combinations
search column and output results in new worksheet in a different o
What's the syntax error with this SendKeys code?
Final Weekend for Standard Registration - Excel User Conference Book Drawing - April 2006
Correct way to call function with 2 args...
re: Type Mismatch Error
Copy and paste a graph as a picture?
Re: Copy and paste a graph as a picture?
Problem with English formula in Swedish installation
only edit from userform
Unable to set the Orientation property of the PageSetup class
Update the list of a combo box, depending on another c.b
Dynamic pivot table
Merge to Columns with Unknown length
Can I create a Custom Colour?
implement test="=(SUM(R[-181]C:R[-170]C)-string1)/string2 "inVBA?
Consolidating/Grouping Data
Deleting Duplicate workbooks
Help in modifying a filesearch macro!
Auto form
Bug When Try Using VBA.UserForms(FormName).Show
Embarressing Problem with Menus
How do I set up a spread sheet that will add my hours work in h:mm
Automatic links to another workbook
Looping through a range & getting values
Rename worksheets with VBA
Urgent help from all excel expert !
Tab Order on Form
Converting Text Values to Time
"Dim" problem
Macro assistance please
how do i change or make this macro??? pictures and code included
finding values
Start a new column if list gets too long
Telling a procedure to end
Worksheet loop won't loop
Huge data structure in Excel
Summing the values in text boxes
Using VBA to Insert a formula in a cell
delete from : to n rows after finding data in a cell
Adding Series to an Existing Graph
Automatic Config Tool Question
Open many *.tsv files in folder and import the data into Excel
Unable to get Match property of worksheetfunction
equivalent code in c# for excel
Delete files within a folder
what is xlb file
Programmatically create totals and names??
Formatted Number into String Variable, Excel VBA
Mapping Data to Excel
Help finding the length of two different columns
Absolute references
RE: Absolute references
RE: Absolute references
Enable and Disable Tool Bar
personal book will not open
RE: personal book will not open
other users unable to use macros
Simple Excel macro
Many Tried It Byt Can U...
SQL From Access Not Working
Paste Special Values Syntax
Pictures tied to rows.
Assign a particular colour to rows based on their current status
RE: Using Shell to open files with more than one word in their name
Using Shell to open files with more than one word in their name
Cursor Type
Mystery ALT key character illudes all methods of extraction! HELP!
Variable overflow
Can Excel do this? (Template?)
conditional sum macro
macro help, please
macro - delete row if cell contains string
Help with better loop code
Macro, Excel: insert cell between colored cells ??
Array to Worksheets
Select range with InputBox. Is it possible?
Sheets Array Selection
How to quit from Powerpoint launched trought VBA codes in Excel
Range.Copy only works with a named destination parameter?
Change label caption on userForm while code runs
saving xla problem
Worksheet Protection
Is a cell formula (IF cell is a %)
Shared workspace vs share workbook
Make a toolbar with customized buttons
Moving sheets
Lock condition based on a background fill
Accessing workbook after .OpenText
Reasons for "Run-time error '13':Type mismatch"?
Evaluating columns based on criteria
Making the macro more flexible?
VB code almost works...but can't find a minor mistake
how to disable zoom in excel with vba
Automatic range adjustment when copying data
Unable to copy and paste between 2 instances of Excel
Using a static set of data to use as input criteria
Create dynamic dropdown from range including blanks
Relative positions from a button
Buttons in Msg Box
WNetGetUniversalName - how to implement in VBA?
PrefixCharacter
"Subscript out of Range" Error Msg?
Copying select cells using VB
More Problems with CBO's
sorting and deleting sheets
Finding named ranges
Help with cell reference
Intercept/replace standard 'cell protected' message with my own message?
Another UserForm query
Array Help
Alphabetical sort in a macro
Interactive Form
Macro/VBA help - lots of xls imports
Final Week for Standard Registration - Excel User Conference Book Drawing - April 2006
Macro Question
Inserting and formating variables in header
cycle through comboboxs with an integer
Why can't I merge cells in a protected sheet?
Number Format
VB Problem - Help!
calling function form within sub
Calling functions developed in VSTO 2005 from Office Excel 2003
Locking Cells on Validation
Problems importing a CSV-file
Reg : Material List
lock/unlock cells
Array Function won't fire
Working with Menu Bars / Toolbars problem
using a VB function in a spreeadsheet
How to Know Last Run Macro
Call
Can we Set Default value for the Excel promt(Y/N)
is this a bug or feature?
Paste Formulas button
EMAIL
Macros or functions
How do I convert 281 minutes to 4h21m in excel
sort cells by color ?Macro?
message box to check value
doesn't recognize fraction in string as numeric
Copy and paste from one sheet to many
CDO emailing
Is it Possible to Find Shape at a Location (#find) for XL97?
Shell function
Upgrade, now buttons point wrong
Compare file names to folder contents
Saving file
Excel User Conference Book Drawing - April 2006
On Error {...} Resume Next
Excel Deletes Top to bottom
Insert Picture
file sharing
Trying to SUM up a DATE/TIME field in code...
autofilter, launch action
parse info. from one workbook to another automatically
Creating xll files for excel 2003 with Visual C++ 2005 express
Another UserForm query
copying an entire column
Excel 2003 - how to arrange sheets side by side?
Newbie needs an OnKey
Protecting worksheets
Clearing Memory
Clearing Memory
Copy Destination fails
String help
Tom Ogilvy, follow up for "coding for footer"
show times vertically?
Clearing Pivot table
Cursor mystery...
Password Protect a single cell
SUMPRODUCT on an entire column?
Formula in Pivot Table
Running a macro based on a value
last try - do until range
Isolate array formulas in a range
DDE link
what is wrong with this code?
Creating .xll files in visual c++ 2005 express.
help with code
Evaluating criteria within certain columns
Linked cells, VLookup? don't know which to use
Data Validation
change from lowercase to uppercase
Auto Copy Macro?
Cannot Save XLA add-in menus
Changing a sheet name to the current date
Storing Context Information in Cells
Positioning text Boxes on an excel chart
VBA Do Until Range("xcolumn" & 6) = ""
Error 400 on executing macro first time in terminal server
Document Recovery Pane Covers Worksheet
Removing VB Modules Automatically
E-Signature by username
Change MM/DD/YYYY to MM.DD.YYYY
Error Driving Me Crazy
Command Button design question
Excel Database help
Iterating rows, calc cells in dynamic sheet
Bloated file size
Better MRU list possible via VBA?
Fill a column in a worksheet from a formula worksheet based on the date
opening and referencing another workbook
VSTO 2005
Embedded vlookup question
delete query
VBA Control Issues
From excel to folders
New macro
How do I automatically populate a Pareto chart in sequence?
Excel VBA Userforms - especially check boxes
Text transfer
Rewrite Subtotal Fomula
Only part of Comment text appears
Application.FormulaConvert
VBA Consultant Positions
IRTDServer Error codes
Macro to delete names except Print_Area
Week Number Function
Problem running basic SQL in excel...
Creating formulas
Protecting a Used Range
Sub Total collumns
Macro to make a graph: help selecting the data ranges.
Switch Signs
Excel VBA Combo Box Populating dependent on other combo box choices
email as attachment in code
Sendepostmeldinger med vedlegg
How to pick the right file
average with 2 conditions
Insert Characters in cell with formatted text
Reading information from a closed workbook
Text Box Link
Reference filename used in code from cell
Problems manipulating a EXCEL Worksheet based on a SharePoint List
CopyfromRecordset
Vlookup 2 columns - help
save sheet as Unicode CSV
Writing Complex Macro or VBA Code?
msgbox / inputbox etc
Calendar Control & ActiveControl
Row deletion and auto filter
convert negative decimals to positive
add items to combo box
I want to sum two conditions like apples of Grade "B"
VBA vs chart
Programming a new macro
Number stored as text
selecting a cell - really need help
Consolidate workbook sheets to another workbook sheet
Pivot Table Help
Insert line via 'IF' stmt
HELP- How can I start off excel with a new worksheet: sheet1, everytime?
fomatting excell cells
Addin - 1. Links & 2. Install/Uninstall Error Message
Referencing variable in a loop
How to refresh the content in Shared Workbook ?
Need Help soon on how to search through a range
Hyperlink-link so that when a cell moves the link also moves?
Send Email
Fixing VBA code to better suit concatenating needs!!
Call Event and Load Form based on Variable
autogenerate rows based
Retreiving Data from the Internet
identifying the first character in a string
Print latest"Sheet 1" from subfolders
coding for footer,help please
Is it possible to prevent WB_BeforeClose with VBA?
Macro protected work sheet
User Form - Range Selector
Copy between workbooks
Option window in macros
VBA-Books
Hyperlink verification message
Custom toolbars for specific files
Disable option save when close excel
Constructing Inner and Outer Loops in Excel VBA
Combo Box Load Above Control?
find entire cell value
How do I add a hyperlink to a particular cell to a textbox using vba?
use of scroll wheel in combobox
Complex VBA question
Re: Complex VBA question
VBA Rookie Issue
Read/Write variables to XML file using VBA
Long character string - need to remove part of it
Re: Removing A - Z and 1 - 65536
Finding the first cell in column where value <> 0
cannot find date in formula
cannot find date in formula
Exporting datagrid contents to Excel using ASP.NET
Prevent Cursor from Changing from default
Print a sheet without ever selecting the sheet
Find the POSITION IN A RANGE of text in a string that matches value(s) in a range
Macro to copy highlighted cells to csv file
select cell
Generic pivot table data organizer?
String manipulation in macro runs slower each time ran.
Syntax problem defining range for pivot table
How to clear links to external workbook
Create Class Module using late binding
Auto RenameTabs!!!
functinalities in excel chart?
How do I sort numbers from left to right and down in order.
Macro - Save As - Changing
option button disabled
If... and... AGAIN!!!
Dynamically Hiding portions of a UserForm
Data / Consolidate
Too many calculations preventing Private Sub from executing macro
Cycling through all worbooks in a folder
Password Help - Urgent!
FileSearch to find partial words?
Pivot Table (Changing the word All)
Trapping Excel events in c#
Edit=>Links dialog box-use code to display
What does Average(R[-29466]C:R[-29185]C mean?
data manipulation in access from Excel vba
Change in one Worksheet Activates Another Worksheet Change
Populating Two Dimensional Array
Need help with Macro
forcing the opening cell to open at top?
Hmmm
Search and Replace Rows
call a excel function from a vb project
VBA - Move text in one cell if another cell is not blank
Dynamically creating a toolbar button
Moving data from 3 columns to next 3
Excel COM Automation crash
VBA - Move cell contents if bold text
can i get help with indirect formula
sort function - from ascending to descending
Any way to react on grouping sheets?
Is If-Then Else limited to seven Elseif's??
Combo Box Protection Problem
Macro to Transfer info from one sheet to another
avoiding duplicates in listbox (added from another listbox)
Spreadsheet To Auto Generate Monthly Calendar
how to protect the colum in excle sheet
OnAction with arguments supported
Disable the "customize" window
Macro idendifying keywords
Intriguing problem with the " quotation marks.
Interrupting initializing stage
Code out 'Web' toolbar
Select a range in a column in currentregion
vb to excel
Shared worksheet
Help with formatting right-click menu caption.
VBA - Inserting a reference / checking
VBA- inserting multiple cell values into single textbox
Profit Margin Trend
GetObject
Security design help
Refedit - Limit selection to only one cell
HELP: how to detect if printers are installed? woes :S
can I search all worksheets in an xls for highest number on load?
Excel .NET Add-In '' could not be found
Find double instances of a row
userform not showing text when run vbModeless
How to use Excel VBA to cancel Excel readonly status
How do i create a macro to find a specific data?
calculate cell before moving to next cell
Help Regarding SaveAs option in VB6
What versions have userprotected rows/columns restiction etc?
Delete Rows question
Call a Function
Auto-Run
Text comparison issue in macro...help!!!
concatenate formatted cells in excel
If and then statement macro
DatePicker
I have many cbox value to chg would like to use integer to do
Disabled Absolute/Relative Macro Button
Using a checkbox to change a formula
Workbook looping to many worksheets
Changing Range on Pivot Cache
Speical Characters and Macros
How transfer data from one file to another other with VBA
comboBox vs Listbox
setting color for range of cells blanks out gridlines
rotation schedule
edit an XY scatter plot by selecting a data point and dragging it
How can I link a cell in sheet?
Using range names in a macro formula
How do I insert 'date modified' for a whole spreadsheet in the foo
CANCEL EVENTS
Passing scrollbar control to keyboard arrow keys
Looping page fields in pivot table
Looping page fields in pivot table
need help on this
Merge Cells depending on another column
reverse text
Clearing target cells:
Running macro within a macro
Fill ComboBox with Filtered Data
Vlookup and Match functions
How To Establish A Link Between Two Workbooks ?
control toolbox is disabled
fixed width file?
include macros in another macro
Automated Calander
Run a macro within a macro
VBA not 100% need help with variable
Combobox query?
SaveSetting: Excel 2000 & 2003
Conditional formula and a bit more...
VB.NET code for Header Font
VBA for "Find" function
Worksheet_Calculate question
Add wordwrap to macro
MsgBox basics
VB.NET line break in header code
Copy specific Sheets and save them as a workbook
Listbox Search Function
Excel 2.1 - .NET Automation
Excel 2.1 - .NET Automation
lookup problem
Entire column, but not top 8 rows
VLOOKUP question
import data without query
Improve Speed by desabling Automatic Calculation
Excel protected workbook appears opaque to virus-scan?
How can I programmatically check in Excel 2002 if a sheet exists?
Digital Certificates and other users
VB. NET Code to Change Excel Worksheet Header/Footer.
Copying Word OLE Object content between objects
removing word wrap from a text file
Another newbie question please
Excel protected workbook appears opaque to virus-scan?
Looping a column in workbook 1 to workbook 2's sheets
Cell Input Monitoring
workbook open event issue
why can't hide zero's based on a zero valuer in range
Change cell catagories?
Macro to Export Selected fields to an Existing Access Database
Subroutine in multiple Workbooks
Edit code - exclude sheets
How can I draw a Parabola in Excel? like y = x^2 + 3
Importing Excel Sheet Problem
Programming question
Before Print
macro to copy all print settings to all sheets
Macro to delete worksheets
application.match and multidimensional array?
Userform Icon
Macros
Creation date in cell
initialize an array to 0
Button: ActiveX programming
Selection.Delete Shift:=xlToLeft (what's the meaning of this?)
Delete row and auto filter
VBA search code
Macro to open and close an Excel file
VBA Question If column contains keyword
Formula SheetName Syntax
How to run a procedure on entering a specific cell?
Prompt for filename in excel macro VBA
Trouble setting visible property for PivotItems
Hyperlinking multiple files
Help with code please?
PAGE.SETUP header format query
rearrange numerical data with eliminating -1 and 0
Activating macro on mouseclick
run macro when a range is changed
Flagging tasks using Networkdays
creating Excell with Digital Certificate - Batch Mode
creating Excell with Digital Certificate - Batch Mode
How to capture a Property as a variable
Se if workbook is Shared with VBA code
How do I enter values in a Combo Box with Excel
how many "IF" can be used on a Formula
Userform / Visual Themes Clash
Tracking workbook user usage
undoing the for next procedure
Change makro
Creating 64 new wsheets and naming them in vba
Batch Workbook Printing for selected
Urgent: what functions to use?
If I enter a value (A) I want excel to tell me a value for (A)...
Change the look of one of three columns from the control column
Multiple workbook
PivotCache Data Source
VBA Query
Basic ADO medthod - working with recordset, plz help.
The best club for muslims all over the world!Have a try!!
Empty Cells if Not Pass the Validation
Loading a Userform
Good books for Excel advanced users
Sort Macro
Conditional Formatting?
Sample Form
Help for Programming in Excel
Edit String VB Macro
open & repair through vba
Hidden rows
Prime Number just for fun
Interacting with Excel open in IE
mailmerge to a word document from email addresses in a single cell of an excel sheet
how to reset data entry cells to 0 or empty
RTD and Exceptions
UCase?
Refer a specific cell in a named cell range
Populating Combo Boxes Still Not Working
Toggle Selection Mode
RefEdit
Disable the prompt when clicking on a protected cell?
Table
question regarding dynamic cell colors
Execute Macro When any Built-in Autofilter Button is Pushed
Error 13 when macro run more than once
user forms
Need to apply VBA code to multiple Worksheets
Use showpages command for more pivot tales
sum up an unknown number of rows
seeking spreadseheet beta testers (off topic)
Hiding SQL Connection String
Code to reference offset cells - NCAA
Macro not firing off
Declare a class module in General Declarations
RTD server architecture - single topic update
Can't find today's date
Data back to Form???
Is Range ?
error with saveas....
automatic field adjustment
Adding Time via mouse button
how does one follow a cell link to another workbook file
Getting started on a Mac
Can you set a Window's Environment variable in VB
How do I turn off print preview with a macro?
Trying to undo labels
copy content to first empty cell in column
Boolean in VBA are returned in local language
Header concern
How do you count how many times a cell is entered
Question re Workbook level declarations
Populating Combo Boxes
Conditional formatting not getting sorted
Image changed based on vlookup function
need a formula please
Dropdown box linked to another workbook
Loop for if then calculation
AVAYA CMS Scripting through Excel VBA
Disabling the "could not open" notification
Q: How to color a cell based on values in two cells
Out of Present Range Error using Excel
How do I change a macro's font size?
2.7mb takes more than a minute to open
Excel 2003 Add-In problem
A little help with cell reference please
centering checkboxes
Workbook got too large
splitting one column into rows depending on the data in the column
Simple loop in macro
Resend : need help removing user form programatically
formula using Divisibility test
Determine the USB drive
Import & Parsing a small 400 line CSV file
Change label border color at runtime
Grouping Rows with Range Variables
parsing full names in to 3 columns
Convert Number To Text
Dynamic Named Range inside a Data Validation list ?
Macro in Excel to Transpose Cells
Help needed
Unique Entries Function
demo db
Any way to know in SheetChange event that Find/Replace was invoked?
links update
Converting Mainframe DISPLAY data to EXCEL formats
wrong footer in 120 worksheets
user form usage
Unload an addin
SUMPRODUCT error - help diagnosing
Macro Speed re: Evaluate
hyperlink item#'s across worksheets
Similar to "Need to know what is selected"
Returning User Control to Excel from other Application in VBA
Move rows to a new file
Assign Macro
change field format for combo box
Need help with dynamic array
Lists
How Can one display chart series using arrays?
improve DeleteBlankRows()
Refresh Excel cells on demand
Rand()
Using Ref edit in Add in to save to a different sheet.
How can I program Excel to automatically print spreedsheats
I am using a Sub Mail_ActiveSheet_Outlook() code in VB
Removing the 'X' (close) from forms in excel VB
Substring-esque function
Insert Total row if duplicates exists
object variable or with block not set
Macro If Statement
minimizing redundant code
Protecting Worksheets Problem
Passing Arrays from Excel to Word
Acting on Real time data feed
Creation date in cell
Button to create a new tab
take off the first two letters
Adding to auto-filter combo boxes
Find part of a word in Advanced Filter Code
Having trouble Using Chr$(39) as substitute for '
Have one Macro react to whatever cantrol calls it
Load a static array at procedure level
Trouble naming worksheet
concatenate from one cell to another
Getting Started
Macro for merging cells
VBA - Looping thro same naming files in 2 directories........PLEASE HELP
Unable to Copy and Paste
application screenupdating issue
automatically add date/time stamp to field?
Pivot table in hidden sheet
Copy and Insert Row problem when AutoFilter is ON
Automation & Registry
Macro to Execute Hyperlink
Filesearch in 2003
How to change no. of decimal places displayed depending on cell va
Conditional formatting or ...??
Message Box at end of Macro
How do I find a specific characters position in a string variable
Disable cut paste in a workbook
Managing Excel from VB^
Macro for Chart Scaling
Problem with code. (Compare all cells)
Generating Excel documents CONTAINING IMAGES in Linux + PHP environment
Windows API to Determine if File is Local/Convert Path to Drive Letter
secondary mouse button
RTD server halting Excel while updating
excel application for use over the web possible ?
Automating Excel with add-in
Gini coefficient
Excel User Conference - Last days for regular registration - Mar 15th
Exporting Only Filled Rows To Another Workbook (revised)
Excel 2000 chart location problem
Excel compoent
Formuala to calculate from last cell in range containing value
Command Line. How to tell to XL : If the xls file exist : Open it, if it does not exist : Create it.
group by concatenate(field1,field2)
Highlight the exact value
Add day to date in VBA????
How do I import data (ASCII) from a com port to Excel ?
Need to know what is selected
Change in action when converting to *.xla
Help creating object in excel VBA
Dropdown Hyperlinks
VB Script for FTP used in excel
return row count of filtered data.
How to run Macro functionality for a protected worksheet
Auto Acknowedge a prompt box?
Auto Acknowedge a prompt box?
buttons
Concatenation
range adding
Interior Color Macro
Displaying relevant info according to output
Office XP compatiblity- Signed in user
Callback for a cell changing with less code
SQL detection
Disable Command Button
Using INDEX in VBA
Save & Save As Question
How do I program a message box with a (Yes),( No) buttons
Problems with code
Equation to refer to data value(s) and not the cell??
Find Today's Date in a List-- How?
Code not getting triggered by change in value
links are not updated
Reference to Multiple Opened Workbooks
Getting rid of char(160)
Pivotcaches add method
UserName login code
Exporting Only Filled Rows To Another Workbook
importing data from Access
Select multi cells and format
Excel keeps changing my function
declaring Excel constants
paste problem
Loading Bar
cell copy question
VBA Help Please
Context-sensitive Actions pane
Condensing a data range with only a few nonzero values???
Why is inserting rows throwing off my hidden rows
Context-sensitive Actions pane
How to prevent double-click, insert a row from workbook_sheetchange
Prevent automatic combobox event trigger
value-driven message in excel e.g., "warning!"
file size after using macro to save a worksheet
Cell Indicator Problem
fix a macro that gets a run-time error '9' subscript out of range
excel xsl.file to csv file folder (navision)
I need to Sequential number an excel 2000 template.
Help with Proper Closing Procedure
formula returning incorrect blanks
format checkbox
Sorting sheets in workbook
Need Number style
Macro SaveAs - Date format
Disable cell warning/error messages
.XLA versus XLS sheet code
using multiple mso-number-format's when exporting using HttpResponse
Adding a variable value to a comment?
"in the language of the macro/user"
VBA open xls as read-only
VBA open xls as Read-Only?
VBA open xls as Read-Only?
NumberFormat vs. NumberFormatLocal
New to Excel VBA
hyperlink with cell value as part of address
Day before creation date in cell or as sheet name
Can I have a worksheet link for minimum and maximun axis value
Testing Range from other Sheets
Programmed Autofilter Query
Help with linking
Listbox Selection Help
Generating Footers for Multiple sheets in Workbook
Last used row
Search for text value in range
Excel 2003 multiple criteria
Need help removing userform programatically
Search Cell Contents Between ||
count colored cells
Nice easy Listbox queries
mean and variance
Need to count formated Cells in Excel Macro
conditional format a series of numbers
VBA changing Page Name.
MsgBox to list users in shared workbook
QueryTable Basics..
Type mismatch error
How do I make sure I don't repeat a value in my worksheet?
Name of STMP Server
Macro to insert cells based on an input
Formula to Macro help PLEASE
Macro for PDF 7.0 in Excel
FitToPagesWide
Generic VB Code to Hide Spreadsheet
Excel: Unable to trap 287 error with Outlook Security Dialog
Repost Of ealier Question
Code Help
Help to clear data & delete rows
2006 Excel User Conference - Book drawing
How to stop macros opening read only files?
Counting hours
Blocking a second spreadsheet from opening
Find
Invalid data format error
Many Thanks
Application.ScreenUpdating is ineffective
Last x entries on a moving list?
Invalid data format
Application.Run not working
Yet another basic problem
I need to analyze last value of each row and get top 10 of repeating values
Pivot table field settings
Find what sheets are linked together
Populate a list box from a worksheet range
Something wrong with undefined functions.
Keypress Textbox
Insert file name into sheet
Lookup and copy into another file
Using VBA to temporarily bypass regional options
SQL <SELECT> with condition
character to integer conversion
Help with userform?
Count with Multiple criteria
merging
Using variable to select rows
Excel Validation list
Access to Active X code names
Formatting data based on a cell range
macro to open note pad from excel
Help with Userform
Macro Relative reference button greyed out.
Creating an organization diagram in Excel
Possible to Filter a Listbox on a form?
Setting Reference to another WorkBook-Problem
Writing Macros
Help with a Macro
Learning VBA
Re: Define name
Define name
VBA Help Links don't all work
New ActiveX Control popup
Deleting EXACT duplicate rows
excel formula for a match result
passing values between add-in and worksheet vba code
Macro Button
Pipe a Paragraph to a bookmark in Word
VB Method to copy and save only one sheet of the active workbook
If This AND That Then...Else... in VBA
How do you make the auto calculate setting stay on manual permanently?
Filling ComboBoxes
Recovering from corrupted file -- New #NAME? Error problem
Chart Select/Copy Performance
quick code question
changing font color of cell content
How do I create Dynamic Dropdowns
Simple VB to Select a Cell if Another Cell Equals a Value
Simple Macro - I think
problem w/ size of combobox & using TopLeftCell
PDF 7.0 & Macro
validate data based on data within another spreadsheet
Can I run a macro on loading?
skip cell if blank go on to use another cell in calculation
Excel help with database & report
How to unhide multiple sheets in one go
check box Error
ScreenUpdating
Have end user add missing references without accessing the vba pro
Find Method within a called procedure
call multiple macros in workbook_open?
How do I highlight the active cell in a spreadsheet?
ActiveX Control with Dialog Causes "Lock"
Generic function applied to column?
forgotten object
Check for current date in a row
check for existing worksheet in all open excel files
Count Duplicates in a range - skip blanks
macro
Runtime 1004 error when insert.
Runtime 1004 error when insert.
All users path
select a variable range
Closing Forms
Copy/Paste rows with specifc text in column d
How to get a list of items onto a list box on a form
How do you automate invoice numbers?
run-time error '9': Subscript out of range
Linking a combo box
Application.WorksheetFunctions
vlookup items in an array
Save Excel File every wednesday VB Script Help
Retrieve multiple files by FTP
Help with VBA Macro Reading Excel "form"
How do I scan a large table/worksheet for values?
Rename a worksheet after copy...
How to Hide Sheet Tabs when workbook Opens
Test if ActiveCell is within a certain named range
Prompting User
Mimic keystrokes?
how do i create search option in ecxel
Printing
Rewriting equation for VB
copying values only from another workbook
Look up and return multiple columns
Populating ComboBox with Folder Names
How to save a ole object from the clipboard? (Do Ctlr+V)
How can I edit/delet a macro that has been created as a private ma
Effective Data structure required
Using a Date time picker in a VBA form
How to write a micro to download file at a URL save the file at the local PC
Drop-down leading to more Cells
Connection to Excel from .Net using Oledb
Sheet presence?
Paste method of worksheet class failed
Help:Open & Print Embedded snapshot file
Importing External Data using ODBC
Next Unique Maximum
Protecting Menu's & toolbars
to find the text and to know that particular cell address
Modify File Creation date in VBA using Document properties
Look up function
Sending to yourself using sendmail
Find first blank cell to paste into
What are the benefits of using VB for excel formulas?
sorting items in a combobox
Stop "save changes" message appearing
Select last blank cell in a range of data
Active Cell Fill Colour
VB to Excel
What is FSDDE and how do I use it?
Cell change causes action
Avoidiing special characters on entry in Excel
Copying all rows that have the right requirements!
automate cells for reproducing graphs
passing targets between functions
Need Help Setting background color in XLM Excel worksheets in Netscapeand Firefox browsers
ClearContents when the worksheet is protected
left()
Macro to Hide Colums
Removing minus numbers from a sumif
How to recalculate a worksheet when a selection is made
Sorting Data
prevent row insert in a range of rows
Triggered screen shots
referencing with variables
How to calculate time in 1/100 decimal while it is entered 1/60
Datepicker not visible on the MSFlexgrid.
store variable
formula error, vba not liking commas
Simple macro (ClearContent) freezes Excel