excel - VBA - Counting the number of filled cells in a row -

the following code far. tips?

 wsheet      colcount = .range(1 & .columns.count).end(xltoright).column   end 

what doing wrong?

try:

colcount = wsheet.usedrange.rows(1).columns.count 

(revised)