?

I want to create a button in Excel with a macro that allows me to add 5 to another number.

So for example, I could click any cell with a value in it, then click the button and 5 would be added to the value in the cell. I've tried various formulas and paste special with no success, so how can I do it?

This is my DW UU team on PO, any suggestions will be great. I peaked at 14 with it.

Crustle w/Custap Berry

Sturdy, Impish

252HP/4Atk/252Def

Stealth Rock

Spikes

Toxic

Stone Edge

Cresselia w/Leftovers

Levitate, Bold

252HP/252Def/4SpAtk

Calm Mind

Moonlight

Psyshock

Ice Beam

Feraligatr w/Life Orb

Sheer Force, Jolly

4HP/252Atk/252Spe

Dragon Dance

Waterfall

Crunch

Ice Punch

Lilligant w/Lum Berry

Own Tempo, Timid

4HP/252SpAtk/252Spe

Hidden Power Fire

Petal Dance

Quiver Dance

Sleep Powder

Yanmega w/Focus Sash

Speed Boost, Modest

4HP/252SpAtk/252Spe

Protect

Hidden Power Ice

Air Slash

Bug Buzz

Golurk w/Leftovers

No Guard, Adamant

8HP/252Atk/248Spe

Rock Polish

Dynamic Punch

Shadow Punch

Earthquake

I feel I need a wall to switch in on big hits, but with Eviolite Chansey banned from UU, Dusclops may be my only option, but idk what to take out.

Does anyone know of any RPGs with little or no random encounters, similar to FF? I don't particularly hate scores and scores or random encounters, but they do get a little boring after a while.

I'm breeding a Mienshao to use in the VGCs- what do you think?:

HP: 18

Atk: 31

Def: 22

SpAtk: 10

SpDef: 14

Spe: 30

Rebreed or not?

Mienshao w/Focus Sash

Nature: Jolly

Ability: Inner Focus

4HP/252Atk/252Spe

Fake Out

Hi Jump Kick

U-Turn

Stone Edge

Tornadus w/Damp Rock

Nature: Timid

Ability: Prankster

64HP/252SpAtk/188Spe

Rain Dance

Hurricane

Psychic

Taunt

Hydreigon w/White Herb

Nature: Modest

Ability: Levitate

4HP/252SpAtk/252Spe

Draco Meteor

Surf

Earth Power

Dragon Pulse

Jellicent w/Water Gem

Nature: Modest

Ability: Water Absorb

252HP/252SpAtk/4SpDef

Water Spout

Ice Beam

Surf

Shadow Ball

I've been testing it on Pokemon Online, and its done surprisingly well (1 loss in 10 battles), so I want some advice on what to improve before I build for reals on my actual Pokemon Black. I put it up yesterday, but didn't really get any useful suggestions.

Mienshao w/Focus Sash

Nature: Jolly

Ability: Inner Focus

4HP/252Atk/252Spe

Fake Out

Hi Jump Kick

U-Turn

Stone Edge

Tornadus w/Damp Rock

Nature: Timid

Ability: Prankster

64HP/252SpAtk/188Spe

Rain Dance

Hurricane

Psychic

Taunt

Hydreigon w/White Herb

Nature: Modest

Ability: Levitate

4HP/252SpAtk/252Spe

Draco Meteor

Surf

Earth Power

Dragon Pulse

Jellicent w/Water Gem

Nature: Modest

Ability: Water Absorb

252HP/252SpAtk/4SpDef

Water Spout

Ice Beam

Surf

Shadow Ball

I've been testing it on Pokemon Online, and its done surprisingly well (1 loss in 10 battles), so I want some advice on what to improve before I build for reals on my actual Pokemon Black.

This is my Gen IV team that I have tested on PO with some success, and am currently in the process of building for real. I've been tweeking it recently, replacing Breloom and Bronzong with Jirachi and Tangrowth Any recommendations would be great.

Blastoise (M) @ Lum Berry

Trait: Torrent

EVs: 144 HP / 252 SAtk / 112 Spd

Modest Nature (+SAtk, -Atk)

- Aqua Jet

- Ice Beam

- Hydro Pump

- Rapid Spin

An awesome, underated anti-lead. 2HKO's Machamp with Hydro Pump (Lum cures confusion from Dynamic Punch and H Pump never misses thanks to Champ's No Guard). It also 2HKO's Swampert and bulky Azelf leads, as well as Sash Azelf, Sash Infernape and Sash Aerodactyl. It also deals with Gliscor leads, but fails to deal with stuff like Empoleon, and draws in Suicune, Starmie, Vaporeon and Rotom-W switch ins. Nevertheless, it can make a great late game Breloom counter if the Lum is still in tact (switching in on spore, then outspeeding and OHKOing with Ice Beam)

Tangrowth (M) @ Leftovers

Trait: Chlorophyll

EVs: 252 HP / 236 Def / 20 SAtk

Relaxed Nature (+Def, -Spd)

- Leaf Storm

- Earthquake

- Hidden Power [Ice]

- Sleep Powder

A respectable physical wall. It can cause switchs on physical attackers, and put the switch in to sleep. Its also another Pokemon that people in standard don't expect to see.

Jirachi @ Choice Scarf

Trait: Serene Grace

EVs: 4 HP / 252 Atk / 252 Spd

Adamant Nature (+Atk, -SAtk)

- Iron Head

- Trick

- Ice Punch

- Fire Punch

A great physical sweeper. Iron Head Flinch Hax is beyond annoying and Trick is there to ruin Pokemon like Blissey or Bronzong.

Gengar (M) @ Focus Sash

Trait: Levitate

EVs: 4 HP / 252 SAtk / 252 Spd

Timid Nature (+Spd, -Atk)

- Destiny Bond

- Shadow Ball

- Thunderbolt

- Focus Blast

Gengar is an awesome special sweeper with great coverage. Destiny Bond isn't that commonly seen on Gengars, but once my sash activates, any skilled trainer will know instantly what I'm up to.

Heatran (M) @ Life Orb

Trait: Flash Fire

EVs: 4 HP / 252 SAtk / 252 Spd

Naive Nature (+Spd, -SDef)

- Hidden Power [Electric]

- Earth Power

- Fire Blast

- Explosion

You may be wondering why HP electric over HP Grass? Well, it always catches out Gyarados. They switch in, expecting me to be helpless against it. They antcipate the switch out and use Dragon Dance, and then I OHKO with HP Electric. Downside- I am helpless against Swampert.

Flygon (M) @ Choice Scarf

Trait: Levitate

EVs: 4 HP / 252 Atk / 252 Spd

Jolly Nature (+Spd, -SAtk)

- Outrage

- Stone Edge

- Earthquake

- U-turn

I'm considering replacing Flygon. Its a great physical attacker and scout, and has served me well since Chomp and Mence were banned, but I'm not too sure about having two choiced Pokemon on the same team...

Rain Dance Team (OU)

I've made some changes to my last team based on the suggestions I recieved. No changes please (unless they're really important), as I've already started breeding (and in Zapdos's case) Ev Training them.

Zapdos w/Damp Rock, Calm nature, 248 HP / 228 SpD / 32 Spe

Thunder, Rain Dance, U-Turn, Roost

Ludicolo w/Life Orb, Modest, 32 HP / 252 SpA / 224 Spe (Swift Swim)

Surf, Ice Beam, Energy Ball, Rain Dance

Kabutops w/Leftovers, Jolly, 4 HP / 252 Atk / 252 Spe

Waterfall, Stone Edge, Swords Dance, Aqua Jet (I prefer priority to the extra coverage and power offered by X-Scissor)

Hariyama w/Flame Orb, Adamant, 252 Atk / 92 Def / 164 SpD

Close Combat, Fake Out, Rain Dance, Stone Edge

Skarmory w/Leftovers, Impish, 252 HP / 240 Def / 16 SpD

Steal Rock, Whirlwind, Roost, Brave Bird (This is the only Pokemon I'm willing to change as I haven't made any provisions to breed it yet)

Tentacruel w/Leftovers, Calm, 252 HP / 120 Def / 136 SpD

Toxic Spikes, Rapid Spin, Surf, Sludge Bomb

I have managed to create a Rain Dance Team without Kingdra, so whatcha think (OU tier)

Zapdos w/Damp Rock, Calm nature, 248 HP / 228 SpD / 32 Spe

Thunder, Rain Dance, U-Turn, Roost

Ludicolo w/Life Orb, Modest, 32 HP / 252 SpA / 224 Spe (Swift Swim)

Surf, Ice Beam, Energy Ball, Rain Dance

Kabutops w/Leftovers, Jolly, 4 HP / 252 Atk / 252 Spe

Waterfall, Stone Edge, Stealth Rock, Aqua Jet or X-Scissor (which one?)

Hariyama w/Flame Orb, Adamant, 252 Atk / 92 Def / 164 SpD

Close Combat, Fake Out, Rain Dance, Ice Punch or Stone Edge (which one?)

Vaporeon w/Leftovers, Bold, 188 HP / 252 Def / 68 SpD

Surf, Ice Beam, Wish, Protect

Tentacruel w/Leftovers, Calm, 252 HP / 120 Def / 136 SpD

Toxic Spikes, Rapid Spin, Surf, Sludge Bomb

I'm not sure if Vaporeon fits it on this set, what do you think?

Who would you say is better as a suicide lead? Azelf or Aerodactyl. Both can SR and Taunt, but Azelf has the edge with Explosion.

UU

Weezing: Pain Split, Fire Blast, Thunderbolt, Will o Wisp

Bold, Leftovers, 252HP/252Def/4SpA

Feraligatr: Waterfall, Return, Swords Dance, Aqua Jet

Adamant, Life Orb, 148HP/252Atk/108Spe

Donphan: Earthquake, Stealth Rock, Rapid Spin, Assurance

Adamant, Life Orb, 252HP/252Atk/4Def

Hariyama: Bullet Punch, Fake Out, Close Combat, Payback

Adamant, Flame Orb, 252Atk/212 Def/44Spe

Houndoom: Nasty Plot, Dark Pulse, HP Grass/Electric, Fire Blast

Timid, Passho Berry, 252SpA/4Spd/252Spe

Venusaur: Sleep Powder, Leech Seed, Energy Ball, Sludge Bomb

Calm, Leftovers, 252HP/4SpA/252SpD

I've redone this question to appease someone who seemed to think the last question was too hard to read;

Its UU, btw

Name:Uxie

Ability: Pressure

Item: Leftovers

Nature: Bold

EVs: 252 HP/252Def/4SpD

Moves:

U-Turn

Psychic

Stealth Rock

Yawn/Thunder Wave

Name:Heracross

Ability: Guts

Item: Choice Scarf

Nature: Adamant

EVs: 4HP/252Atk/252Spe

Moves:

Close Combat

Megahorn

Night Slash

Stone Edge

Name: Weezing

Ability: Levitate

Item: Leftovers

Nature: Bold

EVs:252HP/252Def/4SpA

Moves:

Thunderbolt

Pain Split

Will-o-Wisp

Fire Blast

Name: Mismagius

Ability: Levitate

Item: Leftovers

Nature: Timid

EVs: 4HP/252SpA/252Spe

Moves:

Nasty Plot

Shadow Ball

Thunderbolt

Sub

Name:Mantine

Ability: Water Absorb

Item: Leftovers

Nature: Calm

EVs:252 HP/4SpA/216SpD

Moves:

Surf

Signal Beam

Rest

Sleep Talk

Name: Blaziken

Ability: Blaze

Item: Life Orb

Nature: Rash

EVs: 4Atk/252SpA/252Spe

Moves:

Fire Blast

HP Grass

Stone Edge

Superpower

So, what do you think?

Should I SR or not?

HP: 28

Atk: 6

Def: 25

SpA: 22

SpDef: 31

Spe: 27

As a UU Special Sweeper:

Moltres with HP Grass, Fire Blast, Air Slash and Roost/Sub (252 in speed and Spa, 4 dumped in HP)

or:

Mismagius with Thunderbolt, Shadow Ball, Sub, Nasty Plot (same as above)

Stealth Rock weakness isn't a big factor for me, so what do you think?

Totodile (Adamant)

HP: 30

Atk: 30

Def: 16

SpA: 2

Spd: 24

Spe: 28

I've spent ages rebreeding this guy. Will he do or should I try for one with better defences/speed.

I'm breeding for a Totodile that I'm gonna raise into a Feraligatr (A Dragon Dance set, most likely)

Totodile (Adamant)

HP: 30

Atk: 30

Def: 18

SpA: 9

SpD: 20

Spe: 22

Should I rebreed for better defences and speed, or will these do.

Ok, I gonna use Weezing as a Physical Wall (UU) and I'm thinking about going for something like this:

252 HP/252Def/4SpA

Bold, Leftovers

Will-o-Wisp

Flamethrower

Pain Split (for recovery)

One other move

So I was wondering what the fourth move should be? Also, should I invest some Evs into SpDef, or leave it as it is? Thanks

For Battle Tower. I've actually made the team now, what do you think? I'm open to changes, but nothing like Nature or Ev changes. Any other Pokemon suggestions are fine.

Manectric w/Choice Scarf, Static, Timid

252SpA/4SpD/252Spe

Thunderbolt

Thunder Wave

Flamethrower

Switcheroo

I wanted to use a Trick lead different to the norm of Uxie and co. Hes a tad fragile so this may be a problem. In the early stages of the Tower, I'll use him as a Choice Special Sweeper, but as stuff gets much much much harder, I'll use him to Trick off the Scarf

Vaporeon w/Leftovers, Water Absorb, Bold

188HP/252Def/68SpD

Surf

Ice Beam

Wish

Protect

Same old Wish Support Vaporeon. Dependable, solid and annoying to play against. Wish/Protect is one of the best combos ever.

Metagross w/Life Orb, Clear Body, Jolly

60HP/252Atk/196Spe

Agility

Earthquake

Meteor Mash

Ice Punch/Fire Punch

Agiligross. One Agility and this thing can outspeed a lot of things in the tower. I've gone with Ice Punch, but I'm open to changing it to Fire Punch if persuaded. Its a case of what I fear most, Gliscor, Garchomp, Dragonite and Mence or Forretress and Skarmory

For Battle Tower. I've actually made the team now, what do you think? I'm open to changes, but nothing like Nature or Ev changes. Any other Pokemon suggestions are fine.

Manectric w/Choice Scarf, Static, Timid

252SpA/4SpD/252Spe

Thunderbolt

Thunder Wave

Flamethrower

Switcheroo

I wanted to use a Trick lead different to the norm of Uxie and co. Hes a tad fragile so this may be a problem. In the early stages of the Tower, I'll use him as a Choice Special Sweeper, but as stuff gets much much much harder, I'll use him to Trick off the Scarf

Vaporeon w/Leftovers, Water Absorb, Bold

188HP/252Def/68SpD

Surf

Ice Beam

Wish

Protect

Same old Wish Support Vaporeon. Dependable, solid and annoying to play against. Wish/Protect is one of the best combos ever.

Metagross w/Life Orb, Clear Body, Jolly

60HP/252Atk/196Spe

Agility

Earthquake

Meteor Mash

Ice Punch/Fire Punch

Agiligross. One Agility and this thing can outspeed a lot of things in the tower. I've gone with Ice Punch, but I'm open to changing it to Fire Punch if persuaded. Its a case of what I fear most, Gliscor, Garchomp, Dragonite and Mence or Forretress and Skarmory

Does it work with McDonalds in the UK, or just in the US?