Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    6
    Views
    319

    Re: vba - find non-matching value

    I was hoping that there would be a simple operator you'd insert to specify that it's a non-match you're looking for, like using "<>"& in COUNTIF formulae, for example. Maybe not though.

    It looks...
  2. Replies
    6
    Views
    319

    vba - find non-matching value

    Hi,

    I want to be able to find a non-matching value in VBA.

    So, for example, this code finds the column of the first cell containing a number 1:



    Sheet4.Range("D4:N4").find(1,...
  3. vba - search right to left for first non-matching value

    Hi there,

    What I'm trying to achieve seems pretty simple, just can't figure out the syntax.

    On a single row, I enter blocks of numbers which represent sessions, in increments of 15 mins per...
  4. Replies
    3
    Views
    607

    Re: VBA - Dir function not working

    I've managed to find a workaround: trying to open the target file and close without saving, and if the file can't be found in order to open, you can deal with that in the error handler to return the...
  5. Re: Select a specific cell after code pasted

    No prob :)
  6. Replies
    3
    Views
    607

    Re: VBA - Dir function not working

    The filepath stored from the last time the links were successfully established. Currently that is:

    C:\Users\mrperson\Desktop\WLP system v2.4 (Sharepoint ready)\WLP\Template WLP 18-19.xlsm
    ...
  7. Re: Select a specific cell after code pasted

    Hi,

    As far as I'm aware you need to activate the sheet first - so you can't have Sheet1 active then select a cell in a different sheet. But if you activate the sheet/select the cell in turn in the...
  8. Replies
    3
    Views
    607

    VBA - Dir function not working

    Hi there,

    This is driving me nuts! In my current workbook I have a number of references to another workbook. In the Auto_Open sub, I want to check that the filepath for that external doc is still...
  9. Retrieve date range from Pivot Timeline

    Hi there,

    I'm working on my very first pivot table :) I'm not sure this is possible but it seems like it should be:
    My pivot table counts the number of hours taken for different types of special...
  10. Re: Formula - return bottom non-blank value in a range

    Aha, and computers think they're so smart :)

    I think I got most of that, apart from the bit about cutting the ranges in half :)


    Thanks again
  11. Re: Copy Row of Data from one sheet to another sheet based on a Drop Down Value

    Hi there,

    You'll probably want to use VBA. If you're not sure how to set up a macro let me know and I can walk through it.

    This should do what you need, assuming that the month names in your...
  12. Re: Formula - return bottom non-blank value in a range

    Perfect, thanks very much :)

    How does that even work, just out of curiosity?
  13. Formula - return bottom non-blank value in a range

    Hi there,

    I have a column which holds a running total of hours taken. So, for example, the user enters a number of hours in cell L50, then the formula below, which sits in N50, deducts that number...
  14. Re: Macro "add in" to move line back to original worksheet based on changed value

    Sorry for the delay, I've been away - did you get this working?

    If not, the best thing to try might be to run it line by line in break mode and see if you can identify the point(s) at which it's...
  15. Re: Grouping Worksheets under Week Commencing Sheet

    There's no way to have multiple sheets contained within a single sheet, if that's what you mean, but there are ways to group ranges of cells within a sheet so that you can switch between them easily....
  16. Replies
    6
    Views
    434

    Re: VBA - release workbook object?

    No prob, I'll stick with what I've got until and if it breaks again :) Thanks again
  17. Replies
    6
    Views
    434

    Re: VBA - release workbook object?

    How would I include that in the replace? Would it not just 6 and two 3s, or is there a reason it's a better way to go?
  18. Replies
    6
    Views
    434

    Re: VBA - release workbook object?

    Well-spotted :) I've activated Sheet2 explicitly and it does now get past that line. It was still behaving oddly so I've just spent about an hour trying to figure out why. Turns out I had On error...
  19. Replies
    6
    Views
    434

    VBA - release workbook object?

    Hi there,

    The code segment below is part of a larger sub which creates a copy of a template workbook and renames it under a staff name. The only way I've found to make it work on Sharepoint is by...
  20. Re: VBA to copy cell value only into a range

    Something like this, maybe? When it's run, this will check to see if there's a value in C8 - if there is, it's copied to Z8, else Z8 is left blank.



    If Range("C8").Value <> "" then
    ...
  21. Re: Macro "add in" to move line back to original worksheet based on changed value

    Lol no prob :)

    Sorry yep, that offset should have been 24

    Try replacing your code with this instead:
  22. Re: Macro "add in" to move line back to original worksheet based on changed value

    No prob, don't thank me until it works though :)

    That's odd - just want to make sure first, is the text Dormant being dropped into the right cell? ie. just to the right of a closed case?

    If...
  23. Re: Macro "add in" to move line back to original worksheet based on changed value

    You could add a line to your original code that marks the source worksheet when it's moved to the Closed sheet. Something like this:



    Sub LoopThroughSheets()
    Application.ScreenUpdating = False...
  24. VBA - copy an existing worksheet in Sharepoint to the same location

    Hi everyone,

    I'm looking for a way to copy an existing file in Sharepoint to the same SP location.

    I know you can use the ThisWorkbook.SaveAs method to do it from within the file itself, but I...
  25. Re: Macro "add in" to move line back to original worksheet based on changed value

    It shouldn't be too difficult to reverse the code, but you'd need a way to specify which sheet you want to return the re-opened case to. Is there a column in your data that holds info specific to...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4