First, the notation you are using is Range notation which cannot be used to directly address anything. Instead you declare that range and then use it in your expression.
Second, the notation you used is for a sheet, not a column, and you cannot do math operations on a sheet, because there are no "basic math for whole worksheet".
Instead you can loop over all the columns:
range ra = [Book6]Sheet1!; loop(ii,1,ra.ncols) { range rac = %(ra$)!wcol(ii); rac = ln(rac); }