Resize range after import

**gnoke** · 07-29-2010, 07:00 AM

Hi,

I am importing several new rows from text files to a excel sheet. This runs ok and places the rows under the last row in the sheet with values.

The problem:
I am using a list for the existing rows, but the imported rows stays outside the list.
Is there a macro that will resize the list automaticly so the new rows are included?

Hope someone will share their knowledge with me

Gnoke

**pike** · 07-30-2010, 02:26 AM

hi gnoke
maybe

Please Login or Register  to view this content.

**gnoke** · 07-30-2010, 05:58 AM

Hi and thanks for your replay

This formula merely resizes the columns to show the entire text in each cell.
Maybe I was unclear, I need a resize of the list to include newly added rows..

Gnoke

**pike** · 07-30-2010, 06:16 AM

the syntax is .List( row, column )
do you have an example workbook?

**gnoke** · 07-30-2010, 06:34 AM

Thanks for your time,

I have attatched a sample file. As you can see the buttom three rows are imported, but outside the list.
Of course I can just drag the list downwards, but since imports are done often, It would be much easier to have a macro do it for me

**pike** · 07-30-2010, 07:15 AM

Hi gnoke

maybe something like

Please Login or Register  to view this content.

**gnoke** · 07-30-2010, 07:34 AM

Superb!

Thanks a lot mate.)

**pike** · 07-30-2010, 07:49 AM

no worries

Thanks for taking the time to mark the post Solved

.

Resize range after import

LinkBack

Thread Tools

Rate This Thread

Display

Resize range after import

Re: Resize range after import

Re: Resize range after import

Re: Resize range after import

Re: Resize range after import

Re: Resize range after import

Re: Resize range after import

Re: Resize range after import

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions