microsoft.public.excel.programming
- Saving date created with =Today()?,
BrianG
- Macro to copy previous row and insert two blank rows,
dd
- Re: Number generating an error,
JE McGimpsey
- Macro Compatibility,
ARCUser
- Re: Substituting substrings,
Ron Rosenfeld
- Re: "That name is not valid",
Dave Peterson
- help plz in sorting out the error in problem,
nitn28
- Grouping,
bradleygcarman
- Inscrutable error,
Jim Berglund
- Click-Sort Button: Dealing With Now-Irrelevant Subtotals?,
PeteCresswell
- Controling Word from Excel,
Oggy
- Re: Using Script to download from secure site,
Dave Miller
- dbf Database 5 file access problem with Excel,
Riddler
- Re: Preventing Invalid Characters using data Validation,
Susan
- Re: default value of a control,
Susan
- Compile error in hidden module: [user form name] Excel/VBA,
Carlos
- End If without Block If Error Help,
Bull
- Evaluating if a Shape is a line or a shape,
Sanjay
- Open Workbooks present in the same directory,
cbalajii
- Run Time Error"13".. Mismatch..help plz,
nitn28
- Re: myCell.Row?,
Ron de Bruin
- How Do I Copy Cells From One Sheet To Another,
AshParr
- vlookup grabbing same data for each row,
jeff . white
- Re: Counting/Changing multiple buttons?,
Peter T
- By selecting a cell - change color in a range,
hampster
- "Unable to get Pivot Tables Property of Worksheet Class "Error,
cbalajii
- Copying and Pasting between Two workbooks,
cardan
- Re: VB for multiple filters,
Dave Peterson
- Re: Printing to Dot Matrix,
Dave Peterson
- Re: Help w/ modifying code... pull down menu,
Bob Phillips
- Re: "after update" type macro,
Bob Phillips
- Re: Rename a Module,
Bob Phillips
- Need help copying data from one column to specific columns,
mark@xxxxxxxxxxxxx
- Application Error,
Brent
- A Simple Block Diagram UserInterface,
John Broderick
- 1004 - Move Method of Worksheet Class Failed,
Buddhaful
- "Error 1004 Unable to set the ColorIndex property of the Interior.,
Bob Barnes
- Re: Close 2007 add-in from code,
Bob Phillips
- Need help with Error 'object variable or with block variable not set',
Francois via OfficeKB.com
- Select Half a Worksheet,
Battykoda
- Help with Simple Excel Loop,
mixsingh
- Re: Using an excel built in function in a Macro,
Ron Rosenfeld
- VBa code for index(linest),
nitn28
- App_WorkBookBeforeClose(),
kalyani . deepa
- Re: Using Hebrew in a Macro,
NickHK
- insert a row for every 20,000 th row?,
elaine
- for each doc in dir, copy data to excel,
Max Bialystock
- Re: problems with hidden sheets in for each,
NickHK
- Incorrectly getting "Subscript out of range" Error.,
Andrew
- Macros in Excel,
Your . Friend . Vikass
- RE: Worksheet Comparison,
LoveSunnyDay
- here is my code...it's running a bit slow though..any ideas to make it more efficient? thanks,
Zarlot531
- Re: print-out time,
NickHK
- Re: Changing Font Name in Function Sub,
NickHK
- Help!!,
Jim Berglund
- Spin Button to Change Label between Normal and BOLD,
Corey
- XlTable format with Unicode,
Chris Trengove
- Parsing a string into an array?,
Dave F.
- Formatting date in footer,
jayray
- using functions,
Sanjay
- Re: If text found in Row, delete Column,
RB Smissaert
- add to a cell with a button,
Donny
- Worksheet with its own toolbar,
Francis Hookham
- Creating Intermediate Date Values - New Problem,
Jim Berglund
- Automatic Filesave using Loginname,
SU
- Re: Crash if two programs run at the same time?,
Otto Moehrbach
- Help with a Regex Pattern,
bob . eastman
Form Show,
kirkm
Find the last used Row on a Worksheet,
kirkm
Object Serialisation,
pinkfloydfan
- Message not available
- Message not available
Creating intermediate date values,
Jim Berglund
- Re: Creating intermediate date values - reformatted,
Jim Berglund
- Re: Creating intermediate date values - reformatted,
Joel
- Re: Creating intermediate date values - reformatted,
Jim Berglund
- Re: Creating intermediate date values - reformatted,
Joel
- Re: Creating intermediate date values - reformatted,
Jim Berglund
- Re: Creating intermediate date values - reformatted,
Jim Berglund
- Re: Creating intermediate date values - reformatted,
Barb Reinhardt
- Re: Creating intermediate date values - reformatted,
Jim Berglund
- Re: Creating intermediate date values - reformatted,
Jim Berglund
- Re: Creating intermediate date values - reformatted,
Norman Jones
- Re: Creating intermediate date values - reformatted,
Jim Berglund
- Message not available
- Re: Creating intermediate date values - reformatted,
Norman Jones
Range - Delete question,
kirkm
VB style drop down menu on an excel user form?? help,
Ray
Copy and pasting dynamically,
Zarlot531
Re: Suggestions on Organizing VB procedures,
Bob Phillips
Another quick question regarding moving data,
Zarlot531
Re: If Then to delete sheet if B1 blank,
Dave Peterson
Re: Clear Content except for Formulas,
Norman Jones
Compare text formatting,
potter . justin
Deleting rows based on data NOT meeting criteria --working macro here, just need help with tweaking,
Zarlot531
IF...Tnen Problem.,
Jim Berglund
Re: ODBC Excel add-in does not work/is not supported in Office 2007?,
Dave Patrick
Re: Calling macros,
Otto Moehrbach
Macro for index/match function,
nitn28
Custom Data Validation via Code Q,
Sean
Selecting Cells Dynamically in Different Rows,
alishehzad
lock cells after entry,
maximillan via OfficeKB.com
RE: cannot get ListObject using C++,
urkec
cell refs in formula,
Boba
Append data to a sheet's next row,
Turbo
Automatically create new sheets...,
Midget
DHTMLEdit,
Ray
How to search a cell for multiple keywords?,
mr_espresso
Re: Macro to find a word and copy all rows with this word to diff ws,
Ron de Bruin
Background Color,
smandula
Problem managing Enter Key behavior in a userform,
belerephone
Re: Find all non blank cells,
Ron de Bruin
Re: Find all non-blank cells,
Ron de Bruin
Re: FindControls ID,
Ron de Bruin
Left Right Mid,
QTGlennM
.Xla Password forgot....!,
Thyag
.Xls Password forgot....!,
Thyag
Re: clearcontents problem,
Dave Peterson
Add-in Error "Application-defined or Object-Defined Error",
jeremy . haynie
Fun with SubTotals,
OldDog
Best way to learn to programm with Excel,
BTNA
Re: Help with vlookup,
Dave Peterson
Re: Referring to two different open worksheets in code,
Dave Peterson
File name trauma.,
Limey
Re: A button Control,
Susan
Re: Using Do Loops to copy data,
matt
Macro which can create multiple files out of one Options,
ZhenyaVirina
Macro to split up Excel files that are larger then 65,000 rows Options,
ZhenyaVirina
vlookup combo box,
Charles L. Snyder
Re: highlight font by date,
Tim
Re: Regex techniques,
Tim
creating a table from twenty worksheets,
Zuzeppeddu
Vlookup help,
Maggie
Loop?,
Varoujan
Array formula?,
davegb
Counting Various repeating entries,
Gavin
Re: hideing columns,
Don Guillett
Copying Range Names to another open workbook,
ll
Re: Extract Folders Name From Outlook to Excel,
peter
Re: Delete sheet,
Don Guillett
Go to Column A,
ian . montano
Range selection for macro,
Emile
Re: Saving Text File,
Dave Peterson
Re: Concatenate Text Strings over Array,
Bob Phillips
Copy worksheet by date,
mike
hyperlinking to excel program with userform,
Russ
Re: Paste in alternate rows,
Dave Miller
Excel VBA using Sendmail to Send to Distribution List,
belkingold
RE: vbNewLine not working?,
Jim Jackson
Re: Fill combobox from data in different sheet,
Dave Peterson
RE: Protecting whole workbook,
Mike H
Re: Code modification please,
Norman Jones
Proofread my code,
Ray
Re: colour macro,
Norman Jones
Adding custom property to Range object,
Morgan
Incrementing a variable by 1,
skulkrinbait@xxxxxxxxxxxxxx
CopyFolder Permission Denied, but who by?,
DartGuru
Re: Start up macro,
Norman Jones
Checking a workbook when it is opened,
RobH
Re: How do I make a button to print data from a row?,
NickHK
Printing Copies based on Label Caption WONT Work, WHY is it Soo?,
Corey
Condition based copy/paste of range,
nitn28
Re: Search for duplicates in a column,
matt
How do I scroll a the content of a MultiPage control?,
Caleb Runnels
RE: Macro to Audit Two Columns of Data for Errors,
JLGWhiz
Windows Scripting,
Anant Basant
Excel acting strangely,
William
import value from outlook mail to excel spreadsheet,
Max Bialystock
Really Stuck, Please Help,
Carlee
Printing in Black and White,
Corey
Concatenate Text Formating,
Lunch
DropButtonclick event and list showing,
Stopher
Thanks to Corey and Norman,
rlashmore999
Re: Date question,
tbone
loop each with each string,
obar2
- Re: loop each with each string,
Norman Jones
- Re: loop each with each string,
RB Smissaert
- Re: loop each with each string,
bart.smissaert@xxxxxxxxx
- Re: loop each with each string,
obar2
- Re: loop each with each string,
RB Smissaert
- Re: loop each with each string,
RB Smissaert
- Re: loop each with each string,
RB Smissaert
- Re: loop each with each string,
RB Smissaert
- Re: loop each with each string,
RB Smissaert
- Re: loop each with each string,
RB Smissaert
- Re: loop each with each string,
RB Smissaert
- Re: loop each with each string,
RB Smissaert
- Re: loop each with each string,
RB Smissaert
- Re: loop each with each string,
RB Smissaert
- Re: loop each with each string,
RB Smissaert
- Re: loop each with each string,
RB Smissaert
Re: Store the format of a cell in a variable,
PCLIVE
Re: public variables losing state after sheet deletion,
RB Smissaert
RE: Pass a range object as a parameter,
Vergel Adriano
.PDF to .XLS,
Christian via OfficeKB.com
Creating macros in Excel,
ZhenyaVirina
Re: HELP! How do you add another column to this code?,
George Nicholson
Re: Remove Leading Comma,
Norman Jones
Re: disable a button,
Norman Jones
adding hyperlinks,
greg
RE: Userforms and editing current records,
Tom
RE: On.Time problem,
Vergel Adriano
Paste to a new workbook,
stewart
Re: variable not defined,
Susan
Excel suddenly closes when a DSN-Less connection to SQLServer fails,
Luis Porras
Re: Open File based on filename in cell,
okrob
Refer to controls by group name.,
stewart
AutoShape .. tooltip?,
booner
Referencing adjoining cells and counting in an IF statement,
boriscatbobo
Re: Reference a VBA Query from Access,
Tim
verify state of option button,
stewart
RE: sporadic conditional formatting problem,
Vergel Adriano
Re: e-mail single sheet using a macro,
Ron de Bruin
Last used row problem,
Keith R
How to Offset to get past merged cells ?,
Fred
Re: Reset my object variable myRng1 with each loop,
Bob Phillips
Re: VLOOKUPS,
Norman Jones
Insert Pic Which User Chooses into Comment,
Bull
Re: UserForm, a Multipage and printing...,
Norman Jones
Re: sheet number,
Norman Jones
Split rows into multiple sheet if.....,
Stuart
D,
anu
Preventing users from breaking code with ESC,
joost
Re: Automatic saving and closing,
Susan
RE: Macro elapsed time bar (same as download time elapsed bar),
Tom Ogilvy
public variable question,
Gary Keramidas
Need slight modification on macro below,
Sam Commar
How do I draw a floating cluster Gantt Chart with VBA.,
u473
Help: 1004 Method 'Charts' of Object '_Global' failed,
anu
Copying Range based on condition from workbook 1 to workbook2,
nitn28
RE: Selecting/Copying Variable Areas,
Tom Ogilvy
Re: Update link answer = no,
Dave Peterson
Re: How would one merge this into 1 cell,
Dave Peterson
WithEvents problem,
pinkfloydfan
Re: Concatination error in macro,
Norman Jones
Help needed with copying from one worksheet to another,
Lord . Ricco
Re: Dats in If statement,
Bob Phillips
Re: Missing Right and Format function in Excel 97,
Bob Phillips
Re: call another macro,
Bob Phillips
Make Workbook ReadOnly,
Alan
RE: Populate ListBox with Filtered Records,
Halim
Stock Macro Loop,
Materialised
Macro Loop,
Materialised
Usage of serial port in VBA ( exel ),
Alexi Dobrev
Split, sort and mail,
splat
assigning text box input to a sheet,
rlashmore999
date format help needed,
kiwis
help needed in converting date format,
kiwis
Autosize bug in Excel 2007, textboxes, work arounds,
Anthony Berglas
Check for a value before importing a row,
Carlee
Re: Write to Word Document from Excel VBA Help Needed,
Helmut Weber
Opening a Single Excel File in Different Custom Views Via Hyperlinks,
kent . carey
Re: Std XL icons on my Forms,
RB Smissaert
Using Excel as a Database,
UBER_GEEK
RE: Cause of SheetChange Event,
Matthew Wieder
Re: Macro fails in different WB,
JE McGimpsey
Naming worksheets based on a cell value,
FatBear
RE: Get SheetName from cell,
Brotha Lee
BIFF8 reader,
RB Smissaert
Re: Random generator question,
PCLIVE
dfb Database 5 file import/query,
Riddler
Why type mismatch?,
davegb
Row height,
bluegrassstateworker
Excel VBA locate nearest point,
nitn28
Re: Regex Capture problem,
Ron Rosenfeld
Pivot table - "...too many rows... error,
Almagg via OfficeKB.com
Referencing Fields in MS Project,
marshallemail
Extract data from jpg,
Don Guillett
Using Excel Add ins with visual basic,
revinfo
Handling Worksheet Events of a Worksheet Created During Runtime.,
chatterbox
Re: Excel web querying stock and mutual fund info?,
matt
Re: Office web services toolkit search problem,
Jan Karel Pieterse
Find Method Used within Values in an Array of Ranges,
IComeInTheWest
Re: Triggering Change_Events after Form Initialization,
Jan Karel Pieterse
Unique Item List still contains duplicates,
AC
Re: Referencing Worksheet code name in the following code,
Jim Rech
RE: Reference Numeric Variable in Macro,
Tom Ogilvy
Numbers treated as text,
Jack Sheet
test,
Susan
Unique item list still returns duplicates,
AC
Using cmdlg xlDialogOpen,
PO
UNDO and REDO buttons are inactive,
Shailesh
Help - can't understand why this doesn't work,
mr tom
Re: Difficult Question about averages... Possibly Nested loops...,
NickHK
Re: Error in Code,
Dave Peterson
Need help to convert date from dd/mm/yyyy to mm/dd/yyyy,
kiwis
Re: inputting American dates into an English workbook,
Norman Jones
Re: running Excel VBA macro from SQL Server,
NickHK
GetOpenFilename,
PWS
Worksheet macro to copy formats and formula from discrete ranges,
jamie . cutting
RE: CAN I ADD CONTROLX BUTTON TO CUSTOMISED TOOLBARS,
Wei Lu [MSFT]
QUERY FOR TODAY RECORDS,
shaqil
Macro that moves data "From Akash",
Akash
How to Debug User Defined Functions,
Kieranz
Autosize bug workarounds in Excel 2007 shape textframes,
Anthony Berglas
Match numerical data using excel VBA,
nitn28
Statement not to update the file while opening through Macro,
Gautam
Advice on including Help files for UDFs in a Add-In,
Nick_F
Excel VBA Reference to Forms Object Library (to be unchecked),
tkt_tang
Re: Double Space in Text Box or Excel Cell,
NickHK
Re: macro to save as,
maperalia
REname Pivot table columns,
HSalim[MVP]
Autosize bug in Excel 2007 shape textframes,
Anthony Berglas
Re: High Security setting,
NickHK
Re: Multi select with doubleclick event,
NickHK
Re: Using a macro to hide columns,
Jim Cone
Excel 2007: deleting macro from personal.xlsb,
Carl LaFong
Excel data numeric type read problem,
free9645
shading cells trouble,
Mo2
Copy/Paste problem in Excel 2007,
Josh Sale
Excel Format Cells Numeric Currency VBA,
samadams_2006
Printing Excel Sheet,
mnixonG
Re: Problem with Auto Filter and Macro,
N10
Populating cells based on a combobox OnChange Event,
mnixonG
ComboBox Problems,
mastermind
"Stair-Stepped" Commissions Question.,
sergio . mercado
How to enumerate controls on a worksheet in Excel 2003,
tbone
Calling an Object using variables (What am I doing wrong????),
Superman
Active X combo box help,
alexdetrano
setting a variable equal to a value from a pivot table,
mithu
Re: MACROS 2,
Bob Phillips
Re: What's wrong with my code? Thanks,
Bob Phillips
Populate A Userform ComboBox,
mastermind
another array approach question,
Gary Keramidas
Alternatives to Excel VBA (Query Tables returning more than a million rows),
gotesman@xxxxxxxxx
RE: Macro to select a list of values greater than or equal to a va,
Vergel Adriano
RE: what does target.offset(0,-1).select mean here?,
excelent
Re: MACROS,
Norman Jones
Sumproduct,
Probyn
Using Excel as a scheduling program.,
DellArte
Chartspace,
cougarfighter
RE: Consolidate Rows?,
Dave Birley
find and update,
Keith Teeter
Autoheight adjustment for merged cells not changing,
bluegrassstateworker
Compare 2 series of columns (Combinations),
PST
array from range question,
Gary Keramidas
Delete all files except...,
David Johnston
IE integration,
jeremy . haynie
getpivoitdata and assign to a variable,
mithu
pulling data from a pivot table and assigning it to a vairable,
mithu
Re: conditional formatting to print,
Jim Rech
Better looking command buttons on a worksheet,
Josh Sale
RE: Save as filename,
Vergel Adriano
Re: Macro to select a list of values greater than or equal to a value,
Don Guillett
Re: Custom Button and End Users,
Dave Peterson
Re: Macro cannot be found in Read only modus,
Dave Peterson
Re: crash on close,
Dave Peterson
- Message not available
- Re: crash on close,
Dave Peterson
- Re: crash on close,
Matt
- Re: crash on close,
Dave Peterson
- Re: crash on close,
Matt
- Re: crash on close,
Dave Peterson
- Re: crash on close,
Matt
- Re: crash on close,
Matt
- Re: crash on close,
Matt
- Re: crash on close,
Dave Peterson
- Re: crash on close,
Matt
- Re: crash on close,
NickHK
- Re: crash on close,
Matt
- Re: crash on close,
Dave Peterson
Adding a Custom menu / sub menu,
PaulW
Re: Command Button Tooltips,
Jim Rech
Re: hide column,
Norman Jones
Pivot Tables and percentages,
dmonder
Excel VBA - Sending email,
dweber5
Re: hidden character in string,
Norman Jones
Re: Digital certificate in outlook,
Norman Jones
Re: password recovery,
JE McGimpsey
Sorting chart by name,
navin
VLOOKUP Trouble,
mlarsen1982
Re: Calendar Control - Years,
Ron de Bruin
Re: Stopping copying and emailing of a Excel File,
Ron de Bruin
Re: Break Links Macro help...,
Ron de Bruin
Re: AutoFilter Criteria in VBA,
Don Guillett
Re: E - Mail when sheet updates - hyperlinking !,
Ron de Bruin
Re: Using OE to post and read newsgroups,
Don Guillett
Sorting by chart name,
navin
Moving a worksheet to a new workbook when you do not know the name of worksheet,
Fireworks99
List of pivotitem visible,
MichDenis
Extracting Specific dimensions/values from multidimensional array,
junkabl
Re: Setting Variables,
Bob Phillips
Re: Control box/Command buttons,
Bob Phillips
Select Range Name Q,
Sean
Using COUNTIF with an AND? Or is it something different?,
Paul Franklin
Object Required Error,
MarkHear1
Re: Object Required Error,
ilia
<Possible follow-ups>
RE: Object required error,
Gary''s Student
RE: Object required error,
Mike
RE: Object required error,
Vergel Adriano
How do I get this to look at a date and loop down all the info?,
Pasty
Re: Excel2007 to DBASE4,
NickHK
ranging the filter cells when doing auto filter,
thread
RE: Copy from Word into Excel pastes wrong picture,
Wei Lu [MSFT]
RE: AutoFill Row Numbers & Print Area,
Jay
help! Why my code can't work in excel 97,
kiwis
Re: Test for Disable / Enable Macros,
NickHK
2B or not 2B? - Go to cell Bx, depending on what row is selected,
bony_tony
Cell format reverts to a custom date after change to General,
billgeo
Re: Scope limit of user written Excel Functions,
Tim Williams
Re: SELECTING TABLES & PATHS,
Tim Williams
Alert 'Micosoft Forms' when Closing application,
Corey
User Date Picker rather than Input Box,
Carlee
Re: Show worksheet from cmd button on userform,
Corey
Re: Macro security bypass for one application,
NickHK
Re: How do I assign a value cell in a column that has a dynamic row va,
merjet
How to capitilize automatically?,
charlesweaver33
relating 2 sheets,
mustafa . nuriddine
Re: Is there a code?,
Corey
Re: MS query criteria - referencing a cell on a spreadsheet,
Nick Hodge
Re: Using Solver with Excel 2007 VBA,
Nick Hodge
Create email from cells in Excel?,
Scott Townsend
VBA to Fix Dates,
undrline
Setting RGB colors for a set of cells.,
Miron
Excel Prints the Page as a Tiny Little Square,
PHPBABY3
Re: Locking a TextBox in a userform,
Dave Peterson
RE: Multiple column find,
jtdunn
Macro step wasn't recorded,
rlntemp-gng
Re: My 3rd Msgbox is popping up in wrong position,
Norman Jones
Re: SQL Syntax Error,
MH
Re: email forms,
Les Stout
- Message not available
- Re: email forms,
Ron de Bruin
- Message not available
- Re: email forms,
Ron de Bruin
- Re: email forms,
alexanderd
- Re: email forms,
Ron de Bruin
- Re: email forms,
alexanderd
- Re: email forms,
Ron de Bruin
- Re: email forms,
alexanderd
- Re: email forms,
Ron de Bruin
- Re: email forms,
alexanderd
- Re: email forms,
alexanderd
- Re: email forms,
Ron de Bruin
- Re: email forms,
alexanderd
Autofilling INPUTBOX,
Rick
Re: put inputbox input into a cell,
dq
Help with userform labels,
jeremy . haynie
How to programmatically create range for solver?,
tomerdr
Re: Find data in other worksheet,
Dave Miller
Use A Command Button more than one time,
Bull
Prompting user to enter number of cells to be used,
GainesvilleWes via OfficeKB.com
RE: Odd macro behavior,
Dave Birley
Size Matters - minimizing file size,
jamie . cutting
BeforeSave, Cancel and ReadOnly,
Steve Hunter
Comparing two dates using between.,
BerkshireGuy
RE: Sort Macro,
Hazel
Totalling Formulas,
belczyk@xxxxxxxxx
Re: Attach Macro to single worksheet,
Dave Peterson
Displaying part of a worksheet in another worksheet,
Dave E
Loop & Accumilate e-mail addresses to send to,
Les Stout
code cleaner,
jamie . cutting
Re: Borders,
Susan
Re: how to remove linebreaks in cells with VBA,
Norman Jones
Re: find replace within sheet or workbook,
NickHK
macro to copy and paste,
jln via OfficeKB.com
Re: Excel,
NickHK
Simple addition problem,
skulkrinbait@xxxxxxxxxxxxxx
Sending task to Outlook from Excel,
Pasty_The_First
create chart in worksheet but hide the data from user,
kiwis
Re: Help with code (delete range),
Norman Jones
new worksheet with 4 columns only,
Boba
Re: Returning a value forom a Module to a Userform,
NickHK
Find 1st empty cell within each row,
talista
Re: Required Fields for many Text boxes on a userform,
Zigs
Re: Strange Formular for OLE,
NickHK
RE: REPEAT NTH ROWS,
JLGWhiz
Getting data for pivot table from another spreadsheet,
JDB
RE: Numeric or null value,
Vergel Adriano
Re: Excel formula not displaying a number,
MH
RE: stop application {on keys},
Vergel Adriano
Obtain Cell Formatting in Cell Referencing?,
Al Franz
Cut time from string ?,
Emory Richter
Re: Connection from Excel to SQL,
MH
Excel solver newbie question,
tomerdr
Dynamic Userform Controls not Displaying,
Zigs
Passing table to web service,
Alex
No Dir in Spreadsheet Referencing of Cells,
Al Franz
Re: text trigger,
JE McGimpsey
Re: faster way to save/restore a worksheet in MS Access,
MH
Error 91: Object Variable Not Set,
Carlee
Re: Remove validation,
Mike Fogleman
Re: Creating Multiple Charts from Same Pivot Table using macro,
Jon Peltier
Re: Having problems w/ Solver code,
Jon Peltier
Re: Calculating Commissions,
JE McGimpsey
Re: Projects accumulate in Project Explorer,
Mark Ivey
Re: Error putting a formula in a cell with vba,
cristizet
Re: OK I admit that I can not make a Command Button work,
Mike Fogleman
Copy Merged Cells to Single Cells ??,
Al Franz
Code for Select a file and save it in a different location,
Oggy
Worksheet events,
damorrison
Re: How do i hide the main title bar in excel 2007,
Nick Hodge
Re: Check available pagesize,
Norman Jones
RE: column copy,
Curt
NOVICE with text and list box queries,
rlashmore999
Re: Check if a workbook has an "open password",
rgablejr
I am so close....if null add new problem,
Carlee
Finding a Minimum Number other than Zero within a Range,
cardan
Offset from end of a selection,
Vic
Excel cursor,
doos
please help!,
TPM
Selecting last pasted object,
avi
RE: Find and Replace Row,
excelent
Column lookups of specified numbers,
Jim Berglund
problem with code,
MicrosoftNews
Userform Position exactly adjacent to Cell A 46,
rachitm
Parsing Data String from text file line,
gtslabs
automatically deleting a worksheet (without warning prompt),
Guerilla
removing links between workbooks,
Guerilla
Re: ActiveCell,
JE McGimpsey
Close workbook without alerts,
Jeff Wright
Re: IfError Help,
Dave Peterson
Re: Needing Help,
Dave Peterson
Re: Trigger Email with Excel File Closed,
Dave Peterson
Re: Active Cell Filling,
davesexcel
HELP,
Craig Johnson
Capture cell address in UDF,
Jan Kronsell
Bitwise comparison question,
Ian Gilmore
Re: Exporting code modules,
Norman Jones
Re: Macro's,
Brizers
Re: confine text to cell,
Tim Williams
Group a range - closing the group does not hide the controls....,
rgablejr
macro v active x control,
BLJ
Dynamic chart,
s_smith_iet
UserInterfaceOnly question.,
Ken Johnson
Re: Listing,
Tim
Re: Looping through a specific column,
Norman Jones
Re: Resizing Userform,
Norman Jones
Re: Remove Trailing Comma,
Trevor Shuttleworth
Preventing Duplicates...,
Carlee
Re: Advanced Filtering on an inactive sheet,
merjet
Pop-up calendar with protected sheet,
S . Data
RE: Propogate information based on cell contents,
Barb Reinhardt
RE: .Find and With stmts,
Jim Thomlinson
RE: addnew,
Brent
Re: Selecting an entire column,
Norman Jones
Re: Loan calculator- Payment,
Jim Cone
FormulaR1C1 problem,
satlow
Activate previous Workbook,
excelnut1954
Adding text to Formula result in VBA?,
Mike Proffit
How to calculate Number of rows in Excel ?,
anu
Re: Predictions with Excell,
RB Smissaert
Getting reference to an OLEObject from another cell?,
tomerdr
Validation Drop Downs within a List,
Robert
Re: Check Box Status,
David G
Validation based on digits in the middle of a string,
TexasStar
DoneEx Removal,
MHenry
Re: determine if Pivot Table field item is hidden,
Debra Dalgleish
Re: Vlookup "contains",
Roger Govier
Re: A Sheet by any other name.....,
JE McGimpsey
Re: Excel Stored Dates,
merjet
Help with a "delete rows" Macro,
NewUser22
Protecting VB Code,
Sanjay
RE: application run - macros within macros,
Joel
Re: delete macro from vbs,
Norman Jones
webquery URL with brackets,
davek
Re: Is there a way to do this?,
Tyla
Adding two characters in front plus three in back,
Hinojosa via OfficeKB.com
Calling sub from CommandButton knowing which sheet is active,
gtslabs
Excel macro that deletes all rows which doesn't contain the character "|",
Luca Villa
Yet Another Macro Question,
Materialised
Copy values (loop) from TXT file to excel,
djenzovoort
Re: starting Solver with VBA,
merjet
Re: Check Box Control,
merjet
Excel Macro, slow performance on terminal server...,
Lars Gaarde
Re: Command button,
Susan
Excel 2007 Ribbon Check custom buttons,
Alice
Problem with Vlookup,
Les Stout
Re: Random Numbers,
Roger Whitehead
Re: Selecting the one with the bigest amount,
Norman Jones
script to send data from worksheet to multiple workbooks,
Greg
Need help with checkbox to select recipients of an E Maiil via Lotus Notes,
Francois via OfficeKB.com
How unprotech .XLS if we dont't have password?,
mahesh sharma
Unload a Userform created in VB6,
avi
Re: open all workbooks in a folder,
Coza
Another Stock Macro Question,
Materialised
Re: If cell is changed clear all cells to the right in that row,
David McRitchie
Adapt sheet Protection,
Corey
Re: Windows.RangeFromPoint method is not working properly,
NickHK
Re: VBA Help file,
Andy
Help with copy and pasting,
JHL
Re: MailEnvelope,
NHRunner
Re: External Data-Changing Numeric Formatting,
Tim
ComboBox1 is DELETED(!?) when Me.Pictures(1).Delete runs in my macro,
Finny388
How to locate Cell in which control resides,
Jamal
Re: Double clicking a Cell Programatically,
IanKR
Re: detect shape overlap?,
Dave Peterson
Create characters,
Ed
Re: Email Error,
srd
Pivot table showing #Num! error - SSAS2005 SP2,
tee_user5
Excel training from Rockhurst University Continuing Ed. for free,
twussow
updating Excel.FormatCondition,
greg
can someone help me with these 8 lines of code,
mithu
RE: Updating a Piviot tabel when Excel data updates,
Jayneedshelp
Re: Using macros in an external worksheet,
dq
<Possible follow-ups>
Re: Using macros in an external worksheet,
Dave Peterson
Help Please !!!,
anu
For-Each loop, I think.,
excelnut1954
Currency List Dropdown for Worksheet,
Enz
RE: Pivot Table,
Vergel Adriano
Macro not working in personal.xls,
dibaghish
Re: Error 1004,
ed
Re: Transfering records based on a condition,
Norman Jones
have to open csv files with possibly more than 65000 rows of data in them,,
ZhenyaVirina
How to select cells with checkboxes?,
tomerdr
RE: Unlocking specific worksheets,
Eileen
Combo box with Data Validation feature,
MelissaDeMille
Re: Remove Cell Contents Macro,
Don Guillett
Re: Password Protection,
Norman Jones
Error with Using Macro for XYScatter plots,
anu
Opening a 2nd workbook to get data from, need an easier way,
Craig Marburger
Show A userform on selection range,
Sanjay
Re: VB Code to return to top of page,
scott_smith
Copying Range gives object defined run wrror,
gtslabs
Autosort on an Array,
simon
Re: Copy Macro and Forms/code,
Susan
- Message not available
- Message not available
- Message not available
Re: load a PDF file with VBA,
Ron de Bruin
Inserting VLookup using VBA - Problems concatinating contents of cell & variable,
scott_smith
Re: Null exist in Excel,
Dave Peterson
Selecting Items from drop down list,
mlarsen1982
How to speed up response to scaling axes with code?,
professorplum101
How to use CompareSideBySide method?,
Ed
Re: Challenge of the day part 2,
Khanjohn
Re: Real-time character counter,
Dave Peterson
Re: XL4 error executing Page.Setup function,
Jim Rech
Copy and Split Macro,
Materialised
Macro to compare then copy if string found,
Stuart
- Re: Macro to compare then copy if string found,
sali
- Re: Macro to compare then copy if string found,
Stuart
- Re: Macro to compare then copy if string found,
sali
- Message not available
- Re: Macro to compare then copy if string found,
Stuart
- Re: Macro to compare then copy if string found,
Stuart
- Re: Macro to compare then copy if string found,
sali
- Re: Macro to compare then copy if string found,
Stuart
- Re: Macro to compare then copy if string found,
sali
- Re: Macro to compare then copy if string found,
Stuart
- Re: Macro to compare then copy if string found,
sali
- Re: Macro to compare then copy if string found,
Stuart
- Re: Macro to compare then copy if string found,
acampbell
- Re: Macro to compare then copy if string found,
Stuart
- Re: Macro to compare then copy if string found,
acampbell
- Re: Macro to compare then copy if string found,
acampbell
- Re: Macro to compare then copy if string found,
acampbell
- Re: Macro to compare then copy if string found,
acampbell
Re: Reports in Excel?,
Chip Pearson
Calculate marketing mix,
Jen
copy tabs into new workbook, save, and close.,
Tealina . Mairs
Re: Error on loading userform,
Norman Jones
Re: Always keep first part of text in a cell,
Norman Jones
Excel vba chart build problem.,
wimblejon
Re: Challenge for the day.,
JE McGimpsey
Re: Run Time Error on activate coding,
NickHK
lookup and copy certain value in a loop,
djenzovoort
Re: Additional controls to Toolbox,
Herbert Schroder
Set A1 on Top left Corner Q,
Sean
Looping and copying from a list,
bestie22 via OfficeKB.com
ascii to character,
Gautam
Quick watch...,
Francis Hookham
Cutting/pasting from Excel.Application object - missing the obvious?,
David Evans
Excel - Stock Macro Help,
Materialised
Re: I can't find the YIELD method,
Mike Middleton
Special Http Response feature?,
Jeff
Re: Using Dynamic Ranges in Get Data command,
NickHK
Should be simple: Lookup a picture from a folder based on a cell value changing,
Finny388
Search for name of a file in a directory (http path),
Daisy P
Can Turn Off Internal "Undo" Stack in VBA?,
Larry Adams
Running DDE functions within VBA subroutine - Any assistance appreciated,
jeffstryer
Re: Add loop to Vlookup,
Allen Lance
Re: Kill Function,
NickHK
Re: Text Files,
NickHK
Compile error when using Res=Inputbox,
Corey
Strange Excel Bug?,
kirkm
Limiting a worksheet's selection range.,
Ken Johnson
Re: summing cells on a different sheet,
R1C1
Macro Optimization - 25,000+ Rows,
Spy128Bit
- Re: Macro Optimization - 25,000+ Rows,
sali
- Re: Macro Optimization - 25,000+ Rows,
Spy128Bit
- Re: Macro Optimization - 25,000+ Rows,
sali
- Re: Macro Optimization - 25,000+ Rows,
Spy128Bit
- Re: Macro Optimization - 25,000+ Rows,
sali
- Re: Macro Optimization - 25,000+ Rows,
Spy128Bit
- Re: Macro Optimization - 25,000+ Rows,
sali
- RE: Macro Optimization - 25,000+ Rows,
Jay
- Re: Macro Optimization - 25,000+ Rows,
Spy128Bit
- Message not available
- Re: Macro Optimization - 25,000+ Rows,
Spy128Bit
- Re: Macro Optimization - 25,000+ Rows,
Jay
- Re: Macro Optimization - 25,000+ Rows,
Spy128Bit
- Re: Macro Optimization - 25,000+ Rows,
Spy128Bit
- Re: Macro Optimization - 25,000+ Rows,
Spy128Bit
- Re: Macro Optimization - 25,000+ Rows,
Jay
- Re: Macro Optimization - 25,000+ Rows,
Spy128Bit
- Re: Macro Optimization - 25,000+ Rows,
sali
Rather tired and need solution please 4 Vllookup :-D,
Les Stout
Create a reference to a workbook which is already open,
a . yearsley
Worksheet functions in VBA,
Builder
Re: Userform and Checkbox - will this work?,
Chip Pearson
Re: execute macro from command line,
Steve Yandl
Re: VLOOKUP #N/A error. Sort and format are correct.,
JMcFarland
Re: Time Sheet End of Month,
merjet
Extremely long SQL Array,
Diana
How to Summarize between step?,
Tamil
- Message not available
- Message not available
Re: write a program in xl,
Incidental
Sending e-mail from Excel,
mdicostanzo
Re: Populate one combo box based on the selection of another combo box,
Incidental
New User......Please Help,
NewUser22
Problem opening file from a server,
Les Stout
Re: Saving files one level up,
Dave Peterson
Re: Open Word from Excel,
Ed
Finding a date in between a range of dates.,
Abro via OfficeKB.com
Re: Skip Read-only message,
dq
Launching Macro when Cell Changes,
alexdetrano
Combobox Code, Wont Copy and paste?,
MelissaDeMille
Entering Data into Column C based on word from Column A,
J.J.
Re: User Defined Function giving #NAME? error,
Norman Jones
Delete row if 3 columns have empty cells in a row,
Les Stout
Reading Text file into an array,
gw . boswell
Averaging not Summing,
Carlee
Re: Excel 2007 Macro security problem.,
Incidental
Re: Copy Excel Files to new directory,
Ron de Bruin
Combobox Hiding Text behind,
PMC1
Re: ActiveWorkbook.ChangeLink,
Susan
Re: Dropdown,
MelissaDeMille
Question about the TextBox control,
Tox
Re: Save as DBF in 2007,
weschester
Re: Sheet protection,
Tomasz Gasecki
Excel to Powerpoint pastespecial date problem,
wimblejon
Font color setting problem,
vrzimmerm
Problem with Splash Screen user form with updating status,
professorplum101
Excel Find and Replace Problem with Array,
Steven Lee
Re: How do you create a macro to auto number in excel 2003,
Dave Peterson
Re: Password Protecting a command button,
Incid3ntal
File save macro error,
vrzimmerm
help hiding excel application,
teejayem
How to,
dt
Re: Office HTML: Excel headers and footers metadata erroneously transl,
NickHK
dynamic formula? not sure if it's even possible to do this with Excel ...,
Ray
need some suggestions on how to solve my problem,
kiwis
Re: Trying to create a macro to auto number blank (excel 2003),
paul . robinson
Re: Delete Row,
Norman Jones
ranges,
Arne Hegefors
save on condition,
Guye
Error handling and escape key,
Jeff
Message Box Q,
Sean
Re: referencing inputbox input to worksheet,
Norman Jones
Re: Macro runs OK for me, but not for the other users,
Norman Jones
RE: Converting Excel Calculations to C# (or VB.NET) code and assemblie,
Wei Lu [MSFT]
How to move to column B1 from column Z1,
kiwis
all the check boxes should be checked if i check a particular checkbox in that row,
rg . ruchigoel
Macro Loop to Count Copy,
Ty
Help on solving the linear programming model using solver,
papachunks
Re: command button function,
NickHK
Re: lisbox reference and calculation,
matt
How keep user form constant,
alexdetrano
Value Change Range of Sum in Another Cell,
Al Franz
Which Excel Version Best for Creating New Applications or Add-ins?,
SummitXLer
How would you design this application???????,
Train at Home
Re: Sum , multiply betwenn 2 comboboxes,
kudruu
Resizing and Printing a UserForm,
kudruu
Automatically updating external data sources,
chordringer
Re: Help with creating a custom function,
RB Smissaert
User Form Question,
alexdetrano
Re: ASCII CODE of a character...,
Chip Pearson
ADO data access to excel,
myrka
To thank or not to thank,
Francis Hookham
How to fix .sort in Excel 2007,
ofergr
RE: Create appointment,
Jim Jackson
Here is a challange for someone... Needing to "step through" and combine data fields,
Mctabish
Tab Indexing Behavior on a Mac,
kudruu
Macro to save file in changing directories?,
vrzimmerm
Calendar Control missing,
Dan
Change dates from dd/mm/yy to 6 digits being ddmmyy,
Stuart
Drop Down lists,
haas786@xxxxxxxxx
Re: Displaying data on Excel Statusbar?,
dq
Re: How to use INDIRECT,
Bob Phillips
Re: Protected project,
Gord Dibben
Split Cells,
Stuart
convert .csv to .xls for very large file,
kathy . aubin
Conditional Formatting, copy for rows,
Richhall
Re: Date Issue,
Norman Jones
Re: Putting woirksheet name into a variable,
Matthew Dodds
if AddIn_1 isRunning vbcr application.enableEvents=False vbcr end if: how to do this??,
Matthew Dodds
Re: Selecting the first blank cell in a column,
Don Guillett
Re: Open File - Need an warning to appear if file cannnot be found,
David G
another macro is running ... how to recognise that process in code???,
Matthew Dodds
xlSortTextAsNumbers inconsistent? Excel 2003,
David Evans
ScreenUpdating is always true when stepping through code ! ....,
WhytheQ
Need Help with VB6 and Excel,
anu
Why oh why!!!,
WhytheQ
Re: Hide Cell contents,
dq
Reading command line parameters in a VBA program,
dq
Re: Call sub with array,
Bob Phillips
RE: Drop down menus,
jamesp@premiercs.co.uk
Matching lists,
G.A.M
FTP a file to UNIX server using Excel Macro,
narendra vuradi
Re: New and exciting things,
JE McGimpsey
Simpler Macro,
Joe via OfficeKB.com
finding the last row for a macro,
Mctabish
Re: copy specific rows to a new sheet,
Norman Jones
Message not available
Re: second biggest in array,
Norman Jones
Copy destination,
Francis Hookham
Sub to strip away "Sheet" prefix from names,
Max
Re: Need Help am Brain Dead today.,
NickHK
Problem with rank function based on a non-worksheet array,
Bas
len limit of 255 of function. any workaround?,
Mctabish
Post to a Sheet Depending on a Value within a Cell Q,
Sean
Re: check if valid and size array,
NickHK
Re: sort numeric array,
NickHK
Searching for multiple words in a cell,
JJ
Using an excel addin to call macros in current sheet.,
delling
Re: if with or,
NickHK
Re: msQuery: is JOIN command possible in Excel?,
NickHK
Re: msQuery: is JOIN command possible in Excel?,
MH
Re: Identifying the user that has a workbook open?,
NickHK
shorten connection time <<Macro Tweak needed>>,
Dan
Re: Circular Express when $ added,
alondon
Re: Last Modified Date & Time,
NickHK
Calling DLL functions in Excel VBA,
sunny
Re: Command button calculation from Userform and Cell reference,
Corey
Clearing a Sheet,
kirkm
Re: how do I get excel to round to specific numbers?,
Corey
Re: NEW USER WOULD LIKE HELP WITH A COUPLE OF PROBLEMS,
Corey
Microsoft Excel http://www.teenwag.com/poll?n=1510,
fringo@xxxxxxxxxxxxx
RE: function tweak?,
Vergel Adriano
DP use when sheet protected,
Aaron
Re: Selecting data to copy and paste,
Norman Jones
COM Addin Security,
sridhar . baldava
Re: Textbox and Bullets,
David G
Re: Create Harvey Balls in Excel?,
JE McGimpsey
Scheduling by workdays only spreadsheet problem,
John Bartley K7AAY
Coding a filename into a macro,
Guerilla
Re: Looping through a spreadsheet,
merjet
Print Preview + Coordinate Problem,
lcvianna
Re: Change ws designator,
Dave Peterson
Re: Lock cell and reprotect sheet after save,
Norman Jones
deleting rows with VB,
mantrid
activating a workbook,
Almagg via OfficeKB.com
Re: Correct syntax for hiding a chart sheet,
JE McGimpsey
Charts Sheets to Powerpoint,
kimbobo
tabbing in code,
mithu
Function for RowHt. How to create,
Kieranz
Opening text files,
Dan R.
RE: Hide / Unhide Workshets on Print and Open,
Vergel Adriano
Re: Repost of Question on Preventing 2 cells from having the same valu,
JE McGimpsey
setting the range of cells to be used for customtype errorbars,
Steve
Re: Listbox Help,
Dave Peterson
RE: Conditional CCP entire row,
CLR
Creating a macro to swap cells but retain formatting,
JEFF
Re: Format from Row Source,
Dave Peterson
Re: Adding Date to another Cell,
Tom Ogilvy
Re: Search for Quote,
Bob Phillips
How would this work deliberately naming a sheet, pls?,
StargateFanFromWork
Protect sheets when activated from ShowSheetsList application,
jamie . cutting
Embarassingly simple question regarding VB Editor,
carl . wilkens
Parsing into different sheets,
BerkshireGuy
RE: Function select second lowest,
Vergel Adriano
Excel date input inconsistancy,
PhilM
Rename Multiple work sheet,
Murtaza
SAP interfaces,
Tomasz Gasecki
topmost modal form,
chfa
Referring to sheets wiht variable names,
daisy_robinson
move to the cell on the right, my code not working pls help,
kiwiiii09
want to advanced to cell on the right but my code won't work,
kiwiiii09
Re: Close specific workbk,
papou
Unprotect VBA-Code using VBA-Code?,
Michael Mueller
singel cell reference,
Guye
Re: IM A NEW USER HAVING TROUBLE WITH CODE,
Bob Phillips
Re: Array Argument Parenthesis,
Bob Phillips
Re: Setting the CodeName of a new worksheet in the VBE Editor,
Norman Jones
Re: remove msg box prompt,
paul . robinson
Chart font,
navin
TextBox.Visible = True ... not working,
Ozgur Pars
RE: custom toolbars to exclusive files.,
Vergel Adriano
Help with Search Range in Function,
kirkm
How to get mutally exlusive cells on mouse click,
men
Change Event programming,
Sharon
Sub to transform table into cols,
Max
Updating references in copied excel work sheet,
nsuh
RE: Combo Box Form Control,
Jay
Re: excel b74=b74+1 when b4-b54 ="Y",
JE McGimpsey
Mouse over pop up,
Francis Hookham
Change current directory to the directory that the workbook loads from!,
alondon
Help - How to check if value exists in closed workbook?,
c mateland
Re: Is there a workaround with #REF error message?,
Jim Rech
Rename multiple controls.,
stewart
How to count dates in a column between 2 dates,
deaconj999
Can I link multiple Listboxes to one Scrollbar,
rachitm
Wath means,
Luis Fernando Ortiz M.
Combination question,
Peter T
Trouble formatting a date variable to contain a time value,
Arch Stanton
Stop error message,
Oggy
Re: Help with Case Please,
Dave Peterson
Need Help Pls - What's wrong with this?,
DW
Re: Finding and transfering data,
Don Guillett
Re: Need help with Array,
Dave Peterson
VBA to SQL DB with user input and results to worksheet,
chansing5
Watermark image,
avi
Re: Excel VBA resize picture in powerpoint,
sharad . net
My Macro does NOT Delete ROWS??,
VexedFist
Re: Naming files,
Dave Peterson
Re: Disabling Button Commands in 2007,
Ron de Bruin
Re: Can i sell my vb program,
Bob Phillips
Coping data from excel to word,
Oggy
Tax Table Formula in Single Cell,
Al Franz
RE: code to attach files,
kalikw
Create pivot table,
Almagg
"Form" to add data with?,
StargateFan
Re: ENTER instead of TAB,
Roger Govier
Re: Date check for expiration,
JE McGimpsey
Extract 5 digit number from string,
directos2
- RE: Extract 5 digit number from string,
Barb Reinhardt
- Re: Extract 5 digit number from string,
directos2
- Re: Extract 5 digit number from string,
Dave Peterson
- Re: Extract 5 digit number from string,
Dave Peterson
- Message not available
- Re: Extract 5 digit number from string,
directos2
- Re: Extract 5 digit number from string,
JE McGimpsey
- Re: Extract 5 digit number from string,
Dave Peterson
- Re: Extract 5 digit number from string,
directos2
- Re: Extract 5 digit number from string,
Ron Rosenfeld
- Re: Extract 5 digit number from string,
Ron Rosenfeld
- Re: Extract 5 digit number from string,
Dave Peterson
- Re: Extract 5 digit number from string,
Dave Peterson
- Re: Extract 5 digit number from string,
Ron Rosenfeld
Re: Extract 5 digit number from string,
Dave Peterson
Re: Extract 5 digit number from string,
Norman Jones
RE: Extract 5 digit number from string,
Joel
Re: Extract 5 digit number from string,
Dana DeLouis
Re: Extract 5 digit number from string,
David Portwood
Change image for Ribbon items,
Michael Koerner
Need simple 'Paste' macro code,
pamjeff
RE: "Excel has encountered a problem..." error,
Jay
filling a combo box with two Columns,
Jan T.
Advice on optimizing spreadsheet,
schizoid_man
Re: HELP WITH A COUPLE OF SIMPLE FORMULAS FOR A NEW USER,
Norman Jones
Return sheet name from an address range,
avi
Re: User selection of folder and open all .xls files within folder,
Norman Jones
RE: Return cursor to previous cell,
Kevryl
Re: Changing cell text color based on cell number,
W. Wheeler
WHO CAN EXPLAIN THAT "macro problem"?,
GorKo
Re: how do I tell a macro to move to the bottom of a collumn plus one,
Gary Keramidas
Dynamic Data Range from External Text File, Filter,
Chad Richardson
VB Code Highlight Rows Based on Color Index,
akrosita2000@xxxxxxxxxxx
Re: Userform does not load,
Allen Lance
Re: NETWORKDAYS thru 2020,
Allen Lance
delink all charts in worksheet,
Gerry
problem in watching the comments tags when making protection to sheet,
thread
Re: array question,
Bob Umlas
- Message not available
- Message not available
DLL Vs. EXE?,
avi
Re: Export Specific Sheet in Listbox to New Workbook,
Norman Jones
Re: Using a macro to create a report on another worksheet,
Allen Lance
Re: Appending data and dates to a merged cell,
Tim
RE: Yield function in VBA,
sinclas
Re: how do i make a visual basic function calculate every cycle?,
Tim
Re: How to Insert Rows but not Ripple up others,
Norman Jones
Run Time Error 1004: Application-Defined or Object-Defined Error,
Diana
Re: How do I modify Cell Comments from VBA?,
Dana DeLouis
Recursive Classes - Design Pattern needed,
syswizard
Saving workbook causes new sheet and lockup,
dickie
Counting Specific Number of Days across Multiple Months,
cardan
Re: Test if there is data in a cell or not?,
Dave Peterson
Recording macros/Compatibility Mode Office 03/07,
souzalima
Re: Using CASE Statement to Derive Months from Numeric Dates,
Jon Peltier
Copy from clipboard in excel/vba: size limit ?,
Cyril
Question: Can't pass an Array to a class,
Charles
Re: EnableEvents,
Norman Jones
Macro to Outline based on Indent Level,
carl . gentry
Excel: Self-updating cell,
parkchan
Get address of found range to use in a formula,
keri
Re: Check a value in a range,
Michael Malinsky
Re: Mailenvelope Gives Error to Only One User,
Ron de Bruin
Re: About Officemenu(RibbonX),
Jim Rech
Updating Links Error on Buttons that call up Macros,
thewritings
Re: Making the macro's execution faster,
PCLIVE
Placeholder in find code,
keri
Protect Excel VBA Project from another Excel Macro,
Ram Chepyala
Re: Export to Excel 2007,
Jim Rech
Re: Clear Contents at 5PM daily,
merjet
VBA code crashes Excel 97 - Help please!,
GB
Cumulative totals,
mantrid
- Message not available
- Message not available
Re: Time arithmetic,
Bob Phillips
Automatic adjustment of Cell height?,
Tristan
Changing the font size in the charts,
navin
How to use RTD + Bloomberg/Reuters,
Rune . Hald
Help with combo/Listbox,
Les Stout
MACRO to Copy incl. hyperlinks,
djenzovoort
Re: application.screenupdating = false not working,
Niek Otten
Returning a zero value in an average total,
chedd via OfficeKB.com
Find value and replace cell below,
keri
Disable Move, but not Copy,
Mike
Re: Compile error: Method or data member not found,
Norman Jones
Making array in DLL available in VBA?,
avi
UserForm does NOT save changes to design (Excel 2000),
junk-mail
Blacnk Cells in Excel,
KW
Pivot table formulas,
don
Excel doesn't acknowledge formula as an operation,
don
Re: What is wrong with this macro?,
Dana DeLouis
- Message not available
- Message not available
Re: Argument value, application.run,
NickHK
Force a Date variable to store a time value,
Valued Customer
Re: SaveAsCopy generates error HRESULT:0x800A03EC,
NickHK
Defaults for 'Find',
kirkm
Re: How to "Step Back",
NickHK
Corrupt/ Bad Recordset,
SSweez
Help Please !!!!!!,
kylekelsch
RE: Use Cell Values to Create Tabs with specific names,
Vergel Adriano
Re: Date problems,
Tyla
If blank, insert adjoining cell value,
CLR
- Message not available
- Message not available
Re: code to select first sheet,
Dave Peterson
Add-Ins aren't loading,
Allen Lance
Macro Suddenly Stopped Working,
hvfr902
Re: Late binding,
Tim
Re: Is there a more elegant way to macro this?,
Tim
Re: Macro - update the cell to the left after a find,
merjet
Build a range from a cell,
tomtiv
is there a way to avoid repeating yourself in an excel if formula?,
gregory . halsey
Tabstrip and Treeview,
Sanjay
Re: How to trap an error with onError in a for i loop,
Jim Rech
Border question,
Joanne
Re: Sheet Protection Bug?,
Dave Peterson
Re: SpinButton problem,
PCLIVE
Travel to next cell immediately below, but filtered.,
StargateFanFromWork
Macros Referenced in Custom Menu Fail after Save,
Kevin M
Re: Auto Filter,
Ron de Bruin
Using Vlookup with IF statements,
Addy
Re: Can I simplify these IF statements,
Norman Yuan
Autofill in VBA question,
CarlosAntenna
Validation Error - Please Help!!!,
kylekelsch
Re: Validation Error - Please Help!!!,
Norman Jones
Re: Must I VBA?,
xrbbaker
Using Vlookup for IF statements,
Addy
Keep getting Errors in Code,
mlarsen1982
vbscript and Excel,
HSalim[MVP]
Split string into seperate cells,
keri
Re: Question,
Dee
Lookup to return multiple results in one cell,
jaybee3
Copying text from website OR selecting and coping certain text within a cell,
keri
Re: How to Print out Code,
Norman Jones
Re: Collate information from different files via a macro,
Norman Jones
Xl 2003 Sp2 error message,
Craig B
Re: Looping Thru Worksheets,
PCLIVE
Re: Pop up based on criteria,
merjet
<Possible follow-ups>
Re: Pop up based on criteria,
Bob Phillips
Question: "myself" in a Class,
Charles
Summing occurrences within a list,
Stuie
"Number Formatted As Text": How To Avoid?,
(PeteCresswell)
Re: Where's the Excel 2007 SDK?,
Jim Rech
Re: Problem with Excel 4 macros (I think),
Jim Rech
Re: Custom Add-in - How to Manage,
Dave Peterson
Running Macro on Multiple Worksheets,
VexedFist
Error on input box,
jamie . cutting
Loop through range and add each cell contents to a string,
Daveo
Hide sheet - Help,
Les Stout
Re: EXCEL SPREADSHEET HELP,
Norman Jones
Need macro to check if cell is not blank & previous cell is blank, copy information from row above & paste,
JenIT
Drop down list/Combo box?,
Sandy
Count non-zero cells,
Otto Moehrbach
Re: Calendar Pop up issue,
Norman Jones
Re: FileSearch parameters locked,
NickHK
Updating from internet,
keri
referencing to matrix labels,
Thijs van Bon
Merging Cells,
skulkrinbait@xxxxxxxxxxxxxx
Re: truncate numbers,
Norman Jones
Re: Bug - Programmatic copy/paste other sheet to activecell,
NickHK
Re: Report on missing numbers,
Jas
Find ID Number,
Hazel
Scope of variable,
avi
Stop,
StargateFan
Turn off ThisWorkbook Code?,
volodind
Listbox to display ALL Available Printers to User on a Userfrom,
Corey
Re: Adjust Windows Date/Time from Excel VBA,
NickHK
Re: Solver ignores constraints in protected sheets XL 2003,
Dana DeLouis
Charts with Combobox,
cougarfighter
Re: Send SMS from Excel,
NickHK
Pivot Table drilldown and protecting workbook,
Clayton Dool
Re: Summarise data by average in OLAP cube,
Tim
ADO Excel to Access - bulk transfer of array?,
Post Tenebras Lux
Object required error...,
IT_roofer
Re: Populate Excel Spreadsheet and Preserve Cell Formatting,
bony_tony
Add Page x of x based on sheets.,
myhnews
Re: Creating charts in non-English versions of Excel,
Peter T
modifying Ron DeBruin's menu macro,
SteveDB1
Labelling a persistent object,
pinkfloydfan
Fill a combobox preserving characters format,
phoudha
How to label an object that persists in memory?,
pinkfloydfan
Re: Date formattting in Excel when using OLE,
jodleren
Loading DBF into existing sheet,
E. F.
Re: Delete a Comment/Note/Macro,
PCLIVE
Change ColumnWidth for Multiple Columns?,
AJ Master
Calculated field in Pivot,
kansaskannan
Need Help,
kylekelsch
Re: Opening Workbook to a specific sheet,
Bob Phillips
vbide,
greg
Linking Excel files with part of a file name.,
waxcut
DeleteDuplicatesViaFilter From Chip Pearson's Website,
JohnHB
Re: Populate ComboBox list with Access data,
merjet
Re: Formatting Numbers,
clucas
Setting the Headers and Footers in Excel 2007 when exporting Information from Cobol program,
Matt
Workbook.Range Problem,
kylekelsch
CommandBar not Visible on Chart Pages,
Phil
RE: vbKeyCapital,
John Bundy
Code to make only certain sheets visible,
Michael
Re: Secure Add-ins,
pinkfloydfan
RE: Sub menuing,
Tom Ogilvy
vba Code Performance,
Klips
If Worksheet is active then...,
Darin Kramer
RE: loop problems,
SYBS
select columns by text in first cell,
zedascouves
Add values from two columns into third one in another worksheet,
minkokiss
- Message not available
- Message not available
- Message not available
Re: Warn a user in Shared workbook,
jari . toukkari
I can't figure this out - please help,
PO
Re: comparing spreadsheets spreadsheet compare add-in,
Jim Cone
word userform using xl database,
via135
Re: Help with dates,
matt
Re: input string into a column based on the value of a cell,
matt
Excel 2002 Verisign Digital signature,
gabe
Re: Generating report with VBA,
Ola2B
Automate IE right-click "Save Target As...",
matt
Place a list box in a cell,
Hank Youngerman
How to get all number combination from a list,
sauwing . wong
Subtraction by row,
Praetorian Prefect
- Message not available
- Message not available
- Message not available
RE: Help Please, so confused now.,
Khanjohn
New Book Template,
goss
Specifying a string in a range,
SV
Re: Why Checkbox count = 4,
merjet
Re: Why Checkbox count = 4,
Dave Peterson
Page Break preview shrinks unnecessary rows/columns,
myhnews
VeryHidden causing a problem...?,
Darin Kramer
Use the Selection.End(xlDown) method to select data in a column but do not stop at a blank space. PLEASE HELP!!!,
minkokiss
Get corresponding value,
equiangular
Re: Changing content of a cell based on changes in another cell,
Norman Jones
Re: Rerunning Macro takes longer after each consecutive use....Why?,
Dave Peterson
brain dead today - resize problem,
Susan
Variable Ranges,
kim . miller2
Application.GetOpenFilename,
Dan R.
code error,
Guye
- Message not available
- Message not available
Annoying Blinking and no real Help in NGs,
chfa
RE: if condition is met, shade cell [WORKS] but if value changes: erro,
Vergel Adriano
RE: MsgBox () - Put Numbers In?!,
Tom Ogilvy
Re: personal.xls,
Bob Phillips
ADO.NET DataSet,
PO
Re: Create worksheets from data,
Norman Jones
Stopping ANYTHING from happening when user clicks on an area of the sheet,
Andreww
copy excel chart to word - format problem,
Samirkc
Re: Is Auto Filter On,
Norman Jones
Protected sheet - Autofilter - Excel 97,
Midnight
3rd party software for building add-ins and help files,
Nick_F
Re: Handling errors,
NickHK
Re: Macro Use,
Bob Phillips
Re: MergeWorkbook,
Norman Jones
How to use automation to save xls into pdf from office 2007?,
Jun
Creating a Dynamic Array from list that may change in size,
dean . brunne
Date as variable vs in excel worksheet,
don
Split function,
ripon
Excel 2007 VBA - Disable "Exit" Command,
da_gl
Re: Worksheet_SelectionChange stopped working,
NickHK
Need Help writing a macro,
Sam Commar
Re: Userform, ComboBox and Outside data...,
Tyla
Re: Copying rows from worksheet A to worksheet B based on criteria,
matt
random hyperlinks in excel 2002,
rowej531
Macro Calculation Issues,
mastermind
Re: Microsoft Query - pull data from Access "Too many parameters",
merjet
Manipulating an image with from VBA,
avi
Re: Assistnace with Small Macro. Thanks in advance,
Bob Phillips
Re: retrieving the day of the year,
Dave Peterson
Re: Select and Copy a range,
Ron de Bruin
Re: worksheetname,
Norman Jones
Avoiding an error,
Francis Hookham
Find in a column,
Francis Hookham
Re: 'Option' Buttons,
Norman Jones
Jagged Arrays Problem - How to Assign Arrays to an Array,
Zigs
Jagged Arrays,
Zigs
Not recognizing a specific sheet the first time,
avi
Run Time Error 13 Type mismatch,
VexedFist
Excel document file changes,
clubababyseal
Does anyone know why keyboard shortcut does not work in Excel 2007 for callback functions?,
Weiqun
RE: Sorting and averaging. Do I need a macro?,
I. Miller
Create a registry key for an Excel file,
mrlanier
RE: Cutting cell with object,
Tom Ogilvy
custom popup menu in cell,
roy
RE: How to find and count # of files in a directory,
Tom Ogilvy
RE: Simplify this into a loop,
Joel
creating popup menu when user right-clicks on cell,
roy
RE: Imperfect Matches,
Tom Ogilvy
How to install a new version of an Excel program - Import file does not allow replace to modules,
billgeo
combinations,
PST
RE: Code modification help please,
Tom
For-Each-Next Freezes Excel,
J. Cornor
Re: make VbA invisible,
Norman Jones
RE: not sure on constants,
Curt
RE: Enter data in correct row from form,
Stuart
Subquery Confusion,
Diana
RE: need some help for linear interpolation,
Tom Ogilvy
Cycle through pivotcharts,
Michael
Extend Excel C API add-in for using RibbonX API,
Nandan
Creating a range stack,
Michael Siegel
Re: TreeView Control 6.0 in Excel 2003,
freewindvalley
File Not Found Automatic Cancel,
mlarsen1982
Excel97 to 2007,
BrianG
Must I Always Click Twice to Return to My Document from a User Form,
susiecc via OfficeKB.com
code to deselect a chart modified by VBA,
Brad
Application Status Bar circular,
JB2010
Slow chart problems with very large data sets,
professorplum101
Re: BeforeClose Event,
Bob Phillips
How to add filter to email macro,
kevin . marchand
Re: Change numericals in alphabets.,
Norman Jones
Cell Value to String and Trim then Delete un-needed Rows,
VexedFist
RE: Using the Dictionary object,
vqthomf
Email Booster from Excel,
Safi.
Adding/deleting ranges and renaming accordingly,
Michael Siegel
Validation check,
Guye
Filtering data via VBA code,
haas786@xxxxxxxxx
Re: how to add a macro,
Norman Jones
Help needed with Inputbox problem,
Les Stout
Re: Togglebuttons in a Userform.,
Susan
Re: SendKeys "(^ {HOME})",
tc69
Re: Grouping values,
Norman Jones
drop down list,
Guye
Re: Userform enable/disable,
Coza
Excel Macro Question - correction,
jcroether
Excel Macro question,
jcroether
Unattended Installation WindowsXP and Software,
gvozdok
Code for Work Sheet,
Guye
looping through one range to fill another,
SYBS
MSXML2.DOMDocument,
krsone21121983
Re: copy column cell data onto another worksheet,
Norman Jones
Re: Convert Text into Formula in VBA,
Norman Jones
Re: calling/running a macro on another worksheet,
Norman Jones
sendkey problem,
kaiser
copy chart delay (musa.biralo query),
Matthew Dodds
number transform right at data entry,
bbxrider
Compile 6 identical ranges(size and fields) into a text file.,
dean . brunne
Re: clear picked cells,
JE McGimpsey
Re: Need to replace existinf graph for new graph with the same name,
Tim Williams
Re: looking for repetitive information in a report,
David Portwood
Pls Help! Sending data to an IE web form.,
DW
RE: More Excel 2007 Speed Issues,
Wei Lu [MSFT]
Pivot Table VBA question,
TomCon
Re: newbie question,
Dave Peterson
before double click,
T. Valko
Hiding Empty Rows,
AJ Master
Custom Footer (Dynamic text with Static text),
Maximus
Re: InputBox that obtains Workbook, Worksheet, and Range,
Norman Jones
Re: adding date with double click,
Gord Dibben
Re: Cannot debug,
Bob Umlas
- Message not available
- Message not available
Using a worksheet as a table in an SQL query,
steveh
Array formulas + more than 255 chars,
gmac
Re: I need a macro that fills in a cell with an "X" if I click it.,
Norman Jones
copy and pasting header information,
ghamilton
RE: Automation error. The object invoked has disconnected,
Mike
Re: Flashing highlighter,
Gord Dibben
Re: Opening Workbooks,
Ron de Bruin
Re: macro to increase a value and print,
Ron de Bruin
remove the border for all series for all charts,
velocityinc
Automate Copy and Paste,
maperalia
- RE: Automate Copy and Paste,
Joel
- RE: Automate Copy and Paste,
maperalia
- RE: Automate Copy and Paste,
Joel
- RE: Automate Copy and Paste,
maperalia
- RE: Automate Copy and Paste,
Joel
- RE: Automate Copy and Paste,
maperalia
- RE: Automate Copy and Paste,
Joel
- RE: Automate Copy and Paste,
maperalia
- RE: Automate Copy and Paste,
Joel
- RE: Automate Copy and Paste,
maperalia
- RE: Automate Copy and Paste,
maperalia
- RE: Automate Copy and Paste,
maperalia
Re: Resize the image in excel 2007,
Dave Peterson
- Message not available
- Message not available
excel loading add-in..,
shoelow69
Re: Making modifications to macro module from R. De Bruin,
Bob Phillips
about the limitation of bas module,
shigyapi
RE: # sign doesn't work with between-date searching,
DaveMZ
Re: Windows in Task Bar in Excel 2003,
Bob Flanagan
Open a file in the same instance with ShellExecute,
MichDenis
macro-written correct formula returns #NAME? and #VALUE?,
s.a.
It works but I need better code...,
fzl2007
Trouble with SENDKEYS?,
DW
Re: Modeless Userform Not Displaying,
Bob Flanagan
Re: Check for existence of a file,
Norman Jones
Problem Saving with the 'Must Enable Macro' workaround,
JustBreathe
Re: macros and collections,
Norman Jones
Copying data based on certain criteria,
haas786@xxxxxxxxx
Format to Value,
scoutmaster
Re: UserForms, mandatory completion of fields,
mikeg710
Copy paste to another Workbook, Error 1004,
Steve
Re: How to work with only one colum of a variant,
Norman Jones
Re: count rows till cell is blank,
Norman Jones
Re: isempty close,
Roger Govier
Date Format Frustrations,
scrawny
Re: Strings to Numbers,
David McRitchie
How to know if a workbook is already open?,
David Portwood
Control G,
kirkm
Modifying hyperlink beyond default options,
Michael Siegel
Re: Type mismatch error in Find method,
Jim Cone
Locking all cells of a given color in a given range,
Michael Siegel
Sending emails with VBA is somehow getting stopped - help appreciated...,
jeffstryer
.xla removal,
Coza
Convert hours to days-hours,
noname
Refering to Active Wbk from VB6,
avi
Program for Fan Balancing,
joe . engel
Changing the CONST Variable,
VexedFist
Cahnging the CONSTR Variable,
VexedFist
Userform change question,
Patrick C. Simonds
RE: import access dates into xl "calendar",
urkec
Problem in Range VBA excell...,
JM
Re: second event,
Don Guillett
RE: Can I add this VB script to a VBA script?,
Gary''s Student
Re: How can I count BOLD letters in a cell?,
JE McGimpsey
Re: Search lastname + firstname (search on uppercase),
merjet
Type mismatch?,
StargateFan
SaveAs command doesn't save extension,
stewart
Write VB6 code to be used with VBA,
avi
Formula req for macro,
Gautam
Re: game in excel,
Norman Jones
Re: How do I keep Hidden Columns / Rows from being Unhidden / Refe,
tc69
probably really simple for most, but not me,
yankeefan62
Re: formula or code?,
Jim Cone
complication between VB syntax and Object Value with [-] minus character,
Eldi Munggaran
Save worksheet as new workbook,
stewart
Apply bottom border only on filled cells, leaves blank cells without border?,
StargateFan
Re: Toughy...,
JE McGimpsey
Re: Change Event,
Don Guillett
Disabling events within an event handler,
feltra
Re: VBA equivalent for WScript.Sleep,
Dave Peterson
Combining a Text or picture into another picture,
avi
Re: Automatically add a textbox to a user form based on user requireme,
Helmut Weber
Re: Address of first visible cell,
Norman Jones
Selecting print range,
Tamas Konczer
How can I add scrollbar to a number of cells,
rachitm
Re: Deleting cells,
Norman Jones
Re: Goal Seek,
equiangular
Re: printing,
Dave Peterson
- Message not available
- Message not available
addresses,
Oggy
Re: EXCEL VALUE PASTING,
Norman Jones
Re: Major 2007 Excel Problem,
Nick Hodge
show daily sales as a percentage of monthly sales target,
Max Bialystock
Macro converting Wind Direction from text to degrees,
Norm Shea
Excel 2007Warning, "The following fetures cannot be saved in a macro-free workbook:,
BobR
Web Query,
Alan
65532-65536:Hyperlinks,
Jay
Declaring a variable as a range in another worksheet,
peturg@xxxxxxxxx
- Message not available
- Message not available
Re: PointsToScreenPixels Documentation Incorrect,
Peter T
How can Excel check that a text string is even-numbered or not?,
StargateFan
Paste as Excel object (not as picture),
avi
Audible Alarm Marco w/Pop-up Message,
JustWork
Re: upgraded from 200 to 2007- modify macro menus,
Ron de Bruin
Live chart in a userform,
pinkfloydfan
Errors of Adding OWC10 Spreadsheet reference,
Bula
Edit Chart Macro Help - Skip ActiveChart Selection if no data,
conorfinnegan
Re: Summing a Column of Variable Length,
merjet
Re: copy cell,
Ron de Bruin
Calling a VBA add in from a macro subroutine,
madboy_1
Re: auto filter macro,
Norman Jones
calculate hours using start time & end time, excluding weekends,
noname
telling a macro to go back to where it came from,
ghamilton
Re: Delete Worksheets Named Sheet1, Sheet2, Sheet3, etc.,
Susan
Re: Column Width Problem,
Greg Lovern
Merge Multiple Workbooks,
ir26121973
- Re: Merge Multiple Workbooks,
Ron de Bruin
- Re: Merge Multiple Workbooks,
ir26121973
- Re: Merge Multiple Workbooks,
Ron de Bruin
- Re: Merge Multiple Workbooks,
ir26121973
- Re: Merge Multiple Workbooks,
ir26121973
- Re: Merge Multiple Workbooks,
Ron de Bruin
- Re: Merge Multiple Workbooks,
ir26121973
- Re: Merge Multiple Workbooks,
Ron de Bruin
- Re: Merge Multiple Workbooks,
Ron de Bruin
- Re: Merge Multiple Workbooks,
ir26121973
- Re: Merge Multiple Workbooks,
Ron de Bruin
- Re: Merge Multiple Workbooks,
ir26121973
- Re: Merge Multiple Workbooks,
Ron de Bruin
Object required error 424 why getting?,
Chet
Microsoft.Office.Interop.Excel Texttocolumns C#,
Cheryl
Losing worksheet calculations reference when deleting a sheet,
highlystrung
Re: ADO recordset,
merjet
RE: Import data using QueryTable somehow change sheet cells refere,
JackCali
Read from a terminal application,
Prometheus
Check if Excel file is password protected,
Christopher J Tallos
load/parse large text file,
Keith R
Find repeated values in multiple worksheets and create summary worksheet,
szadoian
Name a sheet using letters from a string?,
vrzimmerm
RE: Pause/Delay to Import Data, then Apply Protection to Sheet,
ryguy7272
Re: clearing columns in VBA,
matt
Re: code for selecting 2nd visible row,
Dave Peterson
Prevent an Image from being removed,
Sanjay
Macro to copy text between delimeters,
Vic
Activate an open window and send keystrokes to it.,
Prometheus
Re: Time,
merjet
- <Possible follow-ups>
- Time,
Huston
Adding counter to new worksheet,
vrzimmerm
Re: Bob P - Count conditional formatting,
maryj
plz plz help me out with this,
ayan
RE: Hyperlink not showing complete file path,
Safi.
Re: Filling a ComboBox range on focus,
Norman Jones
Open a file - Application unknown,
Snirp
Supressing "Do you want to save the changes you made to <file>?" message,
Chrisso
Tree View Design help,
Ram
Help sought re vbmodeless form rendering a class module useless,
The Clint
Help with disabling items in the menu,
Les
Re: Help with Command Button,
Norman Jones
Arrays and picture,
CHRIS
Re: Date format,
ward376