FrumpyJones
New Member
- Joined
- Feb 11, 2008
- Messages
- 28
Hi Everyone,
Thanks for all the help you've given in the past, and hopefully in advance for helping me with this new one!
I have a spreadsheet that goes from columns A-G and down to row infinity. I have a tab called TO BE DISCUSSED and a tab called COMPLETED, and a tab called HOLD
I have some pretty simple (But many) CF setup in the TO BE DISUUSED tab. And it's been working like a charm...
UNTIL I stated moving rows (CUT/PASTE rows to be exact; in case there is a difference to someone) to the other tabs and now it's all gone crazy. When I first created the range I made it A1:G15000 (For the love of Pete if this weekly meeting ever gets to that many rows I'ma gonna defenestrate myself). When I clicked apply to the range it auto throws the $ in front the ranges and I'm fine with that (I guess), but I notice that as I move rows out to the other tabs, my range gets all crazy with sub ranges. like $A$1;$G$19;$A$23;$G$56; etc.etc...
So, finally, the ask:
How do I stop this? Is there a way for me to move the rows without monkeying up the range of the CF? Or am I destined to just keep the range a1:g15000 in notepad++ and do some pasting every few weeks to all my CF's?
Thanks for all the help you've given in the past, and hopefully in advance for helping me with this new one!
I have a spreadsheet that goes from columns A-G and down to row infinity. I have a tab called TO BE DISCUSSED and a tab called COMPLETED, and a tab called HOLD
I have some pretty simple (But many) CF setup in the TO BE DISUUSED tab. And it's been working like a charm...
UNTIL I stated moving rows (CUT/PASTE rows to be exact; in case there is a difference to someone) to the other tabs and now it's all gone crazy. When I first created the range I made it A1:G15000 (For the love of Pete if this weekly meeting ever gets to that many rows I'ma gonna defenestrate myself). When I clicked apply to the range it auto throws the $ in front the ranges and I'm fine with that (I guess), but I notice that as I move rows out to the other tabs, my range gets all crazy with sub ranges. like $A$1;$G$19;$A$23;$G$56; etc.etc...
So, finally, the ask:
How do I stop this? Is there a way for me to move the rows without monkeying up the range of the CF? Or am I destined to just keep the range a1:g15000 in notepad++ and do some pasting every few weeks to all my CF's?
Last edited: