ajay_gajree
Well-known Member
- Joined
- Jul 16, 2011
- Messages
- 518
Sub Macro4()Dim i As Integer i = ThisWorkbook.Names("_Period").Value i = i + 1 ThisWorkbook.Names("_Period").RefersToR1C1 = iEnd SubHi All I have set a named range in my book to a naked value and I want to increment this using VBA, I have tried the above which does not work, can anyone assist?Thanks in advance