I get the Sheet Name to Reflect a Info from a Specific Cell, but how can I have a default value when blank? [closed]

asked 2014-01-18 22:47:36 +0100

hammerhead13 gravatar image

I get the Sheet Name to Reflect a Info from a Specific Cell, but how can I have a default value when blank?

Using this From Karolus

sub abc(event) on Error resume next if right(event.AbsoluteName, 4 ) = "$K$6" then event.Spreadsheet.Name = event.String end if end sub

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-18 17:15:23.895229