Change it to a variable
Sheets("perioder").Cells(start,8).value
OR
strCol = "H"
Range("perioder!" & strCol & start).Value
OR
strCol = "H"
Sheets("perioder").cells(start,strCol).Value
--
If this post helps click Yes
---------------
Jacob Skaria
"alvin Kuiper" wrote:
HI
i have this code:
Range("perioder!$H$" & start).Value
where start is a variable
now i also want to change $h$ to a variable
but i Can't make it right
Help
Alvin
|