Culinary, Arts, Thread.

#42,626
#42,626
Behr said:
That actually sounds like exactly what I'm looking for. But I'm skurt. Lol.

It says to copy and paste that code. Do I copy and paste everything? Like this....

Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range)
'Update 20140923
Static xLastRng As Range
On Error Resume Next
Target.Interior.ColorIndex = 6
xLastRng.Interior.ColorIndex = xlColorIndexNone
Set xLastRng = Target
End Sub
Click to expand...
I would say so. As long as you don't have a ' before the line, it should treat is as a line of code.
 
  • Like
Reactions: Behr
#42,627
#42,627
82_VOL_83 said:
I would say so. As long as you don't have a ' before the line, it should treat is as a line of code.
Click to expand...
Crap like this scares me, afraid I'm gone screw it up. And it ain't excel where I can just close it and "not save" if worse comes to worse. Lol.
 
  • Like
Reactions: 82_VOL_83
#42,630
#42,630
Behr said:
Crap like this scares me, afraid I'm gone screw it up. And it ain't excel where I can just close it and "not save" if worse comes to worse. Lol.
Click to expand...

Make a copy of the spreadsheet... and play with that, no way to f up the original spreadsheet.
 
  • Like
Reactions: VolNExile
#42,635
#42,635
82_VOL_83 said:
I'm not an excel genius, I just work with spreadsheets all day. I use very few functions past algebra.
Click to expand...
That works and I appreciate the time. I probably would eventually thought of that but I was looking for a solution with less steps, and less rows. I don't have room for the 2 extra rows without "shrinking" some. But, you did save me some time and I'll use this for now
Thanks.
 
#42,639
#42,639
  • Like
Reactions: VolNExile and BigOrangeMojo
#42,642
#42,642
NorCalVol67 said:
I like the sausage and cheese plate too. When the ribs are on, they are on. One purveyor is way better than another.
Click to expand...

Agree about the ribs. Ive noticed at several places over the past 18 months or so (damn COVID) is that the racks aren't as meaty. More likely to get a slightly overcooked batch with the less meaty ones.
 
  • Like
Reactions: 508mikey and VolNExile
#42,643
#42,643
BigOrangeMojo said:
Agree about the ribs. Ive noticed at several places over the past 18 months or so (damn COVID) is that the racks aren't as meaty. More likely to get a slightly overcooked batch with the less meaty ones.
Click to expand...

I can't remember the last time I went to the Rendezvous. Probably about 15 or so years ago.
 
  • Like
Reactions: VolNExile
#42,644
#42,644
  • Like
Reactions: BigOrangeMojo, VolNExile and 82_VOL_83
#42,645
#42,645
NEVolFan said:
Make a copy of the spreadsheet... and play with that, no way to f up the original spreadsheet.
Click to expand...
Yep yep yep yep yep

I made the first tab of every workbook for the list of data sources, and what I was doing and how and why.

Second tab was the master copy tab and labeled as such with red background on the tab.

Everything after that was the stuff I was playing around with, including graphs, pivot tables, pivot charts, and the rest. As long as I kept that master tab unaltered, I was safe.
 
  • Like
Reactions: NEVolFan
#42,648
#42,648
  • Like
Reactions: BigOrangeMojo
New posts
You must log in or register to reply here.
Advertisement

Back
Top