Hi, I was wondering if i could take a simple bit of code and assign it
to a varriable

example:

DIM SHEETCODE

*sheetcode* = Sheets("sheet1").range
sheetcode("a1") = sheetcode("b1") + sheetcode("b2")

to simplify this...
Sheets("sheet1").range("a1") = sheets("sheet1").range("b1")+ _
Sheets("sheet1").range("b2")

Or something similar, this is just to give an idea of what I am talking
about. Or maybe I can achieve the same results by defining a function?
I have to do this to several cells which is why I ask, So I still need
to define the range. Im a newb... So any help would be cool

Thanks
Chris


--
justchris
------------------------------------------------------------------------
justchris's Profile: http://www.excelforum.com/member.php...fo&userid=8894
View this thread: http://www.excelforum.com/showthread...hreadid=345789