Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB.NET 1.0 > Pro VB.NET 2002/2003
|
Pro VB.NET 2002/2003 For advanced Visual Basic coders working .NET version 2002/2003. Beginning-level questions will be redirected to other forums, including Beginning VB.NET.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro VB.NET 2002/2003 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 13th, 2007, 03:49 PM
Registered User
 
Join Date: Dec 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Macro Coding. Dropping down a line...

This sounds easy enough but it's giving me fits, especially since it has been working for years.

I recorded a Macro for the Acctg Dept that breaks down and sorts all the sales data and summarizes the info on separate sheets in a w-book.

99% of the time it works, sometimes it needs to be debugged.

Here's my main issue at the moment.
Keep in mind the data changes everymonth.

Using the data filter in the macro, I sort by Salesman Code, then copy the data over to his Commission sheet, then return and delete the data. That way what is ever is left is Non Commissional Sales and I can then copy that over to a separate sheet.

All has been well since recently.

I have a block of sorted data for a Salesman.
I GOTO (for simplicity sake) to A1.
I use the coding : ActiveCell.Offset(1, 0).Activate
which in the past has neatly dropped down to the first line of "visible" data, then I can C+S+E and copy it over.
Now it doesn't. It drops the cursor down to A2 rather than perhaps the first line of data which starts in A12.

What can I do to accomplish what appears like a simple move?

I'm desperate and our end of month is Dec 21.

Please help,
Mike


 
Old December 13th, 2007, 11:08 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

well.. this doesn't look like anything to do with .net, but the best way to achieve the move to the first row of availible data is: do the drop down manually saving a macro while doing it, and copy the result to your macro.. just go to the colum, press finish -> down and save that macro...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========





Similar Threads
Thread Thread Starter Forum Replies Last Post
calling to xlam macro from macro inside xlsb SteveB Excel VBA 0 June 30th, 2008 06:43 PM
format-number dropping 0 stolte XSLT 1 January 18th, 2008 04:46 PM
Dropping constraints epp_b MySQL 2 September 12th, 2006 09:22 PM
ASP.Net Code Behind & In-Line Coding vinod_pawar1 General .NET 4 October 8th, 2004 02:33 AM
retreive function/Line from macro or function? MikoMax J2EE 0 April 1st, 2004 04:42 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.