how do i mention range

range will be vary
how do i mention without specifc range

With ActiveWorkbook.Worksheets("Sheet1").Range("A1:K70")

Code:

---

Dim i As Integer
Dim j As Integer

With ActiveWorkbook.Worksheets("Sheet1").Range("A" & i & ":K" & j)

---

i and j would change depending on what you were doing at the time.

still object defined error is form A1 there is no issue issue is k71 sometimes its vary
With ActiveWorkbook.Worksheets("Sheet1").Range("A" & i & ":K" & j)