Hi,
Try this..
Sub lookupconfirm()
Range("F3").Formula = "=IFERROR(IF(VLOOKUP(E3,A3:A7,1,0)>0,""OK""),""Not
OK"")"
Range("F3").Copy
Range("F3:F" & Cells(Rows.Count, 5).End(xlUp).Row).Select
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub
Warm
Hi,
I have a query. I have two table named original and other.
Now I want to look up for ID,s and check for mismatch in the status in both
table.
For ex-
If 121 is there in lookup table with status ok but the status of 121 in
original table is active I should be able to detect the mismatch
I a
Hi,
Try this..
Sub sheetprint()
Sheets("Summary").Select
Range("D:M").Select
Selection.PrintOut
End Sub
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of veerendra vanam
Sent: Thursday, September 05, 20
Hi,
Just UN-check "Check compatibility when using saving this workbook"
or save file in XLSX format
.
Enjoy
Team XLS
On Thu, Sep 5, 2013 at 1:06 PM, Chandra Shekar wrote:
> Hello Ashish,
>
> Could you please let me know why Chart disapperars while saving the file,
