How to set Range as a User-Defined variable

[Ulnarian]

Hi, I'm a complete beginner to VBA and I'm really just doing this for sun (sorry for any newbie questions!).

Anyways, I would like to write code that prompts the user to enter which Column should be copied into Column A and then have the code set Column A = to the chosen column.

For starters, I have this simple code which gives me a 1004 error (Method Range of Object_Worksheet failed). Can anyone guide me as to what I'm doing wrong here:

Please Login or Register  to view this content.

[mohadin]

Hi
try

Please Login or Register  to view this content.

[Rick Rothstein]

It would be more efficient to restrict the range to the number of rows in use rather than all of the cells in the column, but since that is what your code does, consider writing your Click event code like this...

Please Login or Register  to view this content.

[alansidman]

Change your code to:

Please Login or Register  to view this content.

[Rick Rothstein]

Change your code to:

Please Login or Register  to view this content.

Just pointing out for the OP benefit that you changed the InputBox requirement from the Column Number that the OP's original code asked for to inputting the Column Letter instead.

[Ulnarian]

Perfect, thanks all. Actually, I think the string approach works better here for my purposes.