Hi vietm
Tried renaming again as you suggested and when the copied code has name without number it works? have tried leaving numbers of both but does not work. However I think I have found solution - incorporated copied code into original and it worked! Thanks very much. A good lesson in fault...
Not sure I understand you!
1. The original code runs when data is entered... the copied code should run the same way.
2. I have run the copied code in the VBA window but it stops and looks for MergeCells1 instead of calling MergeCells2
3. I have tried changing name of copied code with same...
Hi
The original code runs automatically when data is entered into the cell E9. I didn't write this code I found it on the web and altered it to suit. It works fine and the re-numbered macros (which Merge cells and Unmerge cells and replace a formula) for the cells further down the document work...
Hi
I have placed the following code into a spreadsheet which works perfectly, however I have copied this code and changed the macros being called but the new vba code is still calling the old macro
original code
Private Sub Worksheet_Change(ByVal Target As Range)
Dim changed As Range
Set...
Hi Hui
Thanks for the reply, unfortunately my plans have changed a little. The user enters data for labels and the last entry is the number of pallets requiring labels, this data is transferred to the sheet where the labels are and tells the user how many sheets to print. What I really would...
Hi All
I have a workbook which users enter data for labels in one sheet this data is linked to another sheet which has the layout for the labels. the user enters the number of individual labels required and then this is converted to the number of pages required as there are 8 labels per...