join column & variable to replace cell number "V65536"

[d_carr]

my question:

how do i join "V" (my column) and "erow_three" (my number of rows) to replace "V65536" in the following statement:

Range("X1") = "=COUNTA(V2:V65536)"


my current code:
Dim ws_three As Worksheet
Set ws_three = Sheets("Responsiveness - operations")
Sheets("Responsiveness - operations").Select
erow_three = ws_three.Cells(2, 1).End(xlDown).Row

Range("X1") = "=COUNTA(V2:V65536)"

 

[d_carr]

thanks robert, luv ur work!
works like a charm.

 

[Trebor76]

I'm glad it all worked out