Search:

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

Search: Search took 0.00 seconds.

  1. Re: How to find the last column which is not empty

    It was my mistake, I was doing wrong concatenation earlier. Now I corrected it and completed my task: Range(ColumnLetter & "1").Activate
    Thanks Rick, Joe and everyone for your help and suggestions....
  2. Re: How to find the last column which is not empty

    I'm unable to pass the variable here: Range(ColumnLetter).Activate. I tried with &, "", etc but getting error. Hence I used Cells(1, lc).Activate instead of Range. However I would like to know how we...
  3. Re: How to find the last column which is not empty

    I'm able to get the Column Letter using the below code:
    'Finding the last column
    lc = Cells(1, Columns.Count).End(xlToLeft).Column
    'Convert To Column Letter
    ColumnLetter = Split(Cells(1,...
  4. How to find the last column which is not empty

    I have the below code:

    Range("A:A,B:B,C:C,D:D,E:E,F:F,G:G,H:H,I:I").Select
    Range("I1").Activate
    ActiveSheet.Shapes.AddChart2(227, xlLine).Select
    ActiveChart.SetSourceData...
  5. Re: Need a macro for clicking all the URL's present under one column

    I tried using the below code but it is overwriting the previous content and not appending. Can someone please modify the code so that next content will be appended.

    Sub Macro1()


    Dim i As Long...
  6. Need a macro for clicking all the URL's present under one column

    I have some random number of hyper links under column G. Clicking a link will open internet explorer downloads dialog box and asks to choose whether to open or save the CSV file. When clicking save...
  7. Re: Need macro for copying values from single column and pasting in multiple columns

    First cell is A1
  8. Re: Need macro for copying values from single column and pasting in multiple columns

    I'm unable to upload the image. Data starts from first cell (Server1)
  9. Re: Need macro for copying values from single column and pasting in multiple columns

    Server names (server 1, server 2 ... etc) are not getting copied.
  10. Re: Need macro for copying values from single column and pasting in multiple columns

    Thank you very much Dante Amor, it is working perfectly fine. But I forgot to mention one thing. I need the server names (server 1, server 2 etc) that are present in column A to be copied to the...
  11. Need macro for copying values from single column and pasting in multiple columns

    Hi All,

    I need macro for the below task.
    I need to copy each set of data under each header from column B to column D, column E, and so on.


    <colgroup><col span="2"></colgroup><tbody>
    Column...
Results 1 to 11 of 11