Quote:
Originally Posted by sumesh56
I opened the worksheet. vba -click on the module and pasted yours. then i clicked on the macros in the code group. now i can see the code name in the list. But on vba doble clicked on the worksheet. clicked view code. pasted yours. went to macros. i cannot see the your macro there. it is not listed there. kindly detail it . thanks.
|
this macro is not serving the purpose. I open a worksheet with so many sheets. i select one and copy contents from it. goes to the second sheet paste it there. then comes to the first one. then i should get the sheet with the top row. that is what i want. means i should get a sheet or a file open with the top row displayed. no matter if it is opened afresh or is being selected from a batch of sheets.thanks