microsoft.public.excel.programming
- Cell/function manipulation,
mazzarin
- Pic Macro,
Brian Matlack
- Macro Code required..........?,
Thyagaraj
- Re: Macro in body of workbook. Can I create XLA?,
Thyagaraj
- Counters,
halem2
- Re: protect Micro,
Norman Jones
- Copying Formulas Down Rows,
J
- Getting 0 to not equal False,
mkerstei
- .Precedents don't work in UDF,
Andruha
- Re: Offset with variable?,
Norman Jones
- delete rows with dates between,
dan
- Error when deleting rows,
wmureports
- Explicitly passing a .value,
mazzarin
- Formula to Excel VB,
JAVB
- Linked Workbooks,
phuser
- Exporting to Excel,
Gohtar345
- Suggest some vb books,
fahad
- Finding the right column,
JaMark
- Re: Windows version language and Excel version language,
Norman Jones
- Help with storing data,
J
- Dir command not consistent,
Robert_L_Ross
- UDF Can't return more than 255 chars???,
R Avery
- Please help,
J
- Dictionary troubles. Declaring and checking .exists,
Abe
- Need Help,
MBA2004
- Re: SUMPRODUCT statement only works sometimes,
Dave Peterson
- 1D Array Problem (Subscript Out Of Range),
John
- Re: Hidden cells,
Norman Jones
- Re: Considering Holidays,
Bob Phillips
- Fastest way to get keys from collection,
Abe
- Re: Copy and paste row based on cell content,
Die_Another_Day
- Run-time error '1004': Unable to set the CategoryNames property of the Axis class,
bodani
- Need help with Lookup,
zheng4
- Object Variable with Block Variable Not set,
SuitedAces
- Add a second condition to loop,
Casey
- Compile error in Excel,
MBA2004
- Re: opening multiple xls files in a folder,
Norman Jones
- Re: How To Maximize A Window From The Task Bar,
Duncan
- Re: Mouvement macro,
Duncan
- Initializing a dictionary and then modifying it.,
Abe
- Need to get modified date,
Michael Wise
- Re: Need help with changing data after it has been imported.,
xLBaron
- Re: Programming Cells To Change Colors,
Casey
- Standard length of a line of VBA code?,
Abe
- Shell for Outlook,
WhytheQ
- Problem with Auto_Open function,
suketus
- Record the date on which the record is made,
cyberdude
- pictures in exell,
frsm
- Run-time error 1004 Method "Range of object_global failed,
simon . q . rice
- Multipage Part of Form,
Bill
- Re: No 'Click' for CommandBarPopups, so what should I do?,
Chip Pearson
- Form,
Bill
- Re: Treeview Question,
RB Smissaert
- SpinButton1.Max quick question,
lavs23@xxxxxxxxx
- Re: How to make a cell containing a macro call to be recalculated?,
Kaak
- Opening a word document,
RobH
- Re: Control array,
RB Smissaert
- Re: Elastic array,
RB Smissaert
Re: Elastic array,
Kaak
Re: Elastic array,
Ingolf
Re: Counting worksheets with a particular name,
NickHK
Macro for Drawing,
herve
Macro to insert copy and insert formulas only to next blank row,
bob
AnyOne !!!!,
T . c . Goosen1977
Re: Filter External Data,
lexcel
LadyHawke,
T . c . Goosen1977
Execl VBA,
bill . graves
How to stop all Excel funtions for a period,
tonyhabayeb
An old question about Office 97 to Office XP upgrades and Bloomberg,
Echo
RE: VBA Coding: Date Consideration,
Irina
problem with calendar dates format,
s_ali_hassan
Irina,
T . c . Goosen1977
This simple userform is driving me nuts,
T . c . Goosen1977
Re: Ending session,
NickHK
Re: Window Object - Subscript out of Range,
NickHK
Detect # scrolled-out rows and column,
toreadore
Re: Syntax error..,
NickHK
EDIT>GO TO...>SPECIAL...,
WhytheQ
I need some help with userforms,
T . c . Goosen1977
Re: Code to modify find/replace,
Ingolf
Need syntax help!,
FCC
Disable the alert,
hurriance
Re: How to find Windows login name with code?,
Paul Lautman
Help please,
T . c . Goosen1977
Re: Check to see if a file is already open,
Ingolf
The same IF (SE) formula give me two different number: why???,
-= Luca =-
Re: Toggle FIND criteria,
ben77
How to programmatically test whether VBA code exists in an Excel file,
Paul Martin
Re: calculation semi auto?,
NickHK
VALIDATE WB NAME,
AD108
Re: Missing Help Files,
NickHK
Coding to make a transpose values button,
Sally
Re: Highlight duplicates,
Leith Ross
need codeto view the 56 colors of ColorIndex,
SuitedAces
public function to sum input and return total sum + 10%,
Santa-D
Re: choose default macros Not Enabled / Macros Enable Setting,
NickHK
autofilter syntax in VBscript,
Bob S
Re: Lotus 123 to Excel,
NickHK
Re: CommandBar 'Insert',
Leith Ross
Re: Quick Question on This Code,
Leith Ross
Re: Event Procedure (re-activate automatic calulation if disabled),
NickHK
Re: Importing Text Files of 100,000+ lines, many blanks,
PY & Associates
Re: Hex to ASCII converter in Excel?,
LenB
Newbie VBA Problem,
FCC
a sensible, descriptive name for activex,
Max Bialystock
Re: Assign my own sound from a list to a command button,
Jim Cone
Saving Changes to Excel App,
den 2005
RE: ChartObjects,
crazybass2
Controlling Outlook 2003 with excel,
wilro85
Triggering UDF,
bhofsetz
DATE Formula,
Digital2k
Re: Is there a way to WAIT in Excel without using 100% CPU?,
Ingolf
How do I build an excel query? (something like SQL),
tonyhabayeb
UserForm to Hide/Unhide Rows,
John Michl
ComboBox Lists,
Corey
Re: Creating Variable for a Sheet,
Harald Staff
Re: In excel can I display a cell based on a calculation (eg M(14/2)?,
RB Smissaert
Crystal xcelsius,
Brian Matlack
Retreving data from Web page,
tech
Loop & Cell Reference,
bforster1
Using a formula in a SUBTOTAL Line,
carmaboy
Error 424 Object Required when passing range as parameter,
carrick
Re: How to print fitted 1 page width and 1 page tall,
Ron de Bruin
Problem Naming Worksheet,
mikebabb
Re: VBA function got name error in excel 2003,
Dave Peterson
Code to show a graph,
cenee
Re: MKDir not working,
RB Smissaert
Re: will 2007 multithreading capability help the vba<-->worksheet tran,
Nick Hodge
Re: Adding Number,
ben77
Filter Macro with Cell reference,
chris100
Re: how do i add weekly averages in excel,
jseven
Restricting copied text to one Column,
Viking
String array initialisation,
major_yash
Re: What Does This Code Do?,
Lil Pun
Referencing code outside of current sheet,
nemadrias
Dictionary and saving workbook/ reopening,
Abraham.Olson@xxxxxxxxx
Hideen Worksheet,
halem2
RE: File properties (size date),
Jim Thomlinson
Locking a sheet & Menu Items,
quietmalu
random dates showing up in userform,
incidental
Printing selected pages in a Word document,
Tristan
Re: Save a single file webpage of each visible sheet in a workbook,
Ron de Bruin
Re: Combo Box - auto complete and the bound column/text column propert,
witek
Macro to send email through Lotus Notes,
PCLIVE
Re: email in XL XP,
Ron de Bruin
Adding a counter to ranges,
wmureports
Trouble with dynamic named range,
vermutmb
Email From Excel/VBA,
mtm4300 via OfficeKB.com
veenob3.hlp,
witek
Re: Find Last Value,
Bob Phillips
Re: Insert & Sequentially Number Column,
Ingolf
Re: Custom properties not showing the value when set programmatically,
Peter T
Re: Type mixture error,
Bob Phillips
unable to record macro,
Denis
Re: code help,
Dave Peterson
Sheet Name to Cell Value,
halem2
Print macro,
Steph
Re: update all the pivots at the same time,
aidan.heritage@xxxxxxxxxx
RE: How to loop thru cells in a row,
Jim Thomlinson
Re: VBA: Date Comparison,
Ingolf
Reg : Excel,
naresh_kalyan
Re: Array data to Range: Only first value written,
Peter T
Inputbox Default to be Upcomming Sunday,
Brian
Default Transparent color for bitmaps on cmd buttons,
Abraham.Olson@xxxxxxxxx
Userform loses its capabilities...reset???,
T . c . Goosen1977
Re: How do I set up macro to truncate column/field?,
Norman Jones
Incrementing a field,
wmureports
Date Comparison,
dzuy
Re: highlight with right click?,
Norman Jones
Combining two sheets into one,
a94andwi
VSTO Excel -- Urgent Help,
bruno_c
Create New Wk,
halem2
Opening Workbooks in a Folder,
Bill
Macro help required.Can any body help.........?,
Thyagaraj
Automatic File Download using CuteFTP,
RCL
Re: RTD wrapper functions do not work in Excel 2007,
peterhoa
Can anybody help on Vb Macros please..?,
Thyagaraj
Is MAPI or CDO installed?,
sarah . mould
Re: Logon Dialog prior to Open Database connection,
Mark Driscol
Circular Reference?,
ags5406
Count backwards,
leonidas
Re: XP question,
Mark Driscol
Object Variable or With Block Variable Not Set,
MJatAflac
.ext file,
kortrijkzaantje
Re: Setting size,
Mark Driscol
Re: *.csv to *.xls,
Kaak
Re: Search Goto Feature,
Don Guillett
Can anybody help on Vb Macros..?,
Thyagaraj
how does a macro use an inputbox ?,
Roger
How to stop Excel from animating range selections?,
gstremer
Macro to add a combobox?,
leonidas
Re: Making charts,
paul . robinson
Re: Placing charts,
paul . robinson
Change combobox properties,
leonidas
Theuns,
T . c . Goosen1977
Re: Small problem with GetopenFileName,
NickHK
RE: Summary Page,
SITCFanTN
Speeding up macros,
phil2006
Re: Changing color of tabs,
NickHK
Error while populating a combobox from Access database,
shivboy
New WorkBook Macro Looking to WRONG WorkBook,
Corey
MouseMove & Click event over an image control,
furbiuzzu
runtime error 75 when I run the application for second time,
divya
How to simulate "Data>Form" in VBA,
Baapi
Can't find Project or Library,
Corey
To block "to "eliminate" of the picture of form, information,
Isaac
Array? IF? LOOKUP? VBA?,
noneofyourbiznez
VBA and Displaying Chinese,
FCC
VBA Function won't work!,
cseilern
Re: Screen Updating on Open Workbook,
Norman Jones
Problem with Macros!,
buzzharley
Why wont this work?....Ontime + Now,
SuitedAces
Why wont this work?... OnTime + Now,
SuitedAces
Add value when checkbox is ticked,
emel24
excel applicaton closes showing complietime error not allowing to edit,
divya sanam
Re: Could anybody tell me what does "Ne01" mean?,
NickHK
Re: Using Excel as a data base,
broro183
Compare two workbooks and Copy missing data,
Naba
Conditional Format,
mary
Handling the 'Cancel' button..??,
RJH
If/Then,
I.P
Re: Advanced Data Maintenance Dialog Question,
NickHK
Question related to Recursive Formula Execution,
vishwas . lele
Field Data Validation in VBA Forms - Here's a way,
Greg Glynn
Re: Help with List Box,
Leith Ross
sql string, +'/'+convert(char(3)..),
doristsr
Re: How to send HP printer escape codes from Excel?,
Ivan F Moala
Re: Reminder Emails,
Vlad999
2 IF THEN STATEMENTS TOGETHER IN ONE FORMULA,
A
Re: auto run,
Dave Peterson
Swapping two ranges,
SuitedAces
Opening Outlook and PDF from excell,
kerrjohn
A way to simplify this please,
Larry Empey
Help with Advanced Sorting Macro,
shirtbird
keep column's information consistent in different worksheets in same row,
hankyfang
NEED a PRO: Screen Epilepsy,
brucemc
Find next blank row,
Vlad999
Re: Need an Excel VBA script written,
PY & Associates
Macro: Convert to PDF & E-mail. Possible?,
wilro85
RE: Conditional Formatting, Multiple Values,
crazybass2
Re: file name on worksheet,
Bob Phillips
SelectionChange and Pivot Tables,
andym
Re: Set Column Width Based On Total Width Of Other Columns,
Jake Marx
~~ Help with Userform and Combo Box ~~,
Corey
Replace left header,
GregR
PrintToFile from spreadsheet,
juzek
Re: Working Days,
Bearacade
Re: How to use VBA to update a SQL Server Table from a Spreadsheet,
Rubble
Looking for faster way to find minimum value,
rivka . howley
selection.value <> "A list of values",
ben . biddle
Pivot Table Data Connection,
J.Rogers
Save as cell with path,
Curben
Can't get Application Events to work with .xla,
M. Authement
Re: Using a Sheet Name,
Mark Driscol
Incrementing Cells with Macros,
wmureports
Select all cells in a column up to a blank cell,
nemadrias
Re: How to Get Excel Command Line Programmatically,
funkymonkUK
VBA Loop Excel Record Extraction,
JI
Unable to set the locked propert,
bsherwood
Re: macro to delete on a condition,
Mark Driscol
Re: Save As Macro,
SudokuKing
summing a range in a UDF,
Grymjack
Sort Multiple Sheets by Category,
nmccart
Access transfer to Excel,
Deb Pingel
Open Outlook from userform,
mtm4300 via OfficeKB.com
Assure entry is numeric,
merritts
Calculating a growing formula,
bambinos83
Loop that Copys from one sheet and pastes to another,
JI
Check validation on SelectionChange,
vermutmb
How does one create a delete property of a user defined class?,
Abraham.Olson@xxxxxxxxx
Import Problem,
wmureports
Need help using a toggle button,
tanktata
Find/Replace Macro with format changes to the replacing number,
r . w . frederick
Re: Identify duplicates and move to new sheet,
markwalling
How to read DBCS from a cell in VBA,
Joe Haberl
Find value in bottom cell in a column,
jakob
VBA Loop,
JI
Data Validation Returning only distinct values from a list,
JI
Saving Excel as latest version,
Nirmal Singh
Re: Paste Array to .xls : All at once,
RB Smissaert
Identifing Locked Cells,
Steve Klenner
Removing a collection item via key name check,
Abraham.Olson@xxxxxxxxx
Re: Search by filter using macro,
chris100
Updating data from one workbook to another,
tanyhart
trying to find #REF! in a formula to replace with a sheet name,
funkymonkUK
Help with using ADO to connect Excel to Access,
alan_conoco
Searching for exact text,
Josh
Re: CopyFromRecordset Error If More Than 911 Characters,
arno
Copy Paste Macro,
dnbtexas
event after worksheet unprotect,
sam
Converting number to text,
T De Villiers
Re: A couple of questions (formating & Collating worksheets),
deelee
Re: SUM in VBA,
Don Guillett
Re: Printing a Userform,
kev_06
"Automatically" get name of selected autoshape into formula? Impossible?,
wanderso
Cannot destroy Word Object in Excel,
dai50
Re: Recursive Loop -- How to Stop It?,
Gert-Jan
inserting colon,
xtrmhyper
Get, Set and Let,
Abraham.Olson@xxxxxxxxx
Copy to a Cell,
Striker
Counting rows in a range,
Gert-Jan
Re: Name of month,
Chip Pearson
- <Possible follow-ups>
- Re: Name of month,
Bob Phillips
- Message not available
- Message not available
Passing references,
Geoff
Pivot name changes automatically,
Sandip
Re: Making worksheets,
Duncan
Macro to paste row number in cell,
leonidas
Re: How do I add a search box,
Chip Pearson
Bring up an error message,
ChrisMattock
Re: Add-in Description,
Bob Phillips
Re: Pausing macros,
phil2006
Loop help,
benjammind
How to save the option button value,
sam
Need help with an if statement,
SuitedAces
Cell adress for next non-blank cell in a range?,
toreadore
Re: Named range in a sheet referred to from another sheet,
Bob Phillips
slow macros,
phil2006
Re: Forcing user's to use the most current workbook!,
patele
Re: Keep text color,
Chip Pearson
ComboBox ShowDropButtonWhen error,
leonidas
Select columns of active cell's row,
Cumberland
autofill method of range class failed,
phil2006
Re: Message box to pop up if a particular value is entered,
Robb27
Addition of a macro to an existing Excel file,
TheShortFox
Re: Saving Protected Workbooks,
Duncan
Re: cocatenation,
Ingolf
get values from combobox in excel.,
roshinpp_77
Re: Percentile --> how to?,
BHARATH RAJAMANI
read string from database and divide result into cells?,
ladyhawke
Re: an earlier post,
Bob Phillips
insert row on next sheet,
leonidas
Re: help getting winzip code from RONs de bruin site,
funkymonkUK
Re: Selfcert.exe cannot create a certificate,
NickHK
Secure Macros,
monkeyman
SelectionChange stops working,
andym
Re: check cell for #REF!,
NickHK
AS400 copy problem,
edwardpestian
Creating a macro to open as save other selected Excel sheets,
Wessie
Compare strings in cells and highlight difference,
Odin
CMD prompt output,
ilekallio
Re: 1 more and I think Im done,
Nick Hodge
Excel 2007 vba question,
Kaak
how to make this in Excel...,
Nevermind
Application.Dialogs(xlDialogSaveAs) = res ???,
Corey
Re: How to save compiled version of VBA macro,
Norman Jones
Hide Rows By reference to a cell,
SuitedAces
Hiding rows bt reference,
SuitedAces
Re: Dates,
Norman Jones
Data Validation list in Input Box... Possible ?,
Corey
Re: Altering code to accomodate empty space,
Norman Jones
Require some codes for variable in formula,
Seeking help
Create Calendar Wit Data Auto Fill using Excel 2000!,
James Cooper
Input Box value saves wrong WorkBook file & AUTO Sheet Numbering (1,2,3,4...),
Corey
Graph Source Data,
Brian
Use a button to copy the values of one range to another,
SuitedAces
help creating helper column,
Allen Clark
Sub that has an input of an array of ranges... what's wrong?,
Abraham.Olson@xxxxxxxxx
Paste Append?,
Kris
Flash a label,
SuitedAces
Open Hidden sheets to specific point,
rhani111
A class with two objects?,
Abraham.Olson@xxxxxxxxx
Conditional Formatting 4+ conditions, format rows based on cell,
nockam
Close All and Workbook_BeforeClose events,
Josh Sale
Re: Conditional Formating on Worksheet Change,
Mark Driscol
Re: Volume Calculator - Button,
Bearacade
Re: Unhiding all worksheets,
Bearacade
Re: Little Macro help,
Bob Phillips
prevent a special cell from being deleted,
jagexcel
Protect sheets via VB6 automation,
Maurizio BELLANTONE
Application.Transpose in VBA EXCEL 2003,
atemesov
Single Macro containing multiple subs,
tony_bender
Filter on cell value?,
QuickLearner
Validate Workbook Name,
AD108
Re: Userform initialize combobox using Chr() function.,
I Maycotte
RE: ActivePrinter in Excel changes!,
Jim Thomlinson
Auto Load an Add-In,
Scott
Print Format,
Eugene
Re: Select sheets based on what is in a range.,
Ron de Bruin
Using Currently Open Lotus Notes Mail Server Info in Excel Macro,
Scottms
Merging XLS Files,
wmureports
Re: I said "Keep this text! Not a date!",
pikapika13
RE: Pulling data from another WS,
Darko
find duplicates between rows, keep or delete entries based on ranked relevance,
elias . winson
Searching Database,
merritts
Cleanly Trimming text...,
Robert . Cordani
Run-Time Error 1004, Debugging,
I Maycotte
Variable from Userform to Macro,
Vikesh Jain
Refresh Data - Database Queries,
tpearo
VBA cell values,
Grymjack
Beginner help! error no return() or halt() function found on macro sheet,
steppin16
Problem with inserting picture.,
Abraham.Olson@xxxxxxxxx
Re: Userform data to the next available row,
Dave Peterson
Re: conditional formatting, multiple criteria,
Ardus Petus
File Save As through VBA,
sandip . dhamapurkar
Need custom color palette for form object on worksheet,
korrin . anderson
Re: Offset from a variable column to a fixed column,
Ardus Petus
Re: Printing VBA,
Mark Driscol
Access to another excel instance?,
derobin
Re: Retrieve from Acces,
Ron de Bruin
Associative arrays in VBA?,
Piotr Lipski
how to save .xls to .html please go through discription,
sujay
Is setting the transparent color of a picture possible?,
Abraham.Olson@xxxxxxxxx
Populating a ComboBox in a UserForm,
I Maycotte
Re: Calling Specific sheet in workbook with Code,
Bob Phillips
An array of Cells?,
Abraham.Olson@xxxxxxxxx
Runtime error 1004 - how to solve,
ladyhawke
Wrong number of arguments or invalid property assignment,
ajg@xxxxxxxxxxxxxxxx
Outlook Express - how to send value of a cell...,
bondcrash
Re: create sheets and copy rows,
Dave Peterson
Email value of a cell in Outlook Express,
bondcrash
Excel VBA Tutorial,
TechBookReport
Re: Calendar - conditional formatting?,
Norman Jones
- Re: Calendar - conditional formatting?,
Norman Jones
- <Possible follow-ups>
- Re: Calendar - conditional formatting?,
Thyagaraj
- Re: Calendar - conditional formatting?,
Mark Driscol
- Re: Calendar - conditional formatting?,
Mark Driscol
- Re: Calendar - conditional formatting?,
Valery2105
- Re: Calendar - conditional formatting?,
Valery2105
- Re: Calendar - conditional formatting?,
Mark Driscol
- Re: Calendar - conditional formatting?,
Valery2105
- Re: Calendar - conditional formatting?,
Mark Driscol
- Re: Calendar - conditional formatting?,
Valery2105
- Re: Calendar - conditional formatting?,
Mark Driscol
- Re: Calendar - conditional formatting?,
Valery2105
- Re: Calendar - conditional formatting?,
Mark Driscol
- Re: Calendar - conditional formatting?,
Mark Driscol
- Re: Calendar - conditional formatting?,
Valery2105
Re: how do i identify first and last row once filter applied,
Bob Phillips
invoke an event procedure with a shortcut key,
nliron
Need to display ANY file type...,
JessiRight77
Can anybody help..?,
Thyagaraj
Please Help! Column Header Lookup,
andypm5
Copy and Find macro help please.,
adelphus
Re: "Singel step"-box suddenly occurs and freezes during debugging,
Dave Peterson
RTD API,
JackInMadrid
Name Box Width and Height,
Werner Rohrmoser
Importing all the .txt files of a folder in a same WB but in different WSheets,
samuel . chausse
Re: Error using WorksheetFunction.Countif,
Bob Phillips
Pictures in Excel,
nat22
cut textbox,
by1612
Re: Charts using hidden cells,
Don Guillett
is there a way to search for a specific value in a formula?,
funkymonkUK
VB for plotting time line on xy graph...,
sacrum
Re: Open Command,
Paul B
Re: Immediate window,
Norman Jones
errrors while trying to delete a commandbutton,
funkymonkUK
Re: Excel sort vs VBA,
Norman Jones
- Message not available
- Message not available
Re: Auto_Open Select Worksheet,
papou
Pivot macros error 1004,
ymeyaw
Re: How do I find "?" character in a column using VBA?,
Bob Phillips
Select a range...,
derobin
Re: Check for Print success,
Duncan
Re: Deny User Save Option,
Duncan
Re: Macro for deleting every second Row of Data,
Kaak
Re: If Pivot Table Exists,
papou
Re: duplicates,
Duncan
Re: print copies of the same sheet with changing values in a box,
Kaak
convert string to columns,
Dave A
Conditional Deletion,
Seeking help
Re: Macros and China,
NickHK
Toolbar seperator line,
Desert Piranha
Creating a call log help.,
uscbryan
RefEdit problem: z-order of forms change,
aeroshanks
Question on how to reference multiple cells in VBA,
louisamarkham
Re: how to convert excel to .xls file,
NickHK
Re: Any easy way to conduct GARCH modeling?,
NickHK
Re: Concatenation with Pocket Excel,
NickHK
Re: Obtain information from Excel?,
NickHK
Re: Negotiating Cells in Specific Order,
Leith Ross
msg Box Title Not Working,
Corey
Inserting Multiple Rows,
chuck1968
msg Box Value to be Saved File Name ??,
Corey
Re: Excel Format Documentation,
NickHK
Re: Dir( ) function not working first time through,
NickHK
create event in class module,
x taol
find each of the items in an array and save result in another array,
lif
Move WorkSheets Within Same WorkBook!!,
James Cooper
Macro code to show a graph (in sheet2),
cenee
Open a file and read contents,
Striker
Re: Fractions displayed in cells, Why not in user forms?,
Dave Peterson
Private Sub Workbook_BeforeClose() really isn't working,
kartune85
Copy Formatting from one row to another using VBA,
louisamarkham
Dealing with different version of Excel using Visual Basic 6,
khundeen
Text to columns question,
spanishj
Changing a named ranged based on array size on a form,
Wanderer
Searching and Updating spreadsheet,
merritts
Re: e-mail code,
Ron de Bruin
Re: Do Until Question,
Ken Johnson
RE: find range of non-blank cells in colum,
Jim Thomlinson
Shrinking controls,
KD
Adding Checkboxes to a Form,
Bill
Code is not working,
Sheeny
Re: For Next Loop...Copying from a cell one column to another...,
Otto Moehrbach
Function dependent on prior cell value,
Post Tenebras Lux
Re: change event not recognized,
Bob Phillips
Search/Sorting data,
bach
if date=then populate cells,
inkrisitive
Re: sumproduct in Excel Macro,
Dave
Calling a private sub in Outlook via toolbar button,
sapphire
Re: Find a Worksheet,
Bob Phillips
Loop with Cell Change Event,
Adrian
Please Help.,
ikirin
Re: OLE DB Provider and Excel,
Bob Phillips
Re: Excel,
Jake Marx
Help needed on macro,
Anoetic
IDE, Search - changing default,
Peter Ostermann
Array data in SQL Query?,
mazzarin
loop through rectangles on worksheet,
jeichhold via OfficeKB.com
Standardise all cells at once,
asim
Manipulating Controls on a worksheet,
David Looney
Re: Changing Cell Text During Change Event,
Die_Another_Day
RE: Bug: Call Sub in other book,
Gary L Brown
Static Time/Date Stamp,
keith . e . graham
Symbol and Tahoma fonts in same text box?,
Abraham.Olson@xxxxxxxxx
Macro for updating a sheet in multiple files,
jijy
Re: RESETTING ORIGINAL FORMATTING ON SHARED WORKBOOKS,
Dave Peterson
Re: Compress into one page,
Otto Moehrbach
Re: How do I print multiple worksheets at the same time?,
Otto Moehrbach
- Message not available
- Message not available
Re: SUMPRODUCT issues,
Ardus Petus
- Message not available
- Message not available
Re: Renaming File,
Bob Phillips
Re: How do I average a list of times (i.e. "1:30" plus "0:20")?,
Bob Phillips
Trim function as a procedure - a simple example,
aztecbrainsurgeon
Website recommendations,
CarolineHedges
UserForm as a tool bar/ floating options for excel sheet,
Abraham.Olson@xxxxxxxxx
Last Row with Content - As a row,
nemadrias
Re: How change link source in long formula when source moved,
michael.beckinsale
Help with hyperlinks in pulldown list. Anyone know how?,
Wayne Knazek
Large formula to VBA if can be done?,
FurRelKT
joining two columns together,
englandfivegermanyone
Macro excel,
The Rookie
RE: Adding And Deleting Sheets,
Gary L Brown
.Refresh BackgroundQuery:=False,
ikirin
How can I use a loop here?,
QuickLearner
VB Script or Macro To Remove a row after it's copied to another sheet,
tdemartino
Conditional Formating,
markvdh
How can I get around "Find" if there's nothing to find,
CarolineHedges
Formulas don't calculate,
Brian Matlack
Re: SOLVER solversolve showref,
Dana DeLouis
How can i sum a range of cells ( Variable ) in a specific cell,
Thyagaraj
Re: Quirky Code,
Ardus Petus
Loop running really slow...?,
Buffyslay
Formula using color of a cell,
sa02000
deleteing specific rows using a userform,
s_ali_hassan
RefEdit in Class Module Problem,
Mark Driscol
Manipulating MS Word from Excel??,
Simon Lloyd
Re: moving a file to another folder,
papou
Re: Finding duplicates in a column,
Duncan
Re: Telling excel to update or not to update,
Utkarsh
Comparing two ranges,
Utkarsh
is it time to abandon Excel?,
QuickLearner
Limit Scrolling,
edwardpestian
Could not load an object because it is not available on this machine,
H . A . de Wilde
Re: Help Plss,
Bob Phillips
Can you help me?,
leonidas
Automatic naming Worksheet tabs,
rhani111
Help me insert a table of data into a body of an email,
funkymonkUK
Opening a file with changing dates,
kingkdz
about random no,
jinvictor
Do I need a control loop to produce worksheet?,
QuickLearner
Insert and delete rows,
leonidas
how to count rows,
Seeking help
Socket Connection via Excel,
Alexander Weiner
Border Macros,
Santa-D
Linked Workbook Update.,
paul . morriss
Macros using Add-Ins,
pelham
Close without saving,
LoveCandle
Compare string with integer,
hurriance
Class Module Problem,
Jason Zischke
Multiple Modules in the same workbook?,
kartune85
Re: datestamp a comment into a cell,
Norman Jones
Procedure not running automatically...,
kartune85
Nesting multiple subs with If...Then statements,
tony_bender
Workbook_BeforeClose?,
kartune85
Excel and Visual Basic,
arand
MAX Value of a CELL in ALL sheets in a workbook,
Corey
Re: Rounding in Excel,
Bob Phillips
Re: Parsing Characters - Bug ???,
Jim Cone
Objects in Excel,
ffyring
UserForms,
sparx
Refresh textbox to reflect scroll bars if appropriate,
Jim May
Is it possible to join columns where there is a match?,
QuickLearner
Re: Formula Not Working-Help Please!!!,
Frankey
Excel VBA Listbox,
shakeel_sadiq
Anyone know where I can find free VBA code for a user-friendly financial spreadsheet,
Abraham.Olson@xxxxxxxxx
Name assigned in workbook refers to range problem!!!,
brucemc
Require some help!,
augrunt
DoWhile Loop & Type mismatch error,
oakman
Re: Disable Cut and paste,
Norman Jones
Percentage in a cell,
mark evans
Re: how to Activate the previous Open, workbook..?,
Mike Fogleman
Re: Custom number formatting,
Mike Fogleman
+(-)ve values ends in Dr(Cr),
sasikumar
Match in VBA,
Hari
Re: template macro executing problem the 2nd time,
Don Guillett
Re: macro to search and list data,
Don Guillett
Hiding New Workbook created using Macro Recorder,
deelee
Re: how do I change a hyperlink to text,
Norman Jones
No cell-selection in worksheet,
Gert-Jan
Re: HOW DO I SET DATES TO SHOW ON MY SPREADSHEET?,
Leith Ross
Create New WB with copy of Sheets 1 & 2 when sheets count reaches 100,
Corey
Clearing Row Contents (using Intersect?),
deelee
copy and insert entire row based on integer in column A,
Dave A
Re: UserForm1.show fails if another workbook is open,
Leith Ross
Re: Return a value associated with a range of values, e.g. tax rates,
Mallycat
Re: VBA Auto_Activate,
Jim Cone
Large formula problem,
Jim28
Letters of Alphabet,
Bill
Getting screen coordinates from Range,
ektimo
Excel named cells or labeled cells question,
farseer
sum() using indirect(),
Grymjack
did you edit code?,
jseven
Installing Crystal Ball 4.0 on Excel 2003?,
Dominic
Refer to combobox in userform with variable,
lif
Re: Closing Workbook without Questions,
Norman Jones
Macros wont run??,
tallpaul
Re: Retrieving an Excel VBA Editor password,
Gord Dibben
Excell named cells or labeled cells question,
farseer
Place a variable inside a directory path,
Brad J .
Shellexecute fails with Excel,
rapple
Re: Rename Module via VBA,
Ardus Petus
variable not recognised in embedded macro,
R..VENKATARAMAN
Need help with pictures!,
RSisep
Re: Highlighting a Past Date,
somethinglikeant
VBA Cell Summation,
Grymjack
- Message not available
- Message not available
Wanted: VB expert to write in built macro in Excel,
iantontan
need change the number format,
gajendra
Macro to delete rows,
Jarvis
Timebomb protection of Code,
Frans Verhaar
Set Value from Vlookup,
ssjody
Re: Renaming files,
Ron de Bruin
- <Possible follow-ups>
- Re: Renaming Files,
Ron de Bruin
- Message not available
- Re: Renaming Files,
Ron de Bruin
- Re: Renaming Files,
Gordon
- Re: Renaming Files,
Ron de Bruin
- Re: Renaming Files,
Ron de Bruin
- Re: Renaming Files,
Gordon
- Re: Renaming Files,
Gordon
- Re: Renaming Files,
Ron de Bruin
- Re: Renaming Files,
Gordon
- Re: Renaming Files,
Ron de Bruin
- Re: Renaming Files,
Gordon
- Re: Renaming Files,
Ron de Bruin
- Re: Renaming Files,
Gordon
- Re: Renaming Files,
Ron de Bruin
- Re: Renaming Files,
Gordon
- Re: Renaming Files,
Ron de Bruin
- Re: Renaming Files,
Gordon
Re: Renaming Files,
jseven
Re: Renaming files from a number string inside the file.,
Ron de Bruin
Re: opening order macro for files in a folder,
Ron de Bruin
How do i call a macro from a cell,
KhanhNguyen
User name and greeting,
edwardpestian
how to drag and drop from a listbox to activecell with vba ?,
ka
Re: SOMEONE CAN HELP ?,
ward376
Find and copy in Excel,
TonyG001
Sending ONLY Range or Page x, BUT not entire Activesheet, How ?,
Corey
- Re: Sending ONLY Range or Page x, BUT not entire Activesheet, How ?,
Norman Jones
- Re: Sending ONLY Range or Page x, BUT not entire Activesheet, How ?,
Corey
- Re: Sending ONLY Range or Page x, BUT not entire Activesheet, How ?,
Norman Jones
- Re: Sending ONLY Range or Page x, BUT not entire Activesheet, How ?,
Corey
- Re: Sending ONLY Range or Page x, BUT not entire Activesheet, How ?,
Ron de Bruin
- Re: Sending ONLY Range or Page x, BUT not entire Activesheet, How ?,
Corey
- Re: Sending ONLY Range or Page x, BUT not entire Activesheet, How ?,
Corey
- Re: Sending ONLY Range or Page x, BUT not entire Activesheet, How ?,
Ron de Bruin
- Re: Sending ONLY Range or Page x, BUT not entire Activesheet, How ?,
Ron de Bruin
- Re: Sending ONLY Range or Page x, BUT not entire Activesheet, How ?,
Corey
- Re: Sending ONLY Range or Page x, BUT not entire Activesheet, How ?,
Norman Jones
- Re: Sending ONLY Range or Page x, BUT not entire Activesheet, How ?,
Corey
- Re: Sending ONLY Range or Page x, BUT not entire Activesheet, How ?,
Norman Jones
- Re: Sending ONLY Range or Page x, BUT not entire Activesheet, How ?,
Corey
- Re: Sending ONLY Range or Page x, BUT not entire Activesheet, How ?,
Ron de Bruin
- Re: Sending ONLY Range or Page x, BUT not entire Activesheet, How ?,
Corey
- Re: Sending ONLY Range or Page x, BUT not entire Activesheet, How ?,
Norman Jones
- Re: Sending ONLY Range or Page x, BUT not entire Activesheet, How ?,
Corey
- Re: Sending ONLY Range or Page x, BUT not entire Activesheet, How ?,
Corey
- Re: Sending ONLY Range or Page x, BUT not entire Activesheet, How ?,
Ron de Bruin
- Re: Sending ONLY Range or Page x, BUT not entire Activesheet, How ?,
Corey
- Re: Sending ONLY Range or Page x, BUT not entire Activesheet, How ?,
Ron de Bruin
automatically assign a hyperlink to a cell,
Brad J .
leading zeros,
Fernando Duran
Re: Excel VBA: calculating checksums,
mrjames
Need formula for date ranges Please & Thanks,
Digital2k
Re: Conditional Formating ?,
Chip Pearson
Data extraction tool problems,
QuickLearner
RE: Copying Data Between Two Spreadsheets,
crazybass2
Using the VBE: Selecting vertical instead of horizontal,
brucemc
Workbook access,
Brian Matlack
Location for DLL used by add-in (XLL),
Gonzalo Diethelm
Probs w/Displaying Graph from Excel Interop Add-In Function,
algorimancer
RE: Challenging Formula,
Jim Thomlinson
Re: character count,
Chip Pearson
Unable to set DisplayAlerts property,
leonard522@xxxxxxx
RE: Automated Printing,
salut
Re: Find Value and go to that Value in Another Sheet,
Die_Another_Day
Fit to page macro,
kixelsid
QueryTable problem when running first time only,
T_o_n_y
Re: Move of Sheet screws up Stored Sheets,
Jim Cone
Re: Determining Row number where two conditions match,
Ardus Petus
Excel Row limitations,
Harry88
Email help...need IF statement for more than one recipient,
tanyhart
Generating Error for UDF,
Loomah
Write data in Last Row-column "B",
maperalia
copy and paste from and to protected sheets,
Tonso
RE: do while loop,
MaryR
Re: Need help with form logic,
Bob Phillips
Go to. . . after data entry,
smunn
Re: Recalculate function,
Bob Phillips
Re: Need Find and color row macro,
Bob Phillips
Worksheet Codename - Crazy Method Error!,
EphesiansSix
WHY OH WHY! ... creating a dynamic array of outlookmail items, then display them.,
WhytheQ
Re: File, SendTo, MailRecipient code,
Ron de Bruin
Re: Personal.xls,
Bob Phillips
List Box Row Source,
jhahes
Any way to copy contents of print area with macro?,
uwajes
Post results to a new workbook,
Rambler
Excel Web Query not displaying Umlaut correctly,
lori_caillouet
Macro to link two files- please help!,
kai_charmer_ge
Re: Averaging ranges,
SteveM
How to select an added worksheet,
davegb
macro for converting number stored as "text" (or preceeded with ') to "number" formatting,
markx
Re: Range to increase/decrease with data,
Tim Marsh
Re: Validation list problems,
xLBaron
Migrating modules from 98 to XP,
mkingsley
Re: VBA Interview Questions,
aidan.heritage@xxxxxxxxxx
Copy cell values if cells match on two diff sheets,
dan
Macro for deleting rows,
leonidas
Re: Print 1st page as Landscape and 2nd page as Portrait, HOW ??,
Corey
Copy rows with a specific value in column A,
Gert-Jan
Re: Stupid Syntax Question,
Norman Jones
Re: InsertRowsAndFillFormulas,
dmcritchie_xlmvp
How can I rename a module in VBA?,
CarolineHedges
Copy worksheets from one WB to another with external Macro,
shabb090177
dynamic range names in Edit -> Go to,
Tim Marsh
A challenging task in VBA,
Zuzeppeddu
Error message - state all strings,
cereldine
Trouble Using InputBox Method to Select Range from Other Sheets,
pao_e_vinho
Re: Procedures/Macros in the list of Macros,
Ardus Petus
Table to Database layout,
michael.beckinsale
Row colour change on input,
CarolineHedges
Re: Inputbox macro for multiple cells,
Ardus Petus
combination lists,
jim
Worksheet Function,
VBA Noob
AutoFilter Data,
AdamPinoy
Re: Automatic accept all pop up dialog box,
Norman Jones
Re: log of when files opened...,
AmyTaylor
Macro Stepping,
George
Problem when uninstalling an Add-in,
Rohit . Parashar
Re: How to get a macro to execute for every xls thats opened on a mach,
Nick Hodge
Re: How do I set up a business customer information system in Excel?,
Nigel
Shortening a Macro,
Paul Sheppard
Re: Color formating,
Norman Jones
Recording a Macro with an Add-In,
Pelham
link dynamic data to cell?,
Theguyfromnj
Re: copy and paste and clipboard contents message,
tumbleweed
Record the time a user selects a macro,
marcusmccown
VSTO: insert one row into a 1-row range,
jj_online
Simple code to append numbers to the existing data in the cells,
Hemang Shah
Re: How can I get Euros in the taskbar of Excel 2000,
NickHK
Extracting Top 5 & Bottom 5 Variances using a Macro Button,
william4444
Creating a Macro Button to Extract Data,
william4444
Re: Insert symbol,
Gord Dibben
Re: apply default "summarize by" for each pivot table field,
Debra Dalgleish
Re: pivot tables,
Debra Dalgleish
Workbooks.add (?RefName?),
kartune85
Re: Stop marco allert and update link allert when opening spreadsheet,
Nick Hodge
Re: Query Table "Connection" Prevents Excel from Quitting,
Mike Fogleman
RE: Schedule a macro with user defined settings,
crazybass2
Re: convert table of hyperlinks,
Mike Fogleman
Simplest way to show/hide boxes when a Macro is run,
white-ryland
NetDDE DDEShare and Excel,
smukhtar
Re: module moving,
39N 95W
Linking a Drop Down Cell with the Macro,
white-ryland
Multiple UserForms not closing,
ceshelman
How Do I Use an XLL Add-In Function from Code?,
TC
Re: Calendar...,
Bob Phillips
Determine Point in Filtered List for Chart,
John Michl
quantinfying dates?,
cjwenngatz
Question about sizing Userforms programmatically,
39N 95W
Cut & Paste into column only if column cell is blank.,
vinhdang@xxxxxxxxx
find the next empty cell: expanded,
stew0720
Re: Hide Print option from File Menu,
Ron de Bruin
Re: Selection Change Event,
Otto Moehrbach
Skip sheets while indexing,
Melinda Chase
Re: How to test for Not Nothing,
Otto Moehrbach
Make VBA open a browser window,
Frans Verhaar
Dynamic numbers in a static enviroment,
trentleshovsky
Re: FormulaR1C1 error on a SUMIF,
Bob Phillips
VBA Sorting question,
creese
Issues with Pivot Chart,
Sagu
Keeping number static in a dynamic enviorment,
trentleshovsky
Aligning rows of data,
e abor
Is is possible to set a border NOT on the edge of a cell?,
Abraham.Olson@xxxxxxxxx
Re: No characters ???,
Norman Jones
Help please in debugging this macro,
sungen99
write array to range,
muster
Parsing a file and displaying contents in excel,
satya . mahesh
Re: How do I convert 5.35 to 5:35 in excel?,
Ardus Petus
Delete sheets on exit,
tanyhart
If - Then synthax,
Turquoise_dax
Re: Timer to close workbook when no activity detected,
Bob Phillips
Quick question..:P (Row range),
Turquoise_dax
Select a Row where the cursor is active,
daved37
Re: EN EXCEL NO PUEDO COPIAR HACIA ABAJO UNA CELDA CON BUSCARV,
Ing. Luis Fernando Ortiz M.
Range - Offset (Major help needed),
VBA Noob
Separating,
T De Villiers
Queries, Protection, and calculations.,
NJP
Last needed info (validation),
Turquoise_dax
Re: vlookup in a text box,
aidan.heritage@xxxxxxxxxx
[hlp]: How to copy a sheet to new wkbook and close the var at the end,
pao_e_vinho
How do you refer to empty cells in coding?,
Turquoise_dax
Re: How to get Word Header Text into Excel VBA,
aidan.heritage@xxxxxxxxxx
Lock Certain Cells that Meet Certain Certeria,
daved37
Missing something in my code...,
Turquoise_dax
Re: MULTI VLOOKUP error #N/A,
DAV135
Re: Replacing UDFs with their value,
Johnny
programmatic access to visual basic project is not trusted,
Rob Kings
Re: How do you edit macros outside of Excel?,
Norman Jones
copy a command button to new worksheet,
elaine
Conditional formatting: NEED ANSWERS FAST!!!,
Turquoise_dax
Rows Insertion,
b166er
Delete all sheets except the active one...?,
derobin
excel tip incomplete,
rss
Employee Schedule,
henrikjt
Re: Comparison Operators,
paul . robinson
Proper Case in Function,
VBA Noob
How to kill excel from visual basic,
alexia_net
Re: Calculating number of occurences based on dates,
Bob Phillips
NETWORKDAYS function?,
Darin
Re: CheckDate and return to usrfrm,
Bob Phillips
replace formula references with previous sheet names,
helenburgess
Re: Using command button to return numerical value from worksheet,
Brad J .
Customizing "sort" macro,
markx
compile error?,
leonidas
Shared Workbook - how to disconnect the pop-up...,
bondcrash
Re: "Asin" doesn't work in VB for Excel macros,
Dave Peterson
Re: Help button,
Dave Peterson
Array - Object required???,
Buffyslay
Formula needed - automatically calculate session time totals for each user,
optimusprym8
Create a drop-down list from a range of cells,
tweety127
about usename,
jinvictor
Insert rows macro,
leonidas
Re: MessageBox and then return to usrForm,
Duncan
Re: on open, always display sheet1,
AP
Adjust Audio Volume,
AP
Re: Help VLOOKUP function,
paul . robinson
Having problems writing macro in Excel,
ernestgoh
Re: Problem with Excel VBA script, decimal bug,
paul . robinson
Show all workbooks open,
bondcrash
Cannot create instance of C# COM server compile with VS 2005,
Ray Lau
screen updating,
miikka1978
Sum the greatest run of negative numbers,
Ev
Re: type mixturte in ByReference argument,
Bob Phillips
Re: pivot tables & offline data access,
DM Unseen
Re: Floating Drawing Object,
NickHK
Re: Act if spell check box occurs,
NickHK
Re: speech feature in excel,
NickHK
Re: color on text in a cell,
Norman Jones
Macro to Save As with filename based on cell contents.,
imafellow
Re: Macro and VB development,
Norman Jones
Re: error message,
Norman Jones
Correct Procedure to Open Help File?,
JK
Excel window closed but process still running,
Jessica
Conflict with Workbooks,
kartune85
I must be tired, because basic Math isn't working.....,
marston . gould
Macro to clear all images?,
grahamhurlburt
how to select cell range with form?,
jagexcel
Need a simple printing macro code,
cenee
Completely Erase ListBox,
Johnny
Open another workbook and then some.... from another Workbook !!,
Corey
- Re: Open another workbook and then some.... from another Workbook !!,
Corey
- Re: Open another workbook and then some.... from another Workbook !!,
kartune85
- Re: Open another workbook and then some.... from another Workbook !!,
Norman Jones
- Re: Open another workbook and then some.... from another Workbook !!,
Corey
- Re: Open another workbook and then some.... from another Workbook !!,
Norman Jones
- Re: Open another workbook and then some.... from another Workbook !!,
Corey
- Re: Open another workbook and then some.... from another Workbook !!,
Norman Jones
- Re: Open another workbook and then some.... from another Workbook !!,
Corey
- Re: Open another workbook and then some.... from another Workbook !!,
Norman Jones
- Re: Open another workbook and then some.... from another Workbook !!,
Corey
- Re: Open another workbook and then some.... from another Workbook !!,
Norman Jones
- Re: Open another workbook and then some.... from another Workbook !!,
Corey
- Re: Open another workbook and then some.... from another Workbook !!,
Norman Jones
- Message not available
Re: Application.Volatile Question, HelP!!!,
Dave Peterson
Test for open workbook,
kartune85
Charting,
Jack
Option Groups and Select Case,
Nubby
Re: Can time be measured to milliseconds?,
RB Smissaert
Create new workbook when 00 sheets are reached,
Corey
Re: Check part of cell for data,
ben77
How to create un combo box on a cell,
Claire
Re: Count NonBlank Cells,
Bearacade
reference to sheets,
ann
Pass variables from Worksheet_Calculate sub to Module,
John Michl
Re: Replace Existing File,
Dave Peterson
Search by columns or by rows,
davegb
Refresh Query based on variable,
GregR
count based on two conditions,
jhahes
Drop down population...,
neilcarden
Command Buttons,
msals22
RE: Displaying a User Form,
crazybass2
Re: Select one cell below active cell,
Trevor Shuttleworth
Re: how to find the last line?,
PCLIVE
Detecting worksheet change from modeless userform,
Kent
RE: How to check if a cell is part of a series of cells (not a nea,
JeKaRe
Thanks to the Group!!!,
Jay Flowers
Re: Worksheet_Change slow,
Bob Phillips
Pivot Table Automatic Grouping,
Spreadsheet
RE: Set other workbooks while writing to ThisWorkbook,
Nicole Seibert
Re: Can VBA tell a user a macro is running until it ends?,
Bob Phillips
How do I create a custom image for a toolbar?,
korrin . anderson
Dropdown to populate next blank cell,
pmgreen
RE: Finding Unique Entries Among Two Columns,
Jim Thomlinson
Consolidating entries question for excel/access,
atomiks
Overwriting text files,
Orlando Acevedo
RE: worksheet_Change with Formulas,
tdw
Textbox Validation not retaining focus,
tdw
if cell contains string then make cell next to it equals "X",
alex . kemsley
Save as web page formatting question,
MarCab
Re: Check for Sheet Password Protected, Unprotect with multiple passwo,
michael.beckinsale
Textboxes in Excel 2007 Beta 2 Macros,
bwillis88
Re: Insert picture when cell changes,
aidan.heritage@xxxxxxxxxx
- Message not available
- Message not available
- Message not available
Resize array based on number of 'used' elements,
John
Collections problem,
John
Re: No macros but still Excel displaying messages everytime I open Exc,
PCLIVE
Finding only spreadsheets with macros,
davegb
Re: 2007 Bug? ChartTitle.Characters.Text not working,
bwillis88
Body Text properties when sending email through Lotus Notes via Macro,
PCLIVE
Re: Array dimension,
Bob Phillips
Re: SpinButton_Change when Date,
Bob Phillips
Macro to autofill column,
dwight . yorke
Worksheet Selection Change event not firing??,
Simon Lloyd
Application.visible........,
Duncan
- Re: Application.visible........,
Bob Phillips
- Re: Application.visible........,
Duncan
- Re: Application.visible........,
Bob Phillips
- Re: Application.visible........,
Duncan
- Re: Application.visible........,
Duncan
- Re: Application.visible........,
Bob Phillips
- Re: Application.visible........,
Duncan
- Re: Application.visible........,
Bob Phillips
- Re: Application.visible........,
Duncan
- Re: Application.visible........,
Bob Phillips
- Re: Application.visible........,
Duncan
- Re: Application.visible........,
Bob Phillips
- Re: Application.visible........,
Duncan
Re: Macro to move files from one directory to another,
Bob Phillips
Excel File Conversion (Also posted in MISC),
Turquoise_dax
import Nvarchar(max) column from sqlexpress,
ladyhawke
Re: Excel is closing itself...Yikes!!,
DAV135
Adding all data types from every n'th column,
ivanlockyer
Re: Macro Question - Find duplicate and make unique,
votequimby
Creating Color Row "Control Panel",
SteveC
'Do Until...' Restart,
Jack
Custom error-message for MatchRequired ComboBox,
Gert-Jan
Re: array within array,
Bob Phillips
Widening the names drop-down, revisited,
Nile_Hef
Re: Disabling Security Messages (Macros),
Hans Dummer
Looop through many sheets,
Hru48
multi dim array?,
Buffyslay
Head against a brick wall !!,
WhytheQ
Re: Conditional Formatting in For:Next loop - won't work!!!,
Bob Phillips
FileDateTime function - how to make it authomatic?,
bondcrash
please help, ned urgent,
jinvictor
copy nonblank rows from many worksheets and paste them onto one worksheet,
starman
2 vba join together,
jinvictor
MSFlexGrid RemoveItem,
gti_jobert
Need desperate help: microsofts macro for converting large text files more than 65000 rows,
fari
Re: Defining the length of an array variably,
Ardus Petus
VBA sum - doesn't work with only one value.,
Bevy
Entering date depending on another cell being populated,
wurz
Re: UserForm,
ward376
Re: looping and naming,
Bob Phillips
Re: Counting textboxes,
Norman Jones
Out of Subscript error while opening a Userform,
shivboy
Shared Workbook - Saving problem,
bondcrash
Re: Improve macro help,
aidan.heritage@xxxxxxxxxx
Progress Bar/worksheet,
welshobit
Re: Placing Cursor in a Cell,
NickHK
Send out email if,
Vlad999
Can you shorten these macros?,
leonidas
search value as part of a cell value,
Nogi
Status Bar,
Vikesh Jain
How to disable save message when I click the cross to close the file,
hon123456
Checking empty cells,
Diez
Figuring out hyperlink in a cell with a macro in VBA,
Nasir . Munir
Re: Remove a cell from a multiple selection,
Norman Jones
Passing Constant Arguments to custom Subroutine & Functions,
cLiffordiL
Re: copy entire row, not just cell in row,
Tom Ogilvy
generate sequence of number,
cyzax7 via OfficeKB.com
Re: format listbox,
Dave Peterson
How to open many excel files efficiently,
xs
Re: Can I access the "Windows in Taskbar" checkbox within a macro?,
Norman Jones
Sorting problem in a macro,
jonco
Re: DragDrop onto a selected range,
Chip Pearson
Extracting data from directory listing,
DK
Re: Copy from one sheet in a workbook to another sheet in another work,
mpeplow
Should be simple,
mpeplow
Which columns AutoFilter is on.,
brittonsm
Re: Dynamically set the value for Field in auto filter,
Mallycat
Range Select with ActiveCell and Offset property,
AJ Master
Re: Can excel automatically send e-mail when particular cell is change,
Ron de Bruin
Filtering,
dok112
Macros question,
cooldyood
Re: Deleting Empty Rows,
Ron de Bruin
Comparing current time to a particular cell,
areed
Re: copying folder contents,
Ron de Bruin
Merge cells,
sungen99
Userform Checkbox,
Bill
Re: Copying data to from one file to another file,
Ron de Bruin
Color Row Macro Problem, adapted from Patrick Malloy macro,
SteveC
Re: Kill all Task Panes?,
travich
Excel 2003 SP2 Task Pane Disabling Does Not Work,
travich
RE: defined name,
Gary''s Student
Re: Auto Update Time When Cell Changes,
Mike G - D.C.
Re: Copy a sheet in one workbook to another workbook in VBA,
MartinShort
Re: Message,
markwalling
Re: Hiding rows,
Ron de Bruin
Re: Removing blank rows,
Ron de Bruin
Protecting Cells,
Scott Nash
changing a cell reference,
I Maycotte
Re: Addins - Calling an addin function from within VBA code,
Ardus Petus
Expert Required,
ceemo
Re: display file open box,
Ron de Bruin
Re: aout open no workeee,
Ron de Bruin
Changing combobox properties,
leonidas
ADO connection with workgroup Access database,
ca1358
Re: Rename files with variable names,
Ron de Bruin
Can this be done???,
WarrenC
Re: Use shape location to clear cells,
Ron de Bruin
Re: Use shape location to clear cells,
Dave Peterson
Breaking a workbook into multiple books,
Doug Lowe
Re: File list,
Don Guillett
Re: Excel Sheet Compacting?,
Ron de Bruin
invoking a add-in with an if statement,
jcrowhurst
repost: clickable graphs (hyperlinked) used to update source data? maybe an activeX?,
KR
do loop problem,
dwalkerc
Excel 2007 macro recorder,
Bruno Campanini
Re: Problem in User Forms,
witek
VB Code works in 2000, but not 2003,
mleviton
List box query,
Greg
Making an Excel form (with a macro) Blackberry friendly,
ljsmith
list of mail in BBC from excel,
...Patrick
Importing new data,
ikirin
Re: programically refresh pivot chart formatting,
William
RE: Excel to SQL,
Jim Thomlinson
I am missing something (hide / unhide rows with buttons),
Turquoise_dax
combination,
RobcPettit
inserting Rows,
Taru
Requesting user input for a number?,
StargateFanFromWork
Finding Sets - Difficult one !,
sandip . dhamapurkar
Do not Update On Open,
Brian
Validation in userform,
Gert-Jan
Need to know what is wrong with this 3 line code (row hiding with conditional formati,
Turquoise_dax
Need to open the Function Arguments window from VBA for a user defined function.,
korrin . anderson
Re: Better lookup code?,
Bob Phillips
Macro based on command button location?,
mattylance
Re: Name each Worksheet with a name?,
Ardus Petus
Locking the excel running the macro,
gbirdsong@xxxxxxxxx
How to program a macro to hide rows with conditionnal formating,
Turquoise_dax
Userform: looking for and deleting character,
Gert-Jan
Re: Range,
Bob Phillips
ADD IN help,
cmpcwil2
Excel 2007,
AP
Change properties of a combobox with VBA,
leonidas
Filter function - exact match...,
pmguerra
Tricky Date Calculation,
dan
Re: Extracting Text to Separate Textboxes,
Ardus Petus
Re: Standardizing Page Set Up for Muliple Sheets,
Dave Peterson
How to search fields and then add to value of cell using vlookup or ?,
FurRelKT
help needed with excel programming!!!,
gem.g
Re: Need macro to remove blank rows,
aidan.heritage@xxxxxxxxxx
- Message not available
- Message not available
Re: Closing Workbooks,
Norman Jones
SOMEONE MUST KNOW!!... keepItCool?? Tom?? Dave??,
WhytheQ
VBA image control,
Piotr Lipski
Delete a module with VBA,
Les Stout
Re: Looper Blooper,
Norman Jones
Counting character in textbox in userform,
Gert-Jan
Re: complicated calculations,
Bob Phillips
Simple Copy/Paste from one workbook to another workbook,
becuzimmike
A One-liner,
T De Villiers
Importing on certain rows from a text file into excel,
kennethstrain
Re: MACRO every 2nd Coulm want delete in selection,
Norman Jones
Re: comparing data,
Norman Jones
Re: Excel VBA procedures running at erratic speeds,
Norman Jones
AJAX combo box in excel,
mr . ashish . shah
Re: Nested For..Next Qn.,
aidan.heritage@xxxxxxxxxx
Re: Object required, fault 'No 424',
Norman Jones
Prevent code in "Sheet Activate" from running when sheet made visible from other macr,
Simon Lloyd
Re: Calendar Control,
Norman Jones
Automatically solving for X or Y intercept on a log or exponential graph.,
jed . needle
New try, Help needed,
miikka1978
Perform Cell Value Find across ALL Sheets,
Corey
Only opening a workbook by User Name or Machine Name???,
Simon Lloyd
Re: setup new user in outlook,
NickHK
Lotto number search,
sharkman992000
Copying new activesheet after other activesheet is hidden?,
Simon Lloyd
Printing Query,
Greg
Re: Using a macro and/or button to open the VBE,
NickHK
Re: Help with code please,
kartune85
SaveAs File Path Method,
kartune85
Re: Runs in macro but not in procedure...why?,
Leith Ross
Re: Can a conditional formula display it's results on a new row?,
Tom Ogilvy
Re: Freeze titles (Figer les volets),
Tom Ogilvy
Re: how to specify only if 3 characters or less,
Tom Ogilvy
Re: computer_name,
Leith Ross
Re: How can I change range name definitions as the No. of rows change.,
Tom Ogilvy
conversion of text to numeric,
Larry Empey
Re: Arrange sheet in specific order with VBA,
PY & Associates
Code to Create a new WorkSheet,
Corey
macro to export a range to a text file?,
icystorm
Concantenated SUM() problem,
Grymjack
Re: Format Cells Dialog,
Jim Cone
Does excel VBA programme has a size limit? Or some other problems caused this problem?,
liu . xiaomu
RE: Sorting specific data from one sheet to another,
Mike Q.
ScreenUpdating and making Sheets Visible - flicker?,
Gordon Smith \(eMVP\)
Number formate of Integer,
Alf
Re: Problem with RICHTX32.OCX,
RB Smissaert
A visual basic value copy BUG?? - accounting format has copy problem!!,
yunyanl
Re: Rename a workbook to an automated name (i.e. date) with a macro,
john . dorn
Finding when there are no directdependents,
sm34gm
Problem: error on numeric,
willz99ta
How to create many txt files from a Excel file ?,
demianill
stop copy highlight without clearing clipboard,
RB Smissaert
Change Name on Worksheet Tab,
Bill
Re: Many Nested loops,
Bob Phillips
Populate a form with data from a range,
randallwilkins
Advanced Searching,
Josh
RE: Search Column - Find Multiple Entries - Sum Then Delete to Sin,
watkincm
find and paste Blocks,
Taru
Re: IF statement to activate worksheet & select Range,
strive4peace
More Find/REplace from table questions...,
deforsythe
Filtering and user input,
Lvenom
Re: Splitting up address,
casey . chambliss
multiple hyperlinks: Help,
thassoun
Re: Run two macros in the same time.,
Jim Cone
Re: Can I run two macros in the same time?,
witek
copy paste codes,
Taru
Macro Distribution,
dan
Please help me refer to a fixed value.,
funkymonkUK
Copy cell value to new worksheet, based on find results,
dan
Textbox Format,
Greg
Wildcards in VBA,
oodam
Re: Determine if Named Range exists in Worksheet,
Ardus Petus
Translation of VBA from PC to MAC,
alina b.
Removing Gridlines in excel, from another application,
iambalrog
SQL Query Destination as an array varable,
casey . chambliss
Re: Active X component can't create object error,
Dave Patrick
Bug - Add OLE Object to Worksheet crashes out Excel 2002 SP3,
John.Greenan
Equivalent to Template Wizard for Excel 2003,
michael.beckinsale
Find lowest missing integer in a column,
Casey
Retrieve data from unopened workbook,
EMoe
Getting embeded Excel worksheets with macros in Word to work,
dwight . yorke
activeworkbook counting,
nozben
math,
RobcPettit
- Message not available
- Message not available
Using worksheet_change to change value of target cell??,
mark . diffley
Date not formatting properly,
David Sisson
"Start a new group" coding possible for a commandbar (floating toolbar)?,
StargateFanFromWork
VBA Code For OR-Function Using Cell Property,
kylie
please help me with my looping of copy worksheets,
funkymonkUK
Cell formatting based on date when value was last modified...?,
richardharwood
RE: Macro Help – Extracting multiple entries from cell,
Bob
selection to color cell if the word promise is in cell,
DKY
list of commands,
Taru
rearranging data,
Taru
Is there a quick way to find sub references in code?,
excelnut1954
Re: Stopping the Macro Warning Message,
Ardus Petus
Re: length of an array,
RB Smissaert
Re: Setting the BackColor of a Static Window !!,
RB Smissaert
VBA Error "Type Mismatch",
steve@xxxxxxxxxx
Allow E-mail from Poster -- Groups Question,
Zone
Add macro with macro,
Gert-Jan
Re: "Show all" filtered rows,
paul . robinson
Complex Numbers in Excel?,
Oliver Gräser
Re: Hide specific sheets on closing file,
Norman Jones
Re: YOU WANT KNOWLEDGE AS WELL AS END ONLY 4,- EUR >> OVER 400,000 EURS BECOMING?,
raypayette
Protect row,
jzifodya
Re: Bug, multiple selection of shapes,
Peter T
trimming cell contents?,
Jeremy Turner
Re: refering to address,
Bob Phillips
Re: Vb Code,
Bob Phillips
Re: saving multiple sheets into one csv file,
Mallycat
New to Group Need If Then help,
gbirdsong@xxxxxxxxx
Re: sorting out data based on 3 alpha characters followed by a comma,
Mallycat
Re: RangeFromPoint ... on a chartsheet ?,
Peter T
Re: Count number of textboxes,
Ardus Petus
Absolute reference in VBA,
leonidas
Check if folder exists, if yes just copy sheet in to folder?,
Simon Lloyd
Desktop shortcut,
Greg
Re: array,
paul . robinson
- Message not available
- <Possible follow-ups>
- Re: array,
Bob Phillips
any good reference material out there?,
funkymonkUK
Re: TextBox,
Bob Phillips
Re: checkbox,
Bob Phillips
Re: How to assign keyboard shortcut to existing Commandbar controls,
Norman Jones
about save or save as,
jinvictor
Change the default respond in method DIsplayAlert,
raizwai
Re: Calculating parts costs rounded to the nearest $15 in Excell,
Tim Williams
Upper case in textbox,
Greg
Adding sheet,
Greg
Can I put Multipage control on workseet,
hon123456
Copying sheets to a mastersheet Help needed,
auspcs
Check to see if date is = to Sunday,
Brian
Re: autosorting protected data with macros,
Gord Dibben
Re: importing files from a directory,
Jim Cone
Re: how do i find my threads,
Norman Jones
Outlook Voting button,
Andrew
adding content to a table by filling a sheet,
Borgas
Re: Open files from Combo box,
Chip Pearson
Re: Excel VBA Macro Running DOS Application !!,
raypayette
Data type to hold decimals,
James Cornthwaite
Record Data at Time Intervals,
herman7782
Adodb with MSXML, no results,
Marcos Hercules
Tricky one ( variant type text to be unaffected by a minus),
James Cornthwaite
Re: Menubar to Sort,
Leith Ross
Re: Replace text in specific column,
Tom Ogilvy
ontime error,
gmferg1
Re: deleting the apostrophe,
Tom Ogilvy
Re: copy to netprinter,
Tom Ogilvy
times of opened,
jinvictor
limited usage,
jinvictor
Using Autofilter with User Input,
kylec
Re: MACRO for Deleting every 2nd ROW,
Tom Ogilvy
Excel 2003 Calculate Event,
Peter Haserodt
Prevent anti-aliasing in Image Control,
Jamie Ballingall
coding tech,
x taol
Re: hyper links in pull down menus,
lexcel
Excel Database Question,
kinetic
Re: excel webbrowser,
Chris
Re: Auto hide sheets,
Leith Ross
Find and return data based on a range,
egeorge4
listbox,
x taol
Run-time error using late binding,
DaBookshah
Help with writing a macro,
SHII
Re: macro to delete rows?,
Mallycat
How do I control Auto Filter in VBA,
Mallycat
out of memory problem! what to do for large matrix operations?,
MCM
Re: DateAdd,
Bob Phillips
Re: Disabling Auto_Open in distributed worksheet,
Simon Lloyd
Cell designation,
Ed
Frame from Control Toolbox?!,
daniel . hurst
Running an add-in recursively on embedded files,
akullen
countbycolor counts all cells in a merged cell,
dsamson
Re: Print Marco with a Combo Box,
Tom Ogilvy
public const availability?,
lcoreyl
Excel Looping code....,
have_a_cup
Comparing 2 Spreadsheets,
mizzrizz
Need Companion Code,
JimMay
Excel macro,
ednewbie
Setting Names from a workbook to a value in a Macro,
Abraham.Olson@xxxxxxxxx
Textformat with mouse-over in userform,
Gert-Jan
Re: how do i make macro program on excell for create new txt file?,
Don Guillett
Move contents of selected cell down one, and to the left one cell?,
Albert Einstein
Re: countif,
Don Guillett
Re: Please add this in excel 2007 if not I am stuck with 2003,
Nick Hodge
Worksheet events problem,
daniel . hurst
popup box title name,
Corey
My CommentBox is Visible Afterwards,
JimMay
Re: How do I,
VBA Noob
reduce public variables,
RB Smissaert
how to stop running vba code without loosing printed data on the sheet?,
MCM
Re: Problem passing a large safearray to Excel,
Peter T
TextBox value,
AD108
Run Macro in other computer,
hurriance
Re: Delete rows that cell value is "No",
Ardus Petus
Running a macro based on combo box value,
m3s3lf
Use of "application",
Desert Piranha
- Message not available
- Message not available
Create Chart from highlighted rows,
Chris
Re: Splitting a workbook,
Dave Peterson
Re: Multi Listboxes with data dependent upon user choices,
Dave Peterson
Password to access code,
Corey
Binary file reads in User type incorrectly,
shayneh
Code to Exit Excel,
Corey
Re: Worksheet just disappeared,
Chip Pearson
Copy Excel 2003 "status bar" sum to cell?,
Dennis Shannon
Macro/VBA to delete rows in Spreadsheet,
Colin Foster
Programmatically pasting a Function locks macro,
diglas1 via OfficeKB.com
Re: How to make userform disappear while called subroutine is running,
mrice
Problem with function creation,
terminator_ba
SOLVER in VBA,
Cornelia
Re: Advanced Filter VB Script for Variable Criteria Range,
Ron de Bruin
Re: Sheet reference in VBA,
Chip Pearson
find text similar to yyyy-mm-dd in string,
davidbarbetta
Chart does not work,
Baha
Activating 2 textboxes for scrollbars,
excelnut1954
Can't test Range for Nothing,
Peter Chatterton
Saving w/s in new w/b as w/s name???,
Simon Lloyd
RE: Formatting multi-line text,
Tom Ogilvy
Code in userform/worksheet vs. in Module,
davegb
Copy text to the Text Box,
Flintstone
solver constaints not satisfied,
felicitycui
Same code - errors on different machine?,
JWM6
Data Input,
Igor . G . Borisov
Creating Macro to edit cell,
Tiffany . Pettit
Re: Copying from sheet to txt-file,
RB Smissaert
Inefficient macro won't complete,
Fox via OfficeKB.com
Re: export to csv file (comma problem),
Jim Rech
Combo Box, deleting rows,
mayou
output data from excel into text file using vba,
pier59
Error: The text string you entered is too long.,
GTVT06
RE: Runtime error 91,
Tom Ogilvy
Application . filesearch doesn't work,
somethinglikeant
Re: Colour of Progress Bar in Excel 2002,
Chip Pearson
Re: NEED HELP: For this Code,
Bearacade
Re: Background of Header,
Chip Pearson
Advanced Filter vs. Macro for deleting dup rows in sheet,
Kermit Piper
removing "do you want to save...",
mwc0914
Determining Yield,
pdgood
Is it possible to set up default Footer settings??,
WhytheQ
module and vba?,
toaxay
Add-in name capitalization?,
M. Authement
assign dataset to matching dataset,
Michael Dirksen
Re: Restore the Context menu Delete option,
Ron de Bruin
Macro to concatenate multiple rows in a column, without selecting each group manually,
MikeM
- Re: Macro to concatenate multiple rows in a column, without selecting each group manually,
Don Guillett
- Re: Macro to concatenate multiple rows in a column, without selecting each group manually,
MikeM
- Re: Macro to concatenate multiple rows in a column, without selecting each group manually,
Don Guillett
- Re: Macro to concatenate multiple rows in a column, without selecting each group manually,
Rick Hansen
- Re: Macro to concatenate multiple rows in a column, without selecting each group manually,
Rick Hansen
- Re: Macro to concatenate multiple rows in a column, without selecting each group manually,
MikeM
- Re: Macro to concatenate multiple rows in a column, without selecting each group manually,
Rick Hansen
Re: msgBox,
RB Smissaert
- <Possible follow-ups>
- Re: msgBox,
Jan Karel Pieterse
Count & List Combinations,
sandip . dhamapurkar
Lotus Notes Task,
BerkshireGuy
Re: Referring to cells,
Don Guillett
Find and Paste Program,
Taru
macro which works in excel 2000 does not work in excel 2002,
nnayak
Extracting specific data from one column to another column,
DK
comboBox properties,
cmpcwil2
After adding a new sheet, wanting to compare cell values,
Emmert
Advance filter question,
QuickLearner
Use String from another module,
Silencer116
Clean Exit from InputBox,
scantor145
Re: A fast way to fill cells in Excel,
RB Smissaert
How to create chart using VB 6.0,
Tomasz Klim
Last Selected Cell,
DAV135
Popup box to enter VLOOKUP value,
Corey
Re: IsDate,
aidan.heritage@xxxxxxxxxx
How to path to user's desktop,
1scant
Place a User Form on Start Up,
SamuelT
Internet Navigation,
Jimbo1
Re: define unique Advancefiltered range,
Mike Fogleman
Filtering several rows on different criteria to build a single row.,
QuickLearner
formatting input boxes,
cereldine
Re: Close user form when button is pressed,
Norman Jones
Incorporating VB6 RichText control into Excel VBA,
chatterbox
Open 'n' Hide,
SamuelT
Re: Force macro on save,
NickHK
Re: show info when workbook opens,
Norman Jones
Checking data in each cells of an array,
cyzax7 via OfficeKB.com
Change colour of cell depending on content,
blain
How to check for Internet connection,
Vikram
need help using send keys,
funkymonkUK
Link to external file,
Tadashii
Re: creation of name range without selection of cells,
42N83W
export file to excel,
owl527
Re: Index number for CommandBar right-click on sheet tab?,
Ardus Petus
Selfcert and Network,
hon123456
Re: Using Controls on a Worksheet,
Nick Hodge
Split a string,
dealwi8me
Excel, reference a cell for parameter in SQL to import data,
Wizard
Finding a value and going to that cell?,
Simon Lloyd
Copy worksheet, rename, merged cell problem??,
Simon Lloyd
How do I get a Function to return Null?,
Peter Chatterton
Re: Additional Controls disabled,
Norman Jones
Re: need a formula to work out how much ......,
Simon Lloyd
Change from Column Selection to Cell Selection,
Lil Pun
Simple worksheet selection question???,
Simon Lloyd
Custom View Macros,
jhovey
On Change Event,
Jeanne Conroy
Border question,
kramer . newsreader
Disapearing formulas,
lostinformulas
Re: Shapes,
Don Lloyd
roster - printing out who is on,
Kengreg
Newbie Run Time Error,
have_a_cup
Re: Word wrap issue,
Dave Peterson
on error,
Linus
VBA created in excel2003 doesn't work in 2000,
Sue Robson
RE: quit on error,
Jim Thomlinson
Re: Combining R1C1 and absolute reference in SUMPRODUCT in VBA,
Don Lloyd
Multiple Cells,
Kramer
Using the ActiveCell function on 2 different worksheets,
CatherineN
Problems with Transposing. HELP!,
Conniet22
RE: Tough - show a hierarchy,
comparini3000
good gotos and bad gotos,
davegb
- Re: good gotos and bad gotos,
Bob Phillips
- Re: good gotos and bad gotos,
Mark Lincoln
- Re: good gotos and bad gotos,
Dave Peterson
- Re: good gotos and bad gotos,
davegb
- Re: good gotos and bad gotos,
Jim Thomlinson
- Re: good gotos and bad gotos,
Bob Phillips
- Re: good gotos and bad gotos,
Jim Thomlinson
- Re: good gotos and bad gotos,
davegb
- Re: good gotos and bad gotos,
bplumhoff@xxxxxxxxx
- Re: good gotos and bad gotos,
M. Authement
- Re: good gotos and bad gotos,
Mark Lincoln
- Re: good gotos and bad gotos,
Jim Thomlinson
- Re: good gotos and bad gotos,
davegb
- Re: good gotos and bad gotos,
Mark Lincoln
Re: Baseball Combinations,
Jim Cone
Empty cell instead of 0,
Zorro
Event: Workbook_Change or Worksheet_Change,
Han
What's the secret on scroll bars in textbox,
excelnut1954
Setting an array range of cells???,
Simon Lloyd
Merge Cells in VBA,
kramer . newsreader
Re: Change Cell Background color Automatically,
Bob Phillips
Page Breaks Macro,
Brian Matlack
Re: Connecting button to macro,
Harald Staff
Trouble opening PC version of Workbook on MAC,
alina b.
SELECTIVE DELETE,
jhemley
Create a workbook with only 1 sheet,
aerotops
Macro concatenate formula,
vipjun
Re: How to cause a #num! error,
Andrew Taylor
VBA - Multiple Array-Enter Command,
KKeenCA
Sending email with selection of data from spreadsheet,
tanyhart
How to create a button to switch to a custom view,
Turquoise_dax
Re: Specify which sheet to paste to,
Simon Lloyd
How do I identify a range based on cell value?,
HBF
Re: Prorated Average,
somethinglikeant
How to create a view option (or hide/unhide preselected cells) (Repost from Misc),
Turquoise_dax
How to read filesystem shortcut attributes,
jdawson
Re: invoice template?,
Paul B
Re: FORMULA FOR EXPERT, PLS MAKE THIS WORK,
Bob Phillips
Jump to "Defined name" range!,
timduongt
Commas appear when typing,
michael
sort multiple columns of data but not change the data location... Possible?,
ghelwig
errors in emailing Excel,
neta
Help with VBA export of cells to PowerPoint,
JOTS
ChDir statement,
neta
Hourly Macro Help,
okcscott3
Help!,
nassia
Re: Buttons,
Bob Phillips
Margins in form items,
topper09er
Retrieving Data from Multiple WorkBooks,
mastermind
Query PVCS,
walshy06
Transform text in date format,
ina
Re: Extracting data from 1 file to multiple files,
Ron de Bruin
RE: Excel VBA Macro stops running when another program is activate,
Brody
Subroutine calls between workbooks and object references,
mark . diffley
Re: Pause Code Execution,
Don Guillett
Canceling a read file function,
mwc0914
Message not available
how to set the value of a cell from another cell,
naddad
Re: User form/Modul,
keeena
Excel macros for interprocess communication,
venky
automating a process in pivot tables,
AmyTaylor
Re: Returning a value from a form,
Bob Phillips
Excel Worksheet Delete "Data may exist",
XidGarcia
Adding two cells together,
cereldine
Re: Color Problems,
keeena
- Message not available
- Message not available
How do I colour ill a cell in excel with a formula?,
SLO
Re: More Selecting and Deleting,
Die_Another_Day
VBA/SQL Question,
mazzarin
Managing Filtered Items,
Dastard
Userlogin for excel speadsheet,
Fatboy
VBA Acessing Member Variable in C# Com AddIn,
Matthew Wieder
List of macro shortcut keys,
Zone
Re: Increment Purchase Order Number,
Curious
Using sheet name of workbooks,
Marcus T
If column A completely empty, one action; if not, another action?,
StargateFanFromWork
- Message not available
- Re: If column A completely empty, one action; if not, another action?,
StargateFanFromWork
- Re: If column A completely empty, one action; if not, another acti,
Michael
- Re: If column A completely empty, one action; if not, another acti,
StargateFanFromWork
- Re: If column A completely empty, one action; if not, another acti,
Michael
- Re: If column A completely empty, one action; if not, another acti,
StargateFanFromWork
- Re: If column A completely empty, one action; if not, another acti,
StargateFanFromWork
- Re: If column A completely empty, one action; if not, another acti,
Michael
- Re: If column A completely empty, one action; if not, another acti,
StargateFanFromWork
- Re: If column A completely empty, one action; if not, another acti,
Michael
- Re: If column A completely empty, one action; if not, another acti,
StargateFanFromWork
Re: 3rd stupid question from newbie - autoloading userform,
Die_Another_Day
cell not changing,
R..VENKATARAMAN
Re: Format Page set up for all tabs in workbook,
Johnny
pasting info from workbook to sheet in another workbook,
s_ali_hassan
Re: Macro for Trimming,
Die_Another_Day
Re: Code Execution has been interrupted - ??,
Tim Hull
Re: Cell Deleting and Shifting,
Die_Another_Day
Re: VLOOKUP Formula from one cell to 2nd cell,
Bob Phillips
Re: Automatic date or time in forms,
Damon
Re: Find + remove blanks if cell contains only numbers,
Dave Peterson
Re: Naming worksheets in loop,
Alan
Sheets reference change variable,
Francois via OfficeKB.com
Checking if Validation exists in the cell,
Lech Jaszowski
Re: Checking format on input,
Bob Phillips
pasting form 1 sheet to another,
s_ali_hassan
Sum in vba only works for multiple values not for single values??,
Bevy
Loops and Events,
Tom
Merged cells,
Ed
how to see only youre userforms??,
tomro1
Re: How to convert values in to text,
aidan.heritage@xxxxxxxxxx
Re: code to unprotect sheet with password,
aidan.heritage@xxxxxxxxxx
Re: Main first,
NickHK
- Message not available
- <Possible follow-ups>
- Re: Main first,
Bob Phillips
Import a CodeModule then call its method in Workbook_Open(),
gdick
Re: SaveAs,
pianoman
Pre-Open VBA,
SamuelT
how to bypass password??,
funkymonkUK
Re: Get data from Excel-cell and check format,
aidan.heritage@xxxxxxxxxx
Re: Clear contents,
Norman Jones
Re: Charts,
Norman Jones
Rolling credits list,
Archie
Re: Search and replace blanks,
Norman Jones
<Possible follow-ups>
Re: Search and replace blanks,
jindon
Insert blank cell and labelling if difference in comparsion,
Balfear
Delete Pivot table,
hurriance
Re: How to link a form to a sheet in excel,
Norman Jones
executing database,
cyzax7 via OfficeKB.com
Re: Replace Function using Wildcards,
Executor
Conditional deletion of rows,
AussieExcelUser
Opening a file via VBA,
Chris Muller
filling userform listbox,
simonhall
Excel Menu Bar,
lehainam
List of Different Cells,
ForSale
Re: excel question,
mudraker
?????.Auto_Open ???,
joseantonio
Re: Save Status Bar Disappers after running macro,
Dave Peterson
matching values,
italiavb
Clean up and Fix Two Macros,
scottnshelly
VLOOKUP to last active cell in row,
rglasunow
macro to hide rows,
steven . m . miller
Changing cell colour depending on content??,
Simon Lloyd
Text Box in Chart,
Bill
Re: how do i use vba to zip folders?,
Dave Peterson
Application.FileDialog(msoFileDialogOpen) and error 75,
H . A . de Wilde
Re: Dynamic Name Labels,
Otto Moehrbach
Print even & odd pages with different margins,
mikeburg
OT,
ikr
Worksheet Navigation Help,
michael
Re: Increment numbers in column A by 1 when selected,
mikeburg
Re: Syntax to insert an array formula in a cell,
mikeburg
Disable Link Alert,
Otto Moehrbach
Re: SQL? Index? Excel?,
Bob Phillips
Re: Save column J of WorkBook when WorkBook is not saved.,
mikeburg
Can this Excel-Access lookup be speeded up?,
1scant
Re: DateTime picker control,
Ron de Bruin
use mouseclick to dynamically change chart series? Chart_beforeDoubleClick?,
KR
Re: Document security question,
Bob Phillips
Re: Another stupid newbie question.,
Bob Phillips
Re: Formula appears as =RC[-3]+RC[-1] Whats this?,
Bob Phillips
Please Help :),
lmarquis
Re: If Statement,
Bearacade
Re: run a macro when cell value changes,
mpeplow
Basic Compile Problem,
mpeplow
20 Procedures one Command button,
Flintstone
If cell contains text, leave as is,
jhemley
Find macro with wildcard as part of code,
excelnut1954
Re: how i use countif and AND?,
Jeff
Controlling switching to other sheets,
Gordon Smith \(eMVP\)
RE: xlDown stops at next empty cell, not at last row of data,
Ronny Hamida
Re: Hidden Text Boxes In Spreadsheets,
Jim Rech
Execute macro many times??,
mtnbikr9
Working with Workbook array,
Otto Moehrbach
How to find the Dimensions of a Variant Range,
Frans Verhaar
Copy Entire Row,
scottnshelly
Add 1 to a number each time you print,
Jason1
Having a floating row or hiding unused rows?,
Simon Lloyd
- Message not available
- Message not available
Re: SUMIF with Mulitple Conditions,
Chip Pearson
Find/REplace from table questions...,
deforsythe
delete images in an excel sheet,
raj . sinha
Re: Find and Replace within workbook - from Visual basic,
mpeplow
Re: student's t table,
Mike Middleton
Re: Help function,
Bob Phillips
Display Value in 'Currency Format',
mpeplow
Re: SUMPRODUCT USING <>,
Bob Phillips
Re: Input Box and Message box Help,
Bob Phillips
Re: Running macro on open of workbook?,
Bearacade
need to seperate one cell's formula by delimiters,
fynn
Help: Excel Macro window run button disabled for all code in 1 module?,
keeena
Excel, OLEDB and uppercase problem.,
witek
Using Checkboxes to enable/disable vb,
paul . salama
slow processing with .find,
Guy Normandeau
Formatting Text by when last modified,
richardharwood
Searching for a Partial Filename,
mark . diffley
Copy contents of textBox to Cell in Excel,
Shashi Bhosale
Re: create macro - delete all rows with zero in column L,
Ron de Bruin
Re: Google spreadsheet,
Duncan
Duplicated form at runtime,
lily
for..next statement problem,
s_ali_hassan
substitute chatracters within a cell,
Shan
formula or VBA - would like to autofill cells based on start date and # of months,
jsr
Re: SUMIF,
Andy
Re: Exclude first charachter,
davegb
Re: How to perisist object in Excel,
Chip Pearson
Newbie-question: recorded macro does not work - why?,
Michael Moser
Re: Looping,
davegb
Auto delete rows within a specified range,
twlove
Save Single Worksheet,
craig arnold
Re: How to disable all Excel Events and then re-activate them?,
Tushar Mehta
macros in network restriction,
tweety127
MSFlexGrid to display Excel data on VBA form,
poppy
Re: REPOST: Calling Excel Automation Add-In in VBA,
Matthew Wieder
Hide and unhide rows for multiple areas,
leonidas
Re: Destinct records macro,
Dave Peterson
Application.CommandBars Help,
gti_jobert
Re: Cell address,
Bob Phillips
- Message not available
- <Possible follow-ups>
- cell address,
Kate
no builtin chart options for me..(Excel 2000)!!,
roshinpp_77
Re: Override dialogs on SaveAs (tab-delimited),
Madasamy
Re: Disable Cell and take out Data Validation,
Bob Phillips
Re: macros using find/replace,
aidan.heritage@xxxxxxxxxx
Re: find values and identifying cell-adress,
anusha2525
is there a way to connect excel to a pop3 server?,
funkymonkUK
Difficult macros,
phil2006
Re: pop up box, searching worksheets and running macros help please,
pianoman
hide and unhide rows,
leonidas
Import a external data,
hurriance
Pivot Chart Problem,
WhytheQ
advanced filter and format,
CG Rosén
Userform Combo box list,
PhilM
Passing values,
PhilM
Data program,
phil2006
Extracting Data - Open vs Closed,
VBA Noob
import and export from SQL SERVER to Excel,
sal21
Importing libraries explicitly in macro code,
shivboy
Re: Save one sheet as .csv with macro,
Paul Lautman
Re: Filtered Array for Listbox,
Paul Lautman
VBA - If / And Statements,
Becky
Excel filter does not working anymore,
Berry
removing commas in csv,
ziggynorton
autosave on changing worksheet,
gillmacca
Copy part of worksheet in VBA,
Ruatha
xlb as Addin ?,
Desert Piranha
Re: Goto a named range using the contents of the active cell,
Simon Lloyd
Accessing a 'column' in a VB array,
den1s
Using SocketWrench,
bshumsky06
Re: Password on VBA causing problem,
Simon Livings
Re: Opening Multiple Sessions of Excel,
Tom Ogilvy
Re: List box deselect,
Dave Peterson
Re: Macro and automatic update,
Jim Cone
macro to search for & select ranges to sum,
Jason Head
Re: How Do I Modify Pearson's Code to Add "Treat Consecutive Delimiters As One"?,
Alicia7Jaynes
Data Validation,
dogonsi
Re: How to open a spreadsheet and make changes to it from code?,
eBob.com
embed?,
Dean
double freeze pane,
nospam
Extract Date (04/05/06) into Text (040506),
Who I Am
Re: Put 1D array into column,
Alan Beban
Re: Using COUNT value as variable,
Johnny
Re: Pull mutil values from one LOOKUP formula,
Johnny
Re: I would like to get a time stamp that does NOT update upon recalc,
Finny
Removing Macro/Deleting a Button in a Spreadsheet,
pnoble
Floating Command button,
kev_06
Paste Special,
sparx
Now I want the opposite,
David
Using Excel to generate an Outlook Calendar Event,
Michael
Protect formula without protecting the worksheet,
lostinformulas
Re: multiplication,
Harald Staff
Date and Time,
Altec101
macro to show list of worksheets in a workbook,
excelnut1954
Hide row if date "A" is later than date "B",
m3s3lf
Initiate Macro On Save,
JTWood
Retreiving list of table & field names from Access into Excel using VBA,
shivboy
Copy Worksheet to a new Workbook creating if it doesn't exist and add more Worksheets if it does exist,
pete . bastin
RE: Adding sheets and copying data problem,
Tom Ogilvy
list all the find values,
jhahes
Calling Excel Automation Add-In in VBA,
Matthew Wieder
Re: Specific Cell Selecting,
Bob Phillips
Re: Multiple Links from drop down box,
Dave Peterson
Referencing cell in Named Range in Function VS Formula,
Nyq
unhide rows when cell is clicked,
lauren_roberts08
Suppress workbook display,
aerotops
Using Macro to copy latest data from one Workbook to another,
Kayote
Change Application Security Settings,
WhytheQ
In VBA, possible ot subtotal without selecting?,
Celt
Re: Conditional Formula,
Bob Phillips
User defined functions without using VBA.,
phongdk
RE: Copy Unknown Number of Sheets,
Tom Ogilvy
Re: Excel crashes on simple procedure,
Mark Lincoln
Re: Selecting a Pattern of Rows,
Die_Another_Day
Save WB from reference found in cell D1 to specific folder,
Annette
RE: VBA Loop Formatting Text Question,
Richard
Iteration Calculations between sheets,
Abraham.Olson@xxxxxxxxx
lookup,
RobcPettit
E-Mail as Hyperlink,
BN-CD
cell.replace strange behaviour,
Nicawette
Subscript out of range error - save copy error,
bg18461
Workbook_BeforeClose,
Alan McQuaid via OfficeKB.com
calling a userform,
s_ali_hassan
Get FileSummaryInfo for files saved on Intranet,
aidan.heritage@xxxxxxxxxx
select range between two empty cells?,
leonidas
Why do add-ins reference specific path,
rodwellm
importing text from bookmark in Word to excel,
mayanklal
Excel Automatino/COM Add-In Question,
mwieder
Resizing Pivot table column,
andee . weir
Deleting automatic page breaks in excel 2003,
mLinn
Re: How can I use VB code to execute macro when double-clicking cell?,
Don Guillett
Excel Sheet.Copy Method (Excel 2003 SP2 ),
AMIT
Re: Delete a Column Based on User Entry,
Don Guillett
Re: Seclect Column or Range according to Cell's Contents,
Bob Phillips
still saving a record to excel even if i press the NO button,
tweety127
Re: 2 questions about developing.,
Bob Phillips
Re: How to develop a calculator using Excel Macro via VBA,
Ken Johnson
Save macro Truncating text,
Brian
Can anybody help me please?,
certain_death
<Possible follow-ups>
Can anybody help me please?,
certain_death
Re: Timer,
Paul Lautman
Filter problems,
Berry
Re: "" does not return blanck,
Dave Peterson
VBA automatically change text format into general format?,
Nicawette
EXCEPTIONALLY SLOW LOOP ....help!!!,
WhytheQ
Cannot Shift Objects off Sheet....?,
Darin Kramer
Speeding up Array,
gti_jobert
Read/Write from/to a closed workbook,
Alan
Query - Data Layout,
mralmackay
Re: Average a range within an array,
Norman Jones
Message Box Help,
Scarecrow
How to pass variable between closed workbook,
hon123456
How to pass variable between different variable,
hon123456
Delete Unwanted Rows (Help with Range),
Santa-D
Pagebreak and Zoom problem,
JON JON
Re: modeless,
Norman Jones
Using Range & Cell,
Jack
Re: Paste Values,
jindon
Filter is not working anymore.,
Berry
How do i parse a text string with a date?,
powderwoo
Name Manager: new version released,
Jan Karel Pieterse
Re: Summarise Worksheet Data,
Tom Ogilvy
Re: Summarising Worksheet Data,
Tom Ogilvy
Lock Cells with Specify Range If Cells contains value,
bernardng
Re: PIVOT TABLE DATE GROUPING,
Debra Dalgleish
making cells change relative to each other, cant figure out,
MMA
Run Macro after update,
hurriance
making cell values change relative to each other? cant figure out ;/,
pete321
Change delimiter in import function from comma to tab,
marksince1984
Macro to add count forumla with dynamic range,
falloutx
How to program keystrokes other than CTRL+something?,
jmgross@xxxxxxxxxxxxxxx
How can I search in this forum?,
kaokao1
pasting into a list using a macro,
DanHegarty
Delete selected sheet,
cyzax7 via OfficeKB.com
Custom button :Copy data to new workbook,
hosweec
RE: copy and paste from one sheet to another with VBA,
Paul Mathews
Re: vba select from Active Directory (LDAP),
Chris
using variables to reference sheets,
marksince1984
Too many gotoos?,
davegb
Find out if a Value is Contained in a cell,
Die_Another_Day
Problem deleting rows by index,
Chris
Need Help w/ Search or Find Macro,
japorms
Date from a cell........,
CLR
huge problem!!!,
tomro1
Trapping error from Empty Dynamic Named Range,
Casey
I need more help with Absolute Reference,
lostinformulas
RE: Stupid question from newbie re: data from multicolumn combobox,
mato nanjin
RE: PageSetup.set_PrintQuality .NET method,
Tom Ogilvy
Cell Colors Dependant on Date,
RJM
Re: macro I shared isn't available in any other workbooks?,
Chip Pearson
Macro to replace error values,
Shamik
Re: VBA Error Handler,
Chip Pearson
Formulas not working once macro is used,
tanyhart
selective protection,
Nospam
WorkBook Activate event not working,
sujatha_krao
Macro to find columns to hide,
Dean
Gathering Data,
Spreadsheet
Case Statement - help required,
deelee
Set a range for all worksheets in workbook??,
Celt
RE: Variable Range/chart,
Tom Ogilvy
VLOOKUP in VBA,
Robert Lee Wheatley
Update Values Dialog,
Agustus
Re: For Each Array Question,
Bob Phillips
Re: FAO Mat P:son,
Don Guillett
Re: excel help,
Don Guillett
"Too many diggerent formats",
Gordana Godzo
Duplicate prevention from Listbox selections to worksheet,
Casey
Save Userform as bitmap,
Jason . Rodrigue
add row to the end of a list and data change,
nicolasdestree
V Lookup Problem,
mhall5
Which sheet gets calculated first for iterations?,
Abe
comparing rows,
RobcPettit
RE: Page# Return off lookup,
Tom Ogilvy
Re: Add new sheets with code,
Dave Peterson
HELP! Conditional Formatting,
Abe85
Re: Opening the Autofilter dialog box,
aidan.heritage@xxxxxxxxxx
Date in VBA,
witek
RE: Time range to workdays in relevant months,
Tom Ogilvy
Sorting information,
Maria
Automate cell selection,
mayanklal
Re: Option Button Grouped,
Peter T
- <Possible follow-ups>
- Re: Option Button Grouped,
Dave Peterson
- Re: Option Button Grouped,
Peter T
- Re: Option Button Grouped,
Dave Peterson
- Re: Option Button Grouped,
Peter T
- Re: Option Button Grouped,
Dave Peterson
- Re: Option Button Grouped,
paul . morriss
- Re: Option Button Grouped,
paul . morriss
- Re: Option Button Grouped,
Dave Peterson
- Re: Option Button Grouped,
Peter T
- Re: Option Button Grouped,
Dave Peterson
- Re: Option Button Grouped,
Peter T
- Re: Option Button Grouped,
Dave Peterson
Date Picker - "Linked Cell" Property,
skev
If cell is empty then run macro otherwise skip this macro,
alexmillner
Cell addressing,
Tomasz Klim
Copy and Paste select data to another workbook.,
tanyhart
use of PROPER function in Macros,
tweety127
Changing Formulas to values in "protected workbook",
Roundy
Problem with macro for importing data to template,
Jay_B
Macro Opening or Looking for Another Workbook,
Toolman045
Reg : GUI,
naresh_kalyan
formula for finding Friday,
EdStevens
Add value to cell...,
ctroyp
Re: Is there an "OnOpen" event for Excel,
Chip Pearson
RE: Macro for sorting within groups,
Paul Mathews
Macro for Row Processing,
George
Update Sheet1,
Steve
Formatting Excel charts created with VBA,
neil
Re: Command Button on worksheet,
Paul Mathews
Re: Error 1004: Application Defined or object defined error,
Chip Pearson
Re: Select.Range,
Mike Fogleman
Re: Print multiple reports from list validation,
Chip Pearson
Re: Making Excel 2003 as the Default over Excel 2007,
Bob Phillips
Re: In SelectionChange Make Last Rwo Dynamic,
Bob Phillips
VB & autotext,
rocket0612
Collect used areas of multiple spreadsheets into one...,
mivpiv
RTD formula,
ben
Re: Hide whole row when cel C3 is 0 (zero),
Harald Staff
Re: Delete Rows,
Norman Jones
RE: Number stored as text. How do I keep the number format?,
Gary''s Student
what went wrong?!,
simon10810
Re: Countif result in message box,
aidan.heritage@xxxxxxxxxx
Re: Excel crashes everytime I send focus from control to worksheet,
Per1000IPDay8
text in ***,
tomro1
Help with Object Design,
Wired Hosting News
excel close + save by button press. how?,
tomro1
ActiveWindow VBA problem,
Tomasz Klim
Re: Sort out data on seperate sheet,
Otto Moehrbach
Running two arguments within same code,
Brad J .
printing special numbers!,
Marc.paternotte
Last Column to first Column,
EMoe
Re: Need emplyee time card app, daily in/out, excel vba based.,
Chip Pearson
Fill FAX template in Word from Excel VBA,
Frans Verhaar
Self-Contained "Database" file?,
woodman650
Program to resave a collection of .xls files into tab separated .txt files,
JH
Alignment of Graphs,
Mnilo
Re: Error in code,
Bob Phillips
Re: .xls values, like .pdf,
Ron de Bruin
selecting a column,
James Cornthwaite
Questions: Copy ranges, autofilter macro, subtotals, & naming shee,
Smangler
Translating numbers into number with color pattern,
Harry88
Read value from combobox (cleaned off duplications),
sven_dau
variant to long?,
James Cornthwaite
Re: Delete all rows not today,
somethinglikeant
rng, varinant to long and offset questions?,
James Cornthwaite
Re: Trouble with this code,
somethinglikeant
Find last row through a macro,
sandip . dhamapurkar
user-level access to pivot table,
sandip . dhamapurkar
Upper-case all text in Excel 2003 spreadsheet,
Chris Hankin
Copying worksheet to new file by macro,
Ruatha
Creating an image file,
Jim
Workbook open event,
hans . domian
Re: How can I select a range of cells for header?,
Joergen Bondesen
Problem with file finding macro,
Alf
Case Satement,
deelee
VBA programming certification,
Frans Verhaar
Re: Changing cell color if date is...,
KellTainer
Determining What FormatCondition Has Been Chosen,
John/Churchwell
Re: Determining if data is sorted in descending order,
jindon
Using Excel as a database and need macro or vba to take data entered on one tab and update the database by adding to the next avail row,
rjr
Embeded Wav,
Desert Piranha
Re: Force user to save file with specified filename,
SteveM
Re: CommandText,
Tom Ogilvy
Re: "Force" user to save file with specific name,
Tom Ogilvy
Re: Map/List of folders, subfolders & files,
Tom Ogilvy
Suming a column to another worksheet,
CRYM
Bringing up sort command,
don
listbox to cells??,
tomro1
I need help with a (apparently) very simple VBA script,
profbosco
Re: Orderly Validation Against Separate Ranges,
somethinglikeant
Re: Send email based on date value,
Ron de Bruin
Re: Help Template & Database,
Ron de Bruin
Setting Timers in Exce.,
Pero
Re: Format prompt in VB InputBox,
Don Guillett
Populate First Empty Cell In each Row with Text,
Sam via OfficeKB.com
Re: Code deleting all rows in error,
Joergen Bondesen
RE: Macro to Paste Items to All but Several Workshets,
Paul Mathews
Excel sheet analyzer/generator,
Tomasz Klim
Extracting data from some files in folder,
Alf
Simple iteration problem,
bstevens
Re: DATE & MONTH minus ?,
Ardus Petus
Re: Identify an add-in file that is not installed,
Ardus Petus
Need help with grouped counts,
bstevens
How Do I "Toolbar List",
Kieranz
Re: Filling out usernames in IE,
Randy Harmelink
Re: Syntax error in code,
Dave Peterson
CopyFromRecordset will fail if the recordset array data such as hierarchical recordsets ???,
Mike
Re: Problem with Date Conversion Code,
Ardus Petus
extract data from pivot via vba (Getpivot is not convenient),
Sandip
Re: Disable all "Refresh Data on File open",
Ardus Petus
Add-ins passwords,
bad_boyu
Delete entire rows where there is a blank in column A,
Chris Hankin
VLOOKUP with multiple criteria,
Madiya
SUMPRODUCT - small correction required,
Madiya
VBA replaced ?,
AD108
Help with Creating Email,
Don
- Message not available
- Message not available
RE: Sell Program - Screwed by Managers !!!,
Greg Wilson
What in the world is it doing??,
G Lykos
Re: Share macros on a network?,
Don
Public function in Personal.xls,
Ardus Petus
Re: Speed VBA Excel 2003 vs 2007,
Norman Jones
Re: First of the year,
Jim Cone
Change color of text segment in msgbox,
brucemc
How to save a file,
hon123456
Excel 2007 Beta,
HSalim[MVP]
Re: getting info from multiple workbooks simultaneously,
Norman Jones
Re: Help needed with Pivot table macro to remove data,
Debra Dalgleish
Re: Loops,
Tim Williams
Re: adCmdText,
Tim Williams
Re: Save a Workbook as "Read Only",
Dave Peterson
findings text in columns,
tomro1
Re: multi tab workbook,
Dave Peterson
making text in Title Case automatically,
tweety127
Simple question,
yakerdude7
Factorial macro or formula.,
Captain Snuggles
How to Show Existing IE Instance if Already Exists, Else Open One,
cole . simonson
Re: next empty row,
Don Guillett
Match columns,
light
Find and Replace Values in Range,
ThatGirlinMS
userform cancel button,
davegb
Re: Hyperlink to Word Template,
Heather Heritage
Adding a hyperlink to a shape,
Rand
RE: Please help with auto Date and Time with VBA,
Jim Thomlinson
Macro to paste in the active cell the contents of a cell from another file??,
LarryB
Re: Excell sheet help needed,
David McRitchie
If then (else?) ...,
StargateFanFromWork
Re: General Quesiton,
Otto Moehrbach
Auto-Format Excel Spreadsheet?,
Abe85
Re: Code For Date Accepts Text,
Ron de Bruin
RE: Concatenating problems,
Charlie
VBA/Excel Add-ins,
bad_boyu
Re: Easy questions about Auto Save,
Chip Pearson
Creating an MSForm based on a table,
Quentin
is a variant an object,
James Cornthwaite
Extract data from many workbooks VBA,
IntricateFool
repost: Dynamic chart help,
Greezy
Re: Macro Question,
Die_Another_Day
saving website html as string,
davidbarbetta
What function(s) should i use?,
FurRelKT
socket in excel vba,
bshumsky06
Re: Excel IF function help,
Harald Staff
Combining files and their respective VBA macros,
grant
More efficient copy/paste??,
Celt
Re: What am I missing here?,
Dave Peterson
RE: How to count number of pages in a named range,
rm81
Determine if folder exists,
Terry K
Won't accept textbox3,
davegb
FileSystemObject.copyfile,
KR
Problem with Formula n VB Macro,
Emily
- Message not available
- Message not available
Accumulative total,
charles
Return ADO recordset to worksheet,
Terri
help me¡¡¡¡,
MARCO6325
COUNTIF criteria in VBA,
whitehurst
excel 2003 Resides in Task manager.,
Pandi
Quite simple macro, but I can't seem to fix it...,
rantz
Macro to copy specific cells from one workbook to another,
dwight . yorke
Application.Volatile,
Nader
Macro to Move Excel Button,
benfalk
Updating Data through Webservices using Excel,
dilishtv
Is this macro even possible?,
eagle_eyes
Create an Excel splash screen without the caption bar,
Kezza
how to remove a space after a string?,
elaine
Line number in error handler,
cereldine
Re: Data Validation - Mulitiple Tabs,
TheLeafs
how to execute a macro assigned to a checkbox in vba,
pieterklinker
Excel keeps reformatting floating point values to dates (e.g. March 17),
antred
Retriving name of cobntrolelement,
Jan Kronsell
colouring the entire row to a color .,
roshinpp_77
incorrect addition,
sandip . dhamapurkar
Re: Formatting / centring Text in a Msg Box,
Norman Jones
Data validation dependent of value of option button,
b . v . pelt
Fire events for all comboboxes in my sheet,
Ardus Petus
Find new value and replace with old one,
Steve
Context menu,
cmpcwil2
Log file...,
ChrisMattock
Re: undo delete,
Jan Karel Pieterse
displaying the user form data,
cyzax7 via OfficeKB.com
Help with PasteSpecial,
staeri
Re: RePost - Creating WBooks,
Ardus Petus
Dynamic chart to track progress by date,
Greezy
displaying contents of a user defined directory,
cyzax7 via OfficeKB.com
Validation list to a Range?,
Dr . Ile
Custom Menu Bar,
Don Lloyd
Re: Round Robin Tournament Generator,
Don Lloyd
Re: Referring to a worsheet in another workbook,
Jim Cone
C# RTD Server,
amacaninch
Re: ActiveCell.Offset on filtered data,
LenB
XML Files,
jhulst
Locking cells with a checkbox using a macro.,
SplatterKat
Open only files last modified in SubDir,
GregR
Double-Click on cell,
edwardpestian
Passing formula value to variable, hide rows,
Punsterr
Create Named Range in VBA,
michael . a7
Wildcard search for string within a string?,
Ed
Re: Macro delimiting text if column has value,
Dave Peterson
macro for copying a range to a column of cells,
aide . morcam
Re: Input Box Size,
Paul B
Re: Macro that deletes certain rows only,
Nick Hodge
Re: Count displayed rows,
Dave Peterson
Re: extrapolate range coordinates,
Dave Peterson
Complex SUMIF statement,
kremericainc
I hope not a dumb question.....,
Celt
Retrieve all Outlook calendar appoinments for a day,
brotherescott
Active Workbook,
halem2
Copy Formula Instead of Value,
Emily
Passing File Name To Macro,
halem2
Workbooks.Opentext - oldskool '97,
bradsalmon
Selecting a sub range?,
James Cornthwaite
xlCellTypeVisible - not working?,
whitehurst
Re: using row autofit but with minimum height,
Chip Pearson
Copy text from Excel to Word,
mayanklal
variant to integer format?,
James Cornthwaite
Using Pivot Table to analyze multiple variables in satisfaction survey,
gotesman@xxxxxxxxx
Form Question,
tssgw
Compile error screwing with me,
MDC
after save event/procedure,
kev_06
Re: Page x of y,
Ardus Petus
how will i create a formula that will copy the content,
tweety127
2 Questions 1 about Macro, 1 about VLookup,
wiredwrx
Indirect reference to run macro in another workbook?,
KR
Macro If And,
Herve_Rob
Conditional Copy Macro Help Needed,
ipsy9
Check For Add-in,
Steve H
Newbie Question on Setting Cell Value in Sheet2,
fir5tsight
Set Cell Value,
fir5tsight
Re: Auto Hide Task Bar,
Bearacade
Re: remove autofilter from some columns,
Dave Peterson
Re: Download from FTP,
Die_Another_Day
Re: Newbie Questions 02,
Andrew Taylor
where do I find docs on excel automation programming?,
Mike
Re: Creating WBooks,
Ardus Petus
HELP... AUTOSUM........Add(msoControlButton, 226),
WhytheQ
'extra' file in VBE project- can't delete it? XL2003,
KR
Re: string parsing w/wildcard problem,
neverends
Pivot Table heading case sensitivity,
christophe . leroquais
Last Used Row,
Zone
Re: Embed a Userform into an Excel document,
Harald Staff
Re: CommandButton Question,
Die_Another_Day
DTPicker to be dropped down on initialisation,
WhytheQ
Way to not sort when only a header row and one row of data to sort?,
StargateFanFromWork
is it possible to automatically change the color of the bar chart as soon as it reach,
tweety127
Select a sheet by name in a macro,
swatsp0p
Delete row problem, could some help me on that?,
ina
SendMail Error Trapping,
NicB .
Re: Set Path for GetSaveAsFilename,
Dave Peterson
Array from row in worksheet,
Colin Nederkoorn
RE: Change background color,
Jim Thomlinson
transpose data from horizontal to vertical in a specific column,
elaine
Counter variable in For Loop,
almostmature@xxxxxxxxx
Macro If and...,
herve
Excel PivotFields/Items,
moglione1
Getting a hook on Toolbar Events,
WhytheQ
Re: New to Programming,
SandyUK
vba check for disabled macros,
Ray Maas
Finding duplicate values b/w two columes,
nikki115
Re: runtime error -429,
paul . robinson
Re: Selecting Blank Cells,
Norman Jones
RE: inserting formula,
enyaw
External Reference - Filename Change,
bg18461
Re: Copy and Paste Visible Cells,
Don Guillett
Arranging VBA windows,
Hari
Re: Count number of cells that are highlighted,
macropod
- Message not available
- Message not available
Newbie add-in questions,
KR
Inserting new worksheet,
tanyhart
Date Format in Userform,
Peter1999
Run procedure when value changes,
Magnus Olofsson
RE: compare cell formats,
Gary''s Student
Re: Why is this a Type Mismatch error?,
Norman Jones
CSng adds erroneous digits to the value,
ben . biddle
Re: Newbie question,
Bob Phillips
Re: Calling a private macro,
öÉÇÁÊÌÏ× òÏÍÁÎ
Re: Range.Value2 is failing for lenghty strings,
NickHK
Re: Can you count a certain color cell?,
Norman Jones
- Message not available
- Message not available
- Message not available
getting size or setting it?,
Sonnich
Printing pages from different sheets in a set order,
Gordana Godzo
how to create macro that will display the sub_subfolder,
cyzax7
Re: how to create macro that will display the sub_subfolder,
Bob Phillips
Dynamic Range,
Rashid
Could not sort the first row ??,
Jun-Chih
VBA vs VB.net,
Wired Hosting News
Flashing Curser,
edwardpestian
Change the Formatting of All Instances of a word in a worksheet in Excel,
jaikal24
Selecting values from a list to add up to a specific quantity,
goose
Re: Need a Matrix diagram - Please help,
Jim Cone
Auto message box,
Vlad999
Ignoring Certain Characters In a Cell Using VBA,
Lil Pun
Re: Sort out data with VBA,
Chip Pearson
Re: Multi Select List box in columns,
lexcel
Re: Changing Value of Cells,
Chip Pearson
Is Excel is now going out of it's way to mess me around?,
Willot
Create summary WB,
GregR
RE: SpecialCells,
mike
Re: Dynamically refreshing Pivot Table Range.,
Dave Peterson
Tricky data type error,
RB Smissaert
Validation Drop Down Box,
Barbara Ryan
integrating row number in a formula,
Grymjack
Re: copy and paste (visual basic),
Don Guillett
Read zip file on disc,
BillyRogers
Re: Determining Whether File Exists,
Chip Pearson
Re: Confused about assigning DIM and such,
Chip Pearson
RE: how do i enable user logins,
Jim Thomlinson
is it possible that the data values shown on the data labels be in a duifferent range,
tweety127
Modify database,
Joao Saraiva
speed of processing,
Chas
Array usage,
brocklanders
error handling,
James Cornthwaite
Re: The Ultimate Problem,
Harald Staff
calculate all possible combination from 10 variables,
silvia
Help!!!!!! - Find Function not working from C#,
andyblum
End of Spreadsheet,
Chas
Inserting Values in a Multidimensional Array from Two Different Controls,
shivboy
Macro to Create Sheet & Duplicate Sheet,
Herve_Rob
Converting a formula to its value,
macik81
Re: Workbook Open not triggering,
witek
Importing/deleting .bas files (a lot)? Repost,
KR
Form placement on spreadsheet,
brucemc
Re: Open excel at a set time,
Steph
Linking Tab Names to a single cell with a worksheet,
Manager
Dim,
Steph
RE: Dynamic multidimensional arrays,
ispy99
code failure,
dreamz
-2147221080 800401a8 Automation error,
JoanExcel
RE: Find,
Jim Thomlinson
- <Possible follow-ups>
- RE: Find,
Tom Ogilvy
RE: Path/File access error (Error 75),
Tom Ogilvy
problem to access sheet from add-in,
Nader
work with invisible sheet,
Oli6865
Re: work with invisible sheet,
witek
Re: Populating Cells using VBA,
Nigel
Font of ListBox,
eLaCiD
Logical operator inconsistency,
KD
open workbooks to extract info into one,
Saz
Add Formula SumIf Relative Range D = A*,
mkerstei
Re: Duplicate all Macros?,
SteveM
Re: Have 2 Macros run in a specific order...Can This Be Done,
Chip Pearson
Variable Filename calls,
Grymjack
RE: Insert Diagram,
Gary''s Student
Disappearing Callouts,
edwardpestian
- Message not available
- Message not available
Re: Runtimem Error 9 Subscript Out of Range,
Bob Phillips
Re: Before Print - one worksheet only,
Bob Phillips
Re: Macro to copy all spreadsheets into 1 spreadsheet,
Dtown Dawg
Parsing a string,
neverends
Table Update,
phil2006
Refreshing Imports,
ceemo
Changing font color in email,
tanyhart
Selecting many Checkboxes to align & size,
Saz
Re: for next loops>> basic information,
Don Guillett
Data Entry and Display problem,
brimurr
VB Macro to Automate a Search/Replace,
Lotus123
Updating a cell that uses a .NET add-in function,
alexagran
Won't Add Multicolumn Data,
Brandon Johnson
Re: pull down menu in validation cell,
Dave Peterson
Macro to insert lines,
tanyhart
Resize Print Area/Pages Macro,
DHallam
RTD value changes not triggering worksheet change event,
DTM
Changing subject line in email,
tanyhart
Re: Excel VBA,
Bob Phillips
Does library reference stay with the code?,
Peter Cornish
Seach & Replace Macro,
NQ Muzza
Chart Name,
Zone
Listbox Column Count and Width Dont work. Seems Easy,
Brandon Johnson
E-mailing in Excel,
kev_06
Hide rows with macro,
Fugazy
Save column J only using copy/paste & temporary copy,
mikeburg
Re: Getting rid of command bar chevrons that allow "customize" menu (E,
Travich
Through a command button hiding rows,
Saz
VB error, "Compile error: value not defined",
StargateFanFromWork
Search Spreadsheet - Results in either listbox or new spreadsheet,
Brandon Johnson
Why doesn't working? Application-defined or object-defined error,
SupperDuck
Exporting data to another spreadsheet,
tanyhart
Update E-Mail Data Base,
Brian Matlack
Using solver while disabling auto calculation,
Kevin
Renamed ranges - PART 2,
rm81
Excel 2003 Performance/Status Bar Quest,
Grumpy Aero Guy
Challenging?,
ChrisMattock
macros,
phil2006
Re: sum format,
Dave Peterson
Trouver la ligne et colonne sur laquelle se trouve un checkbox,
chbillard@xxxxxxxxx
printing selected sheets,
funkymonkUK
Getting Word to work with Excel,
mike . wasson
Excel 2003 vs 2000 VBA Compatibilty,
SteveM
Excel workbooks , internet links,
plato
Re: Command Buttons on Excel Worksheet - font size decreases on click,
MattShoreson
Hide all Sheets,
Roba1
Relative addressing with INDIRECT function,
john
Print 2 pages per sheet,
Andrew B
RTD feeds into excel not trigering a worksheet change macro,
DTM
Can this be done?,
cmpcwil2
Excel "price-stop" formula,
ExcelKat
Calling a sub method,
richcoleuk
cell copying?,
phil2006
how to log all excel files opened on my pc?,
jgalt650-excel
emailing info,
Bob
Progress Bar Control,
pianoman
Re: Progress Bar Control,
pianoman
Re: Shouldnt this work?,
Willot
Ref. problem after sheet import,
Christian
Excel - Polish version - SUBTOTAL,
consec
Function runs more than once,
Huyeote
Re: Match and find entry,
Bob Phillips
disable range selection,
bshumsky06
Including an inputbox within a macro,
Drummy
Re: Why can't I access VBA Help topics?,
protonLeah
Insert Formatted Row at specific point within Dynamic Range,
ksp
Using DTPicker to change date in a cell when user selects cell?,
WaterDog
Pie chart slices too thin,
Fred Smith
Re: List of Folders,
Die_Another_Day
Re: importing file using macro and all rows don't appear?,
Tim Williams
Populating Lists in forms,
marksince1984
Lookup or Index or Match, not sure.,
ForSale
Developing a reporting package,
marksince1984
How can I ignore value from a workbook that are not in my collection?,
kathy . aubin
Re: How to format the month of date,
GregR
Re: Is there a non-macro way to do this?,
macropod
Re: Count remaining rows after autofilter has been applied,
Dave Peterson
Re: Repetative Tasks and Variables,
alecbowman
delete column sets current cell wrong,
davegb
RE: Excel freeze when ran from server drive,
Zimme
Re: How to automate a import from a webpage,
Don Guillett
Macro to autofill (copy paste),
Craig Freeman
use of morefunc funtions in excel macros,
K7
"LAST SAVED BY".... (Help),
cidc
Re: Bingo Card Generator,
darklord
Re: NO RECEIVED ANY REPLY !,
Tim Williams
Merged cells cause "Runtime error 13 type mismatch" problem,
Ralph Malph
Copy Spreadsheet or listbox,
Brandon Johnson
Re: macro reading excel file,
Ron de Bruin
Re: Protect file from being overwritten via "save as",
Edmund
Re: Properties of Combo Box in Userform,
Chip Pearson
Clear Contents Help,
michael
Excel Worksheet Copy Search Help,
Brandon Johnson
Enter Command,
Lil Pun
Re: excel. if g4>h4 i want cell j2 to be 0,
Trevor Shuttleworth
Re: Macro and Count function,
Bob Phillips
Combobox to Select Worksheet,
Mickey
Re: Use of PUBLIC,
Dave Peterson
Excel VBA Script - need to insert an override,
Brad J .
Re: I need to sort an active sheet using the col of the active cell,
Otto Moehrbach
How to switch off calculation on pivot tables.,
witek
is there a way to make dates simply be read as text?,
tweety127
Emailing from Excel,
tanyhart
Re: Exceedeing the 7 conditions in a nesting fomula,
Ardus Petus
Re: Selecting a Pattern of Cells,
C01d
Easy Question,
holyearth
Charts>Series>Values Error,
Raman325
Excel sheet: resiza rows number??,
furbiuzzu
Check Headings,
Altec101
count font color,
snowing
Load data from multiple spreadsheets into one master spreadsheet,
Scarlet
RE: Renaming a range,
Mat P:son
- RE: Renaming a range,
rm81
- RE: Renaming a range,
Mat P:son
- RE: Renaming a range,
rm81
- RE: Renaming a range,
Mat P:son
- RE: Renaming a range,
rm81
- RE: Renaming a range,
Mat P:son
- Message not available
- RE: Renaming a range,
Mat P:son
- RE: Renaming a range,
rm81
- RE: Renaming a range,
Mat P:son
- RE: Renaming a range,
rm81
- RE: Renaming a range,
Mat P:son
- RE: Renaming a range,
rm81
- RE: Renaming a range,
rm81
- Re: Renaming a range,
Tom Ogilvy
Help on inserting rows and formatted content,
tanyhart
Re: runtime error 6 overflow when running a macro,
Dave Peterson
Re: Sumproduct in VBA,
Dave Peterson
Error handling question,
sungen99
Re: Validation Using A List Box,
KellTainer
Re: VB for an entire worksheet,
msals22
Re: How can I do the equivalent of "filesearch" in Office 2007?,
Bob Phillips
Strange one,
Steph
Speeding up a part of a procedure,
herve.vandeput@xxxxxxxxxxxxxxxxxx
HELP: Displaying a brand depending on the first 4 letters of a catalog.,
AE
Formula needs to reference anchored relative cell,
mkerstei
Re: delete from 1 list based on another list,
Norman Jones
I am in dire need of macro help!,
Nora
validation? VBA? Lookup table?,
Ivar LeNoir
Re: Select multiple Shapes,
Norman Jones
return non matches,
ll
Copying Cell data and pasting into word document?,
Simon Lloyd
Listbox text color,
kev_06
Re: Pick a Random name from a list.,
Jeff Standen
Re: copy formula down and ever change range,
Jeff Standen
Run-Time error '91': Object variable of With block variable not set,
jammin1911
Macro for printing specific worksheet from a workbook,
splosczynski
Password Oddity,
SamuelT
Named Range - help!,
MattShoreson
Re: Change optionbutton to true for good,
Jeff Standen
RE: Data Move,
ADG
Display Totals In MsgBox,
Pete
Re: Select Case Behaving Oddly,
Dave Peterson
Formating - Conditional,
markvdh
Naming more than one active workbook,
grantj
Re: Auto copy/ paste on relevant work sheet when selecting list item,
Dave Peterson
really weird copy macro problem,
gillrajb
Re: Auto Fill Column with Date based on rows in other column,
colofnature
VBA Library References - deployment issue,
Chris Leroquais
Re: Adding multiple sheets in one go,
aidan.heritage@xxxxxxxxxx
optimisation tool for objective function macro,
wjm
Unexpected output while populating a combo box,
shivboy
VB Project,
BadgerMK
Re: Accessing Macros (VBA),
Ardus Petus
Setting true/false questions in excel,
blabla
Need help in VB6,
anu
Re: Need help in VB6,
Harald Staff
Insert blank row above populated cell,
Bevy
How to late-bind Excel,
maurizio
Loop to add +1 in cell?,
bxvang
Conditional Hide Rows Macro,
cchubba
Re: [OT] Google spreadsheet,
Don Guillett
Re: Add-in,
Ardus Petus
Re: Exporting cobol files to excel,
tony h
Re: Change properties of a userform,
Ardus Petus
formula array gives compile error,
R..VENKATARAMAN
Re: sum program,
Bob Phillips
Removing Drawn Object,
Brian Matlack
Please help a newbie to VB!!!,
certain_death
SQL command help,
cmpcwil2
Re: Run a macro outside of Excel automatically,
Jeff Standen
Check Digit:- A Real Challenge!,
Duncan
Protection of Objects,
KingG
Re: How can I open a Cad-drawing after fulfilling questions in excel?,
NickHK
Strange problems with setting hidden property of a range when sheet protected with UserInterfaceOnly,
heikki . vuolteenaho
re-execute vba function,
Nader
VBA File Variables - User App directory,
Chris Leroquais
Automatic Unprotect / Protect,
SamuelT
Re: earasing arrays,
Bob Phillips
Re: Self Defined Function Doesn't Update Automatically,
Bob Phillips
Re: Text into one cell,
paul . robinson
Macro launches VB IDE window,
cheesey_toastie
Including an input box within a macro,
Drummy
Time and Date,
Dastard
Quick Excel 2000 VBA question,
dabookshah
#NAME,
Scott Collier
Excel Checkbox and Calendar,
edwardpestian
Can I use a variable in a Range statement,
Alfarata
Re: Merge to Columns with Unknown length,
Tom Ogilvy
Worksheet formatting with Macro...,
Celt
Excel Page Setup - Fit To Page option,
sujatha_krao
Conditional format incorrect if not on starting row,
Kevin Vaughn
evaluation a variable in an expression,
andrewsacher
Re: Bolding variable cell,
Tristan
How to download information from web using VBA ?,
Leonardo
Re: Error I cannot figure out,
Dave Peterson
Re: Searchin for dates,
Tom Ogilvy
Re: Pivot Table Grouping from OLE DB source,
Tom Ogilvy
Re: OpenText method not working,
Tom Ogilvy
Need to Sum all values above,
mkerstei
Combo Box Search,
tssgw
Printing a Word Doc,
Brian Matlack
Snap to grid in VBA (actually a SendKeys question),
Nick Hebb
Re: Solver Maximum adjustable cells & Problem with Binary cells,
SteveM
User Form Help Seems Simple,
Brandon Johnson
Subscript out of range error,
kev_06
Re: Print area based on item list,
Ron de Bruin
Add comments via a function - please could you ammend my code/ pseudocode to work,
James Cornthwaite
Re: Logical test as a variable in a UDF,
Dave Peterson
Email question for Ron de Bruin?,
Steph
Re: Hide rows that are empty without autofilter between data,
Ron de Bruin
Re: If then statement,
ikr
Re: Template - Save As File Name,
Dave Peterson
Insert Column w/ Equation - Fill to bottom,
mkerstei
Re: count unique combinations,
Dave Peterson
Do contents of a cell match existing worksheet name?,
cooper . caroline
Copying Data to Last Row,
rglasunow
It works when I step through it but it won't run,
chillihawk
GetSaveAsFilename Question,
kev_06
Re: Deleting A Macro Using VB.NET,
Doug Glancy
Re: Looping Question,
Chip Pearson
Hyperlink question,
Greg
Can't paste picture while Protect Sheet is on...,
groundhog1
Difficulty of creating a macro?,
TylerLange
Speed Question,
shelfish
Copying modules from Word to Excel,
Pflugs
Animated GIF insert - Reference file missing?,
DISMfish
RE: Dim and Redim,
Sean
macro to make named ranges,
Rosencrantz
Re: create files from a spreadsheet,
Ron de Bruin
Search for a specific cell based on two criteria,
RoVo
Deleting multiple items from a list box,
kev_06
Re: Optional Variables,
Chip Pearson
Make Values from formulas,
GregR
Re: Getting values in row and advancing,
Chip Pearson
Links,
ceemo
Need help with If/Then Syntax,
Shani
Need help - extracting data from cell,
kaur . dilpreet
controlling a form drop down based on selection of another drop down,
flurry
Delete empty rows from a sheet,
bm4466
Setting EDoc Printer Pro in macro,
Frank
Re: Input Box Promt,
Ron de Bruin
Re: Default File location,
Zone
Selecting Separate Columns in VBA,
kudruu
basic template questions (on a network drive),
KR
Re: Save problem with location,
pianoman
Re: In Excel, how to make a field required so it's not left blank?,
Chip Pearson
Re: One Sheet by email,
Ron de Bruin
Re: How to execute a excel subroutine from visual basic,
Chip Pearson
Re: Copying Multiple Items,
pianoman
Macro help:replacing figures,
phil2006
Select case and Last Cell Problem,
JamesBurrows
How to select what I want?,
HotRod
Excel VBA option button question,
CindyG
Tracking changes in Excel using an Event Macro,
Ukyankee
clear the copy,
ceemo
workbook name,
ceemo
Function help!,
phil2006
Re: Want to Hide and/or Unhide one or more sheets by providing Passwor,
Nigel
opposite of XLVeryhidden!!,
roshinpp_77
Re: how do i use outlook web access through excel?,
Ron de Bruin
Macro help,
phil2006
Re: Adding a tip when the mouse is hovered over a shape in Excel....,
Jimbo1
Re: A macro to color the cells according to the values existing in a c,
Bob Phillips
Conversion from Spreadsheet Toolkit functions (ESSV....) to EssBase API functions,
sujay
RE: Macros across multiple files,
FSt1
Shorten up som sheets-kode maby a loop !,
excelent
Content from Text box to Cell,
eLaCiD
Re: How get a row number of the controls(sample:optionbutton),
Norman Jones
Visualize results of a custom formula array > 1818 rows,
Ger
EssV functions Defination/Meanings,
sujay
Re: Global Macro,
Norman Jones
Creating a front end application to sql data set,
AD108
MS Word question,
Ron . Winkley
EssV corresponding,
sujay
Re: offset?,
mudraker
Re: What does this parameter mean?,
Norman Jones
Re: automatically calculates the standing,
Norman Jones
Align to the left or to the right (or center),
kaokao1
Re: USEDRANGE,
Norman Jones
Save as saves selected worksheet instead of whole workbook,
alexmillner
Countif and and,
Jeff
ActiveX Controls are disabled,
fred_gallagher
slow Macro speed,
Lam Chop
Re: Date conversion,
fazstp
<Possible follow-ups>
Re: Date conversion,
Norman Jones
Importing data from Access to Excel, but I need to vary the table from Access,
Liz L.
Re: Userform with Excel chart sheet,
Jon Peltier
Using a macro to import field names into a spreadsheet and place them in different fields,
rjr
InStr Function,
zoot
Macros in Toolbar,
warburger
Help with Looping Code,
JimMay
Named Ranges for Chart,
Sami82
How can I Hide?,
Marcelo Rychter
DeleteFile Method,
don
Help with code,
JimMay
advanced filter format problem,
CG Rosén
other options to functions which cannot modify contents?,
James Cornthwaite
Re: Can I find a string with or without a space after the last charact,
Bob Phillips
Re: Checking Sequential numbering,
mrice
Re: how to create links to all files in directory,
Ron de Bruin
Copy text from excel and paste in word - Urgent Help,
sippy
Proper code,
JimMay
floating legend,
Jade
Re: Working within a workbook without activating it?,
richardfisher
Strings not comparable??,
Marco Bandner
cell value to text box?,
tomro1
Color contents of a cell accessed by a function?,
James Cornthwaite
need a variation in VBA for subtotals,
CJ
Re: Display cell range in listbox,
Tom Ogilvy
Re: help for Visual Basic Find,
Tom Ogilvy
Re: Test for Hyperlink,
Ardus Petus
Help with coding error,
carlos
Re: Interupted Scrollarea,
Ron de Bruin
Re: Tables from web to excel,
DS-NTE
Verifying path fails for no apparent reason..Clueless,
steveblack2006
Re: How to compare today's date to a cell on VBA?,
Sivangen
Help with sebastienm's code - Returning To Previously Selected Worksheet,
AcesUp
File already exists. Do I want to replace?,
EMoe
Re: "User-defined type not defined" error when trying to send e-mail,
Norman Jones
- Message not available
- Message not available
advanced filter,
CG Rosén
RE: How do I Loop through this range and . . .,
Greg Wilson
Running macro upon opening workbook,
don
Leave live cursor in a cell?,
Bob
close without save silently.,
x taol
Error trying to close down dbase IV file used for input to excel,
don
when press the close button in printpreview,
x taol
Help Combo Box,
Marcelo Rychter
Re: #NAME?,
Don Guillett
copying from a table,
tanner
Re: Tip on dialogue/combo box,
mrice
Re: Possible Combinations of scores,
mrice
Re: Copying and Pasting Different Formulas,
C01d
Text wrapping on merged cell,
Colin Telfer
Will Excel "compare" two worksheets or files?,
George
Is this possible?,
phat al
Is there a way to do this?,
brawny_javo
Application.FileDialog(msoFileDialogOpen),
H . A . de Wilde
Re: Like operator,
Agnieszka
Color text based on value,
dvonj
Is this type of worksheet protection possible?,
Hrundi V. Bakshi
Reading a cell that a user has clicked on,
Aaron1978
How to save a output property from MSXML,
Marcos Hercules
Copy named range from file list to summary workbook,
plantechbl
How to backfeed radio buttons?,
G Lykos
Run macro which name is cell value,
eLaCiD
Cell Naming,
Grymjack
Re: Unhiding specific worksheets in VBA (Excel 2003),
MSweetG222
RE: extract data from a text file,
Spike
Re: Copy row contents based on contents,
Dave Peterson
Errors 32809 and 57121 :-(,
Jan
Automatically click "Update Links" & "Continue",
paulharvey
Open workbook in existing Excel session,
mnehlig
Re: Positioning the Calendar on working screen,
Norman Jones
Conditional formatting,
Doug Day
Copying rows based on date,
flurry
Generalising sort routine,
lexcel
Interface Design: Drop Down,
whitehurst
Icon on the top,
Marcelo Rychter
copy from table,
tanner
E-Mailing Question,
John
Re: Column Limit,
JDMils
VBA - The Literal "Microsoft Excel" on the Top",
Marcelo Rychter
Re: retrived last modified date,
Bob Phillips
check blocks in loop,
sybmathics
Create your own poll for free and share your opinion,
prabhuraaman
Send a frame control to a procedure as a parameter,
JDMils
Re: SEARCH AND REPLACE (in Excel 2007, beta),
Probyn
Importing multiple text files to worksheets,
josnah
using an IF function for a total,
Drummy
Re: IF,
Ardus Petus
copy date based on date -refer to date range,
mindpeace
Copying multiple sheets into a NEW workbook,
kev_06
get Outlook calcendar appointments,
gabch
Re: hide PERSONAL.XLS,
Tom Ogilvy
- Message not available
- Message not available
making hotkey in textbox in userform,
x taol
Re: Creating a Price Book,
Chip Pearson
Re: Best tutorial for building base/collection classes?,
tony h
RE: Customer Word form to Excel db,
Dexxterr
Re: Custom toolbar buttons,
Chip Pearson
Re: Better way for writing IF statement ?,
macropod
Re: Storing User response,
Chip Pearson
cut data labels in bar charts,
tweety127
dbgrid control into a userform,
x taol
Copy multiple sheets using a list box,
kev_06
Re: Clear cells,
Chip Pearson
Fill Array from Selected Items in Text Box,
John Michl
Copying sheets to a new workbook,
kev_06
Sum with array problem using SRC/BusinessObjects software,
bird_222
Macro not found in Application.Run,
ndalal
Excel: Filling a user form with yesterday's data,
randallwilkins
Re: VBA - need to minimize Excel from UserForm,
Jake Marx
Passing a Reference in VBA,
Bill
RE: select database file path location for excel query,
Tom Ogilvy
RE: Exce Macros,
Jim Thomlinson
Managing Data in Cells,
Dastard
Excel / VBA - Pull data from one column to new sheet by ident #?,
askew . j
Loading from startup,
kev_06
Delete Columns with duplicate headers,
Casey
Re: Excel Problem....,
BlueTrin
Counting rows in Excel spreadsheet.,
Jim15
Re: Time to complete code/function,
Jake Marx
Run macro whenever cell changes,
eLaCiD
Problems with Word via Excel VBA,
joseph . choi13
Loading list and combo boxes from startup,
kev_06
Relative return to original worksheet in middle of macro,
alexmillner
Re: Autoselect data using Macros,
shoaibj
Re: RowSource in Properties Dialog continued......,
Spike
Re: Cell protection problem,
Dave Peterson
Re: How do I replace a carrige control(box) in excel using VB,
Dave Peterson
Re: Help on Matching and Copying Values In Two Different Sheets,
sylink
How to dynamically add/change Reference?,
Joe HM
Problem deploying an automation addin (VS2005, Windows XP SP1, Excel XP),
BlueTrin
Re: hide columns macro,
Jeff Standen
Help Please: Syntax Problem,
Oblivious
Re: Need help saving file with SUMPRODUCT formula,
Jeff Standen
Problems with Word,
pikapika13
Excel does'nt reconize SolverOK,
lahbib
Re: Run-once macro,
Jeff Standen
Excel 2000/2003 Secondary Axis issue,
darkshadow1886
RE: Assistance required,
Tom Ogilvy
Excel.EXE remains in memory,
harshu4u
Optimatization project,
Anthony
why is it my excel file is always crashing?....,
tweety127
Move cell focus in VBA,
VD
Olap Pivot Tables: Multiple calls to AddPageItem and performance,
urs . eichmann
Fill formula from VBA,
Archie
Tab Order,
EA
Re: Copying macro from word to excel,
macropod
- Message not available
- Message not available
- Message not available
- Message not available
Chart Adjusting Macro II,
chesharma
Close form...,
pianoman
Verify before proceeding,
snowing
Get The Length of data type of excel using visual basic,
sanjaybol
Positioning Worksheet names on Activate,
JimMay
Programmatically query Excel drop-down list ?,
diglas1 via OfficeKB.com
Remove all macros and objects in Excel, Save and Quit,
kanchianil
How to Disable Customize PopUp Window,
Kieranz
Re: DDEExecute With Very Long Strings,
Peter T
Re: Subtotal in header,
Bob Phillips
ActiveX textBox : value doesn't show after programatically changing the value,
Philippe
Re: eroro in simple function,
Jeff Standen
Re: Count down,
Bob Phillips
Re: Macro for splitting a cell,
Jeff Standen
Re: what are the advantages & disadvantages of using forms in excel?,
Bob Phillips
Re: Macro: If(And(...,
herve
Re: split cell at first space,
Andrew Taylor
Re: How to display the user "locking" a workbook or an addin.,
Ivan F Moala
Re: How can I use the " character in a string,
aidan.heritage@xxxxxxxxxx
How can I make File->Save , File->SaveAs Menu disabled?,
Zoo
store sheets listed in listbox in array,
Orhan
Re: Optimizing memory, speed: Arrays vs. Cells, etc...,
Charles Williams
Re: Add function at bottom of Spreadsheet,
Nigel
Menu bar question,
gabch
Re: Disable Object buttons, based on value of other object buttons,
Leith Ross
Drop Down Lists,
AD108
Outlook Warning Messages,
AD108
Compile Error,
Patrick Simonds
Re: Excel: = sign keeps coming up when i enter 7/1 for date,
Norman Jones
Re: Delete all modules and forms from workbook,
Norman Jones
Deleting rows after a specific Value,
Steel Monkey
maro to work on one sheet as opposed to all sheets in the workbook,
gilligans
Property Lists,
fazstp
Listing all files in an online directory,
paulharvey
Re: Copied range. Help please!!,
Paul Lautman
Data Validation not working (with a Worksheet_SelectionChange event),
Todd
Lost Help,
Otto Moehrbach
Creating ranges,
pmguerra
Replace words in Formulas on a DashBoard worksheet,
junoon
disabling readonly(protect on worksheet) using vba,
tweety127
Wildcards and Acronyms in Excel,
Phil
Re: Calendar,
Norman Jones
Read Only File,
Alan
Subscript out or Ranger Error 9 - I'm lost here!,
halem2
Re: Reference a Column by Number,
John Michl
Automatically run macros,
daddioja
Adding commandbutton to sheet,
ckoch
Re: Ned to speed up my code,
Anthony
Clearing a value from a TextBox Automatically??,
Simon Lloyd
Re: Annoying Problem - Subscript out of range,
Anthony
EXCEL 2003 - system.diagnostics,
Christian Lehmann
Finding files on external drives...,
trumb1mj
Resize Problem,
GregR
- Re: Resize Problem,
Dave Peterson
- Re: Resize Problem,
GregR
- Re: Resize Problem,
Dave Peterson
- Re: Resize Problem,
GregR
- Re: Resize Problem,
GregR
- Re: Resize Problem,
Dave Peterson
- Re: Resize Problem,
GregR
- Re: Resize Problem,
Dave Peterson
- Re: Resize Problem,
GregR
- Re: Resize Problem,
Dave Peterson
- Re: Resize Problem,
GregR
- Re: Resize Problem,
GregR
- Re: Resize Problem,
Dave Peterson
- Re: Resize Problem,
Jeff Standen
- Re: Resize Problem,
GregR
How to avoid deleting of rows,
2foot
Workbook Variable,
almostmature@xxxxxxxxx
Re: Delete rows that do not meet specific criteria,
Bearacade
PublishObjects lockup,
ICE9
Re: Runtime error with vba and checkbox,
SplatterKat
copying and pasting from source sheet to destination sheet without naming source sht?,
Simon Lloyd
Re: Bingo Lottery,
Ardus Petus
Re: Worksheet protection,
colofnature
Know a list of machines on a network running SQL SERVER,
sal21
web query,
cliffgry
Yet another "copy method of worksheet class failed",
pdr3
Re: Set Print Area,
Don Guillett
Registry Keys,
EA
Re: copying cells from one workbook to another,
Jeff Standen
Re: excel file recovery....urgent please...,
tweety127
Get External Data VBA,
andysgirl8800
Re: Get External Data VBA,
andysgirl8800
Re: Get External Data VBA,
andysgirl8800
Re: checking if two arrays are equal,
Ardus Petus
Macro To Delete Filtered Pivot Table Data,
Roger
file manipulation,
BillyRogers
match function inside if function,
gnotnoel
Loops to find blanks then loop to find populated,
Bevy
Re: Strange issue Excel >> Word automation,
mxs
MAC authentication in Excel VBA,
sieglej
Copying a chart to a user form,
samuel.dogbatse@xxxxxxxxx
Re: Cut to EOF,
colofnature
How to report Excel 2007 problems?,
Josh Sale
Re: How to determine links to external files or spreadsheets,
Norman Jones
Re: Not allow duplicates from listbox to Worksheet,
Casey
Re: I want to treat numbers as text without any complaints,
Jeff Standen
Automatically update graphs and equations,
Rosencrantz
Calling a Program,
Bill
Re: Select worksheet tab at furthest left position,
Norman Jones
Opening all linked workbooks,
Eric
Chart Export Issues,
sather.brian@xxxxxxxxx
Re: Search for worksheet name,
Phil
Macros and Goal Seek,
speed2
Mousedown Macro,
mabbutt
auto sort,
jamex
Re: Shortcut key,
Jeff Standen
Re: Macro that runs automatically?,
Norman Jones
Re: Automatically run a macro at a certain time,
Bob Phillips
Re: merging worksheets,
mollsters13
creating macro VB in Excel - find and move program,
DictatorDraco
Re: If sheet has no #N/A error then...,
Tom Ogilvy
Hide data based on future date,
nougain
Filename array,
pianoman
Re: Find Minimum values in cyclical graph,
kounoike
Re: Change Value Active X control,
Jeff Standen
Class Module question,
WhytheQ
Specifying Filename when creating PDf from Excel Workbook,
jlejehan
Re: Checking for changes on a multi-user worksheet,
McBarker
Re: 1004 error,
Norman Jones
Re: Data Validation and file size,
diykid
Re: Troubles with ActiveSheet.ShowAllData,
Jeff Standen
Question on Unicode and string conversions in VBA,
RichardSchollar
Strange printing order,
emilija
Add list as a subchoice to a custom menu,
stakar
Last friday,
gabch
Re: creating a VBA variabel from multiple named worksheet ranges,
brachistochrone
Re: InputBox Query,
Jeff Standen
Re: Click "Ok" without prompting - Macro,
Ardus Petus
Formula which change color,
the dude
sending bitmaps through Lotus notes,
rogedavi@xxxxxxxxx
Excel Patch to Support .NET v2.0,
Mat P:son
macro deployment - References DLL issue,
christophe . leroquais
Caption property,
the dude
Re: Lookup fields in Pivot Tables,
Paul Lautman
run time error 9,
SandyUK
Re: UserForm Problem,
the dude
Re: Printing an Access Report from Excel,
Arthur
Setting autofilter at runtime,
AD108
Re: User defined function - adding names,
chillihawk
wild card with if logical function,
b166er
Re: .CodeModule.Find AND PatternSearch (using Regular Expressions),
Paul Martin
Re: List of superseded APIs,
Paul Martin
Re: validation problem,
Ardus Petus
<Possible follow-ups>
Re: validation problem,
Tom Ogilvy
Re: External Files,
schoujar
Re: Moving Sheets To A Different Workbook XL2003,
Tom Ogilvy
Reference to cell - VBA,
Darryl Kirtland
Re: Runtime error 1004,
Oldjay
Macro that writes Macros,
schoujar
How does Windows recognize the file as Excel's?,
Zoo
Progress Bar & Cell Linking,
Xenoshan
Data, Validation, List always starts at the bottom?,
Simon Lloyd
Re: Which combobox has the focus?,
Daniel Bonallack
sumif criteria,
Dean
Re: Within the same procedure, can such Inputbox be used more than,
Edmund
Re: Excel 2000 - Pivot Table Show Pages,
Debra Dalgleish
Re: extracting data from a table,
Debra Dalgleish
Re: SumProducts on a spreadsheet with a variable row dataset,
ljsmith
Re: add sheets,
ljsmith
Help on following code please?,
Greg
Real Time Charting,
lossofdog
Re: Assignment of range to array problem,
kounoike
Count Rows,
snowing
Re: Graphics in ADO Recordsets,
Tim Williams
Grouping and moving worksheets problem?,
Simon Lloyd
Re: Use of CHOOSE? appropriate?,
macropod
Re: Autofit on Merged Cells.,
Peter T
Re: Text Import Wizard change default selections,
Chip Pearson
Major Issue - can no longer open my file!!,
gonger
Copying by Column "Header Name" macro,
akane
Re: Need to combine data programatically.,
PaulD
Extracting defined names,
jsw47
Macro for excel & msoutlook,
binod
Re: enabling a custom menu at workbook open that is disabled,
Chip Pearson
