Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Re: How to read gmail inbox without outlook, dll ....

    posted to https://www.excelforum.com/excel-programming-vba-macros/1283339-how-to-read-gmail-without-outlook.html#post5158495
  2. How to read gmail inbox without outlook, dll ....

    I can send an email via vba without outlook, but I can not receive emails, can you help me ?
  3. Replies
    3
    Views
    2,069

    Re: VBA help - Count Prime Numbers

    Hi Rick, can you explain me your code ? I can not understand how you find prime numbers
  4. Thread: computer name

    by patel45
    Replies
    4
    Views
    283

    Re: computer name

    Sub a()
    sHostName = Environ("computername")
    if sHostName <> "Mypc" then exit sub
    End Sub
  5. Replies
    4
    Views
    286

    Re: Userform called in macro

    can you provide a link to a sample file ?
  6. Replies
    4
    Views
    329

    Re: selecting random rows

    can you provide a link to a sample file ?
  7. Replies
    4
    Views
    170

    Re: Split and save code

    This is not important for an excel file, it would be important for a text file.
  8. Re: Remove duplicates function will not work -

    You are right, I can not remove them on my Excel 2010, ir runs only if I select one column
  9. Replies
    4
    Views
    170

    Re: Split and save code

    I don't understand your problem, are the rows after rast row LR not empty ?
  10. Replies
    6
    Views
    173

    Re: Copy Destination error

    Your code works on my test workbook, check sheets names
  11. Replies
    4
    Views
    263

    Re: Find last row VBA no longer working

    LastRow = Sheets("Core").Cells(Rows.Count, 1).End(xlUp).Row + 1
  12. Replies
    2
    Views
    119

    Re: adding 1st row as header

    change
    Worksheets("sheet2").Cells.Clear
    to
    Worksheets("sheet2").Rows("2:1000").ClearContents
  13. Replies
    2
    Views
    348

    Re: macro for importing text files

    Sub adt()
    fname = inputbox("Enter file name without path and extension")
    With ActiveSheet.QueryTables.Add(Connection:="TEXT;Z:\" & fname & ".ADT", _
    Destination:=Range("$Z$13"))
    ...
  14. Re: Using macro to reference previous sheet in formula

    can you attach a small sample file for testing ?
  15. Re: Using Macro to import excel files into active workbook

    Merge data from all workbooks in a folder (1)
  16. Replies
    1
    Views
    4,040

    Re: Resize userform VBA

    I don't know the best, but try this code

    Declare Function GetSystemMetrics Lib "user32" (ByVal nIndex As Long) As Long
    '---------------------------------
    Public Function GetSR() As Variant...
  17. Re: What's wrong with this file?? (creating new rows in a table make Excel crash)

    your link ask for permission
  18. Replies
    2
    Views
    156

    Re: Looping dose not work in Excel

    eliminate Exit For before Next WS
  19. Re: MACRO to copy data.xls file from different subfolders to dest folder and rename the file

    Name C:\Test\File.xls As C:\Test\File_1.xls

    FileCopy C:\Test\Data.xls, C:\Done\Data.xls
  20. Replies
    1
    Views
    377

    Re: Please Help Me For VLOOKUP Function

    MrExcel Message Board FAQ

    it's the second time you start with help
  21. Re: turn on/off the Private Sub Worksheet_SelectionChange(ByVal target As Range)

    You can reserve a cell i.e. Z1 for a flag, then

    Sub Worksheet_SelectionChange(ByVal target As Range)
    If range("Z1") <>"" then exit sub
    ' put here your code
    ..............
    end sub
  22. Replies
    6
    Views
    220

    Re: Macro or formula to check for Dupes

    Private Sub aa()
    Dim cell As Range
    Sheet2.select
    r1 = 1
    r2 = 12
    For r = r1 To r2
    Range("X" & r & ":Y" & r).Interior.ColorIndex = 0
    Range("Z" & r) = Range("Y" & r) & "," & Range("X" & r)...
  23. Replies
    6
    Views
    220

    Re: Macro or formula to check for Dupes

    this code uses column Z for service

    Sub aa()
    Dim cell As Range
    r1 = 1
    r2 = 18
    For r = r1 To r2
    Range("Z" & r) = Range("Y" & r) & "," & Range("X" & r)
    Next
    For r = r1 To r2
  24. Replies
    4
    Views
    601

    Re: How to remove #N/A from chart.

    see attached http://www.filedropper.com/graphoccurrences
  25. Replies
    30
    Views
    3,024

    re: Auto Transpose macro

    Sub a()
    LR = Cells(Rows.Count, "A").End(xlUp).Row
    p = 1000 ' you can change this value
    drow = 1
    dcol = 3
    For r = 1 To LR Step p
    Set Rng = Range("A" & r & ":A" & r + p - 1)
    ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4