Space_Antelope
New Member
- Joined
- Jun 11, 2015
- Messages
- 3
Hello, new to this forum and VBA for the most part. I need some help. My code bugs out at a certain spot every time on my work computer, but when using the same files on a different computer, it runs without a hitch. I've done some googling on what might be causing this, and I've checked the references and they all match on both computers. Any thoughts? Code is below.
Any help is appreciated. Thanks!
lastR = ActiveSheet.Cells.Find("*", searchorder:=xlByRows, _
LookIn:=xlValues, searchdirection:=xlPrevious).Row
lastC = ActiveSheet.Cells.Find("*", searchorder:=xlByColumns, _
LookIn:=xlValues, searchdirection:=xlPrevious).Column
Any help is appreciated. Thanks!