•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 391,552 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,594 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser:
Views: 4605 | Replies: 3
 |
•
•
Join Date: May 2006
Posts: 39
Reputation: 
Rep Power: 3
Solved Threads: 0
Light Poster
Selection.End(xlDown).Select Good Morning All,
I am having a major issue here; for some reason the line of code below works and sometimes does not work. When it desides not to work, it leaves a mess in my excel sheet.
Please can someone tell me what the problem is? Or is there another code I can use to achieve the same goal?
Ini
I am having a major issue here; for some reason the line of code below works and sometimes does not work. When it desides not to work, it leaves a mess in my excel sheet.
Range("A1").Select ' This just goes to the upper left corner of the sheet
Selection.End(xlDown).Select
' The line of code above is suppose to jump to the last empty row in column A1.
Please can someone tell me what the problem is? Or is there another code I can use to achieve the same goal?
Ini
•
•
Join Date: Dec 2004
Location: Lincoln Park, Michigan
Posts: 1,744
Reputation:
Rep Power: 7
Solved Threads: 107
try doing a msgbox on your xlDown variable, and make sure it has the right value... what happens to the sheet when it messes up?
•
•
Join Date: May 2006
Posts: 39
Reputation:
Rep Power: 3
Solved Threads: 0
Light Poster
What happens is that sometimes when I use the code for it to jump to the last blank row, it would jump and that's fine. But on some cases it would not jump instead it would select A1 as the last row and would start over writing my data's in A3, A4 and so on.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Visual Basic 4 / 5 / 6 Marketplace
Linear Mode
- how to select null values in condition (MySQL)
- Boolean checking (Visual Basic 4 / 5 / 6)
- Sorting a selection (Visual Basic 4 / 5 / 6)
- Program Problem with a select statement to access Data base (C)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Copying selected range from worksheet
- Next Thread: Semi Transparrent Forms
