Rows

Frankie needs HELP · Apr 10th, 2002, 11:06 AM

I need to keep three lines between my table and the one below it.

The data that I have in the top table may change (so more rows maybe taken up). How do I keep the two tables three rows apart?

Mark W. · Apr 10th, 2002, 11:09 AM

Are you referring to PivotTables? If so, why don't you keep them on separate worksheets?

Frankie needs HELP · Apr 10th, 2002, 11:20 AM

No, I can only have one worksheet. In the top table I am extracting data and putting it into the one below (this is all done via a macro). But I must take into account that there may be changes the next time I run the macro, so I can't just assign it to a cell three rows below the top table.

Got any ideas???

Al Chara · Apr 10th, 2002, 12:37 PM

Try the following:

Dim StartPoint As Range
Set StartPoint = Range("a1").End(xlDown).Offset(4, 0)
StartPoint.Select

A1 is the start point for table 1.

Frankie needs HELP · Apr 10th, 2002, 01:01 PM

That's Brilliant Al, you're a life saver, Thank you

Apr 10th, 2002, 12:37 PM	#4
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Try the following: Dim StartPoint As Range Set StartPoint = Range("a1").End(xlDown).Offset(4, 0) StartPoint.Select A1 is the start point for table 1. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 10th, 2002, 11:06 AM	#1
Frankie needs HELP New Member Join Date: Apr 2002 Posts: 43	I need to keep three lines between my table and the one below it. The data that I have in the top table may change (so more rows maybe taken up). How do I keep the two tables three rows apart?

Apr 10th, 2002, 11:09 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Are you referring to PivotTables? If so, why don't you keep them on separate worksheets?

Apr 10th, 2002, 11:20 AM	#3
Frankie needs HELP New Member Join Date: Apr 2002 Posts: 43	No, I can only have one worksheet. In the top table I am extracting data and putting it into the one below (this is all done via a macro). But I must take into account that there may be changes the next time I run the macro, so I can't just assign it to a cell three rows below the top table. Got any ideas???

Apr 10th, 2002, 01:01 PM	#5
Frankie needs HELP New Member Join Date: Apr 2002 Posts: 43	That's Brilliant Al, you're a life saver, Thank you