microsoft.public.excel.programming
- Re: sequential move across sheets,
Chip Pearson
- Re: ActiveSheet.SaveAs,
Tom Ogilvy
- Cant help it,
N10
- Help-Simple Sub,
New to VBA
- Identifying Visible Toolbars,
DCSwearingen
- Re: Convert Excel Formula to VBA,
Tom Ogilvy
- paste to word document and save,
eyecalibrate
- Re: Disable paste special attributes,
Leith Ross
- how to create a new folder through a macro ??,
furbiuzzu
- Saving current workbook,
ccarmock
- Re: Copy cell data from workbook based on user input,
evgny
Programming advice please,
KC Cheung
Re: Concatenate Non Blank Cells,
ssjody
Compare 2 sheet and insert result into other,
sal21
RE: What to use for floating help?,
Greg Wilson
I need a help for the Excel formula.,
srikant_shetty
Q on Entering a Criteria within a Query,
John
Multipage Userform,
mjack003
Extract Data from an Access Database in to Excel,
John
Help writing a macro,
IcarusFB
Re: How do i open excel sheets under one excel program,
Leith Ross
finding the last cell typed in,
jj33002
Data with starting with - causes Type Mismatch,
icdoo
Macro to delete row if value in column J =0,
annep
Re: Can't Disable the "Insert - Rows" menu option in Excel using VBA m,
Ron de Bruin
Re: ListBox question,
Flemming Dahl
Phrase Permutations,
rpgun
Re: Error in code,
Dave Peterson
Creating a list of values,
JC Home
Insert Concatenate Formula,
DARREN FONG via OfficeKB.com
value in userform,
antonov
VBA, and SaveAs Function,
Amber_D_Laws
Re: Code to create and name a sheet,
Norman Jones
Copy matching lines,
cbrd
Generic protect/unprotect code through buttons and code?,
StargateFanFromWork
Re: Calculating Calif overtime on timesheet,
Leith Ross
Re: vlookup up to the next increment,
Niek Otten
VBA Can't select cell - what's up,
bill m
Code execution has been interrupted,
AnExpertNovice
Problem with creating chart within existing worksheet.,
3PhaseMacroMan
Re: Combobox moves when worksheet is printed???,
Dave Peterson
Writing neat code,
Roderick O'Regan
Worksheet_Change: Date Time Input [mmddyy hhmm] to [mm/dd/yy hh:mm],
Brian Handly
To access a previous object via class module,
Pierre Archambault
Re: paste values macro,
Tom Ogilvy
Re: Select first 3 sheets,
Norman Jones
Re: Combine data on one sheet,
Tom Ogilvy
Re: On activate event,
Norman Jones
Newbie help...,
Don Bright
Re: RE newbie question workbook using c# thanks,
Tom Ogilvy
RE: Help for how to pop-up images &/or use text-to-speech on distant c,
JNW
Re: Checking Blank Rows,
Tom Ogilvy
Re: Macro Print to file limited the no of character in a row?,
Dave Peterson
Re: How do I delete 250 rows on Excel sheet where ever a cell value =0,
Bob Phillips
newbie question workbook using c#,
CobraStrikes
input excel data to access db in web server,
x taol
Re: What function to determine the second small integer from a list?,
Tom Ogilvy
Re: 'Template' within a worksheet - change existing worksheets,
Tom Ogilvy
getting data from word into excel,
Nicolas Roth
Re: workbook security,
Jim Rech
Copy/Paste Revisted,
Saxman
Re: pivottable,
Debra Dalgleish
Running a Macro from a Command Button,
sammy2x
Code to get data from webpage into Excel (v.2),
Charalampos
Re: How to write a language independent formula,
Niek Otten
Starting a macro when switching to a worksheet?,
Markus Mueller
Re: filling cells with formulas,
Pierre via OfficeKB.com
Active Cell - Remember,
Paul Brown
color corresponding cell in other column,
Pierre via OfficeKB.com
Moving data from one part of a worksheet to another with a button,
kyle . murdoch
displaying a list of info,
Tom
Cell of sheet Not accepting 32767 character,
trialproduct2004
Using match in vba.. with various files,
nance
Making a number have Text format,
Howard Kaikow
Input mask for changing a numeric to a Zero,
bd420
Automatically Change Date every 2 weeks,
GYRO
Re: Sumproduct with two conditions(or more),
Dave Peterson
HRESULT: 0x800A03EC setting DataSource for pivot tables.,
katherineolson
Re: Modify Paste Special to choose absolute or relative references,
LWD
Transpose,
kadium
How do I update the Vertical scrollbar,
Ken Soenen
Re: Use VBA code to display message if combobox selection not in list,
Dave Peterson
- Message not available
- Message not available
make macros (sub) work for add-in?,
meow
Bug? AutoShape position properties incorrect,
Nick Hebb
Question about creating macro (to export to quickbooks pro),
billybob
verifying one cell and pasting number next to it,
Dev4me
Re: Macro for deleting rows,
Flemming Dahl
Range selecting in non-active workbook,
SJC
Suggestions on resources on UserForms,
excelnut1954
Re: Animation,
Tom Ogilvy
Re: Macro Toolbar has disappeared,
Ron de Bruin
Re: Filer and Copy,
Ron de Bruin
find value and delete cell and the cell next to it,
Pierre via OfficeKB.com
Re: subtract hours, not time of day,
Bob Phillips
Delete Multiple Rows based on Selection,
Kevin O'Neill
Excel Add-in for Analysis Services: can't connect,
mta37
Re: Custom Hotkey Strategy,
Tom Ogilvy
Re: Formula needed with a changing denominator for each grouping,
Tom Ogilvy
Altering a macro with a macro,
TheIrishThug
hyperlink for the Office-2003 Excel web component,
ilyam
Re: Delete Tabs,
Tom Ogilvy
Range Object Question,
abillmeier
Re: starting .bat file from excel VBA,
Dave Peterson
Re: Positioning pictures in a cell,
Tim Williams
Do while not blank macro,
Sanjay
Re: Repositioning cursor,
Leith Ross
Re: How can I insert a drop down date picker to worksheet cells?,
Tom Ogilvy
Re: Macro to combine (sum) like items,
Bob Phillips
Re: ControlButtons in a UserForm,
Dave Peterson
Re: Variables in VBA,
Bob Phillips
Re: Save Macro,
Tom Ogilvy
Re: How do I program a macro to do an essbase retrieve?,
rbanks
Merging information from multiple cells or worksheets,
MAPADMIN
Re: Essbase over-rides basic Functionality?,
rbanks
Re: Hyperion Essbase add-in macro,
rbanks
IF,
GREGORY CIAMPA
Unhiding all worksheets.,
rbanks
Excel and Office Communicator,
Nigel
Combine 2 Macros,
al007
Macro To Printout Worksheets Crashes,
Martin Fishlock
Re: Name Active Workbook,
Ron de Bruin
Re: Macro to copy a value if number,
Ron de Bruin
RE: Setting an Essbase Option using code,
Ron Coderre
switching between applications,
Corey G
Excel upload to Access (VBA help),
Justin
Re: Setting right-hand internal margin in textbox,
Tom Ogilvy
Re: Limit Files via VBA not folder rights or permissions,
Tom Ogilvy
Re: Macro to copy cell values to row below,
Tom Ogilvy
Re: Writing a range to an array...,
Tom Ogilvy
Chosing the top 3 values from a list,
st120869
changing bacground colour if formula altered,
st120869
RE: some complicated programming me thinks, update worksheet function,
K Dales
Creating a generic progress bar,
SJC
Re: Autofilter Pulldown,
Tom Ogilvy
Identifying drive letter with Save-as to a server,
excelnut1954
Re: import property from outlokk distribution list,
sal21
Remove Hyperlinks,
dthmtlgod
Pasting into another application usin Excel VBA,
SystemHack
Want to select cells in B1:B19 which have same value as in cell A1,
al007
Re: Need Help in Printing,
gajendra_vba
Looping thru Sheets without activating,
Myles
Re: Data given produces a cell info,
Norman Jones
Cell Blink or message if cells date = today date,
al007
Excel PageBreaks and the Rows to Count thereof,
tkt_tang
Formatting after Web Query Refresh,
aachiney
help: code for importing xml into excel sheet,
deepakbadki
VBA Copy Paste Problem,
Richard Slacum
Re: Problems implementing advanced filter code...,
GIT-R-DONE
Newbie Question,
mikesr20
Re: Code to set text length in cell,
Mike Fogleman
Comparing Multidimensional Arrays?,
Rshow
help! how to delete useless rows in 2 dim array by VBA,
xiang
Setting Directory when Saving File,
David
Re: MSDN should include a VBA reference.,
Tom Ogilvy
Pivot Table, Limit 255 rows, Invert rows and column,
xav
Extract Data into a Summarized form,
Ricky Pang
class functions,
TheIrishThug
Re: Object Required Error 424,
Chip Pearson
Re: using arrays to transpose data,
Tom Ogilvy
values in userform,
antonov
Better Way To Do This SLOW code,
rshow1971
Re: Worksheet Activation from another workbook,
Bob Phillips
Duplicate CommandButton macros,
Blue Hornet
Loop through column headers to search from column name and get cell range,
Pie
Re: active cell list name,
Dave Peterson
Possible to Change DialogPrintPreview CBs?,
JK
Sorting data--impact to formula references and charting,
mshulman
Global variable problem in debugging,
Frederick Chow
Re: Macro Error,
Tom Ogilvy
Help with MSCOMM control,
EAB1977
Re: TBs and Ckbxes move left on screen after printing,
Tom Ogilvy
Re: Basic question,
Bob Phillips
Re: How do I lock a cell in excel file ?,
Tom Ogilvy
Re: Lock cells for combo box values only,
Tom Ogilvy
Re: Close Files Fast,
Leith Ross
Re: Run-time error '9' on With statement,
Leith Ross
Unlocking a Project,
Ralph Heidecke
RE: Virus Protection Workaround??,
John V
Inserting new items into columns,
Michael Malinsky
Sorting arrays that contain multiple values,
greenglide
VBA error in charting function. Help!,
3PhaseMacroMan
Userform Woes,
gachett
Worksheet_Activate not working on multiple cells,
rounder911
code to find stuff in each sheet?,
mb97
Using interop.excel to open a workbook, the workbook doesn't ask to save changes.,
milmans
Re: Inserting columns,
Don Guillett
avoid warning when removing sheet,
Tijmen
cell references to different sheets with lists,
TheIrishThug
Re: Exporting non contigous ranges,
Tom Ogilvy
Re: Progmatically add code to worksheet_activate,
Chip Pearson
Re: Dual input cells,
Chip Pearson
want to access xml from excel object model,
B Deepak
Create & Format XL Comments with VBA,
AH·C
Generic Window/Workbook text,
jase
More efficient way to calculate values,
Marw
Centering a Userform after Height Change,
Craig
Changing Number Format,
Howard Kaikow
arrange cell order,
norika
Re: Solver function,
Debra Dalgleish
Re: Workbook name problem,
Leith Ross
Can't get the right formula function.,
Jaemun
Lopp in column to find and select,
al007
VB Newbie - Counting occurences in array,
SJC
Re: Print contents of textbox (has scrollbars),
Tom Ogilvy
VBA that automatically generates a series of cash flows based on a start date, an end date and frequency,
tamzik@xxxxxxxxx
Code bug,
peter . thompson
knowing error line and module name,
x taol
Re: Replace Values in range selection,
Bob Phillips
Extract Digit Function Question,
rrstudio2@xxxxxxxxxxx
Re: How do I remove data fields I do not need from data source?,
Otto Moehrbach
RE: Input for Macros,
bpeltzer
Progress bar during workbook save,
Craig
Re: Add Commandbar when Add-in is install,
Bob Phillips
Re: vba help screen,
Bob Phillips
Message box in excel,
RANDY IN NC
Textbox highlighting issue,
peter . thompson
Extract Digits Questions,
rrstudio2
Re: Forms ran as EXE,
Tom Ogilvy
Re: How do I remove duplicate fields in excel,
Tom Ogilvy
Range().resize giving errors,
Harry Tuttle
Sort Code,
Newbie1092
I closed all menus/toolbars with macro. Any way to fix w/o losing my XLB??,
StargateFanFromWork
Generate Histogram,
robbywvut
Extract Number from text,
rrstudio2
Re: if activecell = the cell below,
Otto Moehrbach
Type Mismatch??,
Otto Moehrbach
Re: Valid select statements using OLEDB and Excel,
Bob Phillips
looping thru each w/sheet,
mb97
reading a range name as part of Save-as file,
excelnut1954
Re: Trouble With MacroOptions,
Bob Phillips
Re: Help with a UDF Function using Arrays...,
Tom Ogilvy
How to create & use User Forms,
DCSwearingen
Shortcut Nested If Statements,
rrstudio2
Re: How to do a mass update to formulas?,
Doug Glancy
Inserting forumla using vba,
Guardian
Re: Set tab order for textboxes,
Tom Ogilvy
Question: loading a file into a Object?,
Michael Vaughan
Question: File already exists,
Michael Vaughan
Creating an add-in,
HSalim[MVP]
- Re: Creating an add-in,
Tom Ogilvy
- Re: Creating an add-in,
HSalim[MVP]
- Re: Creating an add-in,
Tom Ogilvy
- Re: Creating an add-in,
Peter T
- Re: Creating an add-in,
HSalim[MVP]
- Re: Creating an add-in,
Peter T
- Re: Creating an add-in,
HSalim[MVP]
- Re: Creating an add-in,
Peter T
- Re: Creating an add-in,
Peter T
- Re: Creating an add-in,
HSalim[MVP]
- Re: Creating an add-in,
Tom Ogilvy
- Re: Creating an add-in,
Tom Ogilvy
- Re: Creating an add-in,
HSalim[MVP]
- Re: Creating an add-in,
Peter T
- Re: Creating an add-in,
HSalim[MVP]
- Re: Creating an add-in,
HSalim[MVP]
- Re: Creating an add-in,
Peter T
- Re: Creating an add-in,
HSalim[MVP]
- Re: Creating an add-in,
Peter T
- Re: Creating an add-in,
HSalim[MVP]
- Re: Creating an add-in,
Peter T
- Re: Creating an add-in,
HSalim[MVP]
XL 97 - designing form with zooming capabilities,
asdfasdfnl
Re: how can i use cell information as a tab name automatically?,
Tom Ogilvy
Update graphs with Macro,
Ferdinand
variable transpose,
kimberlykight
Re: How can I lock a single cell in an Excel following data entry?,
Tom Ogilvy
Re: Importing data from Access to Excel 2003 using code,
Tom Ogilvy
Routine that saves a file. If more than 7 in directory, deletes the oldest.,
wayliff
Topic: Please help DrawingObjects in Cells,
rock
FileSearch using FileType,
Werner Rohrmoser
Hiding/UnHiding Selected Worksheets,
Craig
Re: Hashing,
Norman Jones
What is the VBA command to terminate the Excel.exe process,
orenr
Clarification needed about Scope Of Variables,
vmegha
Macro to insert Now() when cell updates,
systematic
Preventing user from closing form with "X",
peter . thompson
Re: Put Filename Variable in Macro,
Robin Hammond
Re: Process a row if a string search finds certain words from a list,
jindon
If/then code problem,
peter . thompson
Create a sheet and name it,
jeanluc . praz
check to see if all dates are for the current year,
Oldjay
Find multiple values,
deekaye
Re: two very simple questions,
Doug Glancy
Re: How do i pull details from a table to appear as a list in excel?,
Norman Jones
Code bombing on Loop While line,
JMay
Re: Password protection,
Peo Sjoblom
filling array with non-contiguous range,
koalabeer
Re: How 2 use right shift "<<" and left shift ">>" operator in excel?,
Leith Ross
Re: Search/replace Userform Variable,
Dave Peterson
How to use Excel Functions in VBA?,
johnbest
Re: Advance filter to find date wise?,
Bob Phillips
Extract based on Delimiters,
ssjody
VBA code to always select next available new workbook,
wayliff
How to Count only Colored cells,
WM_1956
Auto setting column widths accross a whole workbook,
vMaster
running another application from VBA,
sudhaca
Re: Reference a cell as the file name,
Norman Jones
Re: Can I run Visual Basic procedure using Excel Visual Basic editor?,
Norman Jones
COUNTIF - Cell reference does not work !!,
ideas2050
Character formating for User defined function problem,
RosH
hi,
rock
Make query,
ardi
repeated end(xldown),
R.VENKATARAMAN
How to judge some cell that had been added comments?,
Terry
Using Vlookup in Worksheet_SelectionChange,
Brad
End Down, Down,
annep
Re: importing undelimited text file data, character-by-character,
Niek Otten
Return the name of a range,
Frederick Chow
Need to loop my macro,
David
Re: Deleted empty row for some columns,
jtp
VBA help not displaying all topics.,
davidmal
Cycle through all worksheets,
Patrick Simonds
Looking For A Specific Formula Programmatically,
Johnny Meredith
Re: need form pulldown white while box is color,
Leith Ross
Re: copy and paste from row below,
Norman Jones
Calendar inhance,
Jaemun
prevent button from copying,
David
update collection of arrays,
RB Smissaert
Re: application user input,
Norman Jones
What am I doing wrong?,
Patrick Simonds
Conditional formatting - different cell colour for each year following from user input date?,
StargateFan
- Re: Conditional formatting - different cell colour for each year following from user input date?,
Ken Johnson
- Re: Conditional formatting - different cell colour for each year following from user input date?,
StargateFan
- Re: Conditional formatting - different cell colour for each year following from user input date?,
jtp
- Re: Conditional formatting - different cell colour for each year following from user input date?,
StargateFan
- Re: Conditional formatting - different cell colour for each year following from user input date?,
jtp
- Re: Conditional formatting - different cell colour for each year following from user input date?,
StargateFan
- Re: Conditional formatting - different cell colour for each year following from user input date?,
jtp
- Re: Conditional formatting - different cell colour for each year following from user input date?,
Ken Johnson
- Re: Conditional formatting - different cell colour for each year following from user input date?,
Ken Johnson
- Re: Conditional formatting - different cell colour for each year following from user input date?,
StargateFan
- Re: Conditional formatting - different cell colour for each year following from user input date?,
jtp
- Re: Conditional formatting - different cell colour for each year following from user input date?,
Ken Johnson
- Re: Conditional formatting - different cell colour for each year following from user input date?,
StargateFan
- Re: Conditional formatting - different cell colour for each year following from user input date?,
jtp
- Re: Conditional formatting - different cell colour for each year following from user input date?,
Ken Johnson
- Re: Conditional formatting - different cell colour for each year following from user input date?,
StargateFan
- Re: Conditional formatting - different cell colour for each year following from user input date?,
Ken Johnson
- Re: Conditional formatting - different cell colour for each year following from user input date?,
StargateFan
Insert Additional Numeric Value in a cell using VBA,
Sam via OfficeKB.com
Code works, but is slow,
EMoe
Thanks,
gandhi318
Opening a file from a cell value,
EMoe
q:read value from serial port,
qwerty
Merry Xmas,
al007
search for a specific word and copy the word and the preceeding words until a comma,
DHANANJAY
Vlookup What if not Found,
ssjody
Re: checking celles by vb excel2000,
Norman Jones
Name of Current Macro running?,
Nigel
How to get all Excel instance,
Xav
Re: Multiple user password,
jtp
Summary page,
mb97
Licensing question,
peter . thompson
Checking a cell's (Row,Column),
Craig
programatically color fonts and auto sorting,
quaere_
Repeat code over 300 rows,
Patrick Simonds
Adding a item to the right click menu?,
silkworm
A little advice on comparing cells,
systematic
Commanbar toolbar - can we customize size?,
StargateFan
A simple copy problem,
L. Howard Kittle
Quick and easy solution needed!,
grahamhurlburt
dates in userform,
antonov
VBA to open a .mdb file,
EMoe
how to reverse cells value,
Jaemun
Re: VLOOKUP Formula using variable for lookup_value,
Gazeta
How to make add-in work for all users,
A.Q
Re: Formulas Not Calculating in Excel 2003,
Gord Dibben
Re: create an add-in from macro,
Dave Peterson
Re: Question about text files from excel. DESPERATE HELP NEEDED.,
Dave Peterson
Re: IF then statements,
Tom Ogilvy
Custom Toolbars,
blackfish
Last Cell,
Dave Unger
Delete pivot table,
HSalim[MVP]
Complete newb, I know!,
grahamhurlburt
Re: Data Parsing Problem,
Tom Ogilvy
Button clicks and textbox Exit events,
Linc
Control Scroll bar,
mcroozer
Changes to Add-Ins are not saved...,
cgr
Printing web page selection,
Brian Delaney
DateDIF,
Paul Breslin
Re: spliting out data in one field into two,
Norman Jones
Re: embedding picture or object in a cell,
Tim Williams
Default date in a UserForm box,
excelnut1954
- Re: Default date in a UserForm box,
RB Smissaert
- Re: Default date in a UserForm box,
Harald Staff
- Re: Default date in a UserForm box,
excelnut1954
- Re: Default date in a UserForm box,
Harald Staff
- Re: Default date in a UserForm box,
excelnut1954
- Re: Default date in a UserForm box,
excelnut1954
- Re: Default date in a UserForm box,
Dave Peterson
- Re: Default date in a UserForm box,
excelnut1954
- Re: Default date in a UserForm box,
Dave Peterson
- Re: Default date in a UserForm box,
excelnut1954
- Re: Default date in a UserForm box,
Dave Peterson
- Re: Default date in a UserForm box,
Tom Ogilvy
- Re: Default date in a UserForm box,
excelnut1954
- Re: Default date in a UserForm box,
Dave Peterson
changing addin extensions,
Doug Glancy
Re: Print Failure - Default File Location,
Tom Ogilvy
Re: bond convexity,
Tom Ogilvy
Re: Copying several columns,
Tom Ogilvy
Re: Bottons Fail After Moving File,
Tom Ogilvy
Re: Buttons Fail After Moving File to Different Folder,
Tom Ogilvy
Re: macro to copy & paste cell data into another cell,
Tom Ogilvy
Search cells on a page?,
Josh Orfanakis
Workbook and Window object question,
Frederick Chow
Re: click event,
Otto Moehrbach
Re: Macro to move info and delete duplicat records,
RB Smissaert
Cutom View,
oberon . black
Determine Find/Replace settings and then restore them?,
Dan Williams
source code management,
Eric
If formula question,
CadensDad
Re: Macro to move cell contents based on formatting,
Tom Ogilvy
scroll window to display selected cell in visible area?,
Kate
Re: Hex Edit Excel,
Tom Ogilvy
how to sort many rows independently?,
guillemot
Re: Totals & updating totals,
Tom Ogilvy
RE: DataForm.Show does not work in code,
ufo_pilot
WORD-DELIMITED string vba macro for excel/word,
jackal2k6
Re: how to combine and's with or's in a if statement,
Bob Phillips
Macro Runs Too Fast,
LizS
How to insert Data,
ardi
Re: MY ARRAY FORMULA IS SLOW IF DATA LIST IS MORE THAN 10000R0WS,
keepITcool
ElseIf Statement problem,
Erik K via OfficeKB.com
DT Object missing,
Edward
Re: killing accents sos,
keepITcool
After For..Next..Go to Next Row Data,
Junior728
Multiple File Select,
TheIrishThug
ListBox problem,
Patrick Simonds
Issues about making project references,
Frederick Chow
Re: How to switch between different workbooks?,
Norman Jones
Offsetting formula results,
Patrick Simonds
Re: Can I upgrade Excel to allow longer formulas?,
JE McGimpsey
Re: Emailing an Excel cell range,
Ron de Bruin
Varify status before runing code,
Patrick Simonds
retrieve data interval,
ardi
Re: How to get the row number of new value in a column???,
Leith Ross
Re: macro to insert formula if cell format criteria satisafied,
Leith Ross
Re: Visual Basic Help,
PaulD
How to read text content of AS400 screen,
abc
No Frames in Control Toolbox?,
Don Wiss
Finding sheet a range is on?,
Don Wiss
exporting data from Workbooks in Folder,
juergenkemeter
Calculating Max, Min, Ave etc of a large region,
Jim Brass
simple question,
medicenpringles
Re: Condense Code,
Tim Williams
Context-sensitive custom menu item.,
Murray
Re: I need some checking done,
JE McGimpsey
Colored worksheet tabs in Excel 2000?,
PDQ
CSV file, but not regular commas,
Vikxcel
Re: invoke "Save Changes?" prompt,
Leith Ross
Re: Macro, delete rows that meet criteria,
Norman Jones
Re: How do I use VB to set permissions for cell ranges in Excel 2K3?,
David Lloyd
Create a time stamp from a date and vv,
hhalle
DEBUG EXCEL,
Wild_Jim
Re: Pasting an Excel array,
Tom Ogilvy
Clear data range, and copy static value.,
knox5731
Function to store last row and use in autofill selection,
wayliff
Re: Evaluate sumproduct question,
Bob Phillips
Re: Date and Time Picker,
Leith Ross
How to define a relative named range in VBA,
John Broderick
Show a Excel UserForm in Access,
qing yun
Re: Public Functions,
Chip Pearson
Re: How can I control the macro's running time?,
Leith Ross
Conditional Font Color,
Jim Brass
OnChange function only when a certain cell changes,
PCLIVE
Re: XIrr in VBA error,
Chip Pearson
Re: Macro/Function for Keyboard button combinations,
Leith Ross
How to indicate that UDF didn't converge?,
MrShorty
Nameing A New Workbook,
RANDY IN NC
Re: How to copy Dropdown boxes?,
Leith Ross
Macro to copy from one sheet to another and trim data,
knox5731
RE: Sort Error,
Jim Thomlinson
Import data from multiple excel files,
Arlan
Re: Move to bottom of Column,
Nigel
Default Dir,
GregR
Re: delete duplicates macro to color instead of delete,
ani_unicorn
Re: Paste,
Bob Phillips
SelectionChange event,
Kate
Moving every other row,
catalfamo1220
Not enough memory,
Edward Ulle
Using Workbook_AddinInstall -vs- Workbook_Open Events,
Bill Schanks
absolute reference to sheet in other workbook,
Brassman
Re: How can I delete 'fuzzy' duplicated rows?,
John Coleman
- Message not available
- Re: How can I delete 'fuzzy' duplicated rows?,
Toppers
- Re: How can I delete 'fuzzy' duplicated rows?,
ani_unicorn
- Re: How can I delete 'fuzzy' duplicated rows?,
Ken Hudson
- Re: How can I delete 'fuzzy' duplicated rows?,
ani_unicorn
- Re: How can I delete 'fuzzy' duplicated rows?,
Ken Hudson
- Re: How can I delete 'fuzzy' duplicated rows?,
ani_unicorn
- Re: How can I delete 'fuzzy' duplicated rows?,
Ken Hudson
- Re: How can I delete 'fuzzy' duplicated rows?,
ani_unicorn
- Re: How can I delete 'fuzzy' duplicated rows?,
Toppers
- Re: How can I delete 'fuzzy' duplicated rows?,
Ken Hudson
- Re: How can I delete 'fuzzy' duplicated rows?,
ani_unicorn
- Re: How can I delete 'fuzzy' duplicated rows?,
Ken Hudson
- Re: How can I delete 'fuzzy' duplicated rows?,
ani_unicorn
- Re: How can I delete 'fuzzy' duplicated rows?,
ani_unicorn
- Re: How can I delete 'fuzzy' duplicated rows?,
Dominic
Re: Creating a text file and printing excel spreadsheet data onto it,
Tom Ogilvy
Re: formatting variables,
Dave Peterson
Apply formula to a range with multiple selections,
deekaye
Re: error passing a formula to a cell from a string,
TheIrishThug
Re: Learning VB6 or VB2005?,
Chip Pearson
Re: email a worksheet - problems,
Ron de Bruin
Re: An unanswered question about changing the numeric part,
MattShoreson
Re: VbYesNo MsgBox won't respond to "No",
Chip Pearson
Is there a way to create dates 7 days apart automatically?,
moochito
Re: Exclude hidden workbooks from list,
Jim Cone
Re: Pivot Table groups Refresh,
Debra Dalgleish
Re: How to select sorted data listed under an unsorted grouping?,
mcg
named ranges in a For Loop,
ronnie_knight
need macro help,
yuvalbra@xxxxxxxxx
Re: How do I get the current Excel CustomView in VB,
Chip Pearson
Re: figuring out the next number in a series,
Tushar Mehta
RE: Run Access query from Excel, input value to query being value,
Nagesh
Arrow cursor for a excel WB,
Juuljus
RE: find every different text or data in a column - for Excel,
Ron Coderre
Create named ranges,
loopoo
Issues about making references to a workbook,
Frederick Chow
When do I need Rng.Address(External:=True),
davidm
VB and C# compilation differences,
Alan Roberts
RE: Find defined Name in List, then Goto,
Toppers
Copying a variable selection size ?,
CPhil
Macro to select the result of an autofilter action,
at_my_work
Logical Expression For MULTIPLE Cells???,
triple_c77
RE: Is there a method to find distinct values in a column,
Toppers
Type Mismatch Error Populating Label,
ssjody
Re: pointer to sub,
keepITcool
How to Link value from a Cell to a control in the userform,
Shuvro Basu
Simple Calculation,
Lucifix
date find using find method,
x taol
Re: Columns to Text,
Niek Otten
Excel Cell Sequence,
Carol
smart form,
pgc
.value only to 2 dp?,
dazman
disabling custom buttons during cell edit mode,
Doug Glancy
Access Actions from Excel,
neta
Re: How can I organize values from one table to another.,
Norman Jones
Re: Font color of exact function return in excel should be customize,
Norman Jones
Re: Error,
Tim Williams
Code cleanup help please,
peter . thompson
Another way to trigger a macro?,
Leon
text within a string,
nelg
test for new, unsaved workbook,
Doug Glancy
Mimic Print Preview?,
JK
stopping at text....,
nelg
BrowseForFolder,
pfsardella
Chopping the last 4 characters of a string in VBA,
silkworm
Display issues with upgrade 2000 to XP,
cclambie
ODBC Oracle Table, Delete From Excel?,
nowon
User controls on sheet question. - How to toggle between design and execute mode?,
Hexman
Re: workbook close macro,
Bob Phillips
Re: Saving csv file on Web,
Tim Williams
What type of code do you put in "ThisWorkBook"???,
Hexman
Re: Unlocking and locking a specific cell,
Leith Ross
Re: VLookup,
RB Smissaert
inserting break in code,
papa jonah
form closing with the X,
raw
Add character before 1st letter of string,
al007
Floating toolbar Q - is there a limit to # of icons we can display/use?,
StargateFanFromWork
Bringing up the Unhide Sheet list via macro,
PCLIVE
Re: cant dim as commandbar,
Tom Ogilvy
listbox click event help,
Michael Malinsky
Re: Moving worksheet,
Gazeta
Help simple problem,
b_t_k
uuqal sign in formula bar Excel 2003,
Erik Creyghton
Drop Down Menu with Hyperlinks,
B_Ward
Sumproduct problem,
GregR
date returning time in vba intermediate window,
papa jonah
Re: vb code for running macro from toolbutton,
Bob Phillips
Ordering Worksheets,
PGalla06
Re: How do I do an else if statement?,
Cutter
Dynamic Calculation,
hem3414
Re: Waiting Working,
Dave Peterson
Re: Calculation,
Dave Peterson
RE: Column To Column, Row By Row Worksheet name list,
Kryer
Copying info from one worksheet to another,
oscarooko
Code Error,
ksn
Re: convert from wordperfect to excel,
Pete
Satisfy Cell Requirements Before Printing,
JessiRight77
Having trouble getting 'Local' parameter in SaveAs method to work,
peter . huang
Re: Get Cell Values from Other .xls files,
Ron de Bruin
Accessing external database causing problems?,
Michael Malinsky
Refresh External Data Then All Pivot Tables Based On It,
Dave
Re: Looping through cells using VBA,
Tom Ogilvy
Re: CurDir,
Tom Ogilvy
Stumped,
Andibevan
Re: defaulting to the desktop,
Tom Ogilvy
Re: Items in ComboBox appear "half-sized",
Tom Ogilvy
Checking for Empty Scattered Cells,
Kevin O'Neill
Re: Referring to a Range Based on Selected Rows,
Tom Ogilvy
RE: using command button instead of edit function,
john tempest
Re: Checking Cell Contents,
Tom Ogilvy
- Message not available
- Re: Checking Cell Contents,
Tom Ogilvy
- Re: Checking Cell Contents,
Paige
- Re: Checking Cell Contents,
Dave Peterson
- Re: Checking Cell Contents,
Dave Peterson
- Re: Checking Cell Contents,
Paige
- Re: Checking Cell Contents,
Dave Peterson
- Re: Checking Cell Contents,
Paige
- Re: Checking Cell Contents,
Tom Ogilvy
- Re: Checking Cell Contents,
Dave Peterson
- Re: Checking Cell Contents,
Paige
- Re: Checking Cell Contents,
Dave Peterson
- Re: Checking Cell Contents,
Paige
- Re: Checking Cell Contents,
Charlie
- Re: Checking Cell Contents,
Paige
Creating multiple messages from spreadsheet,
tip2tail
Re: Please help : Macro doesnt work on other PCs,
Tom Ogilvy
Re: Calculating values...,
Niek Otten
Excel programming window user interface,
jean-pierre sarteaux
Re: Fomat (Date, yymmdd) function...,
Niek Otten
How to detect excess rows in txt or csv files before opening?,
39N 95W
Cycling through one column in a range,
mikelee101
Re: Turn AutoFilters Off,
Dave Peterson
Applying FIND Function on a Compound word,
sylink
best way to remove external links,
Gary Keramidas
Re: Sending message via MS Messenger,
Jake Marx
Updating Named Ranges with VBA using a list,
Lee Palmer
Add standard excel button to custom toolbar menu,
Gixxer_J_97
Option buttons: How to get the selected option from a group?,
naddad
pause vba action without using Application.Wait?,
mikesalemi
Re: How do I register my dll complied with ATL to a different PC?,
Kris
Re: Paste Question,
Tom Ogilvy
Code not finding records,
ojackiec
Re: Modified vb - but it won't work,
Bob Phillips
Store hidden information in a spreadsheet,
Remy
Most recent file list,
Mikerosoft
Re: checking for hidden columns,
Mikerosoft
Finding smallest numbers,
Mike7
Re: Split values in one cell and place them in different cells,
kounoike
Re: combine worksheet functions to make macro to automate everything,
Tom Ogilvy
Sheet Name as a Variable?,
Petitboeuf
Import into a Sheet module,
johnhildreth
Email workbook question,
pete3589
xl,
noyb
Re: Append info in all worksheets in workbook in one sheet,
Ron de Bruin
From clumns to rows,
Juuljus
clearing ranges,
newnhamm via OfficeKB.com
- Message not available
- Message not available
Re: 95 Code Conversions,
Jim Rech
Changing a cell without selecting it,
fguyton
Re: macro to create toolbar on open and clear it on close,
incjourn
Analysis ToolPak - enable it programmatically?,
davidfox
Re: Exit from Excel window,
Paul B
how to get updated valued from excel cells?,
B Deepak
Deleting cells,
KtM
Accessing Excel Formula,
incjourn
Email Workseet as Body of email,
sunilkeswani
Paste column as number,
jgabbai
HTML import problem,
mjack003
Re: calling .net dlls,
DM Unseen
Re: Problem with Blocking Dynamically generated UserForm Call,
DM Unseen
Not able to get dialog data of MFC using xll,
Mayank Jindal
[OT] SAP - short question,
Snake Plissken
VBA - Insert Values from listItems to textbox,
Lucifix
Sort Question,
Patrick Simonds
delete macro question,
Gary Keramidas
Very strange ListBox problem,
Patrick Simonds
easy way to check for forbidden characters?,
Ouka
Stretching a userform with the mouse,
Pierre Archambault
must I travel through UserForm_activate event?,
Dave B
Re: For Loops and Named ranges,
Gary Keramidas
programming for advanced filter using external criteria file,
xxx
Re: Centering Text Not Working,
Dave Peterson
Re: vba cut and paste,
lotus
Limiting Functions,
wilro85
Re: How to read TableDefs in ADO,
Tim Williams
Refreshing pivot table from different worksheet,
mandles1
Re: Select All Sheets in Workbook,
Gord Dibben
Re: count data from 2 seperate columns,
Bob Phillips
Re: syntax error,
Dave Peterson
Setting a range within a loop variable for copy/paste,
Craig
Re: VBA access to Active X Scroll Bar,
CodeJunky
arrays,
TheIrishThug
Charting in VBA problem,
jmacclure
populating excel cells with data from data sources,
Craig
Re: Obtani "R1:C1" format of a Range,
Niek Otten
Re: Essbase Causing Selection Change Event to Fire,
keepITcool
Another Atempt,
Saxman
labels on x axis from vba is acting weird,
adullam04-excelgoogle
Auto close the prompt & dialog boxes,
HelpEachOther
When data in TextBox2 matches data in TextBox1,
Maddoktor
Better way to delete macros & other components???,
decc
Filtered Data Refresh,
ssjody
Re: Temporarily unprotect cell then protect afterwards,
Chip Pearson
World Cup,
Bill
calculationstate,
Kris
Re: calculationstate,
Kris
Re: calculationstate,
Kris
Re: calculationstate,
Tom Ogilvy
How to change the source URL of an XML Map?,
rblhome
Needing to select file path with Set command,
mike . wilson8
Possible to sort part of a cell?,
helios02
using xml to specify ranges,
medicenpringles
Pasting Macro,
wilro85
Re: How to suppress Excel default message,
Chip Pearson
Problem assinging FaceID to toolbar,
wschanks
Re: Change fill color based on value of another cell in Excel,
Tom Ogilvy
frequency in VBA,
Dirk
finding row 7,
antonov
recall records,
evgny
userforms showing and hiding,
Laurin
conditional formatting w/ check for beginning odd or even,
barberboy
Re: Xlusrgal.xls,
Peter T
Re: calculate cell formulas during VBA sub,
LenB
Sort without Selecting,
ssjody
VBA on a Hidden Worksheet,
RANDY IN NC
VARIABLES IN ROWS - Help on The Right Syntax,
sylink
Re: Disabling access to MSquery,
Jake Marx
is this possible with a macro....,
sal21
Re: Password protection for an individual form,
Jake Marx
Re: Do you have templates for CRM related issues,
Jake Marx
Removing 1st four rows from a range,
Harry Tuttle
Environ user tracking,
geraintathomas
Add to zip file and email,
krabople
Re: Application Visible,
Mike Fogleman
Going loopy on a loop,
John in Surrey
open Tiff application from excel vba,
ilyaskazi
Re: Auto fit in merged cells,
Norman Jones
Re: Autosave VBA,
Harald Staff
RE: Refreshing MS Query and Excel Pivot Tables using VBA,
K Dales
Extracting from excel to acess database,
Palvin
Re: OFFSET FUNCTION,
Chip Pearson
creating a date format entry from seperate integers,
T . O .
Combo Box List Question,
ssjody
Unable to fill Listbox thru VBA,
rash
Re: opening a blank excel workbook from visual studio express,
Norman Jones
Worksheet_Change funktioniert nicht,
toburz
opening files on network drives via a brouser,
Juuljus
VB editor opens by magic,
dallag
Problems with Array,
systemx
Interesting problem with VBA generated textbox (or textframe of shape) length,
Bill Dilworth
Whatever I do I get the wrong result,
Arishy
changing printer.papersize=vbPRPSLetter,
areddy
Re: autofilter macro in excel2000,
Norman Jones
Calendar (Excel Function or VBA),
Craig
first empty cell,
TheIrishThug
Re: lock a range question,
Rowan Drummond
Border Formats,
Dave
Select empty column & paste - Help please,
saziz
Stk Quotes:: QueryTable is weird ??,
dpenny
Need help resolving error in defining last row,
clmarquez
Re: Error when protecting sheet with cell has seperate password.,
Dave Peterson
Rename a module,
Glen Mettler
need help with formatting data collected from database...,
mandles1
Re: Excel Shapes,
Chip Pearson
This msgbox code works when in Auto_open, but not when called.,
StargateFanFromWork
What am I missing?,
keithb
create new sheets from a header row,
Craig
Help with using OnKey,
keithb
equivalent n´th day in a month,
Mika
Re: macros and column selection,
Chip Pearson
Re: Fill a cell with a data range,
Otto Moehrbach
Re: userform tabs,
Leith Ross
RE: Macro Effecting Formatting,
Jim Thomlinson
Counting a Change in Data in a Subtotal,
stacy
If Function,
jcc31
Commandbutton caption change,
peter . thompson
Delete row if value in another workbook,
d4m
Sorting,
Dave Unger
- <Possible follow-ups>
- Sorting,
Dave Unger
Re: Allow only Hyperlinks,
Tom Ogilvy
Add closed workbook filenames that meet certain criteria to a message box,
rdblatch
Re: Saving Values,
Tom Ogilvy
How to use Alt keys + symbol keys to invoke a macro?,
keithb
Error when No data to paste,
halem2
removing blank entries from an array,
TheIrishThug
How to add a public subroutine to a class module,
keithb
Data validation and empty cells,
Kris
Transpone Excel tables with macro/VBA,
onuytten
Find/Replace built-in dialog in XP,
kevboy
Automatically Setting Row Height with Merged Cells,
katherineolson
Re: Extracting info from a string using VBA plz,
JE McGimpsey
last column..?,
saziz
Analysis Toolpak appears loaded, but isn't,
johnhildreth
Re: Referencing a sheet in VLOOKUP,
Dave Peterson
Re: Changing sheet references in formulas,
Niek Otten
<Possible follow-ups>
Re: Changing sheet references in formulas,
Chip Pearson
Before & After Refresh,
JakeyC
Split Cell Into Seperate Rows,
Andibevan
Re: windows macro,
Jim Rech
Inserting Pictures into cells,
karaeloko
Need to find a match,
adamkane
Expediting Tedious Work,
mikemillsjr
Re: how do you sort two columns; data and headers,
Ian
2 Files open - Paste to One,
cfatz1
Face ID error, any suggestion?,
Rock
Re: sending email without outlook messages,
Ron de Bruin
Re: ____ Return file path via APIs !!!!,
Tom Ogilvy
Re: counting with three conditions,
Tom Ogilvy
Re: HOW CAN I APPLY CONDITIONAL FORMATTING BASED TO AN ENTIRE ROW?,
Tom Ogilvy
RE: Help required to code a '% of total' column,
overcanyon
Re: Problem with formulas updating,
JE McGimpsey
Formulas don't update?,
Brian Matlack
RE: Find then GoTo problem code,
chijanzen
Weeknumber of calendar date?,
NorTor
Return a value if 2 Conditions apply,
John
VB Code to 'read' .txt files and display info in Excel,
Petitboeuf
Problem transferring array data onto worksheet using Resize,
Ken Johnson
- RE: Problem transferring array data onto worksheet using Resize,
Toppers
- Re: Problem transferring array data onto worksheet using Resize,
Ken Johnson
- Re: Problem transferring array data onto worksheet using Resize,
DM Unseen
- Re: Problem transferring array data onto worksheet using Resize,
Ken Johnson
- Re: Problem transferring array data onto worksheet using Resize,
Alan Beban
- Re: Problem transferring array data onto worksheet using Resize,
Ken Johnson
- Re: Problem transferring array data onto worksheet using Resize,
Alan Beban
- Re: Problem transferring array data onto worksheet using Resize,
Ken Johnson
- Re: Problem transferring array data onto worksheet using Resize,
Tom Ogilvy
- Re: Problem transferring array data onto worksheet using Resize,
Tom Ogilvy
- Re: Problem transferring array data onto worksheet using Resize,
Ken Johnson
- Message not available
- Re: Problem transferring array data onto worksheet using Resize,
Ken Johnson
RE: Restoring the Recently Used File List,
Peter Rooney
Re: open workbook from a macro and continue this macro afterwards,
Norman Jones
Summing column w/o VBA. Help.,
alvey
Import an Image into Excel using VB.Net and Option Strict On,
Jedawi
Date in text box reading mm/dd/yy instead of dd/mm/yy,
Maddoktor
Re: .txt In .xls out Macro,
Dick Kusleika
Minimize Excel also hides all User Forms,
Tom Snoiker
Re: Distribute XLT - don't want to do it individually on each machine,
NickHK
How to calculate data that is entered into a text box,
Maddoktor
How to add a button in Excel tool bar in order to run my macro?,
Terry
Re: How do you add a treadline to a chart in excel?,
vandenberg p
Sub cannot run (Error 5),
Max
Re: Sub cannot run (Error 5),
kounoike
Re: Sub cannot run (Error 5),
Dave Patrick
Re: Sub cannot run (Error 5),
NickHK
Re: Opening a template.xls using VBA code.,
Tom Ogilvy
Macro to copy 2 columns to new spreadsheet each new day,
Joan
Re: funcres(funcres.xla),
Dave Peterson
Re: Having trouble combining 4 cells with formulas into one cell formu,
Bob Phillips
Re: Adding Sub Menu Item to Current Custom Menu,
Bob Phillips
If Then Else with Exit For,
goss9394
Debug Excel 2003,
Wild_Jim
Please help. Yacht Race Handicap Median?,
Cathy
Save file as filename plus fieldname,
annep
Macro help for goal seek,
Dean
Subtotal and running/cumulative total!,
rahul25
Delete Entire Row If Q,
John
BorderAround method failure,
johnhildreth
Re: Highlight active range?,
Bob Phillips
Re: Stop users from accessing "Protection" option from "Tools" menu,
Chip Pearson
Help - Can VBA bypass and open excel as read-only?,
Acube
Help - Can Excel create a text file??,
Acube
removing commas from a string,
TheIrishThug
Goto misused: help to tidy Code,
davidm
Re: Shell Synchornous?,
Ron de Bruin
Re: Run Macro on Cell Change Error,
Dave Peterson
Power of Macros,
Mr_Flamenco
Is .Select ever needed?,
John Coleman
Biggest commercial .xla file?,
RB Smissaert
Help With code,
Greg B
Consolidate Ranges into 1 Workbook,
John
- Re: Consolidate Ranges into 1 Workbook,
Mike Fogleman
- Re: Consolidate Ranges into 1 Workbook,
John
- Re: Consolidate Ranges into 1 Workbook,
Mike Fogleman
- Re: Consolidate Ranges into 1 Workbook,
Ron de Bruin
- Re: Consolidate Ranges into 1 Workbook,
John
- Re: Consolidate Ranges into 1 Workbook,
Ron de Bruin
- Re: Consolidate Ranges into 1 Workbook,
John
- Re: Consolidate Ranges into 1 Workbook,
John
- Re: Consolidate Ranges into 1 Workbook,
Ron de Bruin
- Re: Consolidate Ranges into 1 Workbook,
John
- Re: Consolidate Ranges into 1 Workbook,
Ron de Bruin
- Re: Consolidate Ranges into 1 Workbook,
John
- Re: Consolidate Ranges into 1 Workbook,
Ron de Bruin
- Re: Consolidate Ranges into 1 Workbook,
John
- Re: Consolidate Ranges into 1 Workbook,
Ron de Bruin
Change the level of protections (MAKRA),
And1
Re: Count times between 2 times and 2 dates,
Max
Refreshing Web Query Problem,
andym
For better Performance in VBA for Excel - Strings manipulation OR Objects manipulation,
vmegha
adjusting a VB script to my needs,
DPeter2101
Positioning on a sheet,
Roger B.
Re: Excel-VB Macro Variables,
Norman Jones
Re: Assistant NewBallon formatting,
AH·C
Re: drop dowm menu for excel workbook worksheets.,
Tom Ogilvy
Re: More bills,
Steve
List Files in a Directory,
plantechbl
Re: How to add selected row into listbox?,
Leith Ross
Re: Moving a Selection of Data???,
Leith Ross
Securing an Excel application,
johnhildreth
Still having problem with IF-Then statement,
excelnut1954
Nearly There! (Revisted),
Saxman
Re: Date Format??,
john
Re: Using R1C1 in VB to select a range,
john
Application for scheduling students?,
Arnold
RTD server with VC++,
Xing
Start a new session when a session is already opend,
MD
adding functions to drop-down items,
oberon . black
Format Cells Dialog Box won't display!,
Dave B
Better codes to run faster?,
taych
macros and cells,
frustrated
Right click menu,
Mats.Bergstrand
Re: Zipping the current Excel Spreadsheet with PkZip,
Ron de Bruin
- Message not available
- Re: Zipping the current Excel Spreadsheet with PkZip,
Ron de Bruin
- Re: Zipping the current Excel Spreadsheet with PkZip,
David
- Re: Zipping the current Excel Spreadsheet with PkZip,
Ron de Bruin
- Re: Zipping the current Excel Spreadsheet with PkZip,
David
- Re: Zipping the current Excel Spreadsheet with PkZip,
Ron de Bruin
- Re: Zipping the current Excel Spreadsheet with PkZip,
Ron de Bruin
- Re: Zipping the current Excel Spreadsheet with PkZip,
David
- Re: Zipping the current Excel Spreadsheet with PkZip,
Ron de Bruin
- Re: Zipping the current Excel Spreadsheet with PkZip,
David
- Re: Zipping the current Excel Spreadsheet with PkZip,
Ron de Bruin
- Re: Zipping the current Excel Spreadsheet with PkZip,
David
- Re: Zipping the current Excel Spreadsheet with PkZip,
Ron de Bruin
- <Possible follow-ups>
- Re: Zipping the current Excel Spreadsheet with PkZip,
Myles
Simple MultiColumn Sorting,
Jaemun
Customized spin button,
Carim
RE: memory issues,
Greg Wilson
Custom Lookup Function,
Greg
Checking info against cells containing multiple values,
systematic
Change commandbutton text from userform,
peter . thompson
Commandbutton backcolor change on event,
peter . thompson
Re: How do I compare two arrays of numeric strings?,
James D. Connelly
New here so be gentle,
James D. Connelly
personal.xls,
Brian2577
Re: protect a cell based on values in range,
Leith Ross
Re: excel video,
Robin Hammond
AdvandcedFilter - Oh I need help,
Bob Sandor
Combine Workbooks,
LRL
I should know this but ...,
keithb
Array sort,
kenrock
Change the interior color of a cell - Code Review,
Tiny Tim
permanently add library reference,
Loane Sharp
Flow of control from UserForm to Sheet1 sub,
excelnut1954
Re: CurrentDate + 3 months (arithmetic with dates???),
Bob Phillips
Re: Automate Page Header Text,
Dave Peterson
Re: Excel Automation from Access,
theDude
Re: How do I close/exit Excel programmatically,
Tom Ogilvy
Re: WHERE CAN I FIND N JOBCARD TEMPLATE,
Tom Ogilvy
How to Separate an email address,
Bert Kinney
combobox fill problem,
Pierre via OfficeKB.com
Re: excel web queries: make the box for the website name much longer,
Don Guillett
Re: Custom Button - Excel Add-in,
Leith Ross
Re: counting instances of a character within a string,
Chip Pearson
Excel 97 modules appear as tabs,
Kate
Error 13 on many trim with cells started with +,
pcouas
Re: Commandbars,
Bob Phillips
Re: Userform level class instance doesn't recognize methods,
Peter T
naming worksheets,
jerrystan
Last 2 files joined together,
Michael Smith
Re: Function to return interior colour of a cell,
Norman Jones
Re: range values in an array?,
Niek Otten
Re: Dependent Macro/Toggle Buttons,
Tom Ogilvy
Re: Simple loop problem,
Don Guillett
Re: How to convert ANSI to excel?,
Tom Ogilvy
Re: ? how to pull data from another sheet based on value,
Tom Ogilvy
Re: VB for Deleting Rows in Excel,
Ron de Bruin
- Message not available
- Message not available
Re: Do not copy code from template,
Tom Ogilvy
Re: Sum only visible cells,
Tom Ogilvy
Event Trigger,
lobo
Re: macro don't execute a step in the code,
Andrew Taylor
Analysing outlook calender,
Dave
wksht name as current date - m-d-yy,
craig_100
Copying a formula in a blank column as far as data in previous column,
basildon
Protected Sheet Problem in Excel 2000,
JG Scott
Tables from PDF to excel,
marksuza
VBA Code Required to Get Data Which is In Coloums Into Rows,
stublair
Running macros automatically,
frustrated
Garbage collection in VBA,
Edward Ulle
Format Decimals and Whole Numbers,
Lankchevy
Re: reference format Range(Cells(),Cells()),
Norman Jones
compile error HELP !,
Pierre via OfficeKB.com
Blue moon,
Chuck
How do I edit a selected range then copy the range into an new sheet???,
dwyborn
Re: How to distribute macro signature certificates in a domain?,
NickHK
Open Form (VBA Running) and Application.OnTime,
Ronald Dodge
VBA projects!! Aaaargh!,
MattShoreson
Custom Dialog Boxes,
iambalrog
Macros that:Email,FindNext,
iambalrog
Embedding excel files into Outlook emails,
lithium81
Block If,
DA@PD
Get info from changing cell to a static cell ??,
Maxibo
- Re: Get info from changing cell to a static cell ??,
Ken Johnson
- Re: Get info from changing cell to a static cell ??,
Ken Johnson
- Re: Get info from changing cell to a static cell ??,
Maxibo
- Re: Get info from changing cell to a static cell ??,
Ken Johnson
- Re: Get info from changing cell to a static cell ??,
Maxibo
- Re: Get info from changing cell to a static cell ??,
Maxibo
- Re: Get info from changing cell to a static cell ??,
Ken Johnson
- Re: Get info from changing cell to a static cell ??,
Ken Johnson
- Re: Get info from changing cell to a static cell ??,
Maxibo
- Re: Get info from changing cell to a static cell ??,
Ken Johnson
- Re: Get info from changing cell to a static cell ??,
Maxibo
- Re: Get info from changing cell to a static cell ??,
Ken Johnson
- Re: Get info from changing cell to a static cell ??,
Ken Johnson
- Re: Get info from changing cell to a static cell ??,
Ken Johnson
- Re: Get info from changing cell to a static cell ??,
Maxibo
- Re: Get info from changing cell to a static cell ??,
Ken Johnson
- Re: Get info from changing cell to a static cell ??,
Ken Johnson
- Re: Get info from changing cell to a static cell ??,
Ken Johnson
- Re: Get info from changing cell to a static cell ??,
Maxibo
- Re: Get info from changing cell to a static cell ??,
Ken Johnson
- Re: Get info from changing cell to a static cell ??,
Maxibo
- Re: Get info from changing cell to a static cell ??,
Ken Johnson
- Re: Get info from changing cell to a static cell ??,
Ken Johnson
- Re: Get info from changing cell to a static cell ??,
Maxibo
- Re: Get info from changing cell to a static cell ??,
Ken Johnson
RE: I would like to have a cross in my checkbox rather than a tick,
Greg Wilson
CommandButton color change on event,
peter . thompson
Deleting VBA programs,
paulrm906
Range().Select not working,
clmarquez
Variable in MsgBox?,
TheIrishThug
How to detect MS Word or MS Access calls MS Excel using VBA,
Bon
Extracting formula instead of result from cell,
lithium81
locked link,
ashcrusher
Control disappeared problem - specifically, the Calendar Control,
JMMach
Re: how to create a msgbox showing progress of macro,
Rowan Drummond
Different syntax for Application.Wait,
Desert Piranha
Re: Lookup in an array,
Edward Ulle
Format cell based on adjacent cells values,
the majestic ferny
Re: Module Error,
Dave Unger
How do I format a specific column of cells to have a limit aount of characters?,
limshady411
File exists under directory,
PeterW
Re: Working with arrays,
Dave Peterson
How to separate words by comma,
wliong
Disable a Macro,
Dave
Re: I get run time error '5' when I run this code. any sugestions?,
Leith Ross
RE: Finding String Using Vlookup,
Jim Thomlinson
Re: Variable procedure call,
Dave Peterson
mp3 tags,
Darren Hill
HOw can I use Copy and Paste Function,
whygh
Format Page Field,
TheVisionThing
How to update last save time & last author for each worksheet,
the majestic ferny
Removing a Form from VB Automatically,
Trey via OfficeKB.com
Count multiple condition,
whygh
Re: Ignoring reference errors,
Jim Rech
Re: Changing Module names,
Jim Rech
Inserting a Row with a Variable Row Number,
Izran
Re: Format Number to Text,
Leith Ross
looking for the empty cell,
dok112
intersection of named ranges,
Dave B
Finding Name associated with Abbreivation,
rrstudio2
Re: HELP! Get error while saving after password protection,
Tom Ogilvy
Hyperlink path into a adjacent cell,
DARREN FONG via OfficeKB.com
Please Help Correct my code,
saziz
Dynamically obtaining a range from another range,
Sharad Vyas
Re: Help with Excel VBA Programming,
Paul B
Re: I need to change this code to copy All files the "customdoc" folde,
Bob Phillips
Re: macro for copying formula,
Ron de Bruin
colors,
antonov
RE: How do I insert a variable for the file/path in aQuery Table?,
Martin Fishlock
How can I get rid of the pathname?,
Jos Vens
Entirerow.delete based on multiple cells,
tom
Renaming Worksheets,
tcgaines
Re: Taxi scheduling database using Excel?,
Tom Ogilvy
If statement not working,
excelnut1954
Excel Marco Startup Problem: Run-time Error 91,
ambroze
Trust VB projects setting Grayed out,
David Liebtag
Call secure web services from Excel 2003,
mron0210
Re: it's a question for access,
Dave Peterson
Re: Launching Excel macro for every workbook opened.,
Dave Peterson
CheckBoxes how to remember changes,
p. panter
Re: Moving post code data to a different column,
Norman Jones
Summing cells by background colour,
frustrated
Include Worksheets From Workbooks into ONE new Workbook,
tcgaines
Re: XLSTART doesn't open PMW,
Dave Peterson
Get the name of all workbooks open from access,
Xav
Re: Copying worksheets in VBA,
Ron de Bruin
Hyperlink,
Greg B
Re: Creating an array formula in vb,
lmn55378
Permission denied in CreateObject(Excel.Application"),
Leo
Need macro to insert workbook into another workbook using input box,
newnhamm
Maintaining formula while clearing the cell,
Sharad Vyas
RE: Maintaining formula while clearing the cell,
"Peter Huang" [MSFT]
Deleting cells in a column ref a different column,
Daminc
Defining a range and use it's value,
Petitboeuf
Input Dialog Box - Simple Question,
sharpie00
Disable Macros when loading a Workbook in Excel 2000,
Remy
Need pivot table to automatically highlight subtotal rows,
jim37055
Text File Encode to UTF-8_Unicode specific,
miromirc
user difined inputbox,
Brian Matlack
string convertion to date problem,
Rolo
Excel range choose button in VBA form,
Philipp
Combining values from multiple spreadsheets,
Pete
Dynamic pivottables,
KtM
Re: Print Form,
Jim Rech
How to Display the The Insert Picture from Scanner or Camera dialog box,
Browie
Inserting image,
Browie
redim preserve,
RobcPettit
Re: Open another file,
Mike Fogleman
Saving values during installation of Add-In,
Red
Timer code,
pmguerra
conditional sum,
Pierre via OfficeKB.com
hook into worksheet events temporarily?,
Alex Popescu
Global Variable in Excel VBA,
loopoo
matching column and return vlue...,
sal21
error 1004 Range object,
Tony James
How to disable MS Excel Clipboard message when I run a macro,
Bon
Re: execute a macro,
Bob Phillips
Find User Default Email Address in Outlook,
aph
Checking for existing worksheet name,
KtM
Re: I want to change a cell reference based on where the cursor is.,
Nick Hodge
Re: How do I copy a folder from a server using a macro,
KtM
Re: Adding sound clips into Excel,
ilyaskazi
How can send email with Foxmail?,
Samuel Kuo via OfficeKB.com
Re: Macro VBA help please,
MisterEd
Copying discontiguous ranges to Word,
Garry
activate workbook if condidtion is met,
AD108
Force File Name Convention,
AD108
Help with Loop,
Joe Fish
Find Next is not working for me.......,
Tom
- Message not available
- Message not available
Can I detect a KEYDOWN event while in a worksheet,
Ken Soenen
Help with CommandButton vs Excel 2002,
YoungGuy
Re-number drawing object references,
Gunny
VBA for Home key,
Alistair Saldanha
Re: Update Formulas on Consecutive Sheets in a Range,
Dave D-C
ClearContents or ClearFormats also clears Clipboard. How can I keep the clipboard?,
rlaemmler@xxxxxxxxx
IS there a way to find the name of GIF file over Excel cell,
gggkkk
Help: How do I create a column of fixed width data?,
limshady411
Need a solution,
AD108
Date + one year,
Oldjay
Produce the name of the named range of activecell,
L. Howard Kittle
RE: How to create a macro that deletes every blank row in a spread,
Grd
RE: header formatting,
Mike
quick code needed,
saziz
Show/Hide Userform erases global vriables,
Dave D-C
Nearly There?,
Saxman
Re: Nearly There?,
PY & Associates
Event triggered by paste,
johnhildreth
string values do not equal cells, then return msg,
Kevin O'Neill
Calling worksheet module from other module.,
Michael Malinsky
Merge Workbooks?,
AD108
Re: Program a macro to run at specific instances,
Bob Phillips
Re: how save workbook without Do you want to replace it?,
mfq
return "nothing" from UDF,
Rob Kings
Finding Links in a large spreadsheet,
jase
GetObject Equivalent for Internet Explorer?,
spaceman
Getting inconsistent Error 91-Object variable or With block variable not set,
mfq
Working with application path,
Nirmal Singh
GetObject equivalent for IE,
spaceman
Macro doesn't run ?,
Brian Matlack
Toggling Button Labels Between Expand/Collapse,
thomas . utley
RE: Adding cells that meet certain criteria,
Charlie
Is there a function in VBA to find out if entire column is empty?,
HelpEachOther
User defined msgbox,
Brian Matlack
Re: Hiding rows and columns,
Bob Phillips
How do I use an activecell as coordinates for pasteing?,
wilro85
Re: Auto Open - Clear all filters,
Dave Peterson
Change CommandButton Picture,
TheVisionThing
VBA Code for Multiple VLOOKUPS,
Myrna Rodriguez
Importing CSV into Excel sometimes truncates text at 256 characters,
newsgroups
How can I easily add an apostrophe to the beginning of an entry in a cell for multiple rows?,
alisha . kiyomi
Re: Macro creation,
Paul B
Making it not look like excel????,
raw
Re: Windows On/Windows Off,
Remy
Trouble with Average function,
Terry K
Range(0,0).Select ?,
Bill Martin
RE: Exclude specific wks in FOR EACH wks Loop,
Dean
Macro based on check box,
gmunro
RE: Removing reference generates type mismatch error,
quartz
Excel settings,
PGalla06
Problems of list box property,
*¡¸ My-Ricky ¡¸*
Running a variable macro when any value is entered into a variable cell,
Iain . Poulson
Workbooks.Open problem,
Xav
search and write.,
myguess21
conditional addition,
DKY
Re: identifying blank cells by a colour,
Norman Jones
Excel to HTML,
Nicholas Edivan
Workbook before close problems,
st120869
Macro in Excel: pick next 7,
Maciel
Re: Override dialogs on SaveAs (tab-delimited),
cvsanty
Read directly a returned array in the calling routine,
Jean-Pierre Bidon
Projects remain in VBE even after closing workbook,
GoFigure
List Folders using Excel,
Andibevan
how to split a string and return array,
xiang
permanently add reference to ADO library,
Loane Sharp
Hyperlink within Textbox(UserForm),
Soniya
Re: Making print range dynamic in macro,
keepITcool
Opening a large HTML document in Excel - slow,
PJL-2005
Enabled macros,
raw
How to identify text (compare) in one sheet, then move it another,
mag7417
Solver,
Angeliki
RE: Impossible to find error,
Philip
Out of memory error,
funkymonkUK
Looking up dates,
alymcmorland
Re: Run Word from Excel VBA,
Kaak
export charts,
tommy_gtr
how to select row according active cell?,
frankosun
RE: How can I select random whole nos from 1-16 without repeating?,
Patrick Molloy
Saving or not a spreadsheet,
Dean
Q: how to use UsedRange correctly?,
alex
Outlook express email reader,
RosH
histogram analysis,
dantecat
Running procedures on events xl2003,
ragtop73
callbyname in XL 2K and XL 2003,
Doug Glancy
Newbie Q: Range from two cells,
Garry
Copy paste not working after save of worksheet,
rlaemmler@xxxxxxxxx
Calling a different worksheet???,
Tywardreath
VBA code: call subprocedure,
Terry
Security for VBA codes,
excelnut1954
Re: Delete row if "Not" macro,
Dave Peterson
Cut and Paste Jumping,
wilro85
Re: How to handle cancel when using the inputbox method,
Rowan Drummond
Need help - track changes code needs tweaking,
purpleme3
Exporting VB Forms Automatically,
aVBgrad
Trying to Append File using the example in excel but not working,
Susan Hayes
Disable a macrobutton for a particular cell change?,
lotus
Problem with setting Interior Color in VBA,
cneumann
Compare data strings?,
Ed
Re: while loop?,
Ed Ferrero
ActiveSheet.PageSetup.Zoom,
wci
VBA Macro for VLOOKUP,
Myrna Rodriguez
Disabling menus,
Avi
Re: no workbooks open,
Ron de Bruin
How do I convert a Formula into Code???,
BigH
How to stop the 'select sheet' window pop up,
deepakmehta
Re: Auto-Filter on multiple worksheets automatically via VBA,
Tom Ogilvy
Colorindex referencing,
gtslabs
Find,
tkemo569
Re: Deleting rows older than current date and inserting a new row,
Dan E.
VLOOKUP Closest Match Not Close Enough,
Ronster
Auto Filter Question,
Smonczka
Re: GetOpenFilename,
Bob Phillips
VBAProject name compile error, not defined at compile time,
Matthew Dodds
Re: indirect macro,
Bob Phillips
Req: Help requested with Macro problem and syntax errors (any fisherman out there!!),
bob M
Re: Checking whether .xls file was just opened from a template,
Tom Ogilvy
Re: Zipping a Protected Workbook,
Ron de Bruin
Prevent others from running my macros,
Frederick Chow
Re: change event problems,
Norman Jones
RE: Very speciel function,
Toppers
Retrun a worksheet from a function,
Jean-Pierre Bidon
Re: Setting print area within macro,
Tom Ogilvy
Find?,
And1
Find text in Column or Range Name,
Lankchevy
Invoice directly from EXCEL?,
vv
Find File By Name,
EMoe
Re: Extract Day of Week from Date in VBA,
Tom Ogilvy
Re: VBA code to send a system message?,
booner
Code for Printing Discontiguous Ranges,
GoFigure
Copying Several Sheets To a New Uniquely Named Workbook,
soteman2005
I need help ASAP!!,
enak
Re: Changed or Updated property?,
Tom Ogilvy
Re: HELP - Automatic Conditional formatting,
Tom Ogilvy
Change column width according to specific cell content,
RosH
Protect sheet,
Gordon Humphreys
Re: How do I create a formula to move data to a different cell,
JE McGimpsey
Re: Using VBA to disable macros when opening files,
patrikj
Bad code,
Oldjay
Re: Cell Formula vs Cell Value,
Tom Ogilvy
Re: Aborting Execution Before Error Message,
Norman Jones
Re: Macro to change database format.,
Tom Ogilvy
Re: Form Check Boxes an a worksheet,
Norman Jones
calling procedure,
Juggernath
How to disable CTRL key,
Bon
Overflow,
Erik Beck Jensen
Re: Original pathname from &path,
Bob Phillips
UDF Question,
Rob Kings
enable right click,
tommy_gtr
Re: VBA - Check for password protection,
Norman Jones
calculating values in cells,
antonov
Problem with Statistical UDFs,
pablocampbell
Re: How convert a cell subtype? (from vbDouble to vbString),
Rowan Drummond
cell format changing when when using search and replace.,
someone
Re: Understanding Menu Item,
JE McGimpsey
overwrite previous saved data,
oOpsy
RE: timeout on GetSaveAs?,
Vic Eldridge
Determine if Integer is Odd or Even,
GoFigure
Custom "conditional" format ?,
Don Wiss
Re: Commandbar Positioning,
Rowan Drummond
Selection of UserForm through button,
saziz
the most frustrating control,
medicenpringles
Need some help,
Gavin
Re: Populating list box with number format data,
Leith Ross
Exporting from Excel,
HSalim[MVP]
Re: dynamic control combo box,
Rowan Drummond
Very serious question !!!,
And1
How to set the entire selection to a specific value without using VBA,
Koye Li
Re: Writing data to SQL server,
David
Re: automatically copy first 12 characters in one field to another?,
STEVE BELL
Re: Another Error 91 question!?,
Tom Ogilvy
Re: copy from previous page,
Tom Ogilvy
Re: Open file pop-up (network),
Tom Ogilvy
Re: Creating a "pop-up" box,
Bob Phillips
RE: Import External Data Wizard,
wgl
Attn: Tom Ogilvy (Please),
Teerings3
Copy Row To Another Workbook If . . .,
Rekanix
Opening file saved as current date,
Yepp12
user forms,
steveshos
Re: Comparing Cell Contents using a Case statement,
Tom Ogilvy
Problem with criteria when usign worksheetfunction,
Alvaro Silva
Re: Convert formulas to values on save,
STEVE BELL
sorry left out details (In Detail Please Help),
Teerings3
In Detail (what ever works please help),
Teerings3
Re: can we call a Sub in another opened vbaproject?,
Tom Ogilvy
Re: Declaring Procedure Variables,
Tom Ogilvy
data validation on other sheet,
Pierre via OfficeKB.com
Count If Multiple Criteria is Met,
stacy
Displaying Tree Structure in List Box,
King
Re: What method do you use to save/store your developed code?,
Paul B
Re: conditional formatting,
Bernard Liengme
Re: How to define a Named Range in VBA?,
Bob Phillips
Vba dreams: insightd needed,
Ambrosia
compare column1 with column2,
myguess21
RE: Create and import filename list into excel,
Jim Semaj
Re: Range Address Memory Variable Limitation,
Tom Ogilvy
sorting data in 2 columns on column 1,
Pierre via OfficeKB.com
Re: how do i open a zip file using a macro,
Tom Ogilvy
problem formulas,
Pierre via OfficeKB.com
Message not available
Excel has generated Errors,
Denz
Creating simplest Excel Hangman,
nauman612
Problems with simple print macros,
ben_hur
Re: Macro with Essbase Add-in,
King
Please...I beg HELP,
Teerings3
Referencing worksheet controls,
Frederick Chow
Re: How do I write code to preserve variables values for future use.,
Frederick Chow
Re: Pull data from inactive worksheet,
Tom Ogilvy
Re: hyperlink in cell,
Tom Ogilvy
lookup value and print all instances,
kanuvas
Screen resolutions and resizing forms,
Ken Soenen
Adding a Line using VBA,
tkemo569
=indirect,
Teerings3
Export as Textfile with VBA,
moondark
Worksheet Sort,
Vicki
DateDIFF,
Paul Breslin
Excel Ping Command..via web...,
HickoryShade
msgbox answer,
Duncan
Timer Event,
Saxman
How to do the following by pressing the down arrow or up arrow key?,
cyberdude
Performance Improvements while using RTD,
aadyaa
Re: Concatenate two variables (String & Integer),
keepITcool
add a formula to a formula,
barkiny
Re: Initiate a form on the selection of a particular cell of a workshe,
Bob Phillips
Defined Name Box Shortcut,
hamiltonrr
VBA to refer to a cell in a different file,
dazman
Finding and Amending a record,
Duncan
WebQuery(local),
KtM
Macro to record user name and date/time,
Maddoktor
Re: cell backgroundcolor,
keepITcool
cells in clippboard?!?,
Juggernath
How to make created button move with scrollbar?,
Bon
Help: Activecell within Do loop problem,
DavidShepherd
Form job,
DennisG
Finding the Path to the Program Files Folder,
JGS
Creating a loop,
shart
Question??Searching form,
frankosun
Missing condition after solver called by macro,
samkut
Cube Root of a Negative Number fails in VBA?,
jksmurf
Re: Cube Root of a Negative Number fails in VBA?,
Tushar Mehta
can someone simplify this file listing for me,
Gary Keramidas
interpolation in an array,
gnanapragasamv
- Re: interpolation in an array,
vandenberg p
- Re: interpolation in an array,
vandenberg p
- Re: interpolation in an array,
gnanapragasamv
- Re: interpolation in an array,
keepITcool
- Re: interpolation in an array,
keepITcool
- Re: interpolation in an array,
Peter T
- Re: interpolation in an array,
Peter T
- Re: interpolation in an array,
keepITcool
- Re: interpolation in an array,
Peter T
- Re: interpolation in an array,
gnanapragasamv
- Re: interpolation in an array,
Peter T
- Re: interpolation in an array,
Peter T
- Re: interpolation in an array,
Peter T
- Re: interpolation in an array,
gnanapragasamv
Extracting unique entries and assigning it to a named range,
Hari
Adding A Date Command Button,
hazey
RE: Zoom Property - 1004 Error,
David
What's wrong with this SQL join statement????,
Hexman
Coefficients of trendline,
Phung Anh via OfficeKB.com
Moon rise/set,
Dennis Allen
Re: Delete selected range,
Tom Ogilvy
VBA to allow a folder to be a shared folder,
Shane
Match,
Teerings3
WorkBook links on a new drive,
tcmill
Update Sheets from Master (two questions),
Scott
Re: Offset to New Sheet,
Bob Phillips
Money in the Bank?,
AD108
Custom Menu Item Randomly "Checked",
durex
how to give values to non-continguous cells simultan