-
Jun 22nd, 2012, 10:15 AM
#1
Thread Starter
Don't Panic!
[RESOLVED] Excel - how to xlUp ?
Hi,
I used to use Range.end(xlUp) to move like pressing End button and up, but via code.
In 2010, xlUp no longer exists. So uh... how do I use the .end properly?
(weirdly all my old code running with the value in xlup still work fine from Access/Excel pre 2010)
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
-
Jun 22nd, 2012, 10:19 AM
#2
Thread Starter
Don't Panic!
Re: [RESOLVED] Excel - how to xlUp ?
Never mind - friday afternoon - I'm working in Powerpoint linking to an Excel so - xlup hasn't been defined (duuuuh!)
Sorry people
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
-
Jun 22nd, 2012, 10:46 AM
#3
Re: [RESOLVED] Excel - how to xlUp ?
do u mean to find last used row? if yes
Code:
Dim LastRow as long
LastRow = Cells(Rows.Count, "A").End(xlup).Row
-
Jul 6th, 2012, 04:52 AM
#4
Thread Starter
Don't Panic!
Re: [RESOLVED] Excel - how to xlUp ?
Yup thats what I was doing - but forgot I am in Powerpoint, so xlup isn't defined (doh!). Works fine - thanks for the assist!
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|