Problems with setting cell value using VBA

[LSM1604]

Hey everyone,

I was wondering if someone could help me with something please?

I am writing some code to change mass numbers of cell values but it will not work. This issue is the use of "" (quotation marks)

Here is an example of what I would like:

Range("C68").Value = "=COUNTIF(C9:C44,"")"

I get an error each time I try to get the code to run because of the "" after C9:C44,

I require the "" in the cell values because it the workbook is looking for empty cells within that range.


Many thanks,
LSM1604

 

[julia55]

You have to add extra quation marks in the VBA code for forumlas.
Try this:

Range("C68").Value = "=COUNTIF(C9:C44,"""")"

 

[LSM1604]

Works a treat, thank you :D