Excel Programming [Archive] - Page 172

microsoft excell programming
Looking for Solutions
can the VBIDE have its own macros?
connect to an oracle server
How to get the time stamp in VBA for EXCEL
Re: How to extend user options
Re: Opening files
"Member Not Found" Error with Excel 2000
Formula with an ActiveCell
excel from the web
Re: Multiple array problem...pls help?
UPPER CASE
sum partnumber quantities
data feed
data feed
Custom Cell Validation
Appending linked worksheets to new records.
Re: PasteSpecial:VBA vs right click
Really tricky excel problem
click
Including control toolbox objects in tab order
Error Accessing the OLE Registry
string concatenation
put path in as variable
Copy text from one cell to another
Columns
Adress of Copied Range
Re: Opening files
Re: Filesearch Runny Like a Wiped Dog Phenomenon
RTF String
vlookup color problem
Re: Code not working
cell reference
Re: Fixing table array in vlookup?
Determined to eliminate .select
worksheet background
Re: help automated delete without question
Excel crashing when (programatically) adding past the 360th worksheet to a workbook
Shell Statement
populate concatenate field
Code to maintain formatting
Merging 3 Columns in an Excel Spreadsheet (Keeping Data Intact)...?
save as
where is it stored-customized changes in excel97
Print all worksheets from same tray
Re: Established spreadsheet shows err for errors for div/0
Opening a webpage from a vba macro in excel
Re: VBA Error Automation error.
Command line parameters to Excel
Re: Opening files
merging drop-downs
Running Excel Macro from VB6
Re: Putting the Subject field in SendMail
Migrate a Excel Spreadsheet
Putting the Subject field in SendMail
Re: Tricky Excel Problem
Re: Limit character input
Re: Sorting columns with macros
Conditional Formatting question
If match then copy.. beginner in VBA
print embedded active chart programmatically
Sorting columns with macros
Re: Established spreadsheet shows err for errors for div/0
Description of Listview and Treeview Controls
Printing textbox text
Re: Established spreadsheet shows err for errors for div/0
specialcells and toolbox button click event
Cannot open a file
clearing non-numeric data
Error while closing Excel
Help ... can't find newsgroup
Re: Worksheet equivalent of VBA Union?
workbooks.open issue
Excel ADO.Net Hell :S
password
Select from Columns
Easy one: Remembering previous sheet name
deleting/overwriting an excelfile
Re: Printing of non-sequential pages
XLStart folder content deleted when upgrading to XP
Hidden Combo Box
Re: font size on formatconditions
VB Excel AddIn distributing
Cannot select object to assign/edit macro
Re: Printing of non-sequential pages
Accidental Delete of Menu Item Helllllp!
Consolidating module code
Re: Macros in Excel - Save as and rename file
Re: File Formats
Re: Newbie stuck on Passing a Variable into a Range
Re: Diplaying Excel Application through Object Model
Calenders in Excel?
Re: self installing macro
Transporting a toolbar within a spreadsheet
Error Excel: 1004 SaveAs method of Workbook class failed
Changing Default Setting for Number of Columns
Password to view VB code for Village software.xlt
how to prevent user to interrupt macro
Re: Macros in Excel - Save as and rename file
Excel data entry: choice of control for selection
removing selection focus in listbox
Data Validation Again
Warn for an Empty Record
Re: Newbie stuck on Passing a Variable into a Range
macro
Re: File Formats
Listbox
Subscript out of range error
Re: Macro: How to avoid cell value editing ?
Auto-starting a User Form
Re: Textbox limitations?
no scrolling after an autofilter off following a custom view
Shapes with boundaries tied to chart data points
Validation rules changed upon condition
Printing
Re: Newbie stuck on Passing a Variable into a Range
Re: API's and Mouseclick
Re: Newbie stuck on Passing a Variable into a Range
VBA Problems
Re: Passing a parameter to Excel
Using Relative Addresses to Select Columns
Re: second character from the right
#N/A
Array functions
Re: Resizing Ranges
Re: assigning macros to several custom buttons
Re: Simple Array question
Re: Simple Array question
Macro security settings
Worksheet_Change
Re: Loop worked but is it inefficient?
Re: automated delete without question
Re: help: automated delete without question
Re: Move or Copy file
Filling a ComoboBox with Values on a different Worksheet
Excel macro help??
corrected formulas
Referencing Cells Based on a Calculated Value for the Cell-ID
Please debug this one formula in VB
Using a checkbox to trigger an email
Best way to refresh data from an external file
Re: Move or Copy file
Re: Move or Copy file
"Can't shift excess data off page"???
ADO Open command fails on multiple SQL functions
Re: Loop worked but is it inefficient?
Re: macro to delete empty cells
What is a .vbp file
Macro to delete columns
Circular reference
Re: How reassign toolbar button ??
Re: Deleteing Blank Rows
Re: Changing letter color in Excell
Re: How reassign toolbar button ??
Mouse Wheel Trouble in Excel VBA
Weird template/macro behavior ??
Enabling/Disabling Macros
Re: Deleteing Blank Rows
Re: pull down menu on userform
Re: Weird template/macro behavior ??
Re: Userform1 Border
Re: Userform1 Border
Class Modules
Delete rows from sheet
sheet protection problem
Retrieving a cell value with a SQL statement
Re: Why are non-programming q's answered?
IF entire range blank THEN ...
passing spreadsheet cell data to macro
Add Hyperlink to newly added worksheet?
Memory/Font problem
Re: Max function between dates
appactivate sendkeys not working with accelerator
Max function between dates
delete row?
Automatically remove &[Date]
Re: Tricky Excel Problem
Sending Excel sheet by Lotus Notes
comparing sheets
Re: Tricky Excel Problem
Displaying code and spreadsheet at the same time
Print Area Question
Lots of single clickable cells
Opening CSV files with VBA/macro
Change keyboard Regional setting
Data Validation to check Dynamic range in another sheet
fomatting the display of a cell without using the format menu
how to set excel pagebreak in programm
Updating remote references.
Default Application.caption
Select from/filter
Animation
animation
Re: Next cell in a range, by row not column?
Chain Printing
how to place a variable cell into a range?
Date format problem
combobox
ListFillRange
Re: Add-In problem under new SOE
create recordset from csv file on web
Varient Int data type mismatch
Re: Search for a value in a column
How To Count Rows Displayed After Applying AutoFilter
(Simple) VBA Question
Where do macros go?
Opening and saving a template ?
Re: Format column heading cells in template?
Re: Changing Query Source Location?
Memory could not ne "writtem" problem.
using excel macro to activate word document
Insert Records from Excel Into MS SQL Server
followhyperlink event for textboxs
Can I save conditional formatting in template?
Retrieving the Top 10 Average Entries by displaying a third column
Re: Calling certain functions within VBA
Re: API to prevent closing Excel
Save macro in template ?
Re: Cut a column in one line of VBA
ListFillRange
missing items in sheet's activex list/combobox after resizing range
Re: Calling certain functions within VBA
Calling certain functions within VBA
resize method
External Data
How can I detect an AutoFilter when the Criteria isnt Met
Re: Stopping Excel from converting copied text data!
Opening and closing text files
Re: Sum previous cell? Insert line....
open a new word document out of excel
adding subtracting angles/degrees
Barcode Code 128 checksum
Visual Basic 6.3
Re: Changing letter color in Excell
Re: Changing letter color in Excell
Re: Cut a column in one line of VBA
Newbie help...VBA w/ Excel
Re: Cut a column in one line of VBA
Re: Cut a column in one line of VBA
Re: unhiding columns problem
Re: Page Breaks
Excel application: Summing several terms (some constant, some variable)
Inactive close
Code for msg box
Re: Possibility of counting line in textbox??
"Dragging Chart Markers to Change Data" Event
Re: Can a variable workbook be embedded into an Excel funtion?
Problem finding vbModal on users PC
Re: Can a variable workbook be embedded into an Excel funtion?
Re: Macro security settings
Replace Data Source of a Chart
Re: Macro security settings
Opening a Worksheet from a template
Re: Count function
Re: Separation of VBA and Spreadsheet
Re: Count function
Re: Excel XP x Playing Sounds
Why?
Column Character
Re: Macro to filter sheet and copy to another
Re: Turning Off AutoFilter With Code
Re: Macro to filter sheet and copy to another
variable not equal to expression
Accessing a textbox on a sheet....
Identifying Page Breaks
Re: Sending an Outlook e-mail due to a condition in a cell
Deleting Rows from using a target cell
Re: Macro to delete duplicate/triplicate rows
Re: Macro to delete duplicate/triplicate rows
Re: Checkboxes
Array size
Count and List only WorkSheets named (anything)&"-pilot"
mail worksheet (multiple)
Wrong text in msgbox
Null and Nothing condition
Unprotect shet, Password missed!
Counting checkboxes
help needed
VBA
Sheet1 object not Worksheets("Sheet1")
Repost: Calendar Control: Ron De Bruin
how to? set my range= my UDF argument (range vs. value in range) [advanced?]
Re:Autofilter input
OOPS
Application error 1004.
Re: Make "Worksheet Menu Bar" invisible or Delete/hide it's buttons
Displaying different pages in MultiPage
Re: FileCopy
List item Based on Cell value
Find instruction fails (from foreign sheet)
Re: Exel2000 VBA - Creating a Command Bar - Error: "Object Variable or With not Set"
Re: Exception Error? What is it?
Range Sum Formula
Using code instead of worksheet functions
Hyperlink events
Matching Data in VB
userform
setting timeout for opening web files
Saving to a Network Path using VBA
Calender Control VB
Re: Delete unwanted rows
RecordCount problem
How to retrieve domain user name in macro
Repost: How do you identify a worksheet as last?
Re: locate max value in variable range
excel97: filtering out the zeros macro
How to declare Multi-dimensional dynamic array?
Adding hours and minutes together
Re: Slow Response time
compare books macro
how to make hint of help or comment of a self-made function.
undo in code
2 macros in a Togglebutton?
Macro that retains password.
Re: Printing more pages than necessary
Re: copy first row of a sheet to a new sheet in vba
Help with fitting text in textbox
drop down box in cell; autofill
Re: Printing more pages than necessary
Re: excel ??? could it be used to publish a program???
Re: Show/Hide a Secret Cell
Concatentate a formula with a variable sheet name.
Macro to Increment a Cell's Value By 1
Thanks Bob, but...
first blank i a column
Pages numerotation
Re: Payroll data
Loading MSComm.vbx into Excel VB
Labeling points in an X-Y scatter graph?
Challenging Formula in VB
Re: If Col is hidden then add data to a cell
VLookup Not Available in VBA?
Re: command line excel to run macros
MSCAL.ocx - > CITRIX Metaframe XP
Show/Hide a Secret Cell
Userform Date validation
Fill a combo box from a named area on a sheet
Re: From excel to outlook
Copying a Filtered Range from a Sheet in another Workbook
Re: Colour Button
Re: Data Validation
Office 2002 compatibility w. previous version
Re: money
Predetermine Worksheet to Start In
Pause a VBA Module
Changing objects on other Worksheets with Variables
Slow Response time
Single click event
After SaveAs events - are there any?
listrows property
test for "A" or "D"
Re: FTP in macro
VB opens with Excel
Re: Userforms
Naming File from a Cell
source code for copyright
External Data Questions
Usedrange
Re: Export Worksheet to Access
Stock Program
ADO slow recordset getrows
.OnAction - Multiple Calls
Re: Export Worksheet to Access
Re: Help with Card Program
Re: Macro ignors module code
Re: Macro ignors module code
Re: Macro ignors module code
Re: Macro ignors module code
Protecting code in module
Re: Alternative to using .Select for cursor movement.
Database Access, Security and Audit Trails in Excel
Initialize data in new row?
Help In MS Access
Re: numbering rows & autofilter
Copy Worksheet to another workbook, programatically?
Determine the position of a MsgBox
First day of the Month
Create a PivotTable from a VBA array?
Predict Y-values on new X-values based on other actual X and Y values?
Data Validation
Re: Over=protection - Can't even select a cell
Re: Over=protection - Can't even select a cell
Re: Work Order Template Numbering Macro
how to obtain the result of the formula in another cell
Linking to specific cells in a changing table. How to Index?
how to change the red corner of a cell with a comment
auto run a macro
CopyFromRecordset only pastes 1823 characters in a cell!?
Re: Data keeps getting corrupted.... URGENT HELP NEEDED!!!
Dir( ) Problem
Re: Data keeps getting corrupted.... URGENT HELP NEEDED!!!
Re: how to change the style of a cell with a comment .
Re: entering keystroke commands in a formula
compare books
Re: Auto fill based on cRows calculation
Re: Saving workbook sheets to individual excel files
Excel reading user defined fields in Outlook
Blank help window
Can't delete directory created by a macro ...
Re: Data keeps getting corrupted.... URGENT HELP NEEDED!!!
Changing Query source location?
If, then...
Event validating two ranges with dates
Re: xla-files
EXCEL - 97 and 2000 (Want to bring in data and check against a template..
Pivot table visibility
printing to a PDF file
Syntax - Add Range Name based on Selection
fonts ?
Re: countif is one way, any others?
Fill Macro
create macro
Re: Problems with Excel Com Addin
Visual Basic: Combobox Complications
Re: Is there a better method to achieve this?
Excel Programing Resources
VB in Excel is liitle bit different
SAP Business Explorer (BEx)
Search Mutiple Excel Sheets.
Cycle through all the available Fonts
web hyperlinks to excell worksheets
Macro that inserts rows and copy values
Activex combo box won't display values
Re: Inputing Data
Re: countif is one way, any others?
Optimizing in VB
Change figures to words
Excel Macro Warnings
Sheet tab date
Variable reference
Forms.Close
Cell Protected Error
Dumping the contents of a VBA array to a sheet
IF formula error
Re: Variable Declaration??
regsvr32
Re: weird focus problem
Re: weird focus problem
Excel 2000 VBA undefined function problem
Re: Too many rows in Pivot
Clearing cells
Help with worksheet consolidating
converting a spreadsheet to graphical representation
Code to print most (not all) pages within active workbook
Re: Designing a flexible reporting template
saving excel sheet from ASP update
Re: Removing Picture from Cell Command Bar
Re: Date Question
Sending a workbook with a message
Trouble with simple If and Else
Bracketed Range References
Compare Lists
Re: Too many rows in Pivot
Re: xla-files
i am puzzled how to change the red corner of a cell with comment
Re: Help with closing a UserForm
Re: Sum of Totals from a large amount of Info + colour presentation
Programatically adding worksheets to a spreadsheet
Re: Login Box
Removing Macro Virus Warnings Upon File Open
Verify a directory exists
Re: Change cell value immediately after a save
Re: Change cell value immediately after a save
'Object library not registered' in Excel97
Re: Userform reading a cell value
Re: Designing a flexible reporting template
Re: Sum of Totals from a large amount of Info + colour presentation
Re: Assign Macro to Command Botton
Repost: Worksheet Change Method (Bob Philips, Ron De Bruin)
Problem with working out the amount of quarters between two dates
Minimise Maximise Problem
help me!
call procedure
Randomly Select Cells
selecting rows
Create a calendar object in Excel Cell
Closing Excel error message from Access 2K
Use of integer variable for sizing of matrix
Re: Problem using UserForm in Macro
Re: Problem using UserForm in Macro
command button
Re: RoundUp Function
Copy/paste based on adjacent cell contents
Thank You, Bovey
Loop though all data in PivotItems in a Pivot Table
How Can I copy all value of the array into the range?
PivotTable: RefreshTime vs. ChangedTime
Empty custom toolbar
Empty custom toolbar
Re: REformatting PivotChart
Re: end of file marker in spreadsheet to .prn file
IE link to a sheet
Re: getting #value! when I figure I should be getting a diff value
Re: Year as text
Inserting time stamp onchange of any cell
Re: ListBox
How can I emulate MROUND in VBA
Refering to Cell's Name in Macro
I got an Excel Macro/Security question that is driving me nuts.....
VBA problem
open a word document in excel
Finding data in a Range / Returning Cell Location
Formula for VBA
Re: Printing in a Macro
Printing
Automated Naming of ranges...
How do you identify if a worksheet is in the last position in a Macro?
Need a formula for returning the value of the cell shading in a cell
FTP in vba macro
Built-in file dialog question
The Best and Simple Way????????
Why # appears on its own ?
Basic Userform Controlsource question
Adding data to end of range
Wildcard pattern matching and replace in string
Help for 'homemade' function
Macro import
Re: Visual basic to step through range and store a value based on text attribute value.
Re: Visual basic to step through range and store a value based on text attribute value.
Word Issues: Linking from Excel in VBA
Re: Newsreader settings
waiting
Re: Newsreader settings
SIMPLEST way to disable "close" button on form?
How best to extend user's options?
datetime in query
Tool-Options-Calculations
Re: subset of numbers
Imposter in Newsgroup
Baby Gates and Microsoft
Re: REPOST: How to handle errors
Counting the # of pivot tables within a work book and passing in as a variable
Re: Merge cells using macro
Re: Adding chart using a macro
hyperlink in email
Suppressing Msgbox during Testing
Re: Assign Macro to cell???
Re: Suppressing Msgbox during Testing
Is there anyway to restore a workbook?
Macro for selecting entire row from mouse cell selection
Re: Year as text
excel/website interaction PLEASE HELP!!
Apologies For No Subject. Chart Title via a Macro
What is the differance between cdate and ...
ActiveSheet.Protect UserinterfaceOnly:=true
Can't check ActiveX checkbox on worksheet
procedure too large
How would I do this.... Multiple IFs
Position of MsgBox
create new macro in new workbook
Registering function WITHOUT it appearing in the expression builder
adding columns to formula
On_Open color coding
Please help Frustrating VBA code writing problem
Inputing Data
Page Cut
Get columns as "A, B, C etc"
Fast Export
Excel 97 issues
Re: Help Please!
Problems with VBE - Please Help
COMPARE AND COPY
Year as text
CalculateFull in Excel 2002 (XP)
Copying contents of a listbox
VBA Control Checkbox
How to retrieve the directory of the currently open file?
Null statement
Checking valus in cells
Excel Addin Developers
Mysterious debug mode
pivot table xml
code for sorting
Worksheet_change Method
Update formulas
Re: .AxisTitle
Re: Get Month from date
Re: Hide Sheet
Re: Next Charachter
Get Month from date
Export Excel to SQL Server
Next Charachter
Re: Identify - Automatic links to information in another work book
Assign Macro to Command Button
Opening a ReadOnly file in Excel VBA
Annoying bug.
Re: Compare ranges for exactness
Limitations of a shared workbook
Page Setup
custom functions in formula bar
ODBC Link changing selection criteria
Re: Page Setup
Page set up from VB6
Message box
Re: Help Please Cut/Paste Macro for DVD Subtitles
Class doesn't support Automation...
Re: Populate Combo Box With Filtered List
How to add textbox/buttons to an UserForm
remove anything before period in column
how to vlookup returning a concatenation of 2 cells
Comdlg32.ocx
Datagrid ActiveX Control
Page Length
Change numeric value to words
How to distribute Control files (OCX) to users?
Naming a Cell
Re: Do you know this?
Re: Do you know this?
Microsoft_Sale ,Software,Hardware,Visual,Gaming
Microsoft_Sale ,Software,Hardware,Visual,Gaming
Re: Is there a way to remove a range from within another range?
Update links with automation VB.NET
Debra's sample code to hide a Pivotitem
Excel VBA To Control Access
timer conflict
cancel query refresh - vb
Re: Formulas in VBA
Re: Graph problem with VBA script
Import multiple files macro can't find files
Does anyone have a hotel budget workbook I could use?
Hiding Blank lines in named range
Question about VarType
Re: Error Handling
Rum macro in procedure
Re: Error Handling
number into percentile text
2nd post regarding Data Forms
Consolidating Monthly Databases
Excel solver time limit
refresh query
Picture Transparency/Mask/Overlay .. no APIs
Re: api viewer
Automatic email from excel
show cell values on a form
Running macros assigned to toolbars
Make cell entry event change another cell?
Sorting troubles
How to repeat code for 11 files?
sum of lookup
Macro to protect/unprotect worksheets
Setting the system clock with excel
get information from Print dialog
Scheduling macros to run automatically
Set Workbook to invisible?
Re: Need Row Address
How to use .GetOpenFilename in For loop?
Move to Next Row
Opening a workbook containing macros from VB
Re: Before Close on "This Workbook"
Re: Auto_Open & Before_Close
How can I invoke windows environment variable in excel
Micr
Re: 2 bugs in Excel
Entering time values
hiperlinks to sheet (dinamic or based on a cell valeu)
Dynamically change column color in chart
Re: Before Close on "This Workbook"
Merged Cells and Tab Feature
all worksheets except
Select all/Deselect all button in a form
User-Defined Function pre-empting Built-in Function? How to undo????
Re: Runnig macros in background mode
Re: Runnig macros in background mode
Re: Save sheet when cell value changes
Re: another messagebox/form question
Re: create a timesheet/calendar in Excel
ccrptmr.dll
Re: Watermarks
Re: Strange results using .FIND in Excel VBA
Re: Syntax for variable search
Constrain to visible area?
Re: Using Form and Worksheet At the Same Time
Re: Syntax for variable search
Textfile-problem
AutoCalculate
Re: Syntax for variable search
Re: VBA Excel Charts
Saving a single cell
Re: text format in csv file
messageboxes and forms
Re: Syntax for variable search
VBA Excel Charts
custom functions in formula bar
Automatic Macros Invocation
Re: Break out of Code
Using GetOpenFilename
Re: Sending data to a different workbook
bloating of the .XLB
Macro to perform mass header change on 100 worksheets
Code problem
Re: Referencing a range from another workbook
suppress popup message
ActiveX component can't be created
floating table?
Mysterious button
Error Message Wkbk Open
Make sure file is in correct folder??
Advanced Search
Sending data to a different workbook
iteration and error "#div/0"
Re: Excel 2000 Date Import Problem
Check changes on a sheet
convert Numbers to Text
SendKeys {Enter} acts like Return rather than Enter
Excel 2000
Hyperlink
FileSearch Code
Re: an event for onsendemail?
Re: Visual Basic Problem with Chr(34)
Re: Visual Basic Problem with Chr(34)
Help Please Cut/Paste Macro for DVD Subtitles
Password & VB editor
Re: Too much output... PLEASE HELP!
VB reformats dates when opening .CSV in excel
Re Quad combinations
Two Workbooks
Compare ranges for exactness
Gantt charts on Excel Spreadsheet
File Search code
Excel; vba; listbox how to reorganize list in alfabetical order
Command Buttons on XL User Forms
Changing Excel Icon in the Active Window
MATRIX calculations with VBE
Copying Formula
ActiveX distribution
Using the Web Too!
TEXT, CHAR and CODE
Reference to a range in an Excel Add-In
Re: DLLs and VBA: Who free's a variant?
Re: Best Excel VBA Book?
Re: Finding out which page a cell is in
Solver Fails in Excel XP
Excel 2000
Re: Help - PivotTable Drop-down not Sorting
Reference to a range in another workbook
Visual Basic to Excel Refference / Tutorial
Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False)
Re: link cell format
Re: How to detect Acrobat Distiller open
Passing Text from User Form to Spreadsheet
Visual Basic Programming Difficulties with linking Userforms
Re: Calling From Shapes
Re: Opening CSV file causes date differences
VBA: Userform Linkage Difficulties
Number value to text as percentile
Retrieve data from a spreadsheet
Re: REPOST: How to handle errors
Can I save a macro in a template?
File does not open/copy
Record changes made from a vb form
How name a copied worksheet?
Re: Maximum rows in Excel
Re: Maximum rows in Excel
Re: Toolbar Buttons
Single space? - help
Problem With Select Case
Re: Clear a Carriage Return from a String Value
Re: Clear a Carriage Return from a String Value
Cursor Movement in Macro
Re: Clear a Carriage Return from a String Value
Re: DLLs and VBA: Who free's a variant?
EXCEL: trigger web query from macro?
Re: OMG! This seems to easy I can't get it
Re: Ctrl + End
UDF Function Arguments List
Is this an array question?
RPC ERROR - 1ST TIMES WORKS FINE - 2ND TIME ERRORS OUT
Re: Ctrl + End
Returning User Initials
Re: Repost: Looking for info on how to program a userform to use filters
Creating Global Macros
Re: Formulas in VBA
Array question
Excel 97 & Excel 2002 date problem
Copying Sheet
Re: Macro assignment to button gets reassigned
Re: procedure won't call
REPOST: showing a userform
Re: Parse cell reference
Simple VB and Excel questions
ADO
Re: Continuing print code problem
How do I aasign a macro to all workbooks regardless of filename?
How to code/run a macro?
Control Toolbox button
Command line parameters into a macro
averages
Re: Cursor Movement in Macro
Re: Cursor Movement in Macro
Date Difference
Re: Ctrl + End
Property question
Goto method fails when assigning a macro to a button
Data format issue
Adding new row(s) to end of worksheet
Re: Print Copies in with statement?
Add-in udf
Re: Printing Excel Dates (Format dd/mm/yy)
Re: Wow ! Excel 7 has a secret macro "RemoveAllFormatting". Where is it in 2000 !?
Working with mac addresses in Excel
Creating Links Between Spreadsheets
Looping Through Worksheets In A Workbook
Re: The find method
Put Worksheet Name In A1
Re: Put Worksheet Name In A1
Re: find last used cell on worksheet ?
"over-lay" one range onto another range so that only blank cells are affected
Control of named ranges
RE: USING ACTIVEX EXCEL.APPLICATION
Re: Looking for a macro to curve fit using multiple regression
ADODB Recordset
Referencing Cells
format cell type problem
Simple stores control using Excel
List of Names
How can I get the time-zone info of a user?
Re: extracting data from word2k to excel2k
Code Problem !
Variable Undefined When Blank
Re: Code for saving as a .prn file
Re: For Each Sheet in Workbook
Working with Two WorkBooks
Working with Grouped cells on Protected sheets
Selection.AutoFilter Field represented by "all"
copy and paste from different sheets into one sheet using a VB code
Excel properties
vlookup
Run time error 9 (subscript out of range)
Re: How to detect Acrobat Distiller open
Auto Change Formula in different sheets
Find last used cell in an column
Hide VBA Modules?
Problem in running an application
Re: FileCopy
Close current Workbook after calling macro in other
Birthdays database
How to keep values in classmodules
Re: VBA to copy to empty cell directly below a cell when analogous cells in different column have same value as each other?
Re: How to make an alert system by Excel ?
Re: How to make an alert system by Excel ?
Compile error
For each...loop for checkboxes
Populating a form by search criteria
How to make an alert system by Excel ?
Function to Find Last Non-Null Entry in a Column
Code simplification
Re: VBA Code Works in 97, Not in 2002
Re: Refreshing a Worksheet
Re: Refreshing a Worksheet
Abort or continue
make appointment in outlook and send email reminder - all data in excel 2000
Re: Abort or continue
EXCEL AND ODBC AND QUERY
SOS VBA Code Emergency: need to copy tell to empty cell direct below where values in adjacent cells in different column are equal to each other.
VBA Syntax for VLOOKUP to return array of return values
Adding a webBrowser object dynamically to a sheet
Help with macro to update list (database)
Too many sheets is there a way to index them?
VBA to copy to empty cell directly below a cell when analogous cells in different column have same value as each other?
Code to change references
Help with FileSystemObject?
Re: Decoding Part number entries for all values embedded
text wrapping in excel
Vaciar Portapapeles
open all files in a folder and ...
newbie userform problem
Counter does not reset, on 2nd trial
vba excel 2000 device i/o error
Re: test for autofilter
Form Unload
create custom filter
Pivot Table Borders
Question
Negative Value not computing
Re: For Each Sheet in Workbook
get metadata of pictures
Query in Excel
Creating a spreadsheet from Foxpro using Object Model
What is correct syntax for a CommandButton?
Add leading zero(s) to cell values in selection - An Example
Julian Date
Control button question
Adding tabstrip and runtime
Scrolling in Combo Boxes
Limit in the number of Dataqueries in Excel 2000
saving toolbar buttons on custom toolbar
Valid ControlSource values
Macro Auto-refresh?
finding blank cells in a row in Excel 97
Conditional Formatting
need help with a function
GetSystemMetrics32() [Screen Size and UserForms - pt 2]
VBA References
Running macro in a browser window
Simply silly question
How to hilight the active cell
Saving a time stamp with a macro?
Read cell formated as Time
Template Wizard - "Saving to Database" Problem
Re: Making command button code "more flexible"
Change name in Save As?
Validate value in cell
Re: Making command button code "more flexible"
Checking characters using VBA
square boxes when using vbcrlf
GetOpenFilename - Problem
Runtime error '1004':
Textbox does not print properly
Timer Event
Dialog Box Control
ctrl-key adds up to cells.count
need help with a function
Tutorial Available
Excel Add-ins
"Problems obtaining data" error refreshing Excel pivottable
Checking for existence of macros or code in an Excel Spreadsheet
Macros
Disable Database Object
Error Msg
Collecting values for later display?
Open Winword-file using a Excel 97 VBA macro
mysql backend
Emailing from Excel
listbox doesn't scroll properly
Re: Expected:expression
Re: UDF returns #value in XL97
Re: Cell Protection
Declaring Variables
Delete duplicate rows
Assign Macro problem
Inserting Records
Re: Cell Protection
Adding components to multipage programatically
Re: Problem: SaveAs / SaveAsCopy methods
Re: crash changing const to public const
Opening and saving textfile into XLS
generating sheet with command button & code
Locking cell color pattern when sorting rows?
Re: Cell Protection
Print Multiple Sheets
How can I find a handle number of controls on Userform?
aliases
Clear clipboard
Re: Used Range Problem
Re: Enter Excel Design Mode and Exit Design Mode
Screen Size and UserForms
If... Then Loop problems in Worksheet Event
MS Excel Sheets...how to copy and paste ?
Re: Multidimensional Arrays - VBA
Unlinking workbooks
array
Multidimensional Arrays - VBA
Re: Question about "End(xlUp)" property
Re: Question about "End(xlUp)" property
Pivot-table versus crosstab queries
Taking VBA from Excel 2002 to Excel X on a Mac.
Locking command button size to cell proportions?
Export to excel from ASP: Text data interpretation issue
enter into an excel cell...
Cell formatting with 2 variables
Network Path
Macro to name a range
Repeating (Looping) a Macro
Fw:code needed
Stop Dialog box from appearing within macro
Used Range Problem
Re: Auto_Open Check date and Close
Re: Comparing 2 spreadsheets
For Each Sheet in Workbook
Excel VBA to access URL as Textfile
Name a range
Spin Button to increment or decrement the date in cell A1
learning expert level
File Checking
create .TXT file Log
Newbie Question
Disable options
Worksheet Tabs
Re: disabling shorcuts
OLEobject on the sheet
Re: Last cell in column
if statment
Modeless form disappears on deleting sheet
can I Link a database to excel work sheet
query
Subtotals
Need Help Summarizing Survey Results
Re: Something slightly harder...
Re: Auto_Open Check date and Close
make appointment in outlook using data in excel -- set recurrence
Re: Typing a quote character Vs pasting a quote character=> what happens to the resulting CSV? Interesting!!
I got those pivot table blues, ...
Re: Typing a quote character Vs pasting a quote character=> whathappens to the resulting CSV? Interesting!!
Re: Restoring Excel menu bar settings that were changed by code
Help to get Calander functions on Excel XP
vba: Taking average of values in one column based on a corresponding value in another column
counting occurances of a char. within a text string/cell
Re: Auto_Open Check date and Close
Re: Help with Macro Code
Passing a Variable from Worksheet to Workbook