I need some code to select a range starting at a1 and going across 3 rows and down to the bottom of the sheet(the last cell with any data e.g. lastrow)

currently the columns are a, b, d as column c is hidden.

Is offset the right coding to go with?

column D can't be hard coded in as the number of columns hidden will change. today only C is hidden tomorrow it could be more.

Any help is appreciated