Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    1
    Views
    213

    Re: VBA , Problem with automatic formula

    I was not able to edit #1 but I think that the problem is that im running excel 2016 on my laptop , how can the above code be altered so that it works on excel 2016?
  2. Replies
    1
    Views
    213

    VBA , Problem with automatic formula

    Hi guys im currently on vacation and running my spreadsheet on a sub par laptop. On my workstation everything works great but after I started using it on win 7 32 bit on my laptop I have revived a...
  3. Re: was some sort of security update released last night ?

    Also did a test to check if the loop is working:




    posfrom = InStr(textline, "data-league-name")
    If posfrom = 0 Then MsgBox "Error"
  4. Re: was some sort of security update released last night ?

    well nothing is happening.

    I get no results from the text file but after reviewing it all of the data seems to be the same as it always have been.

    Edit:

    For some reason I'm not able to add...
  5. Re: was some sort of security update released last night ?

    Was hoping for an easy fix for this problem as Im no mood to rewrite all of this :/
  6. was some sort of security update released last night ?

    I have my script which has worked without any problem for about 1 year. Until today as far as I can tell no changes have been made to target website.

    I scarpe like this.

    1 download html doc as...
  7. Replies
    1
    Views
    198

    Re: Find location of shape

    You can use:



    ActiveSheet.Shapes(Application.Caller).TopLeftCell.Address(False, False)


    Cheers :)
  8. Replies
    1
    Views
    198

    Find location of shape

    Hi guys im trying to quickly find the row number of my shapes., they are added trough another macro.

    I had success with this code to find the location:



    For Each Shp In...
  9. Replies
    2
    Views
    108

    Re: Standard size for buttons

    There should be some standard, no ?
  10. Replies
    2
    Views
    108

    Standard size for buttons

    Hi im in the process of creating custom buttons for my userforms , but Im not sure what is considered standard size for buttons ?

    anyone have a good suggestion ?

    frederik
  11. Replies
    10
    Views
    278

    Re: A little trouble with shapes

    Was an "error" somewhere else in my code. Im working on a reset code of 2000 rows a lot to consider when writing the code. Anyways times for your swift resonses .. Have a great day :=)

    frederik
  12. Replies
    10
    Views
    278

    Re: A little trouble with shapes

    I figured it out. Was error somewhere else in the code...
  13. Replies
    10
    Views
    278

    Re: A little trouble with shapes

    there are 2000 shapes, think the name is generated random like "Picture 9"

    My latest attempt is this :



    For Each sh In ActiveSheet.Shapes
    On Error Resume Next
    If...
  14. Replies
    10
    Views
    278

    Re: A little trouble with shapes

    Ive tried a dozen attempts but not sure exactly how to write the code
  15. Replies
    10
    Views
    278

    Re: A little trouble with shapes

    My code Keeps all the icons exept the once mention in post # 1
  16. Replies
    10
    Views
    278

    Re: A little trouble with shapes

    Hi thanks for your reply.

    No I also have:
    Plus, Down Arrow, Flowchart: Multidocument in row 3
    as well as rounded rectangles in row 24
    and an icon I have called topico in last row + 1
    ...
  17. Replies
    10
    Views
    278

    A little trouble with shapes

    Im trying to remove most of my shapes from my sheet but a few of them Id like to keep They are in cell S21 and ab21

    the range of cells i want to delete are stored in range(a27:BS & last row")
    ...
  18. Replies
    14
    Views
    437

    Re: Remove this symbol "

    Ok rick. Ill remember that for future reference
  19. Replies
    14
    Views
    437

    Re: Remove this symbol "

    Thanks alot buddy. this was really starting to confuse me, Like empty space nothing is something here :)

    Glad to have it removed
  20. Replies
    14
    Views
    437

    Re: Remove this symbol "

    Here is a small sample that shows how it is stored in excel

    <a href=http://www.filedropper.com/strangebehavior><img src=http://www.filedropper.com/download_button.png width=127 height=145...
  21. Replies
    14
    Views
    437

    Re: Remove this symbol "

    this was a huge pain to remove :/

    Its not styled,, Its scraped from a web pages and it looks like multilinetext in one cell but in not able to split it with this code:



    sTitle =...
  22. Replies
    14
    Views
    437

    Re: Remove this symbol "

    It didnt seam to work , are you sure that is correct ? maybe there is something else wrong?

    edit tested and it works the other way around but for some reason it does not work on this string ?

    ...
  23. Replies
    14
    Views
    437

    Remove this symbol "

    Hi I have quick question. Ive run into a problem I dont know how to remove this symbol from a string "

    Ive tried this:


    sTitle = Replace(sTitle, """, "")



    Anyone know how I can replace...
  24. Replies
    2
    Views
    359

    Re: Userforms and memory issues

    Hi thanks for your response

    Maybe it could be the vars , but I dont have that many running only "dim as worksheet" and a few long vars
    Its only when I do extensive testing of my code I get "Out...
  25. Replies
    2
    Views
    359

    Userforms and memory issues

    Good morning. Ive been creating a couple of userforms and I notice that when I test all functions and changes I make I keep getting this error "out of memory" in my excel . I think the userforms are...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4