Excel Programming [Archive] - Page 112

Syntax of this code
Ignore other applications
If, And
remove query table when saving
Haw can I to create the numeric counter?
view 100%
Cell alignment centered
Excel hang when SaveAs
excel 2003 xlodbc.xla
How to control "Date Time Picker ActiveX Control"
help me out with this - it's killing me..
Worksheet change
Access Link Help!
Code for Access file manipulation from Excel
Can Excel 97 be controlled from VB.NET
ChildItems and ParentItem of PivotItem object dont seem to work
How to display set of record s on the forms using previous & next button
Help Opening file on network
Apostrophies SQL from Access
Removal of empty cells in an Excel table
Find a match and display a message
Conditional Test with Text to Speech Output
Sort multicolumn listbox items?
Problem with Work_Sheet Change.
ABOUT MSGBOX
RecordSet & New Class - Good idea?
Worksheet().Range(Cell(), Cell()) syntax?
Grouping Cells with Macro
retrieve cell value from the cosed file
add/subtracting date:time in Excel 2000
Boxes on form. Datatypes error I think
How to identify operating system user in excel?
how to update time in corresponding cell only
How do I set up a while loop for formulas?
Keep text color from a Index Match Formula
Copy only Visible Cells of a Variable Range...
Run a macro always I open an Excel Document
Forms Toolbar Button question
Code slows down after a few runs
Extracting Terms from simple linear equation
leading zeros!!!! arrrrrrgh! please help
Returning Values from specific cells in Excel using C#
logos and such
type mismatch error
Easy Question
Macro with non-static column length (name last row?)
Hiding a whole sheet in a workbook
Using SMALL where first two values are =
encryted data in excel
Problems using IgnoreRemoteRequests in a shared add-in
Disabling the option to move cells programatically
text in forumula problem
Macro doesn't work when I use Protection
How can I run solver from a macro button?
Function working on whim
Date With VBA
VBA Newbie stuck
Remove links to other spreadsheets
add line during code
Disabling disable macros
Workbook "Locked for Edit" Problem
Recovering VBA Modules
expanding a start date and end date to show all the dates in a list
access
Protecting VBA code
LARGE
How to make command buttons move among worksheets?
range function
Excel formula pasrsing - BNF, Yacc?
Recording macro for multiple cells
Re: Printing Views
Help creating a macro to copy from one cell to another spreadsheet
Sort Help for Excel
Plus sign in front of formulas
SUMPRODUCT Issue
Macro to Insert Comment to a cell
Click Event taking time
SOMETHING TO SHARE: Encripting/Decripting code
Rounding up to the nearest 6" increment
Need to know a workbook is just open
first column in row
Help with vb excel macro
Using a cell integer to select a macro
Macro to select range based on cell not being blank
on error exit sub
Spin Button only allow upwards of the previously saved value
Timer control in VB available in VBA
Date format
Range with numerical data
Add a Excel's references from VB .Net
Add-ins
Please help! Almost done...
Command Button in Excel
Can I use a Macro to unprotect a sheet in the workbook?
ComboBox input
How do I determine if it is a new file or an existing file?
Help with "Waiting for OLE Action" error?
Find out what is selected for AutoFilter
find all the excel files in a folder.
Nested For Each Statement
Application events
Locked cell without alert
Combobox Problem
EXCEL.EXE Application Error
How do you programically remove carriage returns within a cell
Looping and Testing Cell Values
macros
is it possible to unable the user to add more sheets to a workboo
run macro on only one open workbook
excel encrpted
Date Type Mismatch
Get the Date
Print (Manual feed)
Replace reference inside formula
Excel File Growth Problem
help with dates
new sheet with change of column please
Adding a worksheet from a date named workbook and save as current
Automation problem
SetbkColor doesn't work !
Using Excel Library
Überwachung Zellwerte und versandt von mails via Lotus Notes bei Unterschreitung
Save as txt-file macro
Find last nonblank cell in column
Set OutApp = CreateObject("Outlook.Application") - Runtime error 429
not insert link into history of IE
help needed with formula or macro or both !!
ASP: CreateObject("Excel.Application") IIS 6.0 Win2003
Pivotitems("(Blank)") in foreign language
sheet tabs and selection
Add/Change Data validation list
Textbox/Cell Problem
Refine search criteria for Find Method
Debug/Compile VBAProject not available
can anyone help with copy-finding macro?
NumberFormat
How to run a macro (in personal.xls) whatever file (in the listing) open
no add link into history link....
Sending mails on behalf in excel
How to export data to a closed Workbook
Remove button
IDTExten2ibility2 OnConnection method: Can't get it to start
Problems with pivot tables and/or charts
How to get a macro to work on another worksheet
Proxy Error (Connection refused)
Problems using SaveAs and SaveCopyAs
Finding error messages in a workbook
feed data in multiple files without opening them
Comparing data
Can I make a Macro Undoable?
BeforePrint Event
Selecting The Last Row
BNF for excel formula
Format Half of a Cell
newbie VBA help please
passing a range from another worksheet
GetSaveAsFileName saves empty worksheet
simple? Word Bookmarks link to Excel
autofilter/cell selection problems
Code Calculation Problem
Would like to ask assistance in filtering multiple pivots at the same time
syntax for code in MsgBox()?
Code equivelent to a key combination?
Data Validation Drop-Down List Problem
Palmtop for Excel / Excel for Palmtop
User Form Formula
Help me finish my project please!
How To Turn A Row One Of Two Colours Without CF
General Cut & Paste Issue
hiding the column and row heading
Error In Saving Excel File
Print If statement...
autofilter copy to new range
Macros to Organize the Data from multiple files to one file
Semi-Complicated Question...
How to Combine Grouped Records onto one row
Testing Values of Cells
need help with "searching" and "end"
FileNotFoundException
Binding data to a ListBox without using cells
User Defined functions
droping leading zeros when writing to a file
I have a smorgesborg of vba/excel questions
Insert value of formula into cell
range offset
referencing a column
Visual Basic: Setting up a button to switch on/off a picture
Dates
XL "encountered a problem & needs to close"
Sum a range with vba
Calculation
Replace code
row select
Brackets and Macros
Choose printout color or b/w using vba
Is this possible?
How to catch the colorindex in a series
Obtain Word Doc Info Into Excel
Tab key functionality in a protected worksheet
calculation based on row and column values
Determing a range from numerical data
drop down problem
I want a macro that can open a worksheet in a closed workbook
importing 10 sets of data with a macro
Cell Formular
Import CSV to 1 sheet
VBA and Excel web query not accessing the Web
variation of 2 rows
creating a new sheet (back log)
Shade Columns based on criteria in cell.
Deleting Worksheet Error
Excel and Shockwave Flash (Active X Object)
Algorithm Challenge
ambiguous selection
Hlookup
Convert to Number
Selecting a column
How to catch the workbook names...
Colors overridden in a Macro
Commandbar not visible in a graphic
Finding Array Formulas in VBA
Move Dash
detecting a tab delimiter
Copy after Autofilter with no rows found
Mirroring worksheet contents without using Pastelink
Squares
Is it possible to use the MScomm command in excel's VB editor?
Excel Form Validation in VB
all
how to protect header & footer
subtotal
Sending E-mail
creating a list box
how to create button?
Copya and paste data pb
More than three conditional formats
Replacing a string within a text file
Positioning MsgBox
sumproduct
How do you look for quote marks?
Use varaible for worsheet name in a formule
How to replace defined portion of string
Pass multiple characters to a string variable
Unprotecting not working in Shared workbook
PLZ! Help me out with this "killdupes" script
Editing text in text box grouped within a trapezoid
how do I protect folders by password
VBA Counting a range ofhgighlighted cells - before select
programming a dice roll
Selecting data from 1 workbook to copy and paste to a 2nd workbook
Macros & alternatives
The Run-Time Error 1004 That Wouldn't DIE
Runtime error 1004
automatically copy into cells
Listpro
index and match
code question
File with VB programming wont open
VBA programming-autofilter function
How Macro Ask for Variable Input?
Question about dim statement
how do I use a macro to center a shape in a cell in excel
Simple message Yes No...
Need Help With Active Cell
Need Help With Moving Active Cell
Logarithms
Compile error in hidden module
Positioning a char in a sheet
Saving Excel document without macros
VBA to save pictures from the web to local hard drive
reading a user-set autofilter value
Delete empty rows.
MACRO not working on two different files
Open Outlook
select data between workbooks?
What can I append
how to make the barcode reader trigger a macro in excel.
Sheet names in a form dropdown
User Defined Functions
formula to only calculate the last 15 entries?
Certificate Discarded.
creating multiple line charts
Help With Conditional Formatting
How to 'Click and then perform action'
Filling Column with date
column headings
Excel Menu Item for a PC with multiple users
deleting non-numeric rows
Borders with Macros
increment number by code
remove cells with one digit
saving Outlook attachments
Relative Reference Outlining
Putting column values in multiple rows
cross-footing in excel
i need formula help
VB: How do I find next blank row then add another blank row
Ruler in Excel
Rank the Data
Define name, count rows problem.
VB: Find blank row then add another blank row
Using an Excel macro to open a Word File
Circular reference
How to show to a form in excel vba?
need help with formula?
date subtraction
Ranges in array formulas
Generate list from other files
Protect Excel 2000 Objects
Diff tool for VBA projects
Update links to other workbooks while running macro
Insert Function Problem
Count filtered data only
Enabling context-sensitive help in Excel for ADO objects
Get floating CommandBar position
What is the best way to protect VBA code
Need help with a formula
Using "i" in File Names
Automatically Hightlight Rows with w/Date Check?
SendMessageString ...Maybe !!??
VBA Code Problem
pocket excel and macros
Error calling Web Service from Excel Application
Date problem when opening a csv with dates in dd-mm-yyyy format.
How do I set the delimiter to save as a CSV?
Auto changing field trouble
Copying text from regular textbox
Prevent a workbook being closed with the X
Error loading forms
Re: Help! Searching for text with more than one criteria
VBA equivalent of GET.CHART.ITEM
Help! Searching for text with more than one criteria
Help with vbModeless
Msg Box to change Macro criteria?
Bit of help required.
Position Form on screen v Window Zoom !
Data validation named range update
Can a pivot table function like data filter?
Rounding to nearest quarter hour?
Can a pivot table function like data filter?
Fustration Help? Filter, Visible Copy/Paste
Pivot Table
Capture Update Links event VBA
date formatting in excel VBA
Indirect addressing
Conditional formatting
SpreadsheetML of selection
Code can't locate filename
form window too small - Help needed
Coordinates extraction and comparison
Amending a text file
File saving
ActiveWorkbook pointer for Macros from PERSONAL.XLS
relative cell references
Checking for copies.. but not an easy one %(
different colours for different data
Merging excel worksheets
Wanna listen to music while surfing...
Wanna listen to music while surfing...
Copy a designed worksheet into Word
A Function puzzle
Create Combobox Visual Basic
Position of Chr(10)
Use static arrays
*difficult* importing slection from a txt file to new column
Amend the Code
How do I select the first occurance of a number in a column
Save .xls as .txt In DeskTop
numbers to text
Automate Send To/Mail Recipient
Web queries in Excel 2003 not working at all
Passing variables between Sub and Userform
Excel paper setup
VBA Declaration problem
Macro-Button make tu hide?
Scaling for printing
Zoom via Macro for WorkSheet to activate?
Wrong number of Arguments or Invalid property assignment
Help with multipage+chart urgently needed and very much appreciated!
help with an event driven sub argument please
filecopy
Your expert help required pls.
Extracting from 1 cell and placing extractions in multiple cells
Check for Hyperlink
Find the Sunday with min value
open up an excel program with an auto open macro
worksheetfunction.sum error
listbox value to a form
Firing Click Events with Accelerators
sheet protection
Removing blank rows
Remove HTML links in excel
VBE With Maicro Security
How Do You Turn A Partial Row Of Sheet Cells A Color From A UserForm
Macro security
Link submit button to another worksheet
put worksheet values into textbox on form
Copy folder and paste to another folder
matching values and inputing value in the adjacent cell
How can I add values in 2 cells using a command button
How can I add values in 2 cells using a command button
message box transient -sub by Chip Perason
How to copy 30 csv files from a folder to another folder
Issue with 'Left' in macro
Matching Data on different cells
Rename a new workbook
Trouble comparing to subtotals
Linking Dinamic Cell value into another sheet
Paste text into a header
cell change
performance question
vba for countif
Events... Changing the Interior Color
how to check that a var type date is initialized ??
Auto Add Control to Worksheet (to edit data)
Problem with range and autofilter
Add_Ins
Heavy/Slow Calculations
Compare Master Account List with Partner Accounts
Graphics question on Excel VBA UserForm
Macro
Proper way to write a conditional statement with ands
NewIndex for ListBox?
Chart
Range selection
How to open Excel file from PowerPoint?
if and else question
Exporting to txt file, how to insert a "Enter" between lines
Stopwatch In Userform
which function i should use?????
copy / paste
Merging cells
Check to see if excel file has been saved
UserForm
Formula to sheet change
Excel Macro Programming
close file macro
ccard 6 or 16 digits
Format column to have different decimal places
Printing from listbox
Selecting OptionButtons
Cell reference to userform
Multiple Workbooks
Can't delete macro
Solver Issues
Formula help
Rearrange columns using VBA
Use Subtotal Function
Data validation in 3 cells
macro to email
macro to email
Toggle Columns
declaring Arrays to use in a Form with few modules
UserForm
mixing of vba and sumproduct
Excel 4 Macro Recorder
How to get system login name
How to get system login name
lookup physical first worksheet
Date Formatting
Subject: how to calculate time in a payroll worksheet- Revisited
Hide individual/range cells and temporarily increase scale for printing
Need macro that will BREAK a running macro
Help! How do I Auto-Update?
referencing the active cell
Printing form & contents
Simple assignment question
Macro to copy sheet(s)
Sub Worksheet_Change(ByVal Target As Excel.Range) Questions
counting and loops
Test for fractions of a penny
key press event?
Deleting A Worksheet - There may be data ...
VBA Code to access the ACT! 2005 data bases and tables
stock quotes in excel
show duplicate rows in a pivot table using vba
Deleting a blank sheet in a workbook
Auto filter formula - help needed
How to plot missing points
macro to find numeric data & move it
Tie 2 or More Modules Together (vba)
Delete bolded items in column
Return last column of dynamic range
Determine last clicked object / control
Question About customized menu bar
Formula for Filter
External Links Memory Error
I need help Caculating Zip code Distances
Weird... type mismatch only half of the time
How do I group data in an Excel Combo Box
Re: Ado Filter ?
Excel treating text as function
functions & range vars
Excel 4 Macro Help File
Fill Color Rows of Varying Size
interacting with MS Access
Locating min/max number of x adjacent cells
Find next cloumn
Interfacing with Oracle 8i
exiting program
Properties of workbook
object error
Writing a Date Function
web page and excel...
sort problem with first row
adding two ranges
Displaying A MsgBox for X Seconds
Excel printing
removing date from field
I don't want to see what a macro is doing when it's running
SQL Database Query
Help on Codes for Accumulating Figures
Printing
Speed-up a macro!
Project Window in VBE not displaying items grouped properly
Excel 2003 does not calculate automation add-in functions automati
Re: create a copy of a sheet and insert it into the same workbook.
Filter Copy/Paste Fails - Two Ranges Selected?
create a copy of a sheet and insert it into the same workbook.
VBA column counts
Disabling the standard X-Button?
Word Search in VBE (True/False Solution)
Easier Sorting
Checking External Sheet References in formula
User Defined Function
Function Counter
Handling Combo boxes...
John Walkenbach Color Palette (Repost)
getting row and coloumn info from listfillrange
Using popups instead of Message Box
Timeout
Getting timestamp from a file in Excel
creating a Help tool thingy (msgbox?)
Variable ComboBox on Userform
data validation
formula in vba
URL string, pulling in Stock Data
row sum - 9 cells change values to 1 and add the "1"
Development considerations for Win XP
Save method and BeforeSave event
How to Auto Filter Even and Odd Numebered IPNums from huge collect
Detect which shape was clicked....
How can I duplicate a user form and all code?
ScrollBar object
Help in Table Macros
importing worksheet via code
Setting a Constant when creating a new file from a template?
MsgBox "Invalid property value"
silly (?) problem defining ResultRange
Help to get values from 3 option button in one cell
Seting a Constant (via code) when creating a new file based on a template
Sort Column B against Column A
Re: Question about links
Re: Range.Find skips the first cell ??
Re: Macro fails after screen is locked or screensaver becomes active
Re: Range.Find skips the first cell ??
Re: Ado Filter ?
Data Area in Excel 2005
Loop until a unique worksheet name is entered
User Forms and Excel Functions
Inserting "template" rows
Re: Question about links
Web query on Open
Request assistance with cross sheet problem
Re: Subroutine vs GOTO "On Error"
Copying Custom Toolfaces
auto_close and removing menus
range function
Help 'Number Stored as Text Error' !!!
Help me modify this VBA code please:
Retrieving cell formatting from closed workbook
Recording simple Macro
RE: Subroutine vs GOTO "On Error"
Protection problem...
RE: Subroutine vs GOTO "On Error"
using a For-Next in a module and a Form
Date Subtraction/Time between Occurences
print screen
How can i attach active workbook to email- please see the macro
Current Month
range division
Re: Range Question (very simple)
VB directing IE to a local site's html page
Awkward autofilter question (URGENT!)
InStr
VBA Post
Creating Status Report like Microsoft Project
Automation and multiversion of Excel
Simple Question (for you wizards...) please help
how can i adapt this formula?
cutting and pasting ranges using offsets
Union over multiple sheets
UserForm
how to hide the "(All)" option on a pivot table
using worksheet functions in code
Searching for Duplicates across columns and print to new column
still stuck: get filename from range
How to inserting text in thos email macro
VBA Date formatting and locale
Inserting Dim'd Name Between Letters?
Hiding rows if...
functions
Open files, skip a folder
Find subtotals of 160 each
Help needed with the following macro
Repeat series of formulas - REVISITED
Format multiple pivot tables
Pasting embedded OLE objects to specific filename
get file name for FileSaveAs
Open files
Problems with a method form multiple worksheets
John Walkenbach Color Palette
Stop directory & folders changing in link when moving file
Sorting based on the first column of a defined name range (Unknown)
VBA Code to name a variable range
universal code
Return the row numbers or a dynamic range in VBA
How to strip dashes out of numbers in a variable
Sum only visible cells within a range.
sum cells using command button ADD
Cell wont calculate automaticaly
This is not strictly excel, but I am running it from an excel macro
Retrieving cell formatting from closed workbook
Macro for saving file on Auto Date
Formating cells
printingstatus
delete the hyperlink linked to the organizational chart in excel using vba
Macro to Lock Columns
Web Query Questions (2)
Wildcard with constant
getting information about a pivot table
Cell wont calculate automaticaly!
price and yield functions
TextToColumn Split
Error in Loading DLL
Formula for last numberic value in column
macro to merge workbooks
(Leo) Strange print to file behaviour
Trigger Event Code
Protect Rows depending on Values in Particular Columns
Wildcard
(macro, formula,...) To Copy columm in various sheet's
Recursive Function + File searching to return path
What version Excel file was created in.
Transfer amount into next column with condition?
Array as output of function
Automation Error ... Urgent help needed
calendar
Copy Method of Sheets Class Failed - after many copies
Moving amouse over controls
Alternatives for Sumproduct?
keypress on a userform (with code)
Find out which cell that called my function
DR watson
Re: Blinking Cell (Worksheet restarts)
UCASE problem
How to copy selected listbox item to sheet
Newbie Confused...
Re: Pbl calculating US$ values
Variable for column selection
Hide all PivotItems except for a specific Item
Macros with switches
is this possible...
pivot "fields per column" setting
Exporting to a closed workbook
Guardar .xls como .txt En Escritorio
Using a macro to work from Excel to Outlook
Excel Menu help!
Why doesn't this work in Win 2K?
get date from calendar in dialog box
Help with file open and data organise macro
What library is xlLocationAsObject in for use in VB.NET?
InputBox drop-down menu
How can I know if Excel supports the fileformat constant?
Detect which shape was clicked?
Setting Column format as text
VB for Excel/Foreign OS
Creating a budget from a list of transactions
Copying data from multiple sheets into one sheet
Use Macro to open "Find" window
Application.FileSearch crashed Excel in Windows 2K
Use a Macro to Save a Copy of a Workbook?
inconsistent size progress bar
Error 1004 from worksheet activate procedure
Activesheet <> Sheets("Name")
Sending keys to DocuCom PDF Driver
RE: Login System
Setup Excel to autosplit one cell into two
Named Ranges
Re: Login System
Macro to have user enter new worksheet name
Selecting a defined Name via a cell's contents
Wildcards in Advanced filter criteria don't work with Excel 2003
Command Button Hyperlink
XLVERYHIDDEN
Information Rights management
Graphs
Dates not including weekends and holidays
UserForm
importing into excel
UDF not returning correct information
How do I create a list in excell?
extracting a number
Insert a row then copy a transaction
Getting the source name of an OLE Object
Toggling Display as Icon for OLE Object
com add-in
How to select columns using column index
Excel automation question
Selecting text only
Saving and Closing multiple files and Excel program
Use ADO to copy a graphic to Access from XL
Macros Security
Changing DATA VALIDATION box color.
Add-Ins
Installation of "Add-Ins" in code
Password Protect Worksheet
Excel Column Width Units
Selective Mailing Of Attachments
Time Userform
addIn functions in automation
Visual Basic code to find next available (blank) row in a spreadsh
Help with function that crashes Excel
Worksheet_Change with discontinuous cells
Validate cell when contents are pasted into it
"on error resume next" NOT working...
skipping one row several times over
Enabling sub menu items via vba
Macro update
Autofilter
Password Removal Problems
How can I make this simpler?
The "Like" operator.
get_Range Restrictions..
My errorical understanding of Error handling
how to control the "Save as type"
UserForm Help
Multipage Control Pages - Changing Index Value in Code
Why is my digital signature is being discarded?
Multipage Control Pages - Changing Index Value in Code
printing to a pdf file
Looping through files in a folder
Custom Calendar Format
Code to save spreadsheet
Problem sorting a single column in a shared workbook
PANTONE to custom color
Delete rows with different criteria
Excel HTMLProject replaced on RefreshDocument iages lost
module related
Repeat series of formulas
Perplexing sheets.
HELP PLEASE !!! Replaced HTMLProject for sheets but Images were lost.
Dim Line Labels?
Excel replaced HTML Project but Images are lost
Closing Excel
Function to capture the time a cell changes
macro equivalent to arrow keys
CommandBar
GetPivotData with column grand totals
How to show the maximize button
Hide Excel Menu From Screen
vba date function
macro editting
Send graphic to Access?
HELP! - Printing a sheet with values populated from dropdown box
Command to bypass the asking to save option
Sudoko
remove hyperlinks from objects in the excel workbook using vb
Between to values
File size...
Programmatically reading data field values from PivotTable
Stuck
Changeing codename of worksheet via VBComponents collection
Program 2 shapes
Deleting data in userform and database
Custom Classes and Cans Of Worms....
save custom data in excel
Macro to insert Current Time into protected cell
I Need Help To Do This Code In A Macro
Multilanguage translation
Creating Option Entries in Excel Menu Bars using VB
Displaying the result of a formula in a text box
New Menu in Excel
Code for Advanced Sort
Attaching excel in Loutus notes
Loop through for condition and input in adjacent cell
Advanced Filter...
Centering a Shape over a given cell when resizing
Command Line Arguments
copy formula
How to make sure a Cell is within the current visible window's ran
Help! How to get all the command's captions within a CommandBars?
Explanation needed for CopyAllModules code
Excel AutoFilter using ASp.net
paste special/values can be very slow
variation to code needed
change macro wih macro, is it possible?
Require Workbook to be renamed in order to Save It
Sub too large
copy worksheet
Excel 2000 vs Excel 2003
Setting a value in an add-in
Disable hyperlinks
help with arrray formula
problem to create a line graph
Name of running sub???
A macro that copies and pastes autofiltered cells will fail.
Filling cells via code..
Time Format Input question
Code that ask user for a password before it runs..
Application.Calculation = xlCalculationManual mystery
SHELL to open an application and pass parameters to it
Validate an email address
command button
File Input Question
Save If Condition is true
RecordSet object - Cannot get help file to display
Sort the Tabs
flash drives
Copy Contents of 3 Columns into 1
code to run another macro?
Can anyone recommend an affiliate tracking program?
buttons on InputBox
How to create dialog boxes
Need help adjusting my code:
Test for dups in Array
how to close a form in vba (not hide)
Macros disabled
what is the Excel macro command equivalent to "end up"
cell selection
IF FUNCTION Trouble
worksheet.activate not activating
protect with password
Compare Cells
Using Web Queries -- unusual problem
Scenario If Date is greater
Change Event on a named range
Calendar Control
scrolling a sheet with vb
Repeating rows at the BOTTOM of the page
Excel 2000 Solver Problems
On Error Issues
Worksheet Navigation
On hard drive, how do I restore .XLS prior to last save?
Why code work in 2003 but not 2000?
How do I FILTER this?
Spacing Macro
Duplicates
Excel and Word Bookmarks
Function with results in offset cell
Copy between variable workbook names
Input Box problem
The column return value?????
Looping through Worksheets
Determining the height and width of Print_Area in a closed workbook
Pass worksheet to macro as a parameter
A simple question
Excel 98 not functioning properly on formula
Re: Moving to a different cell automatically.
Opening a Word Document from Excel - ??Stumped??
Missing Cell in a column when it is on row 16
Moving to a different cell automatically.
Save value on form
Move page breaks programmatically...
Find and Replace in Formulas
Excel function
MsgBox with Timer
Make an indexer at rows for many txt files.
Count number of cells in a range with amount > 0
SQL CASE statement on EXCEL VBA
select first non blank cell
Cells formatting done without me allowing it in VBA
Placing triangle symbols WITHIN cell for significance testing
Next For looping in a If
Date Format on Form
(Newbie) Copying values from an array to the worksheet
CountIf question
sum on a variable range
Mailing single rows via button
Solver macro
opening ftp-file from macro
updateLink; files with passwords , VBA help!
tidying up code and refering macros
Preventing Users From Locking a Shared Network Add-In File
Search and copy macro
VBA error: Unable to set the Values property of the Series class
Merge an entire row
Counting survey responses
Help! Is it Possibe to write UDF(custom formula) inside sheet
Scannig number of rows
Use Parenthesis in Filenames - workaround??
Selecting multiple text boxes
VBA English-Spanish
Data correction
Script question
count up the occurences of non continuous value
Help for a macro change cell colour under many conditions
User form/spread sheet
Custom Class and Properties
Problemas with function Format()
Remove the filename when assign a macro to a menu command.
Looking at previous columns
way to run sub after user exits textbox
How to trap the worksheet_BeforeDeactivate event?
macro for paste special values in different location
Auto Editing the Row source.
Visual Basic - Macros
Update custom formulas automatically
Problems with DATE data type
Worksheet_Calculate problem
Reload Listbox - type mismatch error
running private sub
Making rows variable
Insert Character into Editing-Cell
Can a macro be triggered when a cell is selected?
Help with deleting rows where the value of the first column isn't divisable by a certain number.
remove routing slip
Code for Registering Add-in
how to delete a chart using code?
Count quanity of values in an Array
Forest & Trees????
Testing an unopened (or opened) worksheet for VBA Project protected
Timed Message Box
Write value to an Excel VBA variable by reading Access DB?
Deleting a sheet via code-- different criteria
macro running problem
Problems with Paste
Advancedfilter returning all rows instead of ones that match crit
Select failed?
Font Size on Forms
Problems with ChartObjects
Macro to select rows based on a value in a column
Checking for security level to allow macros to run
change font size in excel vba
Routing / email
Excel User Conference, 2005 - Ft. Worth, Texas - Sept 16/17
ActiveWorkbook.Close (False)
Printing only a selected area
Find Autoshape
how do I transfer information from excel to an existing word document using a macro
Prevent Autofill from changing protected cells formatting
Select Method Failing
Deleting a sheet via code
CommandButton Failure
Some sort of a For Each loop??
Arrays
Need help with dates
dll reference
look up syntax
Controls in a Worksheet
Split or copy records n-times as excel scans the value of a colum
How to make Pulldown menus
Re: HELP! What's wrong with my code?
copy row
Problem with cell value
HELP! What's wrong with my code?
Output Text in specific place
Individual Page Selection
Save .txt file to .csv in VBA
VBAProject Properties
Search Text in Comments
Creating Sheets in VBA
HOW TO PORGRAM WITH EXCEL?
color selector
Determine Column
activeX dll
automatic printing / print report FIXED
macro to paste certain cell formats based on wksht name
find "closest" match
Inserting Excel Range into Word
If statement not working right
Iterating through cells, comparing values
Help on Excel data auto generation of graph
Set up contract expiration dates program?
Forms Textbox and Assign Macro
If Then Help!!!!
hide save as
Array Question I think
Help with listbox control events
UserForm Popup Menu ?
How to perform action in all worksheets
Finding two variables on the same row to match function
Frame on spreadsheet
sorting a large selection
hide columns from find
Printing order
Accesing Word Document from Excel???
Change BackColor
last column of a row
Run macro when worksheet is opened
Workbook name
How to stop warning message when opening excel file in IE
Random Selection
Starting a Macro when Command is Executed?
Object variable or with block not set
macro needs to reference cell values in different worksheets
How do I make specific columns Proper or Caps?
Looping through my worksheet and copying cells
grouping
Lookup