Gary's Student

Gary's Student has asked 19 questions and find answers to 165 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

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
Syntax to Define an Entire Row as Range
Which Window Is Active
Data Validation to Include Comma Character
Opening a File whose Name Contains a Space
Using Range.Replace on Formula Cells

Gary's Student answers

Why does For Each over Range.Columns(1) not iterate over cells?
str(1) returning with a space in front excel vba
EXCEL VBA - Loop through cells in a column, if not empty, print cell value into another column
Excel - Find and replace multiple parts of formula simultaneously
Formula in Excel - Logarithmic Average
Excel 2016 Macro Unable to Find File : Runtime Error 1004
Excel & VBA: 'If value is less than 1' condition being triggered by a value that is exactly 1
Fast way to loop through filtered list in reverse?
Why does INDIRECT() not work with name references?
VBA code for moving cells from one column to another based on specific cell criteria