Excel 2007 : Function formula for copy a cell from a to b

**thbusk** · 09-05-2010, 05:47 PM

Hi

I'am trying to copy information in a cell(eks:bA4) to another cell(eks: G7). Anyone who can help me?

Thbusk

**teylyn** · 09-05-2010, 05:55 PM

Hello,

with Excel formulas in cell G7

=A4

with VBA:

Please Login or Register  to view this content.

If that does not answer your question, please provide a bigger picture.

cheers

**thbusk** · 09-05-2010, 06:05 PM

Thank you

But what is a VBA code, that's new for me?

Thbusk

**MarvinP** · 09-05-2010, 06:55 PM

Hi thbusk,

I was a little confused with your question when you asked:

copy information in a cell(eks:bA4) to another cell(eks: G7).

When you use a colon in the above it means a bunch of cells or something else.

I think what you wanted to know is how to copy, using a formula how to get what is in BA4 stuck in G7.

You would do this by clicking on G7, type an equal sign (=) followed by clicking on BA4.
The formula in G7 would then look like this: =BA4

Press enter and G7 will then contain whatever is in BA4.

Was that the question? If not please, excuse my ignorance.