Cell value as variable in a range statement

[JROG]

First timer. So please excuse the the simpleton.
I wish to copy a selection with the bottom row number linked to a cell value in the active worksheet. My code reads:

Sub test()
'
' test Macro
'
' Keyboard Shortcut: Ctrl+Shift+J
'
Dim ABC As Integer
ABC = Range("AC4").Value
Range("B18:X" & ABC).Select
Selection.Copy
End Sub

I read a lot of previous posts and thought I had it right but I still get [Method 'Range' of object'_Global' failed]. Any help would be greatly appreciated.

[Marcol]

Hi JROG

Welcome to the Forum

Please wrap your code in code tags, before the moderators get you...

Forum rules

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button.

Cheers

[JROG]

REPOST tags. Thanks for the instruction

First timer. So please excuse the the simpleton.
I wish to copy a selection with the bottom row number linked to a cell value in the active worksheet. My code reads:

Please Login or Register  to view this content.

I read a lot of previous posts and thought I had it right but I still get [Method 'Range' of object'_Global' failed]. Any help would be greatly appreciated.

[JROG]

Double please!

[shg]

Try this. If it beeps, the value in AC4 is out of range.

Please Login or Register  to view this content.

[JROG]

Shg,

It beeped. I moved the reference from AC1 to V1 and it worked! Praise VBAllah.

However, I have no idea why the variable needed to be in the same set of columns as the selection range.

Anyway, thank you very much. My excel project has taken a giant step forward.