How to Remove Random Number Generator

[Lizzi]

Hi,

I have an excel 2007 spreadsheet that has a data table in it, the table contains sales revenue, one of the column is called 'amount" and there are a few others named "2011,2012,2013 etc. The sheet also contains a macro which when run will tell the user that certain colomns/rows have no data in them. The table also has a conditional format which calculates the $$ amount in the amount column to divide itself into months. When i drag the table down to add another line of new data, a randon number appears in the columns where the $$ amounts would go, any idea how i can stop this from happening please.

Sorry for the long explanation, wanted to give us much info as possible.

Thanx in advance for any help

 

[bertie]

Hi and welcome to the forum.

It sounds like there is a Worksheet_Change event associated with the spreadsheet. This code triggers when a change is made to the spreadsheet.

Right click the sheet tab.
Select View Code.

If there is a Worksheet_Change or Worksheet_SelctionChange event coded they may be something in the code which generates random numbers.

NB Be careful, there may also be code in these events that you need. Make a copy of your workbook before deleting anything.

If in any doubt post the code back here.

 

[Lizzi]

Hi,

Thanku for the reply

I checked the code (right clicked on the sheet and clicked view code) it's blank, i checked all the other sheets in the work book and they to are blank?

am i missing something?

 

[mikerickson]

What kind of data or formulas are in the columns of the existing columns that give these numbers when dragged?

What happens if you insert rows into the existing table?

What kind of "random" numbers appear?

Have you looked in the ThisWorkbook module to see if there is any code in there?

 

[buxtongt]

Are you sure the numbers showing up are random? Could they be pulling from somewhere and just look random? Have you tried extending it once, closing the file without saving, reopening the file and extending it again to see if you get the same number?

 

[Lizzi]

Hi, thanx for replyng.....

the column where the randon number appears has no formula or macro associated it with it, the data in the cell immediately above the newly inserted row contains a $$ value and if you insert a row or drag the table down to add a row to the end, the same thing happens. It adds another $$ value of a much higer amount, its like it multiplies the cell.

i checked all worksheets and the work book, there is no code showing.

 

[xenou]

Maybe the data is autofilling. For instance, if you put a 1 in A1 and a 2 in A2 and drag down, you'll get 3 in A3.

Sometimes you don't have to drag down to put new data in a table (?) - what are you looking for when you drag down? Do you want formulas to fill in? Or just formatting to fill in?

 

[bertie]

i checked all worksheets and the work book, there is no code showing.

In the Project Window where you checked the Sheets and ThisWorkbook, is there a reference for "Modules"?

If so expand that and see if there is code in any of those modules.

 

[Lizzi]

i was dragging it down or inserting rows as columns AC to EH have a conditional format in them, so i was dragging to make sure the format was the same as the line above

 

[Lizzi]

In the Project Window where you checked the Sheets and ThisWorkbook, is there a reference for "Modules"?

If so expand that and see if there is code in any of those modules.

The only thing i can expand on is:
Microsoft Excel objects, it then lists all the sheets associated to the workbook and there is no code in any of them, including the last one that says "this workbook"