vba - Select column 1 to 10 of ActiveCell row in Excel -

this regarding macro in excel.

while combination of keys pressed (i.e. macro triggered), need format changes columns 1 10 of row has activecell.

at moment have selecting entire row

activecell.entirerow.select 

however, need select row 1 10. think ought

activecell.range(1, 10).select 

but not work.

just clear, have read

activecell.offset(5, -4).select 

but not going work in case. activecell column of row , hence hardcoded offset not going help.

so, excel gurus there, hoping quick stuff, somehow can't find answer. please help.

if columns 1 10 (i.e. j) ought work:

range("a" & activecell.row & ":j" & activecell.row) 

for example if activecell m14 select range a14:j14. can format how like.

hope helps