kylefoley76
Well-known Member
- Joined
- Mar 1, 2010
- Messages
- 1,553
anyone know this. i've got 1200 line continuations and excel and word are saying that that's too much. excel 2007
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
what's maximum number of line continuations in a vba code
- Thread starter kylefoley76
- Start date
Norie
Well-known Member
- Joined
- Apr 28, 2004
- Messages
- 76,377
- Office Version
- 365
- Platform
- Windows
Kyle
I don't know about you but I think there's quite a few people who think that having 1 million rows isn't exactly the best idea MS had.
You could easily create a simple text file with this information and use that for whatever you want to do.
In fact you could probably just copy it to a worksheet, tweak things a bit and save as a CSV.
You could then use VBA's file I/O functions which are common to most Office applications.
I don't know about you but I think there's quite a few people who think that having 1 million rows isn't exactly the best idea MS had.
You could easily create a simple text file with this information and use that for whatever you want to do.
In fact you could probably just copy it to a worksheet, tweak things a bit and save as a CSV.
You could then use VBA's file I/O functions which are common to most Office applications.
Upvote
0
Excel Facts
How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Similar threads
- Question
- Solved
