how do i mention range

[kamakshi]

range will be vary
how do i mention without specifc range

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

[Hack]

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.

[kamakshi]

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)