How to do Input Msgbox to copy select column to sheet 2 ?

**yannipr** · 07-10-2008, 03:21 PM

Hi
How to do Input Msgbox to select row ( any row ) instead of line "Columns("D:D").Select" ?
For example my macro is

Please Login or Register  to view this content.

Thank you

**VBA Noob** · 07-10-2008, 03:30 PM

Maybe

Please Login or Register  to view this content.

VBA Noob

**yannipr** · 07-10-2008, 03:42 PM

Thank you but i getting error "subscript out of range" why ?

**VBA Noob** · 07-10-2008, 03:44 PM

I assumed Sheet 2 was an error in your code so changed to Sheet2. Try changing that

VBA Noob

**yannipr** · 07-10-2008, 03:49 PM

You are right! thank you

**Kenneth Hobson** · 07-10-2008, 03:52 PM

I guess if you put the code in a sheet rather than a module you would get that.

Thank you but i getting error "subscript out of range"