Recent content by nehanaik25

  1. N

    which one is faster in excel vba, For loop or Do-While loop?

    Hi, I am looking for an answer for which one is faster in excel vba, For loop or Do-While loop? Thanks in advance!
  2. N

    Excel/VBA Certification

    Hi, I would like to know if there any Excel/VBA certification exist. I searched on the web but couldnt find any information. Thanks in advance.
  3. N

    Excel Problem with macro in Excel VBA working across sheets

    Hi Bitsbb01, If you are using worksheet level event then you can use offset, something like Private Sub Worksheet_Change(ByVal Target As Range) If VBA.InStr(1, Target.Address, "AT", vbTextCompare) Then Worksheet_Calculate2 Target End If End Sub Sub Worksheet_Calculate2(ByVal...
  4. N

    Excel how to add right click options on table object of excel 2007

    i got the solution.. Intead of cell level i used table tevel command bar button.. i.e. replace Application.CommandBars("Cell") with Application.CommandBars("List Range Popup") Thanks
  5. N

    Excel how to add right click options on table object of excel 2007

    Hi, I have to add some right click options(context menu of table object) on table object of excel. I can add right click command bar buttons in excel workbook event 'Workbook_SheetBeforeRightClick'. But when i click on a table object i dont see my custom right click options. anyone knows...
  6. N

    VBA: change cell to blank based on change to another

    Hi mjkd, Try something like Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$D$3" Then 'Exit Sub Range("D4").ClearContents Range("D5").ClearContents Range("D14").ClearContents Range("D15").ClearContents ElseIf...
Top