I have a problem that I am trying to understand. I have a worksheet with about 3600 numbers that I want to do mathematical equations to. I have setup my worksheet to complete all of the math if I can get the numbers into one specific cell. I have worked up a loop macro to get this done quicker but I am stuck on one problem. This is what my macro looks like now:
do
activecell.offset(1,0).select
activecell.copy
range("b22").select
activesheet.paste
????
loop
The problem I have is how to get the active cell for coping back to the list of numbers. I thought about using some sort of (X,X) but am only getting stuck. If I use offset I can only get the numbers duplicated to the other row. Any help is appreciated. Thanks
do
activecell.offset(1,0).select
activecell.copy
range("b22").select
activesheet.paste
????
loop
The problem I have is how to get the active cell for coping back to the list of numbers. I thought about using some sort of (X,X) but am only getting stuck. If I use offset I can only get the numbers duplicated to the other row. Any help is appreciated. Thanks