Excel Programming [Archive] - Page 126

Deleting duplicates
automatically finding the first empty cell
Automatically change month for all pivot tables
Does the hyperlink exist?
Detecting a cancel on Workbook_BeforeClose event?
Hide Toolbars
tricky formula.. please help
Problem executin macro from a different workbook where it is
How do I programmatically specify a range.
Setting Chart series
_RE: AutoCoplete cells content
in excel how can i convert numbers into word?(1 to one, 2 to two.
Input Box
how to know the picture is open
Macro
Windows Password
Sum Array Formula Across Multi Sheets
Application.FileSearch is not working??
Error:Invalid File format,while opening an Excel Template file
If pressed no to msgbox, then exit sub
removing values not links
OptionButton value
Printing problem
Add file to Recent File List
Set range based on find
Test
Option Buttons
Last Cell
Looping & Consolidating
Sorting data
Code hangs Excel ... Why? ... and how can i debug??
Column Delete based on String
Screen Updating
Protecting shared workbooks
Trying to set comment to Cell value
Controlling chart axis
Change message to include range
Advance A Date By Month Or Year
Screen Updating
add a label to Multipages
Deleting Empty Columns
Screen Updating
Looping Through Sheet
Highlight Minimum Number > 0 in Red
Macro to search number with in a series.
test
AFTER Calculate Event
vbscript - export to excel ???
Simple? Formatting Question
Re: Need help with message box.
Cancel to take focus
Edit Add Delete Listbox Records
Need help with message box.
Transposing selected column headings
Connaitre la taille d'une image avec Excel et VBA
erase all space characters into string
Methode 'Cells' of object '_Worksheet' failed
++++++PLEASE HELP++++++
Solver unstable in XP
copy sum selection
Call function from one workbook that resides in another workbook m
Re: Help To Create Batch/Macro Required
selecting multiple ranges
Passing Variables to another macro
Dates and Variables
Mysterious "Identify Label" is crashing Excel
Delete Shortcuts
Trying to stop making a new sheet
returning more than one value from a VBA function
Excel Macro string formatting
Copy Last row
embedded object
how do I change the color of a cell dependant upon the cell's con.
AddName - issues w/ creating with reference to a diffferent workbook.
Naming a file with the same name as the folder
SWOT abalysis template
Excel Data Base Link
Command button
Problem with scheduler
Selecting mulitple worksheets to Print (using VBA)
update Label and other component
Storing a range in a variable
VBA complilation error
VBA Excel compilation error
Date Format + Graphs
Sheet automatically condenses data??
EXCEL: Need help
Listview and colored line
odd or even number
Numeric Keypad
ytl
number convert into words
number convert into words
autofilter on a not-active sheet
Form Macro
Loop column A and delete and move on condition
Naming a sheet from formula result
Genarating count of unique words in a cell or cells
Changing the SpinButton value in Workbook_Open()
Using Select with Range.Cells property
2 excel application
Generating Field inputs from other fields
Package and Deployment...
Custom Number Formatting
Clearing Form Values the easy Way???
Macro and Text
Create File Folder
Problems using Find
Changing data access from MSAccess2000 to SQL Server
combobox on worksheet won't stay in one place
How do I convert decimals to fractional odds for horse racing?
passing Excel system values (constant) of properties as arguments
HIGHLIGHT A DATE 10 DAYS BEFORE IT IS PAST DUE
Ctrl-J list of properties and methods
disable page break preview button
UsedRange.Copy copiess ##### instead of text
Modeless Msgbox?
copying a macro to several cells
copying a macro to several cells
how do you say in VBA?
How do I use MSHFlexGrid?
Macro procedures
Saving problem
Printing Macro question
Custom buttons
Merging Two (or more) Workbooks
Problem with Page Orientation of Excel Workbook While Streaming MIME Content
macro calling macro
Change by value
Email Range Contents
Solver (and other parts of VBA) dysfunctional in Excel 2003 SP1
VBA code to Refresh Connection for Excel Add-in for Analysis Servi
display how long it takes to calc or timing certain events
Assign a random selection to a range
Applying an Excel macro to an Excel file from within HTML
Macro error
apps for Pocket Excel
Translate these worksheet function to VB
sheets.select with reference to Cells value
copy insert macro
Subtotal another open sheet in VBA
Macro crashes if printer not installed
Get rid of CHAR(12)
Syntax for ADO Query String
Sumproduct problem
How to get an object reference to an ALREADY open excel spreadshee
Control Toolbar Image Resizes on Print
Page Break
Search for a sheet
Math calculations in VBA
Opening a file with a space in the name?
Date Display In Cell Not Working
Excel-import data
Help enclosing a macro in With/End With
Create List of Queries
File does not exist
Meaning of specifications in the Text to column feature
A program running on different Excel Versions
Calculate the average by searching to cell values
"Tabbing" code crashing xl2002 WinXP
Text Box Data Validation
Notes text >255 characters
Columns Shifting on Import of Data
Workbook_Open() Not executing
Move up a folder in VBA (EXCEL)
OnTime Unusual Application
Customising Application.Filesearch to process textpad kind of files
Posting my messages
Context sensitive help
Setting Maximum number of Workbooks per Instance of Excel
Worksheet Function not refreshing
Want to Unzip files automatically
Displayalerts not working
Transpose selected column headings to rows
Prevent calculation
Message box
Transpose
date format
How to copy a sheet and move it to 2nd last (with VBA)
Accessing DropDown box from a Userform
Excel Instance is not killed from clasic asp
Excel XP Sum Array Formula
Shortcut Popup Menu?
usage "AddressOf TimerProc" in Excel97
Re: make a shape a toggle
Filenames In Loops
How Do I attach a atachment to a VBA created email?
make a shape a toggle
How to get reference to a range as string?
Interate backward using "Step"
Issue with form field lengths
Resizing an input box?
ROUNDING
Need Help with Programming-Syntax/Compile Errors
export chart
copy and paste
HOW CONVERT NUMBER IN TEXT IN EXCEL LIKE A INVOICE
How to make a cell equal text
vba calcs are acting funny
Simple copying and pasting macro
Macro goes AWOL
Finding cells in a range
How Can I paste the dataset on a spreadsheet
Ok or Cancel code
Add Command to RightClick Menu
programming cell autofit doesn't work?
How do I initiate the windows printer select object in Excel macro
file open dialog
How do I make the Excel progam alphabetize my client list?
Referencing an Excel Chart in VBA
Apply expression to entire range
Finding and deleting duplicate files
form and module
How do I enable simultaneous excel workbook users to use advanced.
Frustrated with Microsoft
Reletive Referencing of Another Cell's Formulas
Excel 2004 no longer supports SetData appleEvent
Makro in Excel
How do I lock a combo box's position once it is placed?
List all possible combinations
RTD DCOM Excel
"GoalSeek method of Range object failed" error message
Problems with Wildcards and VBA
Workbook and Worksheet Events
Spreadsheet validation
Format column
Confirm Autofilter off
Combinations
bad file name or number?
VB Script file save as with date
very high cpu/ram usage: many Excel/SQL Server ADO return-trips
Input values directly in message box?
Help for modify data in excel!
ActiveX ComboBox Control on Sheet
How to get the number of used rows from excel spreadsheet in VBScr
Help! Loss of Tab control/cell selection problem
Excel Prob
Conditional Formatted Cell Color Index
Having a moving Total
copying chart
writing macro to gray out cells automatically
Remove all items from an ActiveX control on a sheet
Radio Buttons & scrollbars - the nitty gritty detail!
Format of a TextBox in a userform
How to hide a workbook using VBA
Copy files-what is wrong with this?
Copy/paste range variable between workbooks
application.calculation is slow: mouse clicks speed it up...
Change event for data validation listbox
saving workbook from URL
Can I determine the active selection's type?
passing arguments by postion through application.run
Format column
GROUP PRINTING
Error: 424 Object required
Pomocy z excelem,bo jestem zielona :(
Can't open protected sheets
Directories with wirldcards problems
vb.net import macro error and allow visual basic is checked in se.
Active Cell VB . NET
Color Palate Limitations – Cell Interiors
Opening web documents as "text"
Moving Items to bottom of spreadsheet based on criteria
Disable or remove macros for a workbook to be sent in email...
Pivot Table From Access Parameter Query
Prompt for VBAproject password
Application Event - Opening Workbook
VB and Find worksheet function
Type Mismatch on some PCs
Force *relative* path in Insert Hyperlink dialog
How do I put the name of a worksheet into a cell in that workshee.
How to retrieve range in formula?
Printing Macro
Date-Format of Dropdown-Combo is integer
Input Masking a Text box
How to count process running time ( process not finished)
how do I create a UDF (VBA) that returns an array (ctrl+shift+enter)
Cell value input date
Selecting object
Paste Special
Excel VBA error
Problems in saving excel file using excel macros
Private Sub
Newbie: How to open chart on cell click?
changing name of workbook
get a picture width and height without inserting the picture
How to retrieve index of workbooks
off topic question
Using Excel Worksheet functions in Arrays
Determining Toolbar Ownership?
Useing Class structures and Events
PivotTable ColumnFields AutoSelection
loops and count
check box
Part of the Active Row
Parsing text box in userform
use of mouse track wheel on user form combobox...
Find 'Product not found'
Colored arrows
Remove Row/Column Headers
Pivot table - colour of headers
Date retrieve incorrectly
Delete Row Based On Row Height
Problem updating references
wrapping text in a pop-up box - MsgBox
Unable to Set Underline Property of Font Class
Check cell for data before running code
Reset Right Click Menu
workbooks.open
DDEInitiate inconsistent...
Set the values for the x axis
Run-time error '70': Permission denied
how to insert pop up calendar in Excel 2003
Extracting Data from Word to Excel.
Replacing workbook with master copy
Updating hiden workbook
Setting a cell's formula with VBA
Help with code
Unprotect column
Parse through a TXT file in reverse order
Links to other workbooks
"Switchboard" in Excel
Excel 2003 Subtotal order and grouping incorrect in SP1
cell value from text box
Get a reference to the last object pasted
Is there a fromula for TAB?
Save text of spreadsheet--without macros or data query
Ignore Text, function only for numerical values
Sorting multiple columns in VBA
Arranging graphical objects on sheet
Add submenu Items
date between ?
Create named range for each column not working?
Error Control no work :(
Application.ScreenUpdating problem
Copying Word text to Excel
UserForm Question
adding before save so it works every time excel opens and with any workbook
Resetting chart ranges
How do I create a macro that will activate the solver?
Counter for inserting sequence of numbers in Column C
How to Set VB ComboBox ListFillRange to a Defined Range in an external workbook
Mail Merge-Tables
Re: MoveAfterReturnDirection
Find specific cell value
Re: Please help a Stinkin' Rookie get started!?!!
Error setting FaceId of CommandbarButton
Palette Color Control in UserForm
Error control no work :(
Password protect an excel file?
VLOOKUP #N/A error. Sort and format are correct.
Slim Jim
Pivot Table Refresh Problems
How to select the first 5 paragraphs in a Word Document from Excel
Transposing selected column headers
can i insert a picture in an exact cell of a spreadsheet
Clean up a string
Error message on Activechart.XYGroups
Help with Workbook_Open macro please
Use intersection of column and TWO ranges in formula?
Transfer data between worksheets
Can I password protect Excel VBA / Macros?
Counting records
Why is Excel and Access SQL different?
Variables in a query
To make sure only the Validated list can be put in the drop down b
Selecting Column of Visible AutoFiltered Cells.
run macro after print command.
Saving file in VBE
use unexcel file in excel file?
serveral excel file problem?
export data from excel using VBA
Entering Formula with "" within it
Autofill Error
Re: Help with selecting a range of cells
Send e-mail with CDO
Trapping Keystrokes from Addin
RE: "operation is not allowed when the object is closed" error when us
macro problems
which way would you access data?
Re: ADODB from SQLServer - IF function?
Cant find sheet
PageBreaks and CustomViews solved
Export multiple sheets to 1 csv file.
Automatically copying specified rows from a sheet to another
Type Mismatch Error when getting data from another workbook
how to use vba spin boxes in excel
Compare cells and insert row
Paste from clipboard to an Excel table
Copy Excel data content listed in 3 columns into a single column
Arithmatic operation on arrays
Type Mismatch Error
Transfer data between worksheets
Scan and delete
Re: Super/SubScript Button Macro
Re: Update cell immediately upon selection from drop down
EXCEL Templates
Windows Explorer Question
RE: Inserting data into a seperate Excel workbook
RE: How do I have Excel autohide ranges basted on conditions?
run when value changes
inserting objects
Re: All time running macro
RE: worksheets
Re: Can objects be passed around as in Java?
Re: Run time error 5941
RE: Update cell immediately upon selection from drop down
Re: worksheets
Macro to print a dynamic range
Autofilter works... just not in my ListBox_click!
RE: Update cell immediately upon selection from drop down
Re: Hide SQL Query
Possible to print a string?
Re: Run time error 5941
Code WAY too slow... (worksheet_change event)
When does Code Execute on a List Box?
selecting network printer
Auto insert a number of rows
Deleting Command Button
Referencing global values in one workbook from another
Delete ADODB Recordset
Other Open Workbook
Other Open Workbook
Get value from a drop down box on a spreadsheet
Repeating data
Re:
formula/function to copy from worksheet to worksheet
Clear All Checkboxes?
Excel 2003 On Error Resume Next doesn't work for me
Addin - XLA Question how too
if char is number
Excel to Access
newbie question
Print UserForm w/ Borders
Screen viewing
find a text in a file name
Directory/File movement with VBA
Protect code
Compare value to array of values, "best fit" (closest without going over, e.g. price is right)
Setting variables to Nothing
How do I make a macro work in one worksheet only
How do I change the color of a cell if...
How to initiate macros in user-friendly fashion
If, Else statements
Pulling data from different worksheet
Identifying Top row
Unprotect and Protect sheet within macro
AutoCoplete cells content
Populate excel file B with Columns/data from Excel File A
Autorun macro on starting a template
How to reference a public array (declared in module) from a proced
Import module then run code not working.
Custom Function If..Else and reading text strings
today vs. now
CurDir does not work
Multicolumn Listbox with variable range
inheritance module
Use VBA to capture IP address
Montw Carlo Simulation in excel
Macro slow down
Shortcut Pupup Menu?
userforms
How to sum a column based on the choice of autofilter?
How to count process running time ( process not finished)
Adding custom file formats to Excel?
Using DateValue function
Subscript out of range....
XML Schemas (XSD) and XML
how to deny users macro execution, please?
Self deleting CommandBarButton possible?
Trial version
block event
Select sheet based on reference
Selecting a group of worksheets to delete
Get File Size
Macro to Cell
adding tooltips / helper tips to custom funcitons
Add Command to Right-Click Menu
Determining What Jobs Ready To Move to Production
SaveAs Problem
pasting in cell comments
PrintArea setting
Dynamic Multi Column ListBox
What syntax do I use to add todays date in an excel macro
Padding formatted numbers with leading spaces
Shared Workbook: loading Userforms
For the Pro's
Prompt for SaveAsDialog with file type preset.
Adding rows from sheets to one sheet
Any mouse events for Worksheets?
Mouse movement on worksheet
Finding the right most cell as a function
Excel macro to insert names for ranges, not always the same size..
Basic Question about varaibles
Automating Autofill Coding Question
calling a subroutine to format date(s)
Parse a long string into lines?
PageBreak-broke?
Errors raised out of nowhere... help appreciated
Connection to MySQL causes "Catastrophic failure"
Customize a button on a MsgBox?
Pivot Table and data from MS Access
Some formatting 'lines' will not go away
Userform Input Into Excel
nbst
Using Checkboxes
Increasing file size...
Menus
Display Word Paragraphs in Excel???
Prevent strolling pass a particular cell
save without code
VBE search
Checkbox Lock
ActiveCell.CurrentRegion property
Problems with Deleting rows using VBA
In Excel, how do I select rows in which a certain value appears i.
In Excel, how do I select rows in which a certain value appears?
Inserting Lines
how do you set or reset the print range for several sheets at a ti
Print Range
Convert seconds to time
delete combobox
How do I copy macro into new workbook that was created automatica.
Call another Macro
Persistent menu item with Excel Automation Add-in?
VBA decimal places
using macros to import data
Boxes
Prompted to save even after setting wb.saved=true
how do I make a routine run after the 'cancel' butten is pressed .
Prompted to save even after setting wb.Saved=true
Button Images
XP, Excel 2003, VB6 cell border problem
Validation of cells
Range Name Duplication and PasteSpecial Macro
Connecting to External Database
Sending macro based e-mail with built-in "Heading" and "Text"
RTD server on remote machine.
Visual basic Code
VBA Function error and display result in sheet
Need help with ADO in Excel
Inheritance of references
Invoke a macro with the Enter key
Deleting "Share Log" Filters & Print Settings for prior users
In need of a macro.
Creating PDF Files
How do I program a macro to do an essbase retrieve?
Handling of event raised in other class module
Help required in VBA
Can we modify the macro to accept multi-inputs?
Programmatically set Excel 97 Control Toobar Checkbox object & container name
Addins & iSeries
How to I program on rows after autofilter in Excel?
Getting named range from a cell
Copying filtered data
Questions with using another workbook for data source
Thanks to All
Central Ohio Excel Programming Interest Groups?
How to obtain Cell Name
Simple data/Hard statistics
Sorting in a macro
Date subtraction question
List Box SOS
How to use Excel VBA to query a SAP database?
Newbie: Need VBA & Excel references
Runtime Error '1004'
Runtime error '1004'
Auto Insert of Rows
Testing for filke in directory
Copying Defined Names
Cannot close excel
Moving to first Instance of a Value
Simple data/Hard statistics
Convert Format of SQL Data
export macros
Syntax Laurent Longre's Morefunc VSORT with arrays?
VBAProject duplicates
Number format based on number format of another cell in another workbook
simple question
Re: Opt Out of a Query.
disable custom toolbar
Problem with webquery in VBA
"Excel.Application" Object Model
Excel Loan Ammortation Spreadsheet
Excel form in Outlook
Excel Loan Ammortation Spreadsheet ?
Take over menus
Working with directories question
Fastest way to sort large 2-D arrays?
Finding a File on the C Drive
Opt Out of a Query.
Graphics Call With Macro - How to Exclude Some Pix?
How I do to validate a date?
Pivot Tables Formatting interior color &Type Mismatch
Close Hidden Data Sheet
How do I move a toolbar with custom macros over to another computer?
breaking a cell into two cells via VBA program
Macros disabled on my other computer - stopped accepting my personal certification
Printing Text Files from VBA
Problem with hidden file
regardingh spellNumber VBA project
Changing text in other cells
Pivot Table
Application.GoTo
export file from txt (Notepad)
Dealing with a large table and multiple calculations
Excel VBA with power point?
Excel 2003: Alignment problems saving workbook as prn file.
Vlookup --> LookupV
Convert CSVs to Excel workbook
cell reference
Linking to IE
multiple range reference
is there a code to wait?
?
template gone crazy
URGENT: Mac/PC Macro compatibility problem
Excel & ASP.NET
Paste values only
Delete Images
Storing value in a variable from a cell
Excel - VBA - PDA
Updating references in earlier versions
Get a reference to the currently running IE ?
Runtime error 1004
Lookups and variable sums
How can I convert the contents of a text selection from uppercase.
Opening Addin using URL
SQL embedded "IF" statement
Run-time error '1004' on hiding worksheets
Private subs
Assistance with linking please...
down with the debug error
Print, Save or E-mail Button/Function
Help with TRIM Function
building xsl for an xml
Communicating with Outlook
Case Select
popupmenu is not invoking the code
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Faster For-Next Loop?
Navigating among worksheets
Rectangle that activates a macro
Open Files
Tutorials with examples
access password
multiple range reference
Naming Range Variables
Macro that will delete any un used styles.
Re: Saving an Excel 2000 file with Excel 97
Re: Later version
Print comment indicators on Excel
Data from Access
CellColorIndex
Error message 400
Internet Connection Issue
Interacting with IE
Hyperlink Excel2000 vs Excel2002
dim problem
Help with Click link, Find, Paste (Excel to Web back to Excel)
Looping through Sheet
Sort Based off of an Input Box
.Net + COM+ example
Excel changing Default Printer
Scope of 'On Error Resume Next'?
Help please in selecting range dependent on another range
simulating click events
How do I compare 2 lists and show duplicates as a new list?
PRoblem with Ranges and Sumproduct under VBA
disable the x button on a userform
Filepath and Updating Links
Concatenate and vlookup function in vba
UDF to reference a specific element in an array
VBA into Maximiser
Printing if a cell is blank
VB Critical 400
"Date" function in VBA
SpecialCells(xlLastCell)
Simple for.. next problem
Plotting blank cells
DISABLE "SAVE QUERY DEFINITION"
Version of Ms Excel - using excel programming via vb 6
FORMULA REQUIRED
How to avoid recalulcation (UDF)?
Save a range to binary file (including its format)
in XP, locked cells cannot be selected
File status
Access + Packaging Wizard + Excel
can anyone help me with a payday calculator?
Can 2 workbooks share data in Name Fields?
Can't iterate thru a row with For
Macro cell reference help
FInding a Date with wildcard
duplicate last name and date of birth
Workbook.Quit
How To Pass Value Using "ByRef"
Can't set Excel Options
Rename File
What is the better way to scan cells after autofiler
need code for disable selection of locked cells
Web Import via Firefox
Modeless window
Excel Macro using vb script
How to express a cell address into numeric for array use
format first row within select
Combining fields and outputting to one cell
auto number form
Not IsNumeric not working - or is it me?
Out of space stack error, simple code?
Excel2000; display worksheet in userform
Select a cell containing a word
Script to send
Tab Position
Help with loop
Pasting an array into a range
Q: assign field background color dynamically according to field values
Open Powerpoint Presentation via Excel VBA code
HYPERLINK URL PROBLEM (Excel2000 VS Excel2002)
Macros in Excel 2000 running very slowly
Object Browser Help
How to set Tab-to-next-field in a custom form (created with VBA)
Object Browser Help
Help with VBA (or VB) DateAdd, WORDAY functions, date format
Assign a variable to a word document
How do I print the contents of a textbox that is on a Userform
A excel function similar to ListFind()
Opening a user selected workbook
Export Excel Sheet to JPG or TIF
How do I set up a macro to automatically update links upon openin.
Setting a variable to represent a union
excel issue Q183503 now happening in Excel 2002
Code that Crashes Excel without fail - Excel 97 SR2 WinNT
Closing Excel from a DLL
Macro - Cell clearing
YTD to appear in the Charts
Need help with spreading logic
Runtime error 9
Macro
Save sheet as .txt
Happy Face gauge not updating.
Yet another undesired pop-up
Need help with logic to spread changes
Error running macro
supress conditional formatting
Macro
saving an excel file as an ASCII text file without delimiters
'Kill'
Does anyone have a sample Employee Travel Request form in Excel o.
Paste Failed
Digital Signature being dropped
Macro
Apply "EnableResize" to Application?
Unprotect from Forms Listbox
Title Bar
Referring to other workbooks
Macros
Selection.QueryTable problem
Inserting Rows during a SheetChange event
For/Loop skipping one value in loop only
Show Full Menus
Create a macro to select items from an existing list ....
Add-In to load when Excel opens?
Printing Problems
converting excel
File Browser Prompt
After importing FIND en CHANGE corresporending value
FullScreen Question
Sumproduct and finding partial strings
Cannot Undo After Running Macro
worksheet embeded ?
Macro launches after activating a range of cells
Excel should export its file as exe
what are the uses of excel?
Remove Query Definition with Macro or VBA
Select and then sort a list
getpivotdata with offset
Changing color of a row depending on coloum values?
Backspace and percentage, please help
Inserting Hyperlink in Excel 97 Macro
export in graphic format - experts, can vba do it?
export in graphic format - experts, can vba do it?
SQL - SELECT INTO making temporary Excel table
automatically changing the background color of a cell
SQL - As part of an aggregate function ERROR
Macro to active Menu Command of File>Send To>Routing Recipent
Macro to activate menu command File>Routing Recipent
MsgBox Font
Excel, C#, and IE
On Error Goto ignored
Listbox.RowSource problem
Pictures on modeless windows
Excel C# programs with Visual Studio .NET on Windows XP Family Edi
Deleting rows from list of files
Day associated with date
Excel Workbook Hidden Problem
Add-In Functions not listed in Automation
Macro to Delete Row
Getting text file into a VBA string variable
Easy copy of an Array Formula with Dynamic Value...
XL 97 Text Box property - WordWrap
Determine if character is text or numeric?
VB automated pasting of Excel range into Word document
How to autofill Excel form with User's Name (i.e., from Outlook)
IF and AND
getting info from a combo box
xml webservice Client
Help with find function please!
How to make new, blank
How to autofill Excel form with User's Name (i.e., from Outlook)
FollowHyperlink to OLEObject
Multiple IF situations
How to use the "found" cellvalue in VB.
How to Create a Search box and button for text information in an excel sheet.
Simple, need assistance
Q: search string
running same code with multiple controls
Hide Formula (or Lock Cell) using VBA
Re: Import module in protected project?
sdv file question
Inserting a single character into the middle of a 3 GB file
delete rows autofilter
Tooltip for mouseover of Image OLEObject (from Control Toolbar)
unbound pastespecial in Access
count within a range
How do I print out ONLY certain cells for preprints?
Adding frame on multipage through code...
need Thompson tau on Excel to remove outliers
How to make Add-In worksheets viewable.
Using Web Components Spreadsheet Objectin Userform
Close with no pop-up?
Adding new sheet's cell value to old formula
Variant Array retaining data in it after procedure finished
Named Range in Center Header
writing range contents to arrays; best way?
Dictionary can't handle Longs > 10,000,000?
Simple Dumb Question: App.ScreenUpdating
Need help with input box
make outlook visible
quit without saving option
Disable mouse?
Help With Producing Results Please
Last Row Utility
Characters
force a macro to execute
office web components
Copy/Paste of separated columns from Excel to a thirdparty application
Select visible cells using vba
Re: visual persentage like effect & referance cells
save object as jpg or gif
#NAME? Error
Find a backslash at end of a cell
label_change event?? ODBC control??
How to prevent copying of an order form using an excel spreadsheet
WorkSheet Event - Copied
Macro to copy cell from one worksheet to another
Trying to create Routing macro - problems
Macro, worksheet, from where did I come?
deleting multiple rows with multiple criteria
Missing Paramenter List
Need Macro To Close Excel Application
connecting multiple work sheets
Range and Cells method
Copy Row Of Formulas After Last Used Row?
Floating Form
EMAIL IF....
Farfetched question!!!!
Moving window to show chart
enabling macros
Calling Excel macro remotely?
TextBox that only accepts integers?
Excel 2003 Importing large delimited text file
Determining Array Limit
Cell validation problem
Personal.xls
Macro Problem
Error message when start a new EXCEL
View only UserForm?
Is it possible to hide the Windows Task Bar?
Pivot Table Data Refresh error after upgrade from 2000 to 2003
Progmatically adding controls in multipage
CDO Email
Using Excel to open other files
generating an excel graph with C++
Add Unique ID to end of every cell?
Cells & Characters
Start macro upon cell's change in value, 5 questions
Merging cells in Word Table from Excel
chk box to filter or hide rows based on value in a column
Protecting workbook with hyperlinks
divide date & time into two columns
sum function in a userfrom
How can I install a Message Box?
repost: need help trying to automate Outlook from XL, with late binding
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ?
Macro stops running after file has moved
Userform Date Formatting MM/DD/YYYY
VBA Userform To Excel Inquiry!
HOw do I populate fields with just the workdays?
open excel from Access
Error running simple command
Return the location of data point on a chart
How do I set up a combo box to select one value but pas an other .
Error 7 Out of Memory 2/3 through Macro
RE: unlink a pivot table
Help - Error: Unable to set the PrintArea property of the PageSetup class
How to paste only certain columns from a listbox into a named range
For....each w/ workbook files
Programatically merge every other row?
Make Combobox act like autofilter
GetOpenFilename
programatically merge cells?
Re: Problem with multiple Auto_Open Macro's
Re: Print selected sheets in Excel
Autofilter / Sort question
Re: Print selected sheets in Excel
Sum selection - like in status bar
Code not printing to color printer
Re: Print selected sheets in Excel
Using "Evaluate" with Sumif
Q: break link and save
Re: activecell.specialcells(xlCellTypeVisible) returns column refe
Re: excel page numbers
On Error GoTo
Re: Delete Rows containing pop-up entry
Re: Time conversion
Re: Adding data to the pivot table datasource
Macro Problem
Re: If...Then Insert
Re: excel page numbers
Re: Disallow sorting of data.
Print selected sheets in Excel
Internet Explorer question - Trace to new image
Problem with Sumif and Right()
Link excel field to Acrobat files
Send worksheet via email this spreadsheet button
Making progress with array functions, another two questions
Column REferencing is out of wack
Help hiding macro work
Help with Dialog box pop ups
Problem copying ADO recordset to Excel 2003
Problem copying ADO recordset to Excel 2003
ticket numbering
sum values in a col only if value in next col is desired value
Help on writing class module
changing the font size on the drop down of a list (autofilter).
Disabling Move for Userform
filtering data
RE: Sheet copy after
Help finding colum with VBA
Image control DC
Re: Page Setup functions very slow in VBA RE: earlier thread
Macro Sort Problem
Re: Tabbing between Text Boxes
transposing and parsing cells
Refreshing all Pivot Tables in the On_Open() code
Reference code in another workbook from a calling workbook
Ideas for quicker way to populate adjacent cells with array elemen
Events for listobject
Sort sheets using both alpha and numeric?
Q:sheet to file
Need Help w/ Code
Excel can't find OE
Help creating formula
How to change font in a macro that inserts a formula in a footer
choose? lookup?
Compatibility issue? Excel97/2003
Easy question (Combo Box)
Stop Worksheet_SelectionChange event from firing?
Dollars/Euros - handle multiple price fields
Help with setting Print area to more than one worksheet with VBA
Counting in cells
Processing code on wrong sheet
SQL - list items that have duplicates
Help Simplifing Code
Sheet Copy After:
Basic Macros?
Regarding data in multiple tabs in a workbook
Find/replace format?
Name of range containing ActiveCell?
Possible to select and delete multiple items
Trying To Enter A Formula Into Every Cell In A Column.
A range variable consisting of multiple ranges.
create a macro to automaticaly name a file.
Printout method: in color, duplex
Range.Copy (Destination)
Web browser question
ThisWorkbook
disable cell "drag and drop" for a cell/range meeting given condit
Calling Com addin from form button on sheet?
Finding which version of Excel created a file
submenu help (how to create arrow for expanding menu)
remove sheet gridlines permanetly
Adding & removing menu buttons
Which cell did I click?
More than one password?
different times with autofilter row deletes
Show & Hide Shape in a Sheet
Printing a Pivot Table from code - Excel 2003
limit copy command?
how do i setup an if, then statement