Hi,
I'm currently trying to select a Range by using variables for row and column number.
Here's the whole thing I'm trying to do:
1) select a unique ID in Worksheet A and store this in a variable called ISIN
2) jump to Worksheet B and find the row in col A that contains this unique ID (I do this by using Cells.Find...)
3) I store the row number in a variable called REIHE
4) I find and store the column number with the last value (see code below) in a variable called SPALTE
This is where i don't get any further. I'm using the following code to select a range, but it always produces a runtime error. Any Help would be highly appreciated! I'm using/have to use Excel 2003...
EDIT: Just to complete the picture: My ultimate goal is to create a Graph from this and another Range. Idea is to replace the bold code below by the code (or code similar to that) above....![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Bookmarks