hi back!

no, i dont want it to record the names. i want it to count the spreadsheets
if and only if they're names are 1.xls, 2.xls...25.xls, then enter the values
1 through n in (what i should have typed the first time) a5:a:30. if there
are only 5 spreadsheets open (ie 1.xls, 2.xls...5.xls) then it starts in a5
and enters 1, 2 in a6,...5 in a9

thanks a million

"Alok" wrote:

Hi,

Just need some clarifications to answer your question. Do you mean that the
code should record the names of all the open workbooks in A5:A25? Are they
named 1.xls, 2.xls etc? Also you probably meant A1:A25 if all 25 were open
and their names had to be recorded?

Alok

"lawson" wrote:

Hello

i have a spreadsheet that upon opening, it counts all the spreadsheets (n)
that are also open and are named inclusively between 1 and 25. it then enters
the values 1, 2, 3....n in column A5:A25.

thanks

Lawson