so you mean, for example, you want to add a new resource manually,
then press a button perhaps to update an output sheet?
On 3 Oct, 12:42, Cecilia Chiderski wrote:
> Hi, I need your expertise on this... Example attached. I have a list of
> resources with different locations. There are 3 possibl
Put this code behind the sheet that you are using
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
If Target.Address = "$A$1" Then
RightCellClicked
Else
WrongCellClicked
End If
End Sub
Insert a module in the workbook and put this cod
For a start, you don't need to activate the sheet to do things to it.
You can write for example:
Sheet1.range("a1").offset etc
As for the activecell and offsetting there are better ways but depends
on how your workbook is set up (named ranges are useful here)
If you post your actual code
Presumably when it finds the occurrence, it activates the sheet the
occurrence is in, so:
var_SheetName = activesheet.name
should do it
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this gro
