kieran989
05-07-2017, 02:30 AM
Hi there,
I have a dynamic range in my workbook (going across the page), setup in name manager using =OFFSET($A$1,0,0,1,COUNT($A1:$ZZ1))
I need to be able to add a value to the next blank cell using VBA? This needs to be able to work even when there is only 1 entry in the dynamic range (ie xlright wont work)
I have tried the following but still cant get it to work:
With Range("namedrange")
.Cells(1, .Cells.Count).Offset(0, 1).Value = somevalue
End With
I have a dynamic range in my workbook (going across the page), setup in name manager using =OFFSET($A$1,0,0,1,COUNT($A1:$ZZ1))
I need to be able to add a value to the next blank cell using VBA? This needs to be able to work even when there is only 1 entry in the dynamic range (ie xlright wont work)
I have tried the following but still cant get it to work:
With Range("namedrange")
.Cells(1, .Cells.Count).Offset(0, 1).Value = somevalue
End With