Culinary, Arts, Thread.

@Behr I had our corporate Excel help look at it. It requires putting DBa code in and saving it as a macro. I tried to get through it and couldn't. I will post later if you feel like trying and on top of that, I don't think it does what you are asking.
That's what I read. Said it was a pain in the butt to do and probably wouldn't get the result I hoped for.

I've moved on, but thanks!!
 
  • Like
Reactions: 82_VOL_83
This looks like the correct thread for this...

Anybody remember these blankets? It's been stowed away in our RV for several years. I had forgotten that my mom gave it to me years ago when they were cleaning out their old house before moving. It's from a land and time before Titans, Jaguars, Panthers and Texans, lol. Was my favorite blanket as a kid.

blanket.jpg
 
This looks like the correct thread for this...

Anybody remember these blankets? It's been stowed away in our RV for several years. I had forgotten that my mom gave it to me years ago when they were cleaning out their old house before moving. It's from a land and time before Titans, Jaguars, Panthers and Texans, lol. Was my favorite blanket as a kid.

View attachment 409085
1636130442178.png
 
This looks like the correct thread for this...

Anybody remember these blankets? It's been stowed away in our RV for several years. I had forgotten that my mom gave it to me years ago when they were cleaning out their old house before moving. It's from a land and time before Titans, Jaguars, Panthers and Texans, lol. Was my favorite blanket as a kid.

View attachment 409085
Yep, I had one. Lol..
 
I do have another question though. On your sheet above...

A1 is my total time walking 30 laps.
A2 is total laps = 33

Now I have
A1 = seconds 1802
A2 = laps 33
A3 = A1/A2 seconds per lap

Is there an easier way to get ...
A1 = 30:02 [time]
A2 = 33 [laps]
A3 = 54.60 [seconds per lap]
If cereal I can write the formulas, if not I might wrote them anyway to get you mor mayuder
 
  • Like
Reactions: Behr
If cereal I can write the formulas, if not I might wrote them anyway to get you mor mayuder
I assumed it was a cell formatting issue that I can't find, or it doesn't exist. I've tried every way I could think of but would love to be wrong.
 
  • Like
Reactions: Behr
@Behr....This might be what you are looking for... if not, STFU.

How to highlight active cell or selection in Excel?
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
 
Advertisement

Back
Top