Search:

Type: Posts; User: dxzaber; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Re: VBA to import data in already opened third party software.

    99 Views but no reply. Am i asking for something impossible or very difficult or my post missing any information.?
  2. VBA to import data in already opened third party software.

    Sub openspcolumn()


    CreateObject("Shell.Application").Open (ThisWorkbook.Path & "\SP" & "\slendercolumn.col")




    End Sub...
  3. Replies
    3
    Views
    170

    Re: Saving Specific Sheet With VBA

    Sheets("Sheet4").Copy


    Adding this only creates a new copy of sheet4 . Does not even save.
  4. Replies
    3
    Views
    170

    Saving Specific Sheet With VBA

    Private Sub CommandButton1_Click()
    Dim path As String
    Dim filename1 As String
    path = ThisWorkbook.path
    filename1 = Range("K2").Text
    Application.DisplayAlerts = False
    ActiveWorkbook.SaveAs...
  5. Connecting Specific Point in Scattered Graph

    How to connect Specific Point in Scattered Graph.
    <tbody>
    X
    Y


    1
    10
  6. Replies
    20
    Views
    812

    Re: Vlookup is not working Properly

    Change B6 and formula still works.
  7. Replies
    20
    Views
    812

    Re: Vlookup is not working Properly

    THANKS MARK858. You suggestion solved the problem . But i dont understand what was the problem
  8. Replies
    20
    Views
    812

    Re: Vlookup is not working Properly

    V28 should return 0.0000 rather than #N/A
  9. Replies
    20
    Views
    812

    Re: Vlookup is not working Properly

    Please Check https://drive.google.com/open?id=0B1GJKIl2o1WZM0xIa1JTaXhjMEk

    Tell me whats wrong with V28,W28,X28............ Cell formula?? and is there any alternative of Vlookup
  10. Replies
    20
    Views
    812

    Re: Vlookup is not working Properly

    i have changed cell format to text . but still if i select two cell right bottom corner shows average sum etc. Very confusing. if i check U28 with TYPE function .it returns 1 which is for number...
  11. Replies
    20
    Views
    812

    Re: Vlookup is not working Properly

    i have changed as you [mole999] have recommended , But still facing same problem
  12. Replies
    20
    Views
    812

    Re: Vlookup is not working Properly

    Does not work with other values. Change .78 to see or change U28 reference to B17
  13. Replies
    20
    Views
    812

    Re: Vlookup is not working Properly

    how can I share my excel with you???
  14. Replies
    20
    Views
    812

    Vlookup is not working Properly

    https://drive.google.com/open?id=0B1GJKIl2o1WZYkh1NUhzV0djWUk

    please Check my excel from link

    why Formula in Cell V28 ,W28 , X28 ,..... is not working????

    When only i put .78 in Cell U28...
  15. Replies
    10
    Views
    264

    Re: Vllookup & Hlookup combination

    Yeah it works 100% .
  16. Replies
    10
    Views
    264

    Re: Vllookup & Hlookup combination

    Can you solve it using Vlookup & hlookup???
  17. Replies
    10
    Views
    264

    Re: Vllookup & Hlookup combination

    But why Vloopup & Hlookup not working ????
  18. Replies
    10
    Views
    264

    Re: Vllookup & Hlookup combination

    this one works. Thanks a Lot
  19. Replies
    10
    Views
    264

    Re: Vllookup & Hlookup combination

    value in cell AY11 & BI7 will change .say for .5 in BI7 your formula does not work..
  20. Replies
    10
    Views
    264

    Vllookup & Hlookup combination

    https://drive.google.com/file/d/0B1GJKIl2o1WZNWtHWGItWURZLTg/view?usp=sharing

    Please refer to to table AY6 To BM18 (Overall Pressure Coefficient ,Cp for X direction)

    for value in cell AY11 &...
  21. Replies
    5
    Views
    171

    Re: Conditional Formatting

    THANKS FOR YOUR REPLY. I AM NOT GOOD at macros/VBA .So have decided to omit last stage now its in three color (excel 2013)

    cell B1=10

    if cell A1 value is greater than B1 (say A1=11 ) , I want...
  22. Replies
    5
    Views
    171

    Conditional Formatting

    cell B1=10

    if cell A1 value is greater than B1 (say A1=11 ) , I want Cell B1 to be filled with RED

    if cell A1 value is less than B1 and B1 is larger by 10% or less (say A1=9.1,9.8,9.5) , I...
  23. Showing Numerical value before operation

    say i have 20 in cell A1 and 30 in cell A2.i will sum A1+A2 in cell A4. i want cell A3 to show numerical value and operation sign . In this case that will be 20+30
  24. Re: Vlookup Hlookup is not giving desired result

    Problem Solved ..Hidden column was the problem .Thanks A lot
  25. Re: Vlookup Hlookup is not giving desired result

    problem Solved ..Hidden column was the problem .Thanks A lot
Results 1 to 25 of 35
Page 1 of 2 1 2