hi,
\r\n
\r\ni searched for a string which is find in a cell which is merged.
\r\nnow i want the a value in a relativ position from there 4 rows down and in the range of the merged cell. but i can only find the first column not the 7th for example.
\r\nhere a little example :
\r\n| -' + '-' + '-' + '-' + '-' + '-' + '-' + '-' + '-' + '- string -' + '-' + '-' + '-' + '-' + '-' + '-' + '-' + '-' + '-' + '-' + '- |
\r\n| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
\r\n
\r\nthat\'s my code :
\r\n
\r\n fleetpos.Offset(4, 6).Select
\r\n Do While Not fleetpos.Value = Empty
\r\n If fleetpos.Value = actualplanetname Then
\r\n ActiveCell.Offset(0, 17).Value = ActiveCell.Offset(0, 17).Value + fleetpos.Offset(0, 1).Value
\r\n End If
\r\n fleetpos.Offset(1, 0).Select
\r\n Loop
\r\n
\r\nbefore and after "fleetpos.Offset(1, 0).Select" fleetpos has the same address. i think i have a general problem.
\r\nplease help a newbie in VBA.
\r\n
\r\nps: if someone knows a solve for the addition with more elegance post it too