Running Macro from another sheet but referring to Active Worksheet

Hi,

This is day 3 of me learning VBA and I am trying to learn it by doing practical work.

So I started writing a macro for a sheet called "MealCal", once I had it working on that sheet, I then decided I needed to run it from another sheet called "Meal Schedule" because that sheet will pull the data results from the sheet called "MealCal" via vlookup and give us a nice summary.

MY problem is when I started running it from the sheet "Meal Schedule" it does not paste the first row of Sheets("14 Room 09-14") into A1 of sheet "MealCal" instead is pastes it in from row A6 down and the next column again starts from row B6.

BUT when I run the macro from "MealCal" it starts at the top at A1.

I have got a problem with understanding referring to active sheet yet working from another sheet, Please could you help me with the code below. The code starts pasting in row6 of sheet "MealCal" from the second last line in the below code.

Please Login or Register  to view this content.

Hi, JBeaucaire

Thanks so much for the help, my macro is now working properly for your above help.

Hi JBeaucaire,

I have just run into a problem with this code which you gave me earlier, I am needing to copy the rows to the other sheet but it needs to be paste as values. How would I change the below code to make it paste as a value? When I paste Selection.PasteSpecial Paste:=xlPasteValues at then end of the below code it just gives me errors.

Please Login or Register  to view this content.

Works perfectly, thanks a mil.