Posted to microsoft.public.excel.programming

Lolly[_2_] Lolly[_2_] is offline

external usenet poster

Posts: 28

Loops in a range for a more than one ocurrence of samevalue

This is simple macro
I want to create a loop.Write now if I transpose the data it's range
related. I want to make it independent of cell.

Sheets("mntn"). Select
'Range("F14:F25").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("mon").Select
Range("Cn").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=True
Application.CutCopyMode = False

Any help would be appreciated
--
Kittie

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
Do loops	grandfilth	Excel Discussion (Misc queries)	1	November 10th 05 12:00 AM
Do Loops	Sue[_5_]	Excel Programming	1	May 20th 04 07:51 PM
RANGE & NESTED LOOPS	jay dean	Excel Programming	1	January 29th 04 11:43 PM
Non Contiguous range and loops	David	Excel Programming	3	November 3rd 03 01:40 PM
Loops	Tom Ogilvy	Excel Programming	0	July 18th 03 05:20 PM

All times are GMT +1. The time now is 05:53 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us