macros

[Mully]

I am using the following macrn a table that has 40
names and in the cells along side a variety of numbers. I
need to be able to duplicate several of the names and
numbers along side, in say cell "A42" to cell "A49" which
are blank how do I do this without writing a new macro.
Example of macro below.

Range ("A2"). Select
ActiveCell. FormulaR1C1 = "A.SHAW"
Range ("A3"). Select
ActiveCell. FormulaR1C1 = "M.HALL"
Range ("B2"). Select
ActiveCell. FormulaR1C1 = "195"
Range ("C2"). Select
ActivCell. FormulaR1C1 = "1054"
Range ("B3"). Select
ActiveCell. FormulaR1C1 = "194"
Range ("C3". Select
ActiveCell. FormulaR1C1 = "21"

and so on to end of table.

Many Thanks

Regards

Mully

 

[Don Guillett]

Selections are NOT necessary OR desirable

Range ("A2")= "A.SHAW"
Range ("A3")= "M.HALL"
Range ("B2")= 195
Range ("C2")=1054
Range ("B3")= 194
Range ("C3")= 21

range("a42:a49")="whatever"
range("a42,a45,a48")=1

 

[Mully]

Hi
Perhaps not explained very well, re wrote macro as
suggested works ok however on duplicating a name the
constant figures do not enter cells. for example -

A2 = A. SHAW.B2 = 195.C2 = 1054
A3 = M. HALL.B3 = 194.C3 = 21
ABOVE ALL OK

(CELL A40 ENTERED A. SHAW) CELLS B40 & C40 REMAIN BLANK.IS
IT POSSIBLE WITHIN THE MACRO FOR THE CONSTANT FIGURES AS
IN B2 AND C2 TO BE AUTOMATICALLY ENTERED WHEN ENTERING A
NAME IN A40 OFF THE TABLE. IS IT ALSO POSSIBLE WHEN THE
LIST IS COMPLETE FOR IT TO AUTOMATICALLY TRANSFER ITS SELF
TO ANOTHER SHEET WITHIN THE WORKBOOK. WHAT WOULD I HAVE TO
DO IF A NAME WAS IN THE LIST AND FOR CERTAIN WEEKS OF THE
YEAR HE/SHE WOULD BE ON HOLIDAY AND HIS/HER NAME WOULD
NOT BE NEEDED ON THE LIST. SORRY ABOUT THE QUESTIONS AND
LONG EXPLANATIONS I'M JUST A NOVICE TRYING TO SPEED THINGS
UP FOR MY COMPANY.

MANY THANKS AND APPRECIATION FOR YOUR TIME AND EFFORTS.

REGARDS

MULLY