saving a dynamic range as a bmp file

[bobaol]

Hi, I found the following code to save as a bmp file. It works nicely for saving the range A10 to Q30 as a bmp file. However, my range changes. So, today, it may be Range C22 to J33 or Range T3 to X70, and so on.
This is the code from Mister Excel... http://www.mrexcel.com/forum/showthread.php?t=233108
Sub Macro_bmp_Print_()
SaveRangePic ActiveSheet.Range("A10:Q30"), "C:\MyRangePic.bmp"
End Sub

I have a macro to figure out the beginning range, and I place that value in cell B1. I would place the end range in cell C1. B1 would look like this: C22, and C1 would look like this: J33

I change the above code to look like this, but it did not work. SaveRangePic ActiveSheet.Range("b1".value & "c1".value), "C:\MyRangePic.bmp"

any help is appreciated. thanks in advance.

 

[Joe4]

Maybe try this instead:

   myRange = Range("B1").Text & ":" & Range("C1").Text
   SaveRangePic ActiveSheet.Range(myRange), "C:\MyRangePic.bmp"