Thank you Trevor,
now I understand why I get error with your code. When I let the code
store an range address, I get the areas separated with comma",".
Because the computer language define in the Excel GUI they should be
separated with semicomma ";"

I ran "," replaced by ";" in the cell with the address, and I got 241
as you did.

Hmm, now I dont know what to do. When I use the content in the cell
just to compare " IF Sheet2.Range("A1").Value<
Columns("V:V").SpecialCells(xlCellTypeFormulas, 1).Rows.Address
Then ..." it work OK. I guess This code wont work i I (by code)
replace the cell content from "," to ";"?

Any suggestions? Since this is a new question, I'll make a new tread
of it.

Kind re´gards,
Tskogstrom