call variable into cell value

[penfold1992]

I know this is a silly question but I dont know how to call a variable into a cell...

I have a variable set as Monthrow = Range("G16").Row + 14
Another is Countrec = 242
then I want to use
Range("C" & Monthrow).Value = Countrec

but there appears to be no change in C16 (Monthrow is currently 16)

how do I enter a variable into a cell as a value?

[Trebor76]

Hi there,

The syntax is correct - put the Monthrow in a message box to validate its value i.e.

Please Login or Register  to view this content.

Robert

[jraj1106]

Hi.

Sorry but Monthrow <> 16. You get Monthrow =30 from

Please Login or Register  to view this content.

line.

[OllieB]

penfold,

I am not entirely sure about your question.

Please Login or Register  to view this content.

the above code takes the row number of G16 (which is not surprisingly always 16) and then add the value 14. SO MonthRow will always have the value 30 after this line. What I think you want to do is take the VALUE shown in G16 and add 14.

Please Login or Register  to view this content.

If you now want to assign the value of Countrec to a cell in column C on the row number that equals the value of MonthRow the code would be

Please Login or Register  to view this content.

[penfold1992]

I found it better to do Debug.Print Monthrow but that gave me the correct answer

The problem was something more basic that I just didnt realise until i clicked on the cell...

it was a merged cell so it didnt like it. I must have accidently merged it at some previous stage and forgot about it.
silly mistake really but i guess thats a reason for vba to not change that specific cell!

EDIT for ollieB, i made a mistake typing in the code into the forums, it was .Value :P I was trying to cut out some information from the macro so i hand wrote that bit!