Excel Programming [Archive] - Page 146

Query returning more data than will fit on worksheet with VBA DB query...
search facility
Protection & Macros
Last Row Help
Files properties
excel to word.
SmartDocument: RefreshPane() doesn't update TaskPane immediately
Getting excel array dimension
Select last cell in range
Activesheet.delete
How to detect user quitting excel
Copy Rows and insert these rows before a page break
Need Mac File Type Code for CSV formats
function returning array
How can I set the title permenantly
Goal Seek
Pivot Tables - slow...
How to run Reports in excel
SaveAS w/ a variable name problem
Loop too slow deleteing xltoleft
formating an excel spreadsheet
how to Pause a VBA procedure until user presses Enter
Shared Workbook - Hiding rows as per Username
How to add menu button to exisiting menubar
Hide/Unhide Columns representing dates as per Current System Date!
loops and If's
Import from web query problem
Excel vb running a batch files and parsing output issue
colors
Autoexec Macro
clear the clipboard?
Programming lag..
Re: Copy VB Project
Re: Visibility Problem of Embedded Buttons in Worksheet
double array
Re: Print Preview
hiding showing columns using checkboxes
Worksheet_change
FaceID Toolbar (The best one ever!)
Macro that querys only the most current dBase file.
Color index values
Mouse pointer
What does undersocre line mean
Cell comment string trunckating
Series Code
Convert an empty string to a double
AUTOFILTER copy and paste
Fill with a formula until Cell is Blank
Msgbox button labels
Re: Run Macros Sequentially
Trying to set the Collate default to off.
sum function
Is there a way that I can control a row's height with programming? (or cell contents)
View range in a macro
run macro automatically
Excel VBA - Assigning macro to button.
Re: Decoding a Range String
Sheets select method fails when workbook is opened by another workbook
Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue.
extract time from excel serial date
2 Questions about inserting rows.
Display HTML help file using FollowHyperlink; want browser to have Focus
MACROS & COMMAND BUTTONS
VB coding for showing "find" dialogue box?
Re: MACROS & COMMAND BUTTONS
macro to select sheets/page in a workbook and print them
Excel ADO SQL StoredProc
How to set up a sub-total routine?
Two Match Statements.
Loop through all Open workbooks
Re: R1C1 type refences in VBA for column identification
HPageBreaks oddities...
Worksheet_Activate
Reverting to a date
Make Sure User Selects 3 Cells
msg box help
Breakup cells having 2 words with a blank between them
Selecting range question
Macro problem
Selecting filename in cell from file browser
Duplicates
VBA Forms and Illegal Operations Galore
drop downlist that captures criteria from another sheet
Information into tables
how do you add a row of data like in a database
Testing for hidden rows
Excel 2003 Autofilter Problem
IF Limitation?
#N/A Using SQL.REQUEST
escape character
Copying of sheets
OLEObjects clickable?
on press
data from a sheet to a matrix
Missing References
On Click Event?, and how to use
Using forms
timesheet
Running Macros in Access from Excel
Appeding user data to the end of excel file
focus
Can information from 2 columns show in one combo box?
Select method of Range fails
Hidden Files
new class w/ graphic objects
List Charts Macro
Cells.Find doesnt work on columns other than A
XML
Do.....Loop until IsEmpty(....)
msgbox query
RTD Throttleinterval. How do you change it?
XML selecting sinlge nodes with name selectionNamespaces
screen clips
Excel VBA (?!)-refer to a cell on Sheet to left of X, based on criteria on Sheet X
Userform Print
Msgbox query
Filtering File names
Macro to Close and save all changes
VBA saving
Grey Panel/window
Combo update filtering
on press detection
Cell Bound Combo Box
listbox as filtr
How to Sort Data by columns and display the data on GUI using Visual Basic
Zip&Email-VBA
Help creating link & formula from user input
Message box
Excel VBA - hidden rows / autofilter
macro auto run
Can it be done
Macro Question
Newbie vba - How do I reference cells in another workbook
Decrease file size
Excel VBA problem
Auto- Fill Dates?
Why does the EnableSelection-xlNoSelection stick thru the user interface?
Option to continue or cancel
frm Excel 97 to 2003
Worksheet_Change Event triggered off specific cell
Passing format to variable Part 2
sending email from Excel
why does my excel file size increase when I use visual basic editor
Web Query for Currency Rates
Convert range of text to values
2 column List box
Menu for user forms
Can you reuse links??
Passing Number Format to a Variable
One more macro
Prompt user automatically
keep focus & window steady
Combobox run time error
Date Colum Date Formatting & Validation
Ack. Going to another column Take 3. Sorry!
Excel 5.0 compatability problem?
Excel Add-in
Userform troubles!
controlling another application via VBA code in Excell & sending keystrokes & mouse clicks
Import CSV with match
for...next and criteria1
Converting to R1C1 in FormulaArray
Excel 2000 and TextBoxes
Shared Workbook Question
Chart component
Stepping through For Each...Next backwards?
Works with Excel 97, not Excel 2000
copying output from pivit tables
Web queries
Find Function via VB
Sorting times - getting messy
Re: Help with 1 code line
Help with 1 code line
Code is Running Too Fast
Pasting Q
input message
"Cells" become "CellS" - why?
building a smart league table
VBA Code printing problem
changing directories...with vba
Sending spreadsheets through Lotus with a group mailbox
Names of macros for toolbar buttons
Amend Access database from Excel
HELP----Row cut and Paste
if a=true and b=5 then....
Specify style and color of marker in chart
Help for a VBA rookie
strange printing/looping problem
Fix If statment to accept Upper or Lower Case
"=ROW()-1" type of coding doesn't appear in a filter / is there coding that does?
911 Excel Cache!
Vba Help Required
Macro programing
Writing Unique Solutions; what could be wrong here?
NewMenu
create new Folder
Macro to various text values in cell to separate cells
Macro to split mult text in the cell to separate cells
Copy Last Row & Paste
Add Up Q
Creating a Macro that loads the most current dBase file.
Macro needed
possible "or" function?
Enter= New Paragraph in Text cell?
Copy Last Draw & Paste
detect upper and lower case letters
Quote qualified data export
Have a Formula I want to put in to some Code Q
Macro.
Sorting
Find a hidden entry
Hide row from VBA
Delete Entire Row If Q
colored a cell
Help with Error: Type Mismatch
Same sub different results
Source an Access Table for a dropdown list box
Loop through all files in a folder
plotting chart with user selected range from current workbook
Need a macro to move data from column into rows
EXCEL VBA question
One more loop question
Excel 2000 not working at all
Deleting shape series and trendlines
Need to Pull Data into a Comment
Tracking Workbook usage
Recordset Problem - object is closed
Send active workbook as attachment
Print Box
Hidden data?
Error Trap for bypassing Password Protection
Userform
excel with embedded word doc
Disabling Close, minimize, and restore
Read data from a text file (*.txt)
Need a Quick answer on this one.........
find workbooks with macros
VBA - SaveAs hangs (2003 vs 2k ?)
Sending Email Through Excel - Disable SpellCheck
Excel exception problem
Matching cell in one column to value in another
How to jump to fisr empty row?
Multicolumn Listbox and ordinary listbox
Macro Help Please
Whats the equivalent for NETWORKDAYS in VBA for excel ?
Creating a Sum
Controls in Excel
Excel VBA - MsgBox to display variable value?
Exit Excel programmatically
How to execute a macro when data in a pivotchart changes?
edit cell names all at once?
how to select multiple rows using vba
How to Activate unknown file name
Macros to Cut and Paste
Excel VBA syntax problem
Re: VBA error check using Excel functions
Why 2 legend entries?
export from excel to word
Initiate perl script in linux from a Windows VBA program
Looping thru the active selection
Problems with using SQL via VBA to extract db data and copy to a worksheet
Macros and command buttons
Help with Formula
Re: Importing data
Re: Activate Macro on Activating a sheet
Selected Cell
Last Row Macro
Processing a set of Excel Files
XL97: Out of stack space opening web page as workbook
Re: "If" VB Syntaxe
using escape key to exit a userform
RE Any ideas why this simple proc. won't work?
Command Button
Re: Importing data
Multipage control tab font
Run a Database Query within VB
"If" VB Syntaxe
How would I get every third row to be a specific background color?
Excel ComboBox mouse scroll
Any ideas why this simple proc. won't work?
If this is impossible, just tell me.
UDF needs to update cells.
NEED TO REPEAT ROWS AT THE BOTTOM OF EXCEL SPREAD SHEET
clipboard
Reading a Range
Can't Move Menu with Macros to Another Folder
Changing a made up password
Showing Multiple Sheet Info
Select a sheet to copy from one workbook to another
Web query with parameters does not work in Excel 2000 - Please help
Deleting Macros from a Worksheet
multiple calcualtion
Resume Next doesn't work in IsOpen function
IS THIS A BUG?
List box from another sheet with Criterias
Inserting a row after every seven lines
mac problem
how to hide .CSV file extension ?
Calling a macro from an IF statement
Bypassing Worksheet SAVE
run time error 1004
Excel VBA - Conditional formatting
please help!!
Printing 2 sided from different worksheets
Link between files with vba
Changing the Name of an Addin and loading worksheets off a network drive
MS Excel: Please help with toolbars/buttons...
MS Excel: Please help with toolbars/buttons...
Weeknum-function
TextBoxes on a Form
substitute strings with variables
Combo Box Query
Use data from an external sheet.
Syntax for WorksheetFunction Match
Out of Memory
Arrays
Search Wooksheet
Help writing a macro
OLE action error thru automation
Finding and replacing characters in Excel
exporting data from a form to a spread sheet
Delete a row in an array
ComboBox Scrolling
SSTab problems
Is there a way to create a program in excel to compare files?
String manipulation from one cell broken up into multiple columns
Excel Macro Help
"file available for read/write" message
About PageField (cont't)
macro for shifting/combining and arranging data
How do you reset 'change was made in workbook' switch?
Save Excel worksheet as Crystal Report
send email msg
Building a secure add-in
Getting hWnd for API call or Color choosing dialog
Dated Fields
Run quietly
Passing listindex to worksheet names
run vba automatically
Application level events no longer execute
Excel to Access
Please explain syntax needed
Highlight found text string in cell?
Entering Data in 1 Worksheet to appear in a specific format in Sheet 2
Creating carriage returns in msg or input boxes
using named ranges
Using Offset and Match
VBA and charts
Tracking workbook usage
Sending text
VLookup
Using VBA to send email based on form response
Code to hide columns problem
GetOpenFilename Dialog default path
Re: Form wont hide
Re: How can you turn off screen Redraw
VBA Array Transfer
Re: How can you turn off screen Redraw
Multiple Userform Hold Data to edit
Macro - File Save As
VBA that recognises the end of a sequence
Generic Workbook Select
Rename active sheet
Unhiding the worksheet
Footer character limit
Combo Boxes Not Changing Independently
VBA code for Deleting rows by verification
Delete sheet without prompt
number
End of Page
Re: How do I set up a macro to repeat automatically in Excel?
Auto merge files
Office 2003 v Office 2000 - VBA
formula remains as text rather than formula
Easy one- Comman button close
Macro Help Please
Borders question, please
Deleting Blank Rows
Using "Cells" to write "Range("A:A,H:H").Select"
using VBA to emulate "validation" drop-down list
multiple workbooks opening
macros dont work
VBA Action on excel #Reference! error 4?
extract text from a comment
"3" TO MARCH OR "11" TO NOVEMBER
closing an excel application
Password on an E-Mail File via VB
Custom form on opening - I think it's an easy one for the experts
Excel Macro Weekday / Today Function
Creating Ranges
Re: TextBox Focus
Summing Columns Based On Value
Comparing data based on two columns
Decode from URL of hyperlink
Finding an Average based on a Condition
Re: TextBox Focus
Manipulating bits
Worksheet_change event
Print Dialog Cancel Button
Re: Newbie VBA: How to test second position in a cell?
Slow Excel 2002 VBA on WinXP
"Object variable not set"??
Countif with 2 conditions
Macro to merge cells
Sheet Protection Identifier
Script to make my life easier??
Deleting empty rows
Read the contents of the column
Excel VBA - UsedRange problem
Re: TextBox focus
Active File name
Excel 2002 SP2 VBA 6.3 'RefersTo' Method fails
Increment Alpha Character
Exporting Data from Excel to Access Problems
Macro that will always hide / unhide next column
Can someone tell me what's wrong with this code please?
Re: Using find range
Yes No Auto-answer?
Issue with Toolbar Menu
Sharing Files
Date looping
Stopping the Update Links Message
need help with a formule
Shell command
Button
Help with shortening/cleaning some code please
Change range multiple times
Excel VBA to save .xls file as UTF-8 text file
How construct a formula from cells with formulas as text?
How to stop screen blinking when running macro
Problem with opening an Excel 2000 workbook in Excel 2003
Excel/macro Formula Problem!
Pivot Tables
Sorting 2 sets of information
Excel VBA programmatic validation problem
The userform X button
Data,Text to Columns Clean up
Date query
Having a status bar (%completion) displayed while my macro runs
Toolbar & dynamic filename
how do i incrememnt a cell?
Selection the previously selected cell
Editing text file
Error on advanced filter vba excel - 1004
openning word
saving workbook with specified filename on the romote server
Excel 2003 hangs with dates in user forms
Slow macros cont.....
How do I select a whole range and delete the contents of the cells?
Pivot Table Page Field Question
Re: Update Combobox with New Data
vb and excel as datasource
Problem with opening an Excel 2000 workbook in Excel 2003
Advanced sorting in a spreadsheet
How to undo changes made to Excel sheet programatically
Highlighting a row in grey
Select Range using R1C1
Re: !!!! A chance of a lifetime !!!
Re: !!!! A chance of a lifetime !!!
VBA: saving as with the name of the worksheet
About PageField
Pivot Table Automation Questions
simple formula to count cells
Re: Program workbook title as the filename
Excel Macro Filtered Data in-place: cannot calculate Frequency of Visible Cells
copy & paste (To: choice)
Not receiving all posts
Sorting a table
Next without For error
Chart being trashed after 5th build
Conditional alternating loop
Getting Data from Web Servers and Application Servers
Help Req e mail to sheets
Change Event and Calculated cells
Excel VBA formula call in VBA
sending data to com1 port from excel
CommandButton Margins
Re: VBA code to add hyperlinks
copy and paste
Entering 1 line of data values that will show up in a second Sheet?
Calculations in different countries
Write a Shortcut to Open Excel Workbook at a Specific Sheet
Trim path from full filename
loop through a cell.
print seperatly
Customizing the autofilter dropdown
Re: Optimize RAM Utilization
Combobox Population
How do I turn protection on/off with Combo boxes
HELP! Please!
Combination Determination?
Clock how long it takes code to run?
Automating Add-In Steps
Add Workbook with specific number of worksheets
Memory expanding spreadsheet
Excel templates on web
Strange behaviour in VBA Help
Code Query
In Reverse...
Re: Macro Execution Stopped
Re: Preset Display Setting in Auto Open
Range doesn't fill
Import template
Copying Cell Contents throughout spreadsheet
Selected cells become deselected?
Re: Preset Display Setting in Auto Open
Database Funtions for pulling data
Excel Macro exporting to MS-Project 2002
merging ranges
UserForm
Excel VBA not recognised
Application.goto
VBA - Colored Tabs Excel 2000
macro to spellcheck entire workbook
Automatic unlocking and locking worksheet on opening excel
PLEASE, PLEASE, PLEASE HELLLLP!!! Excel macro destroying Word toolbars !
listboxs and combo boxes
HELP:old format or invalid type library
Hiding Part of the VBA Code
shapes
Re: Finding the Blank Cell
Alternative to Vlookups?
VBA-Add Column Totals
Deleting rows by name in cell
Detecting Save vs SaveAs in BeforeSave
Workbook Open method
get row and column numbers
passing variable to file...
macro keeps shoving cells aside
Adding Descriptions to Function Parameters
Cancel button to bypass MsgBox
vb command button
Sendkeys will change the status of Numlock
Setting range value to a variable
vb button
Inserting Rows Above Other Rows.
fill in hour in excel sheet
Userform
Data Update Form
range of cells
Run Time Error 13 in Excel Chart (XP)
Summing Fields
Textbox
state of option button
LIstbox Question
Assigning name to button
Error bar
Pivot Table, Consolidating Columns
Parsing Word document into Excel
Paste Values via VB Q
Scheduled Procedures
Required fields
test
peculiar problem in cell references while merging excel sheets
Re: Problem with VBA compatibility - Excel 2003
Incorrect results of Weekdayname(Weekday... function???
Enumeration
How to register an event handler when excel opens
Excel 2002 - Slow macros
copy cells with more then 255 chars...
List Boxes
Case Statement Help
Unwanted date conversion when opening a workbook
Function
How can I break down text in letters using VBA
ComboBox Exit
Screen updating
Problem with opening an Excel 2000 workbook in Excel 2003
help needed with VB
macro help needed
Textbox focus lost
Variant as matrix
Problems opening Access database from Excel VBA
Problem with VBA compatibility - Excel 2003
Message Boxes
VBA passing vector from spreadsheet to array
Array Values
Process excel files, suppress alerts
Urgent - Ctrl-V between sheets, not allow Drag and drop
ComErrors
Re: SQL fails without breakpoint
How to add icons in the Listview control
Dynamic Array
macro to change repeat row/column print setting
Track a Memory Leak
Do this function for each row in worksheet
BeforeSave sub won't save another workbook when triggered by another event sub
Using multiple conditions
Run Minimized
how to skip Update Values dialog when links change tonon-existent spreadsheets?
Iterate through the values in a named range?
Named Range is a formula
calendar date limits
Notes on Chart?
Triggering Verification Function
Web Query VBA help
call excel 2003 macro from command line
To put an automatic " End total " on column Currtotal
Pause
Run a macro batch process
Re: Trying to protect output file with Macro
Range.Find returns cell outside of range when range set to single cell
Creating ustom toolbar
internet data through marco into excel
AutoFilter and Freezing Panes using C# for Excel
Print to Adobe Acrobat (2 ws to one file)
Create folders on a shared drive with a macro
Moving 1 Data Cell into A second Sheet?
Re: Print macro for multiple ranges/sheets
Slow Load Help
What does CTRL-ALT-SHIFT-F4 do?
xlVeryHidden Resolution
Multiple rows to one column
Re: Print macro for multiple ranges/sheets
How to get a macro to start in the right spot!
Help with Multiple Excel Sheets
Removing menu bar customization from old XL95 files
Use ADO Parameters in loop
Questions upon opening workbooks
Doing a calculation, then looping for several of the same calc
Complex numbers
Registering an even handler
Re: Unprotect,refresh then protect again
which odbc excel driver is the best?
Excel automation help...Involves multiple Excel files
Inventory Workbook - automated entry worksheet???
Average If Macro
macro to track profit when long
Importing data from another workbook
Macro problems with range and naming issues
Setting the value of a cell from a combo box
vba, excel, commandbutton1_click() x,y?
Variant Array
Subtract 1 from Each Number in Column
Sort macro by same columns
Printing to PDF using VBA
Enable/Disable Macro
text box percent field
Close a workbook
Say 'YES' to overwrite file
excel solver addin
Code to colour Unlocked cells
Dynamic Variable Name
List Search Results in a UserForm
Re: Execute VB Form from Excel
Automatic Saving
Re: Disable Worksheet Tab Menu
Re: Disable Worksheet Tab Menu
Range Notation for Excel Functions in VBA
Help!! Instead of Conditional Formatting, pull interior color from lookup
excel, vba, command button
getting values without using "select"
Consolidate Range
Importing data from a Text File, Not enough lines?
chart point value
on Calculation event
Trouble with variable type
Saving Procdb.xla on exit from Excel
SmartTable program
Re: optionbutton in userform
optionbutton in userform
ID numbers
Scanning cells to get their value
Setting LinkedCell of individual OptionButton
cut and paste macros along with lookup
macro needed for flagging dates due
ROBBYN - RE -Code Refinement involving blank cell(s) COULD NOT POST FOLLOWUP
Macro for updating memberssubscription list annually
Date Format Issue
Format cell if contains a value
Add one more condition
Goto end of data & select all rows below
problem with Application.ScreenUpdating
Macro
Combo Boxes
cut and paste
macro cut and paste
Need Formula Listing Code Modification
How to subtract many cell areas (between sheets)
Macro
Move to a cell referenced from the current cell.
Changing a PivotChart Removes Series Formatting
Open workbook that is protected with password
Sort of excel calendar
Clean big arrays of data.... HELP !!
Drag and Drop
extract string
Issue in date formats
Get the list of applications which are running
Working with line OLE objects
how to delete excel cells that are color-filled?
Macro Shortcut
Create Global Variables in a module
Ubound & Lbound
toolbar
Problem with clearing cells
User defined function not recognized
Problem with Pivot Table
changing footer before save
Code was working all the time, now sometimes it does and sometimes...
Transpose Problem
Excel VBA - use of ActiveCell.FormulaR1C1
Excel 2000 calling functions in C++
IF formula to display a product of a calculation
save as error message
Excel VBA - Printing filtered records
VBA: copying and inserting a dynamic range
broken hyperlink when I send email uuing outlook2000
Validation from a list
Calling WinZip from Excel
sending email winthin a macro via Excell 2000 under win98
Algorithm based on time and date ( =Now() )
Paradox then paste into excel
Shortcuttext
Seperate column
Save as and file exists.
Problem with user name and password
Compare first characters in two cells
EXCEL.exe Error
Execution on opening the workbook.
Editting textbox value that is grouped with a shape
Create an Undo
That gives me an error... (it indicates that my else has no If ...)
pivottable + chart
Code Refinement involving blank cell(s)
personal macro workbook
How can I call a macro in another workbook?
Worksheet_Change does not work
right function
Updating Header Information via VBA
Sort Numerically Worksheets via VB when creating a new worksheets
find date on other sheet
Trying to edit data in other cells from a formula
Bad Data Somewhere?
A question regarding Macros
Format Function stopped working...
general ledger
Goes to A1 on all Worksheets when Opening Q
logistics of application and procedures
New exciting : Infra-Red reader
Need Help Connecting To DB
Linking Comboboxes
Entire form is protected - Need help to understand
Excel VBA : Sheet selection
"Find" question
Changing cell color based on its value
From CheckBox to Cell
Visually check Protection code
How to use an array
color function
how to read past news?
Pictrues in Excel
Find the xlstart folder
Excel VBA - Insert Word Table problem
excel: activitaing a macro upon selection of a cell
E-Mail File Q
Sorting of data
Encourage users to enable macros
How to print current data and time to text file
ThisWorkbook.Path & "\" & .... not WAVFile, but AVI file...
How do I create a Drop Down List in a cell?
Excel in VB
Solver and Excel 2003
Tough One: displayalerts = false while OUTSIDE VBA
Get Cell Value while typing
Excel macro - Save as with override...
Excel VBA -Creating a new file
Urgent...insert values
How to create LOG file for commands executed in VB..?
Does a worksheet exist
simple problem with values in cells
who can help me???
selection.pastespecial problem
macro for shifting/combining and arranging data
vba code for Pivot Table
Welcome Sheet???
Enter data depending on Col A
Delete sheet without warning messages
Workbook renaming
Excel 2000 or 2002, Differences?
Command and pass value to Acces from Excel
how to read excel spreadsheet into database (DB2)
Naming a range
Named range questions
Internet connection?
Named range questions
Names.Add method
Multiple users of file
Multiple Condition syntax needed
How to put the value form cell into the msgbox
Before "Before Close" help needed!
Combining IF statements
Thanks Otto.......Unprotect and re-Protect
Help Needed to Set-Up Changeable Groups for Custom Grid
trying to put a check box in each shell with vba
Doing something wrong - xlVeryHidden
ThisWorkbook.Save not working under Workbook_BeforeSave, Help!
Deleteing Duplicate Rows???
another loop question
Scroll to Current Month on Combo box using Data Validation
get external data
Calculate hours from 10:00-21:00 format
Computer identification using Excel VB
Is it possible?
Find function very slow, when XLS window is not active
Macro to enable or visible on specific worksheet only
Type mismatch
Formula Help
VB6.0 vs VB6.3
Re: How to detect if a cell is formula
Search & Replace
VBA
Excel VBA - Best way to indent one column based on another
Determining chart points at mouse position
VBA Editor won't run
David McRitchie/Thanks
Excel macro to open word mail merge
Excel VBA - Varible number rows
print range based on cell input
lookup
How to Add an Object to the New Object List in windows 2000
Contents of a cell refer to sheet name
Excel 97 and MSWindows XP Home Ed.
Calculate Time
help needed with macro
Problem with Macros in VB (2 Parts)
Joining Columns
Problem closing Excel
Calculating Time
Syntax problem with" intersect"
How to get rid..."automatic links"
Workbook and Standard Module
Creating/programming an Excel dynamic graph
Vlookup?
MCSEs
deleting values from a column
multiple looping criteria
access to cell values
Code not executing
Date
How to acknowledge a message box from VB program?
Sum Total in a worksheet
Getting list of directories
Automation Error, Unknown Error. Error value - 440
Worksheet copy problem
I don't think this is an easy one
Printing Used Range--Method Print Out Failed
Paste contents of windows clipboard into a vba 2d array?
Scrollbar Thumb
vba- excel- "for each" what row/col (cell) is it looking at?
capturing mouse positions at any moment
How to create a URL and when user clicks it to open a Excel workbook
Re: Help
Excel to powerpoint
Skip a cell
Personal.xls won't open or record any more
Re: Prevent "standard" key event in userform
Sorting of values within a list box
Multiple Sorts
How do you open a specific worksheet using an Excel Driver?
Prevent "standard" key event in userform
run an excelfile/macro automatically
Row lookup based on a given value in the same row
automatically advance to next cell without hitting enter or tab
Array of 100X250 as return of a user defined function?
Selection Change Event...
MsComm32.ocx not registered
Printing Grouped Sheets
macro to select next and rename
Glolbal Variables Reset when using OleObjects
randomize
Reference Row Address
Auto-run macro after a save-as event
Save File to Another Directory, but not change Users File Save location
setting address in "mail as attachment" macro
Re: macros
Drop-Down List to Choose File to Open
**HELP** VBA code to insert subtotals
Drop-Down List to Choose File to Open
Re: macros
Adding a worksheet
Editing several hyperlinks at once
limit the number of operations of worksheet
VBA - Formatting issue....
format move
On time Event
Creating a macro to let a user use a keystroke for repeatative information
Tips on searching and comparing multiple columns on separate sheets.
Set Groups for Custom Grid
Emailing using VB
format ='s another cell
Re: Creating COM add-in
Web Query in Excel
Worsheet Name Change Based on cell's value
Macro to Paste to specific line, and continue to Paste each time on next row not over
Code not working on another comp
Error arising in Windows XP having Excel 2002, was fine in WindowsNT having Excel2000
Closing Excel From VB
Simple Exit-the-program
tic tac toe
Import/Export Excel spreadshee data without MS Excel install
Setting SeriesCollection values in Excel 2000
Re: Pause Macro to enter data in cell
VBA problem importing and auditing Unix reports
Re: Pause Macro to enter data in cell
Re: Navigate by macro
Re: Navigate by macro
Formula needed
Questionnaire ?
Memory Leak
Passing Strings from UserForm to Module
Toggle Button
Re: Sort Macro
filtered data
More Help
Run Time Issues
Stringing Subs
Thanks
Variable names in SQL
Pivottables from external sources
Re: suppressing error message
Re: suppressing error message
Saving Absolute Hyperlinks
BUG????
Excel displays picture of Britney Spears in a bikini every time I start the application
Re: Code to Insert a picture using VC++
DELETING FILES FROM A FOLDER WITH SPECIFIC EXTENSION
Last cell
"Restore" excel functions when error or leaving?
function on a range
Iteration loop
activesheet: chart or worksheet?
Cursor cell selector is displayed again
Iteration loop
Looping with logic
How to use Listview control
Excel Status Progress Bar
Deleting Range using VB
What is the {} symbol used for???????
assigning worksheet variable
MUST BE POSSIBLE !! ..........
Looping
Excel VBA Progress bar on a userform
Need help creating a case statement
Variable Name
Find last col with data
shell to behave in synchronous manner
Set Groups for Custom Grid
Prevent users from running macros
User Name / Computer Name
Restricting save ability of an excel file
Container property
Making certain cells editable after protecting the sheet
Interrogating format
Rowwsourceproblem
ActiveCell.PasteSpecial (xlPasteValues) hangs program
How do I access XLA functions?
ComboBox Not "Tappable"
XLB File missing
Beginner Variable Problem
allowing user to format a protected cell
Search & Replace
Form trouble
application defined error
VBA codes to determine program installed on PC.
Excel Pivot Table from SQL Server
Delete row when zero in column b thru e
Question about references
highlighting rows
program new worksheet
Error Handling and For-Next Loops
Directing Users?
Excel XP won't run XLA properly
Reversing the order of a chart
Calculation
Delete row when zero
Need Macro Modification
Macro to Copy/Paste then Paste to Next Line
if cell contains formula change background colour to pale yellow
PageSetup
Selecting All AutoShapes on a Worksheet
Conditional Formatting using two formula conditions
RE: Rs-232 in Excel
test
LinEst function
Click events on charts
Using VBA to set Headers and Footers with Font and Fontsize parameters
Run Time Issues
Quick 'report' - how do I get started ?
Data/Form
Focus problem
Please recommend a good book for Excel VBA programming.
optimizing a lookup
assign result of ExecuteExcel4Macro to an array
Using VBA: Trying to write new solutions ONLY
Select Sheet then Select Range
Re: Max Memory in a Excel Com DLL
Using VC++, ODBC Excel Driver: Access specific worksheet?
Extracting Url from a hyperlink
Shadows with forms