microsoft.public.excel.programming
- HELP: Formula for combining fields,
pollewops
- Anyone know how to hyperlink destination in a cell?,
JethroUK©
- Test if value is between two numbers,
smplogc
- Re: Stop a running Screensaver .,
Steve Yandl
- Range Type Mismatch Excel vs Spreadsheet 9.0,
letapia1970@xxxxxxxxx
- trim,
RobcPettit
- Immediate Window - Available Commands,
Patti
- Selecting multi rows,
Derek Mansfield
- Re: how to use a command button in excel?,
Otto Moehrbach
- VBA Calculation Error,
The Hawk
Convert an excel file to an exe file,
Paul
Problems with calendar control,
Wim
Re: How to turn on Shapes conditionally?,
Ken Johnson
Split Field content in Query?,
Abdul
Re: Input data form with drop down list,
Ron de Bruin
Re: Santhosh,
Ron de Bruin
Text to Columns,
ericsh
RE: On Error GoTo ... But wait!,
monir
call excel macro from asp page,
berkeleydb_user
Re: Month plus one,
martin
Entering the date before Automatically,
thejuni
trouble getting addin's workbook_open procedure to recognize activeworkbook,
martin
Conditional BackColor Loop,
obsessive
Save as XML File msg !! (Macros),
rvillanueva
Re: Check if named range exists!,
Gary Keramidas
Help with multiple sorts, multiple sheets,
Slow1911s
If ActiveCell.Font.Bold = True Then ... trying to specify a range, not 'entirerow',
Winawer
simple question,
Bob Bedford
Re: Downloading historical stock data from MSN Money to Excel via VBA,
Charles
ActiveSheet.QueryTables.Add using InputBox and/or a URL list in a .txt file list,
crazy_vba
form stops execution,
Marcos
OnKey and Range Question,
jayy
Betfair Poker,
scottymelloty
Add-In Madness,
Ron Rosenfeld
Re: autofilter : how to go to next row ?,
Tom Ogilvy
Re: How do I enable a disabled Autofilter in Excel,
Dave Peterson
copy formulas & format of row above when inserting a row, but only on 1 sheet,
Celt
Re: inserting more than 65536 pictures into file using VBA,
Peter T
how do i find an email and copy the text and paste into excel sheet,
VB Script for Excel
Print variable page sizes,
nsv
load addresses of selected cells into array,
galefly
Foolproof .find,
Robin S.
Re: Workbook open to the same sheet,
JE McGimpsey
2000 will Hang - 2003 will Open,
Jeff Kurschner
Save As ... (using macro XLS),
rvillanueva
Re: How do you get calling cell for custom function,
Bob Phillips
Inserted row must have the same format as the row above,
Luc
Re: renaming sheets,
somethinglikeant
MMult and MInv,
tedy
MID function and SQL Query,
Soniya
Re: How do I add a month to a filename extracted from a cell,
somethinglikeant
removing duplicates in lists,
red6000
Re: Number Displaying as Date,
somethinglikeant
How to reference column by name,
Scott Steiner
Add Database Names, table names & related fields from table in combo box,
Snowy
Find record in database,
Mohammad Alsayad
closest neighbour coordinates,
Mick
Re: Change Format of Entire Column,
Ken Johnson
- Message not available
- Message not available
VB interface,
AD108
Exporting Excel Graphs,
Richard John
Loop through a range of cells to find unique entries,
zoot
Re: Method 'PasteFace' of objetc 'CommandBarButton' failed,
Jon Peltier
VBA for getting files off internet,
Btibert
ot - Wanted: Excel Programmer Writers in RedmondWanted: Excel Programmer Writers in Redmond,
Gary Keramidas
Re: VBA Code Reference to Solver Failure !,
Jon Peltier
Re: Find and Replace in a DDE string!!!,
Tom Ogilvy
Statistical formulas across sheets?,
Don Wiss
Maximum data points for PERCENTILE function?,
Don Wiss
Preserving Undo History Solution,
willjohnson33
Re: add a Text Box and a Check Box on a sheet,
Chip Pearson
using variables in codenames,
mars1968@xxxxxxxxx
Re: How do I simulate dealing from a deck of cards?,
halogen
Book recommendations,
halogen
Please Help: Paste Column Contents to Next Available Column Without Data,
mneches
Select a Range of (Variable) Rows,
Loucas
Very weird - Code does not work until after file is saved???,
InfiniteJoy
Format Cell Colour if contents are Changed ?,
MAS
Error opening external xls,
pietgrob
Creating and renaming a worksheet from user input,
jonco
ExtenXLS loads data into Excel 2002 file but damages the Excel file.,
kp2900
Controls names as varible?,
lily
paste only if destination cell nonblank,
edwardpestian
Count number of characters in merged cells + adjusting rowheight,
Luc
RE: named range in,
Tom Ogilvy
Relative Reference,
liseladele
Weird range selection issue XL2003- help please!,
KR
Re: Autofilter detection,
Chip Pearson
Re: Error using OnTime Method,
Chip Pearson
How do i check if the current cell is part of a range ?,
Luc
Worksheet Sum Question,
czywrg
Re: UDF setup for a range of cells,
Chip Pearson
Re: Save As Event,
Bob Phillips
Error on Import,
Ken Hudson
Disable Macro on real only option,
Renato8
Copy Button Problem,
mtm4300 via OfficeKB.com
Determine if entire row or column is selected,
MC82
Determine cell value based on list from other sheet,
TBAnashdk
Conditional Button.,
sungen99
Analyst data and display results in new worksheet,
Lesley_h
Activating an Open Workbook without using the whole filename as a reference,
jlejehan
Closing one workbook with a varying name,
Craig
Re: Linking using a variable in the path,
Dave Peterson
Re: Adapting an array formula,
Bob Phillips
Copy Special,
bm4466
Re: sumif with <> "",
Gary Keramidas
Referencing Controls Using Variables,
Teodomiro
A little help with some code please.,
sungen99
Inserting Open Event code via VBA,
Pete
- Message not available
- Message not available
ComboBox Change event triggered incorrectly?,
Vindaloo
How to Open a Word Template from vb.net,
Don Mylrea
Copy and Paste Values ..... then Reverse !,
jagstirling
The problem with comparison of text as well as the password from the VBAProject Protection :(,
And1
Assign a macro to a hyperlink,
Daminc
NOT A VBA Question, I need to delete a row which has a certain cell value, can anyone guide me in the right direction?,
LJ
not open xls if macro protection,
miro
Unusual Excel error message,
alan_conoco
Advanced filter in VBA,
mayou
Custom function for weeknum to Month i got some issues with this need alittle help,
robertjtucker
Modify code to insert borders,
Phil H
LOOPING BUT THE MARKS ARE NOT IN SEQUENTIAL ORDER #3,
sam . fares
VBA Code HELP PLEASE!!,
Nick TKA
select non-locked cells,
kontraa
Re: Range Name affecting speed of macro,
broro183
macro clash,
bondcrash
Re: VBA: Generate listing based on another worksheet in the same workb,
Alexander Lopatsch
userform control backcolour.,
MattShoreson
Re: Cancel Addin Install from Workbook_AddinInstall?,
Ivan Raiminius
NOW() function,
Sami Euren
Re: Calculating a field in pivot tables,
AmyTaylor
Re: inverse formula,
ina
Weird error,
Adi
Re: Problems with Command Buttons Randomly Resizing themselves,
pianoman
accessing worksheets from 2 excel files,
ashishprem
vb.net calling worksheet by name,
Barnie
SubFolders in macro,
pianoman
Extracting only when column contains a certain value,
AmyTaylor
save file,
asburypark98
Re: Generate listing based on another worksheet in the same workb,
PY & Associates
Embedding Excel graphs in Word,
Richard John
Macro Help - Loop Problems,
ksp
Protecting formatted cells.,
Peter Ostermann
Re: What is Excel CS?,
Tim Williams
Re: How many levels of an IF statement is allowed within a Nested IF?,
mudraker
"Greying" a UserForm text input box,
den1s
Format error,
Patrick Simonds
Test post,
Patrick Simonds
Project or Libary,
Patrick Simonds
Project or Libary problem,
Patrick Simonds
Re: VBA: Tools -> Reference,
Dave Peterson
Re: How to select range of Active Window,
Simon Lloyd
ShowWindow and reposition/resize after selecting an embedded chart,
InfiniteJoy
Adding a reference programatically,
Fred
Re: Adding a reference programatically,
RB Smissaert
Re: How do I link one checkbox to update another checkbox?,
Jim Cone
Re: match,
Tim Williams
Re: Printerproblem,
Rody Meulman
Keystroke identification,
Tim
Re: Check box control,
Jim Cone
XL doesn't like my path?,
davegb
Using IsBlank in VBA,
Conan Kelly
When a scrollbar is not a scrollbar,
Flash in the Pan
Match or Find Function Help Please,
mkovaleski
Help selecting a range in vba from userform inputs,
grievesy
Re: How can I do date "calculations"?,
Chip Pearson
Sorting data in non-contiguous cells,
jonco
Run-time error 1004 on variable,
Casey
checked the equal values from cells,
kar
Form to select 2 spreadsheets,
davegb
Selecting Used Range,
loric
Compare 2 lists macro help!,
zaq121
Re: Debugging,
Ikaabod
Re: Combine data to fixed product id,
Kletcho
RE: Clearing all values in a User Defined Type variable,
J Streger
Re: The x (close program) in the upper right corner is greyed out...,
RB Smissaert
RE: Next Blank Row,
Jim Thomlinson
Re: Max and Min Numbers with text,
Bob Phillips
Re: OnTime question,
Bob Phillips
What Does This Code Do?,
Lil Pun
how to convert a range from numeric to text type? but quickly,
lauralucas
Capture user input into xldialog print,
vpanang
Scroll bar - to increment btwn MIN and MAX value.,
jay
MonthName to Integer from Current to Previous Year,
nerbe
Could someone HELP TRANSLATE this simple psuedo code into MACRO pl,
bxc2739
RE: Pivottable Field items code -problems,
bxc2739
RE: Excel - global VB macros,
bxc2739
Re: Working with Arrays, pasing from function to function,
Bob Phillips
LOOPING BUT THE MARKS ARE NOT IN SEQUENTIAL ORDER #2,
sam . fares
Clearing a cell,
news.microsoft.com
getting vba shell command to execute batch and save output to a file,
Mad Scientist Jr
Workbook not closed when OnBeginShutdown and OnDisconnection events fire in Excel Addin,
Alan
Show one of multiple comment boxes based on value,
kurtech
If value is equal, if not a blank row is inserted.,
Emajination
Need help coping a range of data from sheet 1 to the next empty cell in sheet2,
alpine7411
Re: password protect macro,
AidanH
auto import a table into excel from a html,
ceemo
Apply AdvancedFilter in more than one columns,
Bala
Need VBA code for Rnadom Number Generator,
Shani
Random Number Generator help,
Shani
public Function Error Excel 2003,
xunzi
Procedure name as variable,
Redbeard
Listbox to generate 2nd Listbox,
SirLoin
Re: Neverending lines.,
aidan . heritage
Re: Filter Problem,
aidan . heritage
Re: Mix of relative and absolute?,
aidan . heritage
Re: Private - seeing macros again!,
Ardus Petus
Data From Web,
MBSNewbie
Passing a comboBox to a sub,
cmpcwil2
Looping through a user defined type?,
plh
Hi-Lited Cell trouble,
Brian Matlack
Conditional delete using saved macro possible ?,
Raj.
RE: Printing userforms,
Tom Ogilvy
HELP - Stuck in loop,
gti_jobert
Re: creating template,
NickHK
Re: autofit problem,
excelent
button that opens open dialogs but saves path to sheet,
cereldine
Copy rows from excel sheet to a word document,
ashishprem
Retrieving a Name of Cell,
cheesey_toastie
Re: Macro to copy from workbooks listed as http links,
Ardus Petus
Help reqd with adding menu items!!,
kinny
Macro to get comments out of a spreadsheet,
shanelaura
Copying formula cells that really ought to be constants?,
Nate
Re: Timed Popup Message,
Ivan Raiminius
Re: How to stop warning message in Excel "initialize ActiveX controls",
Michel Pierron
How to open a macro?,
Mark Milke
Reduce Flickering using Application.ScreenUpdating,
Xiazer
Re: Last Row Variable,
Zurn
Xls --> Xlt,
Zurn
how do i make a macro that will select all those cells that are empty,
VB Script for Excel
Opening a workbook, passwords and error 1004.,
droopy928gt
Tool tips or screen tips,
Andrew B
help with macro about data entry with double counter,
veli.izzet@xxxxxxxxx
Re: save in directory,
mudraker
Re: Truncating to two decimals,
Dana DeLouis
Browse for file name code? (Excel 2002 VBA),
kp2900
enableevents in event codes,
R..VENKATARAMAN
Re: Command Button - On Click Event,
Jim Cone
RE: How to add a password check when an excel workbook opens?,
cush
Color of output,
John
Excel Macro: Matching and calculating 2 worksheets,
mayanair
Allowing a UDF to,
JF3
PASSWORD REMOVAL I have the password to open the file and the password to modify the file now how to remove them,
LJ
User Defined type as Sub parameter?,
plh
Userform for time entry: multiple controls/single value?,
smplogc
template for fuel log?,
GWAR
Entering the same text into multiple cells on multiple worsheets,
kyrospeare
Re: Excell Add Comment,
Norman Jones
RE: VBA scripting in Excel,
Len
Statement to Automate new sheets if is needed it.,
maperalia
Re: functions in merged cells,
tony h
Help in finding first empty cell in multiple ranges,
jonco
protect tab,
Andre
Ranges, adding a column to a named print range then saving the file,
ross_smith
Help!!!.. Fuzzy Matching for Chinese Characters/Names.. is there a Macro out there?,
frostytile
code for seperating alpha numerics,
saziz
splitting strings,
tad_wegner
increasing the size of a named range and saving it back to the spreadsheetI,
ross_smith
Dialogue Boxes,
AussieDave
Re: Clear check box macro,
Rick Hansen
Conditional Delete in Excel using Macro,
rhjaisingh
color changing cells,
darrenm
RE: copy question,
srroduin
Autofit Pivot column by Criteria,
VBA Noob
Re: Multiple corresponding Values (Biff.........),
Bob Phillips
UDF Question,
Koye Li
Re: urgent : count of digits in a number,
Die_Another_Day
Issue with Hiding Columns,
chris100
What Range property distinguishes a double from a datetime?,
LJ
Re: count of digit in a number,
Dave Peterson
Set Bkg Color if cell value is less than or equal to -14,
moglione1
Re: How do I set the time in Excel,
Niek Otten
NSIS VBA Add-In Installer,
dgp
Re: count in a string,
RB Smissaert
Re: inserting formula,
NickH
Re: submit button in macro,
AMDRIT
Run Event Code In General Module,
Who I Am
Re: vbCancel,
Die_Another_Day
need help..,
ritu
Re: Getting the color for each cell in a selection,
Die_Another_Day
RE: faster way to convert hex to ieee754?,
Tom Ogilvy
DDE Module Messing up Other Code,
Lil Pun
Re: Getting color of each cell in selection,
Chip Pearson
accessing another program from Excel,
jpfullerton
Re: faster way to convert hex to ieee754?,
bplumhoff@xxxxxxxxx
How so I make a "Worksheet_Change Event" to show cell changes in Excel?,
susiecmore
Re: Display message box after each line of code?,
Bob Phillips
VBA "For Loop" Question,
wingfield
Zip Code Formatting,
weeshie73
Writing and reading from a template Excel file using ADO.Net - results not recalculated,
RJN
What's the future status of xlDialogFindFile?,
JK
Re: Pause a macro after each line, run next after hitting spacebar?,
Chip Pearson
Get info from Powerpoint 2003,
ordoff73
RE: using a filedialog box from a dll,
Tom Ogilvy
Validate an Email Address,
Duncan
Excel Worksheet Change Event,
susiecmore
Re: Q re program speed, with 15k lines of data,
RB Smissaert
LOOPING BUT THE MARKS ARE NOT IN SEQUENTIAL ORDER,
sam . fares
Re: Replace Return,
Dave Peterson
ListBox items paste into worksheet in reverse order,
Casey
selecting sheets of the same name between two workbooks,
Craig
Find New Entries in a List,
macb
Re: N/A # and error 2015,
ina
Re: problem with code,
Ivan Raiminius
Re: HELP ON SUMPRODUCT() FUNCTION,
Bob Phillips
Insert and Copy Data to new Workbook Row,
Ozzie via OfficeKB.com
Increment numbers in column A by 1 when selected,
mikeburg
RE: Real Time Collection and Display of Data by Excel,
Steve Landry
Circle equation in VB,
David
Re: Return ROW number from qa found range,
Chip Pearson
Re: How to stop Excel from truncating text to 255 characters?,
Dave Peterson
Largest number in a column,
eyecalibrate
conditionally adding a cell,
newbie099
RE: test first character in cell,
Tom Ogilvy
Re: FTP uploading,
mudraker
RE: Display alerts,
Tom Ogilvy
Re: LastColumn used as letter(s) in VBA,
JBUK
Re: mouse pointer as a hand,
gavins_satori
Excel Process Hanging ( Interop.Excel),
Jörgen Ahrens
adding a macro to a cell,
enyaw
RE: Cursor Event,
gavins_satori
Resize and Transpose question.,
Ken Johnson
Pls help me for data transfer from 1 file to other file?,
shital shah
Convert US date format to UK date format,
Louise
Event handler,
VBA Noob
Similar to sumproduct...?,
Darin Kramer
Row limit in Excel,
mannan
how to display different content depends on some conditions?,
sam
MSFlexGrid Delete Row,
gti_jobert
Finding a date & Selection.End(xlDown),
Clivey_UK
setting print area,
Nick Smith
copy cell content only,
Nick Smith
Userform problem (Listindex),
Gert-Jan
Updating Excel data with a newer version of Excel data,
steviec334567
Overview over lockd cells in a sheet.,
Ebbe
Formatting Axis,
damo
loop on visible cells only,
Sliman
Re: Customizing a menu bar...,
Bob Phillips
web query: password protect (plz help),
vikas
PivotTable: possible to display Data Item field as it is?,
blackpuppy
RE: Accessing Tooltip Data in an Excel Chart,
Vic Eldridge
Matching and calculating 2 worksheets,
mayanair
How do i delete all the rows lying below a cell.,
VB Script for Excel
How can I detect if the text in a cell is underlined?,
plh
Re: auto numbering macro,
Tom Ogilvy
Re: How can I create a project estimation tool with excel,
Tom Ogilvy
Re: Adding picture to page setup,
Pelarian
ThisWorkBook problem,
Blogd_Node
Identify and differ msoRectangle, option button textbox,
MD
Re: Macro Help - Deleting two characters per line!,
Ricky Pang
Unable to Copy Add-in To Library Error,
John Hutcins
workbooks damaged,
Mikeyhend
Trigger Macro on change in cell value,
qwerty
Pivottable code problem,
Rayo K
Re: Accessibility to macros,
Die_Another_Day
Where to start?,
edwardpestian
Re: Passing Module to subroutine,
Chip Pearson
Re: Allowing User to save file,
Kletcho
How to display Items in ListBox,
sam
finding last used column,
Craig
Get Info From Web,
MBSNewbie
Excel to Word Run-time error 91,
Lee
How to check if a range contains a certain value,
Luc
Please help this teacher out,
NoProgram
navigating to an unnamed spawned window ?,
tmp2100
Macro to Simulate F2,
Lil Pun
How to Select All sheets,
Dawn Bjork Buzbee
Re: CLOSE WB,
NickH
- Re: CLOSE WB,
Die_Another_Day
- Message not available
- Message not available
- Message not available
Re: Help with Range Reference,
Niek Otten
RE: How do I trigger a macro by selecting from a dropdown list?,
Jim Thomlinson
Re: Adding Colour,
Ikaabod
User-defined type not defined,
cluck
Runtime Error 1004 Unable to set the XValues property of series cl,
Rachel
Userform for displaying values from a row,
Gert-Jan
- Re: Userform for displaying values from a row,
Craig
- Re: Userform for displaying values from a row,
Gert-Jan
- Re: Userform for displaying values from a row,
Die_Another_Day
- Re: Userform for displaying values from a row,
Gert-Jan
- Re: Userform for displaying values from a row,
Die_Another_Day
- Re: Userform for displaying values from a row,
Gert-Jan
- Re: Userform for displaying values from a row,
Die_Another_Day
- Re: Userform for displaying values from a row,
Gert-Jan
- Re: Userform for displaying values from a row,
Die_Another_Day
- Re: Userform for displaying values from a row,
Die_Another_Day
- Re: Userform for displaying values from a row,
Gert-Jan
- Re: Userform for displaying values from a row,
Gert-Jan
- Re: Userform for displaying values from a row,
Die_Another_Day
- Re: Userform for displaying values from a row,
Dave Peterson
Simple Question from Newbie,
NoProgram
Random Name Generation,
Fleone
Importing large file,
Brian Matlack
RE: NOT WORKING..Getting XLA files to work with Excel,
basilio
Re: installing an addin,
basilio
Cut and paste by reference part 2,
Lunks
Re: import multiple files to excel,
Cellmate
Toggle Subtotal on and off,
Paul D. Simon
Read Write Programming,
BEEJAY
Replace: Object Required,
Trent Argante
Check and uncheck a checkbox,
NoProgram
RE: Run Macro on Change,
Tom Ogilvy
RE: Converting Data Types,
Tom Ogilvy
Replacing "NULL",
Conan Kelly
Find/replace range,
Corrine
Convert clunky nested If statement to macro,
westexp
RE: Excel constants,
Tom Ogilvy
read outlook contacts,
William
Re: Date in VBA,
Don Guillett
Some helpful UDF's,
Jeremy Gollehon
Re: Lower case VBA,
Don Guillett
VBE freezes after running macros,
dweis
Saving worksheets as filenames,
AmyTaylor
reference item,
William
Create Summary WB,
GregR
read database,
William
selecting sheet name in another workbook by variable (same sheet name),
Craig
read odbc data,
William
Analysis between 2 worksheets,
mwilso0823
Checklist for testing code?,
M. Authement
Help with Wait X Then Go,
Ikaabod
Define range with activecell,
goss9394
Querying Excel document with OleDb,
jeff . rutland
Using Checkboxes in Excel,
spartikus
Excel slowness,
gloveman
identifying and moving matching values,
sean_f
passing argument in a function as integer problem,
ina
Macro Help to Compare Values in Two Separate WorkBooks,
RePete
Re: How do I assign point values on survey answers?,
aidan . heritage
double image buttons,
dennismhancy@xxxxxxxxx
Feedback Req'd.,
phil
Save As Problem,
mtm4300 via OfficeKB.com
Passing multiple variables through functions,
Xiazer
Selecting Different Workbook,
halem2
Re: A general newsgroup question.,
Don Guillett
Re: Insert a null value to keep format???,
Bob Phillips
improvements in telling loop to stop,
cereldine
Re: Directing the Printing using a Macro,
Bob Phillips
Re: set var to folder path using Open Dialogue box,
Bob Phillips
Re: toggle open files,
Die_Another_Day
RE: Need a Macro that will delete every odd row starting at row number,
Brandon Horne
Detecting a control in a cell?,
cmpcwil2
Re: Un Protect in Excel 2000,
Dave Peterson
Re: How to chain VBA applications,
Bob Phillips
Re: Counts more than one,
Bob Phillips
Need a Macro that will delete every odd row starting at row number 1.,
Brandon Horne
Keeping a running time total,
Jim
Slow 'FIND' when entering a value in Combobox,
bdn435
Storing variable values in Excel worksheet,
Henry Stockbridge
Re: Status of NumLock, ScrollLock and CapsLock,
Andrew Taylor
<Possible follow-ups>
Re: Status of NumLock, ScrollLock and CapsLock,
Ardus Petus
Re: Hide Paste Names,
Jan Karel Pieterse
merge pairs of columns,
mpreddy
small fuction problem pass arguments,
ina
populate data,
edwardpestian
scrolllock key off,
whizzz2004
Help with Matrix,
Les Stout
Function that makes excel work faster,
deilegium
display array in a range,
ina
Help with updating query table from internet,
Les Stout
Udf,
kontraa
Built in Data Form,
pianoman
RE: custom number formats - including text from other cells,
Nick Smith
Excel Exception handling Macro,
coder_arun
Prevent Excel from going online when opening html file,
G.Mueller
Excel hangs...,
coder_arun
SaveAsUI,
Desert Piranha
Automatically populate combo box.,
bretthotep
Find and replace again...!!!!,
reena
Excel 2003 VBA - "Maximizing" Window & "Calculating" Workbook,
JingleRock
Re: Excel formula for finding next number in a given sequence?,
doco
Create seprate files from multiple sheets in excel,
Shuvro Basu
Re: passing range from RefEdit control,
Doug Glancy
add-in procedures called from active workbook events,
doco
Row 1,
smandula
Re: how to create form fields in excel,
NickHK
mismatch error and Variants,
T_o_n_y
How to make a file so that it can't be deleted from the system?,
hikaripro@xxxxxxxxx
Screen tips,
Andrew B
Caculating Sales using If(vlookup()),
Gregc.
Re: Macro in a protected worksheet,
Ken Johnson
Open filename using workbook property,
soundneedle@xxxxxxxxxxx
Re: Problem with Do While loop,
mudraker
Setting range object--Type mismatch if template not used,
cbender
Re: Circular?,
Dave Peterson
Custom Function Returns #num error,
jyellis
Reading Data From Protected WorkBook,
rick@xxxxxxxxxxxxxx
trying to insert a formula,
davegb
Re: Is there a Macro to enable a check box based on the content of,
Tom Ogilvy
DTPicker Control: Can you programatically fire the click event?,
bob.crimmins@xxxxxxxxxx
Excel Web Services in Office 2000,
Tim
Copy/Paste Macro,
ToferKing
Problem with VBA in Excel,
jaymcgill
naming colors,
samearle
Worksheet events and a little bit extra code,
tinkerbellsmyhoe
Text Box Change Script,
earth2joy
Re: Stopping Deactivation of a Worksheet,
Doug Glancy
File Path,
STEVEB
dead chart,
Claus Haslauer
FileSearch - help,
-Zoki-
RE: Array or InStr Difficulty,
Tom Ogilvy
Why xl deletes 250+ rows using worksheet_change,
stumanchu
Msg Box on each Loop to Replace text,
Ricky Pang
hi, i am trying to copy data to closed workbook,
ritu
excel colors,
samearle
Sending automatic e-mail from Xl,
JBCIB
problem with array display,
ina
Calling user defined function from C/C++,
Ravil
Lookup Values 2 Vertical variables,
Ricardo Cruz
Re: Quick Question re For and Next,
Doug Glancy
Re: Vlookup using a cell value as search criteria,
Bob Phillips
Re: Find method Returns,
Chip Pearson
Filter function; copy values to another sheet,
Gert-Jan
Re: Macro to Specific Cells in a Range,
Bob Phillips
Referencing Spreadsheet in VBA,
Timmy Mac1
Creating an Excel Workbook in Access/VBA - CSV to XLS conversion,
ragtopcaddy
error 28: out of stack space call function,
ina
Re: Display value linked to Combo Box Selection,
MattShoreson
autofilter and worksheet protection,
dreamz
dynamic msgbox?,
anny
deleting form controls by code,
Bri
Getting multiple cell contents using a macro,
neilgrant
Newbie questions - probably simple,
Sonnich
Could use some help creating a macro....,
texasx96
Excel performance problem (Excel11.xlb file),
Alain79
Workbook Variables,
gti_jobert
Retrieve Data from Web site,
Les Stout
Comments Author?,
Dav
Runtime question in vb vs. vba,
Nick . Korynski
Reference to worksheet range in R1C1,
JohanF
Show print dialog box,
Jack Sheet
Random numbers appearing, calculations showing as zero,
ophelia
How to stop other macros while current macro runs,
Paul987
outlook vba,
funkymonkUK
Chart Numbering problem,
scantor145
acessing text files using excel vba,
srkumar
closing the active workbook,
jmoffat
copy calculation onto 300 sheets !?,
AmyTaylor
call a macro from macro,
ina
How to count items in a list and group depending on size of list?,
Simon Lloyd
Re: link a cell in the 'Master' worksheet list to a 'Detail' worksheet,
Bob Phillips
UserForm - Last Active control,
MattShoreson
probability,
plato
Re: month format,
Bob Phillips
RE: Regression results,
Jerry W. Lewis
help getting code from ron de bruins site,
funkymonkUK
Hi Need your help,
reena_san@xxxxxxxxx
VBA Training,
Essonc
object variable or with variable not set,
ina
Re: Ignore blank rows to populate custom drop down list column range,
Bob Phillips
Re: What is the CopyOrigin parameter for in the Excel VBA insert metho,
Doug Glancy
Re: How can I get a copy of Excel 97 to test my projects,
Dave Peterson
- Message not available
- Message not available
Conditional Formatting,
thetoppy
?Module code copy,
gabch
Interior Cell Colour - Conditional Formatting,
michael . a7
How to later and earlier versions of Excel to play nicely?,
plh
Re: excel vba macro Please HELP!!!,
Gary Keramidas
FormulaArray problem,
Bri
Re: Rename a Worksheet within a Macro,
Bob Phillips
Re: Highlight Duplicate Data in each Row,
Sum
Basic Excel functionality collides with VBA code.,
Peter Ostermann
Giving FOCUS to Print Preview,
JimP
Re: how to get latest input on an seperate worksheet,
Tom Ogilvy
Using macros updates on Excel Workbook,
zamit@xxxxxxxxxxx
Running a one macro on all sheets within the file,
Eron
Re: Pivot Tables-Calculations?,
Debra Dalgleish
Need to protect with Password,
f_amshan
how to manipulate text in one column,
cah jogja
Looping in a range,
Robert
Re: VB copy paste column data to another left to right sheet across sh,
broro183
Re: ERROR IN CODE,
broro183
Selection.Autofill Destination:=Range(ActiveCell.Value),
Shaka215
datediff help,
ina
Re: Automated Delete Item from ComboBox List,
Chip Pearson
Re: help to a very special split,
Gary Keramidas
- Message not available
- Message not available
- Message not available
<Possible follow-ups>
Re: help to a very special split,
RB Smissaert
Re: Instrrev function,
Don Guillett
rounding up to the 0.97,
dclx10
Monitoring cells that have data changed,
PeterW
Re: How can i plot multiple histograms on one plot?,
Mike Middleton
SQL Work in Access but not in Excel via VBA,
mjbigelow
Re: Buttons in lower portion of workbook appear in upper portion,
Tim Williams
Re: Call Issue,
Jim Cone
How to code with the R1C1 Style of Reference?,
plh
Editing color/msoGradiant of shapes, option button and text boxes,
MD
Extract the n word of a sentence in a cell,
crazy_vba
how to do that,
lwong
Re: Can the InputBox Prompt have Carriage Returns?,
Bob Phillips
Re: If I insert a row in my worksheet, I have to change the row manua,
Don Guillett
Application.DecimalSeparator,
Niek Otten
vlookup with iserror,
wensiang
Re: Would like to getback a MsgBox on error,
davesexcel
Can I use a formula that finds the smallest number that occurs twice in a column?,
JasonK
Re: Beyond 1024 cell content limit,
macropod
Re: Add Message While Program is Working,
JWM6
Re: Formatting textbox in forms control,
JWM6
Re: Incremental Counter Function in Excel,
Dave Peterson
Help...code needed to ignore null cells,
puakeni1
Eliminate blanks before a charachter chain,
MónicaM
Active X Control Wierdness...,
Trip
For Each Next loop Through Userform,
John Shikella
Help: Excel and Shell Command,
josh
Re: check mutiple files with wildcard name and tally to differnt xls f,
Tom Ogilvy
excel sum miliseconds,
Bllich
Re: Sending an email from Excel attaching the workbook they are in,
Ron de Bruin
Re: Reverting to previous values,
Tim Williams
- Message not available
- Message not available
A Simple(?) Macro Question,
DaveJones39
Protected spreadsheet, but need to add rows,
davegb
Re: Open a file do a macro ( made) and open next succesive file,
Lucas Swanson
Edit single character within a variable,
rickdogg03
Re: Data Validation - Accept Only Certain Numbers/Characters,
Doug Glancy
Re: My list is too long for my drop down box,
L. Howard Kittle
Really slow code (just this one section),
KR
Excel and Outlook Email Macros,
John Michl
Need a macro to loop evaluation of many textboxes in a UserForm.,
excelnut1954
Application.DisplayAlerts doesn't seem to work,
jason . draut
RE: Case Statement Question,
Liz Steffen
Delete multi columns,
loay
Re: Display COUNT result in Titlebar,
JE McGimpsey
copy entire row to another workbook,
Craig
if function,
bakhour
Re: CHOOSE function NOT RIGHT????,
Dick Kusleika
Having to click a Cmd button twice to get it to respond,
excelnut1954
search for worksheet, insert new if doesn't exist,
cereldine
Re: date problem,
Lucas Swanson
Referencing repeating non-consecutive rows,
caraj
Need help find automate way to cross reference two GAINT excel databases!!,
bxc2739
Re: Update links macro,
Gary Keramidas
- Message not available
- Message not available
Re: HELP TO FIND MAXIMUM VALUE,
JE McGimpsey
executing batch files using VBA,
srkumar
VBA doesn't like sharing a spreadsheet,
ortp01
Running a Word macro from Excel problem,
PaulC
Re: Worksheet Rows,
Zack Barresse
- Message not available
- Message not available
Need to Customize Workbook tabs Context Menu,
hewett_nick
Have to keep hitting the Continue Button,
lapdseth@xxxxxxxxxxxxx
Form ComboBox problem,
cmpcwil2
very urgent,
vikas
how to get month and year from date,
ina
Import,
John Sutton
Merge dissapears.. with an Excel Macro.,
GastonFranzini
Re: Click event moves user to column W,
Ikaabod
Re: Pivot Table in VB,
pianoman
Can someone help with VBA Macro? I want to compare 2 lists of data?,
certain_death
How to choose a select-list option using VBA macro ?,
tmp2100
Easy IF/Else Problem,
Paul987
Lookup solution needed,
drucey
Re: Always Sendkeys...,
Duncan
Examples of using Bloomberg API / real time data with Excel VBA?,
12Keys
Date manipulation,
Rick A
Repost - more info,
K Dales
Find cell,
Vsn
Re: Column Delete stop working,
Harsh Trivedi
Changing Module name,
Daminc
help with manipulating string and open dialog box,
funkymonkUK
Macro to clear then reinsert pivot table datafield,
Fullam
User Form... built in form is so close...!,
pianoman
Re: Changing time format to numeric,
Arvi Laanemets
How open statements effect code,
cereldine
Re: How can I automatic insert tekst from excelsheet using macro,
Ardus Petus
Help with using an activex control,
CrazyPhilll
A tricky one....Calendar year,
Duncan
using automation to create and embed an excel chart in Word,
neil
Using sumproduct or similar in VBA,
AmyTaylor
help me with this marco,
lwong
Selecting a specific cell (that is data validated),
cliodne
Re: date comparison problems,
Ardus Petus
Re: What does no response mean???? Am I asking a stupid question???,
NickHK
- Message not available
- Message not available
Re: adding help to columns,
NickHK
Re: Probably an easy question.,
Tim Williams
Re: PivotTable: string data ittem filed?,
blackpuppy
Re: Rename Userform and Insert animation,
Tom Ogilvy
web query question,
Mark
User Defined Type in place of Enum,
Steve Drenker
RE: Halt or Pause a Macro,
Tomkat743
Adding a second argument to a macro..,
My2Boyz9802
Re: Syntax - set variable to result of Vlookup,
Tom Ogilvy
How do I Initialize Form?,
TJDeborah
Deleting rows with wild card,
parteegolfer
Re: "Problem with new form??",
Tom Ogilvy
Office 2000 - Excel VBA - Help with Labels,
Kotaro
Re: Insert rows in the middle of the document???,
Tom Ogilvy
Re: Split one column into five columns,
Tim Williams
Re: How do I set up a default zip code that correspondes to a town?,
protonLeah
Re: Custom Date Picker Control,
TJDeborah
Please Help with Macro,
Carlie
Re: Close an Excel file if is found it open.,
Zack Barresse
macro security,
Nospam
Re: Small but weird problem,
Dave Peterson
Creatings a VBA Module,
Carlthomas
Help calculating time passed,
JL
Retrieving pivot items for pivot table value cells without using PivotCell,
Casey
macro in copied workbook fails,
icystorm
Re: Sub with two variables???,
Trevor Shuttleworth
Copy workbook to current folder,
DavidW
Open excel file from password protected Intranet site(IE),
Dan McCollick
Re: VBA property for Sub procedure name,
Chip Pearson
using ATPVBAEN.XLA!Random to write to a text file?,
festdaddy
Easy question: User selects cell with mouse?,
agentsmith83
Autofit of Merged cell when hit enter key,
dforgacs
Going insane with NewWindow ignore,
bigbri
Find method fails in Excel 2003 ("Subscript out of range"),
Guy Jara
References: How to removed MISSING: WORD..,
Alex St-Pierre
skipping a cell in a form in Excel,
oobe
RE: VLookUp Error Handling Needed,
Tom Ogilvy
Re: Microsoft query won't allow parameters,
kmoyer
Copy/Paste problems with Worksheet_Change,
K Dales
Cut and paste by reference,
pnascimento
PRINTING IN "VBA" (Excel) HELP :(,
And1
Re: Man in the middle,
Luke Alcatel
RE: Speed of Applications in VBA vs VB,
Mat P:son
Re: Search, Find, and Fill in Offset,
Rick Hansen
- Re: Search, Find, and Fill in Offset,
Rick Hansen
- Re: Search, Find, and Fill in Offset,
Paige
- Re: Search, Find, and Fill in Offset,
Rick Hansen
- Re: Search, Find, and Fill in Offset,
Rick Hansen
- Re: Search, Find, and Fill in Offset,
Rick Hansen
- Re: Search, Find, and Fill in Offset,
Paige
Capturing time from server Excel 2000,
GP
Macro to add Button,
Lift Off
Re: Looping through excel files to add to a new workbook,
Ron de Bruin
Reposting - Help for Merging rows,
sp123
Re: Selected Sort,
David McRitchie
Re: Move Rows,
Ikaabod
Re: update links,
Ron de Bruin
Re: set up a macro to copy/ move sheets to individual files,
Ron de Bruin
Re: copy cells and insert them into another worksheet?????,
Ron de Bruin
Formula and text in one cell?,
HotRod
Message not available
speeding up copy and paste code,
cereldine
Re: VB Sort Help,
Jim Cone
Re: Connecting to FTP,
Dick Kusleika
changing password to ****,
praveen_khm
Selecting multiple items on Listbox,
Rahul_Uk
Set up a hyperlink to open a web object in excel?,
DT
Opening and deleting File with only partial Filename,
sean_f
Spreadsheet sharing and VBA,
ortp01
3+ Dynamic Dependent dropdowns?,
KD
Re: Help with VBA code - passing references to sheets?,
Bob Phillips
RE: Need ADO Recordset Help,
Mr B
Re: Accessing a Forms Properties,
Bob Phillips
Send mail via VBA through a proxy address?,
Iwant2learn
Extract data to the right of a hyphen in a cell,
DavidW
Re: Using a dll in vba,
Chip Pearson
Conditional Formating another cell,
Darin Kramer
Re: Environment Variable Names,
Chip Pearson
Re: Removing unwanted space at end of text cell,
Don Guillett
learning to use macros,
RussellD
Runtime error when closing the sheetHi all,,
praveen_khm
Difference between Excel 2002 and 2003?,
michaellm
Re: Help please I cannot get an answer to this question,
Ivan Raiminius
Help: Menu Region has gone Black,
AMDRIT
Office 2000 - Office 2003,
EA
Any Ideas?,
Jimbo1
StatusBar Progress,
Silencer116
Regarding Excel Status Bar,
prasanta
command 'IF',
ceconik
comand 'IF",
ceconik
Macro to Delete Row based on <3,
Steve M
Detect Delete Column/Row vs Insert,
Otto Moehrbach
Re: putting count of the number of rows at the bottom,
macropod
Re: Delete cell data in a row,
macropod
Looking for a column heading and using the column position,
drucey
HELP Needed, Word mail merge breaks when saved as.. from an Excel Macro,
GastonFranzini
Re: Trouble Adding VBA Code to Module; Bug in Excel/VBE?,
Ivan Raiminius
Put a formula to a cell with macro and it doesent calculate. (Excel localisation problem?),
peterfarge
Match dates and prices,
daniroy
Compress file,
juliana . delmuro
VBA data from Closed workbook Question,
Les Stout
how to identify the control that ran a macro?,
Andy Warner
Re: Password protection,
Ivan Raiminius
Transpose > out of range error,
javamom
Re: **Link 2 sheets based on particular field**,
broro183
Textbox,
Jimbo1
how to get specific strings out of a cell ?,
crazy_vba
database form,
sameh
Re: inserting rows at bottom,
macropod
Re: sumif function on multiple sheets,
Bob Phillips
Selecting only certain characters from a cell value?,
drucey
Find and replace in excel,
reena
Automatically registering ADD-IN COM DLL - Some help required.,
rhodinar
Moving around cell by cell in VBA?,
drucey
file size too big!,
pmguerra
Get subtotal by two criteria programmatically,
sean_f
Referring to cells on other drives,
johncassell
Convert from vba to vb?,
Duncan
Re: Showing Excel within the MFC application,
NickHK
Re: Generating a numbered document,
Ivan Raiminius
Finding a word, then deleting every row above that?,
drucey
Forms ComboBox,
cmpcwil2
Loop through ".DAT" files, open run code, close next,
Les Stout
Event procedures: who is calling?,
Momo
Re: Running a macro in a predetermine range if not them msgBox,
Ivan Raiminius
Re: Performance issue,
Ivan Raiminius
average of values >0,
inquirer
inputbox help,
kckar
"Invalid Property" msg when Property Valid???,
BernieR
adding data to a chart,
inquirer
Re: allow edit ranges protection,
Tim Williams
Re: To be safe - how to check macro before run it?,
L. Howard Kittle
Excel's Spec?,
gabch
Clear Form results in INCORRECT "Invalid Property" message....,
B
enable menubar,
Shane
Can I tell my Macro to stop running for 10sec?,
Gazzr
Copy cells in another worksheet without activating,
Jon
CalculationAutomatic is changing to manual,
elrussell
RE: blank rows filling (Urgent),
Ron Coderre
Merge rows depending on the value of the first column,
sp123
Filldown Formula,
Carlie
Secure Log In,
mjack003
RE: Relative movements within macros,
Jim Thomlinson
Count contents in a column,
JWM6
Re: Saving as .pdf,
Cindy
Re: Solved it,
Tim Williams
left and right function,
slomkat
Changing the activation of a sheet that is unactive and undefined,
Andyjk1
Re: Determining User's Windows Login Name,
Gary Keramidas
Re: Merge Cells depending on another column,
sp123
Event: Workbook_SheetDelete,
Han
Reference an individual row within a Column,
afmullane
Re: Window Message for not value found,
Ron de Bruin
Re: User Form will not scroll to Match Entry First Letter?,
Ikaabod
Onclick 2 events,
Steve Jackson
Re: select toolbar button from macro,
Ron de Bruin
Macro help to rearrange excel table,
Alan
Re: Changing Directory for GetOpenFileName,
Ron de Bruin
Require a password to execute a macro,
Rjeffay
How to initialize the column width from pixels. Pixel to Char conversion,
rlaemmler@xxxxxxxxx
Re: The macros in this file do not match the digital signature.,
rlaemmler@xxxxxxxxx
Re: Defining a named range for a dynamic result set,
Dave Peterson
Re: 2 Urgent Questions,
Ikaabod
Help:Programmatically Adding Checkboxes with Captions,
josh
Top 3 Records,
HeartSA
Re: input box,
Don Guillett
Using autofilter to ADD data not delete data,
jim_0068
Joining identical items to show as one????,
cazajosa
Re: Sum a quantity once for multiple entries,
Bob Phillips
- Message not available
- Message not available
- Message not available
Re: How to know if a text is displayed on an empty cell,
Peter T
vlookup>= or <=?,
Rickyzcarroll
RE: New Collection add trim,
Tomkat743
FSo tutorial for Excel VBA,
NoNickName
school project ..please help,
sally
Re: How to create module wide 'constant'?,
Ivan Raiminius
Re: change event for multiple cells,
Ron de Bruin
very large text and CONTINUE records,
arun.darra@xxxxxxxxx
Automatically closing workbook,
zapszipszops
placing an embedded file on a sheet in a fixed position,
jeffhughes
Moving a workbook,
Daminc
RE: Autofit doesn't work when column not enough width,
sebastienm
Sum the items in a column whish match a certain value,
johncassell
Searching within VBA module,
Ian
Formula that does nothing,
andbolam
Excel VBA - help with selecting,
atlantis_sweet
Formula with excel range,
prasanta
Login to Web Page and the Search Page for Text,
rav . tohan
SST and CONTINUE records,
arun.darra@xxxxxxxxx
RE: Condensing a macro,
sebastienm
Re: Tracking changes of login & time,
Ivan Raiminius
include VBA macros as text file,
Suresh
Resize a variant array,
Jean-Pierre Bidon
Changing shading based on a row above,
matpj
ColorIndex Mystery,
blatkins
Mod(number;divisor),
Mhek
Format for Leading Zeros,
DavidW
Problem Deleting all rows from List Object,
Dean
Re: Date in YY/MM/DD format,
Bob Phillips
Re: Collection tries to open /.xls,
Dave Peterson
Excel controls vs vba controls,
cmpcwil2
save file by DDE,
asburypark98
Re: Macros running slow on Excel 2003 but not on Excel 2002,
Charles Williams
Re: Error 459 on callup of UserForm with ActiveX control,
Peter T
Storage of a serie of dates,
daniroy
Out of stack space problem,
Fred
'On change' property,
matpj
Re: Copy and paste columns,
Ivan Raiminius
Web Query using ADO(?) connection,
reloader
Re: Loop Until Clustering?,
JE McGimpsey
selecting a cell,
ashishprem
Pivot Selection,
mph999
Re: Execute a macro from command line: possible or not ?,
MattShoreson
Horizontal filter,
Wallace
getting data from all files from a folder.,
J_J
Different Styles within a single Cell,
Jérémie Gent
Re: Is it possible to disable a tab/page on a multipage Userform?,
Zurn
Opening Microsoft Outlook attachments from saved .msg files,
Rich
DataList not fill,
Fabian
Re: Deleting items as they are used from a drop down menu,
Tim Williams
How can i extract some text data.....,
Saz
Re: The case of the moving image,
Tim Williams
Re: browse for a .xls file then open in visual studio 2005 express edi,
Tim Williams
Listbox doubleclick launch,
HK
VBA Copy, Paste and Format,
Vlad999
ranking values,
bosforus
VBA EXCEL IFSTRING HELP,
Rickyzcarroll
User Form to Modify Row,
BBoner
Macro to remove,
John
Network folder list,
cdownload
Auto Update Range of a Pivot Table,
TJDeborah
Row Hiding doesn't Seems to Work,
cLiffordiL
ass Auto Quick Info to UDF,
as_sass
Microsoft Jet Error VBA Excel,
anhtuando
ActiveRange not resetting,
bmorgan02
"Invalid property" after "Clear Form",
B
Re: use a variable to name an object in a loop,
m davidson
Re: Print dialog : problem when user click printpreview,
Tom Ogilvy
Re: Conditional Discount formula,
Tom Ogilvy
Error 70,
François
RE: Find and Then Loop,
Paige
Re: Can't see cursor or selected text in textbox even though it has fo,
Tom Ogilvy
Capitalize the last character of a cell.,
oobe
RE: Open and Save CSV File,
kaiserlich
Showing length of active cell in real time,
jgoog
Need To save a spreadsheet multiple times through a macro,
mibsaweiss
Re: Switch between unknown wbk name grab a value and go back,
J . Evans . 1970
Recording numbers in a new file,
IndyStageRandy
Re: auto resizing of cells or rows,
J . Evans . 1970
Label in Excel... change caption from VB,
gonecrazybacksoon@xxxxxxxxx
Class Collection Add Items keep repeating,
Kevin Vaughn
Re: Autofilter toggle problem,
CLR
printing text in autoshapes,
RitaR
Sending tasks from Excel 2000 to Outlook 2000,
ungwaimio
column width > 255,
srinivasug
Unable to pass variable between Userforms,
PGM
Trying to Combine Workbooks,
ryan . lindner
RE: counting rows,
Tom Ogilvy
RE: How to run a macro on all sheets?,
sebastienm
this is weird,
sa02000
Reference to an Embedded Word Object,
atvaluesoftware@xxxxxxxxx
FileFormat:=xlTextPrinter saves only 240 characters of cell,
srinivasug
Re: concatenate,
Bob Phillips
Re: CAN I REPLACE NON-PRINTING CHAR(127) WITH A SYMBOL?,
Dave Peterson
baffling: method or datamember not found,
RB Smissaert
dynamic colouring of fields,
dylan
help with looping dates,
srroduin
RE: create blank rows,
sebastienm
Password option for spreadsheets,
praveen_khm
Macro compatibiltiy between XL versions,
johnhildreth
Find/replace,
rbmcc
Opening/saving a web page via VBA,
Ron
General Question on Range,
agentsmith83
Re: Problem when Excel Not Maximized,
Peter T
Re: Extract numbers from text,
Kletcho
Work on a hidden worksheet,
agentsmith83
Multipage question,
toocold
Re: Picture name is changin as worksheet is copied,
Peter T
Change excel file icon,
Daniel CHEN
Listbox with text & input row,
JWM6
Re: How to retrieve the value within the table from Access into Excel?,
Ron de Bruin
Re: Find specific text from a list of possiblities,
ivan . raiminius
Select Range found by Vlookup,
JG Scott
Need help -- a Macro that searches for string in a cell range?,
graphicGuy
Help,
tsammons
Re: How to trigger code in Excel add-in after double-click or right-cl,
ivan . raiminius
Get subtotal by two criteria,
sean_f
Append Columns to another column,
sean_f
Re: Format - Add space between number and symbol (%),
Gary Keramidas
<Possible follow-ups>
Re: Format - Add space between number and symbol (%),
Don Guillett
compile error... ADODB connection,
ina
Re: Setting the print area,
papou
Can't select range. Why the error?,
agentsmith83
Data-input pop-up box?,
tailindil
hi, i need help , i want to create a macro that take snapshots,
ritu
Select values from spreadsheet and use as strings,
sean_f
auto populate,
dmowens
Re: How do I count the instances of numbers in a list?,
gti_jobert
Please Help!!,
tsammons
Excel user access rights,
gti_jobert
Catch Error in macro,
sa02000
row (i:j).select,
ina
Problem with scroll area,
Juuljus
Re: Find/Replace text with formula,
Gary Keramidas
Re: Tickboxes and the macro's behind them,
Duncan
Help Me!!!Excel opening File Maker,
torps1988
Compare values in multiple sheets,
marcu_lucia
if statement problem,
ina
How to test if an object exist really,
Jean-Pierre Bidon
Automatically sum a filter,
macke
Re: auto filter in merged cells,
Dave Peterson
Re: Cell cropping with a Macro or VB,
Don Guillett
Help: Import text > transpose > append to new worksheet,
javamom
Re: Conditional Concatenate,
Bob Phillips
Re: disable Tool menu,
Bob Phillips
IF(OR) function with text,
yinya
Save Value after run,
scantor145
Re: disable the Tool menu in toolbar,
L Scholes
Combo box help,
L Scholes
English to VBA translator needed,
Vlad999
cell formatting,
Duncan
Re: custom menu not showing in template file,
Zurn
Solver Add-in,
HSalim[MVP]
Tick Box Macro,
Vlad999
MultiPage tab,
JWM6
Re: How do I write If then statements?,
Norman Jones
Pivot table input selection criteria,
colmansprint
Where to get "Microsoft Smart Tags 2.0 Type Libary" ?,
gimme_this_gimme_that
Re: How to run fla file using VBA,
Tim Williams
Macro CPU Utilization Issue,
bmorgan02
Re: Help. It should be simple, but it is not.,
Rick Hansen
Re: Select Case,
Dave Peterson
Embetting Vlookup in IF statement,
hooper123
Excel VBA Programming...How to Trigger an Event WhenYou Move Off a Cell,
samadams_2006
Autofill missing numbers,
TimE
Re: How can I repeat a macro?,
Don Guillett
RE: Why do command buttons shift when i am printing my files?,
Sandeep
Help!: Converting "1,253-" to "-1,253",
japorms
Moving row data to columns in a one to many,
ovrdrvn
Required Sheet and fields,
ralphdevlin via OfficeKB.com
Force condition on all Rows,
afmullane
Re: How can I repeat a macro, and how can make it without any message?,
RB Smissaert
Emailing selective sheets within a workbook.,
Gary J. Dikkema
Extracting content based on criteria and creating new workbook,
Gary J. Dikkema
Re: How do I set text alignment in code.,
Jim Cone
Find and select LastRow Minus 1,
Carlie
Re: how to reference a worksheet with a variable vs a name,
Gary Keramidas
copy any clicked cell address like A1 or B4 to the clipboard,
up2you
HTML parsing with VBA,
markoium@xxxxxxxxx
Re: Parsing the file name,
Newsgroup
Disabling BeforeSave event,
bren1519
Listbox Select items with Keyboard.,
Casey
Programming with events,
Newsgroup
RE: Lock a cell format to dollars only,
Debbie
Macro to combine cells,
c mcg
Inputbox to pull cell location,
stvgarner
math wizard needed.,
kevindmorgan
sendkey method for forms,
reachthepalace
Pulling Info From Cell To Form Label,
smithb2@xxxxxxxxxxxxxxxx
Runtime Errror 1004 No more new fonts may be applied in this workb,
Henri
Re: In VBA, make IE Browser object always in foreground,
Chip Pearson
Problem Copying book,
Rich Kniatt
How can I call a JavaScript Function from Excel VBA,
save_antartica
How to automatically clear cells upon changing/making selection?,
Ingeniero1
Excel Macro Question,
Jashbury
Combobox to select date,
atlantis_sweet
- Message not available
- Message not available
elapsed time format,
EdStevens
Ranking based on two columns,
sa02000
How many series does this code create???,
johnhildreth
Opening a list of workbooks with vba, similar to going through sheets in a workbook?,
Ron
printing macro problem,
icystorm
Bold Font,
scantor145
Re: How are excel function names in dlls/xlas resolved ?,
Chip Pearson
Re: Are Macros Safe as a solution to Excel sheet problems,
Ardus Petus
update excel files using a vba script,
adinic
Re: show XML data horizontally,
David McRitchie
Re: How do I add to the list of function categories?,
Bob Phillips
Re: Is it possible to display worksheets cells in a userform,
Ardus Petus
Re: Can you run a macro on a worksheet from a module in an XLA?,
Norman Jones
<Possible follow-ups>
Re: Can you run a macro on a worksheet from a module in an XLA?,
Bob Phillips
Creating xls file via xml getting Run-time error '1004',
ydnam
vb cancel button,
kckar
Re: If then else,
cucchiaino
Error 1004 - unable to set the hastitle property of the axis class,
Henri
Re: Pausing in Excel VBA,
Tim Williams
Mouse X-Y Coordinates,
Bob
Countif using the same cell on every sheet,
kmh987
xll worksheet function,
RB Smissaert
DropBox w/out user override through paste,
Leo
Re: Export modules from protected projects,
gg67
Re: commas missing at copy and past in excel,
Gary Keramidas
Re: How to move to 1st cell in next row after exit a particular cell.,
Norman Jones
RE: Function/Sub to change cell properties,
ExcelMonkey
Excel VBA Paste Special - replace contents of destination cells,
Sam via OfficeKB.com
Excel to Access export using VBA in Excel,
Lwangaman
Re: With End using multiple ranges,
Nick Hodge
Holiday form,
tuggers
External References to Libraries,
David Lewis
translate ws formula to vba code,
L Scholes
Re: Setup Chart name,
Tim Williams
Re: help with loops in code,,
Don Guillett
RE: Range reference problem placing charts,
Henri
How to select one of three lists for a combo box?,
Ingeniero1
Cell Event Only Affects One Column,
Who I Am
Re: make checkboxes bigger,
Tom Ogilvy
Displaying the size of the dataset currently in memory,
jle104
Resetting VBA Windows,
LoveCandle
Re: excel sheet with visual basic doesn't open,
Nick Hodge
To do list management spreadsheet,
twaccess
msgbox function,
cliodne
Re: Inhibiting cross spreadsheet custom-menu functionality.,
windsurferLA
Need Help with Inserting in SQL,
Livin
Re: Can one use Excel (or write a macro) to solve differential equatio,
windsurferLA
emailing a single worksheet from an Excel VB form?,
jsmarsha
Re: Open (website) for Input?,
Tim Williams
User form OK command automate,
reachthepalace
How can i split some symbol into many cells ?,
kee149
Re: Differentiate between 'Print' and 'Print Preview' in VBA code,
Doug Glancy
Userform shadows...,
RJH
Re: Find text String and select cell address where it is found?,
Tom Ogilvy
Re: Esc Key Closes Workbook,
Tom Ogilvy
Data Modification,
Syed Haider Ali
How to create pick list in VBA,
John
removing the file extension while listing files via foundfiles,
Jon
Re: Add-ins,
Nick Hodge
Re: save/export custom button image for toolbars,
Nick Hodge
Drag and drop Web services in Excel,
sibob
Re: hijri shamsi calendar,
Tom Ogilvy
Re: Knockout draw,
Tom Ogilvy
Using FoundFiles to list by path and filename,
Jon
variables in excel solver for vba,
suprmodl29
Web Qery Based On Form Field Input,
netbrink
Re: help with error in code,
Don Guillett
xl copy cell content to NotePad,
elrussell
Sheet names in a macro,
bern
Actual Saved FileName begins with Space,
Jim May
Re: Need to get contents of one cell to populate into other(s).,
Don Guillett
Unable to trace dependents and file shows "Calculate" all the time,
Seagal
Modify Pivot Table SourceData range,
Mike Fogleman
Re: Macro to delete row if row blank but cells do have formulas in the,
Ron de Bruin
Help with Hyperlink...Mr. Dave Peterson's Code,
ashish352
RE: Populate sheet from userform,
cityfc
Copy value from next cell in a row if cell value is NaN,
sdaetwyler
How to use SUMPRODUCT in VBA,
Madiya
Re: Allow grouping / ungrouping while protecting the sheet,
Dave Peterson
Re: find value in one sheet use this as the row to copy the value in c,
Don Guillett
<Possible follow-ups>
Re: find value in one sheet use this as the row to copy the value in c,
danetrak
Re: How can I insert a run macro command in the IF function?,
Stewart
Open Browser Maximized,
Stephen Newman
Setting varible to equal values of a # of cells,
mozart
Re: userform listbox columnheads,
Norman Jones
SheetName Function,
EXCEL NEWS
oledb connection string problem in vb.net,
Manoj Nair
Re: want to show a picture based on a value,
Norman Jones
inverting a chart,
inquirer
checkbox in runtime,
jmartinez . pincheira
Error writing value to cell - continued,
Steven M (remove wax and invalid to reply)
Re: EXCEL file corruption,
John James
"lst" file does not work,
maperalia
Lost Visual basic modules,
Slade
Re: Data mining,
ward376
Working with one Column in a Named Range,
Steve Drenker
Re: Extract data by skipping blanks into a summarized form,
Randy Harmelink
problem copying workbook,
Rich Kniatt
Re: Open a workbook with a name that was recorded in a cell,
Tim Williams
Selection a row while within a "FOR Each",
David Schrader
Some basic (pun intended) info needed on VBA please,
Bill Allen
Re: How to run XLS Macros from inside a VB script,
Andrew Taylor
CountIf by month,
ashley0578
find the total,
...Patrick
easy way to fill out a range with formulas?,
dreamz
Re: easy way to fill out a range with formulas?,
ward376
Find and Replace Macro,
gtton
Userform problem,
racudd
Skip blank cells; Run-time error 380,
jbpyron
kill old versions of workbook,
ward376
Macro taking longer every run,
Ron
Re: copy cell contents if "x" is present in cell.,
Crowbar via OfficeKB.com
Clearing a textbox in userform,
excelnut1954
iterate through a row to find a match,
suprmodl29
Referencing a different workbook.,
chris100
Reference different workbook,
chris100
How to change closed file name - Error: file not found,
PGM
Textbox Problem,
toocold
how to automatically download info from yahoo finance into excel,
Pete Moss
Pivot Tables in Macros,
Skytree01
Is there a way to have an Excel Macro fill out a IE web form repeatedly?,
ishiwata
Re: FileDialog(msoFileDialogOpen),
Ardus Petus
working with multiple ranges,
dreamz
Reading binary file,
Maxi
Help unhide sheets,
sdubose99
Message not available
Re: Hyperlink on vba form,
Steve Yandl
VBA shell command - issues...,
JWM6
Re: Macro to copy formula if cell has value,
Ardus Petus
Re: Module error?,
Norman Jones
Running code before any file is opened/saved,
Bill Schanks
RE: Code to bold names within a cell- With a twist,
macro_guy34345
Printing specific excel worksheets in VB.NET,
ecd1973
Help with Emptying a Collection,
pacer1
Re: Compare Cell,
davesexcel
Re: Pause Macro,
Norman Jones
Creating a commission function,
Bob
i need to record a macro to....,
tinkerbellsmyhoe
macro to copy/paste range for printing,
Mike Wasilewski
Macro Which Highlights Rows That Contain Identical First Cells,
luu980
Excel path problem with UDFs stored at different locations,
hege
Re: Hide/lock cells?,
Bob Phillips
Fill combobox from DLL,
JJ
Excel 2003/ Excel 97,
Don Lloyd
Name cell after worksheet Tab,
thetoppy
errorcode if somebody is trying to change ...,
Martin Bauer
Auto Execution,
Marnia
RE: Open an Excel File from Selected Cell,
Martin Fishlock
How can I detect .xls closing? Not BeforeClose , Like AfterClose?,
Zoo
RE: Trouble selecting chart in macro,
Greg Wilson
Autofilter question,
JeffMelton
use selected value from one combobox to populate another combobox,
rjudge
Creating a form with option buttons,
Jon
renaming VBA "modules",
windsurferLA
TextToColumns prompt,
ehz2101
exception to MsgBox,
L Scholes
Re: Playing a embedded wav file when excel opens,
Doug Glancy
Can i change a fill color in vba?,
Jon
VBA function to xll function,
RB Smissaert
Re: Using Find and Replace to replace " in a macro,
dok112
Please solve this VBA mystery!,
Amit Shanker
Removing last 2 digits on a number in Excel,
lermuseaux
interior.colorindex causing problems,
Ian
Add row and text between each row,
JR
Deleting HPageBreaks returns...,
darlove
Unconcatenate and Replace Text,
crystalgatewood
Trying to loop through all shapes on multiple worksheets and change color,
korrin . anderson
TYPE MISMATCH,
smithb2@xxxxxxxxxxxxxxxx
passing variables between 2 forms,
burl_rfc
Re: How check if workbook open?,
mrice
Re: Sumif or sumproduct,
daddylonglegs
Re: Run-Time Error,
mrice
date update in VBA,
L Scholes
Re: date update in VBA,
Carim
How to d/load & save web pages w/VBA?,
Ron
Re: name of checkbox that was clicked in a userform,
Dave Peterson
Another Question regarding ranges,
hansjhamm@xxxxxxxxx
Combine a range with a constant number,
hansjhamm@xxxxxxxxx
macro for parsing text,
markoium
Re: Named Range Issue,
Niek Otten
Re: Vb.net and Office 2003.,
Dave Peterson
RE: Data Validation Question,
Pops Jackson
=now(),
BannerBrat
when select cell in range checkbox value is true_but how?,
up2you
add to a dynamic list,
L Scholes
<Possible follow-ups>
add to a dynamic list,
L Scholes
- Message not available
- Message not available
add to a dynamic list,
L Scholes
How to get actual rows number in Excel using VBA?,
michaellm
Is there a break statement in VBA,
Shani
Re: IF - THEN question,
Bob Phillips
using, referencing bmp in spreadsheets,
PS
Strange values,
scantor145
Array Formulas in VBA,
Bill Martin
Re: Navigate to specific cell on specific worksheet,
joran6@xxxxxxxxxxxxx
Need VBA code to dtermine how many rows have data in them,
Shani
ChangeLink - What's wrong with the following?,
daliano71
list index problem,
burl_rfc
Defining string using InStr function help,
Iwant2learn
please help Need VBA code that searches for partial text in a cell,
Shani
UserForm_Initialize,
RB Smissaert
Center a Shape in a Cell,
Izran
Find() method help,
eXtraLogic
Moving a file using excel vba,
Greg
Font.Color - syntax error ?,
Linda Edlund
Shading cells in a row based on another cell,
matpj
Re: Private Function Code Change,
Art H
looping through controls,
cmpcwil2
Problem formatting series in VBA,
El_Pablo
Populating form with data from worksheet,
burl_rfc
Simple but I can't remember,
Andibevan
Help with Date Macro/Function,
RyanMMurphy
Re: How can I add a table from a different DB to excel Query 2002?,
DM Unseen
Re: run-time error '9': Subscript out of range - WHY??,
JE McGimpsey
Re: find and replace in vba,
Dave Peterson
How "memorize/save" sort in ExcelXP,
George
Time calculations,
cm_gmail
how to do for each worksheet in workbook exept one sheet??,
matthias
VB Macro for concatenating data...,
rivvorz
Re: Excel returns @name? error when using a custom written function in,
JE McGimpsey
Executing macro on cell change.,
Brad
Total values per colour,
Sanjay
Re: Onkey doesn't work,
Jan Karel Pieterse
- Message not available
- Message not available
Opening CSV in excel from VB,
lonfnico
Word to Excel Macro Error,
jlp1782
telling range when to stop.,
cereldine
Copy Cells to variant array,
Jean-Pierre Bidon
Calendar Control,
Nick S
Problem saving sequential numbers order book,
Blues
Re: Data Valadation Formula Needed,
Ardus Petus
Search words in array?,
Dr . Ile
Excel automation problem,
Arvi Laanemets
Looping thru Workbooks problem,
davidm
Finding matching rows on two worksheets,
Wire323
Macro to sort through data,
systemx
Copy paste VBA,
sinbad
Excel Auto Zoom Module,
thetoppy
Excel Programming,
Christopher . Top
Drag value not format?!,
OrientalPearl
Re: Starting and stopping Ontime,
mudraker
Specifying the size (in cm) of a chart ?,
Xavier
Sort in 2003 not working in 2000,
karpaydiem
Re: Trim does not work,
Zack Barresse
Clear Contants in a Range Based on a Value,
Jeff
Re: Rowsource referenced to a hidden workbook,
dok112
Re: Cant query a web page,
dok112
a question about "Application.GetSaveAsFileName",
12Keys
Re: How to change alphanumeric to numeric,
JakeyC
Refer to picture stored in workbook,
JakeyC
Re: Deleting EXACT duplicate rows,
luu980
Help, need advice,
Mikeyhend
Re: Finding criteria and removing matching rows (Range issue?),
Dave Peterson
Unattended Import to an excel spreadsheet,
dataguy
Printing from EXCEL using a macro,
jim9912
Re: How do I locate cells who have cond