Using offset function to select a range of cells based on active cell location

Hi,

Seasons Greetings!

How to use offset function to select a range of cells based on active cell. I mean want to tell excel that select set of cells every time from active cell. I'm trying the following code in my file, but not getting this to work.

Please Login or Register  to view this content.

Appreciate your help on this.

Thanks!

Happy Holidays!

Something like this:

Please Login or Register  to view this content.

check do you need to use 13 and 11 in resize part.

I'm sorry, I'm not good at vba, still learning
Where should I change the lines in my code to the one you have suggested.

Thank You very much!