Select from fixed cell to used range

[Manish84]

Hi Friends,

I am very simple query, but i am not able to find out how to do it.

In the attached file, i want to select the range from cell B8 (which is fixed), to used range i.e. till Cell F18 (but the problem is, cell F18 is not fixed). Last used row or column can change. I want to do it by using VBA.

Here is the sample file Select Range.xlsm

Thanks & Regards,
Manish

[hemesh]

Hello manish does your last cell is always going to be in column F then use below code

Please Login or Register  to view this content.

if columns can also vary then use

Please Login or Register  to view this content.

[Manish84]

Thanks Hemesh, for your quick response.

I will go with second one as column is also not fixed .

Regards,
Manish

Hello manish does your last cell is always going to be in column F then use below code

Please Login or Register  to view this content.

if columns can also vary then use

Please Login or Register  to view this content.

[hemesh]

Thanks for the feedback