microsoft.public.excel.programming
- Cannot create forms?,
cht13er
- Adding a Value from one worksheet to another.,
newguy
- Re: worksheet change,
Nigel
- VBA basic question,
kirkm
- Write 3d array to range,
westcoasthockeyleague
- VBA question,
kirkm
- Re: Randomly selecting a cell weighted on percentage,
Jim Cone
- Re: Subs,
Jim Cone
- Adding information to a Pivot Table,
Bill
- Re: Request for help with EXCEL 2003,
PY & Associates
- Problem with short-cut key combination,
Otto Moehrbach
- C# Value2 intermittent exception,
temp
- Re: leave one blank row between data in *visible* rows,
Ken Johnson
- Re: Removing VBA Password,
Gord Dibben
- Change cell color,
Patrick Simonds
- Re: Cout CF in range that = blue,
Gord Dibben
- VBA Problem Converting Numbers that are brought in as text,
Kc-Mass
- Re: Transpose to Non-adjacent Cells,
Chip Pearson
- Skip code,
Patrick Simonds
- If spelling of a word in a DV range changes, can values previously selected be updated?,
Arnold
- SendKeys,
ankur
- Message not available
- Message not available
- HOW TO TRACK DATES OF A MONTH EXCEPT SUNDAY,
Akash
- Updating value in form text box based on combo box input,
burl_h
- Org Chart: Can't add coworker object while recording macro?,
bpeasey
- Re: Pivot Table Error,
Debra Dalgleish
- Re: System Error &H80004005 (-2147467259). Unspecified error,
Chip Pearson
- Re: checking for a numeric value in a textbox,
Mike Fogleman
- Newcomers' Newsgroup Etiquette,
Zone
- Type of variables and their effect on result...,
MichDenis
- Re: Syntax to Find User's File in MultiUser App,
Chip Pearson
- Create & Name new Sheets without duplicates,
hughaskew2
- DSUM - Modifying the function...,
DKIM
- Custom Toolbar Below Other TBs,
Zone
- Re: Recognizing cell change in a Sub Worksheet_Change procedure,
Dave Peterson
- Re: Activating Workbook,
Chip Pearson
- Re: Create an Array to fill a Range,
Dave Peterson
- Re: how can I create a save file hyperlink or macro in a workbook?,
Jon Peltier
- Re: Prevent Editing of Worksheets w/in SpreadsheetML,
gimme_this_gimme_that
- Re: Pulling Part of a String,
Don Guillett
- Re: UserForms -- Subscript out of range error,
Bob Phillips
- Possible to automate conversion of text files to Excel?,
Joker76
- Posting text from VBA to spreadsheet Web Browser,
TW Bake
- Re: wrap text,
Don Guillett
- Re: Can we run Windows Script file from Excel/Office Application,
Dave Peterson
- VBA compiled - affects conditional compile?,
kevin.bourque@xxxxxxxxx
- Pls advice if there is a bug in my vbe ?,
dribler2
- Randomize tab colors when new sheets are added, and link color to formatting,
Arnold
- FAX with Excel VBA,
Otto Moehrbach
- Excel size increase through charts,
xyfix
- Problem solver call from vb6,
xyfix
- Function Int,
bcar
- RE: Showing rows containing text,
Martin Fishlock
- ActiveCell.FormulaR1C1 = "=IF(c4:c4<='Title Page'!$B$19,1,0)" ?? HELP!!!,
harteorama
- Code stops for no apparent reason,
René
- Re: Problem with ATPVBAEN.XLA,
Nick Hodge
- Controlling Hidden Rows / Columns in Filtered List,
KC VBA Qns
- Copying Cells,
Dave Unger
- Hi ...read text file and copy it in a specific cell,
Riggi
- Hi ...read test file and copy it in a cell,
Riggi
- Re: Number of links?,
NickHK
- Re: VBA coding to copy sheets into a new workbook,
Corey
- Modify code to reference from a Matching value in Combobox1,
Corey
- Re: macro help please,
Corey
- Combobox Properties (Text Wrap and Center from Top to Bottom) How?,
Corey
- Re: can i from excel create mail merge with calendar invitations ?,
Francisco Parrilla
- Re: Custom face for custom toolbar item,
Jim Cone
- Totaling (Subtotaling) a Changing Filtered Range,
Corrie
- Re: Worksheet Change Error,
Dave Peterson
- CommandButton Caption Anomily,
mickey
- SP UDF for EXCEL,
dribler2
- Non Static Variables in a For...Next Loop,
Jess
- Re: Non Static Variables in a For...Next Loop,
Jess
- Re: Non Static Variables in a For...Next Loop,
Jason Lepack
- Re: Non Static Variables in a For...Next Loop,
Jess
- Re: Non Static Variables in a For...Next Loop,
Jason Lepack
- Re: Non Static Variables in a For...Next Loop,
Jess
- Re: Non Static Variables in a For...Next Loop,
Jason Lepack
- Re: Non Static Variables in a For...Next Loop,
Jess
- Re: Non Static Variables in a For...Next Loop,
Jess
- Re: Non Static Variables in a For...Next Loop,
Jason Lepack
- Re: Non Static Variables in a For...Next Loop,
Jess
- Re: Non Static Variables in a For...Next Loop,
Jason Lepack
- Re: Non Static Variables in a For...Next Loop,
Jess
- Re: Non Static Variables in a For...Next Loop,
Jason Lepack
- Re: Non Static Variables in a For...Next Loop,
Susan
- Re: Non Static Variables in a For...Next Loop,
Jess
- combobox on userform not populating ??,
Corey
- Conditional automatic entry from a list using VBA,
Syd
- Re: exit from excel?,
jeff . j . griffith
- macro for pivot table,
J.W. Aldridge
- RE: Dynamically Insert Variable Number of Rows, Loop,
John Bundy
- Re: personal xls for UDF,
Ron de Bruin
- Re: Need some code for header/ footer, another case of "last saved,
Ron de Bruin
- Excel Chart displays incorrect X-Axis,
Andreas
- Accessing Mapquest info from Excel,
Bruce
- Re: Help Rearrange Data,
Bob Phillips
- Re: Show Milliseconds,
Jim Cone
- another SP UDF for my auditing sheet, if possible,
dribler2
- Re: Need Automation Help fast,
Jim Cone
Create an attractive "link" button,
mrlanier
Userform Suggestion,
jeff . white
- Message not available
- Message not available
Re: any more criteria condition for mySP UDF, if possible,
Bob Phillips
Re: Pivot Cache,
Debra Dalgleish
Re: more factors needed for an SP UDF,
Bob Phillips
Re: clearing a user-defined Type variable,
Chip Pearson
protect sheet question,
JG
Filling both hidden and visible cells once a filter has been applied,
Corrie
FTP via VBA,
Himansu
RE: Multiple Userforms Upon Click,
Freddy
Data table automation problem,
Will
repeat macro for added items,
J.W. Aldridge
Automatically add/show/hide rows that have (or have no) data?,
wx4usa
excel question?,
Mark J
Help: sort data and move to a new sheet,
DyverDown
It takes two clicks to shut down Excel,
Dean Meyer
Hash (#) at start of line in VBA,
kevin.bourque@xxxxxxxxx
Run macro on refresh data (pivot table),
J.W. Aldridge
Merging Spreadsheet and matching data...,
ChrisB
Re: pls help ammend progress bar code,
Bob Phillips
Move cells to another column based on value of cell,
maprime12
Importing all files in a folder to excel workbook,
kmcosta
Export sheet > store sheet > import sheet.,
Robert
Re: Look up Function,
Bob Phillips
Copying rows to another sheet when certain value equals,
jon
Re: Check Box Question,
Andrew Taylor
Change row height,
bergjes
C# COM Add-In: Form doesn't appear after closing n reoping it 3 times,
Waseem Chishti
UDF for Excel in C# paramters not coming through,
Nico
Re: Lists and Look ups,
Nigel
Formatting numerals and text numbers between Arabic and Hindi (indic) languages,
steveblack2006
Unexpected CommandButton Caption Display on Exit,
mickey
RE: Pass the variable into the sub function,
Martin Fishlock
How to check drive exist or not using FileSystemObject,
moonhk
Re: moving between windows,
horkuang
Re: e-Mail File out of Excel 2003 Macro,
Tim Lindsley
Combobox List to list Numerical Values ONLY in Column A is specific Sheet....,
Corey
"LegalWorkSheetName" Function?,
(PeteCresswell)
Help with a Dynamic range,
thesquirrel@xxxxxxxxx
Re: Cancel 'Password' prompt during VBA,
Dave Peterson
Formatting Text to Italic AND Underlined to individually listed cells,
Corey
print PDF file from Excel - NOT print Excel to PDF?,
Alan Ibbotson
Help writing macro for a lookup table,
rama . kol
Excel solver in vb6.3,
xyfix
Re: Highlight Cell,
Gord Dibben
Using VB Code to update one workbook with data from 4 diffferent workbooks.,
banderson
Code Execution Has Been Interrupted Error,
Sprinks
A macro that will show a cell's contents but not allow it to print,
mrlanier
Re: A macro that will show a cell's contents but not allow it to print,
horkuang
Re: Combining Files,
Ron de Bruin
Find Replace List of Items,
rrstudio2@xxxxxxxxxxx
Simultaneous rst.AddNew and rst.Delete from 2 Workbooks,
Trip
Re: Activate WorkBook,
Jason Lepack
Macro Only works Once,
kerry_ja@xxxxxxxxx
Centering a worksheet for viewing,
mrlanier
Re: help for myWORKDAY UDF,
Bob Phillips
non disruptable run time condition,
KC VBA Qns
Re: Rank Code,
Bob Phillips
Changing pivot chart format,
J.W. Aldridge
Re: custom commandbarPopup control - how to return its identifer?,
Jim Rech
Re: Delete workbook..?,
Susan
Macro to delete first and last row,
patrick . connally
Re: any UDF for sum or rounded product,
Bob Phillips
- Message not available
- Re: any UDF for sum or rounded product,
Bob Phillips
- Re: any UDF for sum or rounded product,
dribler2
- Re: any UDF for sum or rounded product,
Don Guillett
- Re: any UDF for sum or rounded product,
dribler2
- Re: any UDF for sum or rounded product,
Bob Phillips
- Re: any UDF for sum or rounded product,
dribler2
- Re: any UDF for sum or rounded product,
Bob Phillips
- Re: any UDF for sum or rounded product,
dribler2
- Re: any UDF for sum or rounded product,
Bob Phillips
- Re: any UDF for sum or rounded product,
dribler2
- Re: any UDF for sum or rounded product,
bplumhoff@xxxxxxxxx
- Re: any UDF for sum or rounded product,
Bob Phillips
- Re: any UDF for sum or rounded product,
dribler2
- <Possible follow-ups>
- RE: any UDF for sum or rounded product,
dribler2
Based on a condition in one column, search for a year in another column, and display data from another column in the same row >> look,
MPSingley
RE: duplicating a page while adding a progressive date,
FlaPrinter
Passing excel cell values as sql variables,
jai
Need help with adding Controls and event handlers at runtime,
martin . zackrisson
Re: Automatic Dates,
Don Guillett
complex time formula,
nsstick
Problem with too large a range,
fullers
Help with a simple Excel macro,
Dan R.
Counting recurring cells,
Peter
Re: Option Button forces user to input into a Textbox,
John Bundy
Problem Importing CSV Files,
John V
Re: Hide all windows while macro is running,
Gary Keramidas
Re: Macro to save data in one cell and add new data in cell below etc,
John Bundy
Re: providing serial numbers with cells hidden,
Zone
Display value in same row of most recent date in a different column,
MPSingley
Create a command button in Excel using C#,
Senthil
Formula in text formatted cell,
dworst
Re: Save into different "user's" folder,
Bob Phillips
Re: display alert when workbook open,
Bob Phillips
SaveCopyAs generating the 0x800a03ec exception,
PromisedOyster
Creating backup of a data file,
chedd via OfficeKB.com
Loadpicture - check if file exists,
t0ny
how to trap cell cut and paste,
parm kalkal
RE: Open Read Only,
"Peter Huang" [MSFT]
Re: Use of Calendar in both a form and excel sheet,
NickHK
Protection to add a line to Remove "Select Locked Cells" ???,
Corey
Userform Canellation.,
Corey
Re: Macro to open the Subtotal function,
gimme_this_gimme_that
bug in excel range naming?,
Michal AKA Miki
How to Add 21 Textbox values to give the Sum ?,
Corey
Re: how to use .xla -- addin file -- Office 2003?,
gimme_this_gimme_that
Cannot jump to 'VBProject because it is in the library 'VBIDE' which is not currently referenced,
gimme_this_gimme_that
How to tab to next from a texbox,
Corey
help with a special timer,
Vladi
RE: How do I add sound alerts to Excel spreadsheets?,
Marvin
userform Max value in Column A,
Corey
are these 2 statements equivalent?,
Gary Keramidas
One problem,
Sopranos
How to check if a cell is blank and, if so, apply a formula,
Arnold
Center Comment Over Selected Cell,
inthepickle
Re: Can any controls name concatenated?,
Dave Peterson
Opening workbook in its own program,
timduongt
Selecting a Record and copying it to another Workbook,
Dooley007
Help!,
teresa
- Message not available
- <Possible follow-ups>
- Help!,
teresa
Re: Problems With PRN File,
Dave Peterson
Listbox value help needed,
jeff . white
SAVE AS... WITHOUT COPYING THISWORKBOOK MACRO´S,
cbm
Removing columns and rows from an imported worksheet,
rjr
Re: sayfa koruması şifre soruyor ben şifreyi bilmiyorum,
Susan
RE: Mutipage,
Richard
RE: Using Checkboxes,
Freddy
Excel and Barcodefont distribution,
Mario
Query text too long,
steveh
Resetting an object counter,
kreutz
pivot cash,
Erik Creyghton
Copy rows to new sheet based on variable cell reference,
michaelberrier
Re: is this possible, replacing password protected sheet text with mac,
Mike Fogleman
Re: Hidden macro,
Bob Phillips
Re: UDF function on Matrix,
Bob Phillips
Create a 5 second message box that shows text in a cell,
mrlanier
running a macro on another worksheet,
BRC
Zoom Window Selection Possible?,
None
Re: User Forms availabilty to all workbooks,
Mark Ivey
Re: Creating the name of a worksheet in a cell,
Don Guillett
macro doesn't work on Excel for the mac but works on Windows XL??,
Dave F
Programming a worksheet to find last row and add formula's,
rjr
How do I call a dynamically created String in a VBA Sub,
izimmer
- Message not available
- Message not available
How to store variables of a single cell in a column?,
noyau
Render the contents of a cell invisible,
mrlanier
Passing a function as a parameter,
Scott
Re: Odd copy and paste question,
Nick Hodge
Re: data from password protected files,
Tom Ogilvy
Excel Window,
Homer
using range, and/or offset to complete table.,
BRC
Create a date that will not change,
mrlanier
Re: Run Macro from cell change THEN select adjacent cell,
John Coleman
Spacebar Exits Macro,
Zone
Re: Preventing Range Name changes,
Chip Pearson
Distorted Fonts on Controls,
cwrm4
Placin Data In Next Avaialble Cell,
Michael Koerner
Re: Combobox and Textbox settings,
Chip Pearson
Re: Getting info from FIND/REPLACE,
RichardSchollar
Re: Force Path for File Saving,
Nick Hodge
Re: Ex Rate,
Stephen Rasey
Hashing function CryptAcquireContext Lib "advapi32" not working in new computer.,
Stephen Rasey
Comment Positions,
Mangus Pyke
Re: Test Initialization of an Array,
Jim Cone
read data in an excel file on a remote sever,
m7han . milan
Going nuts on this one...,
AD108
Re: Application.InputBox,
Dave Peterson
Re: Running code before saving workbook,
Jim Rech
Parsing Strings in Excel,
Michael
Re: Sub that cannot be executed from Excel,
Tom Ogilvy
Re: userform to appear in the center of the screen,
JMay
inserting a formula next to populated cells,
BRC
Re: Excel concatenate duplicate rows,
Don Guillett
Updating a sum,
newguy
How can I execute a macro right after the user clicks the validation drop down?,
Michael
Assign borders and colors with a condition,
mrlanier
VBA code for outline border,
Otto Moehrbach
VBA to -0- an amount during a Copy/Paste of a range of cells,
Dennis
Loop through Row Range, Excel 2000, 2003,
jfcby
- Re: Loop through Row Range, Excel 2000, 2003,
Don Guillett
- Message not available
- Re: Loop through Row Range, Excel 2000, 2003,
Don Guillett
- Re: Loop through Row Range, Excel 2000, 2003,
Dave Peterson
- Re: Loop through Row Range, Excel 2000, 2003,
jfcby
- Re: Loop through Row Range, Excel 2000, 2003,
Don Guillett
- Re: Loop through Row Range, Excel 2000, 2003,
Dave Peterson
- Re: Loop through Row Range, Excel 2000, 2003,
jfcby
- Re: Loop through Row Range, Excel 2000, 2003,
Tom Ogilvy
- Re: Loop through Row Range, Excel 2000, 2003,
jfcby
- Re: Loop through Row Range, Excel 2000, 2003,
Tom Ogilvy
- Re: Loop through Row Range, Excel 2000, 2003,
jfcby
- Re: Loop through Row Range, Excel 2000, 2003,
jfcby
- Re: Loop through Row Range, Excel 2000, 2003,
jfcby
- Re: Loop through Row Range, Excel 2000, 2003,
Tom Ogilvy
- Message not available
- Re: Loop through Row Range, Excel 2000, 2003,
Don Guillett
Finding Cell Address from Listbox,
Eubanks
Downloading Multiple Pages of Get External Data from Yahoo,
Frank Hayes
Wait Seconds and Tenths,
Zone
Re: Find last row with value,
Dave Peterson
Re: define a range knowing the corners?,
Bob Phillips
Complex--don't even know how to word the subject for this,
Arnold
- Re: Complex--don't even know how to word the subject for this,
Mike Fogleman
- Re: Complex--don't even know how to word the subject for this,
Mike Fogleman
- Re: Complex--don't even know how to word the subject for this,
Arnold
- Re: Complex--don't even know how to word the subject for this,
Arnold
- Re: Complex--don't even know how to word the subject for this,
Jason Lepack
- Re: Complex--don't even know how to word the subject for this,
Arnold
- Re: Complex--don't even know how to word the subject for this,
Mike Fogleman
- Re: Complex--don't even know how to word the subject for this,
Arnold
- Re: Complex--don't even know how to word the subject for this,
Tom Ogilvy
- Re: Complex--don't even know how to word the subject for this,
Arnold
- Re: Complex--don't even know how to word the subject for this,
Tom Ogilvy
- Re: Complex--don't even know how to word the subject for this,
Arnold
Re: Writing macros to sequentially change the address of a cell in Exc,
Ken Johnson
To go to a particular Sheet,
Akash
CryptAcquireContext Lib "advapi32",
Stephen Rasey
Find Common names in multi ranges,
JG
Hours Minutes and Seconds,
Michael Koerner
this code makes excel crash,
zz
Re: Easy (for you) question,
John Coleman
Re: Rounding a Rounded Number,
Zack Barresse
Re: Rounding a Rounded Number,
Gary Keramidas
How to use an array ?,
Amit
Run Macro in another workbook already OPENED in another instance of Excel,
benjamin . d . rogers
Re: Formula to count distinct values not working in VBA,
Don Guillett
Excel Object Model Diagram?,
(PeteCresswell)
Yet More Question about Newsreader,
Zone
Re: Delete Duplicate rows,
KC Rippstein
Selecting Drawing Object By Name,
Zone
Re: Function Question,
Tim Williams
save workbook but doesn't really save,
mlafarlett
Clear all borders with VBA,
Otto Moehrbach
Copy/Paste Range,
mastermind
cusotm formats,
Dean
Quick Question: Buttons,
Mazin
Control Toolbox Checkbox Macro - Help Please!,
Tealina . Mairs
Find First Row where "value" = "",
tig
Excel: Compare Two Worksheets,
Myrna Rodriguez
Set Focus Not working on a form,
starke1120
Re: What could be wrong?,
Don Guillett
RE: VB function,
Alok
Re: God's New Year present.,
A Mad Doberman
Select Cell on Same Row as Checkbox,
Tealina . Mairs
variant/error Error 2023,
bz
Re: error handling - dodgy syntax,
james . billy
Re: Claiming Dependents,
james . billy
Loop through a range, allow user input during...,
AD108
Re: Continuous Loop,
John Coleman
Looping Error,
Tealina . Mairs
Unchecking all Forms checkboxes in entire sheet,
michaelberrier
Make 2 Macros Work as 1,
Hazel
please help me,
anant . javali
Re: next cell,
John Coleman
Re: Active Conditions,
Bob Phillips
Re: Excel 2007 Problems; in writing macro and convert text to colums,
Bob Phillips
Petty Cash book,
Akash
Retrieve a the date created date of an Access Table in Excel using VBA,
neil . smith
closing dummy file,
ricowyder
Offset function,
Dean
Trying to improve the performance of my code,
Carlo
modeless userform problem,
AD108
Basic Syntax,
Nick_F
Re: Multiple responses from a look up table,
bplumhoff@xxxxxxxxx
Count the times a file is opened,
mrlanier
Re: Reference cell in previous worksheet to then add +1 for serial,
NickHK
How to pass text to web page ?,
moonhk
Re: UseFunction question,
Tom Ogilvy
More Concise Way To Assign Borders?,
(PeteCresswell)
Error Checking Code, Excel 2000 & 2003,
jfcby
Don't Copy If Null --> Help,
Ardy
Userform. How to Have TextBox Selected & Return/Enter Key to be same as OK Button ???,
Corey
Setting the text in a cell to the text of a cell on a different sheet in the same workbook,
Max C
Pivot SubTotals - Request help,
kansaskannan
Re: Named Range Macro Formula,
Gary Keramidas
Re: How Do I Password Hide a Sheet,
Gert-Jan
Sorting a range on another worksheet without selecting the worksheet,
Scott . Prestridge
Check if a optionbutton is selected,
Gert-Jan
Re: Create list of worksheets and cell values,
Ken
Auto Log Into Site, etc......,
J.W. Aldridge
(VBA Function ?) Lookup value and copy it into antoher worksheet,
beety007
Comparing two worksheets,
Chaitanya . Kalapala
Can't select image on a worksheet that was inserted by c#???,
Michael Howes
Wanted: Syntax for Filename changed without impacting Macro,
bluegrassstateworker
Re: Can't add macros to buttons I've created....,
bluegrassstateworker
Re: Why are some dates changing and not others?,
RichardSchollar
Re: copy and paste to multiple cell,
RichardSchollar
Re: If / Else Code (hiding rows based on cell value),
Don Guillett
Hide Columns based on network username,
Chris
How do you create an Array of Arrays?,
BFike
RE: Adding Images,
Dan Kelly
AURO SUMMING FROM TABLE AND COPYING TO NEW WORKSHEET,
tracks via OfficeKB.com
One subroutine to run another,
MARK
Needs help converting some pseudo code into VB code,
williameis
interupting excel infintie loops to detect shortcut key presses,
tom lorenz
Counting Groups,
rrstudio2@xxxxxxxxxxx
Delete Rows,
Douglas Goodman
Re: returning the first name on the list assigned to a particular rang,
Jim Rech
Re: Fill FromDate to ToDate,
RichardSchollar
Re: program tab button,
Don Guillett
Re: Use string as cell location, need help,
RichardSchollar
#1 How to best learn VBA? #2 Division problem question,
Hrundi V. Bakshi
Save as space delimited file from VBA,
Nash
Re: TextBox Values to Outlook,
paul . robinson
Chart series delete all then add new,
keri
Re: Cell References and Ranges,
JMay
English German CSV issue,
davidbruce17
Re: Add button to worksheet cell,
Waseem Chishti
Re: sum with multi criteria,
Bob Phillips
- Message not available
- Message not available
How to using VBA to send/get data in logined web page ?,
moonhk
worksheet_calculation problem,
Nasim
Re: Selecting Values in Worksheet,
Trever B
How to block all macro when a particular file is open,
Dileep Chandran
Excel macro to calc payment/payoff of credit card,
exsfcp - Steve
Re: display worksheet on form,
Jim Cone
Open Outlook from a macro,
Corey
Re: multiple criteria statement,
Tim Williams
Flexibility assign Cell value,
moonhk
Replicate PMT calculation,
grahamhow424
Re: Linked cell location in VBA,
Jim Cone
Text in TextBox to Program,
Gordon
Re: Find next Date,
Don Guillett
Chart not working,
keri
How to delete a question mark throughout database,
TJ
Delete part of cell contents,
nxqviet
Re: How to extract a value from Excel and include it in a query,
Nick Hodge
Re: Multi Column Listbox Help,
Ken
Delete Row Macro,
Douglas Goodman
Test,
Zone
help with chart,
A Whelan
Help with automating data style change,
shhhhh
How to keep macros attached when moving sheet to a new workbook,
amanda . graor
RE: Find and Replace Macro,
Josh O.
copy values in rows to columns,
Carpe Diem
Dynamically generating a spreadsheet with custom pivot table including data,
pnschofield
Newsgroup Reader Advice,
Zone
Figuring out if a day is a legal holiday,
Bruce
Sort 4 of columns by matching cells,
mazin . j
"find" finesse needed,
Susan
Worksheet change event with cell linked to combo box result,
Fid
RE: Copy/Paste Formula Issue in Macro,
Jim
DSO Summary Properties Error,
John Michl
XL 2003: Problem running Solver from VBA,
Robert Valentine
Re: Colour Cells onSheet,
Zone
Re: Input Box,
Dave Peterson
Re: Row Height,
PaulD
Emailing range in Outlook- so close! just need a little help,
Keith
Re: Filter Macro,
PaulD
Desperate for help with these formats,
keri
Re: Variable Range for Sum Formula,
Dave Peterson
Re: Save Workbook as another file without an fomulas inside,
Ron de Bruin
variable sheet names not working,
Susan
Re-setting HPageBreak,
Mike Fogleman
Removing all data from two columns,
Michael Koerner
Help with If,then statement Returning Value (or Select Case),
MrsForeman
- Message not available
- Message not available
Speed this up for me, please,
Adrian D. Bailey
Data Split and sort problem,
joecrabtree
Force macro to wait with next step,
Gert-Jan
File Size Problem,
AD108
Cocatenating two variables with a space in between,
Deecrypt
Date Format Macro Problem,
joecrabtree
VBA & Conditional Formatting >3 conditions,
diane . carney
Time formats,
keri
Delimiter for csv and text file using ADO,
Jean-Yves
How to disable column autosizing in Excel 2007,
Nick Hebb
Re: Worksheetfunction Substitute,
Bob Phillips
fourty different spreadsheets with the same macros,
daniroy
- Message not available
- Message not available
Excel saving as textfile quotes issue,
christophe . leroquais
slow code,
Newbie
PLEASE help - Fast approaching deadline,
Jackie
RE: PLEASE help - Fast approaching deadline,
Jackie
RE: PLEASE help Bernie are you still available?,
Jackie
Remove All Macros,
Steve
Registry Location for References in VBe,
Mike McNeill
change code,
keri
Big Problem using VLOOKUP formula,
jessie
Help with looping macro / goto,
keri
Listbox In VBA Growing,
harrycunningham
- <Possible follow-ups>
- Listbox In VBA Growing,
harrycunningham
- Message not available
- Message not available
- Message not available
Problem with Range reference - Odd error,
Kc-Mass
How to use drop down lists in Worksheets using VBA,
Deecrypt
Add a button to each row of a spreadsheet,
nacooke
Combobox Properties Textcolumn,
dd
Concatenate anyone?,
dd
Disable menu item when a particular excel file is opened,
Dileep Chandran
How to debug class ?,
moonhk
Macro to delete specific rows,
Gert-Jan
- Message not available
- Message not available
Excel VBA run twice?,
Tony WONG
Corrupted Excel File,
AD108
Re: How to solve 70-point gas network problems using solver tool?,
NickHK
Re: Maximum Controls on UserForms,
Spreadsheet Solutions
Re: how do i use UserForm1.Show vbModeless command?,
NickHK
Re: User-Defined Type,
NickHK
rows for visible cells,
mf_digger
Last Row in Disjoint Range,
Scott
Data Sort Macro for specific cells,
slundrigan via OfficeKB.com
How can I insert excel sheet in to powerpoint slides with autupdate option?,
Shyaam
Re: show modal,
NickHK
Re: adding code from a template,
NickHK
Saving txt file from excel by specifying path - drop down directory explorer,
Riggi
Re: change permission on a folder like cacls command,
NickHK
Re: Two excel version conflict?,
NickHK
- Message not available
- Message not available
Re: CreateDocumentFromUrl,
NickHK
RE: Automating copy-pasting of data values into a new spreadsheet layo,
Martin Fishlock
select case statement?,
CR
Creating Chart Dynamically (It is Driving Me Nuts),
Ardy
Re: Setting Cell Values from VBA,
Jon Peltier
how do I prompt the user to select a cell?,
cathellisuk
Paste validation, Copy, Paste Special Validation,
Scott
Re: msoFileDialogSaveAs,
Jim Rech
Macro that sums cells in rows of varible number and....,
blazzzercat
Excel Re-Starts after shut-down,
SteveP
Help file problem,
Ian
Re: If statements,
John Green
Copy thru VBA,
Anna
Macro that deletes the last character in a cell,
TJ
List of values / unique problem,
Gert-Jan
PIA interop Excel - VB.net accessing Cell,
Chris Le Roquais
Re: Row Number with Text,
Otto Moehrbach
Re: Name of button,
Dave Peterson
Error message if duplicate data entered,
RealmSteel
Button do not appear on Sheet !,
Amit
RE: I'm in serious Excel Data Base trouble,
Alok
Sorting Help,
Anna
Intermittent Error - Method 'Add' of object 'HPageBreaks' failed,
Jamey Weare
Re: Pivot Table Question,
Dave Peterson
SQL Query Function,
Stevek
Format of amount in label,
Gert-Jan
Copy Total to the following row in Column A,
dd
Values in Columns to convert in rows,
Carpe Diem
For Next Loop Chart Titles,
Jackie
Excel with game is stuck in a loop,
jamesdouglasstrang
Re: Find the closest value,
Don Guillett
Running Two Macros as One,
cheeser83
RE: Rapidly exporting Excel data to text file,
mikejhelms
Find First empty cell at end of Column A,
DG
Error Trap Via Message,
Ardy
Re: I'm dying over here...excel,
Don Guillett
Pivot Table Question: SubTotals for 2 of 4 Pivot Tables in same worksheet,
kansaskannan
Re: Dynamic Chart Building - "Unable to set the ... property of the Se,
Jon Peltier
How to intersect two coloumns in a third coloumns,
jessie
Tracking Changes to Cells?,
john
How do I bring up the select cells dialog ?,
dd
Changing file name,
Mervyn Thomas
Replace VBA Reference for Type Library,
Mike McNeill
Re: Call a VBA module from Microsoft Access,
Nick Hodge
Re: Showing the Address Book window,
Karim Benabd
Re: Question about RANGE (easy one, or at least it should be),
Gary Keramidas
Copy data from one file sheet into another,
Anna
Re: get actual date from variable text string,
Jon Peltier
Locale issue,
Why Tea
Re: Never-ending For Next Loop,
Don Guillett
Switching from Jan-1 yields 1/1/2006, should be 2007,
Jason Lepack
Help in syntax,
Anna
For Each array - TextBoxes in a UserForm,
excelnut1954
Hide Sheets,
Anna
delimiter,
hughie
Query,
Abdul
Question about a formula,
jln via OfficeKB.com
Series XValues, determine if labels or values,
Peter T
RE: Can't find project or library,
Alok
arrays from Excel VBA,
MJH
Run-Time Chart Only Displays Even DataLabels,
Rawce
Using VBA to open an excel file,
nickharthan
RE: Multiple print title rows,
ChrisO
Re: Copy - Paste Special (Values),
ankur
Re: unique range,
Bob Phillips
- Message not available
- Message not available
Delete sheets - all except 3,
joecrabtree
Re: User Forms,
Simon Lloyd
Detecting the workbook name on startup,
bigmart
Re: Check File name for its existance in a folder,
Gary Keramidas
Conditional Format,
Patrick Simonds
Re: Calculate number of records in a Group,
Greg Glynn
how to disable chart tab in Excel?,
Amit
Referencing a Column with a Variable name,
newguy
Editing in formula,
Anna
Lookup Sheet,
Anna
using data validation list for dropdowns,
Dean
RE: Macro to Pull Data from Seperate Workbooks,
Dave
Re: drop down cell link to worksheet not working,
Nick Hodge
Re: printing an external document,
Nick Hodge
selecting multiple ActiveCell items (possibly loop problem),
jono_dude
Continuing problem populating userform from a previous record,
Dooley007
Re: help with code,
Ivyleaf
Compare cells and concatenate on match,
vs88
Autofilter / CF,
rumkus
Re: The undo button is greyed out due to this formula,
Nick Hodge
Re: ActiveCell.FormulaR1C1 referencing a moving target.,
Bob Phillips
Lookup on a sheet so that every time when file open it copes data from another file sheet,
Anna
need macro to call a workbook w/o the actual name of the workbook,
crimsonkng
Re: Sheet referencing in a macro,
Nick Hodge
Re: removing programs,
Nick Hodge
Re: Excel 2007: Macros disabled when workbook is protected (why?),
Jim Rech
Conditional formatting of a range of cells?,
stephen
VBA Copy Info from Excel Sheet Displayed in IE,
White Horse
RE: worksheet to worksheet . . .,
Nigel
A Substitute for Vlookup,
amirstal
Move Total from Column B to A,
dd
Concatenate Variables,
hmiller@xxxxxxxxxxxx
- Message not available
- Message not available
Help! Selecting a Worksheet with VBA,
yonathan . sabbah
Automatic Exchange Rates,
Why Tea
Excel graph (newbie),
Amit
Location of mscal.ocx,
M. Authement
Pivot Table: Optional Page Field,
kansaskannan
Web Query a changing URL,
AKTransplant
Reference Table,
amirstal
RE: MS-DOS commands from within Visual Basic Version 6.3,
Freddy
VBA to Save Web Pages,
Ron
COMBOBOXES,
Zigball
Store TextBox entry into Variable,
Gordon
Interpolation Problem,
amirstal
Re: Converting currency to text "One & 00/100 Dollars",
Paul B
Code Locks Up Worksheet Briefly,
Paige
Using Vlookup worksheet function in VBA,
marcbruun
Unique Data ID tags help (average),
joecrabtree
Detecting Broken links,
DMc2005
Really Interesting,
rellyinte
Re: calling subs,
Bob Phillips
Coding if formuals,
jln via OfficeKB.com
Help with Arrays - making a total formula,
drolfe
Basic VBA Question,
amirstal
<Possible follow-ups>
Basic VBA Question,
amirstal
Re: rounding to nearest 1000,
Bernard Liengme
Delete Sheets Problem,
joecrabtree
Delete Cell Contents IF,
joecrabtree
How to make Excel the active application,
Stefan Mueller
Re: How to check Excel worksheet contents before routing?,
Jim Cone
Copy specific data over to other worksheet,
dd
WORKDAY #NAME? Problem - tried the toolpack already,
yumex85
Charts and EMF,
NickP
Save as problem,
joecrabtree
Operators/if etc,
Peter
Combobox Dropdown method,
james . billy
Re: Can I create a userform in Excel to create an appointment in Outlo,
paul . robinson
Re: Password on VBA Code,
paul . robinson
Date format Problem Macro,
joecrabtree
Unique,
ankur
Last digit automatically changes to zero (0),
mghops
About function BAHTTEX,
Akash
runout - plant production scheduling tank inventory,
deano
Re: on error don't resume next?,
NickHK
Big sort problem,
Patrick Simonds
A1 reference style,
T. Valko
Difficult find and move,
howardgrigg
Re: set up a flashing background,
John Coleman
Re: Password,
Tom Ogilvy
Re: Where can I find Microsoft.Office.Interop.Excel.dll?,
Trevor Shuttleworth
Linking Excel-areas to word-documents,
Eirik Sævareid
Re: paste excel text into a comment box,
cathellisuk
Nested Loop,
JMay
Combine 2 codes from WorkSheet_Change & WorkSheet _SelectionChange to ONLY WorkSheet_Change,
Corey
Re: Can I use standard Functions with MS Query?,
Tom Ogilvy
Re: Chart macro okay but sometimes ends by moving to a new location?,
Jon Peltier
Selecting multiple ranges,
RWN
If A1=H Then B1=1, Excel 2000 & 2003,
jfcby
Sheet selection,
Patrick Simonds
Rename Sheet Goofyness,
Scoobywan
While/Do Loop problem,
MicrosoftNews
Creating a worksheet for every weekday,
hungledink
Breaking up long line of code doesn't work,
Hector Fernandez
Getting and setting all printer driver features supported using VBA,
steveblack2006
Class module and a lot of records,
--== Alain ==--
How to list objects defined - buttons, etc.?,
G Lykos
Create Add-in,
Fredrik E . Nilsen
Connect Pivot Table to WSDL web service source?,
Doug N
RE: Code ignoring filtered (visible) tasks.,
Finius Eetch
Re: Fill Colour,
John Coleman
collection and limit,
--== Alain ==--
Re: Return filtered tasks,
Ron de Bruin
Re: Code for auto league tables!,
Ken Johnson
XP control look ?,
--== Alain ==--
Problem with filtering,
Tim Walters
Trigger a Macro,
Patrick Simonds
Re: Monthly Report,
Jef Gorbach
Re: send range results to a certian cell,
Jef Gorbach
Re: Loop vertically, copying and pasting inputs for each cell in Col A,
Jef Gorbach
How to Use Relative Reference in Array Formula,
huamingjian
How not to show zero in textboxes?,
John Smith
Re: Code to instruct "Insert new disk",
JakeyC
Code question,
kirkm
Re: SendKeys "(^ {HOME})",
Dave Peterson
Change Event not firing,
L. Howard Kittle
Inserting 3 new rows after the word total,
dd
auto-open macro lost within workbook,
windsurferLA
Problem accessing an Excel file from ADO,
Michel S .
Extracting part of the data from a single Excel cell,
nigelbarham
Help with variables,
keri
How to select a single "column" of a VBA array?,
pinkfloydfan
Re: Is it possible to exit Excel completely from a macro?,
WATYF1
Holding Shift to bypass Auto_Open doesn't work in Excel 2007...,
WATYF1
RE: insert 2 rows & insert data into cell,
Tom Ogilvy
Re: How do I print batch run to pdf files?,
gimme_this_gimme_that
Opening another instance of Excel,
thesquirrel@xxxxxxxxx
Does Office 2007 have VBA?,
gimme_this_gimme_that
- Message not available
- Message not available
Substitute for Vlookup,
amirstal
Sort Column, Excel 2000 & 2003,
jfcby
Dimmed Keyword as Variable,
Zone
Re: Delete all Shapes from selected Range,
Chip Pearson
select based on 2 columns?,
Kent McPherson
Pivot Table: Totals for "Last 12 months" and "Preceding 12 months",
kansaskannan
Re: Problems with Application.FileSearch,
Jim Rech
Re: Chart Labeler Macro,
Jon Peltier
Letter alternative to 1 - 26,
keri
Autofilters and Userforms,
jeff . white
Moving rows with out removing from range,
None
Using filename hyperlinks in Macros,
Marlene . Sawhney
Re: Macro Problem,
Don Guillett
Adding spaces into a variable,
Peter
Concatenate Text in Visual Basic,
daniroy
Re: Create Function using Excel VBA,
Dave Peterson
Macro to find odd due dates and move them,
jln via OfficeKB.com
Re: Find Blank Line,
Dave Peterson
Re: Creating and using add-ins,
Dave Peterson
Re: Call user defined function in an add-in,
Dave Peterson
Macro to go to last cell in a column,
excelnut1954
Re: OleObject really embedded in cell - not as shape overlay,
Jon Peltier
Check if Date within this week/last week,
Duncan
SQL database,
Pink Panther
Excel 03 Macro/Code,
ddw_23
Re: Troble with Code,
Bob Phillips
Alternative to integer?,
keri
VBA Syntax to :select" or activate a module in Project Explorer,
Dennis
Range Definition,
daniroy
How can I get the row number Based on cell value,
Kc-Mass
- Re: How can I get the row number Based on cell value,
ankur
- Re: How can I get the row number Based on cell value,
ankur
- Re: How can I get the row number Based on cell value,
ankur
- Re: How can I get the row number Based on cell value,
ankur
- Re: How can I get the row number Based on cell value,
ankur
- Re: How can I get the row number Based on cell value,
ankur
- Re: How can I get the row number Based on cell value,
ankur
- Re: How can I get the row number Based on cell value,
ankur
- RE: How can I get the row number Based on cell value,
Martin Fishlock
- Re: How can I get the row number Based on cell value,
Kc-Mass
copy no match,
vernalGreens
'Save as' problem,
joecrabtree
Re: converting matlab scripts to VB to run in excel,
macropod
Is there any way to speed this up?,
Keith74
Rename selected (highlighted) sheet with cell contents of sheets in cell A1,
transferxxx
Compare 2 list and extract continous range,
Tamil
Lookup Multiple Values in Same Range,
google
Drop-down list dependant on another cell value,
samdev
assign shortcut to macro,
Gary Keramidas
Re: Create pivot table with VB,
Debra Dalgleish
Re: Clearing cell contents,
Dave Peterson
Re: reading tags from an mp4 file into excel sheet,
NickHK
Insert Data Last Row Loop through cells Excel 2000 & 2003,
jfcby
VBA for index match and an IF statement to make a cumbersome formula easier,
jsr
How to have data ordered via Data validation,
bartvandongen
Next without for??,
ZootRot
Delete all Macros Error,
BOBODD
if selection from drop down menu = X, then...,
Calvin . Lai
Chart code,
keri
Help speeding up my code,
Nick
RE: Subscript out of Range Error,
BOBODD
Re: What Does FormulaR1C1 Do?,
Don Guillett
How to detect selected cells in Excel, in VSTO,
Hung
FAX from VBA,
Otto Moehrbach
any function to replace loop,
rumkus
Delete cells where value is 0,
keri
Re: Adding working days,
Niek Otten
Save only one sheet from workbook,
joecrabtree
Re: problem with spreadsheet number format loaded from array,
marcus
Re: public property in one workbook, want to set value from another,
Tim Williams
Re: Selecting Activecell in hidden sheet,
Don Guillett
VBA UDF Calculation (not),
Greg Longtin
Re: Please Help.....................,
Don Guillett
Re: Inserting formula,
Bob Phillips
vba arrays, count blank cells,
matt
Merged cell auto row height revisited,
RealmSteel
vba macro to cut and shift text>65 char,
Nat1
VBA Code and Protection Sheet,
amirstal
Newbie Web Query and Date Formatting + Error Handling,
AKTransplant
Re: copy and paste values in a range,
keri
Error Handling doesn't work!,
HamishMcT
Re: load 2 dimensional array into excel sheet,
Bob Phillips
Re: Window Class of UserForm controls,
Bob Phillips
Excel VB: Problem Clicking Submit In Online Form,
jonathan . trousdale
Re: New workbook / 3 sheets,
Ken
Help with using arrays or just help in general!!!!,
bpotter_chk
Re: Expected End With..,
thesquirrel@xxxxxxxxx
Re: Converting all numbers to negative,
Please help James
Convert Weekly Forecast to Montly,
cwrm4
Not recognising value,
keri
Re: Can you use a Range $N$xx:$Q$xx in Target.Address?,
Dave Peterson
Re: Auto Row Height in Merged Cells with pre exisiting text,
Dave Peterson
- Message not available
- Re: Auto Row Height in Merged Cells with pre exisiting text,
Dave Peterson
- Re: Auto Row Height in Merged Cells with pre exisiting text,
gwinder
- Re: Auto Row Height in Merged Cells with pre exisiting text,
Dave Peterson
- Re: Auto Row Height in Merged Cells with pre exisiting text,
gwinder
- Re: Auto Row Height in Merged Cells with pre exisiting text,
Dave Peterson
- Re: Auto Row Height in Merged Cells with pre exisiting text,
gwinder
- Re: Auto Row Height in Merged Cells with pre exisiting text,
Dave Peterson
- Re: Auto Row Height in Merged Cells with pre exisiting text,
gwinder
- Re: Auto Row Height in Merged Cells with pre exisiting text,
Dave Peterson
- Re: Auto Row Height in Merged Cells with pre exisiting text,
gwinder
- Re: Auto Row Height in Merged Cells with pre exisiting text,
Dave Peterson
- Re: Auto Row Height in Merged Cells with pre exisiting text,
gwinder
- Re: Auto Row Height in Merged Cells with pre exisiting text,
Dave Peterson
Difference between VB and VBA?,
Mike
Re: How can this code be made more efficient?,
Bob Phillips
Formatting help,
keri
code error,
keri
Suppressing the Disable/Enable Macros Message Box Programmatically,
Mark Dev
xlBook.SaveAs (documentName) when file open by another process,
bg_ie
Re: Paste filenames into cells,
Don Guillett
Range text alignment,
keri
Run a macro continuously,
vernalGreens
Using a variable in more than one sub procedure,
keri
Re: For Next help,
John
HOW CAN I CONVERT NUMBER IN WORD USING VB6,
joe joe
Error on opening more than one workbook containing the same code,
john . mctigue
Help with for/next statements,
keri
Filtering problem,
Tim Walters
Re: creating a new collection,
Bob Phillips
Delete row if formula brings back an error,
keri
Re: Find & Replace macro limit?,
NickHK
Re: Help , reading an Excel value from the C program,
RapidXLL_NET
Re: Excel Worksheets Menu bar,
paul . robinson
Re: Userform: Showing Cell Data,
abhimanyu
Are Excel Shim Dll's have COM support,
abhimanyu
Extracting data from web page with an imbedded DB query,
jcalver
Worksheets("Sheet1") for foreign languages,
bg_ie
Re: Copy Sheet Names to a Column,
Nick Hodge
hide columns by column number,
Gary Keramidas
quick question,
Gary Keramidas
Best Excel VBA book?,
BradF
Re: ip addres,
NickHK
Deleting Charts,
Ardy
Cell Select Excel 2000 & 2003,
jfcby
Re: Code for Unicode,
NickHK
Program too large,
bpotter_chk
Trigger an Excel VBA event from another application,
Mike
Re: Code runs slooooww,
Gary Keramidas
Re: Forms,
Corey
Microsoft Query Help,
BlackJackal
Using Relative Reference Function to apply to Range,
Anthony
Re: Unhide Picture Using msoFalse,
Peter T
Re: ScreenUpdating = False not working,
Corey
Re: Oval-print location,
Jim Cone
Using Multiple Variables in an Array with Booleans,
cardan
Userform to have Last Updated Values Time & Date Displayed ??,
Corey
Locking certain cells..,
DB
RE: Combining similar data,
Bill Pfister
Re: Locating 1st blank cell in named range,
Trevor Shuttleworth
Workbook reopens after close,
John Michl
Re: Auto Response to Dialog Box,
Nick Hodge
Inputbox Location on Screen. Can you code it to popup lower on the screen ?,
Corey
go to website, fill in blocks from Excel,
J.W. Aldridge
allow entry in only one txtbox,
CR
Re: Macro to run when sheet activated,
Dave Miller
3D column chart,
canbya
Number stored as text error message,
prahz
RE: Copying Top and bottom values from number of ranges.,
Charles Chickering
RE: Is there a way to know when a user has selected the find funct,
Jim Thomlinson
Re: Colour the rings in a radar chart?,
Jon Peltier
Re: Macro to match values in an array.,
Bob Phillips
Re: Using result of function as row number,
Bob Phillips
RE: Send Form to Remote Database,
Ron Coderre
Macro that changes worksheet tab name,
Magoo
Re: Vlookup problem,
Dave Peterson
Help with If / Loop / Adding cells,
keri
Re: How to know if a range has been selected,
Bob Phillips
Editing a Read Only Excel File via VBE,
bg_ie
Charting in a loop,
Otto Moehrbach
Updated Question - Updating an SQL Database,
Dave
Printing Charts Macro Help,
joecrabtree
Programmatically unprotect my protected project to delete modules?,
Toby Erkson
Re: Character Comparison In a Cell,
lesliebantleman
Install or protect an Excel spreadsheet?,
web guy
Auto Save,
amirstal
Re: Serious problem when opening a file,
Dave Peterson
Application level VBE,
aine_canby
Open an excel Module,
ielmrani via OfficeKB.com
Copying Conditional Formatting Fails,
Henry Stockbridge
CSV Import - user to select file,
joecrabtree
Selecting a row from one worksheet if it is present in another,
i_eat_pies
Object hyperlink produces "Reference is not valid" error after worksheet name change,
relative_virtue@xxxxxxxxxxx
- Message not available
- Message not available
Re: Macro to clear cells of no value,
Bob Phillips
Excel 'database',
Duncan
Identify if a page break occours while entering data,
Keith74
System.Runtime.InteropServices.COMException (0x800A03EC),
mina
Application.Quit,
elcroco
Re: How to do this kind of sorting?,
NickHK
Applying the same macro to multiple excel files,
bg_ie
Re: File attributes,
NickHK
- <Possible follow-ups>
- Re: File attributes,
Bob Phillips
- Re: File attributes,
Alan
- Re: File attributes,
Bob Phillips
- Re: File attributes,
Alan
- Re: File attributes,
Bob Phillips
- Re: File attributes,
Bob Phillips
- Re: File attributes,
Alan
- Re: File attributes,
Joergen Bondesen
- Re: File attributes,
Bob Phillips
- Re: File attributes,
Joergen Bondesen
- Re: File attributes,
Bob Phillips
- Re: File attributes,
Joergen Bondesen
RE: File Open Dilog Box with Filter,
Martin Fishlock
Tacking All Sunday & Saturday in a Year along with the dates,
Akash
multi sheet scanning,
--== Alain ==--
Re: GetSaveAsFileName to prompt for overwriting?,
Jon Peltier
Re: Read VBA source code as input,
NickHK
Re: Choosing which macro to call,
NickHK
Re: time switch,
bony_tony
Printing on notepad from excel worksheet... Please Help!!,
riggimehta
Re: Setting Up References in the VBE,
NickHK
Re: Type change in a declared Variable?,
NickHK
Setting worksheet name equal to variable value,
newguy
Re: Sorting after autofilter,
Dave Peterson
match function with text and numbers,
sugargenius
Re: Lock an option in a menu.,
thesquirrel@xxxxxxxxx
Re: How to rename worksheet like "Jan. 2006",
Bob Phillips
Re: How to create worksheet with the name "Jan. 2007".....,
Bob Phillips
Colour specific cell based on 2 other cell values,
bony_tony
Re: Percentage,
Niek Otten
Array of comboboxes,
Dennis Benjamin
Show Data from Various Tabs in one Tab within the same worksheet,
Ardy
identifying files with macros,
emilio . ramirez . jr
Macro,
Bundychik
Re: vlookup function that returns blank if error,
Bob Phillips
On Click Event in Excel,
ISUTri
Access Named range value with multiple workbooks open,
ksgoodwin
Macro delete line,
Virginie
Combo Box vba that works like Forms Menu combo box,
Hector Fernandez
extract range with same weeks and move to "calendar",
leen . smit
RE: Compile error: Argument not optional,
Dave F
Email a workbook/worksheet on schedule?,
Zigball
Launch Macro at startup,
HotRod
Re: Rename Worksheet without Selecting the sheet,
jeff . j . griffith
Web Browser,
Zigball
Listbox none selected feature,
Mike Milligan
Find method... not work, suggest me please...,
sal21
Re: VBA parameters and checkboxes in Excel,
Bob Phillips
finding odd due dates,
jln via OfficeKB.com
Converting a "Logged out" time and "logged in" time to find out the elapsed time,
PamelaB
Adding meta tags to Excel web pages?,
MelB
copy row when matching colums found,
lancastergeneral
URGENT! How to read value in pivot table,
stoppal
Importing from Excel to Access,
rhodri . gabe
Enter information in one and lock the other, OR vise versa,
heyitsthechad
Re: select a range with a dialog box,
Bob Phillips
Send email when Condition met?,
HotRod
Macro to Filter on active cell within autofilter,
Cheekyaardvark
Compile error in hidden module - in custom VBA add-in...,
pbastian
detect duplicity by 1 scanning,
--== Alain ==--
Filename parameters passed based on cell contents,
bluegrassstateworker
Edit Module headings...,
Darin Kramer
showing data from a cell in a text box,
tenglins
Filename created by passing parameter of cell values,
andy . crumbacker
Conditional Computing,
aung
RE: Application.onKey non-functioning,
Martin Fishlock
Re: IF Statement Help,
Duncan
Re: display more info for listbox entry,
paul . robinson
RE: File transfer using Shell,
Mike
Re: send excel by email,
Duncan
problem with shapes.nodes collection in excel 2007,
tpm
Error Querying Access Database From Excel,
raymond . allan
Subtract cell formula from existing cell formula,
transferxxx
Re: Form VBA,
Corey
RE: Speeding Up Excel Performance-VBA Loops,
Hans Dummer
Re: Don't COUNT 0%??,
Bob Phillips
"Cannot quit Excel" after tried to access protected WB,
tskogstrom
Data Split and graph problem,
joecrabtree
ClearArrows - Runtime Error 1004,
moonhk
Adding cell properties (validation/colouring) quickly,
Scott
Re: Troubleshooting programming on a Mac from a Windows,
NickHK
DisplayOutline,
KC VBA Qns
EXcel Functions in VBA,
Tony McGee
update links question,
Gary Keramidas
Calculating a Due Date that is not a holiday or weekend,
Smythe32@xxxxxxx
How to use Index and Match to lookup headers in row and column?,
BradF
Re: 'Freeze panes' disables controls,
NickHK
Storing a selection from a combo box in a variable,
bony_tony
Re: problem with "Refresh BackgroundQuery=False",
NickHK
Warning Message before a Macro is Run,
amirstal
Re: prevent location change before saving,
NickHK
Re: how to tell when the user selects the find function - hippy,
NickHK
Excel to MiniTab,
Mark Ivey
Re: Excel rows.insert question,
NickHK
Re: Ignoring Errors,
NickHK
Re: Could not set the Text property of a ComboBox on User Form.,
NickHK
Re: Screen Position,
Dave Peterson
Copy paste a range from one Workbook to another,
Kc-Mass
Re: Open old workbook as new workbook?,
Corey
Problem with leap-frogging myCell Range,
Dennis
Re: Formatting of fields,
macropod
RE: Long Strings,
Martin Fishlock
RE: Find specific column titles and copy the column to new workboo,
JLGWhiz
VBA function calling for computations within other sheets,
Horatiu
Return System TimeZone in Abbreviation Format (i.e. CST),
prahz
Excel vba SUB doesn't complete until closing app,
mark . gorczyca
Re: VB number formats,
Gary Keramidas
Looking for range interestion recommendation,
Scott
Re: Custom Toolbar Docked amidst all other toolbars,
Jim Cone
Re: Search multiple strings in each cell,
Dave Peterson
- Re: Search multiple strings in each cell,
Jeff
- Re: Search multiple strings in each cell,
Jeff
- Re: Search multiple strings in each cell,
Jeff
- Re: Search multiple strings in each cell,
Dave Peterson
- Re: Search multiple strings in each cell,
Jeff
- Re: Search multiple strings in each cell,
Jeff
- Re: Search multiple strings in each cell,
Jeff
- Re: Search multiple strings in each cell,
Dave Peterson
- Re: Search multiple strings in each cell,
Jeff
- Re: Search multiple strings in each cell,
Dave Peterson
- Re: Search multiple strings in each cell,
Jeff
- Re: Search multiple strings in each cell,
Jeff
- Re: Search multiple strings in each cell,
Dave Peterson
- Re: Search multiple strings in each cell,
Jeff
- Re: Search multiple strings in each cell,
Dave Peterson
- Re: Search multiple strings in each cell,
Jeff
- Re: Search multiple strings in each cell,
Dave Peterson
Re: Convert String variable to code,
Bob Phillips
Removing "dummy" cell entries - zero length,
Tim Childs
Re: Splitting files / Pivot Table,
Debra Dalgleish
How can I make all the #VALUE! on the spreadsheet disappear?,
amirstal
Re: Auto row height for merged cells,
RealmSteel
Output from table?,
pwknowles
Do while loop error....,
guy
Transfer Data From Multiple TAB to One TAB,
Ardy
Re: If X and Y then Replace Y,
excel-ant
Re: Changing,
Dave Peterson
Excel Add in for AS: Function's not recognized,
VallabhK
Need Help ASAP!! Re: VBA cell addressing after Filter,
Dennis
Re: Moving Rows (Basic VBA Stuff),
Don Guillett
2 column List Box populated with data not from Excel sheet?,
MariahJ
Macro Code Help,
amirstal
pick last item from a (variable) range,
Gert
Where the objects are stored on the hard drive,
Zigball
Re: Interactive user form design,
Bob Phillips
Re: Timer Code,
Bob Phillips
How to view and update the code behind a pivot table,
andrei338
Re: New to Microsoft Treeview Control,
Satish
Sin Button run macro Excel 2000 - 2003,
jfcby
E-mail Files From Files,
SmartyPants
print sheets from a range with names,
cbm
Re: Vlookup Cannot Find a Particular Date in a Range?,
Niek Otten
For Ron de Bruin,
Otto Moehrbach
Open file with VBA,
Otto Moehrbach
Re: customise Insert Function/Function Arguments dialog box,
Niek Otten
object or array ?,
--== Alain ==--
Re: Group data in pivot using VBA,
Franz Verga
Re: calling external routines,
NickHK
Creating a User Defined Class / Object,
Andrew Hall NZ
Value Issue,
ankur
Re: positive value,
macropod
Hw to write a macro to calculate values,
Akash
getValue,
baha17@xxxxxxxxx
Re: Custom Mouse over Cell Event Help,
NickHK
Copy to current workbook loop,
justme
RE: Relative & Absolute References in Formula,
DennisW
Code Error Message Excel 2000 - 2003,
jfcby
Re: Save as Read-Only,
Corey
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code.,
Corey
Re: delete rows using VB,
macropod
Populate a Userform from an existing Record.,
Dooley007
Poor performance in summing up values on another worksheet,
Doug
How do you SETFOCUS on TextBox,
Mike
User Form pop up with a beep?,
Don Wiss
Re: Pop Up Windows,
Gord Dibben
SelectionChange code will ONLY work if cell is Selected AGAIN. Need to work once cell in no longer selected,
Corey
Re: Accpac Dos to Excel,
Tom Ogilvy
Re: Using Solver with multiple ranges (Excel 2003 sp2),
Tom Ogilvy
Print sheets by "All Sheets in workbook, EXCEPT for specific named sheets". Possible?,
Corey
Textbox appearances. Format as $ and %. How?,
Corey
Creating Pivot tables by VBA for varying amounts of data,
Paul
Re: Key listener,
Tom Ogilvy
Help with event code,
JMay
Change cell value Excel 2000 & 2003,
jfcby
Question on Graph XLGraphType,
Wayne Cressman
Re: Calendar control with merged cells,
Tom Ogilvy
Problem limiting characters,
Patrick Simonds
Re: create drop down box,
Gert-Jan
Conditional copying of rows,
Gert-Jan
Re: find first occurrence of data in a column,
Ron Rosenfeld
finding the location of a group of cells,
jimbo
Tourism,
jillsandr
Macro to Print all worksheets in workbook,
Dean
Limit characters,
Patrick Simonds
non duplicate values,
baha17@xxxxxxxxx
Save As,
Ardy
Re: Refresh Excel Pivot Table When New Data is Added using VBA,
Debra Dalgleish
Applying Colours,
Sanjay
Offset problem,
Patrick Simonds
copy chart from one sheet to other.,
musa.biralo
Re: Problem with Shell command,
Chip Pearson
Re: shape runtime error 438 excel 2007,
Jim Rech
Re: Still Need Help Repositioning Comments,
Jim Rech
Pasting search results not advancing row between matches,
Jon
Re: New List in 2003,
Bob Phillips
Extract Data using Web query,
francizyeo
What happened to Auto-Filter?,
slim
Re: Disabling Shortcuts And Keys,
Jim Cone
Re: dropdown cell link changes when inserting a row,
Jim Cone
before_save problems,
Nasim
Re: How do I code a cell to display the current date on double-click?,
George C.
I want to change the background color of cells, if value is a square root.,
George C.
Re: Row Source based on a filtered list,
Tom Ogilvy
Re: Using Macro to fill up data in coulmn,
Dave Peterson
Re: Name Sheets in Series,
Dave Peterson
Calling another worksheet,
Patrick Simonds
combining macros - compile error: duplicate declaration in current scope,
J.W. Aldridge
Help with drop down selection list box,
joecrabtree
SpecialCells Value=0??,
Otto Moehrbach
name sheet,
Gert
Formula with indirect addressing,
Erik Mattsson
listbox help please,
Gary Keramidas
- Message not available
- Message not available
Re: I need example code. Need a large Math (times X) table.,
George C.
I need a SUMIF that works with two criteria,
alondon
How to show User Form when form name is in string?,
Don Wiss
Re: Select Cell Contents from multippel cells,
Mark Ivey
Re: "Sending" range from Excel to Word,
Mark Ivey
Re: Multiple windows?,
Mark Ivey
update Records reference to new file,
tarone@xxxxxxxxx
Changing color of a cell, can it work like this?,
kinjin . zero
RE: Find method, special cells, home grown function,
Neal Zimm
MarkerForegroundColor not working,
mole6e23
Custom msgbox help needed!!!,
zz
Return System Time Zone,
prahz
Re: Using an IF statement, or VLOOKUP statement,
Tim Williams
Re: Adding time & dates together,
Trevor Shuttleworth
Re: Day v Date,
Dave Peterson
Re: Macro assigned to Menu,
Dave Peterson
Re: Zero Default,
Dave Peterson
Re: Conversion,
Ron de Bruin
Re: Moving data from one sheet to another.,
Ron de Bruin
How can I get rid of all the #N/A that are in my spreadsheet?,
amirstal
Macro - Excel to I-NOTES (Lotus Domino)?,
rustywheel
Add data to calendar from worksheet, Excel 2000-2003,
jfcby
Each cell is showing as a page,
LauraBethBrown@xxxxxxxxx
Parse Cell Around "Dash" in Data,
saraqpost
Re: Print and Copy option - MsgBox(),
Nigel
Re: Chart Axis Alignment,
Jon Peltier
Re: How to display the first Item in a combobox as the default item,
Jim Cone
GetSaveAsFilename,
Syed Zeeshan Haider
Macro with stop date,
ElaineYKwan
Re: Declaring Worksheets,
Bob Phillips
Re: Basic question - all rows in column to last row,
Bob Phillips
Re: Ceilling or round function?,
Tom Ogilvy
Re: COUNTIF with multiple criteria,
Tom Ogilvy
Calling a value when double clicking a cell,
andres . 31
No Multipage pages are active on startup,
prahz
Re: remarking VBA code,
Chip Pearson
Re: SendMail without open Outlook,
Ron de Bruin
Re: Sheet name as date,
Tom Ogilvy
Re: graph,
Tom Ogilvy
Grouping Work Sheets,
jim . hardy
protect opening of worksheet,
bernd
Re: More Concatenate operation - Any help?,
Bob Phillips
Re: application.caller,
Tom Ogilvy
Re: Run a macro by pressing a hyperlink,
Tom Ogilvy
Re: deleting a chart using a macro,
Tom Ogilvy
Strange 'Print' behaviour',
Nik
Re: Message Box - With Text Input,
Nick Hodge
Find and set references at runtime,
rezafloyd
Search then copy and past data,
joecrabtree
Macro to deleting spreadsheets in a workbook,
Snoopy
Error 1004 ""Method 'Range' of object '_Global' Failed,
Andrew R
Point and comma problem,
Gert-Jan
Re: Cell Formaating using vba,
Bob Phillips
User defined function: Address where UDF is used,
Joerg Lensing
Re: Difference between fixed and variable date,
Ian
Change Range using value in cell,
joecrabtree
Re: IS POSIBLE TO ADD TEXT IN TO A CELL WHIT TIME FORMAT?,
NickHK
UsedRange.Rows.Count value,
moonhk
Re: Cell formatting,
NickHK
Delete duplicates and more!,
Ramses
Delete Tabs,
Ardy
Visual Basic Code,
amirstal
Re: Can I change the colours on a spreadsheet with an if formula?,
NickHK
Visual Basic suddenly stopped working,
amirstal
Case sensitive unique list,
Smurfette18
Re: Private Sub Worksheet_Change(ByVal Target As Range),
Dave Peterson
Re: Difficult VBA Query,
Dave Peterson
Re: Follow Hyperlink Without Showing Website,
NickHK
Re: Count lines code in workbook,
Dave Peterson
Re: task scheduler does not reconize excel,
NickHK
Calendar DropDown & Scrollbar HELP, Excel 2000-2003,
jfcby
spellLang # for UK,
pjbur2005 via OfficeKB.com
Re: Convert Long File Name to Short File Name,
NickHK
Re: Select Case organization help,
Otto Moehrbach
Do loop until, step down row - copy paste - not what it seems.,
justagrunt
send sheet as attachment,
TBolt
Adding time,
DB
Re: Return the name of a range in a sheet formula,
Chip Pearson
Re: Formula to VBA,
Chip Pearson
Copying formulas with Macro,
dwshearer
Re: XML Spreadsheet Warning in Table - Cell Of Grid,
jem26
Getting started,
newbie
VB macro to change shape colours,
Sanjay
Re: Breaking up a Text String,
Chip Pearson
Re: How to Run VBA Code on cell or range change,
Bob Phillips
Re: How to find this total?,
Bob Phillips
Re: How top copy cell comments,
Dave Peterson
specifing an open workbook and reading its worksheets,
jerm . hannley
Using Vlookup in VBA,
prahz
Helping Parsing Excel Data,
conorfinnegan
Insert image into cell using C# and Excel interop??,
Michael Howes
Input Box that allows user to select range,
joecrabtree
Multipage's first page does not show contents on startup,
prahz
Re: What DDE topic returns the currently open file?,
Peter T
Access to Server folders,
Fred
Re: Selectdown Macro w/ varying rows,
Ron de Bruin
Need help with filtering dates,
bpotter_chk
Two Cell Loop,
amirstal
Re: I have if statement and I want to add more if to this arguement,
Ian
Need Help...Fix my Spreadsheet Please,
garcam
Re: Need to create a list of sheets from a list of names in column a,
KC Rippstein
modifying a macro with a macro,
davegb
Re: Using VBA to bring up Help,
Ron de Bruin
Click event of combobox,
Peter Ostermann
Re: For Next loop,
Doug Glancy
- Re: For Next loop,
Jason Lepack
- Message not available
- Re: For Next loop,
Jason Lepack
- Re: For Next loop,
Kevin
- Re: For Next loop,
Jason Lepack
- Re: For Next loop,
Kevin
- Re: For Next loop,
Jason Lepack
- Re: For Next loop,
Kevin
- Re: For Next loop,
Kevin
- Re: For Next loop,
Chip Pearson
- Re: For Next loop,
Jason Lepack
- Re: For Next loop,
Kevin
Re: User Defined Type not Defined error,
Chip Pearson
how to compare two arrays?,
Ofer
#N/A and SUM,
amirstal
Re: Deleting Worksheets,
paul . robinson
Learning about arrays?,
M. Authement
Re: VB calculations,
timmulla
Re: How to remove rows with the first cell blank,
Ron de Bruin
Re: Find Loop and then Loop again,
Don Guillett
Slicing and Dicing 1 Cell,
Justin
finding the blink cause,
Ofer
Re: unique, blank free, editable dropdown...,
chelle
Does the Macro Editor have an .exe associated to it?,
michael . roco
Re: list box selection?,
paul . robinson
Convert a number to text and add a comma separator for thousands,
prahz
Autofill range,
Wendy
Re: worksheet loop,
Don Guillett
Index and Match Functions,
amirstal
Search column for certain criteria and display results in a table,
cheeser83
Re: Hide the running macro,
Norman Jones
array elements count,
madeleine
Re: how can i "=MROUND(J33,50)",
Niek Otten
For Each loop recheck,
Riddler
Macro formatting,
Sam Commar
Data Extract and Sort Macro Help,
joecrabtree
protecting a worksheet,
HSalim[MVP]
Need VBA Expert help on DV list,
Rishi
pdf printer on each laptop different name,
ricowyder
CellFormat is lost when using CopyFromRecordset,
lucy
Re: Display decimals in a msgbox,
Don Guillett
Re: Delete All Macros,
Norman Jones
Re: UDF Help Websites?,
Niek Otten
Re: Names of named ranges in active sheet only,
Norman Jones
Re: Strange serious problem,
Norman Jones
exclude a column,
bernd
Re: required alert msg,
Norman Jones
Re: User Defined Function - Needed,
Norman Jones
How to I activate Excel,
Sean
Copy Problem - URGENT PLZ! X.X,
Dash
Selecting a chart in a worksheet with VBA trouble,
SebasFM
Re: Code to delete rows where cell value is zero,
Cheekyaardvark
Re: Query Refresh code,
NickHK
modeless dialog question,
Gary Keramidas
Re: How to change all cells with "zero" value into transparent, not bl,
Gary Keramidas
Save excel file before printing,
Nasim
save before printing,
Nasim
How to Fill the data,
ronwang1001
Re: close application when interrupt by user,
NickHK
Re: Change Worksheet Button Caption on Worksheet.Activate,
John Green
How to Programatically Invoke "Debug",
Greg Glynn
Re: Automatic line change,
NickHK
Re: Extract all CN='Name' from a Active Directory data-dumped-cell,
Jim Cone
Re: generating non-repeating random numbers in a range,
Tom Ogilvy
Copying cells to another worksheet,
Derrick Salmon
Re: How do you keep a Dialog Box in the center of the screen?,
NickHK
Re: Formatting Excel from Access/Subtotals,
NickHK
Re: Set Integer Variables back to Zero,
NickHK
Re: Timer Events in VBA,
NickHK
Re: Sorting Controls by Name,
Dave Peterson
Re: How do I create a macro to Show detail in Excel,
Jim Cone
Which imports for stdole in vb.net,
samadams_2006
Re: refer to cells by number,
Mike Fogleman
Print long sheet shared on pages,
pygmalion
Re: Insert Rows,
Bob Phillips
Re: FormatNumber,
Bob Phillips
Re: Consolidate many sheets into one sheet with multiple rows,
Ron de Bruin
Autofilter Printing,
Magoo
How to automatically generate excel files at the web server?,
Maxwell2006
Find, Copy offset to offset on other sheet, Run-time 1004.,
Finny
- Re: Find, Copy offset to offset on other sheet, Run-time 1004.,
Dave Peterson
- Re: Find, Copy offset to offset on other sheet, Run-time 1004.,
Finny
- Re: Find, Copy offset to offset on other sheet, Run-time 1004.,
Finny
- Re: Find, Copy offset to offset on other sheet, Run-time 1004.,
Dave Peterson
- Re: Find, Copy offset to offset on other sheet, Run-time 1004.,
Finny
- Re: Find, Copy offset to offset on other sheet, Run-time 1004.,
Finny
- Re: Find, Copy offset to offset on other sheet, Run-time 1004.,
Dave Peterson
- Re: Find, Copy offset to offset on other sheet, Run-time 1004.,
Finny
- Re: Find, Copy offset to offset on other sheet, Run-time 1004.,
Finny
- Re: Find, Copy offset to offset on other sheet, Run-time 1004.,
Dave Peterson
reading rows,
jerm . hannley
ranking each employee,
ppatel
Create multiple workbooks from a single Excel spreadsheet,
slowjam4
weird things happen sometimes,
Gary Keramidas
Re: goto row,
Tom Ogilvy
Re: Efficient Code to Copy a 1-D Array to a Worksheet Column,
Tom Ogilvy
Using variable as row reference in VBA,
Deecrypt
Re: User Defined Functions,
Niek Otten
ActiveCell.FormulaR1C1,
Kevin
Re: Moving, Resizing a Cell Comment,
Dave Peterson
- Message not available
- Message not available
Where does an "On error resume next" statement apply?,
davegb
An objects properties?,
davegb
Re: Dynamic Column in Pivot Table Macro,
Roger Govier