| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
set number of rows equal in mutiple columns
I am having trouble setting the number of rows equal across my spreadsheet. For example i have about 2000 records in column b and there should be that many rows in column d...however there are zero's goin all the way down my sheet (to file 65536). What i want to do is write something in vb so set number of rows in column b and make that many rows in all the other columns. It has to be variable because across my 3 spreadsheet pages the number of files varies depeding on the amount of information that i import. I have been working on this for a few days and it seems to me it should be a simple solution but I can't find it...thanks for any help you could give -- speary ------------------------------------------------------------------------ speary's Profile: http://www.excelforum.com/member.php...o&userid=24959 View this thread: http://www.excelforum.com/showthread...hreadid=385040 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete extra columns and rows | Excel Discussion (Misc queries) | |||
| Is it possible to have rows labled A->Z and columns 0->n ? | Excel Discussion (Misc queries) | |||
| Increasing number of columns in spreadsheet | Excel Discussion (Misc queries) | |||
| hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
| Printing problems with columns and rows | Excel Discussion (Misc queries) | |||
Threaded Mode
