Skip to main content

All Questions

Tagged with
Filter by
Sorted by
Tagged with
0 votes
1 answer
426 views

When I use range.offset in VBA, I get error code 1004 application defined object or object defined error due to synatx error

I am trying to use the offset function and cannot figure out the problem with my synatx. I copied this code from another question about offset on this website. I want to look for a string in column X (...
Rae Van Sandt's user avatar
0 votes
1 answer
6k views

Excel VBA: Using .Range.Offset property on a range variable returns unexpected values

I have given Stack Exchange and Google a good search and I can't find the exact answer I'm looking for. I'm having trouble understanding the values returned from using RangeVariable.Range.Offset, NOT ...
Stephen's user avatar