Excel Programming [Archive] - Page 152

VBA code to transfer a Range to a Word doc
Re: ¤¤¤s±a¦³·R¯fmm¯u*±¥Ø(¦³¹Ï)
saving file
command button in pivot table
Protect Macro from Edit
select sheet
Thank You
internet data transfer library
Copy Cells if A=1
Eliminating save message
Send Instant Messages from Excel
Tagging a Cell
Fill a Range with VB SafeArray
copy a hidden sheet
Insert Grand total at the end
If B4 =? enter 1 in A4
query metastock data
Would like to Obtain a Cell Address from a vlookup function
convert excel doc with macros as web document
How To Copy & PasteSpecial: Range from Mult Wksht into SummarySheet
Re: Macro to advance current row by 1
selecting contents of a text box in vba
Re: Macro to advance current row by 1
your opinions and help on my best sub thus far
Excel vb Email
Add-In Problem Disables Excel
Delete Row
Re: Unable to set Underline property of the Font class
Formula to calculate affiliate commission
Isblank check in VB
Name Delete Problem Again
Office Chart doubt
Hot Key Confusion - NOT programming related, sorry
Problem with IF Statements Within VBA Code
Limit on number of Sheets in a Workbook?
Paste a large text into a cell
Autosave excel file
Extracting useful info from test data
Excel 2000 vs Excel 2002 Macro
Change SourceData in Excel PivotTable via VBA
Using a Macro to find a value in a range and activate it
Inserting rows based on another cells value
Sporadic problem with Enabling Macros
Rounding questions: (Formula and Code) ?
unique numbers
calling subs
HELP. Can this be done easily? Save me HOURS of work.
message box question
Problem in setting Excel formula through VB
Index match lookup formula
VBA code gets lost from workbook if I paste in new data and save???
IF Statement
ODBC driver does not support the requested properties
Hyperlink to Hidden sheet
Row Delete
Ignore - just a test
VBA Newbie - Simple Macro
query table with patent publications
InputBox Function
Auto Filter. More
AppActivate runtime error 5 when used with shell cmd
Embed Pictures in Workbook
Go to Differant Cells After entering
Pop-up Combo Box
array formulas and index lookup
Is this possible?
Going to differant Cells after Entering
Pop Ups
Do While only does once
Lookup on worksheet return whole row
TextBox formatting (Revisited)
Easy one
Public variables and Class
Autofilter
BLANK as a Formula result.
validating against a list - Please Help!
Help needed to test and modify interworkbook links
Returning last button pushed in Excel 7
XValues and values.
Adding new worksheet from template in code
h2 (30), c1(33)--split- c1(30) -d1(3)
MS Query
How to keep the Checkboxes selected by the user unchanged even after closing the userform
Increment number in cell before printing
UDF recalc problem between sheets
Reference to DLL corrupts on recompile of dll
Printing query with Sendkeys
Go to last row of data and delete the rest to bottom of s/sheet
how to get custom papersize from excel?
Logging things..
Quick Date Entry European
Match / Name-assigning To A Range
Re: MsgBox
Drive Letter of current file
Plain descriptions required
How to Check a checkbox on spreadsheet from VB code
Assignning a value to a range
How to run a macro automatically when i open my excel spreadsheet
Runtime Error "1004" Select Method of Range Class Failed
Protect formula
Newbie in deep..... Excel and VB
copy & paste command button
Updating Sheets on a non continuous cells
How to avoid several print areas being squeezed into one page
Workbook is viewable in VBE after I close it
Visual Basic System Error
Sort, Subtotal, Label Subtotal, Insert row
VBA- SeriesCollection
Insert a ghost entry to a collection
getting textbox value
Cell Translation Code
on _SelectionChange Copy Range to Second Worksheet
convert numeric to alphabet
how to rename the sheet in programming
Wee programming query
parsing text file, and generating distinct cell values
Export Userforms to Access
Please use the latest Version
using a barcode scanner to validate numbers
Import images
Conditional Copy
Date Calculations
Formatting number as accounting
Relative Values in a Macro
RE: MsgBox
Re: MsgBox
basic question about loops
Using values from one macro in another!
Adding text
Activating last chart added.
Allowing only one or two viewings of a worksheet?
error
disable Warning Message
How can I use the Spin or Toggle buttons to change cell values
Automation Error
Excel macro licencing
Copy Value but not Formula
Accessing PowerPoint files from Excel
changing the value of one cell using another cell
Add border based on date
Code modification - remove commas from names
Supress "now printing" message
Delete names
Pulldown Sub-menus within the main menu!
Re: Excel 'file locked for editing' by <me>, how to avoid.
Selecting sheets without specifying
Easy one: Focus off individual cell?
Access a Web Site from VBA,
Criteria Fliter then Count results
User defined menus and functions!
Re: moving the cell pointer after hitting enter
Using value from pulldown box in macro
MSGrid.TWD in Windows 2000
Adding menus!
antilogarithm
Delete Shortcut with Code
Go to SELECTED CELLS
Paste special values
#VALUE! position in column of data
VBA noob - making the date appear on/from a form
Re: Excel recalculates formulas when opening files last saved by an earlier version of Excel
textbox validation
Insert data between 2 fixed rows
creating macro to ask for variable info when excel starts
compile error in hidden module with excel 2003
Re: Can't Set DisplayAlerts to False
Coping a sheet
Event Procedures: Event on Worksheet to fire Event on another Worksheet
Creating remote objects
RE: windows 2000 puts my files in lecture only
How do you build pivot table in VB
Getting a subrange of a specified range.
Range < - > String conversion.
Excel Add-ins
Re: End of Page
Re: Question about MSCommonDialog object
Pivot Table not in order - why?
date time picker
Re: Linking sheet tab names to cells
Missing Nav Links in VBA & MSFORMS Help
Searching for cell and comparing different workbooks
Searching for cell and comparing different workbooks
Real simple VBA not sure why I cannot paste.
Opening New Email On top of Excel / SetForegroundWindow
reloading arrays
UPDATE & COMPARE
how to tune the resolution of an exported image?
Protecting Data Validation from being overwritten
Reply to Tom Ogilvy
Can't get Web Query to work
Sheet Delay
Help With Very Simple Code
TextBox Formatting
Automate Word via Excel
Saving to Removable storage
Installed add-in not loading when Excel 2000 started
InputBoxes Exceptions
Run Time Error with Toolbars
Searching a range in Closed Workbook
Macro to create large 2d surface charts.
Leftmost and Rightmost Cell
sendkeys statement
Excel FIle Not Opening
Re: Log file ??
detect if file opens read-only
Screen Flicker when changing row height
Code runs in XL97 but not 2000?
excel focus problems with custom RTD server (real time data)
Method Range of object global failed
Re: Sorting a protected worksheet
how to set default value in list validation" did not return results.
Re: Sorting a protected worksheet
Email in Excel
Excel - Return column alphabet from column number
Automation error -2147417848 (80010108)
<shape>.GroupItems acts different in XP for sub-groups?
functions run 2 times.
Project stays in VBEditor when workbook is closed
Help of VBA?
Proper case
other type values in array.
other type values in array.
How do I polpulate a list box?
How to use Treeview control with Imagelist
Errormessage when button is pressed twice or more
Changing Font Color
Calculating R-squared value
Formula
Excel events - please help!!!!
If Then Conditions
Right click menu in my form
Formulals
Pivot Charts
Debug problem
Copy sheet problem
Re: C#, OWC10 and forcing formatting on columns.
Calling an excel 4.0 macro from vba in Excel 2002
#N/A Help!
adding rows
form
creating a running tally
Printing one Adobe pdf instead of multiple pdfs
Read only without password
how easily indent my code?
send zip file to desktop
execute stored procedure
dynamic textbox??
Office 2003 pivot table filter clear
RowSource not supported in Office for Macintosh (workaround?)
How do you determine if it's the 1st row/col of a specified range?
use vba in excel to append data in access
conditional formulas
Problem in plotting data series on secondary axis
Wav Warning Upon Attempt to Close Userform
different font format in the same cell but using a formula
add a new line on the same cell using a formula
creating a dos command in VBE
application. ...
Deleting Blank Cells Subject to Criteria (Originally Posted in Excel by Mistake)
Minimise Form Button + Linked Wrokbooks Warning
Insert row
Sorting rows and columns using VBA
updating of data without overwriting the previous data updated
simple workbook create/copy queries
Hide Excel row in VBA
closing Excel in VBA
protection with cells
common dialog box
MSChart Control Question
processing part of a collection
Re: Adding hundreds of hour of time
Custom format
UnlockProtectedCells
listbox option in form
userform zoom
Merge Excel data/charts into Word Template
Subject line in outlook
Use DDE in VBA code.
solver setcell= to an argument name rather than a cell in the worksheet
Transfering values?
VBA code to add a reference to solver
Help with collections
Re: Copy text only
placing a point on a image
Paste Options Button Does Not Appear When You Paste Between Two Instances of Exc
Protection in VBA
Assigning cell values within a VBA program
Particular custom function.
Something works, something don't.
msgbox
Newbie - two questions
Changing location of text file from which information is imported
RE: text box program
having a macro work only on a worksheet
Question for MVPs
Solver32.dll unavailable error, use excel setup to reinstall
Export data to SQL table
List source must be on same worksheet?
Change OLAP Cube Data Source
Copying from several workbooks into one
Lowest Value
FileSystemObject
Merge into Word Template
Re: Truncate text
Protecting a workbook
Calling a Sub passing Textbox name
Move Cell in Column A to Column B when FIND
Text Extraction
Clock?
Application.WorksheetFunction.Upper
Re: Starting Explorer from VBA
Forms
WinZip
instead of formula
emailing
Date format issue
Automatically filling cell with data from COM port
Calendar
deleting wksts
Truncate text
Using with...
auto execute
Include Count
EXCEL.exe has created errors and will be closed by Windows.
Klagenfurt Austria July 2004 European Spreadsheet Risks Interest Group Conference
Multicolumn ListBox in Userforms (selecting specific rows)
Back to original file
Can't dereference a missing DLL
Re: Form resize based on screen resolution.
URGENT!!!!!!!!!!!!!!! Problem with macros in Excel
Chip Pearson: ProgressReporter UserCancel event
Help Please: Need code to test several lines
Send Mail With Redemption
file handling 2
On Error ??
file handling
Scroll Bar in Excel 2002
XL 2003 macro not working in XL 2000
Counting rows
what is a good/best formula to extract the 3rd last word in cell A1 into cell C1
File X1Textwindows formating!
Range Resize
"Library not registered" message accessing an HTMLDocument object
VB Errors
Re: numbering a column automatically
RE: parameter value query
Totals
date issue
Re: numbering a column automatically
Using Offset on Cell Address
File Formatting!
Re: Embed Graphic onto custom command
Adding zeros
numbering a column
Question to speed up a process -
Nested IF Statements - Worksheet Function
Re: cpearson VBE question
Re: Multiple TextBoxes_Populate
WhatTheHeck?
VBA SpinButton_SpinUp Question
Repost: hiding columns
Changing copy to Cut
How do you know when a data refresh is complete
Calling Analysis Add-in Funciton in VB
Comparing Items and Prices in Excel
Else:
reture the range of a chart series
Delete Rows
delete a category
MsgBox
VLookup
"file not found" error message when launching source file
Can Combo Boxes Be Formatted?
Re: problem with code in workbook_open event
Random Numbers from list
Syntax needed for With
Custom function not computing (#VALUE!) returned
xla Installation
use vba function in formula
CopyPicture is giving problem
Test for existence of Name
Count using VB
Input Box List
Test if Lotus Notes open
Re: Can't Set DisplayAlerts to False
Saving while vba is passworded
RE: communication
excel 97 Charts and Controls!!!!
Count Property
save as filename
advice on improving code
BeforeSave event
Test that a workbook is open
Re: Clear cells resulting in div/0 or zero ?
Multiple TextBoxes_Populate
hold down a key while clicking using Excel VB... sendkeys/mouseevents?
solverresults
Running a macro on multiple tabs
Macro : confirm Delete
Getting the name of the Actual Scenario
excel 2002 -Userforms and macros help
Scrolling gives me error 424
Search in Range
forget password of my vba program in Excel
Copy Mult. Wkshts Into Single Wkbk
Auto invoice numbering
Rendering EXCEL pivot kind of report using C#
Listen to network adapter
comparison charts
Checking for duplicates?
Re: MS Bug? Data validation list dropdown with Worksheet_Change event
HELP!
sick code needs doctor
Re: File error: Data may have been lost.
Selecting Refedit value
Copy Method of Worksheet Class Failed
save with date
Re: Paste text over merged cells
VBA - chart reference error
Invalid Number Format in Excel 10
Remove ' at beginning of cell
Excel VBA - Read the series' chart data ranges
F1 key not producing "Help" window in Excel 2003?
Excel VBA - Read and modify the chart data range
Converting hex to ascii
Named Ranges - Slow Workbooks!
! error
Export to multiple workbooks - row limit
Silly question
Menu creation - from DLL rather than .XLA
Calling solver
Run time error!
Refer to three cells to populate For next
Poor Worksheet Performance (for Mike Malachy)
Macro Question?
Copy Method of Worksheet Class Failed
Equal scaling in diagrams
External function call
Soccer Tables
Searching a String
Msgbox
searching a string with a partial string
moving ranges thru workbook
Add fields to pivot table
help with worksheet functions
Copy Method of Worksheet Class Failed
Query sheet to activate
Copy Method of Worksheet Class Failed
Re: Paste to variable number of rows
I need the number of a row that meets my criteria
Re: Paste text over merged cells
Complex Text Strings|Variables
Copy Method of Worksheet Class Failed
Retrieving FoxPro Data using Query
Find value loop not working
Renaming VBA Modules
Event to fire when pivottable is pivoted
Abnormal "IF" request
Using Application Events
Data Input Box to Cell
Unique Entries
Comparing Data
Somebody hit me with a bigger hammer... I forgot how to..
Copy Method of Worksheet Class Failed
Enter time
Renaming sheets
runtime error 91 in Personal.xls - no clue!
Please help with PasteSpecial programming
Using XP Events with Excel 2000 Users
Re: Re: Transposing cells & deleting sheets
REPOST: Looking for how to use DTPicker
When I moved data from one workbook to another...
Scheduled Task
how to detect paste
Using ShadeAlternate Subroutines as Macro
Prevent user to drag and drop
Listboxes
Excel VBA - Complicate Problem
Script Help?
Is it possible to load XML/SSML string into workbook without using temporary file?
Workbook_open Event
Before print increment counter
personal numberformat
Find All and then Copy the Data...
ActiveSheet.QueryTables.Add using a File DSN
Ascending Order
forms in xla
Finding text within a cell
Enter european date
Question about what the Find function returns if the item wasn't found
Problem using imagebox with wmf files
Rename sheet if exists
about OLE automation
Calling a macro from an If statement
data imported into EXCEL as text displayed as exponential number
Format function doesn't recognise [hh]:mm
There must be an eaiser way
Timeout for OLE actions in Excel 2003
Overview of VBA objects etc...
Running Solver Add-In through VB ?
how do I create dependent lists?
combobox cases
C# and Pivot Tables
Running Total on Userform
Find selection
Error Problem
OverWritten excel file
Offset Prob
Re: query (hiding the excel worksheet presently selected with the help of vb code)
If its a subtotal Row?
Problem using Excel Xp Workbook on Excel 97
Excel VBA - Copy Folder problem
How mk code applicable to any active workbook?
Excel VBA - Excel 4 Macro problem
Find and replace within VBA
Userform data
Autocomplete DropDown List
Userform
COM Add-ins and Keyboard Hooks/Child Windows
Populate multiple comboboxes with same lists
FileExist doesn't work
Deleting some cells in a row using command button and offset
Re: Error in Copy/Paste
Selecting all contents on page (range)
adding attachement to e-mail from Excel
Populate multiple comboboxes with same lists
list box- list all files ina directory
Calculations on Cell Values in VBA
Re: Displaying embedded chart on userform
Recording a macro with relative reference
Protecting only one cell
Use VBA to access Printer Properties (Resolution, Tray etc)
ActiveCell.Formula Syntax
Timer
Write data to a cell, then make it undeletable/selectable
Order column in pivot table.
MIssing References
Attaching Command Bars to Add-IN
Time Sheets
if ... or ... then ?
Listbox memory problem
R1C1 Education
Move a file without opening it.
Is ther a way to change the interior.colorindex of multiple rows
Filling Userform in Word with Excel cell value.
Please help me Parse this
Advanced Filter & Named Range
formulas including ; character
Working Around Excel Row Limit
Forcing users
Re: autofilter problem with date values
Who's my caller info?
Mail Merge with Excel?
2 Textbox questions
Delete a custom button by holding down the ALT key and dragging the button off the toolbar
Newbie - How to close GUI but not Excel
How do I create a cell whose value can only go up, not down?
how to find row with a given value in a column
problem with excel refreshing Via macro
Form start position
Random Function
Dynamically adding data to a Combobox?
Re: Hide Toolbar with vb
How to see all variables?
Button to format selected text as subscript
Help with copying and pasting from user input
VBA code
UserForm: Jump to the next visible cell
Page Setup Problem
Need to add mutliple columns to a List Box
listobject ... Excel2003
Filters & Sum
Referencing other worksheet data using a drop-down list
combine two ranges
Copying Excel files and Macro problems
Screen resolution kernel call
Data validation with VBA
Adding a Confirmation Step to Macro
Sorting
Re: Comparing rows of data in two worksheets
Code for SUM with duel criteria
Changing the order in dropdown boxes?
excel 2000 macro on excel 2003... help!
Why is delimit failing me _now_???
VBA and data validation?
Batch Excel worksheet formatting
Last Row of Data
VBA code
Excel - Copy range of cells based on Combobox Selection
Auto Choosing Pages to Copy
Formula, not results showing
Help - trying to make installation file
Naming convention for a variable "Book1" while copying sheets
Trying to improving existing code (portion of)
VB OLE embeded excel document cannot be saved -err 1004
In Event printer fails
Price Pointing/Complex Rounding
Scanning barcodes in a dialog box to check duplicates
letter
scrollbar on userform
Workbook add, reqest name
Excel VBA-hide row worksheet event
How to detect current active sheet number
Web Query
Signature Will Be Discarded
Named Ranges - Macro Problems
I invented way cool analysis tool in excel
Comparing two sets of data
Newbie - populate (macro) GUI from Excel cells
Excel 2000 Slow Loops
Closing forms
Function, User Defined
Makin a Filter...
[question] about consolidations...
Re: Entry of Incomplete Dates
Open Hidden Worksheet
Re: Reference to other workbook problem
changing an palette index value programmatically in Excel
Tickboxes on worksheet
Hourglass in combo - unwanted
Chip Pearson Import/Export Macros
passing control value from one form to another form
Re: Comparing rows of data in two worksheets
using variable for a control name
Attach custom list to a cell
Checkboxes and Other
selecting multiple sheets by use of an array?
RE :Copy method of Worksheet class failed?
Inserting a Row With Macro - Help
Steps from Macro recorder for Pivot table will not run as a Macro
Re: Need Solution save as ASCII
SaveCopyAs losing security settings
Copy titles from another workbook
Changing Text Color After Change
Trying to sum a range and drop the lowest 2 scores
XMLHTTP proxy settings.
help automating the Replace function in Excel
decimal places
Compare & create list of uniques across books/sheets
Format bases on IF Statement
Skip empty and text cells
Copy method of Worksheet class failed?
Send a task from an excel file
ADD & UPDATE
AutoFilter method of Range Class Failed
Can I do this?
Application.EnableEvents
Assign Macro function not working
Need Class Collection advice
Ctrl and Alt keys
Error when using macro to write formula to cell
Re: Manipulating 150+ checkboxes with a macro in Excel 2000
Workbook_Open() Error
Sort/Filter by Color
Macros Running Slow in a Shared workbook
Substr Copy
Web Query Logins and Access Refresh
User-def shortcut to macro
Sending "Enter" command to cmd.exe app...
Re: Macros in Shared Workbook
Re: resetting controlsource cells
Formula
AutoFilter
User Form
Re: Solver in VBA
Excel VBA -Force users to populate custom form cells
Running .BAT file from within a macro...
Hyperlinks in drop-down list
Where is the protection in VBA???
Re: Name list in the workbook
Re: Help with Outlook & a movie list
EXCEL VBA non-volatile INDIRECT
Is it possible to move a Digital Certificate to another PC?
Re: linked cells loop?
Re: linked cells loop?
Copying cell contents to add to existing contents in another cell
select records using VBA
Macro to move between sheets
Copying multiple worksheets into a new workbook
Range object
Copying sheet to its own wb
after each print, copy data from sheet 1 to sheet 2
within a macro how can I suppress the warning pop "A file named xxxx.xls already exists in this location. Do you want to replace it?"
Open file Dialog box in Macro
Controls & their properties etc
VBA code only working up to 9999 rows
Not using send button on excel e-mail
autorun code when opening sheet (not workbook)
sending e-mails from excel without 'send'
IF then write new worksheet/book
Printing Range
missing command buttons
workbook change
Better way to test for empty Recordset
Character limit for DAO queries?
Template Path???
Exception Report
Excel library reference files
Error in code to Check Forms Checkbox
master sheet
Excel Formattings
Which is more efficient?
Excel 2000 VBA problem -- sorting values in subtotaled column
Transposing Data
Timer for auto shut down
Re: Format when linking cells
VB Project Documentation
Prompt to copy formulas
Protect except chng colmn width
Delete row from ListBox with RowSource enabled
Auto Open Not Functioning
Flling an array
Drop down box problem
Option Compare Text
Re: Troubles doing Data Retrieval from SQL
trying to search 4 text in a word doc & print page?
Execl 2003 XML Question
Open a password protected excel workbook from second workbook to fetch data using dynamic connection
2 questions related to Excel under Windows 98/2000
Error Handling Routine
SQL query in Excel 2000 using VBA
ActiveSheet woes
Excel Driver Error: Cannot expand named range
VBA - Macro backward compatibility from excel 2002 to excel 2000
Visual Basic/ Macro date formatting in Excel 97
Using IF, Then with rowsource?
Re: Help with Outlook & a movie list
Deleting Rows
Convert Excel Functions to VBA Macro Function
SV: Re: Check for newest *.txt file and import data
Sub vs Function
Re: Saving on the server
Changing graph
RE: communication
excel solver macro
Help with 1 x 2 array output
Excel-Opening Word
macro using excel solver
Re: getting data from closed workbook
Re: getting data from closed workbook
Problem With Auto Open
worksheet
office automation Word-Excel
Excel VBA - forms
On Screen Loop Counter
Selecting cells in Excel
Can't Set DisplayAlerts to False
Input Form on Worksheet 1, Data on Worksheet 2
Subtotal Format with Macro
getting data from access to exel
Re: Last used cell
Creating organizational charts using VBA code?
Command Button
Re: Saving to Network share with different mappings?
Entering numeric values
Insert Filepath into Cell
Macro Secrity Problem!
Unwanted excel message
Mixing date formats in VBA
Sorting data in sheets
Is there a way I can change the shortcut key without having to redo the macro?
For...Each Loop Problem
Uncheck Forms Check box via code
Newbie Question .. what's this
having problem with resize
Trouble making a report of all Files within a Folder and all Subfolders?
Insert data returned from Procedure at 46th Row
Fill down VLOOKUP
newbie with userform questions
Re: Excel Formula or VBA???
Detect what version (if any) of Excel is installed
Totals and Sorting
Excel cannot 'FIND' data imported from oracle
Dir Path Code Problem
Re: Assigning array to range inside Excel Object
selecting random records
Having problems with adding input from combobox
Dir Path
Limit to 50 char only
Selecting File
Save to FTP
Need to know the Sort Column Keys
Sorting columns left to right leave a intact
excel simple prob w/running subtotals
pivot table grid formatting problem after refresh
Insert Rows Macro
Userform and scroll bars
how do count all record in one column
Copyfromrecordset failed after install of Office XP SP3
Constants & Declarations for National Language Support
Re: Automatic File Name based on cell content
Excel VBA macro - need to edit code to skip a year
Re: getting data from closed workbook
Help on comparing two data on two worksheet
Problems Using MS Oracle ODBC with Excel
Library Reference files
Microsoft Office XP PIA's
Consolidating worksheets
Re: need help - how to highlight row when nothing in cell
Excel macro & multiple users
Autofill
Re: Prgrammatically save a file to a specific folder on a network drive
vb-Copy two cells, and paste into another worsksheet
REPOST for Tom (or anyone else that can help)
VBA Code Example
calling subs, Doesn't seem to run fisrt time?
Rounding Nearest Dollar
Re: Preserving text formats with Concatenate function
Re: Compare input from ComboBox
Re: Dates in excel
Auto fill down
Maximun IF statements in a cell
dblclick event
Re: #NAME?
Re: VB CODE RUN ON DDE VALUE CHANGE
Re: Finding Column based on input, then first empty row
Re: Finding Column based on input, then first empty row
Re: VB CODE RUN ON DDE VALUE CHANGE
Re: Listbox Display
Re: Copy contents of cells down (nigel)
Add code to Private Sub ComboBox1_Change() with a macro from a different workbook
Custom menu's
Re: Listbox Display
refreshing VB function after changing value
Cannot make macro relative
Where is a macro shortcut key stored in a module?
SpecialCells and UsedRange
compile error: else without if
Dsiplay Printer dialog
Maximize Userform
Hyperlinks
VBA programmer feedback
Macro to protect and unprotect
changing bg color
Cannot Lock Text Boxes-Excel 2002
Re: Manipulating 150+ checkboxes with a macro in Excel 2000
newbie trying to workout copy
Excel Driver Error: Cannot Expand Named Range
Formula logic explaination
Re: VBA Excel - Load Data button
Re: VBA Excel - Load Data button
Hi-light area based on name found in column A
Finding Blanks in list
Finding Blanks in list
My syntax not working with Auto Open procedure
Excel Menus that fold out
Color Change Through DV
Place code in a new workbook with a macro.
Number Format
If Problem
Re: Connecting to Access using macro
Run-time Error in "SENDUSING" configuation value is invalid
VBA Reference to Custom tlb
Re: Catching an Open Excel File with VBScript
Repost: cut/paste excel cells w/ ActiveX checkboxes to Word
change name
Selecting Data in Column
Tab Coloring
Simple Question, need quick answer please
Re: Application.Volatile messing up other function
Pivot Table Resizing
Re: List of Sheets
With active cell
Excel - Double Negatives (Past, Present and Future)
Countng the number of non blank fields in a table
Screen resolution
Calculation Problem
Re: Change Rows/Columns in range???
Re: Change Rows/Columns in range???
Re: formating current row to center text (thanks)
group/frames
Excel VBA - Help looping through all but 2 workbooks
Normal Distribution
Create a help file
Re: TOM Ogilvy: userform buttons problem
Re: Reading with ADO from Access database over network
Resizing BackgroundPicture Gifs programmatically for varying screen resolutions
Initialising a variable
Re: Properties of QueryTable Object
opening a word document from excel: file still won't load
Excel VBA - InsertPicture
How can I detect if user is in Group Mode when a macro starts?
Excel VBA - msgbox of excel regarding Update
Re: communication
For Next bug ????
opening a word document from excel
Re: Workbook size
permission after migrate to off.XP
April Fools
activecell color
Multiple Modules, or one big one?
VBA Autofilter error in '97, not 2000
MoveDown
Re: Record Keystrokes With Macro Recorder
For Each, Next
IDE is greyed out
Re: Cannot trace this simple error
Excel / Word 2002 LOCKED
Re: Trying to save contents of cell as the file name
Filter, sort, filter and then display
Office Web Component-Data Transfer
Quarterly Log ? How to
Memory problem
Stopping Excel after running visual basic in Access
Re: range problem with multiple use of subtotal function
Inventory
Could someone help me with some coding
Excel97 vs Excel2000
Re: Excel automatically creates a shortcut on the root of c:\
Re: Best package to make COM add-in
Access a internet Web Site uisng a macro done with excel
Re: Sub-Totalling and Adjusting SUM formulae
how ti find a particular is available
Re: Deleting blanks from the end of values in cells
Re: table totxt
Re: Crosstab to Database VBA
Re: Help in using Application.Version
Re: Putting Array Formula into each Cell in a Selection (that doesn'ttake eons!)
Re: Group Box with Option Buttons
Re: runtime error '1004' delete Method of Range Class Failed
Why won't this code works
Selecting a directory from a form in excel
complicated question for copying ranges to new sheets
Re: Trim function won't work in VBA
RE: SaveCopyAs does not work
Re: Help with VBA Vlookup
Question about pictures in excel
Re: thanks...But I had another ques
Re: How to execute macros not saved in a workbook
Re: SaveCopyAs does not work
Creating add-ins
Re: VBA Macro - correlations in random number generation
Excel VBA- Trend Function in Macro Problem
Excel - To test for a Blank Sheet
Re: creating dynamic controls
Re: Automatic File Name based on cell content
Re: Menu editor
What is in a file name?
Re: Deleting blanks from the end of values in cells
Last Row and Column
Re: Cell tab order
Re: Trying to save contents of cell as the file name
AutoFiltering by combobox selection
Add name by vba based on cell content
RE: How to show only one part of rowlevel 3???
Re: Paste to variable number of rows
Re: Last used cell
Re: Trying to save contents of cell as the file name
EnableSelection = xlUnlockedCells
Visible Sheet Showing When Hidden
Excel VBA - Multi sheet filtering/querying(?) & combo box woes
HTML and realtime webservices used with Excel
Programmatically Adding Controls (Macro) eg Button on A SpreadSheet
Selecting and pasting to an empty cell
Merging two workbooks
Copy and Paste
Word Art Object properties in VBA
Code Modification
Match Code
Sum Crossreference
Number Formatting with string variables
Displaying the column letter
Variant Array with String Values - Type Mismatch
Hyperlink help for a Newbie
Import data from mysql on a web server
Delete Duplicate Rows, Summing the Qty
Hiding A Sheet Command Button With VBA
Can the screen resolution be changed within VBA?
0 stock
Dynamic Listing
Hiding macros
Type Mismatch
data info on a form
removing early duplicates
Identifying duplicates/unique values
How do I add a File Open box to this script???
Would an Add-in work?
password protection
SaveAs problems
Can any body help?
usedrange doesn't show the right value
Tabstrip control
Combo Box help!
Reciprocal range?
Select delimiter in .txt creation
Application.wait & Blinking Connector
Macros go slower than a turtle in mud
Auto date or comment entry
Trying to Sort and Subtotal with Vbscript in Excel
Time Calculation
FormulaArray with existing cell
Data Grouping when Worksheets Protected
Code execution skips Application.Run statement
person's height format
excel vba - userform list source in other workbook
Excel VBA - Userform combox problem
Can open a worksheet but cannot edit or save
Excel VBA - Userform Texbox/Scrollbar problem
Import data from mysql
Combobox source