Determine a Range despite number of rows

**FCarv** · 08-23-2012, 10:48 AM

Hello guys,

This might have an easy solution but i'm seriously knocking my head on the keyboard for quite a while trying and still couldn't reach a code solution.

Objective:

Determine a Range despite the number of rows that a worksheet has.
For example in the file I have attached I need to select A8:I8 and then untill the last cell with some value, i.e., A8:I79.

The problem:
I can have 79 rows, 1250 or even 10000.
However the columns are fixed.

I was trying with something like this but so far didn't work out:

Please Login or Register  to view this content.

Can you help me out with this?

Kind Regards,
FCarv

**JosephP** · 08-23-2012, 10:51 AM

if you just want to clear the data

Please Login or Register  to view this content.

**FCarv** · 08-23-2012, 11:04 AM

Yes, exactly.
But only untill column I because then I have a column "J" that I didn't ilustrate in the example and that one I should not clear because it has a formula that I should keep.

Nevertheless let me try the code

EDIT: Yes, that way it clears the formula I have in column J, which it's exactly what i'm trying to avoid

**JosephP** · 08-23-2012, 11:06 AM

small change then

Please Login or Register  to view this content.

**FCarv** · 08-23-2012, 11:10 AM

I really envy you so much right now

It worked perfectly.
Thank you so much.

Rgs,
FCarv

Determine a Range despite number of rows

LinkBack

Thread Tools

Rate This Thread

Display

Determine a Range despite number of rows

Re: Determine a Range despite number of rows

Re: Determine a Range despite number of rows

Re: Determine a Range despite number of rows

Re: Determine a Range despite number of rows

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions