I don't know what has happened here. The value I am getting from the target row col is off by one row even though the row count is correct.
When I step through this the Row value is 2, the column value is 1 the data in that cell should be 123 but it is the value from the next row.
Please Login or Register to view this content.
Scott
The harder it gets the happier I am.
Finally got my signature set up!
Hi
The way you have your code written, it is using target as the starting point, then using CELLS to work out where to go. As the row number for TARGET, the effect is to go 2 rows from target, then across the required number of columns. If TARGET was in row 3, then you would be 3 rows off.
Try something likeryloPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks