Quote Originally Posted by mikerickson View Post
There are non-volatile alternatives to OFFSET.

=OFFSET(A1,0,0,COUNTA(A:A),1)

can be replaced with
=INDEX(A:A,1,1):INDEX(A:A,COUNTA(A:A),1)

for example, but there is no generic replacement.
Thanks for all the inputs ..

I think I am not able to convey correctly what I mean, being fairly new in VBA I use a Formula Approach even while writing codes in VBA...

Me learning VBA is definitely a long process however , if I were to replace every formula written in VBA using the Application,WorkSheetFunctions Approach and then converting it into values is it going to help? to make it faster..

The OFFSET is used in the Dynamic Dropdowns, I have never tired the INDEX though I would be more than happy to try that out..

Since there a lot of Unequal Columns I tend to use the ENtire Columns or ELse Indirect("A"&Counta(B:B))..

So how do i use it sparingly..

Warm Regards
e4excel