I get a Runtime 1004 error, Method Range of object _Worksheet failed.
The problem is that I loop through a an array of cells and retrieve their values and convert it to a Range
Problem is that when the value is not a valid for Range i.e the cell contains "hello" as opposed to "B12" or "B12:C14" I get the runtime error.Please Login or Register to view this content.
I tried
I triedPlease Login or Register to view this content.
both did not stop the error from appearing, is there anyway to test the value first to determine if the string is a valid argument for the Range() method?Please Login or Register to view this content.
Bookmarks