create Range Statement Dynamically

[Danny54]

Good Morning

how can I go about creating a dynamic Range statement used in my excel vba macro?

the statement created would be
Range("$F$4:$H$6").Select

looking at the follow sheet

Thanks

a	b	c	d	e	f	g	h
z	a	b	c		1​	2​	3​
z	a	b			x
z	a	b				x
z	a	b

 

[Joe4]

Based on your example, this would work:

Range("F4").CurrentRegion.Select