David Owen Nunes

I have the following code:

Sub KeepOnlyUnitAllocation()

Dim RowToTest As Long

Sheets("Sheet..").Select

Deletes all row less than specified value up to row 2

(excludes row 1)

For RowToTest = Cells(Rows.Count, 9).End(xlUp).Row To 2 Step -1

With Cells(RowToTest, 9)

If (.Value <> "AMC Charge" Or .Value <> "Unit Allocation") Then

Rows(RowToTest).EntireRow.Delete

End If

End With

Next RowToTest

End Sub

I have a word file, which is opened when I run a macro from an excel file. The file has been deleted by a user.

I made the file "hidden", but it was still deleted.

How can I protect the file from being deleted - without storing it in another location?

I have neutral and live and earth wires extending from the ceiling - however, the light fitting shows N, E, S and L.

I believe the S is switch live.

The directions say that Live is not used for that particular light.

Which wire goes into Switch Live?

I have a list for example:

Red

Green

Blue

Yellow

Orange

All with data in the columns.

I would like to delete all rows which are not Blue and Yellow. In my scenario there would potentially be 2000 rows with 100 colours, but only 20 meeting the criteria.

How can I write a macro to do this?

In reviewing spelling & grammar in my document, I would like to be able to have redundant phrases highlighted - for instance: "Absolutely essential."

Is there a way to show these / add them to the custom dictionary? Or show the correct phrase "essential" as a suggestion?

I have changed from 32 bit to 64 bit windows and now Minecraft won t work.

Where can I source the driver?

I got my girlfriend plastic flowers, but she threw them out of our fifth floor apartment window, because they don't have a smell.

Why don't they grow plastic flowers which have a fragrance?

I'm confused. I went to the bank and they asked me for a pin code. I wasn't aware that I had a pin code.

What will happen if no one can access me? What if my pin code expires?

Got me some curtains ... how to hang them?

Where in the UK are indigenous forests - that are big enough to use for furniture making? Are they sustainable forests?

How long would it take for a drop of water to trickle down from London to (the coast)?

Seriously, where is he? I've been looking everywhere.

This comes from "The Odd Women" by George Gissing

Is there a touch-screen option or short-cut I can use to hang up? The phone is a BB Torch 9800.

I am currently employed as an Agency Worker (UK), however I have been working in the same company for over 2 years. If I were to lose that position, would the Company have to pay some sort of redundancy benefit? Would the agency be liable? Or is there no liability in either circumstance?