Hi guys,
hoping you can help me with this issue.
I have some data in a range "a1" to AZ50". one row may have data to column D where another may have data to column AW
I am looking for a way to return the value in the right most cell for EACH row and return it to that rows column "BD". (BD should not count as the right most cell)
This data can change so i need to make sure that what ever i do can be updated. Can anyone help ? I'm not the best with VBA but have this feeling that it is going to be the only way tor esolve the issue.
Thanks
Colin
hoping you can help me with this issue.
I have some data in a range "a1" to AZ50". one row may have data to column D where another may have data to column AW
I am looking for a way to return the value in the right most cell for EACH row and return it to that rows column "BD". (BD should not count as the right most cell)
This data can change so i need to make sure that what ever i do can be updated. Can anyone help ? I'm not the best with VBA but have this feeling that it is going to be the only way tor esolve the issue.
Thanks
Colin