Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Using 'With Workbook' and 'Do while' loop through multi workbook

    This works perfect!

    Thanks
  2. Using 'With Workbook' and 'Do while' loop through multi workbook

    Hi ...

    I have multiple workbooks saved in a folder and the code below seems to only work for my first file. However, I need it to work for all the files in the folder but can't seem to see where I...
  3. Replies
    12
    Views
    227

    Re: Repeating my code until the last row of data

    <tbody>
    COL L
    COL M
    COLN
    COL O
    COL P


    ROW 1
    project 1
  4. Replies
    12
    Views
    227

    Re: Repeating my code until the last row of data

    Yes therebis data is sheet4
    So
    COL COL M COL N
    Header 1 header 2 header 3 .....
    Value value value
    Blank blank value
  5. Replies
    12
    Views
    227

    Re: Repeating my code until the last row of data

    Thanks...

    However, I need A3 to change also ( so drop down each row).. What I am trying to do is change my table above from


    <colgroup><col width="64" span="7" style="width:48pt">...
  6. Replies
    12
    Views
    227

    Re: Repeating my code until the last row of data

    column A
  7. Replies
    12
    Views
    227

    Re: Repeating my code until the last row of data

    If someone can help with this. That'll be much appreciated.
  8. Replies
    12
    Views
    227

    Re: Repeating my code until the last row of data

    Thank you for your response and i want the code to run on every line of my sheet, all the way down to the last row
  9. Replies
    12
    Views
    227

    Repeating my code until the last row of data

    Hi ,

    I have the data set


    <colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>

    COL A
    COL B
    COL C
  10. Replies
    9
    Views
    293

    Re: Using Offset on Visible cells only

    No the code works only for the first offset for the first visible cell. i.e ( It will drop down to range(A19).

    - Data filtered showing all data that has a 'Y' associated to it in a hidden column.
  11. Replies
    9
    Views
    293

    Re: Using Offset on Visible cells only

    Unfortunately , this does not work for me. once the code is run it stays at the cell below Range("A10")
  12. Replies
    9
    Views
    293

    Re: Using Offset on Visible cells only

    Hi ,

    I seem to get the code 'Application defined or object defined error' when I run the code below.
  13. Replies
    9
    Views
    293

    Using Offset on Visible cells only

    Hi,

    I have the code



    ActiveSheet.Range("A10").Offset(1, 0).Select


    But this does not work for me as my data is filtered. I do not want to unfiltered the data. But how can I use offset on...
  14. Looping until the last row in sheet - copy cell i until last colmn

    Hi and thanks,


    Data set

    Col A Col B Col C Col D Col E Col F Col G
    Row 1 x x x x x ...
  15. Replies
    5
    Views
    107

    Re: selecting a range with an unknown col end

    Thank you this also works !
  16. Replies
    5
    Views
    107

    Re: selecting a range with an unknown col end

    This works exactly what I am after !
    Thank you !
  17. Replies
    5
    Views
    107

    selecting a range with an unknown col end

    Hi and thanks in advanced.

    I have the data set

    ColA ColB ColC ColD ColE ColF ColG ColH ColI
    Row 1 x blank cell x blank cell ...
  18. Replies
    10
    Views
    169

    Re: Selecting a Cell & Range

    Yes there are merged cells. Is this what is causing the issue?
  19. Replies
    10
    Views
    169

    Re: Selecting a Cell & Range

    I receive the error with this code


    Range("P10", Cells(10, last_col)).Select
  20. Replies
    10
    Views
    169

    Re: Selecting a Cell & Range

    Yours sorry Fluff
  21. Replies
    10
    Views
    169

    Re: Selecting a Cell & Range

    Thank you for your response.
    I still receive the same error message
  22. Replies
    10
    Views
    169

    Selecting a Cell & Range

    Hi and Thanks in advanced.

    I am trying to select the cell P10 and the last col as set as my range below.
    but I receive the error 'Application defined - object error'
    I have the code below:

    ...
  23. Replies
    8
    Views
    210

    Re: Do Until Loop Not Working for my last row !

    Because I need this set range repeated until the last row with data ( this last row with data will be different for each time I may run the code.
  24. Replies
    8
    Views
    210

    Re: Do Until Loop Not Working for my last row !

    So I have a a set range that I need to paste (doesn't matter if values or not) in a column i.e 'H' until the last row with data.

    Hope that helps.
  25. Replies
    8
    Views
    210

    Re: Do Until Loop Not Working for my last row !

    I have just tried that and still occur the same problem
Results 1 to 25 of 92
Page 1 of 4 1 2 3 4