How to add an integer to R1C1 formula?

[farkasmate]

Hi Guys,

I'm relatively new in VBA programming, that's why I need some help.

I'm using the following macro, but it doesn't work (I guess because of the reference to the "lastrow" variable).
I have two worksheets: the first one is "value", where I want to read data from to the other worksheet "May".

Please Login or Register  to view this content.

The problem is, that I do not know how to refer to the lastrow variable.
I tried various forms (R"&lastrow&"; R" & lastrow & ") etc., but it didn't work.

Any suggestions or advice?

A friend of mine suggested to use the Application.Worksheetfunction.If formula, but I don't know how and where to insert it.

Thanks a lot,

[Andy Pope]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

I assume the asterisks in the formula are not really multiplication signs.

Please Login or Register  to view this content.

Would then give you a formula like this
=+IF(D$1=Value!$M$4,SUMIFS(Value!$G$1:$G$2,Value!$A$1:$A$2,"2020",Value!$B$1:$B$2,"05",Value!$F$1:$F$2,"A",Value!$E$1:$E$2,May!$A2),"")

[farkasmate]

Hi Andy,

Thanks much - I didn't know why that was not working to me, I also tried to put " & lastrow & " into the formula, but got an error message.

Now it Works fine

Thank you