Hi
I am having trouble with my sumifs in vba. It is returning error 1004. I think that it is due to one the word that it is referencing as it has the symbol $ after the word Overtime. I have tried the following:
1. putting in " - however that didn't work as it then reads the characters and not the value
2. putting in address instead value, there was change
Here is the code :
It is important to keep the word Overtime $ as that is the heading where I pull my data out from.
Any assistance would be appreciated.
Thanks
Celica
I am having trouble with my sumifs in vba. It is returning error 1004. I think that it is due to one the word that it is referencing as it has the symbol $ after the word Overtime. I have tried the following:
1. putting in " - however that didn't work as it then reads the characters and not the value
2. putting in address instead value, there was change
Here is the code :
Code:
gc2 = Ns.Cells(3, ((t * 3) + t - 1)).Address
Ns.Cells(4 + g - 1, (t * 3 - (t - 1))).Formula = "=sumifs(" & S2s & vc1 & ":" & vc2 & "," & S2s & gc3 & ":" & gc4 & "," & S3s & gc2 & "," & S2s & Ac2 & ":" & Ac3 & "," & Ac1 & ")"It is important to keep the word Overtime $ as that is the heading where I pull my data out from.
Any assistance would be appreciated.
Thanks
Celica
