looking for out of the box solution

[Pilot5000]

I have range in excel which I name it “Mike” (A2:A6) , in that range I several lines as follow:
Sheets("B").Range("a2").Select

Range("H15").Value = Sheets("D").Range("B2").Value 
Range("H16").Value = "3Yr" 
Range("H17").Value = Sheets("D").Range("C5").Value 
Range("H18").Value = "3 Year Average Efficiency" 
Range("H20").Value = "3Yr"  

I would like to know if this range & those lines can be executed via VBA, by the name rage mentioned. Moreover, those lines are basically part of macro which I hope I can place then in a sheet and not in a module, I know that in lotus you can write your macro in a range on a sheet name that range , and then activate that macro by calling the name of you have it to be executed , by click button , is that option existed also in VBA and excel (p.s.- I place here the original code in VBA)

Please Login or Register  to view this content.

Giving the fact I am newer to VBA my question does not sound too stupid, and any help will be appreciated

[davesexcel]

Please Login or Register  to view this content.

Code needs to go in the VBA Editor, it is not like Lotus where the macro code was on the spreadsheet.

[TankBuilder88]

One note. If you want the values to be linked and update when you update them on sheet D then you can modify Dave's code as follows

Please Login or Register  to view this content.

The D! could be replaced by any sheet name.