Setting data from current cell to another sheet...

[Guest]

Howdy,

I am selecting a cell by doing a search to find the proper row I need and then moving over one cell using the offset command. Then what I need to do is take whatever data is in that cell and copy it to a cell on another sheet. I can access the other cell via Worksheets().Range().value = ..... But then what do I put after that to say take whatever is in the current cell since I won't know what cell is selected?

Hope that makes sense.

Thanks.

 

[mudraker]

Worksheets("sheet1").Range("a1").valu
=Worksheets("sheet2").Range("a1").value

where Worksheets("sheet2").Range("a1").value = your selected cel

 

[Mr B]

Well the problem is I don't know which cell is going to be selected because it's doing a search to
determine where to go. That's the part I don't know....

I know I can do it with a copy/paste type command but wasn't sure if there was another way.

 

[mudraker]

Mr B

If you select the cell after you have found it then

Worksheets("sheet1").Range("a1").value=activecell.value

It would help if you posted the code you are using to find your cel

 

[Mr B]

That should work fine. I just wasn't sure how to reference whatever the current cell was without
knowing it's specific row/column info.