Is there a method to refresh the Usedrange within a "With" Block?

[prabha_friend]

With .UsedRange
	.Select
	.Columns(.Columns.Count).Offset(0, 1).FormulaR1C1 = "=countA(RC[-" & .Columns.Count & "]:RC[-1])"
	.Rows(.Rows.Count).Offset(1, 0).FormulaR1C1 = "=countA(R[-" & .Rows.Count & "]C:R[-1]C)"

The newly added row and column are not getting included in the Usedrange. How to refresh it?

One more question:
Why usedrange.offset not giving the expected result?

Thanks in advance.

 

[ukmikeb]

The newly added row and column are not getting included in the Usedrange. How to refresh it?

One more question:
Why usedrange.offset not giving the expected result?

Thanks in advance.

1, Refresh by "With .UsedRange"

2, UsedRange.offset(1,1) will offset the WHOLE range 1 column to the right and 1 row down.

hth