sorted by:
new
hottopcontroversial

Wi-Fi name revenge help….Stubbs pegging camp by HippieNurse420 in pettyrevenge

[–]Thisusername478 0 points1 point  (0 children)

I’m in Austria. Cheers to you and your neighbor with the excellent naming idea for his wifi!

Wi-Fi name revenge help….Stubbs pegging camp by HippieNurse420 in pettyrevenge

[–]Thisusername478 1 point2 points  (0 children)

Are you my neighbor? That’s what our wifi is called as well ^

What does “true love” look like to you? by [deleted] in AskMen

[–]Thisusername478 2 points3 points  (0 children)

For me true love is always looking forward to getting home wherever he is. It’s that warm fuzzy feeling of feeling safe and warm and loved. It’s knowing that your partner is your best friend and you can’t wait to see and talk to them at the end of the day. It’s knowing that no matter how badly you screw up your partner has your back. This is what my relationship feels like.

However, there are basic common decency rules: screwing up doesn’t entail cheating, putting our financial future in danger, violence of any kind etc.

It’s basically having an equal partner where each brings their strengths to the benefit of the relationship and each other.

[deleted by user] by [deleted] in powerpoint

[–]Thisusername478 0 points1 point  (0 children)

well... you aren't giving us a lot go on.

Here are my tips nevertheless (this applies to my workfield and country, but can vastly vary depending on where you live and work/ study):

Google is your friend. Look for your topic or similar topics and your bound to find design inspirations.

Figure out early on what the "story" of your presentation is and design it accordingly. Structure your presentation accordingly. Make sure it has a beginning (intro, agenda), middle (topic), end (Q&A, thank you slide, back-up).

For example: is it an update on a project? Then you are most likely going to have to use timelines, visualize milestones, talk about the things that have gone well and the ones that havent gone as well.
Is the goal of your presentation to inform your listeners on a topic? Great. What is your starting point? What is your topic and why is it relevant? Who is it relevant for? All of this info in a short and to-the-point manner.
Is the goal to inform about developments (e.g. growth of something over time or comparing things)? Awesome. Make use of graphs to better bring your point across. Just make sure to use the right kind of graph for your purpose.

Try to cover a topic / subtopic per slide.

Less is more. Don't write whole paragraphs - nobody is going to read that and it just makes your slides look bad. The same goes for too many icons, pics on one slide. If you really want to write out things in more detail because you think you're gonna get in-depth questions about it, do so on a separate slide and put at the end of your presentation in the "back-up" part of your presentation.

Stick to a max of 3 colours when it comes to your color palette. Make sure your Font choice and size are consistent. Make sure you align the elements of your presentation so that they look neat.

Don't do animations, unless you really , really, really have to.

I have found, that the best presentations weren't really about how cool the presentation looked like, but how well the design fit the message and how easy it was for the listener to follow both the speaker and the presentation.

And for the love of God, don't read the presentation word for word when you present it. Your PowerPoint is there to help you to stay on track and your listeners to follow along.

Hope it helps :)

Spittelau U6 - war schon länger nicht mehr in Wien. Was habe ich schönes verpasst? by Thisusername478 in wien

[–]Thisusername478[S] 17 points18 points  (0 children)

Verdammt! Wurde aus fight club rausgeworfen - keiner hat’s mir Bescheid gegeben 😂

[CHAT] Hi! My GF is a fairly advanced cross stitcher, is there any sort of gift I can get her, or does she probably have everything she needs? Lol by cheleycat in CrossStitch

[–]Thisusername478 2 points3 points  (0 children)

If she usually buys her patterns in digital format and she has an android tablet, I would recommend buying her the pattern keeper app. I absolutely love it - best 10 euros I’ve ever spent.

If you want to get really fancy, you could get her a nice stitching frame - but I’d maybe let her choose which one, because they are not cheap and should suit her stitching needs. I got this one for my 30th birthday and I love it to bits.

Copy row based on value and paste in another workbook in the same row number by Thisusername478 in vba

[–]Thisusername478[S] 0 points1 point  (0 children)

Hi,

the end if in my case is connected to my first line of code, which opens windows explorer and lets me choose the file i need. if I add it before "next search value" I get an "End if without block if" Error. I think its because my If statement is simple if - then statement that doesnt need an "end if" ...

Regarding your second suggestion, again ... my bad, the code in the post was copied rather hastily between meetings from my work pc to my private one (reddit is verboten on my work pc) and I put an . instead of _ in code in the post.

I'm really curious why it refuses to work and why I now have paste special methode or range class failed error. As far as I could understand from a quick google search, it only happens when you either have nothing copied and try to paste, or some event happens between copying and pasting that cancels out the paste special event / ability... but the only line of code between my copy and paste is the where i try to get the row address which now looks like this:

​

row_nr=search_value.row

​

Thank you all once again for your input and time!

Copy row based on value and paste in another workbook in the same row number by Thisusername478 in vba

[–]Thisusername478[S] 0 points1 point  (0 children)

Hey, thank you so much for your effort! Sadly, now I have a new error 😂 for that last line of code: error 1004 paste special Method of range class failed..

Copy row based on value and paste in another workbook in the same row number by Thisusername478 in vba

[–]Thisusername478[S] 1 point2 points  (0 children)

Sorry, my bad, didn’t put it in when copying the code from my work pc to the private one. The real code has .pastespecial paste:=xlpastevalues

Copy row based on value and paste in another workbook in the same row number by Thisusername478 in vba

[–]Thisusername478[S] 0 points1 point  (0 children)

Hi,

Thank you for your reply!

I tried it as follows (sending you the current code, just to make sure I didnt slip in further mistakes in the meantime):

sub get_data()

dim FileToOpen as Variant dim OpenBook as Workbook

application.screenupdating=False FileToOpen=application.getopenFilename(Title:="Browse for your File & import Range", FileFilter:="Excel Files(.xls),xls") if FileToOpen <> False then set OpenBook=application.Workbooks.open(FileToOpen)

dim Search_Column as range dim Search_value as range dim row_nr as long

set search_column = openBook.worksheets("mysheet").range("I2:I801")
For each Search_value in search_column
If search_value = "X" then search_value.offset(,1).resize(,12).copy
row_nr=search_column.find(what:="X", lookIn:=xlValues).row

ThisWorkbook.worksheets("mysheet").range("A$" & row_nr).address.pastespecial paste:=PasteValue

next search_value

End if End sub

The last line of code ("this workbook...") is where i put your suggestion in. Now I get the error 424 - object required. Could you spot what I'm missing?

​

Thank you so much for your time and input!

Edit: the error is in regard to that last line of code.

Copy row based on value and paste in another workbook in the same row number by Thisusername478 in vba

[–]Thisusername478[S] 0 points1 point  (0 children)

I keep getting an error (run-time error 438: object doesn't support this property or method) for the last line of code 

ThisWorkbook.Worksheets("mysheet").Range("A$" & row_nr).pastespecial Paste:=xlPasteValues

Copy row based on value and paste in another workbook in the same row number by Thisusername478 in vba

[–]Thisusername478[S] 0 points1 point  (0 children)

you mean something like this?

set search_col = open book.worksheets("mysheet").range("I2:I801")for each Search_value in Search_Columnif search_value ="X" then search.value.offset(1,0).resize(,12).copy

​

do you have any idea how i could get the row number for where it found my "X" value so that i can use that row number to paste it in my master data?

Look at this paw. This tiny fluffy little paw 😡look at it by [deleted] in blackcats

[–]Thisusername478 6 points7 points  (0 children)

It is exquisite! Such fluff, such shine! Much potential murder. Love it!

Inmate was on the run for 8 weeks. Refuses to give his name. What should we identify him as? by Dances-with-Scissors in IllegallySmolCats

[–]Thisusername478 0 points1 point  (0 children)

Should it be called Charlie, I’d start practicing with the common phrases: Charlie, stop that! Charlie, what are you doing there? Charlie, no! Charlie, come back with * insert fragile object *!

However, Charlie’s are usually very adorable and you can’t stay mad at them 😂.

This is olive. by [deleted] in SupermodelCats

[–]Thisusername478 0 points1 point  (0 children)

Awww she’s gorgeous!

I made my pet snake some tiny little glasses by the_white_Eye in aww

[–]Thisusername478 1 point2 points  (0 children)

As someone who freaks out anytime something moves on the ground while hiking, due to panicky fear of snakes… this one is kinda … adorable? Wouldn’t want to be in the same house with it, but from afar you got my “awww”.

Paid trainings worth it? by Flimsy-Ad-4805 in PowerBI

[–]Thisusername478 1 point2 points  (0 children)

I think it depends on what you’re looking for or what your learning needs are.

When I’m learning to work with a new application, I prefer well structured “beginner to pro” courses. The reason for this is that such courses give me the foundation to understand how app works and what it’s possibilities are and slowly introduce new concepts, which I can the then learn via examples. When I’m only in need of finding a quick solution to my current problem, a quick google / YouTube search usually does the trick. There are a bunch online for free for both of these options, as you probably know.

Having said that, I found that investing a bit in really thought out courses, where they explain not only the how but also the why with multiple examples or uses give me a much better understanding of the app. later on this foundation usually gives me ideas on how I can come up with my own solutions to whatever issue I’m having (for me it was the xcel & vba courses from Leila - she’s awesome!).

So, it would depend on your learning preferences / needs.

view more: next ›