Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: Force a user to select the entire row from row number

    Can’t thank you enough Footoo
  2. Re: Force a user to select the entire row from row number

    Not working exactly it seems to be inserting an extra row (which isn’t formatted the cells are unmerged on the extra row)
    The other row inserted is OK


    Sub AddRows()
    Dim n As Variant, Ans As...
  3. Re: Force a user to select the entire row from row number

    Could somebody help please?
    I would like to change this part of the below code

    Selection.EntireRow.Copy
    Selection.Resize(n).EntireRow.Insert
    So it just copies and inserts the row with formats...
  4. Replies
    5
    Views
    92

    Re: Listing excel files in a folder

    Brilliant thanks for your help Fluff
  5. Replies
    5
    Views
    92

    Re: Listing excel files in a folder

    Thanks Fluff that works great
    Some of the excel files have links and I get a message "do I wish to update links"
    How can I open the files as read only and not update links
  6. Replies
    5
    Views
    92

    Listing excel files in a folder

    Can anybody help a bit I please, I am putting together some code to list the excel files in a folder in column B, open each one in turn copy a value from cell D142 and paste in column C next to the...
  7. Re: Code for deleting rows not working correctly

    vcoolio.
    That works great
    many thanks
  8. Re: Code for deleting rows not working correctly

    Thanks Misca
    How do I modify this code so it stops at range B4, as it is deleting rows above my list that I need
  9. Code for deleting rows not working correctly

    Hi I need a little help please
    I have put some code together to delete an entire row if a cell in a list starting from B4 and is a variable length.
    The code is sort of working but once it gets to a...
  10. Re: Force a user to select the entire row from row number

    Footoo
    Tried your suggestion works brilliantly, much neater
    Thank you


    Sub AddRows()
    Dim n As Variant, Ans As Variant

    If TypeName(Selection) <> "Range" Then
    MsgBox "Select a worksheet...
  11. Re: Force a user to select the entire row from row number

    Thanks Footo
    Will give it a go
  12. Re: Force a user to select the entire row from row number

    Footoo
    Just had a go with the code you wrote at post # 13, works absolutely brilliantly.
    Thank you
  13. Re: Force a user to select the entire row from row number

    Thanks for all your help Footo
    I have changed that line of code you suggested.
    I will look at the macro macro per post # 13 the reason I didn’t was I had gone down a root I was sort of comfortable...
  14. Re: Force a user to select the entire row from row number

    Footoo thanks for all your help I think I have got it now, posting code in case it helps somebody else out


    Sub AddRows()

    Dim n As Integer
    Dim Ans As Variant

    If...
  15. Re: Force a user to select the entire row from row number

    OK thanks Footoo, lost the plot a bit
    Is there any way I can include

    ' Ans = MsgBox("Have you selected the row where you want to ads the extra rows", vbYesNo)
    ' If Ans = vbYes...
  16. Re: Force a user to select the entire row from row number

    OK ran into a bit of an issue
    Is there any way I can include

    ' Ans = MsgBox("Have you selected the row where you want to ads the extra rows", vbYesNo)
    ' If Ans = vbYes Then
    I...
  17. Re: Force a user to select the entire row from row number

    Apologies Footoo
    Got it now
    Thanks for everything
  18. Re: Force a user to select the entire row from row number

    Thanks for all your assistance
    All working OK apart from I am not getting the msgbox "Insertion not allowed" up when I try to enter rows where I have Do not insert Rows in column O, although it is...
  19. Re: Force a user to select the entire row from row number

    Thanks footoo that works brilliantly
  20. Force a user to select the entire row from row number

    Can somebody help a bit please, I have cobbled together the below code to allow the user to insert extra rows. But I have a couple of problems.

    1. I need be able to force the user to select the...
  21. Replies
    9
    Views
    147

    Re: Sum a fixed range

    Appologies Alan
    What is the 1 for after the 2996 =SUM(OFFSET($F$1,4,0,2996,1))
    I have tried changing it to see what would happen and it diddn't seem to make any difference unless I change it to 0...
  22. Replies
    9
    Views
    147

    Re: Sum a fixed range

    So easy when you know
    Thanks for your time
    Gary
  23. Replies
    9
    Views
    147

    Re: Sum a fixed range

    That’s is brilliant thanks Alan
    Would you mind explaining what the formula is doing and how it works please
  24. Replies
    9
    Views
    147

    Sum a fixed range

    Hopefully somebody can help me out a bit here.
    I have a range I need to sum =SUM(F5:F3000)
    But I need to allow the users to be able to delete rows within this range once they are completed, this...
  25. Replies
    12
    Views
    252

    Re: Using a Named table in Data Validation

    Aladin
    Apologies for not getting back to you, something came up.
    I have created the lists as named ranges, then I converted them to tables. They are now shown as both in the “Name Manager”. They...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4