Excel Programming [Archive] - Page 171

Range selection problem
How can I avoid form destruction??
Copying Problem
Protect a few sheets
How to disable Keyboard shortcut
Efficient Search / Find
Out of memory error.
Out of memory error.
Out of memory error.
Wrong data format in columns ... What's going on?
How to use Microsoft Calendar Control 9.0 on a Userform
how to determine which checkboxes are checked
SUM Formula using code
Re: Linking cells in two separate sheets
Re: Linking cells in two separate sheets
VBA "Save As Text" Routine?
Re: Find a Value and not a Formula
transpose absolute references
VBA -- procedures as arguments?
saving
Re: For loop for Checkbox
Re: For loop for Checkbox
Re: Programing a macro to pause while running for data entry
Excel Automation - Chart Performance
Virus Warning
Newbie VBA Help Needed!
password VBA and need for Macro
Multiple ComboBox linked to Outlook and Interlinked
Inserting A Row Into A Data Table
Writing an Excel Spreadsheet via a program's output
Multi-User Access to a worksheet
Macro search replace question
Simple textbox question
Excel skip some lines of VBA code
excel web component get data from spreadsheet for post
Determining Row Number
Set Excel to not automatically convert text to date
formula is to long error
Find/search function/example request.
Finding a Duplicate using Vb
excel
Excel formula in macro
change page margins at word through excel
Macro that controlls duplicate values
attach to email
Re: insufficient resources
Re: File save as
Distributed Spreadsheets
Add control to commandbar
Canceling a UserForm
Insert rows
Re: Excel conversion
visual basic command in a cell??
Re: can't read KB articles (font)
IsEmpty and Is Nothinq problems
log files
Tracking down functions in use (Excel 97)
Re: VLOOKUP in VBA
Command Button vs Form Button
Advanced Filters - improve performance ?
Returning the "You replied to this email on.." property from Outlook
passing strings
Re: call a sub with arguments from Worksheet_FollowHyperlink event
Re: ComboBox List
Re: ComboBox List
PASSING A STRING VALUE
Macro-Run-time error '6'
how to set scroll area
Excel 2K Com Addin DLL in Excel 97?
Re: Splitting a Procedure
Re: VLOOKUP in VBA
Re: Setting a Solver constraint using vba?
Read embedded word document by VBA
Re: Setting Print Area, includes text, numbers, charts & graphs
Re: Splitting a Procedure
Updating Pivot Tables
Splitting Procedures
Run method for subroutines
Problem Using an Object Variable in a Class Definition
Problem with Multi-Dimensional Array
Re: How to insert Excel Worksheet Name using Automation in VB Dot Net??
Re: Changing Option Button Value
call function
syntax of changing file attributes
Bold (an easy one)
Conditional Max value
Re: can't read KB articles (font)
Modifying Relative Addressing
Providing for Applicaiton Update
Re: Calendar in UserForm
Re: Can VLookup refer to a cell with a range name?
VBA help doesn't work: Stuck with resize cursor
Re: Can VLookup refer to a cell with a range name?
Re: SaveAs needed if new
changing a cell value in a different sheet from several sheets
Re: SaveAs needed if new
typing in a number and converting it something else
offset
Re: popup message window
Re: Problems with german excel version
variable cell into range
Finding latest transaction and seeing if it is over a year old.
Add controls to UserForm
How to provide sample workbook?
Re: Make tools button grey
Problem - Workbook_BeforePrint
Could this code be faster?
put a calendar on an excel sheet
Accessing the values of form controls on worksheets in Excel 2000
Application Installation ! Urgent
Re: Problems with german excel version
Excel Remains Active in Windows Task Manager
Automatic Date
Re: Hide & Copy
VB Excel Automation Error
Passing Data to Outlook
Minimum time per interval
Re: How to hide sheets and VBA code in my Excel workbook?
VBS script for Pocket PC
How to hide sheets and VBA code in my Excel workbook?
Re: print listbox contents
how to add code programmatically to a macro for a button
Set Print Area = Image??
Re: Scanning & .chk extensions
Function to Find Duplicates
Rookie VBA'er seeks help!
Automate open file, update links, run macro, close and save file
Excel version compatibilities
How do I set the value of a textbox on a userform to the value in a named cell?
Re: Call a macro or sub based on the name of a cell?
Simple goal seek macro
Re: Sorting in a ComboBox
Networking problems...
Re: userform question
Re: Autofill Indefinite Range in VBA/Macros
Excel Workbook opened twice with dotnet interop
Re: Excel crashes with createEventProc for a button
Autofill Indefinite Range in VBA/Macros
add to two dimensional array
Date Formulas
join location string with variable
Text following an Outlook field insertion
Manipulate Excel
Re: Call a macro or sub based on the name of a cell?
Excel in SourceSafe ???
Temporarily delete ALL CommandBars?
Rounding parts of a number while maintaining the Total
Make Spreadsheet Time out
Excel's Hyperlinl
macro needed
Array Help
MS Query
Automating Excel on a Server
=clean(a1)
deleting the rows depending on the result of a condition involving two columns.
Re: VBA and Passwords?
Object Variable or With Block variable not set?
Re: SendKeys
Re: example
Print dialog
Re: strange problem For Each loop in Treeview
Workbook.SaveAs
Set variable equal to a cell value & more
Excel Macros
Re: strange problem For Each loop in Treeview
userform question
userform question
Excel VBA misbehaves on web???
REQ: Simplest way to parse (read) HTML formatted data in via Excel VBA (or VB6)
Inconsistent code
Re: Excel crashes with createEventProc for a button
Re: Subroutine call without file reference
Cut and Paste after Auto FIlter
concatenate a date
import text-file - strings contain cr-lf
Re: XP comments
Re: XP comments
Re: Make tools button grey
Macro to Sort Automatically Based on Contents of Drop-down Box
Open Folder
Copy Data
Re: Copy data
Re: Open Folder
Command buttons not available
Second instance of Excel
Synax for two IF conditions in VBA
Remove password
Excel 97 "Find" metod
Generic Command Button Response
macro use of "find" command
How to get the active cell address?
Find finds nothing, and errors
Opening Multiple Workbooks
Database refresh crash
concatenate
Displaying info
Open excel workbook in access
Code to not display delete sheet alerts
Re: Excel crashes with createEventProc for a button
Method 'Range' of object '_Global' failed
VBA Keywords
Data Validation
SaveSetting/GetSetting: not high-overhead?
Popup message window with name
Automating email using Lotus Notes
Macro which adds new spreadsheets
Search by Date
Project Elements as One List
Bringing Excel to the front
Renaming VBA module
Code in ThisWorkbook crashes Excel
Re: Copying rows from one file and pasting into a new file
Re: Paste special problem
Re: Memory Issues
Macro For Filtering on Multiple Sheets
sheet.range.sort with ordercustom
new to VBA
VBA to read spreadsheet's filename?
Run time error '9' Subscript out of range
Re: new line at sheet textbox
Why won't this Excel 2000 code work for Excel '97?
Basic Email Help Excel 2000 Req!
Using data from Fomulafind dialog in Find Method
VB6, Excel, Win Version conflicts????
XL Query. Urgent Please help.
Re: VBA - Application-defined or object-defined error
Can Range.Find search a Cells' Text property?
Subtracting times.
Sorting/Adding certian cells
faster macro
Re: VBA - Application-defined or object-defined error
Linking cells to another worksheet
Visual Basic Range variable
Disable update links dialog box
VBA - Excel issues
Using Application.WorksheetFunction.Ln(...) in VBA
Need to Find End Value of a Column with Unknown End Range
Re: mail
Another Newby question about selecting and what it can do [longish]
Excel 97 File Name is Saved as a Number?
Re: Charting Problem VBA
Dialog Box Confirmation Selection
Hiding print dialog box within macro
Excel
HasComment?
Help with some code please
Scanning for Duplicate Data in a Column, Merging Data and Finally Removing All Duplicates...?
Help for formulas/layout?
List variables in worksheet
Listbox/Form question
Pulling and Pushing web page data
excel 97
Yet another Newby question about selecting
Re: Copying rows from one file and pasting into a new file
Sorting a list of names for updates
Easy question: macro to move cursor one to the right
Summing a variable sized range programmatically
Execute a macro when the contents of A1 changes
Personal.xls in the startup folder must stay open for recording
Extreme Interview with Anand Bhatt kyuVzL
formula for days in month - days left???
userform
64kb limit to module code
Why does this formatting macro not work?
Menu entry with check?
Create a Databse using VBA
Case statement in variable range
Printing and Document Name
Traverse treeview bottom to top
Personal.xls Question
Enable/Disable Macros
Comparing Values for Sorting
Advanced Filter
not pulling down formulas
month to number
Flatfile.xla
ComboBox and select item
Popup Massage Windows
Prompt User to Enter Data with a macro
Re: Create a formula into a String then assign string to a cell
How to Save Custom Icons?
Simple way to input dates
Macro changes the format of dates
Re: File from an Informix database to import into Excel
Excel Web Query - SSL 128 Bit
Re: insert picture into worksheet cell
Exiting Excel without being prompted
Re: Exiting Excel without being prompted
Input variables on Sheet1 being called by a VB program on Sheet 2
Excel VBA Code Execution Excel XP Vs Excel Office 2000
SIMPLE MACRO!!!
OnTime running 2 subs
Hyperlink Bug
From my Addin, referring to activeworkbook's sheets by their codenames
Object not supporting property or method
problem using ActiveSheet in VB sub
Automatically runing a macro
Re: VBA Calls
Enter text in cell Code
Personal.xls
Formatting
Pass Variables into Form's code
Memory Leak using ADO 2.6
Finding spaces cells
Re: problem editing Word document with VBA from Excel
checking if workbook is open before accessing
Minimize a form
Find method example
Protecting VBA Code
Copying into new spreadsheet
Wow
Error message
Hiding null sums
Read embedded word document
Re: SUMPRODUCT Problem
Saving a File Generates a Sequential Number Name
Userform-List box help
Re: Changing security level
Re: Screen Refresh after minimize
Re: Changing security level
Re: Changing security level
Creating HTML files in VBA
VLOOKUP
For chip about scroll
Re: Is there a way to ReName a Sheet Using a Drop Down Menu?
Template Wizard w/ Data Tracking 97-->XP
Combobox list source
Date update on data update
Active X not updating properties on Excel Sheet
XL 2000 Template Wizard - help
Setting Decimal in code
Re: SUMPRODUCT Formula
Automating entry using validation
Pivot table filter list doesn't refresh
Excel to Word Font Size
Multiple users running macro from personal.xls
Shapes.AddPicture run-time error
Codename equivalent for Series
Excel 2002 Compile Error ?
Re: deleting rows in a non-continous range
Hiding VBA code
Dates
Progress Indicators for Dummies
Lookup formula with date test
Wildcards
Compiling Multiple Spreadsheets to One
Re: ScreenUpdating automatically resets to True
copy/paste VBA
Re: HOWTO Replace from Row
Re: Customizing print preview window
Cursor Location
Re: Assign Macro not showing up
Problem width width-property
Re: HOWTO Replace from Row
Application error 1004 with a twist.
Changing Save As Type in Save as dialog box
Re: Charts & Graphs on Userforms.
Opening Excel files in cascade through VBa
Re: Delete row from range using key column
Re: Create and Array formula using range names
Code that runs each time AFTER a sheet is cut off the book
HasComment ?!?
Re: Error about ExcelApp.Workbooks.Add
Re: Send Keys
Choose diagram
Run time error '1004'
RE: Word Document that shows Excel Chart
Problem with TAB key and Textbox controls
date time picker error
Combining Cell into One
Re: Assign Macro not showing up
HTML in Excel VBA
VBA read/write registry setting
VBA read/write registry setting
Re: Type Mistmatch Error
Re: Automating Excel Cell Drag and Drop
Re: Intersecting addresses from two sheets
Re: Keyboard Macros
VBA to Element Based XML
Re: deleting rows in a non-continous range
Re: checkboxes lose value in Excel
Re: Can I find what ver of IE is running via VBA ?
Re: Test to see if a worksheet exists thanks, Chip
Macro error why?
Re: month to number
Re: month to number
Regex Question
Open program with Application.Quit?
Un-usable Icons
macro written in Excel 2000 not working in Excel 2002
copmapre and rank cells
Task scheduler question
window control
Subtract 7:00 pm from 7:30 pm
Open a text file and get the info
Re: User form with a listbox
Subtract 7:00 pm from 7:30 pm
Re: Subtract 7:00 pm from 7:30 pm
Re: Retaining Defaults in an InputBox # 3
Re: Subtract 7:00 pm from 7:30 pm
Attaching Macros to Custom Buttons
Programming Ideas
File Location code
Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report"
calculating averages
how to send e-mail from excel
Is there more efficient formula?
Adding Data from EXCEL to a TEXT file
Print Macro
Re: An error on the error :)
control scroll position
Re: combobox change
Re: month to number
Re: Protect UserInterfaceOnly in Shared Workbook
Re: Protect UserInterfaceOnly in Shared Workbook
Re: message box program flow
Method ~ of Object ~ Failed.
Evaluating new project idea
Re: Link macro to a toolbar?
Re: How to check if SHEET has QUERYTABLE property ?
Re: month to number
Counting entries
Re: iterating through all properties of an object
Re: Send Keys
Re: month to number
Coding to check for a sheet name and add it if it's not there
Re: Cascading Deletes across multiple sheets
a lot of "ExternalData" Named Ranges
Re: Protecting Macro's
Re: Protecting Macro's
Re: Intersecting addresses from two sheets
Re: Send Keys
Is there a floppy disk in Drive A?
DAO objects with late binding in Excel?
Outlook and Excel Integration for Contacts
Re: how to make a help hint for my function made by myself.
Re: Excel functions/formulas
Workbooks.Open closes other workbooks
How to present User with Print Options
Re: Numerical accuracy in Form Text-boxes
Range COPY function - how to copy VALUES and not formulas
Saving a Workbook without code
Position of Message Box on screen
Figuring out what the Shape Indexes are.
Re: Automatically Determine last row and column
Re: Macro to edit cell
sort method frustration
Re: sum (column 2 of namedrange)
Automatic Numbering of Sorts
Is there "SourceSafe" for Excel VB Macros?
Re: Cancatenate string
Adding TrendLine
Re: Writing to 2nd worksheet in workbook
Finding cells and summing variable cells
Cancatenate string
Re: placing dialog box for showform
How do I create a Worksheets object
Toolbar Button
Comparing 2 worksheet
Read Value fom Closed CSV file
Keep userform visible, but return control to calling routine
VBA read/write registry
HOw do you save a file using a macro?
Re: Another ISERROR question...
Autocomplete; and other
Prevent user from disabling macros
Re: Another ISERROR question...
Stripping dashes from a number
Re: Searching text
Excel VB sub
VBA union of two ranges
Re: MyOval = ActiveSheet.DrawingObjects.Name
Cell F14 F16 Required if F22 or F23 is checked
Merge Imported Files for Output???
HOW TO PROGRAM EXCEL SO THAT THE TITLES ON GRAPHS ARE AUTOMATICALLY CHANGED
Program cell to delete other cell values
Re: abc ANAYLYSIS
NEED HELP PROGRAMMING EXCEL TO AUTHENTICATE EXCEL USER ID AND LICENSE NUMBER WHEN TEMPLATES ARE USED
Can't see my worksheet in excel
Re: Keyboard Macros
ComboBox Default items Not Showing
Update Links/Trust Macros?
LEFT Function in Macro
combine cells and preserve formatting of individual characters
Re: macro to edit formula
Store Value after Calculation
Outlook and Excel Integration
Re: Determining Active Row Number
Properties Page is blank for check box Control, other controls
Re: Code for Buttons (repost)
Re: Input box question
MS Graph - PowerPoint
Field Required if another field is checked
MDI Forms in Excel 2002 XP
Re: worksheet protection
Re: Text Box - Setting Values
search for values to define range
Determining Active Row Number
Speed up password cracker in Excel ?
Import Data from Access Database in a Workgroup
Making cells so users can select them
Calculating the first day of the week for the month
subtotal function
CONDITIONAL OUTLINE
Listbox question
User Form textbox formatting
speeding up a macro
wildcard character replacement help
Search and find
Excel 2002 - Multiplication
Calculated value based on current line selection
Combo box in excel
Re: Macro or ActiveX for buttons
Re: Exception HResult: 0x8007FA08 (VB.net)
self-installing add-in?
self-installing add-in?
Re: Trim like worksheet Trim
Re: Declare Multidimensional Arrays
Copying Text vs. Numerical Values
Re: Declare Multidimensional Arrays
abc ANAYLYSIS
Re: worksheet protection
worksheet protection
Re: Formatting a range based on contents of column/row heading
automatic sort
How to average up rows in Excel using VB6
VLooking Reference in Combo Box
Worksheet gets update from DDE server
Sum & IF condition
Re: Setting a required cell
Setting a required cell
Re: Setting a required cell
?
List an object?
macro to edit formula
Re: Making Databases
Re: Traversing Rows
Updating .tag in Userform Control in VBA
Re: Open Excel files in a folder
Re: Open Excel files in a folder
Macro in different books
Separating Data
Populatnig cells from an addin
Re: Hiding worksheets based on user permissions
Formatting a range based on contents of column/row heading
Summing unknown number of rows
With Sheets("Data_Assembly"
Calculate No. of Objects on Floor Plan
Search Problem
Re: Clearing cell contents automatically
Automatically Insert Rows
How to make the drop down for comboBox visible in toolbar
Change event for multiple checkboxes
Re: Proper case
paste selection??
Re: Proper case
Referencing one workbook in other???
vb6 and Excel 97
Re: Opening a spreadsheet using VB
If;than (macro)
merge data from multiple excel sheets into a workbook
Opening a spreadsheet using VB
Problem with closing the excel application
Re: Opening a spreadsheet using VB
range offset
web query format
Renaming within VBA
SendMail error
How to program a three dimentional table in excel
Displaying CSV file with HTML tags in Excel 2002
Re: Upper/Lower case problem
Macro recording
Re: Login Box help
Starting Date of the Month
Validating Excel
F4 Repeat Default Restate
Skipping protected cells
importing data using a macro
Re: Control Tip Text For Pictures
Selecting Filtered Items from Named range
Visual Basic problem
Re: Looping Through A Recordset
Re: Selective read data from ascii file
Excel VBA Conversion
Code and data part deux
Unactivating
Re: TextBox Coding Help
Getting the formula of a cell as text
VBA occur error - kernel32.dll
Copying Formatting Without Selecting
Drawing in Excel
Re: UserForm with RefEdit Modality Issue
TextBox Coding Help
looping cells though a named range
Code for Buttons
Caption on Menus
Problems with worksheet containing ActiveX controls
Importing csv into excel and not retrieving all data
Re: VBA TextPager / Email
Use of IIF
VB Editor doesn't "recognize" open workbooks
Re: enable/disable macro's dialog?
Web Query in Macro
If Then Else Statements
Re: message box program flow
Import data from Access Data Base
Detect Excel Version
XL2000 VBA code to ACCESS 2000
Adding text to a cell
Column width in pixels how?
The .xlb File That Wouldn't Die!
message boxes and buttons
Using the "Find"
Mid$ Function
Re: Look up number
If/ then question
Re: Get rid of this file contains macros box
Access to Excel
Re: Hide code from user
Re: Using Workbooks.OpenText to read a tab-delimited file into a worksheet
Save As command
Can Excel VBA work outside Excel?
How to limit the Number of rows in Excel sheet
AutoComplete? Drop Down List? Please Advise
read-only error
Re: VBA TextPager / Email
Picture with Macrto Assigned causes problem
Re: Allowing formatting in lower versions of EXCEL
Increase letter by one
Listing all external links within a file
SQL Statement Attaching to SQL Server
Changing to Network Directory
Re: Tricky Conversion Problem.
Re: Contents of a file
Re: How to copy text from a TextBox in a ActiveSheet to a variable
Selecting the other open workbook
Re: How to copy text from a TextBox in a ActiveSheet to a variable
Saving combo box list when closed?
Inefficient Calculation of User Defined Functions in Excel 2000
Re: Can i set a reference programmatically?
Re: remove close button
Formula Returns #N/A
Macro that hide or unhide and not calculate or calculate
Re: remove close button
Determine last col with data
Re: remove close button
Re: Hide code from user
Re: Carriage Return
Formatting zero results from a formula
Re: Opening a UserForm
Setting the Send to Value xlDialogSendMail
Help with some code please
How to copy worksheets with a user defined variable
Re: Looping Through A Recordset
Finding a range for Copying & Pasting
r1c1
Re: Visual basic for scrollbar feature
Re: Populating a VBA UserForm
Help! Inserting Rows
VB Application for Advanced filter Macro
Recognising '0.00'
Re: Named Range
error with setting "Items.Visible = True"
Re: Named Range
HELP
Quick question - is there an easy way to find which row is the last with data?
Enabling Add-In closes current sheet
Visual basic for scrollbar feature
Re: Converting VBA app to VB.net project
Strange variable declarations
Why wouldn't calling the Activate sub for a sheet automatically call that sheet's Worksheet_Activate() sub?
Re: how to save the input of the controls in a form
Need for performance boost
Re: Dates
Enable Macros with No Prompt
VBA Excel Checking whether an XL file is already open elsewhere
how to protect a sheet
vb.net and excel xp
Re: Data Validation Error!
auto turn off macro virus protection
Re: Converting VBA app to VB.net project
for each cell
get a sheet of a Excel file
Inputing data ranges
Addin in read-only mode problem
Controlling random rows
Advise, please, how to get the following macros working:
Data Validation Error!
Page Setup
Date string question
XL97 watch window hangs
Help! Trying to recover macros from a file
Converting VBA app to VB.net project
Creating an XL Range on the fly
How do I get a cell's row number
Re: splitting text in two lines
Hacking open password
Re : Excel – Width of a Column and PointsToScreenPixelsX
Summing a Range
Conditional email sending
Using VB to unhide hidden rows based on user response
Excel & Outlook Integration - Urgent!
Coping values to the next empty row
Excel 2002 / XP - Running .XLS with Macros via Task Scheduler
Re: Excel query creates named range
help...too much copying and pasting
attach macro to hyperlink
Selection.End(xlDown) with Rows selected
Re: Importing Userform in Excel 2002
excel office templates
Re: Unhiding Rows
Selection.End(xlDown) with Rows selected
Excel Range to Access Table
change default for sort ?
PATH Update; VBA problems
Adding buttons and connect macro
raw speed for excel worksheet functions? - xll -or com addin?
Trap Excel events from VB
Auto Close
Mail multiple charts instead of multi. sheets
Clearing list from all form commandboxes
Find top of worksheet
Re: Sheet Name Change Event?
Re: Sheet Name Change Event?
Can I use a login to let users see different worksheets?
how do I create a login for a spread sheet
How To Keep DropDown From Printing?
DsoFile ActiveX component can't create object on other computers
Re: Adding New Records To Excel Database..
VBA update data from Internet Explorer and copy to Excel?
?
log the values of a single cell
How do I unprotect cells when using OpenText function?
DAO query/recordset returns with field names
Re: Adding New Records To Excel Database..
Do I need programming for this?
Popup Progress Indicator
Re: 2 Dimensional Array
Re: Triggering click event of a menu in vba
Re: to Tom Ogilvy: re Macros in excel
Re: Triggering click event of a menu in vba
Re: 2 Dimensional Array
Spinbutton Linked to Textbox
SUMPRODUCT
Hiding selected Row
Vlookup Error handling
Re: Accessing a "veryhidden" sheet
deleting certain parts of a cell
Web links in Excel closing workbook
Re: Offset function
Re: What are the System Tables named "Print Area" & "Print Titles"?
Re: Unattended Macro
Re: Run-time error 40036
Re: comments
Can't dynamically add withevents OptionButton to worksheet
Limiting return on Excel Web Query ...
How do I get series of files to open from same folder
Re: Excel query creates named range
Re: dates in a combo box
Re: Enabling macros
Re: Method 'ActivePrinter' of object '_Application' failed
VBE calls Mathcad 8 in Excel97
Excel Function
Scheduling a Macro
How can I open a named Word doc from an Excel macro
Re: Colums and Rows to repeat in Printing
Re: How to Limit No of Records in a Validation List
Paste Special won't work in VBA
Toggling one column of AutoFiltering
Parametrized Macros preventing other macros
Repost: How to Limit No of Records in a Validation List
Formated date thru Input box
VB Forms
Data import
Why doesn't it work?
Simple VBA devision problem
Worksheet name length
Checking the last character is in a list
Adding a additional column in to a sum range
Userforms
Create and Array formula using range names
Retaining the default in an input box - again
Switch to Access
Excel VBA Macro
Polynomial least squares fit
Login Screen
startup file
Deleting/Replacing Values in a Range
HIGHLIGHTING ROWS & COLUMNS
Re: setting complex print area
"Select Column method or property not available because some/all of object doesn't refer to table"
[help] asp & pivotchart
Footer (Update Date)
Re: setting complex print area
closing instatiated apps
Re: PasteValue Without Selecting
Re: PasteValue Without Selecting
How do I convert a user defined selection into an array?
Conditional compilation
Re: Locking cells
SQL Server 2000 - Pivot Table
Code to put contents of A1 and B1 in header
Reference? Question
VBA & Excel memory usage
value of a cell based upon column letter and variable for row#
Re: Passing an Array of User-Defined Type to an Argument of a Function
Re: Goal Seek (in VBA)
Passing arrays to a subroutine
Links
Copying a block of data
Listbox problem
Sum Dynamic data
Problem with copying variable(s) to cell(s) and converting strings to mixed case
Returning data to excel from msquery
Re: Return Col for best alphabetical fit
Copy form and code question
Football League Standing
Scope of variable includes all Form _and_ Code modules??
"Backing" up a Workbook Sheet
The object invoked has disconnected from its clinets
Exporting Text File
Re: Copying formulas to new cell
persist properties
Re: web hosting for up to 10 domain names 7.00
What does the me. preface do?
file format
unable to control screenupdating
BuiltinDocumentProperties
strange command buttons in fax preview
A couple of questions
COUNT SEPARATE PERIODS IN COLUMN
Type mismatch error
sorting in Pivot tables
ThisWorkbook Macros
Cross-Post vs MultiPost
Need final code tweak
Re: How do I return the values of a chart's data range?
Re: step into process
Entering a 30 digit number
Merging 3 Columns in an Excel Spreadsheet (Keeping Data Intact)...2nd Post
Annual % Increase - Formula
SQL in Excel?
Date Format
please help
Re: selecting multiple charts
Re: Locking other Excel sheets from intermingling with my Excel App
Re: Charts in cmyk/pantone colors ?
[how to] VBA catching close/print in printpreview
Earn $500 to $700 per Week Downloading FREE Software
The path for any given Excel spreadsheet ???
Re: Keyboard shortcut to insert a checkmark
run excel macro
Re: Shared file - macro error
Pass file name from Spreadsheet Range
Re: Checking for non-numerical content in a cell
Chart creation ceiling in Excel 2002 via Chart.Add ?
Scheduling by seniority
Prevent dialog - Prevents Sending Excel File From Outlook
Re: Working with a WK1 format...
Downloading stock prices
drop down menu
Errors when copying a sheet
EXCEL REPORT
Re: Dropdown control as multiline
Clearing a Column range in Multiple Workbooks
changing sort for pivot table fields
Re: Inserting Long Text in a Cell Problem
Comments on this code to FTP save, please?
vb.net vs studio.net
placing dialog box for showform
Custom Format
Re: Keyboard shortcut to insert a checkmark
Re: Opening questions
Re: Keyboard shortcut to insert a checkmark
Re: Exiting a workbook
Method 'Run' of object '_Global' failed when changing OS and Office versions
Disable Clipboard Dialog Box during Macro
Re: Exiting a workbook
Re: Logon to Worksheet
opening and writing into notepad
For Loop in Sub Detailloop
Calulating the last sayurday of a week using vba
CreateObject produces error
Copy Formulas
Detect whether a row is completely empty
checking multiple sheets.
Re: xlClipboard Clear Contents
Do I need Excel installed to use excel objects from VB6?
Re: Need specific values
Retaining a default in an input box
Automatic screenshot in Excel
Re: Changing Excel Chart Size
Keep running total of mult. inputs
Re: API call to check other program is idle
Question about sorting & subtotaling
Determining cellcontents
How do I get Pivot filter change event to fire?
Re: How to change relative chart/pivotTabe ?
Re: Inserting Long Text in a Cell Problem
Re: Loop ends early
Good code not working???
alfabetical order in array
Open XL2K without executing Macros
Turning off all screen updates during a Solver routine
Re: Sharing Variable Values Between Workbooks??? Any ideas?
Re: Code to tell if workbook is opened in browser
Array Size
Programming Undo
ComboBox Hell!!!
VBA Function Version Comparison
Beginner question about selecting a range
Selecting or Activating a cell.
Re: Closing Excel in VBA
Excel's Marco Convert data to Access
Re: Cannot Delete an ActiveX Control
Rejected Safe Mode action : Microsoft Excel.
OLE embedment of Mathcad 8 in Excel97
Autofilter.Selection - After Change Event???
Excel return error code
Best Excel 2002 books?
Re: Cannot Delete an ActiveX Control
Can the user "Choose" the path via a VBA command?
unactive workbook name
VBA code or formula needed to identify certain records in a database
Re: Quitting a User Form
Re: VB.Net
Range object failed - random error
Permanent Variable?
Worksheet unhide
saving a ss
Create an .xls file by script
Re: excel/asp interaction - HELP!
Re: Macro/Paste Special
Re: Macro/Paste Special
trapping click events on shapes
Absolute reference in R1C1 notation
Re: convert a string of into a date format
quotes in formulas using vba
Re: links to several xls with same named ranges
rate of change vba
Source Data Code Cleanup Help
Finding Machine Identifiers
Re: Inputing Data
COUNTIF() data type problems
Re: Modifying Locked Cells... :-)
Re: Modifying Locked Cells... :-)
web query
Trouble to sort an array in Excel using VBA
Moving Data from one sheet to another
Re: VBA does not open workbook
Counter
VLOOKUP and table_array link
Can you Copy Objects from a Worksheet to a Userform
Re: sumif ...
OnTime method only runs 1 time
Within Range?
Re: Can't get out of loop at the right point
Re: Can't get out of loop at the right point
Vb.net - excel 97 automation
Use XL as packet sniffer & log?
Re: sumif ...
Command to jump to last row in list not working
Workbooks.Open for FtpFileSpec.xls with Password
Getting the systems username
Re: sumif ...
Re: Command to jump to last row in list not working
Auto Fill in Formula Per New Line
force upate to datbase using save as
Re: Selection Change question
password char in input box
Help with Sort
Re: Merging or Adding two .csv files
ungroup worksheets
Re: Merging or Adding two .csv files
Re: compile error in hidden module: Dialogs
Re: Editing the VBcritical logo
Searching for a words in a column from a list of words.
compile error in hidden module: Dialogs
Catch Update Linked Cells Event
Disabling Toolbar buttons and CommandBar items
Group Commandbutton?
month calendar
animation and message
animation and message
Excel causing
Re: Comment Import
Worksheet version of VBA JOIN
Disable auto editor formatting
Re: getting excel to recalculate on format
Re: Save an image from a worksheet to a file
Urgent Help! Excel's Marco Convert to Access's db
Return value of excel when exit
Selecting a constant changing Range
Re: Copying formulas to new cell
Why the DataValidation Code not working?
SUMIF
Re: Copying formulas to new cell
Updating xlusrgal.xls on other PCs
Re: Copying formulas to new cell
microsoft excell programming