Re: Create button to run formula on every sheet in workbook
Ok.. that works and is pretty slick. Thanks
I ran some tests on it. I added more tickets on one of the worksheets. and reran the button and it did indeed select random tickets that were added.
Now, for the next question, to make sure I understand it.
If the column I was interested changed, I would need to change this line,
x = .Cells(1).CurrentRegion.Columns(5)
changing the (5) to what ever number column that I need? Meaning that if the format changes and columns are added or removed, (5) becomes whatever column I am interested in counted from Column A =1, B=2, C=3, etc?
So if I now was interested in column G, it would be
x = .Cells(1).CurrentRegion.Columns(7)