using macros across a sheet

**daveyboy123** · 02-03-2008, 09:51 AM

Hi all,
how do I use a macro across a spreadsheet?I can record a macro OK,but when I try to use it again on the same spreadsheet all I get is the macro calculating using the same data as when I recorded it.I have several groups of data across one spreadsheet and I want to use the same macro over the entire sheet.How do I do this?Thanks in advance,
Dave

**VBA Noob** · 02-03-2008, 09:54 AM

Please read forum rules below. I've move your post to programming

If you add your code use

code tags

as per example and someone will take a look

VBA Noob

**daveyboy123** · 02-03-2008, 10:00 AM

Hi all,
how do I use a macro across a spreadsheet?I can record a macro OK,but when I try to use it again on the same spreadsheet all I get is the macro calculating using the same data as when I recorded it.I have several groups of data across one spreadsheet and I want to use the same macro over the entire sheet.How do I do this?Thanks in advance,
Dave

**VBA Noob** · 02-03-2008, 10:24 AM

daveyboy123,

Please read forum rules and message to cross posters below and then add a link to your cross post

Also your duplicate posts have being merged

VBA Noob

**royUK** · 02-03-2008, 10:26 AM

I think this is the same question

http://www.excelforum.com/showthread.php?t=631931

**daveyboy123** · 02-03-2008, 10:38 AM

Ok,here is the workbook.Hopefully someone can help!Pleas keep in mind I am a complete noob with Excel!

**Norie** · 02-03-2008, 11:19 AM

Nice workbook - shame there's no code in it.

**royUK** · 02-03-2008, 12:04 PM

There's nothing to indicate what you are averaging.

**daveyboy123** · 02-03-2008, 12:29 PM

Sorry all,as I said I am new to all this!I need the averages across all the %age rows for every compartment(A1,A2,A3 etc)Here it is again,this time if you look at A1(column 18) I have worked out the averages across all the rows....I need a simple macro that will do this for me over the whole sheet.I have very little of experience of Excel,but I can get a macro to work for one compartment.