In place of: ActiveCell.FormulaR1C1
use: ActiveCell.Formula
change other part of formula accordingly.
Akhilesh
On Fri, Nov 21, 2008 at 8:56 AM, Leigh Williams <[EMAIL PROTECTED]>wrote:
>
> I am trying to do a vlookup on my Excel spreadsheet using the
> following VBA code:
>
> Dim row As Inte
Could you post the file in question?
Tom
On Thu, Nov 20, 2008 at 10:46 AM, macrogirl <[EMAIL PROTECTED]>wrote:
>
> I have a sub procedure written under another procedure. When I press
> F5 to run the procedure, it is not listed in the drop down menu but
> the code right above it is. Any suggestio
Dear Vicent,
Follow the below mentioned process according to step.
1. Select Data
2. Select Validation
3. "In Allow" select List
4. and In source give the range of required data or list which you want.
*Unfeigned Regards
Manoj S Negi*
*"Miles & miles to go before I sleep"
¨`·.·´¨) Always
Hi People,
I was looking for some help on the attached file.I have the data on
sheet 1 and in sheet 2 I want the data to be compiled for every
person.It should have the subtotal for each person in regards to "P".
Thanks.
--~--~-~--~~~---~--~~
Visit the blog to dow
