naming ranges???

[navyaa]

i am writing a macro where i select a range using a value in another cell: i start at a region and then row and columns below it based on a count are selected.

I need to name the range that is selected.....and here is my code for selecting:
Range("RPTSET").Select
ActiveCell.Offset(rowOffset:=[Range("SETCNT").Value], columnOffset:=9).Activate


ANY SUGGESTIONS??
NAVYA

 

[rikrak]

On 2002-09-13 11:38, navyaa wrote:
i am writing a macro where i select a range using a value in another cell: i start at a region and then row and columns below it based on a count are selected.

I need to name the range that is selected.....and here is my code for selecting:
Range("RPTSET").Select
ActiveCell.Offset(rowOffset:=[Range("SETCNT").Value], columnOffset:=9).Activate


ANY SUGGESTIONS??
NAVYA

Hi,
is this what you need?

Sub test()
'select
Range("RPTSET").Select
ActiveCell.Offset(rowOffset:=Range("SETCNT").Value, columnOffset:=9).Activate
'name the selected cell
ActiveWorkbook.Names.Add Name:="namedregion", RefersToR1C1:=ActiveCell
End Sub

 

[navyaa]

Thank you for your reply...

I am just going to try what you suggested...the only difference is its not just a single cell that is selected by the offset statement...its a range so will what u suggested work the same way for that??

This is the correct code for what im doing:
Range("NUM").Select
Range(ActiveCell, ActiveCell.Offset([SETCNT].Value, 9)).Select
ActiveWorkbook.Names.Add Name:="namedregion", RefersToR1C1:=ActiveCell

WILL THIS WORK??

 

[navyaa]

hi again,

Thank you very much...i just tried it and it works, i just replaced the activecell by selection.

Navya