Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Copying rows in EXCEL

Status
Not open for further replies.
Handcopy

Handcopy

Programmer
Joined
Oct 17, 2007
Messages
11
Location
US
Hello, I am using EB to send an email that gets information from excel. For example, i need to send an email that contains every row that has been marked by initials in another column. I want to be able to take only those rows and email them. That would work, or if not i was wondering if i could just send that one sheet.

Thank you in advanced.
 
Sort by date Sort by votes





Hi,

Try using the Excel AutoFilter on the marked columns & copy the CurrentRegion. Just a few statements. No loop.

Skip,

[glasses] When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[tongue]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

CADD6953
  • Locked
  • Question Question
Help needed with syntax/logic in Attachmate macro
2
Replies
26
Views
2K
SkipVought
S
jeaneshe
  • Locked
  • Question Question
How do I select different Excel cells using a variable column loop?
Replies
10
Views
1K
SkipVought
S
dhsd
  • Locked
  • Question Question
VBA code works fine in debug mode but not when I run it
Replies
5
Views
930
SkipVought
S
AlbertShenko
  • Locked
  • Question Question
Excel VBA Not Sending F keys to Attachmate
Replies
15
Views
2K
SkipVought
S
CADD6953
  • Locked
  • Question Question
Macro for Excel to Attachmate and Back Again
2
Replies
34
Views
3K
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top