Application or object defined error - 1004

[dgdgdg]

Hi all

I am having a problem with what would seem a simple peice of code the line I am having problems with is

Please Login or Register  to view this content.

I am fairly new to vba and have been trying a few methods and seem to having the same error, even after introducing more variables.

Basically this is supposed to check existing cells except for the town and county cells for town and county names in other cells and clear the contents if this is true.

I am guessing what evenr is the issue is a schoolboy error, there are some public variables used in this but they seem fine.

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

Whenever you find yourself writing a looping macro take a step back and think if there is a more efficient and simpler way - there often is. Loops can be time consuming when many cells are involved.

It's likely that the simplest way is to filter your data so that only the rows containing the cells you want to clear are visible and then clear those cells. Filtering is the fastest way I know to achieve this sort of stuff.

Upload your workbook so that we can see the request in context and manually add the result you want to see on a second sheet.

[AB33]

Please Login or Register  to view this content.

You have not defined tcol in your Dim? What is tcol?

[dgdgdg]

There are two variables tcol and ccol.

Variables tcol and ccol are from previous modules and declared publicly

each contains the column number tcol = town column and ccol = county column

I have had to do this because I am dealing with dynamic data where these columns could be different and are calculated dependant on the column where they reside.

I have checked to contents of these variables and they are storing the correct value

And I have just solved this issue, it was a schoolboy error and I had the variables declared as a string, I have changed them to long and it executes them fine.

Thank you all for your help, you pointed me in the right direction.