Cell Reference

[IanT]

Hi

I have a range of cells which need there cell ref to increase by one ie K22 to K23 etc. Exmp below. Is there code which might complete this task!

=Data!K22 to =Data!K22
=Data!L59 to =Data!K60
=Data!AA89 to =Data!AA89
Etc

 

[unmarkedhelicopter]

Hi

I have a range of cells which need there cell ref to increase by one ie K22 to K23 etc. Exmp below. Is there code which might complete this task!

=Data!K22 to =Data!K22
=Data!L59 to =Data!K60
=Data!AA89 to =Data!AA89
Etc

Sorry, why does the middle one increase and the other two stay the same ?