Macro was working but is not now

**jeskit** · 01-12-2011, 12:39 PM

Hi

I created this bit of code to clear a cell range and then put a formula in it. It was working yesterday but now it is not and i dont know why.

Please Login or Register  to view this content.

I have noticed that excel is putting quote marks in the code but i dont know why. It is putting them in this bit around the cell numbers

Please Login or Register  to view this content.

CAN anyone please help me?

Thank you
Jeskit

**royUK** · 01-12-2011, 12:40 PM

The quotes are necessary.

I think attaching the workbook would help

**jeskit** · 01-12-2011, 01:18 PM

Ok thanks

I have tried putting Activeworkbook.sheets but it didnt work

**JBeaucaire** · 01-12-2011, 01:28 PM

Make sure cells G15:H16 are formatted as General.

**jeskit** · 01-13-2011, 04:20 AM

hi

I have checked and they are formatted to general but still not working

**teylyn** · 01-13-2011, 04:32 AM

Hello, why don't you upload the workbook, as RoyUK suggested. We can play '20 Questions' but looking at the real thing will be a lot faster.

"Not working" is not a very precise error description. Do you get an error message? Unexpected results? No results? What?

**jeskit** · 01-13-2011, 04:39 AM

Hi

i cant upload the work book as it has information in it which i will get in trouble for letting anyone see.

When i run the macro it does everything, it clears the cell range, finds the values from cells and places it in the cell range, peforms the formula and produces no error message. However when it gets to the putting the results of the formula in the cell range (G:15, H:15, G:16, H:16) it does not it puts

Please Login or Register  to view this content.

and invalid name error.

I hope this helps.

**teylyn** · 01-13-2011, 04:53 AM

After the macro has run, what is the exact formula in the cells with the Name? error? Copy the formula from the formula bar and paste it here.

**jeskit** · 01-13-2011, 04:56 AM

Hi

This is the formula code the macro puts in the cell

Please Login or Register  to view this content.

put the result is #NAME? but there is a green comment attachted to the cell which says the error is Invalid error name

**teylyn** · 01-13-2011, 05:01 AM

Ah, there seem to be superfluous and unwanted ' signs in the formula. It should read

=MAX('Dealer Extracts'!H15:H35)

not

=MAX('Dealer Extracts'!'H15':'H35')

I don't see how the code you posted would put in the extra ' signs, though.

Can you strip all confidential data from the workbook, replace with dummy data and post the file?