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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Copy Specific Cell & Paste

Status
Not open for further replies.
abitslow

abitslow

Technical User
Apr 25, 2003
44
Hi,
I'm trying to write a macro to look down a list of entries (C2:C2501), count how many are blank (always toward the end) and then turn that range and the coresponding range next to it (D2:Dx) into a scatter graph.
Is this possible?
Many thanks in advance.
matt.
 
Sort by date Sort by votes




Hi,

Why not AutoFilter NonBlanks? The Chart can plot VISIBLE cell only.

Skip,

[glasses] [red][/red]
[tongue]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Copy data between SQL and Oracle 1
Replies
8
Views
1K
remeng
remeng
MattGreer
  • Locked
  • Question
Excel - Copy Filtered Rows from a table to a new blank worksheet
Replies
7
Views
440
combo
combo
MattGreer
  • Locked
  • Question
Add a formula in a cell that refers to another cell... Not using 'Range' tho 2
Replies
8
Views
315
MattGreer
MattGreer
MattGreer
  • Locked
  • Question
Recalculate Radio-Button-Selected VBA Functions When A Cell Is Updated 2
Replies
18
Views
608
strongm
strongm
NaWin55
  • Locked
  • Question
Extract text from ppt table and paste into excel using VBA
Replies
10
Views
686
remeng
remeng

Part and Inventory Search

Sponsor

Back
Top