Copy data from another column (Only for Visible cells)

[Aswinraj]

Hello Guys,

I Need to Map the data from one column to another column. Example: Consider there are two columns A and B where i need to Map the data present in B to A.
I took the ColumnName (Column B) as ColLtr_Customer and Current row in Column A as currrow and entered the formula as show below but i am getting the result as =@'B576' and correct result should be =B576

Note: I will copy the formula till last available column only for visible cells ( this formula applied only to visible cells)

ActiveCell.FormulaR1C1 = "=" & ColLtr_Customer & currrow

 

[MARK858]

I assume that you are using 365...
The @ symbol shouldn't stop your formula running is it giving an incorrect result?

For information on the @ symbol (Implicit Intersection Operator) see the link below.

Implicit intersection operator: @ - Microsoft Support

Learn about the implicit intersection operator (@), which returns a single value using logic known as implicit intersection. The implicit intersection operator (@) may return a value, single cell range, or an error. The implicit intersection operator (@) is in a class of functions called dynamic...

support.microsoft.com

 

[Aswinraj]

@MARK858 : Yes i am using office 365. And i got the correct result by changing FormulaR1C1 to Value.

Thanks for your time.

 

[MARK858]

That was stupid of me not spotting that you were using .FormulaR1C1 for a formula in A1 style
Happy that you have it sorted (btw you can use .Formula rather than .Value as well).