range with dim select

[ianripping]

I have a number generated by a Dim named regtype

I want to define a range like:

rang(b:regtype) using vba

how do i do this?

i tried :-

range.address(regtype , b).select

but didnt work

any suggestions

 

[Frank Kabel]

Hi
not quite sure but try
cells(regtype,"B").select

if regtype is a number representing your desired row and you want to
select the cell in column 'B'

 

[Vasant Nanavati]

Range("B" & regtype).Select

 

[ianripping]

thanks frank that great, how would i select regtpye row, from column
to m

 

[Frank Kabel]

Hi
try something like
Range(cells(regtype,"B"),cells(regtype,"M"))

or
Range("B" & regtype & ":M" & regtype)