Macro virgin

[Colin Bishop]

i have inherited a workbook for calculating and recording wages. The module that extractes information from a worksheet and transfers it to another worksheet has a formula =SELECT("hings") if I change hings to smith an 'error at cell x' box appears. What am I doing wrong? This is the complete macro.

=WORKBOOK.SELECT("Summary","Summary")
=SELECT("hings")
=COPY()
=SELECT("r8c10")
=WORKBOOK.SELECT("hings","hings")
=SELECT("xhings")
=PASTE.SPECIAL(3,1,FALSE,FALSE)
=DELETE.NAME("xhings")
=SELECT.END(4)
=DEFINE.NAME("xhings")

 

[JackDanIce]

Welcome to the board.

I think "hings" is a defined name or range, whereas "smith" isn't, that's why I believe it's failing.

You need to look at how your workbook is set up and defined

 

[Colin Bishop]

Thanks,

To explain further, The name hings is one of a list of employees names on a worksheet, what I want to do is add another name and alter the macro to see it or change a redundant employees name to the new name and alter the macro to see it.