I am using a worksheet to enter data, this code copies and resorts by the
second column and populated a second worksheet. and works great (thank you
to the kind soul who gave this to me BTW)
I'm trying to modify it to bring a third column along for the ride. I don' t

Public Function Get_dir()
Windows("PEM.xls").Activate
With Worksheets("sheet1")
.Activate

I am trying to develop code so that on the event that a1 is not blank the
cursor will go to B2 and take $A$1*B1.  Then move over one cell to C2 and
take $A$1*C1 out to a100.
So far I have;

How do I make a macro in Personal .xls available on other worksheets without
having to open Personal.xls explicitly?  I have a file that I get twice a day
that needs to undergo some modifications which are stored in a macro in
personal.xls.  I open Excel by Dbl-Clicking my .xls ...

I have a worksheet (A) which gets updated by cell values in another worksheet
(B). Worksheet A is only valid up to a particular date. After that date, I
want to be able to lock every value in the worksheet A so that I can still
update worksheet B (manually) and NOT have worksheet ...

It's been a while since I've used VBA, I'm hoping someone can
help me.
I have a spreadsheet of data for several accounts, I divide the
data into sections based on the account number in Column A. I

Excel 2000 - I have a spreadsheet that is laid out to have enough columns
formated for the maxium possible uaeage for this application.  The number of
columns actually used will vary.  I know the maximum columns used, but I need
a macro that will delete all blank columns.

Much thanks in advance:
I have a pivot table, "Pivot1". For example sake, in column A I have
list of countries.  In columns B through C, I have other attributes
that tie to column A (ie. cities, provinces, states, etc.) Note:

Hi expert,
I need to write a little excel vbscript with ADO recordset code to
change the first column, whenever the cell starts with first letter 'D'
(which means a district number), then I need to replace the cell to the

This is kind of similar to my last post, but I'm working with AND
statements again in VBA.  I'm trying to enter a value into a cell only
if 2 or more different check boxes are marked off.  Although this is
very very wrong, something like:

I would like some help please.  I have a swag of pivot tables (that
I've structured to all point to the same pivot cache).  As part of a
regular process I need to assign this cache to point to new Data files
and new Data ranges.

I use an Excel vba to "upload" data from Excel data to my accounting
software by sendkey command. The steps are 1)real data from Excel cells, 2)
switch the active window to accounting software, 3) use sendkey command to
fill accouting system blank field, 4) switch back to Excel ...

I Wish to use a macro to insert   ActiveCell.FormulaR1C1 =
"=TIME(6,30,0)"  in a cell. With the 6 and the 30 to be variables from
a input box.
Ian

Hey everyone,
I have a macro that is generating an email based on input into a
userform.  How can I tell it to insert a tab space into the email?
I've tried just tabbing the text in the macro and that doesn't work.

I'm new to this so I hope I get it right in order to get some help.
=Look(A13,D13,(A13),3)*E13
This is the formula entered into a cell expecting a specific value to
be returned to it.  The formula calls the VB code listed below.  This