wirint code in vba

[turtlejack]

Sub ResizeRng()
x =(g20)
Selection.resize(7, x).Select
End Sub

I want to resize a range using the value from cell g20.This value will not always be the same, so, i want to use a variable, to identify/refer/call,,,etc. this cell..
please help

 

[turtlejack]

oops,spelled "writing" incorrectly in subject

 

[PHV]

Have tried to replace this:
x =(g20)
By this:
x =[G20]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[turtlejack]

havent tried it yet.. I sure will though.. hope it works. I have a feeling it just needs a little push to make it do what I want..Thanks in advance

 

[turtlejack]

just to close this out, thanks for the help, this code works great.