Record formulae to cells using absolute addressing [eg: $a$1]

[BrianCob]

I want to apply formulae to a range of cells which mirrors certain data from another sheet using absolute referencing.
This is the format which I want to see:
=if(‘SheetName’!$’x’$’y’<>” ”,‘SheetName’!$’x’$’y’,” ”)

The code below does that successful when there is no condition applied, ie: ='First'!$D$7<>""

Replacing the active statement in the code with:
Range(Chr(64 + a) & b).Formula = "=if(‘First’!" & "$" & Chr(67 + a) & "$" & b <> "" & "," & "‘First’!" & "$" & Chr(67 + a) & "$" & b & "," & "" & ")"
places TRUE in each cell and no formula.

As far as I can see the statement above are correct, but the “,” does not seem to be recognised in both places. Replacing that set with chr(44) does not assist me.

Please Login or Register  to view this content.

[HaHoBe]

Hi, BrianCob,

maybe like this (mind the ' before and after First!)

Please Login or Register  to view this content.

Ciao,
Holger

[BrianCob]

That my friend, once I used the actual Sheet names in my project, worked perfectly.
Was the Sheets("Second"). or having the quotes before the inequality sign <>? I had tried using the bank of 4 quotes """".
Anyway, it gives me food for thought.

Many thanks.

[HaHoBe]

Hi, BrianCob,

I think when you copied in the sheet names with the single quotes you didn´t get the correct ones (I was asked for a file name instead of accepting the sheetname as these quotes from your code looked a bit curved).

Ciao,
Holger

[BrianCob]

I just found that, while it may not be good practice, I could omit the Sheets("Second"). but I did need the bank of 4 quotes and the quote before the inequality.