melewie
Board Regular
- Joined
- Nov 21, 2008
- Messages
- 188
- Office Version
- 365
- Platform
- Windows
Hi all,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I am having trouble with a bit of code. Select the empty cells between to cells.<o></o>
<o></o>
Really struggling to do this. Offset moves the whole selection range! I’m guessing it will be something like this<o></o>
<o></o>
<o></o>
Thanks in advance<o></o>
<o></o>
Lewie<o></o>
<o></o>
I am having trouble with a bit of code. Select the empty cells between to cells.<o></o>
<o></o>
Really struggling to do this. Offset moves the whole selection range! I’m guessing it will be something like this<o></o>
Code:
[/FONT][/COLOR]
[COLOR=black][FONT=Verdana]Range(Selection, Selection.End(xlDown).Row - 1).Select<o:p></o:p>[/FONT][/COLOR]
<o></o>
Thanks in advance<o></o>
<o></o>
Lewie<o></o>