Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    104

    Re: Horizontal Dynamic Named Range

    Of course, thank you! That fixed it.
  2. Replies
    2
    Views
    104

    Horizontal Dynamic Named Range

    Hi all,

    I have created a dynamic range that expands vertically in the same column.

    =OFFSET(B1,0,0,1,COUNTA(1:1))

    My data starts and B1 (Sheet1) and currently ends in CU1, but I keep adding...
  3. Replies
    0
    Views
    96

    Apple Mac File Path

    Hi all, I'm working on a spreadsheet for a friend who uses a Mac. I have zero experience on a Mac so I'm hoping I could get some help please.

    The below code works on my PC but it fails on his...
  4. Re: Find number of days in a date range but only for a specific Month

    Thank you, they both worked well. I appreciate the quick responses.
  5. Find number of days in a date range but only for a specific Month

    Hi all,

    I'm looking for a formula to find the number of days within a date range, but only for a specific month (in this case, July):


    <tbody>
    Start Date
    End Date
    Expected
    Result (days)
  6. Replies
    5
    Views
    248

    Re: VBA Filter From Named Range

    Hi igold,


    That code works really well and I want to say thank you so much for taking the time to help me out, I really appreciate it.


    If it's not too much trouble, would you be able to add...
  7. Replies
    5
    Views
    248

    Re: VBA Filter From Named Range

    Hi igold, thanks for taking a look at this.

    Yes, there are currently 14 names in the "Doc" Named Range and that is the only data contained in the Named Range. Although not very often, the names...
  8. Replies
    5
    Views
    248

    VBA Filter From Named Range

    Hi all, couldn't find an answer to my specific question so I'm hoping some one can assist.

    I have a range of data in Sheet1 from A1:T5000. I have a Named Range called "Doc" which I have created...
  9. Re: Conditional formatting - change color of data label in pie chart

    I found this code on another thread which I think is what I'm looking for.

    Could some one help me to apply this code to my pie chart please? My chart name is "Chart 26" and the data labels are...
  10. Conditional formatting - change color of data label in pie chart

    Hello,
    I'm trying to change the color of data labels in a pie chart according to the percentage value. e.g. If =< 5%, then Black, If >5%, then White
    After some research I tried entering a custom...
  11. Replies
    6
    Views
    394

    Re: user form initialising with US date not UK

    I did try it but I must have entered something incorrectly the first time.
    Tried it again and it works now.
    Thanks.
  12. Replies
    6
    Views
    394

    Re: user form initialising with US date not UK

    Hello,

    I didn't want to start a new thread so I'm hoping someone can help me with this similar issue.

    I'm using the below code to set a "To" and "From" date range in a UserForm. The dates in...
  13. Replies
    4
    Views
    121

    Re: Fill down formula

    Is anyone able to help me with this please? Thank you.
  14. Replies
    4
    Views
    121

    Re: Fill down formula

    Hi Caleeco, thanks for your help on this. Unfortunately I'm getting a Run-time error: '1004': Method 'Range' of object'_Worksheet' failed

    When I hit Debug, it takes me to this part of the code: ...
  15. Replies
    4
    Views
    121

    Fill down formula

    I have some simple code that copies data from sheet 'Auto', pastes in cell C2 and then auto-fills to C20000:



    Range("C2").Select
    ActiveCell.FormulaR1C1 = "=Auto!R[1]C[32]"
    Range("C2").Select...
  16. Re: VBA code find multi text and delete entire rows

    Thank you both for your help!
    Those amendments worked great and I'm learning along the way.
  17. Re: VBA code find multi text and delete entire rows

    Hello Peter_SSs or anyone else that could possibly help.
    I didn't want to start a new thread as I thought the above code could help me with my problem:

    I have a sheet with data in range...
  18. Replies
    6
    Views
    208

    Re: Date/Time Format

    Hi lrobbo, apologies for the late reply as I haven't had a chance to look at this until now. I haven't thoroughly tested yet it but it seems to work really well.
    Thanks again for your help, I...
  19. Replies
    6
    Views
    208

    Re: Date/Time Format

    lrobbo314, thank you for your help! That worked perfectly.

    Although I forgot to add one step to the calculation... In addition to changing the date/time format, I also need to amend the time to...
  20. Replies
    6
    Views
    208

    Date/Time Format

    Hello, I've searched but I can't find guidance on the specific date and time format issue I have.

    I have a spreadsheet with cells in range A2:A100 showing the following date and time format: Tue...
  21. Replies
    4
    Views
    256

    Re: Automate Process

    Thank you, will give that a try.
  22. Replies
    1
    Views
    138

    vba to copy, paste, run code, loop

    I started a previous post but I think I over-complicated it, so I will try again with (hopefully) a better explanation of what I'm trying to achieve:

    Sheet "Dates" contains dates from A2:A200 (the...
  23. Replies
    4
    Views
    256

    Re: Automate Process

    Thanks for responding. Copying between sheets is done with this code:


    Sheets("Pair").Select
    Range("A5").Select
    Range(Selection, Selection.End(xlDown)).Select
    Range(Selection,...
  24. Replies
    4
    Views
    256

    Automate Process

    Hi all, I’m looking for some help on automating a process in Excel. I can do simple vba but I’m out of my depth on this one. Here is the process I’m trying to automate:

    Sheet “Dates” has a...
  25. Re: Find last cell in column and divide by the last cell in aother column

    That's perfect, thanks again!
Results 1 to 25 of 141
Page 1 of 6 1 2 3 4