Vba Code to Select Range with blanks

[SharmaAntriksh]

I have a dataset where i am trying to select a range but there are a lot of blank cells in between and each time i run

range("a2345:c3345").end(xlup).select

It stops at the first blank

I came up with a temporary workaround for this by looping this code

Sub SelectRange()

For x = 1 to 300

range("a2345:c3345").end(xlup).select

Next x

End sub

The only problem is once the data set gets bigger the loop value of x =300 will stop in between, i want to be able to get to the range Range("a1:c1") without looping while selecting data from a2345:c2345

Let me know if there is a solution for this. Thank you

 

[Norie]

Is there a specific column that will always have the last row of data?

 

[SharmaAntriksh]

Yes the ranges("a1:c1") will always have data

 

[Norie]

So the range A1:C1 will always have the last row of data, so the last row of data will always be 1?