Question on selecting sheet with user input

[armando12345]

Hi everyone,

I have this macro that works perfectly basically. This sheet takes columns from one sheet and pastes them into another sheet. I want it to be very dynamic, hence the input boxes. Basically, I want to be able to take out 2 of the input boxes and just use the header row input to also find the worksheet name. So, they would only be asked where the headers are in the sheet and then basically the macro would know the sourcesheet and targetsheet already. Thanks in advance!

Please Login or Register  to view this content.

Edit: I tried using the HeaderRowS and headerrowT variables in place of the initial input boxes but this gives me an error.

[Marc L]

Hi,

as the Parent property returns the worksheet object where a range stands …

[armando12345]

Hi,

as the Parent property returns the worksheet object where a range stands …

I don't really understand what you're trying to say

[Marc L]

So see the explanation for Range.Parent property in the VBA help …

[armando12345]

So see the explanation for Range.Parent property in the VBA help …

Right. I know how that works. My main issue is that I get an error whenever I try to change the code. I want to get to a point where I can do HeaderowS.worksheet.name and the macro will work.