Search:

Type: Posts; User: seenu_1st

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds; generated 28 minute(s) ago.

  1. MsOf07 Re: Sort comma separated numbers and normal numbers together

    yes, you are right, need to use only 1st digit for sorting. The cells may contain individual numbers and comma separated numbers too.

    I have solved this by looping thru rows to extract 1st chr...
  2. MsOf07 Re: Sort comma separated numbers and normal numbers together

    yes, you are right, need to use only 1st digit for sorting. The cells may contain individual numbers and comma separated numbers too.

    Thanks!
  3. MsOf07 Re: Sort comma separated numbers and normal numbers together

    normal sorting through VBA

    With ActiveWorkbook.Worksheets("Sheet1").Sort
    .SetRange Range("A1:A7")
    .Header = xlNo
    .MatchCase = False
    .Orientation =...
  4. MsOf07 Re: Sort comma separated numbers and normal numbers together

    Hi Vbfbryce, thanks for your reply, 79 comes first, but i need 7,8,9 to be first.
  5. MsOf07 [RESOLVED] Sort comma separated numbers and normal numbers together

    Hello experts!

    I have some data that a column contains number alone and comma separated together, I need to sort considering both criteria, example as shown below

    Col A
    3
    5
    7,8,9
    11
    6
  6. MsOf13 Re: check if day difference less than 3 days in a range of dates

    good work ! thanks for ur time,

    actually i m trying to do it by any formula / array formula with out any VBA code.
  7. MsOf13 Re: check if day difference less than 3 days in a range of dates

    yes I agree, it is not only that column, i have other data in other columns, i m trying to highlight when enter a date (with lesser interval) in the column.
  8. MsOf13 Re: check if day difference less than 3 days in a range of dates

    exactly ! camparing with each and every dates.
  9. MsOf13 Re: check if day difference less than 3 days in a range of dates

    please see the image below, row 1 and 5 less than 4 days, row 3 and 5 less than 4 days, hope you get me now.

    145673
  10. MsOf13 Re: check if day difference less than 3 days in a range of dates

    not only between 2 dates, i need to check all the dates (between each date in the column) in the column A to be compared and should be more than 3 days.

    Thank you,
  11. MsOf13 Re: check if day difference less than 3 days in a range of dates

    hi,
    thanks for your valuable time.

    I have 'n' number of dates in column A, the interval between any date should be more than 3 days else need to highlight.

    thanks in advance.
  12. MsOf13 check if day difference less than 3 days in a range of dates

    dear experts,

    I need a formula to check the dates in a range which differs less than 3 days among them, I m going to highlight that cells by conditional formatting.

    Thanks in advance.
    ...
  13. Replies
    2
    Views
    3,467

    MsOf10 Upload file using Winscp by excel vba

    Hi experts,

    I need help to upload a file and compare the size using Winscp, any samples and suggestions pls

    Thank u
  14. Replies
    1
    Views
    1,008

    Check the file size from FTP

    Hi experts,

    I have uploaded files to FTP by executing a batchfile thru vba code, i just need to check the file size which i uploaded to confirm that the file loaded fully
    any suggestions and any...
  15. Replies
    4
    Views
    975

    Re: min max value from txt file

    @opus, i m trying with second option as it is faster, thanks for ur reply
    @Doogle, thanks for ur reply, i wil try ur code, how to open multiple splited files simulatneously?
  16. Replies
    4
    Views
    975

    min max value from txt file

    Dear friends,
    I need to get the min / max XYZ value from a txt file, the txt file got 1000's of lines like 10,000, 20,000 and more lines
    so line by line looping is very slow, any better idea to...
  17. Replies
    43
    Views
    8,258

    Re: SUM of selected cell range

    Hi Ria,
    which line gives error? can u attach the file u tried?
  18. Replies
    43
    Views
    8,258

    Re: SUM of selected cell range

    Ria, the post #30 dosent help?
  19. Re: Datagrid not supported Refresh after add, delete, ... ?

    with out seeing the code cant predict the problem, post the code and which line gives the error?
  20. Re: Delete unwanted Columns and add some text to 1st column of a csv

    do u need to do these from excel VBA or VB6?
  21. Re: Datagrid not supported Refresh after add, delete, ... ?

    can u post delete / insert code?
  22. Replies
    21
    Views
    2,097

    Re: Resize everything on a form?

    see this link
  23. Replies
    29
    Views
    2,387

    Re: Prevent Shifting Number!

    ur requirement may not be clear as the users to be understood, better start a new thread with clear info, Goodluck!
  24. MsOf10 Re: [RESOLVED] Excel - Copy value of cell paste into another cell

    Thank u sidhu!
  25. MsOf10 Re: Excel - Copy value of cell paste into another cell

    i hav only 2003 version, can u pls atach 2003 version pls?
  26. MsOf10 Re: Excel - Copy value of cell paste into another cell

    whenever u change any row value in sheet1 Col A, u need that changed row value to be pasted in sheet2 A1, am i right? if yes then why dont u use Worksheet_Change event?
  27. MsOf10 Re: Excel - Copy value of cell paste into another cell

    what do u hav in Col B?
  28. Replies
    4
    Views
    680

    Re: Remove records with 0 values

    something like this

    "Select * From Tablename Where Column1 <> 0"
  29. Replies
    9
    Views
    1,539

    Re: Adobe flash player error

    is IE9 suitable for windows xp service pack 3?
  30. Replies
    9
    Views
    1,539

    Re: Adobe flash player error

    firefox and google chrome is working fine, IE8 only the problem.
  31. Replies
    9
    Views
    1,539

    Re: Adobe flash player error

    i hav tried the old verion, but it gives this error, pls see the image, i hav already uninstaled the latest one,
    thanks for ur help!
  32. Replies
    9
    Views
    1,539

    Re: Adobe flash player error

    thanks for the reply, where can i get the older version of flash player?
  33. Re: Delete files in folder that are older than a certain date?

    try like this

    Private Sub Command1_Click()
    Const FromFolder = "D:\seenu\from\" 'change path
    Const FilePattern = "*.log" 'change pattern
    Dim File As String

    File = Dir$(FromFolder &...
  34. Replies
    30
    Views
    5,835

    Re: Separate text, populate list box

    but the names r date/time is it?
  35. Replies
    30
    Views
    5,835

    Re: Separate text, populate list box

    u need to loop thru each file in the folder with above Max187Boucher's FileDateTime() function to get the recent date/time.

    edited: if the filename is Date/Time then u can compare the filename...
  36. Replies
    43
    Views
    8,258

    Re: SUM of selected cell range

    yes, see the attached excel file for example.
  37. Replies
    8
    Views
    1,071

    Re: Problem resizing Picturebox

    see this link if anything useful for u
  38. Replies
    43
    Views
    8,258

    Re: SUM of selected cell range

    may be With Block missing

    With sheetname
    'code
    End With

    r u running this code from excel or access?
  39. Replies
    9
    Views
    1,539

    Adobe flash player error

    Dear experts,
    I m facing a problem with adobe flash player 11, my exact problem is, when the shockwave flash object addon in enabled in IE8, i cudnt attach anything in yahoo mail, if i disable that...
  40. Replies
    4
    Views
    680

    Re: Remove records with 0 values

    why dont u avoid 0 values when u open recordset by query?
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width