HI,
I have written a marco in excel but with following code i have a problem.
For Each h In Range(ws.Cells(1, 1), ws.Cells(1, .Column.Count + .Column - 1))
This is part of the marco, which will select for the particular 1st row to find something to do something. But I am getting this error on one pc and not on the other...????
Run time error: 424
Object required
Can someone tell me how to debug this error???
Any help is much appreciated
Raj
I have written a marco in excel but with following code i have a problem.
For Each h In Range(ws.Cells(1, 1), ws.Cells(1, .Column.Count + .Column - 1))
This is part of the marco, which will select for the particular 1st row to find something to do something. But I am getting this error on one pc and not on the other...????
Run time error: 424
Object required
Can someone tell me how to debug this error???
Any help is much appreciated
Raj