Extending the range of an existing VBA based worksheet

[Amacdee]

I am a relative noob when it comes to VBA etc so please bear with me.

We have a worksheet with four columns (and an embedded formula) reaching to Row 100 then the calculations stop. I have tried copying and pasting (doh) from the first 100 rows into the next 100 but that clearly doesnt work. How can I unearth the program/macro going on behind the scenes just to extend the range that it calculates from 100 to 500 for example ?

[davesexcel]

Hi,
How is this macro activated?

[Amacdee]

"How is this macro activated?"

Thats a good question Dave. All I know is that the sheet has four columns. The first of which contains an employee name and the next three columns include their standard, overtime and double time pay rates.

In rows 3 to 100 it is possible to enter a surname in column A, then three monetary amounts in columns B, C and D. These are then used to calculate the costs in a timesheet (held in another worksheet). What we need to do is continue the process so we can add new employees in to columns 101 to 200.

However I have no idea where the macro or VB programming resides to activate these numbers. Is there a way to click on a cell and find out where its dependency lies ?

[yawnzzzz]

In Excel 2007, you'll have to go to the File Menu (round circle in top-left), and click Excel Options. Then check the Show Developer tab in the Ribbon. Now click on the Developer tab and there's a button called Macro's.

In Previous Excel, go to the Tools Menu, then point to Macro, and click Macros.

Once you get that far, copy and paste both the formula in the cells and the VBA code onto the forum. Don't forget to use [*code*] tags around it (without *'s).

[royUK]

I suggest you attach the workbook after removing any sensitive information

[davesexcel]

"How is this macro activated?"

Thats a good question Dave. All I know is that the sheet has four columns. The first of which contains an employee name and the next three columns include their standard, overtime and double time pay rates.

In rows 3 to 100 it is possible to enter a surname in column A, then three monetary amounts in columns B, C and D. These are then used to calculate the costs in a timesheet (held in another worksheet). What we need to do is continue the process so we can add new employees in to columns 101 to 200.

However I have no idea where the macro or VB programming resides to activate these numbers. Is there a way to click on a cell and find out where its dependency lies ?

Try right clicking the sheet tab and select "View Code", see if there is a code there

[Amacdee]

I'm using Excel 2003 BTW and I really dont want this to become the War and Peace of threads as I have no wish to tie up valuable resources.

However when I right click on the sheet tab and select "view code" it opens a VB screen with a box which would presumably show the macro inside. However the screen is blank so maybe if there are no macros its all VB programming instead ?

Anyway I have zipped up the workbook and will send it to whoever is prepared to take up the challenge

Many thanks

[yawnzzzz]

You can attach the workbook on here, so anyone can view it. Also, VBA coding and macro's are the same thing, so if it's blank then there's likely no programming code behind the scenes. We might just need to see the formula within the cells.

[davesexcel]

I'm using Excel 2003 BTW and I really dont want this to become the War and Peace of threads as I have no wish to tie up valuable resources.

However when I right click on the sheet tab and select "view code" it opens a VB screen with a box which would presumably show the macro inside. However the screen is blank so maybe if there are no macros its all VB programming instead ?

Anyway I have zipped up the workbook and will send it to whoever is prepared to take up the challenge

Many thanks

Hi Amacdee,
Attach it to your next post....