Menu

if emthy

Search this Thread

Prev

Previous Post

Next Post

Next

#1

Report Post

Posted to microsoft.public.excel.programming

Alvin Hansen[_2_] Alvin Hansen[_2_] is offline

Alvin Hansen[_2_] is offline

external usenet poster

Posts: 209

Default

if emthy

Hi!!

I have this in a userform
Set myrange2 =
Sheets(Range("kurt!$i$1").Value).Range(Range("kurt !$i$1").Value)

Can i do something if the range is emthy

regards alvin

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

All times are GMT +1. The time now is 07:33 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement