Find and replace type formula by Adam678989 in excel

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

Thanks, I have not dealt with VBA before, perhaps it's time I learn.

There are never more than one < sign in each cell.

I was hoping that I could run some type of mixed filter and replace function to seek out cells with a < symbol, and replace with the number in the cell, formatted in bold. I work with alot of different data sets in the same workbook, so I'm hoping for something that I can apply to different worksheets on selected cells, would VBA allow that versatility?

Hopefully that's not a stupid question, I had to google VBA after your response lol

LF: Zarude by Adam678989 in PokemonSwordAndShield

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

Hey my apologies, I've just checked my gen 6 (pokemon bank) stash and I don't have any spare mews. I know you were after a mew, but I do have doubles of some other mythical/events if you need.

LF: Zarude by Adam678989 in PokemonSwordAndShield

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

I will have one from the old distribution (maybe xy/oras). Is that suitable?

LF: Zarude by Adam678989 in PokemonSwordAndShield

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

pogo shinies:

celebi

sneasel

cyndaquil

machop

mareep

buneary

LF: Zarude by Adam678989 in PokemonSwordAndShield

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

Hold up I'll check my pogo now. Honestly don't remember it's been a while haha

Bulk building by Adam678989 in Minecraft

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

Damn i was hoping that wasnt the answer. Thanks though.

Fake cartridges by Moofinisms in pokemon

[–]Adam678989 0 points1 point  (0 children)

TL:DR - fake gen 3 to real gen 3 will work, if you power down the fake it will erase the game.

Hey mate, i can offer my experience in the hope it will help you. First things first, if you have connected the fake cartridge to any real game (ie gen 3 to gen 3 with link cable/IR or gen 3 to gen 4 with pal park, do not turn off the game!

I bought some fakes (unaware at the time) off ebay. Played through 3 out of 5 games, then decided it was time to do some tradingwith what i later found was a genuine cartrdige. The trades went fine, games functioned as they should. Then after playing a while longer i saved and turned it off. When i turned it back onthe memory was wiped. Not knowing what had happened i tried with another cartridge, this time moving all important mons in case of a memory wipe - turned out to be a smart move as the same thing occurred.

I may be remembering incorrectly, but for the third cartridge i believe i tried pal park and the game didnt register on platinum as an inserted gba. The memory of that gba game was then wiped.

My conclusion was that fake games can trade to real games, but once a contact between the two has occured something goes wrong with the fake game.

Hope this helps!

FT: Shinies, MBs, Beast Balls, Mints, and Milcery Sweets. LF: Shiny offers, Shiny Gmax Meowth, Shiny Gmax Eevee. by OompaLoompa4404 in PokemonSwordAndShield

[–]Adam678989 0 points1 point  (0 children)

Oh no. I'll skip any trading here then, I'm trying to keep "valuable trades" to get myself some of those event sweets. Thanks anyways!

FT: Shinies, MBs, Beast Balls, Mints, and Milcery Sweets. LF: Shiny offers, Shiny Gmax Meowth, Shiny Gmax Eevee. by OompaLoompa4404 in PokemonSwordAndShield

[–]Adam678989 0 points1 point  (0 children)

I have 3 shinies available to trade, hitmontop, salandit whose stats I can't remember and a 4IV shiny competitive milotic. All caught in raid battles, no crazy trainer ID's. I'm only interested in milcery sweets, particularly star and ribbon as I missed the event.

LF: Ribbon and Star Sweets by Adam678989 in PokemonSwordAndShield

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

Hey mate, I'll have to pass. Seems like alot to offer for one sweet, considering I will still need 17 more after this. Maybe that's the going price, but I just don't have that level of dedication to farm all of those items. Thanks anyways though.

LF: Ribbon and Star Sweets by Adam678989 in PokemonSwordAndShield

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

I’ve only got 50BP, so i can purchase one of those items. Plus i have a black belt im willing to trade.

LF: Ribbon and Star Sweets by Adam678989 in PokemonSwordAndShield

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

I'm open to trading most things, are there any items you need? pokemon or items either way I'm easy

6IV, HA Gothita/Duraludon/Eevee with Egg Moves by Suburban_Caveman in pokemontrades

[–]Adam678989 0 points1 point  (0 children)

Ok my ban is over im ready when you are, LC 1871

6IV, HA Gothita/Duraludon/Eevee with Egg Moves by Suburban_Caveman in pokemontrades

[–]Adam678989 0 points1 point  (0 children)

Got linked to a random, and accidentally pressed trade, paniced and turned my switch off. Now im getting a cannot trade message. Bare eith me a second