VBA to cycle through cells

max8719

Board Regular
Hi I have 2 buttons one for cycle left and one for right. i would like to be able to cycle the selection forward and backward.

I15, AN15, BP15, CU15, DY15, FD15, GH15, HM15, IR15, JV15, LA15, ME15.

Thanks in advance.
 
Last edited:

James006

Well-known Member
Hi,

Surprisingly .. you have not posted your current macros ...which allow you to cycle left and right ...

You could create a Named Range ...
 

max8719

Board Regular
Hi apologies but I haven't created a macro yet, I just have two objects i would like to use as buttons
 

James006

Well-known Member
Hi,

Do not know your constraints ... but given your explanations ... you should be using a SpinButton ...

By the way is there a coherent Column count in between all your cells in Row 15 ...?
 

max8719

Board Regular
I just want the active cell selection go through the cells stated, each these are merged cells ie I15 to AM15 is a merged cell "January" and so on.
 

Some videos you may like

This Week's Hot Topics

Top