Tweak code to use string vs number

[dannac]

Please Login or Register  to view this content.

The above code works as should.

What I would like to do is have the input box allow for a column instead.
Say I would like to go from activecell to col M.
I tried using "strings & type 2" but cannot get it to work.

[Norie]

dannac

The inputbox is already being used for a column.

Do you mean that you want it to work for both column letter and column number?

Please Login or Register  to view this content.

By the way, it's not a good idea to name a sub after an existing VBA method.

[dannac]

Norie

I would like to type the column "letter" in the input box ... ("What column do you want to copy to")
instead of the number of copies.

I'll change the "FillRight."

Thanks

[Norie]

The code I posted allows you to type the column letter

[dannac]

Works great ... Thanks Norie