hey guys,
how can i set an entire worksheet into a range?
I tried this, but it's not working:
maybe i need to set setMSG2 as something else? Or maybe it's the way i'm trying to display on .HTMLBody? I'm not getting an erorr, its just not showing anything. Everything else in my code works fine, this is just a piece.
how can i set an entire worksheet into a range?
I tried this, but it's not working:
Code:
For i = 3 To Worksheets.Count
Set wksTemp = Worksheets(i)
With wksTemp
setMSG2 = wksTemp.UsedRange
.HTMLBody = strMSG & strMSG2
maybe i need to set setMSG2 as something else? Or maybe it's the way i'm trying to display on .HTMLBody? I'm not getting an erorr, its just not showing anything. Everything else in my code works fine, this is just a piece.