RowHeight & name manager.

[starlev]

I have the following two questions:
1.i was using the following statement Rows("start:lr").RowHeight
Were start is a row defined by the user and lr is the last row.
However Excel is not resizing this range row height why?

2. I have the following vba statement with is url = Range(URL_UK & i)
URL_UK is a Column which I modified under name manager.
However in VBA it says that URL_UK = 0.
And I’m not sure why?

Thank you for your helo

[Norie]

1 If you used "start:lr" then VBA would be looking for a named range called 'start:lr'.

2 VBA sees URL_UK as an undeclared variable, if you want to refer to a range with the name 'URL_UK' you would need to use Range("URL-UK").

[starlev]

Thank you for your help.
1. In my case what will be the right syntax to change the row height of ("start:lr")
2.I tried Range(“URL_UK” & i) as you suggested however was no luck.
any other ideas?

[Norie]

1 Perhaps.

Please Login or Register  to view this content.

2 That's not what I suggested, all I suggested was if you want to refer to the range 'URL_UK' you would need to use Range("URL_UK").

What are you actually trying to do?

[starlev]

Hi,

1. Works great thank you
2. In order to make my code more flexible I defined column AC as URL_UK. However in when I use the following syntax url = Range(URL_UK & i) instead of url = Range( “AC” & i).

However this is not working how can I make this work?.

[Norie]

How exactly have you defined 'URL_UK'?

Have you defined it to refer to the range AC:AC (or $AC:$AC) or to refer to the string 'AC'?

[starlev]

I defined it as $AC:$AC

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[TMS]

Please Login or Register  to view this content.

[starlev]

Thank you i will give it a try