Excel Programming [Archive] - Page 165

Can I "sign" my own macros? or some other fix for the message about security and macros?
text to values
RE: Programming Excel in Windows 98 Second Edition
50 workbooks
Passing data between spreadsheets
Identify Forms DropDown as it is triggered
Macro selecting the last used cell does not work
Link a macro to a cell value
getting the Weekday from serial
Use of the "OR" function
Find active Windows()
formatting a worksheet
Random function
Minutes vs Hours
determinate if pop up menu exists
Differences between Excel 97 and XP
User form trouble
problem with selection when calling macro externally from VB6
Button, Button, which Button?
Testing Closed Files
Transferring data from on excel spreadsheet to another
automation macro
Setting Spreadsheet control data source to Excel file
SaveAs syntax when using a variable
how do i ignore cells with font color?
how do i ignore cells with font color?
how do i ignore cells with font color?
how do i ignore cells with font color?
how do i ignore cells with font color?
how do i ignore cells with font color?
how do i ignore cells with font color?
Remove a reference
how do i ignore cells with font color?
how do i ignore cells with font color?
how do i ignore cells with font color?
how do i ignore cells with font color?
how do i ignore cells with font color?
how do i ignore cells with font color?
Duplicate Rows
how do i ignore cells with font color?
Re: PasteSpecial problem
how do i ignore cells with font color?
how do i ignore cells with font color?
how do i ignore cells with font color?
Excel - add to "Worksheet Menu Bar"
Combo Box addItem question
Excel Writing speed
Copy and Paste to New Workbook
access X ecel
Open files in directory
data validation vs. locked cells
Create an Input Box in Assistant
NT Domain Logon
Timed Automatic Refresh of Cells
Change Printer
Formating Macro
Run-time error on command button
Copy Worksheet Help?
Logical Functions
Logical Functions
Grouping & collasping in a protected worksheet
Adding reference in code
My Autofilter is overzealous!
converting a number to a date
"Each Row from there to here"?
Run Time Error 1004
FillRight
Assign code to shape
Copy rows to different worksheet destinations
Count Function in Date Field
How to hide row range from code?
Responding to cell events in Excel
Worksheet name in order
On Enter and On Exit events of MSFORMS controls?
Need help with algorithm
Run-Time code refuses to work in Windows XP
secure a sheet
OCX Error in Excel
Com Port and VBA from Excel
extracting a stringvalue from filename
Get external data not working properly
command buttons
Can I create in VBA a class with instancing type different from 1 and 2?
Global value does not retain value when UserForm is hide
Deleting rows with specific value from row 1 to 200
EnableEvents and DisplayAlerts problems
VBA Object (External) for EXCEL
Help needed coding a macro to adjust the source of information each time it is run
VBA Copy Worksheets
Excel Custom Function with Select Case
Delete cells - auto move
Books Excel
Tom Ogilvys Code
Leading characters
Sheet Name
Sending Emails according to sheet name
Repeated application of AutoFilter
Code Modification(From previous post)
copying and pasting loop
Protecting Sheet
Inserting and arranging sheets
Time a sub routine in thousanths of a second
How to find the first blank cell in a range
How to find a value then select that column
Change Font Type
MIME multiple Excel spreadsheets
Detecting if a userform is loaded
query info based on dates
Using variables for row index
Sending print commands to the printer
Cell limitations?
Hiding a hyperlink!
Merging 2 Excel Documents
how to delete empty row in vba
Change to existing macro
Linking cells to a field on a website
Custom Footer using ThisWorkbook.Path?
Range of Cells to populate in a text box on a userform
Disable Excel Prompt
Replace ActiveCell w/Query Results?
Email Array
Best practices pivot using SQL-sourced table?
User Form
"This macro calls that macro, which calls .."-how many?
Worksheet Protection
Hidden worksheets
Hiding macros
Re: Delete records using excel Macro
Get external data with password
Make a file read only
Making a macro references relative
Re: Delete records using excel Macro
Indirect addressing
Once criteria has been met, delet the same row.
EXIF information
cells in a diagonal range
$6 to $6000
Dynamically changing a calculated field in Pivot Table
Enable/Disable Worksheet Change Event code
Requesting return reciept in Outlook 2002 from Excel
Copy & PasteSpecial
Help with unprotecting worksheet in Excel 97
delete record using Macro in excel spreed sheet
Cancel Exit on duplicate
Animated gif
Array Formula (I think)
Re: Help with calculating elapsed times and formulas
Writing a formula in a variable
Re: Looking for VB code to test for "RING" , "BUSY" disconnects or other signals
HyperLink
Can Excel support Multiple Users
Excel 2003 not compatible with Office 2k Web Components -- HELP!
echo off?
Access AutoFilter list for use with input box?
Excel "integrated" in VB6
Pull Down Menu's
CommandBarButton click event
Cell Formatting - Continued
Count Down in Cell
How to sort pivot table?
Shortcut menu on worksheet tab
Analyzing code speed
CHIP PEARSON - THANX
Non Contiguous range and loops
Help on the Assistant Balloon
Balloon Assistant
Change "relative" to "absolute" (database)
populating a combobox on a worksheet
Backup file in folder
delayed worksheet.activate
Cell Formatting
Min Max function
show a value of X in worksheet
HOW ? Running a different Macro if value reached
Deleting worksheets in a procedure
Accessing document properties of non-Microsoft product files
Preventing use of buttons on the taskbar
Returning a date as a serial umber
Input from Text file
How to export a picture or chart from Excel to PowerPoint?
Excel Security
Problem while fetching Excel records?
Excel Visualbasic
Need lookup formula
Trim Special Characters (Japanese Environment)
How to get data from pivot table with multiple column fields?
How to sum value from master worksheet taking value from other close worksheet
More Visual Basic Syntax
Help: Visual Basic Syntax
Updating data automatically using macro
How to show only 1 series in pivot chart?
How to hide filter buttons in pivot tables?
File Read-Only Status
Creating new sheets (more detailed)
Another simple little problem
Sort command
paste as values syntax
XLODBC
Macro to Play Wave File
Excel macro to get stock quotes off the www
Dynamically Creating Sheets
How to locate a cell in the absolute A1 position
Unhiding Rows: bug in Excel?
Set Expiry Date in exel file
Percent progress
Global file reference change
Problems with permutation
automated macro's? and macro limitation to a worksheet
Change Numbers to Dates
Positioning the cursor programatically
Writing 2 macros to sort names and numbers in excel 97
Trying to limit .Find to a specific range
Combobox in a Message box
Copying Variables in VB Editor In Excel
Copy and Paste part II
Cut and Paste macro based on criteria then delete empty rows
Pop up messages
Sending files by e-mail
A real challenge...can anyone solve this !??!?
listbox
index
Customised Interface
Help on subscript out of range error (VB6/VBA)
checking if worksheet is blank
Copy & Paste values macro...almost there?
Excel hangs on close when using Web services in add-in
Fill Color each Row based on a Condition
Can anyone recommend a good book?
How to get Formula Tips to appear?
Query & Write
How to get Formula Tips to appear?
Sheet event doesn't work in '97
returning cell value based upon 3 criteria
My code replace the data by the line number
where is References dialog box?
Selecting multiple rows from listbox for reporting
Import File with browse and select (even from Pocket PC?)
Calling a sub from a addin in vba
Way to automate adding pictures in a series in Excel?
For Each Loop
Making a media library for movies, cd, book, so on
Background color for 50,000 odd-numbered rows
Excel97 versus Excel95
macro to copy and paste between 2 workbooks
dissallow characters
Recalculation of a spreadsheet
CodePane
Conver text to number in VBA
Transparently updating another workbook from the current workbook
Screen Flicker
Locking/Unlocking a VBA Project in 2000 vs '97 - Difference?
Export each worksheet to csv
Rookie question: placing a value into one cell based on a forrmula in another
create gif of selected area that is not a chart
Detecting VBA code
Worksheet Change event and Links?
find columns
Selection of the range filled in
function "count if color"
generic data entry form
can variables pass values
Detection of VBA code
QUESTION ON "OFFSET" !
Sample workbook
Simplified Help
Substitute Range Question?
protect / unprotect worksheets using VBA
userforms and worksheet help
use find twice to find cell on a specific row
Altering UI Programatically
find row
Sheet Event
display statusbar, scrollbars and formulabar
Read/Write data to/from text files from a spreadsheet.
Selecting a file path in Excel VBA using FileOpen dialog
How Can i sum hectars ?
Testing for open workbook
Please Correct the mistake
Pivot Chart - how to hide buttons?
How to add images to custom toolbar buttons?
Problem with custom toolbar
Changing a range number to a variable
VBA Row(line) No Syntax?
Removing an Item From a Collection
Excel no longer allows new formulas with division "/" operator
Re: Hiding a Combo Box.
Re: toolbars
Function to create a collection
Changing Data order in Cells
Returning the Number of Rows in a Recordset
OLE2 problem with the "formula bar"
UserForms setting radio buttons
Outlook
AutoSum button
More to Error in code
Error in Code
How Many Arguments?
controlling date entry in a text box
Need a method to extract the Date from a cell to a new cel
Finding if a cell is within a Range
Hiding a Combo Box.
Find and Replace - Auto Cell Formats
random numbers
Excel spreadsheet sort
VBA - Protecting from Save
Macro to use find command
VB and Excel in win98
Looping
Remove empty rows
Automatic next number in a series
File folder dialog
Combobox
Add event code through a macro
Finding Function
Dynamic range in graphing macro
Handling Excel Events in a Designer form in an ActiveX DLL
Excel Macro Problem, Add-in need to work in every workbook & Error:9 Subscript out of range
Controlling the position of attachments and Body Text in Outlook
Hyperlinks from UserForm Controls
duplicate #'s
Exporting Charts as GIFs
Problems deleting custom menu => double entries
Using Macro to update formula
Cut & Paste
An Add-in question
Need a function that finds a value in a table range and returns the cell number
Protection
Export values in a text file
Display a Recordset in Excel
Excel-Microsoft Visual Basic File Not Found
Import Text File Location
target address
Delete rows w/o criteria
Strip Modules from Workbook - Code Organization
Finding Excel Macros
Paste Values
Delete Cells in Workbook
Cell formats keep changing
Macro
Repeat the contents of a cell
Cell Address
Find a value a post data to another worksheet
Word doc opens, but not in visible window?
macros across multiple worksheets ...
Program a combobox/dropdownlist to create
Moving CommandBar using VBA or C#
How to Avoid Printing Blank Rows
Range.cells.calculate give error 1004 only in XP
Assigning add-in function to custom button
Checking if worksheet is blank
Create a Acrobat PDF file from VBA
Excel Crash
Font and Fill ColorIndex
2 Questions ?
copy sheet1 from all open workbooks to one workbook
Merge Cells
CALENDAR
How to make it a Concurrent (Multi-user) spreadsheet
Excel data recovery
Merging two och more recordsets
Code for locking windows
Saving one specific worksheet in a workbook
Spreadsheet opened by user or programme
Taking a subset of a string
secura a macro
Using Drop Down List Then Creating Saved File (with formulas intact)
Error 1004: Method 'Cells' of object '_Global' failed
a Formula for a culomn in all recors
For/Each iteration for collection class
How to change type of the cell?
urgent: no connection to excel
getting the column name
using vba copy data from .csv file into an excel spreadsheet
events
workbook open()
Anybody translate VB for PC to VB for Mac?
"like" string
vba macro for getting external data
Gathering info from a set of excel files
Count occurances of text in a cell
Problem with drawing graphs
Returning an array from a UDF to a column range
Filter
ComboBox
Subotal feature without labels?
Jet Ole DB With Excel
hex conversion
Calculating Elapsed time in a macro
LastRow issue
Send mail with attachment
Re: recherche et affichage d'une image
Filling alternating rows in a worksheet with color backgroud
HyperLink problem
Use code to cancel printing
Multi-variable Equation Solving
Lost File
Macro's scip Files!!!
Dynamiclly generating PDFs from Excel
Program a combobox/dropdownlist to create textboxes dynamically
Queries and Macros
Calculate years between two dates more precisely
Option Buttons on User Forms
Invoking Mail Merge from Excel
Increment sheet names
Excel Code Module
Turning off macro disabled pop-up
Disable Change Event in Form
XLA and strong typing
Data validation in a MSG box
Formatting Cells
Update Links
Excel 2003 and Peachtree
Unique Tag for Printed Excel Spreadsheet
Macro to convert date cells
Macro to convert date cells
Macro to convert date cells
Macro to convert date cells
Macro to convert date cells
Some simple code
Excel, VB DLL and Macros
selecting cells
How to create a message box to keep track of progress
XlPivotFormatType ???
Keep large numbers from truncating?????
Mining an array
Program a drop down list to show a specific response depending on the selction
Function that emulates FIND(find_text,within_text,start_num)
Assigning Macro To Shape
Unpaid overtime?
variable that refernces the values in a text box
Personal.xls
oops!!!
Generate XLS on server without Microsoft Excel
How do I protect my hidden Excel.Application object from unwanted user interaction.
flashing screen driving me bonkers!
creating a hyperlink in a shared workbook
how many combinations in a list equal a certain total
Deleting sheets
MACRO TO UPDATE DATES !
.net, excel, extended properties and dbnull
insert validation in sheet
How can I hide the code??
Deleting Many Cells on a Sheet
Circular References, what a nightmare.
Hide rows if formula result is zero
Delete #N/A rows Formula
Re: Selecting cells with a particular formula
Re: Selecting cells with a particular formula
Re: Selecting cells with a particular formula
default printer
Easiest way to automate spreadsheet merge?
In Excel VBA, open .txt with Word?
program activation
Name field value
date extraction howto?
print form orientation
Date Validation
Selecting cells with a particular formula
Zoom problem
dates in dropdown
edit default excel template
[excel 97 vba ] Reading ranges into an array
Report Question?
setting up a workdirectory
Error 50290: Error writing to Worksheet while using an ActiveX Control
Empty toolbars
Calling macros width arguments in winxp
ByRef not passing address
start a macro when file opens??
Using Find & Replace in macro
Protected worksheet and macro
Find "." (Full Stop) in cell then all text after colour blue
extracting string from value in cell
Paste Cells in Column A to Columns B-K
Dir() limited to 48 files?
xlDialogSendMail Error
Replacing a value within a string using a formula
extract a foldername with a formula-update formula does not work
Code security
extract a foldername with a formula
SaveAs,csv
autorun userform from worksheet
Excel cannot update web page
Programming Xml Source Pane of Excel 2003
Saving a graph as .jpg
Add-in auto updating
copying rows
no connection to excel
file extension problem
Macro run slow when turn on ScreenSaver
question on button event
Text Box for Numeric Data
Delete rows after used cell?
Convert Excel to PDF via VB code
Changing color of cells
Countdown to Retirement
Closing a Window
Point of departure...
XLA & COM files
Import Text file into multiple columns
Copy insert rows
Menu commands - overruling with macro - How to do it?
Detecting non-supported files using Excel.Open
Proper method for Excel/Query/Macro reporting
Re: Looping
determinate if a range is empty
Excel error message in protected sheets
Referencing other workbooks
removing unwanted characters in a cell
Re: Looping
how can I lock a file after some days of using it??
Sum of cells spanning several worksheets
Workbook references
merging templates into workbook
xlDialogTextToColumns arguments
excel control button
Sorting 100 rows of 6 records horizontally
Re: recherche et affichage d'une image
application.worksheetfunction.mmult help
Replace return of line by a space in VBA
Run time error '1004'
next avaliable range
Visible Rows Indexing
Closing Excel
File List Creation
Control IE popup from excel VBA instantiation
Accessing External Data
Macros
work schedule formla's
Setting Excel toolbar or menu icon in C# WITHOUT using builtin icons
protection sheet and code ???
Unable to suppress warning message...
recherche et affichage d'une image
Add-Ins and Pocket Excel CE
How to Retrieve Last Used Cell In Column
Range.Select with variable cells ?
Exporting to Excel, Then Formatting Columns/Cells
Excel to Access
embedded objects
Changing Event Subs of Controls On Air
Open Menu item "Print" from VBA
Re: Access to Excel
Re: Display a message whilst a macro runs
Adding toolbar/menu command to Excel using C#
Preventing opening workbook inside active workbook.
counting occurance of a name in a cell
Pie chart programming
Help with a macro. Let's eliminate a loop...
Creating Boolean Functions
Protect macro code from viewing/editing
makro that sums every new number entered in cell
WEB BASED EXCEL REPORTING
TCD Format du Tableau xl???
Auto Open won't die or go away
Uploading Problem
User form question
unprotecting a combobox in your spreadsheet
check font colour
VBA code to open a specific worksheet
Case sensitive data
worksheetfunction.vlookup?
xlDialogSendMail problem
Delete #N/A rows
Button
Improving code.....For Next
Moving Vertical Page Breaks in Excel via VB
Minimize the VB form
Copying a named range of cells
'Floating' UserForm
Add control at run time.
Open workbook without activating it
Minimize the VB form
Searching unknown number of cells for a value
Toggle Button
access function description from c
access function description from c++
access the function description
Print Excel Workbook When Open
Automated Printing
spreadsheet calc
deleting variable number of rows
Renaming files
Disconnect a spreadsheet from its datasource
Compile Error in Code
Excel Test Formula
Stock quotes:Excel
How to update pivot table items?
Need FASTEST way to get data from a large closed Excel File
Reading specific digits from a numeric variable
Using "Find"
Delete columns
Determining range
Application Process-Shell Command
Re: Display a message whilst a macro runs
file name
worksheetfunction
Print multiple worksheets
events
How to change image by function?
ASSISTANT FILENAME
Macro to play wave file
autofilter using macro
Yes_No
Excel and preparing email
macro & combobox
copying and pasting not adjecent cells
Code slows on subsequent run
assigning a formule to each cel in a column
Path Not Found Error
In a Cell, How Can I Make The Cursor Go to The End?!
vba multi threading
Get Last Row
CONVERTING A LOTUS MACRO
VBA code to insert images in excel sheet
multilple sheets using days of curr month!
Conditional IF statement
Auto Refresh/Format a PivoTable
Ontime questions
Macro execution refers not to the active sheet/excel file
VBA Code to convert Excel to PDF
How Can I Use SendKeys in MAC EXCEL?
Templates and CreateObject
Assigning formula using a macro
code lost after saving
Updating form labels from code in a module
Application Size and Location
Excel Marcos and Programs
proprietary protection
Transferring data entered into a Text box to another Cell/Sheet?
hlookup in VBA
list worksheet names within a notebook
Need Looping Help
followhyperlink failure
How would I modify the following?
Worksheet value to user forms
Setting attributes for controls
Automating Excel (XL2002)
Form Resize
Worksheets.Add method
ONACTION macro tries to open another workbook
How do I use a Combo Box to change values in a Cell.
Disabling Toolbar Buttons with no open Workbook
PRINTAREA
detect worksheet
copy a mocro to another pc. HELP!!!!!!!!!!!!!!!!!!!!
Open WinZip from Excel
Selecting single column with merged cell at top
Looping Find
Delete Rows below a certain cell
Set variable = nothing?
Creating a Dynamic Function
TextToColumns Dialog
Saving VBA Toolbar Customisation
Help with Macro
MESSAGE ALERT
Random Number Formulas
Printing Mutiple workbooks....
Printing to Generic / Text printer
Visual Basic to reference value in Excel cell
MACROS
Help Excel for Second Edition Windowns 98
UserForm remembering Settings
Listbox9 does not support saving.....
Executing a Script on an Oracle DB
Counting files using Loop
Counting files using Loop
Counting files using Loop
menu in excel
Start recording macro
Anomaly, can't format cell
Changing cell formulas with a macro or VBA
Load Macro at start up?
Re: @ Round Formulas
What is InBufferCount?
Re: Delete Rows above a certain point
Conditional find
Re: @ Round Formulas
Linking Excel to the Internet..
List Box Visible Rows Only
Maintain Target Porperties in MS Excel
Insert rows
Sort to Various Sheets in Workbook
Send file automatically
Tuning Off Toolbars
sumif
Loop through sheets, deselect charts
adding a listbox to a spreadsheet
code Help - Routing Recipients
Comm 1
Can anyone solve this!?
Comm1 not opening
Help Retrieving Cell Values
Paste a Range from a variable
Printing to Adobe without getting promt for name
macro & comobox
Web service reference Tool 2.0 -
VBA code slows to a snails crawl when screen saver activated
Revised Question on Page Numbering
Offset Formula Question
excel 2000, vba and msquery(sql)
Annoying "virus" alert when using code to send mail
Excel 97 automatic cell format
how to trigger macro or force autofit
Calling Macros oustide current module
Holloween Mystery: ghostly blank cells
Email from Excel..please help!!
Formatting a date as a serial number
For Next with step
Re: Page number question
Re: Page number question
Re: sheet collection
Check activate sheet
formatting ques...
How to force a recalculation of values based on custom function
How to write an importer/exporter for excel
Another Tuesday Task
Tuesday Treachery
Creating a Master Sheet
Pb en VBA Excel
Problem with Legends in chart
Cheque Writer in Excel
Before DoubleClick
OLE
toolbars
Insufficient memory Caused by Pivots.
Compare Worksheet's
Autofilter hides totals I want to see
Problems with ungroup
SQL Multiple table joins in VBA
Problem hiding/unhiding columns using combo control
Create customs define event
Making arrays outside cells
ActiveWorkbook keyword seems to fail
Specify a folder for saving to?!?!
Cell format
Excel formula
Format column auto. to "hidden"
VBA code 'find next'
Rounddown problem in VBA
question on the definition of refer to
vba or function
Difficulties in VBA ( User form and option button)
Running Access MAcros or VB modules in Excel
Flickering of the Screen when the Macro runs.
Adding Modules
Userform question
Global variable
Pointing to the Correct Directory
Pivot Table: Hide Items Poperty
Custom Menu
Form question
Import External Data incomplete
Help with a Combo Box Change Event
Over ride double-click handler?
Run-time error '430' / Class doesn't support Automation
References in VBA macros ?
Help - Change Event triggered on File Save As
Any difference between Sheets Activate and Select?
Using Excel through COM
using mappoint in Excel VB
ATTN: VASANT
How to display contents of a cell in UserForm and take input
ranking the bottom of the table
Automation
List of GUIDs and other properties for future references
Create named range
Getting to the Function Explanation Programmatically
Opening a CSV file
delete rows
Copying Cells
message when saving workbook
Automaticaly Emailing A S/Sheet ??
Nedd help on my function in VBA
Templates
Still Stuck
SQL Statement
converting 16 digit number to text
Re: Macro 'Automation error' with ChemOffice Excel macro
Changing a cell color....
Excel 2002 and Excel 2003 VBA help screens
Collectiong data from SQL server / Repeat!
SP3 removed Macro Security option in Excel 2000
How to set a time for the next 1/4 hour
Operation Is Not Allowed When The Object Is Closed
Add columns of data in Excel workbook to fields in MS Access
My Macro keeps stopping??
Filtering
vba programming
Detect workbook events from .XLA
How to conditionally sum values depending on values in other colums
storing numbers within the macro
Date/Time - String or Number!
Re: vb to copy conditional info.
Using Excel to generate Word macros
Connecting to comm 1
On Error
Connecting to comm1
restrict entry in a textbox to a range of values
Is there a better option than Getobject to access a .xls?
programming font color on select items
Conditional number format of cell
Using VBA with Shared Workbooks
Pivot Table Macro in Excel 2002
run a DOS .bat files under an excel macro
Excel vba printout method
Importing data from text files
User Defined Addin - Urgent Please Help!
Macro Monday Blues
Determine active file size
Linking Cell Comments!
Using VB to fill a formula down
Associating a macro with a button
Emptying the copy buffer
ActiveWorkbook reference fails
Maximize minimize and restore button
Run command when hitting ENTER on list box item
Modify generic dialogue
Print data from FlexGrid
argh, can't get it to work
Msgbox help
how can i copy a macro to another pc
Sum Function
Range.column
variable range: l just can't get there!
Populating combo box with a function
AutoComplete in a List
calculation multiple row & colums
User access to the VBE
Ending a routine
VBA code to change the Print - "Number of copies" to 3
Prevent users from using AutoFilter
Excel help + VB
#DIV/0! criteria
worksheetname in a cell
Spreadsheet documentation
Option Button and forms
MACRO QUESTION
Sendmail Macro
Working between Worksheets of the same workbook
Excel on the Web
Why doesn't this work...??
link a cell into a vba form
Worksheets.Add
looping with formula inside
Stopping a macro without using Ctrl Break
VBA: how to force another instance of VB to run
Difficulty hiding check boxes
Formula
Shapes.. trying to print a square square
How many CR's in a multi line texbox
Array Formula
Restricting use of menus and toolbars
Re: Publicising Benefits of VBA
Use VBA to open an Excel cell for Edit
Last question I promise
Disable ALT KEY
UsedRange & Formatting of Cells
tabbing round a userform, whole field is selected
Userform Textbox Currency Format Problems
How do I remove toolbars and specific menus items to restrict use?
Formulas
REQ: I need help working out this function.
AutoFill Method
Looped process
Changing cells temp.
ActiveX Warning Message
Wordwrap wont!!!!
Resizeable Rectangle
Add & Delete Records in Excel using a form showing a scrollbar also!
refedit query
Too Basic A Question
Using Solver within Macro
Creating a Function that references cells to other cells...
Run time error 1004
handicap predictions
Sum at point of change
Row Heights
true 3D bar charts possible?
Is it possible to set a class member to be another class member?
Re: Customisation of Chart Dialog
"Run Time Error 1004 Application Defined or Object Defined Error."
Windows Media Control and VB6
Newbie : Combo box on cell ?
MACRO TO REPEAT FORMULA
Page Setup for multiple sheets
Excel Data Sort - doesn't. HELP please
How to make a sheet the active sheet?
Missing Security option in Macros
Assign a variables value to a TextBox
How can I avoid a BLANK cell being interpreted as a ZERO?
setting tab order by code
Printing with reference to current PC
Let me have another try
Determine range with VBA
Macro slowing down after a while...
Inputbox to return address of cell selected by mouse
Inputbox used to return value of selected cell
Sum
Array Help Needed
Reliably get sheet 1 of the active workbook
Append new row of data to range
Create Excel Macros
In unten stehendem Prozedurausschnitt soll an Stelle des Feldes 'name' jenes Feld eingesetzt werden, das in der Variablen sortierKriterium steht.
Ambiguous Name Detected
Comment Box
A very simple question....
Disabling Minimise/Restore Down buttons
Format text in Outlook from Excel
Code for modify a column
can we start form by clicking hiperlink ?
How do I use Workbook.Add
Attention: Leo Heuser
queryinterface error in vb.net
Disable "Save" &/or "Close"
Not sure how to tackle this
RE: C# and OLEFormat.Object
Count Cells containing Text only
Is this NewsGroup Operational
How to return a XL97 spreadsheet info to the requested web page?
my script wont post, unless i hit a key..
auto open a workbook
making a cell fixed number to a input number
Opening a workbook minimized...
ReDim an Array
Export to text with custom delimination
Code For Expiration Date
Basic VBA question
Add-in installation on Excel 2002
How to uninstall XP PIAs
Grouping Option Buttons
VBA: Userform Access
Cell Edit
unwanted concatenation
Pausing a macro for user input
Excel/Windows 98 second edition
Activating workbook with variable Name
Changing PivotTable source
Maintaining Column Widths in CSV Format File
relative reference
How to keep Excel sheets on a database?
DataCombo control...
Tab Stop Broken
macro for conditional formatting
test
Publicising Benefits of VBA
"Not Enough Memory" new macros problem
Changing the Hyperlink in a cell
Open all linked files and close them.
Selecting Rows by Column Value
Dialogue Boxe
Excel outline showlevel
Error 1004 - unable to set the orientation of the page setup class
More Macro Madness
VB backwards compatability to 97
Copying sheets
SPSS Excel
Excel Compiler - is one available?
skipping text formats
Wish to parse through a text string to find data
How to Insert Picture in Excel?
Can anyone find what is wrong with the following?
Modifications to Permutation Macro
Macro warning when no macros in workbook
offset property to define range
utility
Link .xls cell formula to .xla function
Autocomplete (?) in code not working
Parsing Full Names of varying lenths and parts
Library missing..
Excel won't quit
Proteting against a button press
Combo Box - Can I Concatenate the list?
macro for timestamp option button
DATEPICKER CONTROL
How Do I...
Parsing Shell Command with Parenthesis
Delete rows if they are empty
Simple macro - help please!!
macros disabled after apply SP -3 to excel 2000
Dropdown Rowsource
Disabling/Enabling Macros
I need to validate with a formula
Having trouble with formula to automaticly enter data
MS QUERY w/out querytable
Saving CSV files in Excel macros
MS QUERY
Gray background is shown when loading a workbook
Documentation & testing
Path
text in listbox
"TEXT" numbers - count problem
Referencing Cells in Macros
Combo Box becomes blurred
If value betwenn 0% and 50% than yes
excel problem
How do I use Workbooks.Add
repost: Listbox text align
Msgbox
Formula using VBA
Replace Standard XL workbook icon