View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Roger Bedford Roger Bedford is offline
external usenet poster
 
Posts: 3
Default Positioning a sheet

I have a spreadsheet to which I add a column of data every day.
I have set my columns on the spreadsheet so that all of them are about 1.5
inches in width.
This creates 8 columns that show on my screen at any one time.

I would like a macro that will always position the sheet from left to right
so that the last column on the right is a blank column and the other 7
columns to the
left of the blank column will have prior data in them showing as well.

Any suggestions would be much appreciated.

Roger