Posted to microsoft.public.excel.misc

Marilyn

external usenet poster

Posts: 211

copy and paste VBA repeats and repeats

Hello
Below is my code. It seems to work but... I keep getting an hour glass
everytime I select A27
I have 7 differenct contracts so I will repeat it using else if
Customer has to be able to alter the range

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Range("e6").Value = "Contract C" Then
Worksheets("Sheet3").Range("A3:D40").Copy Worksheets("Mine").Range("A27")
Range("A27").Select
Else
If Range("e6").Value = "" Then
Range("A27:D64").Value = ""

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
NO REPEATS	HOMER	Charts and Charting in Excel	3	July 11th 08 09:55 PM
No repeats of name in same colum	Headworth	Excel Discussion (Misc queries)	2	June 22nd 08 12:19 PM
Unwanted Repeats	roy.okinawa	Excel Worksheet Functions	10	November 30th 05 01:15 AM
Count repeats	Daniel Bonallack	Excel Worksheet Functions	7	December 10th 04 05:13 PM
no repeats in a column	repeat	Excel Worksheet Functions	2	November 3rd 04 09:36 PM

All times are GMT +1. The time now is 03:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us