VBA code for passing a variable name as a paramter to Range object

[vidyuthrajesh]

Hello,

unsure if my query is logical. I have stored the column number in D5 and this should be used as an input to range object. For instance,the below code works well, but instead of referring B:B ( highlighted) directly i need to use the value stored in D5 ( which will be 2 in this case)

Please Login or Register  to view this content.

[shg]

Maybe

Please Login or Register  to view this content.

[JS411]

shg, Did you intend to write....

Please Login or Register  to view this content.

[shg]

Either would work, depending in the cell contents.

[JS411]

Per the OP, the cell contents is a Column Number.

[shg]

Then Columns it is. Range would be more versatile, but you're exactly right for the OP's stated plan.

[vidyuthrajesh]

Thanks Shg / JS411 for your support. It works. aplogies for delayed submission as i had just accessed my account.