Excel Programming [Archive] - Page 161

copy range between sheets
excel error
Fill down relating to cell value
Moving multiple worksheets to new workbook in VBA
Making a Dynamic List in Listbox
RP - Office 2000 automation parameters Access and excel
reference to previous worksheet
Questions!
=(TEXT(RIGHT(A1,4),"####")&(TEXT(LEFT(A1,4),"####" )))
Opening an excel file with VB within Excel 2000 with or without the .xls suffix
Reconcilling list
Filter Criteria
Help please....
Is this possible?
Call_Database_Form Code. Please Help!
Unique numbers
Help?? Averaging cells
HELP! My macro won't link with form
Test to see if a spreadsheet window is open
macros, filters, HELP
Cell to contain page name
Really easy?
Excel fill down formula recalculation question
Macro to force text to rol to next cell
Ogilvy Help :) - "Object variable or With block variable not set"
calling private subs
Bypassing password
Paste method of worksheet class failed error
How to make the opening of a workbook conditional upon the opening of another workbook
Basic Stuff.
Variable scope question w/combo-box
VBA Function syntax
Find Empty Column and paste cell values
Worksheet_Change problem
Reversing Words
Buttons
Excel macros
counting spaces in a string
Help saving a select to a text file
Chart.Export creates zero byte GIF and hangs on server
Using Property Let with a Type as member of a Class
resizing columns with pixels
Cell Date/Time and NumberFormat issue
Equivalent of Match Functn in VBA
Substacting two military times
On Edit activation
Changing Cell Colour
Query - Where is it???
VBA & XLL - function shadowing.
Office 2000: excel to access automation and parameters
I need to compare 2 separate lists
Excel Parameters???
How to make opening of workbook conditional of opening of another workbook
Logarithmic Chart in VBA
Excel freezing when zoom active and on dual-monitors.
Way to change a single line of vb code in several hundred excel files?
Updating Cells that Get Value from Macro
Programming Excel -The most efficient way
Sharing Macros in Excel
Protect Statement
Importing text file into an existing excel workbook.
Find last row can't find anything...
Problem with SolverAdd. Can anyone help?
secure an excel spreadsheet
Problem implementing SolverAdd - Can anyone solve?
insert a row according a condition
Help with excel!
problems closing workbook
controls and macros
Way to change a single line of vb code in several hundred excel files?
Help Please
Help please to match data in a range, get the next column's value.
Temp File
Replacing links with values
Pivot Output formatting.
Cell address to Points
1004 Method 'COMAddIns' of object '_Application' failed
Excel 2000 replacement for Response.Write
Variable Not Defined? objPivotCache
Save only new or changed cells
sort an array
rounding of numbers in vba
referencing a control
a little help? OLE object, which version of app?
Importing text to excell without especifying path
separate copy of excel
Word/XL Mail Merge, 2000
testing for blank
Can anyone help!?!?!?
Variables in a Range statement
1004 method 'COMAddIns' of object '_Application' failed
calculating balance w/interest
Naming a range
Excel Formula - Error 1004 - Bug? Mistake?
Insert range function and CopyOrigin
Weeknum Add In doesn't load when launching Excel
Embedded Objects in Excel
Calendar Control 9.0
Random numbers
vba variable problem
Using Microsoft Web Components In VB
Filtering
Printer name from handle
Problem with process Excel
autodestruction
ActiveSheet.Next.Select not working!
how to call a macro from a worksheet event?
inserting rows with formulas
arrays
MISSING: OCWebPreview ActiveX Control Module
saving new file name
Excel Pivot table Events
Excel 2003 prompts for the password when I am not opening the stated file.
Using result of user input?
Help Please !!!
Recursion with user defined functions
Coverting a VBA array from 2-D to 1-D
Check for number
Merry Christmas and thanks for your help during the year.
international problem, decimal separator and chart series
Data Records Take Up Two Rows.
Triggering an Excel macro on press of SAVE
Need help ....
For....Next- Array of worksheets.
Run macro on all worksheets within workbook
Simplifying code using array
Inserting rows before page break
Unable to add a hyperlink to a custom CammandBarButton
Strange problem saving add-in
Secure Workbook
LastName, FirstName format
I want Cell content as Autofilter criteria
Format Textbox as %
automation error kills excel
How can I CHANGE VALUE IN A CELL IN A HIDDEN WORKSHEET?
Dropping Data to a VB.net Program
ComboBox Items
Pivot Table Question
Macro no longer works in XP
Macro no longer works now that in Excel XP
I Can Not Use Data Groups In Protected Sheets?
additem listbox
Drop Down Information
Summarising figures - can anyone help please
Identify and move duplicate rows?
freeze panes...perhaps in microsoft script editor
Value padding in VBA
Copy and Paste Macro Help please....
Deleting rows A to E when finding dublicated Data in Column B
range selection
Compile error distMon
Combo Box for navigating in a worksheet
blank columns
Formatting font with concantenated string
Delete key causes error in Worksheet_Change in 2003
VBA source code
HELP!!!! Can't stop a loop (NOT an infinite loop)
month according to numbers
excel vba array basic operations
hyperlink made easy???
Delete empty rows
Search number in a string (excel vba)
Updating database from excel sheet with macro
code for showing userform on cell selection
Combo Boxes
Help Design a Medical Practice Spreadsheet
Need help with looping through a dynamic range
Variable in Range statement
One-D Array to Column Problem
Quickly search for and delete entire row if certain character is found
How to open a specific MS office file using button in Access?
Worksheet_Change & Undo
Custom userforms
Deleting conditional formats based on condition
The Tricky Blank CodeName Property & Excel 2002
Creating a copy of a worksheet II (Just 2 more things please...)
special cell selection
Applying formulae
Newbie help please
Opening a saved file
Format Conversions
How to create Specific date in macro code
Userform Validation
Application.WorksheetFunction.MMult
Combo Box
Combining workbooks into one?????
VBA Code
Conditional Formatting
How to make a Password login screen in excel
vba code for lookup worksheet function
Union only works for sometimes.
Dimensioning Arrays
pivot table destination
Excel 2000 microsoft development environment
Code to Show All Pivot Table Items
date formatting
VBA: Select Excel's Worksheet using wildcard
inserting a character amongst characters in a cell.
Long time to load
Add a form onto a macro - Need help ASAP
Page Header from a cell in bold
Exporting images
Userforms and Spredasheets
Possible form help needed
Function: Join Cells with Format
Save Macro Question
Save File with multiple cells values as it's name
Auto Open question
Format
to kevin RE CloseSwitch
Format Conditions
Deleting Files in Folder
spreadsheet on userform
Deleting/Adding/Changing values based on ComboBox1 Value
Excel messages
today code in vba
Coloring a row a different color upon completing a cell
creating pdf files with macro
Deleting Whole Rows From ListBox2
getting error
Creating a copy of a worksheet
Inputbox - display text as asterisk
Disable call for Addin
Userform using 3 ranges to populate.
displaying filtered data on another sheet (Excel2000)
Userform Formula Help Needed
Like operator as a worksheet-function
Getting a number from a textbox to use in a vb formula
Re: reference sheets
reference sheets
Deleting rows based on criteria
Memory corruption?
Input Value to Multiple Cells
restricting access to workbook
Tab Code
Listbox for navigation
Shape Size in Cell
Search two sheets simultaneously
HOW can I add a PASSWORD entry box to my Excel app using VBA?
Microsoft Query - how to reference a cell value in a filter
HELP - Need to prevent others from viewing my MACRO LIST - How do I do this?
autonumbering in excel..
Wildcard character with Select Statement
Finding ranges in an array, cut and paste also.
Hiding and protecting sheet without crashing Excel!
if statement
How do I reference Current Cell when cell isn't the Activecell
Change code to make worksheets instead of workbooks
Passing Parameters to Userdefined Functions
Dont know how?
Changing the name of a referenced file
Saving to same directory
Need code - new user
Form
Excel/VBA question: Link ChartTitle at run-time, anyone?
Converting mulitlingual .xls using solver.xla
Help using Network DDE in Excel
cells.find...
Cell question
Selecting cells
Userform and Text Box
Automation from .pdb to excel and then to access
Count unique visible records
Save As "Error" Searching for idmxl8.xla Add In
RE: Open Access DB in Excel with Command Button
Listing files within a folder
Automation
Formatting equation output
Custom Toolbar
compile error in hidden module
Excel scatter plot
Automation
Excel 2000: maximise a sizeable form?
2 Qs: grab net page, and import as fixed length format
Changing the height of a commandbar control (edit box) at runtime
Macro Dispaly Box
identification of cell that exceed certain number of characters
Numbers Only
Range Acting Lke Control?
Tools/Options/ Row & column headers
What is wrong??
Dimension problem
I am new to VBA and am stuck
Detect MsgBox keyUp
Problems with "addin administration"
VBA Detection of Workbook already Open
Setting bkcolor on active cell when left mouse doubleclikked
addin problem: sheet mismatch by function parameters
Custom Menu
open database
how to disable saving???
Multiline textbox.. Can you have multiple font colors within?
Split fullname into Drive, Path and Filename
Re: Open Access DB in Excel with Command Button
Visual Basic query!!!
txtbox code
Trapping an open Workbook
pivot and vba !!!
Multiple Source Worksheets
Grouping rows and columns on a protected worksheet
Status Message User Form in Excel '97
vba and ocx
Re: Open Access DB in Excel with Command Button
Do I need an MP3 License?
MSForms.TextBox Exit event isn't available in Excel class mosule
Meaning of simple code
X axis labels from a Data Source...
Groups and Protection
3 VBA Conditions(last edit)
Locating first cell that has a number in it
Excel ODBC Query
Creating Sub CommandButton1_Clk programmatically
Code Edit
How do I use RecordNavigationControl
Excel Single Instance
Special Ranges of Cells
How to create a dynamic Userform via VBA
Where is the complete Object Model
Past directly into TextBox on UserForm
Conditional formatting using VB
Problem with UDF
Urgent help!!!! VBA
removing and replacing toolbars
Re: What is the VBA equivilate to Excel worksheet function lookup
Using Excel WorksheetFunction.Mode function in Access VBA
Re: How do I Delete Lines from VBA Array?
Pivot Table Question
Re: Range().Select Not Working
Conditional value code
Auto filter macro
Inputbox question
Thanks
Having trouble posting messages
Select column two
ASCII 133 -- Accented A or Ellipse
Dividing data into worksheets by column values
Grouping OptionButtons post-creation
Code
VBA Code -- Cleaning Data
Identifying cell from which a call is made
Worksheet_Change and comment in a cell
.ScreenUpdating Problem?
Store Hidden Data in the Cell
Security setting of low ignored for macros
Simple copy rows with certain value to new sheet
Design Input, please
Add a dynamic date to a header or footer
Help with some code to insert rows
Microsoft Visual Basic Editor and Mouse Scroll
Code works in XL2000 but not in XP!?
Stopping event during opening and saving
Emailing Excel Sheet As Attachment
Extracting Sheet Name
Remove VBA Project module
Calling ApplyCustomType for Excel 2002 in C#
Excel 2000 VBA ActiveWorkbook.FullName
Querying a database for values in each row
3 columns and one line chart
referencing filtered cells
Capturing the Update Links Property
Using a VMA for a reminder?
Using a variable name as part of a file pathname to open many files
Month Calculation
tab through certain cells only
All good except...
object by variable name
Page Header
setting tab name for worksheet
Difficult Pivot Table Technical Question
Using Input Box results in a formula
accessing data on a web site
Several versions of Excel on same PC / same user?
I need to change the BG color of a cell dynamically
Open file in the application that created it
Array question
Macro to Create PDF from excel with filename...
VBA & Acrobat 6.0
saving a file
Changing the vlookup cell
Using ADODB to read data out of another excel file
Still have formula prob :o(
Function Error
AskToUpdateLinks
Getting around Initials popup screen
Date Format Help
more help with a hide macro
Problems with xl97 & xl2K
pivot table
Summary...Number of shts varies
Errors with #import "Excel9.olb"
synchronize worksheet in a workbook
Disable Macros Automatically
scrolling to a specific cell
Auto Load
Re: formula problem
Sort issue
Find first and last cells in column that have a certain fill color
Find first and last cells in column that have a certain fill color
copy and paste loop
turning off minimize, maximize & close
ActivityLog - UserStatus
Looping
Navigating a filtered list
help on charts
Linking powerpoint to Excel
Block deleting all zeros at once.
Revealing formulas
Return Range in VB
VBA send mail with groupwise
Summing in Macros
Help with CSV format
Excel
Permission problem when opening excel file from ASP
Error if can't find text
Offset
Naming
Need a "GetFolder method"
VBE Menu Bar Visible But Not Functional
Creating Pivot Table with VBA
Numeric Text Boxes
Addin problem
Inserting Pictures from Access OLE Object field
checkboxes
Problem copying from one workbook to anoth
Quiz.xls
Excel 2003: custom function with dotnet
How do I pass a worksheets name to function?
Writing to Excel using ASP.NET
Creating recordsets based on a range
Call Excel from VC++ Win32 DLL
command to return the row number or cell number in excel?
Using text files
Max-function with alphanumeric values?!?
Find Whole Word Only
Free books on Charting, Basics, Data Management, Functions; Free Add-In "Excel Usability Enhancer"
function doesn't work
How can I add a PASSWORD entry box to my EXCEL app using VBA
why error for activate method
Dropdown list
Insert Details from ListBox onto a NewWorkbook
formatting date
How to distribute custom toolbar updates?
How do I hide an Excel MENU item?
Creating worksheets from another worksheet
Calendar question
How to move to the next filtered row/col in VBA?
How to make the Toolbar Invisible through VBA
Month
Magnify dropdown list
Web Query general question
How to lock the path to a macro
macro to import data from mysql
Overflow in VBA, but value < limit
Function Add-in troubleshooting-Vlookup
Cell formats
Get rid of empty rows
onTime loop running in the background
Is there a "Non-Intersect" VBA method to remove a sub-range from a range?
OpenText very slow
Can a named range be protected???
Get file size
Calling Sub(s) from ThisWorkbook
passing variables from an excel macro to a powerpoint macro
Creating a Hide Macro
A problem in VB
VBA code that only runs when a worksheet is active
Control or VBA programming a button
Memory problem
Calling a .Net Procedure from a Macro
How to change color of buttons if pressed?
Method 'Range' of object '_Global' failed
Selecting used part of a range
Saving
three types of comboboxes.
different screen resolutions
listbox scrolling with mouse
Re: A 2 fold macro question. *(I need some MVP help on this one.)
Task Scheduler
open utf-8 csv in excel
Summing with Macro
Excel contents to Outlook email
To sort data in VBA/excel by the method of the minimas
Tabels and calculation methods
Extra rows with no data
HOW-TO? Loop through cells in a column
Opposite of CONCATENATE
Help with Formula
Closing Workbook without Saving
AutoFilter
Assign Active Cell Value
Opening properties box
the file already exists - do you want to replace the existing file?
Moving a range between sheets
Copy and Find
Arrays
Excel hangs on Workbooks.Open Line
User Forms and Pivot Tables
Prompted to save changes after macro save - why?
Insert rows depending on entry in certain column
SendKeys {HOME} not working
Help Please!, Retrieving E-Mail
"Split Unioned Ranges"
Can't find a macro
Automatically run VB code on workbook save event
Excel Form
Excel User Form problem
Sub Run-time error
Auto invoke of a VBA Sub function
Create master sheet RETAIN formats
What is VB_Invoke_Func attribute?
select only certain characters from a cell.
count how many characters in a cell?
Automatically copy select rows to different page?
Excel Project
AppActivate trouble...
How preserve the value of NOW() or TODAY()?
current date formula ?
Opening text file in Excel
worksheet change event
Locate max value cell
Loops
Using Rows().Delete
Using vlookup in VBA
Identify link location
Has the Page Setup Leak been Fixed in the Newest Version of Excel?
Help on Excel VBA macro
Adding Data to Next Available Line
Visual Basic macro to do something that is done trhough an Excel function
Re calculate
How to Exit Excel Automatically
Paste into textbox
Create text pop-up in VBA function
can you..
Crash working with Excel 2000
Number of Lines in a Worksheet Function?
SQL Database
Formating a Picture
Worksheet Protection - Help!
delimited data in column
Copy results and then remove formula
How To: Get the index value of the selected color
Tom Ogilvy:Object Error Still
Re: A 2 fold macro question. *(I need some MVP help on this one.)
Years and Weeks
How to obtain multiple quantities from an Excel VB function?
displaying entries once
Unusual question
How to run subtotal function from ASP?
Making code more efficient
Unknown Error Message
Change Input language
Formatting a header with VBA
HELP WITH FORMULA
publishing html using excel - problem with files becoming corrupt
how to run through a table an delete the empty cells?
force a line break in a comment
Anyone know how to do an EXCEL Script - details inside
How do I change the datatype of a cell?
From Cell to InputBox
prevent recalculation of random data except in a "Calculate" macro
Access to Worksheet in AddIn.xla
Exporting Excel Comments in to Access tables
Minimum Cell Value
Compare Ranges by Address
Search/Replace in Comments in Excel
Get folders list
Running worksheet function in VBA
Icon
Excel macro
Problem with Pivot table reports
Saving workbook from vba
RefEdit
Counting number of grouped/outlined rows
getopenfilename in access
Add Text to Column Contents
Unix Directory/File Listing
Hibernate using Excel macro
Excel not visible in c#
How can I make a sound alert using macro in Excel! (But not use speaker)
building a text string while looping though a worksheet
xy scatter graph - add points to series
moving rows based on criteria
How to verify specific Worksheets are present
IF function with multiple string conditions (Excel 2000)
Formatting for Numbers & Currency in textbox
Excel VBA worksheet will not run different computer.
Appending records from one table to another
How does one link data? Sort different columns?
MOre excel 4 macro problems
dates on forms
cut & paste between sheets based on cell data
Rollup of Data in Multiple Sheets (based on user input)
Object Library References
Building Custom AutoComplete
Deleting lines with no data
Excel 4 macro
Re: Subscript out of range error
Import from one excel worksheet into another
How to assign directory for GetOpenFilename method
trying to search excel from Outlook... NO Results
Closing the Userform when macro is running
FileSearch for a TextorProperty with a wildcard
Excel in IE - opening new window
Making code accessible to many buttons
what object group does this reside in
Help with calculation
How to find the type of Sheet in Excel.Workbook.sheets collection
deselecting a highlighted range after a VBA copy procedure
If..then..Lookup?
Re: Multi Column Combo Box
Object Library References
Printing displayed sheets
"Disable Macros"
For loop...
Re: Multi Column Combo Box
Find range by interior color
Set properties in an XLS file..
rearrange an array in a different order
How to do selection.subtotal in VBScript/ASP ?
Calling .Move() From Javascript
variant array containing cel adresses > convert to actual ranges-array
excel print dialog
run a macro from a cell reference
Referencing Cells in VB
Selection.ShapeRange.IncrementLeft error
Locking only certain cells
Selection.ShapeRange.IncrementLeft error
Determine if there's data in embedded word document
I can't quite get the syntax for printing to the manual feed tray
Inserting a shared list from code
Help modifying code
Trouble getting solver to load a model
how do I make a simple macro
General Text Search and Highlight
Newbie question on cell reference 2
Sharing Excel File on Network - Saving
SendMail
Dynamic Control Creation in VBA
If Checked Box true???
J++ to J# upgrade of _IDTExtensibility2 Addin
Newbie help with cell reference
FileSearch macro returning incorrect docs?
a few simple newbies questions
Deleting records from access using ADO in through Excel
Import txt file
Interrupting an add line
On change event
listbox1.additem syntax for multiple columns
Multi-column ListBox. Multiple bound columns???
Cond. Format Formulas
Referencing a ComboBox control from a Workbook Object?
Identify if another user has spreadsheet open - in VBA
Lehman formula
Microsoft word
unprotecting workbook
editing control/form objects on a worksheet
Dr. Watson ordinal44 error
Last, First Name Swap
Adding Toolbar at startup
Printing
Excel Event Problem
RefEdit doesn't work properly
Macro Questions
Can't call up floating macro toolbar-stop recording/relative ref.
combine an IF and SUM
size of a chart sheet
CHANGE PROTECTED CELL VIA MACRO
HELP!! Populate text in single XL field, or bulk copy text into 1 field
Named arguments for built in dialogs
Object not defined
Mail for the postings
Illustrated list of Toolbar buttons
Macros i XL 2003 versus 2000 - speed problems
HELP: VBA help file
Need Help in importing text file
How To: Command Bar Face ID property
security change possible in VBA?
MS Excel "path" and XP/NTFS folder naming
Excel - special sort
deleting sheet: how to omit warning
ODBC Links in Excel XP
unable to set the OnAction Property of the Text Box
Transfer of data from excel to access
Complete Excel App? Advantages?
Workbook on intranet unexpected behaviour
Dynamic Range Naming
C. F. Formulas Needed
emailing from excel
Auto-update of formula results
OnChange - argh! How do I get this to work please?
Buttons in Toolbars
@ symbol
XLS file-format
Experts kindly help
Userform array/subsript range error
multi-select drop down list
A Pivot table issue
Where do I find the listing of the differnt methods, properties etc used by VBA?
I want a help Please
Condition Statement
Changing cell format with VBA?
How to attach commandbars with VBA
Hide rows?
Please need HELP - Need to add and INPUT BOX so that users need to enter a PASSWORD to use a workbook
Task Pane Doesn't Close
Excel Workbook Security
Function layout
extract data
How to Use Financial Function "ACCRINT" in VBA
direct to certain cells using drop down list
Bound column does not work after hiding form
Excel Network chatroom - testers needed
Finding and moving hypens from end to beginning of cell
retrieving table names from Excel and Access sources using ADO
Selecting columns
jumping to a cell which matches user specified text
Section 508 accessibility and Excel
Changing cell color
Evaluating a cell
Increaseing the number of aurguments in a function
ado
Hours spread uniformally between two dates
BackColor property code
Save sheet as .TXT out of Workbook
Macro that adds then deletes
J++ to J# upgrade of _IDTExtensibility2 Addin
Single Step Dialog Box
Error message after installing Office SR2
Programmaticallly fixing references
Formating cells to only accept ShortDate format
Sizing Comments
Accessing combobox/listbox values
Run a Word Macro from Excel
Text manipulation
free up memory by deleting variables
exporting excel to text with : delmited
Publish Macro
Custom cell format
Excel thru Terminal Server
(xlDown) not working properly!
How do I retrieve data from an Oracle db?
Excel 2000 drillthrough - How?
Practice Files
Add % sign to numbers
(xlDown) not working properly!
Catching an error
Retrieving data from Oracle
how automaticly print excel sheet.
Most popular word
Simple (?) Formula Problem
Importing Multiple lines of text in a single Excel Cel
leap-year condition
FindMethod-DateValues
Split large sheet into several smaller sheets for emailing
polygon.net web query help
current cell in user-defined function
Displaying worksheets
Problem with cells.Find within a loop
Help with my first macro please
Iterate through files in a folder on Hard Drive
how to rename sht after TransferSpreadsheet method?
Type mismatch? string 2 a long??
Repost: How to calc string's printable width?
Possible? -- RAND()
stupid textbox
Excel Addin and Delegates in C#
Execel sum up
How to get screen size ?
Menu Editor /Windows Menu
Call Excel from VC++ Win32 DLL
Variable-Length String causing error
VSTO 2.0
How to Show a userform from XLA sub
Re: Comments autofit
Remove Excel AddIn from AddIn List !! Help
Comments autofit
Extract All worksheet names in workbook
two column combo box Excel 97
Shared Workbook: Conflicts
Copying data ranges in a macro
Formula from VBA to Excel worksheet
Leap Year
Application.Inputbox Question
Sending Excel file as attachment to Lotus Notes mail
Exporting Excel output to pdf/rtf/doc format
Search across multiple sheets and subtotal.
Excel Web Query Function
Automatic email from Excel through Lotus.
Application Hangs Up Computer During Opening
OLE Automation
Userform and reading multiple listboxes
Adding/Deleting from toolbars using VBA
'find' in directory
Looping through Ranges of Rows
How to get cell in a certain place
Validate Excel Range with RegEx
Web-based (preferably free) VBA Excel tutorials
Sort one column and entire rows get sorted
Excel Addin and Delegates in C#
Spreadsheet 'Tours'
When workbook is closed tries to reopen??
Looping through Ranges of Rows
How To Copy a Sheet to Another workbook
How To Copy a Sheet to Another workbook
Sending data as POST request to a Webserver via VBA
How to create a PASSWORD ENTRY BOX at startup of Excel Application
Re : Making use of the Built-in Dialog Boxes
excel - ListBox multiple Select
Problem with the Excel 10.0 Object Library
Create and show UserForm from Add-In
Excel XP Macro Loading Problem
Excel sheets saved as XML files that can be read by .NET
OLE picture refresh?
conditional colors in stacked bar chart
function or call macro
Sending mail from excel with CDO
Lost Menu Bar
Bringing info from userform to spreadsheet
How to make paste FaceID disappear after API paste?
listbox will not refresh
macro how too?
Time stamping - automated by worksheet update
Personal.xls Macros
Listbox ColumnHeads
How can I convert text to all lowercase?
Functions not executing in Excel 2000
Bad Office CD -- how do I get a replacement.
formula?
Protecting Add-In's from viewing
VBA Training course?
message box/question box in a formula
Printing selected pages
Opening Excel with a stream
Copying calculated values
Point Me. Searching strings for lists of keywords
Return ActiveX properties by means of a variable???
Blinking Text
Re: Excel XP Macro Loading Problem
Accessing Addin from Sheet_Event Code
Widen Data Validation Dropdown
Accessing Addin from Sheet_Event Code
find cell with value greater than my number
deleting text is easy... but what about this?!!!
ComboBox Question
Question about Protecting a Workbook
Statistics, Charts and VBA
Delete all special characters in a selection?
Getting data from Pivot Table
move '-' from back to front???
Simple Questions
List out FileNames.xls with K4 Blank
creating a checkbox control on a user form using VBA
Auto_Open vs Open and call macro --priority question
List Box format
Address
CountIf for two columns
listing which documents were changed by macro
Need help with combobox output
File won't close when "beforeclose" event is used.
Conditional Data formats
Trying to select values in a column with blanks
Floating Cell Total
Disable/Enable Macros through code
Identifying and locating linking cells!
myaddin tutorial
How to calculate cell's contents printable width?
Strange problem with filesearch...help
Running Excel from a Server
Modify code from one macro to another...any takers?
Disable the right mouse button??
Cut & Paste Data into different worksheet based on specific criteria
Validation List with Variable Lengths & Invisible Empty Cells
Printing multiple worksheets only if data exists
Forms
Select a value from a combobox drop down list through code
Blinking Text?
Paste values
Accessing the clipboard after copyface
Help with Validation Tables
Limiting tables in Excel query
VBA Query coding in Ms Excel for Mac OS 9 (ping Jim)
Dialogframe
Color every 'nth' row?
public declaration
Charts on a User Form
Delete all blank worksheets?
Mmm tricky- but i'm sure someone out there can help!
Applying formulae to cells???
Help with setting up an Ordering system, please
Code runs different in a commandbutton than a macro why?
print sheets
Time to output in seconds,00
Export Excel to Word
looking for html to pull series of urls
times
Floating List Box
is it possible to CLICK & insert date
Checking if workbook is open
Application.Calculation
Validation list using code
inputbox help
FindNext problem when using PasteSpecial
Shared Workbooks
Add pictures to UserForm at runtime
Visibilise toolbars/menus based on active sheet
Listbox on custom toolbar?
Updating a Function's Result
Object variables
Hide workbook
populate listbox
Creating Folders from Excel Using OLE Automation
Sample Array
Excel Driver
CUT and COPY?
Printing hidden sheets
Help with locking Cells
own-made FaceID 's or command buttons in menu bar
Unsaved file as E-mail attachment
Importing texsts files
Accessing pixels in bitmaps + retreiving from registry
Trapping Excel Close Event
Can anyone help with input boxes?
need to set a cell background color which is not within the Excel colorindex range
Time.
vba - How to opening a file (*.doc *.xls)
Macro to nsert value from table, then next value, till done
Simple VBA - What's wrong??
VBA cheat sheet?
Shared Workbooks
Selection method not available in VB when referencing Excel worksheet
Creating Shape at runtime
Calendar Control & Office XP SP2
complex column sorting
How do you list all the workbooks you have opened and the sheets in each workbook?
Auto_open or On_open
Creating a function
Counting Instances of a Value?
Help with data importing from txt file to excel programmatically
Need some help with in coding!!!! text file importing
vba- go to top of page
Deleting rows filled with 0
Repeating macro
Re: Top Ten List
Help with some code please
Image resizing DLL
Way to prevent VLOOKUP from verifying remote file exists?
Range as argument in function
Run a macro when new selection in listbox
Object defined error
Inserting records from Excel directly into a SQL database
Date Formating using VB Vlookup
Web Querying from excel.
Problem with PrintArea property
Excel XP Macro Loading Problem
Copy value in formula
CODE to select range based on User Input or Value of Input Field
Excel to Access - ADO?
Why 2 macros differ so much in speed?
Excel Copy
Word Scramble
Reading the Registry - CSV Download Flag
Copying data across 2 xcel files
Matching cell
Is there a TimeDiff function?
How to select entire column using VBA
vba-showalldata
Complex Conditional Formatting
Opening a new mail dialog box in Excel using vba
After Enter in a cell
excel shuts down when text is changed in cell
Macro shortcut key
Random numbers
Unable to set the Chart type to XY Plotter
Add values of textboxes together
Copy data
problem with code
Follow Then Thread (Sewing 101?)
Multiple Web Queries
Exporting subset of rows to multiple files
function calls
Random Numbers
Validation...
Add Names
add in failure
Random number
macro to pick data
Start up files
Creating a Named Range using VB
Excel VBA
Exporting Access data to different worksheets on the same workbook
How do I add a vertical spacer bar in toolbar
Excel programming not using COM
Detecting Worksheet Activity
Tricky Transpose
Index of Minimum value in array
Calling Subroutines/User Functions from Macros
PageSetup is slow
Run Time control events
VB numpty
find worksheet by FindMethod