VBA to read both row & column numbers from cells

[cjcass]

Hi,
I have the code below that selects a range from cell BM76 using the row number from the value in cell BJ68 but the column is fixed as BU.
How can I adapt this code so it also reads the column number from cell BJ71 rather than it being fixed as BU?
Any help much appreciated.

Dim numrows As Long
numrows = Range("BJ68")


Range("BM76:BU" & numrows).Select
Selection.CopyPicture

 

[cjcass]

ok, have sussed this...

I have put a formula into cell BJ71 that returns the column letter of the last column used, this is then referenced in the vba as follows:

Range("BM76:" & Range("BJ71").Value & numrows).Select

Thank you to anyone that has spent any time looking at this for me.