RE: $$Excel-Macros$$ vba - run time error 9 out of range

groups.com Subject: $$Excel-Macros$$ vba - run time error 9 out of range hi all, im new to VBA and trying run below, when i run the code excel throws run time 9 error message, can you please help on this error Thanks Private Sub Worksheet_Calculate() Dim rng As Range, c As Range Dim ws As Wor

Re: $$Excel-Macros$$ vba - run time error 9 out of range

There are a lot of possibilities and without knowing what line of code is throwing the error it is difficult to be certain. The most likely errors are that either a sheet-name is not exactly the same as the trimmed name in Column A (for example the sheet name might have a space at the end) or the

Re: $$Excel-Macros$$ vba - run time error 9 out of range

2:20 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ vba - run time error 9 out of range hi all, im new to VBA and trying run below, when i run the code excel throws run time 9 error message, can you please help on this error Thanks Private Sub Worksheet_Calculate() Dim rng As

$$Excel-Macros$$ vba - run time error 9 out of range

hi all, im new to VBA and trying run below, when i run the code excel throws run time 9 error message, can you please help on this error Thanks Private Sub Worksheet_Calculate() Dim rng As Range, c As Range Dim ws As Worksheet Dim lastRow As Long Dim x As Variant Set ws = Worksheets("Component