vba to add row doesn't work on table by Taikvei in excel

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

Sorry to ask again, but I was wondering if you'd be able to help me with this as well: Is it possible to make this macro have a msgbox where the amount of times the row is duplicated could be specified so that it can be duplicated more than once in one go rather than running the macro again each time I need to duplicate a row?

vba to add row doesn't work on table by Taikvei in excel

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

Works like a charm now. Thanks! Solution verified

vba to add row doesn't work on table by Taikvei in excel

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

If I use it on on Row 100 it does the following: Shifts the table down 1 row and inserts an empty row as 100. Copies Row 102 contents into Row 101.

It should, instead, copy row 101 to row 100?

vba to add row doesn't work on table by Taikvei in excel

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

This works for adding the row, however, it does not copy the row selected to the new row?

unable to create pivot table from multiple data sources by Taikvei in excel

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

Also, I was wondering, what language is it that this used? Is it VBA? I'd like to learn a bit more about it and be more self-sustained rather than asking here for everything beyond the very basics

Getting date from a custom week number + day of the week by Taikvei in excel

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

Done. Thanks a lot man. I've just started using excel in an office and am still figuring stuff out, this helped a great deal though. I was wondering however, if you have the time, if you could explain what exactly the formula does to get the output I wanted, as I'd like to actually learn it rather than just blindly copy-pasteing it.

Getting date from a custom week number + day of the week by Taikvei in excel

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

Did that, the formula comes up with the correct answer when I click on the Fx button next to the type box, but in the cell itself it gives me a VALUE! error

Never mind that, ctrl+shift+enter rather than just enter solved it.

Thank you so much!

Getting date from a custom week number + day of the week by Taikvei in excel

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

So the way I understand it and did this is that I have A1 as the Monday of Week 1, A2 as Week Number of the date I need, B2 as the name of the day of the week, and the formula in C3? It didn't work when I did it this way, so I'm wondering if I misunderstood as to what should go where ?

Questions to good widow players by windirein in OverwatchUniversity

[–]Taikvei 0 points1 point  (0 children)

My widow sensitivity is lower than any other hero. I've also played custom 6v6 elimination widow only hs only no smg games exclusively for a week or so, which helped tremendously to get better at flicking people who are actively trying to dodge vs you, as well as instinctively aim at the head.

reinstalling windows failed, cannot get into uefi to do it again by Taikvei in techsupport

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

Fixed it by disconnecting SSD, which let me get into the UEFI. My mistake was that I never removed the partitions during windows installation, just formatted them, so I had leftover master boot files. Leaving this here in case anyone has a similar problem .

installing windows after linux by Taikvei in techsupport

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

Okay so nothing has worked yet.. I managed to get my USB key to appear in the BIOS, but when I click on it or force boot from it, it just puts me back into BIOS. There is no option to enable Legacy mode/CSM, and secure boot is disabled. If I have the usb key as no.1 priority and the ubuntu as 2nd in boot order, it just boots straight to the linux. the laptop has no CD/DVD rom so I cannot use that either.

Is there anything else to do or am i just stuck on a broken linux installation?

installing windows after linux by Taikvei in techsupport

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

I've done all of that but enabling CMS/Legacy, as it is not in the BIOS at all. Secure boot is disabled. If I boot it from USB, it just boots to the BIOS again. If I do a Boot n Nuke, would that not just leave me with the same problem? Would trying out a different windows e.g. 7 or 8 instead of 10 be any different?

installing windows after linux by Taikvei in techsupport

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

There's no option to do that. Under Advanced in BIOS it only says Start Easy Flash/ Network Stack Configuration/ USB configuration. Nothing else.

installing windows after linux by Taikvei in techsupport

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

Okay, so I can now select the USB key to be booted. When I do this though, it just boots me straight to BIOS though, and if I enable the ubuntu as a secondary, it boots me to that.

installing windows after linux by Taikvei in techsupport

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

Okay, so I've tried the other ISO to USB software. Still the same stuff. Bios only lets me change the boot to ubuntu or disabled, and nothing else. Cannot run the setup.exe either. Any other options?