This is it,
Range"A*".Select (where * is a variable row)
then Range "A*:R*".Copy
Where I'm having the problem is setting the variable
does this explain better?
henkus
I would like to be able to copy an entire row and paste it to another location by just selecting the cell in row A. I'm pretty new to VB and can't figure out the syntax. please help!!
Iwould like to be able to hide or lock up the menu bar in my exel 98 application through an Auto open macro and re-establish again with Auto close. I've managed to do this with all the tool bars but can't work out how to do it with the menu bar. can it be done?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.