Ideally, I'd like to create an app in excel that requires approximately 400 rows, but excel only has 256.
I really need to do this without seperating onto 2 or more worksheets.
Anyone know if/how to extend it?
Thanks
Pete
Ideally, I'd like to create an app in excel that requires approximately 400 rows, but excel only has 256.
I really need to do this without seperating onto 2 or more worksheets.
Anyone know if/how to extend it?
Thanks
Pete
Hi,
Excel will allow 65536 rows. I take it you meant columns :question:
Anyway, there's no way to increase the number of columns in a normal Excel worksheet. The Microsoft Office Web Components spreadsheet control allows 676 columns and will be available if you have Excel 2000 or later. However, this could be tricky if you haven't used it before.
I've got to ask this question - do you really need more than 256 columns? Maybe there is an alternative way of doing what you need?
Thanks Dan. (I did mean columns, oops!)
I think I'll have to think of an alternative method. I'm creating a holiday chart which needs names down the left column, and days along the top row... I didn't want to use more than one sheet because I need other controls on the sheet, and a dozen or so sheets each with several controls on would take ages to save, and slow down my VBA coding... but maybe that's what I need to work on eh?!
Thanks for your help, any suggestions on the above would be appreciated too.
Pete
if your dates go across the top can you take out weekends? If you drag a date with the right mouse button you have an optiion to only drag weekdays.
Just a thought.
:guitar:
I expect you have already considered it but why not put the names across the top
W
Don’t have an account yet? Register yourself now and be a part of our community!