Range of object global failed

[Nandakumar]

Hi Friends,

I am finding the below error in the macro (though i am not expert in macros).Can you please someone help in correcting it,which will be great help?

Error: "range of object global failed" and appearing in the below row:

For j = 1 To 7
Range("fraction").Cells(1, j).Value = 1
f = 1

Attached herewith complete excel sheet.

 

[Marc L]

Hi, as the named range does not exist …​

​

 

[Nandakumar]

Hi, as the named range does not exist …​

​

Hi,

Thanks for the reply.How to fix it?

 

[Marc L]

You have to check according to the logic to follow if you need to create this named range​

or to replace it with an already existing named range or just a classic no named range …​

​