Gary's Student

Gary's Student has asked 24 questions and find answers to 194 problems.

Stats

About

Retired Engineer, Retired Manager, Retired Baby Sitter

Grandfather
Bionicle Collector
Zinfandel Sipper
Marzipan Addict

a.k.a. James Ravenswood
a.k.a. Jakobshavn

Gary's Student questions

Documentation for Pictures and Picture Methods and Properties with VBA
Picking a Font For the VBA Editor
Testing for NULL
Locate the last used cell in a block of cells
Using VLOOKUP() in VBA [duplicate]
Close the Immediate Window - VBA
Assign Shortcut keys within the VBE Window
Avoiding Loops in Setting Cells in Various Worksheets
Application.OnKey Fails to Reset Properly
Evaluate an Array Formula

Gary's Student answers

Extract Consecutive Digits from a String using VBA
How does AND function work in VBA?
Pausing a VBA loop to allow editing of worksheet, with or without userform
I want to strip / clean() a cell of everything except CHAR(015), but ASCII Control Characters can't SUBSTITUTE() out
Select Random Cell In A Range Only If It Has A Value - Excel
How to retrieve the all six digit numbers from the exact cell?
Add '1' to all cells in a range
VBA Crashing On End Statement or Reset When Array Assigned to Range Within Sub
Replace cells containing "#VALUE!" with average value of surrounding cells
How can I remove duplicate rows and reversed-order duplicate rows in VBA-Excel