Excel Programming [Archive] - Page 138

Compile error
Upgrading Excel 2000 to Excel 2004
text to columns
Re: Seperating 1 String into Many strings!
Re: Seperating 1 String into Many strings!
Solution: How to programmaticaly leave "edit mode"
Highlighting Duplicates in a List
Excel to Powerpoint Slow Execution
creating a text record from a number preserving the leading zero
Quirky Button
Worksheet_Change and Workbook_SheetChange not firing
Half of the code works?
Assigning Macro Problem
Add-in Toolbar - Respect Customize... Setting
Keeping leading zeros in field
creating a text record from a number preserving the leading zero
Run a macro in a workbook through VB6
Code to trap data entry outside of range
Acrobat Distiller: start if not running
Re: How to turn on Personal.xls
Re: Comparing String Values
Excel VBA array of checkboxes
Click on worksheet with UserForm open?
Refer to another Sheet (Easy)
Re: How do I create an "IF" formula?
Re: How do I create an "IF" formula?
Command Button Behavior
Code not hiding columns
Adding columns
Subtracting time in excel to show in minutes:seconds
Freeze Worksheet while macro runs
Delete columns
RE: Workbook naming
excel help
Re: Alternative to Application.Match
Re: is there anyway to call the Solver add-in as a function?
Re: Application.Match
Date counting
Re: How do I track amount paid per Ticket?
Re: Date counting
Selecting sheet
Alternative to Application.Match
comments
Re: Copy/Paste Macro & Formatting Issues
RE: Workbook naming
Re: Comparing String Values
Open Excel file through Fortran?
Re: Comparing String Values
Re: Still Having Application.Match trouble
Highlight a selected toolbar in a menu with a checkmark?
copy many files into one
Workbook naming
Assign cell value from VBA function
Distribute Userform?
Tab Search?
Re: Modeless Userform problem
Screen flicker despite ScreenUpdate = False in the first line of code
Assign cell value from VBA function
Multiple Workbook Data Combination
HELP!! very complex formula
Intersection of Week
Array Question
Ading color to difrent cells
Re: is there anyway to call the Solver add-in as a function?
Re: How do I import data into a template
Date entry using a macro
Copy into Row holding Button
Calculating totals if a condition is met
bug listview?
Macro execution limit
Find Macro
Re: Custom Save Button
Way to free memory as I input lines from a file?
What's the difference here?
code works in excel 2002, but not in excel 2003
Finding the current "print range"
comman button macro can't open worksheet
Close all other workbooks but this one?
Sorting data by Cell Colour
How to make my FORM usable across multiple worksheets?
NumberFormat vs NumberFormatLocal
Excel 2003 VBA Help - Missing Contents
Multipage control
Insert picture
subroutine to concatenate strings
Standard "Open" and "Save As" Buttons
To fetch the values from the excel cells into the variable
importing several text files into different excel worksheet
Macro buttons
Re: Macro written in Excel 2003 and saved as Excel 2000 .xls
Find Unique Entries
Grouping in a chart (Gantt Chart)
UserForm collapse ?
Source of value passed to class object
Still Having Application.Match trouble
DDEInitiate to MSAccess problems
Invoking a workbook from a Fortran Program!
Adding a check mark to the custom made toolbar/menu continue......
make selected item highlighted in listview
Duplicate Records in Excel
Find Duplicate Entries
Finding latest date
Re: Application.Match
Plot 7 bars and 1 line on a chart
Activate last cell in selected range - an example
Re: Application.Match
select range from code
Log entries, web entries
assign macro to delete event
Re: Application.Match
making autofill range dynamic
Application.Match
Programmatically Add Worksheet Event
In outlook,how do I show the whole number 5.00 with zeros?
How do I import data into a template
How do I import data into a template
How do I import data into a template
Re: 2 spreadsheets
Insert Columns
Re: How can I move to another cell two rows up and 1 column over in VB
Re: Is there a better way (with less typing)?
Re: Is there a better way (with less typing)?
max/min of a selected range of cells
Help wanted with computation
Re: Arrays and Strings
RE: Trigger an event on Checkbox change
Re: Finding a series of values within an Array
Creating a Function
Row Deletion
Re: Removing Workbook_Open code
Re: fill row color on a specified worksheet
Removing Workbook_Open code
null text box
fill row color on a specified worksheet
Macro to Find Cells with Conditional Formats
Re: Finding a series of values within an Array
A stopwatch to record time in a cell
Filename has Url in file-save dialog when saving exported Excel do
Loop to Next item in For Next on Condition
Custom Toolbar
Re: Finding a series of values within an Array
Providing Estimate to Complete Info on a Process
Using a macro over a number of sheets (Redux)
Arrays and Strings
autofilter
application.worksheetfunction. <function> (syntax)
Finding a series of values within an Array
Re: Better Way to Use OptionButton
Use of Indirect function
Open hyperlink in new window
Validation with offset range and other?
Trigger an event on Checkbox change
Better Way to Use OptionButton
msgbox (2 questions)
Could not load an object
How to "translate" that in VBA ?
Scroll Wheel not Working
Custom Toolbar position
Re: Function Argument
XL2003 VBA Add msoControlButton BUG or Feature?
Re: Removing macros using VBA
Re: Removing macros using VBA
Re: Removing macros using VBA
tab direction
Re: Error Converting Passed Range into Array in VBA for Excel
Excel VBA -- Finding last row in group of columns
Filling Database Query
Interfaces for VBA Forms
Re: Formatting in cells
Insert Row without Selecting
Re: Color a cell
Code Centralization
Re: Color a cell
Can you "duplicate" "copy" listboxes and code to multiple cells?
Re: worksheet last updated
Re: stop screen refresh
Batch Open and Save
Behavior of Today()??
Re: stop screen refresh
Selecting row data for chart - Not sure what I did right
Re: stop screen refresh
Re: how to call a function with variance which is function Name
Re: Find a cell when Excel opens
populating listview with array
Linking a multiple page spreadsheet into PowerPoint
Using a macro over a number of sheets
Saving a chart as a JPG file
Mod operator
Retrieve variant array of cells as formatted in the cell
Range.GetEnumerator() from .Net
Highlight a selection from a menu, urgent!
putting in todays date
Do not want sheet renamed
Assistance in VBA
Checking range names
Entering Array Formula
Excel 2000 to excel 2003
Word Wrap
Looping through (active??) cells problem
Re: VBAProject Password
Help!!!
copy cell contents to a textbox > 255 characters
Syntax when referring to self
typing difficulties
Protecting values of variables
Filesearch : .zip files not found ???
Macro to delete line
Best fit
listbox default datatype
Populating Column Headers in a ListBox
Goto Command in Code
Re: etyping difficulties
Workbook Open - Prevent CTRL Break
Adding module - assigning macro to button
Excel Formatting Cells Using VB code
Macro to run on openinng worksheet
track cell changes
Re: Looking for books on Pivot table
Passing Worksheet tab as an argument.
Excel as a service ?
statement for.... to
Do combobox allow user to enter text?
select a list from several worksheets
excel fit to 1 page shows 1 page but not all data is on that page
Static Macro in Spreadsheet
How can I use Analysis Toll Pack functions in VBA?
AUTOMATE DATE SELECTION, PRINT, PDF
Worksheet_Change wont Trigger
ENTER DATE, CHOOSE WKSHEET, SAVE IN FOLDER
How to query the controls in form using vb
A bit long - but please help
Select/Copy/Paste in Macro/VBA
Delete an Item in a list box
Writing to a closed workbook
Combo Box
Excel to VBA
Deleting macro code programatically
Chart size/position
Multiple row selection
Call subs from another wkbk?
Group items
Re: ActiveWindow.Width no longer works for me!
Re: Error Converting Passed Range into Array in VBA for Excel
Highlight a selected toolbar in a menu!
Format cell
Passing a String in Array to Range as String
pass argument to macro
QDE (Quick Date Entry)
MOD function
Tabs
sql connection in macro
links updating
Re: ADO
Tab Order for an Excel Form
path to current file...
Re: Comparing to Arrays
Cancel option possible while opening a file?
Type Mismatch error
formatting in a protected sheet
number vs text format
Automatically include contents of a cell in "Save As..." filename.
return a value from a dialog box
Macro query - finding mutliple occurences of text in a column
Re: Comparing to Arrays
finding the last cell with content
Turn off file numbering
Picture Editor for Excel
Changing range names in VBA
Google search from excel
MsgBox & String 3
Open workbook and paste formulas in another
Public constant in many workbooks
Timing problem
Visual basic Userform caption
Re: Comparing to Arrays
Re: Comparing to Arrays
Re: Comparing to Arrays
cell/column referencing and plotting data
MsgBox String 2
epxort to excel removes trailing 0's
Declare an Array() ????
Re: Reserved words in Excel VBA
VBA File in EXCEL 2000 Crashes in code that I have made no changes
Userform Info
form wont show or load
MsgBox & String
If Cell1 has something Cell2 is blank?
Re: searching for vlookup equivalent in VBA
Shell command in VBA suddenly stops working
Excel worksheets and VB .NET
Installing a button with VBA
Having file name on the excel sheet automatically
Path and File Name
Apply conditions on Input box continuation!
Subdirectories
Import Data
Re: Calculating a auto filtered range
Run Time Error 9
Import Dropping Leading Zeroes
SQL in Excel Query
Excel / XP SP2 / Web
Deactivating worksheets
Average of one range based on date in one column
Comparing to Arrays
find, Match, Copy from onesheet to other
Re: Protecting the code
Would a loop work?
Incorrect column expression
Variables
Addin working on all sheets
Re: Deleting nonactive Sheets in Excell
direction needed
Re: Deleting nonactive Sheets in Excell
Excel VBA Write to xls ?
Excel VBA Write to xls ?
Re: Protected sheet
auto-fill information
Re: Referencing cells in another workbook
Re: Referencing cells in another workbook
Color Cells via VBA
Signing VBA code within an Excel spreadsheet from VBA
Sheets arrays
Error when trying to use QueryTables.Add
Missing Post
Read excel data programaticaly in C/C++
identify 'save as' of the commandbar 'worksheet menu bar'
ClearContents - Except NamedRanges
SOLVER- programming or not?
Can't find project or libary
Does Excel Support Java?
About Page Break
Moving between textboxes
can I sort colored cells?
Takes long to save the file (Speed problem)
Excel VBA - Problem calculating and passing values to another worksheet
Macro to hide multiple rows
A1 style Range in programming
Re: Randomize three variables subject to sum always equal to 1
closing a userform
Randomize three variables subject to sum always equal to 1
Macro for Excel page Customization
Excel – Macro Problem – Find/Search and Insert
worksheet save
Recording a macro to open a large fixed-width text file
Order of open/close
Is there a way to simulate a 'Hide Column' Event?
Excel 2003 multiple regression coefficients inaccurate
Re: Locating Cell data and corresponding Max data
When i close a object 91 error shows.
ListBox (finding Repost) (try to line up my example)
pivot table+put unique data in 'row area'+count of items in 'data area'
Acquiring a single recordset from Access into Excel
Mk Dir
ListBox ( finding supporting data not in the list)
view datagrid report in .xls or .pdf
Vlookup in VB not returning anything error
Re: Help setting a print range in a data sheet
Re: Help setting a print range in a data sheet
listbox saving ?
How to apply conditions on Input box?
Macro to move the cursor to a different cell on the same row
Re: Macro - Format Spreadsheet
open & save old xls file
Initializing Userform
Can I split&write data to each individual sheet?
Runtime error 1004 with method OpenText - but only on one computer
dumb question
Re: VBA-writing a macro
Re: Change list to hyperlinks
Object Hierchy
how do I update a spreadsheet without duplicating records?
TimeStamps
formula to see if cell contains one of two text values
Setting up a formula
Rename Worksheets to Sequential Dates
Looking up blank cells and transporting data to another worksheet
noob: problems with macros in invoice
Re: Change list to hyperlinks
Update Links
Sub or function not defined error
Displaying Formulas and Values of the Same Cells
Update cell values after cell is changed
Excel macro: Speak on enter
ActiveWindow.Width no longer works for me!
EventClass Module
DELETING BLANK ROWS
Reason for past posts being removed
Type mismatch error
Private Sub Workbook_Open() not running on open
sheet reference
multi selection list as text?
Question for Alan on QuickSort
Re: Workbook_BeforeClose
Named Formulas-Excel Modifying Them
Re: Nested Subtotal and Macro
Database Connection from Excel
opening multiple files from within a macro
Displaying a message when macros run!
Find exact values
Best approach to this problem
Msgbox
A question about Cells & finding the Week
Log File using VBA in Excel XP or 97
How to get Row & Column in Excel 2000 VB?
Opening a Database from Excel
Import Data
Courtesy
error: "sub or function not defined" what is it trying to tell me?!
WorkSheet.Delete
Saving a woorkbook as a TXT file keeping its current name
Re: Rounding Time
Function, Calculation of Standard Deviation of levels
Re: Macro
Re: Formatting toolbar
Excel VBA - Printing a sheet rotated 180 degrees
Best way to add Multi selection box
NEGATIVE HOURS (3)
Line Broken Transfering data to Word
Start VBA with a macro?
Re: mkdir problem
Export range to text file
dropdown lists
QN: Webpage Hyperlink in a UserForm??
Re: Programming to VBE
formatting cells
Re: mkdir problem
Pivot Table Grouping
Referencing specific cell
Re: Programming to VBE
Macros not getting updated in personal.xls!
Re: Programming to VBE
multiple cells in a loop
Re: How do I open a Form in Excel XP
Excel Functoin getting Cluster status
Adding a drop down list
Expanding Selection Range
Newbie Help
linking to web page
macro
Pasting in a unique row for each unique date
Help with grouping values
Rounding problem (controlling word from excel)
Checking Cell Background Color
ActiveCell.FormulaArray code - Get error
Importing a txt file to a ComboBox itens
Watch Window
Need macro that selects an item off pivot page filter, prints, se.
ambiguous error
Little bit of Java in VB?
Need help with figuring running totals
Lookup external data by cell or range of cells
drawingobjects what is it ????
Validating from a list workaround
SpinButton Controls in Excel 2000
ComboBox
Header/Left margin
GetSaveAsFilename - Save as box
Selection based on coloured cells?
Macro
Mail from Excel 97 via Notes 5
Calling Microsoft Excel ODBC Query
Possible to write VBA code to send out an EMAIL everytime a workbook is opened?
Trim: Excel 97 gives error "Can't find project or library"
How to create controls at runtime
Read from an Excel file
Help with my code and formula
Excel User Group, Sydney, Aus
File Open Take a Long Time
more newbie help on my significant figures function...
Resize Range Question
can we add a blank line after every...lines?
Protect worksheet
Reading from an Excel Document
Runs possible on the background?
Importing into Excel
Sorting Using Code
HOW DO I IDENTIFY DUPLICATES IN A COLUMN OF NUMBERS
VBA - Closing Outlook
Microsoft Office Word has encountered a problem when shutting down
VBA, How to open a file with date like 29 August 2004
pls help newbie with my significant figures function
RE: mswinsck.ocx
ActiveCell.Formula
import simple data & re-arrange it
Sending Excel Data to a Coldfusion Form
ListBox "picking the same item repeatedly"
protection with password
Excel Macro Query - Search for specific text in cells of a column
Missing a library in menu --> extra -->references
Not sure how to handle this
worksheet function in VB
matching dates from imported *.dbf file?
how to add items to combobox
Worksheet functions in VB
To reformat a culculated date/time round-up to the nearest ½ hour
Lost Focus - Applying to cell
Clearing TextBoxes needs 2 clicks
VBA macro to obtain file names using WIN32 API
Is it possible to open the VBA form with a link in a sheet and to pass variable from a cell to the VBA form?
TEXT TO COLUMNS
How can I create a URL with link using the VBA form.
How to create the URL with link using the VBA form input in excel?
checking if file is saved
Can you Limit the number of caracters that can be typed in a cell?
Method 'Range' of Object_Worksheet Failed
Is it possible?
new message scroll bar missing
Filter Listbox in user form
trouble linking formulas, because format continues to change
auto run macro at workbook open
making new wkb and place an event in it
Comment extraire et traiter les donnés GPS
sending email from excel using outlook express
Please advise: excel's mathematic solutions
Programing Dialogs in Excel 2002
Programing Dialogs in Excel 2002
press letter and go 2 entry begin w letter in data validation drop
copy from a list
Verifying lines with other workbook
excel VBA
open word document
Removing characters from a text string
Re: Histogram
Excel VBA
just testing
Vba - getting value from other userform
almost works
Macro - Run automatically every X minutes
how to connect to already open excel sheet
where is the _IMsoDispObj
peek and poke using vb
Check cells in a column
Initializing static variables in VBA
How to optimize and improve that code ?
Reading conditional format that is active in VB
Checking if autofilter is on?
VBA Code to switch view
Re: msg box while operation is running.
Qn: SpinButton1.Max not working??
how do I delete a workbook
Print area
Cell Naming and Formula bar Display
Pointer required
Counting Values
Choosing a directory/file
Re: Excel/VB Copy/Paste of Graphics
Question about opening workbooks on Excel startup
Selecting a Range of cells in VBA
Help with Reducing Numbers Please
Re: Histogram
RE: replace a formula with it's results....need help
Excel's Sort Order
Copying sheet to another workbook using VBA...
writing a formula containing if and and
Referencing Code from another project
Autofill last row
Find word and copy
Deleting Macros
Date format in macros
Are all the old posts gone for good!
How can i set up the alerts on the desktop ?
Starting Inputbox focused?
Data Validation
Open or Show a Message Box on open...
Excel - Customize Default Color Palette
Running a Macro from hidden Workbook
Re: xlodbc
Please Help with a macro.
MsgBox Prompt w/ No "X" to close
Excel 2000: How to execute code automatically?
really simple question
Import PDF
Problems opening a text file using macro!
Excel Question
Macro to open another workbook
add-ins
DateAdd
Step Thru Formulas Macro
Copy data
Running Macro from objApp Application object
Missing something? does not count correctly
UDF not available
macro advice
Make more than 1 selection from combobox send to another sheet
Auto create unique accelerators for a list
Formatting all worksheets to fit on one page each
Copying a chart
Installing Add-in for all users in Win 2000/XP
How do I use tabs in a macro?
Save files as different names
macro question
Re: How do I use tabs in a macro?
VBA Form Drop Down List
Macro it's very Slow ....
Linking userform to userform in Excel 2003
Cut cells from column A that contain "/" Paste them to column B
Copy/Paste Macro and Column Sizing
Master List
Saving txt files and date format changes
Re: How do I use tabs in a macro?
Re: How do I use tabs in a macro?
Re: Nested function 'FIND(OR)'
Forms
Use Keyboard with Command Button
Excel.......Automate importing multiple changing CSV's
Errors on other PCs
macro to update page footer number
Offset Between?
Querying data from an outside table
Options in Cell
msg box while operation is running.
Directory contents
SelectionChange or Defined Name Selection Difference
"Last modified by" in a cell.
can't do Find or Replace while Modeless form is shown
Re: Creating directories from excel
How to?
Automated charting VB code problem
Can't browze and open file, urgent!
arrays in arrays
Change back round color of a cell w/VB
formula help
Application level event handler broken in 2003SP1 ?
Protecting my macros from being viewed/edited?
NEGATIVE HOURS (2)
Excel 2002 VBA connection to Access 2002 using SQL
One works - One does not?
fso.FileExists is too fussy
Cell Change
Any easier way than looping on ranges
Excel 97 ADODB Recordset.Find "Invalid Use" error
Qn: Setting MultiPage page default???
Qn: vbOKCancel -- Cancel doesn't work??
Comparing two lists
List unique
Stored code
call excel macro from access
dynamic data lookup by cell
Detect Password Protection
Help
Simple Q about font color
Evaluate or WorksheetFunction Problem
Macro to change text colour
making a group visible (or not...)
XL VBA adding new worksheet if current worksheet is not empty
Excel VBA - If Else problem - HELP PLEASE
how do i have multiple inputs and 1 output
Convert to PDF
Calculation of peak / off peak hrs v2
Left/Right Header/Footer Text Margins!
Re: Having input the current date in a cell I want to lock it
Macro doesn't work in Excel 97
Change the File Open option in Excel
Calculation of peak and off peak hours
Error in macro, that opens a file!
Sorting data and retaining additional information with value, not
Extracting a dynamic range
insert 3 rows before any text in column A
Using "End" to stop all code
modified time of a worksheet
Re: Intellimouse Wheel Event
Macro to delete rows
Format Same Length Always?
Populate Listbox with File Name Only
vbCode to Link a picture to a user form rather than embed it
help in showing results of database query
Link to Public Folder Post?
Code Help
Adding control in VB
Macro moving down the sheet cell by cell
Creating a chart in C#
Re: Need VB Coding Help for a Macro
truncating a number in VB
Re: Need VB Coding Help for a Macro
Finding Matching Records in a Column
Can someone work their magic (Good SS that I wish to make better) - Lancefer's Pop ME '03-'04 Temp.zip (0/1)
Asc character
Re: Having input the current date in a cell I want to lock it
Cannot copy a sheet
Re: Intellimouse Wheel Event
TextBox not responding...
Rounding Defect?
Re: Personal.xls
Personal.xls
Using builtin sheet activator
File Not Saving
Re: VBA to find Cell Range in Files in Folder, return value
Bitmaps on User Forms...can you make it a jpeg????
change tab name
Returning varying rows of data through lookup function
FolderPicker dialog box
Re: hiding rows using macro
Extract Characters
Re: Best Fit Solution
Re: How can I....
Locking a project
Text Cell
Listbox Usage
macros not showing up when using excel COM object in .NET
Excel VBA - Creating Directories
Fixing UserForm Position
Re: Having input the current date in a cell I want to lock it
delete macro with code
Pre defined value
Macro Folder
Protected Projects
Damsel Needs Assitance with Proper_Case Macro
Re: One more question on ListBoxes (I hope)
How to check "Always trust macros from this published" when securityis set to high?
Re: Refreshing Query Tables
Hide Columns w/Change Event
Putting correct values in cells
Refreshing Query Tables
cancelling out of read-only recommended locks up Excel 2000
Re: Toolbar on opening a workbook
Huge Excel Document
Method Rows of Object Global Failed
cell contents as filename
Printing Problems in a big Excel App
Option button caption
Importing Complicated Access Query into Excel
If statement
Newbie: Error 1004
Copying Data
Selecting cells from a list
Newbie- Filename referencing in macros
Hide Columns w/Change Event
Do not print in duplex
How to know the total number of records in the excel sheet
How do I determine a Function's callling Row Number.
Re: Bypassing startup macros
Data Form Insert Count to add to Summary Sheet
Referring Date in VBA
Initialize variable
Finding if the activecell is withing a named range
workbook open read only without prompt
Re: Bypassing startup macros
Run Access query from Excel
ComboBox - Entering Text
dataform
Checking for who opened Excel
Run an excel macro without tying up excel?
Finding from a range
Looping Find Next
worksheet_change
Freeze pane of all Sheets how?
Macro to delete rows with text cells
Unable to remove Sheet objects in the Microsoft Excel Objects
run-time error 9
make macro change (delete) its own code
Re: VLookUp when Macro Opens WorkBooks
select mulitiple columns and items from a listbox
Re: changing column order in pivot tables?
FileFormat for "field1", "field2"
General question about organizing or grouping AddIns
Is it possible to use a Lookup Table???
Drop-down updated on each keystroke
Hyperlinks from Bar Charts
Macro for Date & Time
stop code execution
Re: Selecting Multiple items in ListBox
use a variable in a formula
RE: VLookUp when Macro Opens WorkBooks
Re: VLookUp when Macro Opens WorkBooks
Macro for pivot table and printing.....
Rounding Errors
Macro to find the next free line
Align a picture/shape in the middle of a range("A1:H10")
Align a picture/shape in the middle of a range("A1:H10")
Re: Hidden rows
Invalid procedure call in use of Shape property??
Conditional Formatting
RE: ComboBox control behavior changes when BeforeUpdate event hand
Load Excel worksheet displayed in IE into native excel
Best Book in VBA?
RE: default references or adding programatically
AllowFormattingCells in Excel 2000?
Filters/Range/Summing
Problem with UDF can't return the value of a formula
RE: worksheets formatting
Web Query & Array Questions!
VB Code does not work when sheet or workbook is protected
Excel VBA Forms and multiple checkboxes
Code for moving cursor one cell to the right
Switching Workbooks in vbscript
XL 2003 Customized AutoFormat
Same Footer, but different page setup options
Left Justify Caption on a Button
Re: insert SORT in right-click
copy & paste from & to hidden sheets
AUTOMATIC DELETE
Change the background color on a multipage control?
XML exports and style sheets
Who has a workbook open
long if statement
Re: Cell address nearest to screen coordinates
Trim characters
Directory Printer
ResizeArray for Alan Question
a picklist for a field
UDF's and Worksheet Function VBA Combinations
Strong-arm tactic for enabling Macro
Re: Conditionnal formatting using VB
How do you get a macro to run upon opening a SpSheet
Re: adding to a number already in a cell
Sorting and inserting problem
Merge cells with information
Custom Toolbar
Re: Inputbox() Sum() MsgBox()
Error 1004 when running on a protected sheet
Export Chart to Microsoft Word
Re: adding to a number already in a cell
Re: HOW DO I PUT A & IN MY HEADER IN EXCEL
Re: HOW DO I PUT A & IN MY HEADER IN EXCEL
Background macros?
Is there a way to say which cell is clicked on?
Re: adding to a number already in a cell
Re: Create a New Menu
Re: How to use a variable as a sheets code name
Excel FileExists macro problem....
Get an object representing an existing Excel instance from Outlook
List all TextBox on a sheet
VBA Help Required - Copying details from ComboBox onto worksheet
WorkSheet / ActiveSheet Question
RE: Update WorkBooks in Folder
Re: Conditionnal formatting using VB
Worksheet activate
Re: Update WorkBooks in Folder
Arrays
Re: Update WorkBooks in Folder
Excel Formulas
Clipboard - "No" to Paste Info Later
Re: Question for complicated merge
VBModal Error
Re: Input box does not allow selection in another file
Re: Reseting Shape counter
Unlock VBA project
Re: Reseting Shape counter
Adding columns with dates
Releasing all Userforms in memory
setting print area via VBA
Memory problem Refreshing data
Summing columns
Urgent help(Find, match and copy)
VBA auto running
ASP to Excel
Does the sheet exist?
Selecting a sheet by code name
How to preserve cut/copy range on SelectionChange event?
Saving chart as jpg in 97
declaring constants from the sheet?
lookup problems
Printing
Access the values from combo box after autofiltering
select a range
problem updating cells
deleting workbook on date????
DonÂ´t show Updatelinks prompt and donÂ´t update
Userform Advanced Filter
Creation of "floating" toolbar
Autofiltered cell value (VBA)
Message Open Box
Open existing workbook
help with excluding 0s from code
Annoying clipboard message
Combining 2 Pivotfields to 1(Help!!!)
Don't save changes???????????
How do I pause a Macro whilst it is running?
Convert "Month" to "MonthName" format from db to PivotTable
Workshet onchange
What Book to buy?
Conditional Formatting
Excel – Macro Problem – Inserting, Appending Data, Deleting
Help with Macro to Convert Date/Time to Time Only
number testing
Unable to Record
Filter 'From' 'To' Dates in 1 Col
windows.sheets ?
Manually editing Sort function in VBA
opposite of intersect
Find and Match in one worksheet and get data (Very Urgent)
Through code : Making a global change to 100 templates
Auto launch userform
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error
Invalid Procedure
Re: Hide VB Source Code
Cannot access ADO help file in VBE
Excel VBA auto entry of data
Global variable/Print
Selecting multiple items and columns from ListBox
Amend range for negative value
Mscal calendar
Calendar
How do I delete repeated entries.
New to macros question
Simple question - Named Range in Macro
DMEDIAN
Pasting problem
Load Sheet2 on Startup??
Find intersection point using lables?
Remove a character from a column
Re: Excel Headers & Footers
XLDialog Printer Setup
Help with a formula
Object Library Not Registered
Array Sorting in VB
Clipboard Message
Is there anyone out there that can help me?
Distributing Workbook
Need Help writing a macro
Missing Project or Library
Selecting a worksheet in a workbook
Are there any dangers in adding a lot of "comments" to a workbook?
Combination Numbers between 000 and 999
Application.Filesearch yields incorrect results??
If "text" exists in COL A, keep (quick one)
automatic data fill , based on list into dynamic range
AutoSave code problem
multicolumn listbox move or value set
Increment column in loop
Paste literal text
me.printform
Re: Adding to the SeriesCollection of a chart object in VB6
Does this make sense?
Formatting a new seriescollection in a chart object
Excel to Word
Auto-Subtotal
macro using PROPER function
Can Excel download files?
Re: switch applications?
Deleting or Hiding Rows
Re: common subroutines - add-in
Formatting a column - needs refresh?
how to hide a chart series or make it invisible
Difference between .Activate and .Select
Re: ListBox Question
Re: Macro Find
Subtotalling a column of data?
Legends in a pie chart in excel 2000
Re: Can I use Environment variables (such as %USERPROFILE%) in Excel .
Unable to get macro hotkey to work
Selecting workbook
Run Macro when loading addin
Forcing charts with common columns to display colors consistantly
Excel 2003 text file generation slow
Re: Copy and Paste (Tom already in disscussion - more help needed)
Printer Selection Box
Creating a multi-user spreadsheet
Get filename
extracting parameters from formula
Count from Input box
Input box doesn't return sheet name with range
Re: saving with VBA
Re: PC Spreadsheet not working on MAC
Excel VBA Autofilter on dates not operating correctly
hightlight table or create borders
Re: File_Save
Re: File-Save
Filtering of data using frequency filters
Excel VBA - Delete cell to right of cell
SQL - TOP 1 Usage
Assigning data source to chart
NEGATIVE HOURS
misc ?'s about creating forms
DDE limitation?
Selecting ranges
conditional match function
UserForm implementation
Mail shot
OptionButton selection dilema
macro which import alfa*.txt file, how to ?
Chart Placement
Display an Alert popup.
MsgBox commands
How to show unicode String ?
Need help : Open a csv file with semicolon separation
Date formating problem
listbox listindex problem
"Transpose" Macro.
Creating Access DB
Increment final value in for statement
conditional formatting
Autofilter with Range problem
column value
Conditional formatting
Autofilter with Sum
Assigning PRINT AREAS and no. of PAGES to PRINT
Find last column with data
Check null for range objects
copy and paste table in another existing worksheet
Open file with file name from cell
How to create a shortcut key to access buttons in excel forms
VBA Code for selecting days
Assigning range names to arrays
Re: updating charts
Macro/Function to delete.........
Security Code
Copying and Pasting in a different worksheet (Urgent)
VBA Cut and Paste Help
Re: Print Userform Landscape - VBA