Setting a Range name

[Tempy]

Good Day, I have to name a range and it can vary, dependant on the
spreadsheet recieved and the amount od data but all the used area will
be the range name KTL.

At this point in time it is A1:CQ847

This could go to CQ5000

Could somebody help me with some code please.

Thanks in advance

Tempy

*** Sent via Developersdex http://www.developersdex.com ***

 

[Bob Phillips]

set myRange = Range("A1:C" & cells(rows.count,"C").end(xlup).row)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Tom Ogilvy]

You mean like Insert=>Name=>Define kind of name a range?

ActiveSheet.UsedRange = "KTL"

 

[Tempy]

Thanks Bob, but i need to test the range and then name it as KTL, as the
range is not fixed but varying.

I tried this but it name it from A1:C847, but the width or number of
columns can also vary.

Thanks

Tempy

*** Sent via Developersdex http://www.developersdex.com ***

 

[Tempy]

Hi Tom, I need to name the used range as KTL but it can vary.

Tempy

*** Sent via Developersdex http://www.developersdex.com ***

 

[Bob Phillips]

Range("A1:C" & cells(rows.count,"C").end(xlup).row).Name = "KTL"

 

[Tom Ogilvy]

What is that statement supposed to mean?

 

[Tempy]

Hi Bob,

Thank you that works great, i apologise for my ignorance but am a newbie
to this game, but getting there slowly with all of your help.

Thanks again to you all

Tempy

*** Sent via Developersdex http://www.developersdex.com ***