If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Please help need urgent help

Hello and let me say I am sorry if there are variations of my question posted but I could not find any and I am green.
I need help please
I would like to get a code to do the following pls.
pick the value in cell a1
copy range b2:s90 in that same worksheet
copy as picture
paste as picture in a different yet an existing workbook
create new worksheet
name new the work sheet as the value from a1 from the 1st worksheet

please advise here is what I have so far

Sub Snapshot()
'
'

If Worksheets("Report").Cells(2, 2).Value <> "CarDEALER" Then
Worksheets("Report").Cells(2, 2).Value = "CarDEALER"
End If