Filling cells

[Jazzzbo]

I would like to count the rows in a worksheet, using the values in column A, and then copy the contents of B1,and , C1 into all the rows below them.

I did this a long time ago, but my current attempts don't work.

I tried a macro, but it doesn't let me us my Rows.Count variable.

Suggestions, please?
Jim

[humdingaling]

To figure out last row,

can you use

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

my suggestion is the middle one as it focus on column A
**you can use a larger number than A65536 if your version of excel allows and if you have more than 65536 rows

[protonLeah]

I tried a macro, but,... But I didn't post it

Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.