application or object defined error

[prajesh]

hi excelforum,
i am constantly facing the error 1004 (Application or object defined error).... I am not being able to solve it.. Please help..

Please Login or Register  to view this content.

the error is shown on the line below:
****If Worksheets(2).Cells(5, 2) = Worksheets(1).Cells(7, a) Then****
the 5th line of the code..

[pike]

should work try adding

Please Login or Register  to view this content.

[prajesh]

hi pike,
that doesnt work either..........same error!

[pike]

Check that you have "Sheet1" and "Sheet2"

[prajesh]

yes, i do have them....
1st sheet is "Tool Sheet" while 2nd sheet is "Data sheet"

[pike]

Hmmm. Try adding "option explicit" and run the debug
it will force you to delcare all variables and helps find errors
also at .value

Please Login or Register  to view this content.

[pike]

only other thing is if it loops and the a value exceeds the columns avaliable?
use

Please Login or Register  to view this content.

this will print all the a values to the immediate window for checking

[prajesh]

pike,
dim filepath as ...............???

[pike]

Hi prajesh

as string

[prajesh]

pike,
you are my saviour, mate...
thank u so much.......
and regarding yesterday's conversation about gilly, do u think ricky had anything to do with gilly's retirement?

[pike]

No, he is a smart man and knew that it was time to go and play 20/20 in India where the big bicks are while he still could.

[prajesh]

hmmm..
and pike, what difference does defining variables make?
and why is it that the code works without dim statements in some case and doesnt work in rest?

[pike]

You can use the VBA help to find an explination on option explict its a very good reference
why because not declaring dimentions causes an error to occur at compile time.
a=5 " error

Dim a as long
a=5 'no error