Debug single line of code

I can't seem to figure out the issue here, I keep getting the Range_Global_failed error. Trying to make this cut/paste code as short as possible:

    Range(Range("A" & count1), Range("A" & Rows.Count).Offset(xlUp)).Cut (Range("A" & count1).Offset(1))

Any suggestions?

That segment of code is the Paste destination. What is the proper way of writing this?

Paste
is missing from the code.

Okay, thank you. My variable (count1) is in a different subroutine. How do I declare it in such a way that it's value can be used in this line of code? (public variable?)

Thanks, wfm007. I found an additional problem to be that my variable count1 (from the previous subroutine) is empty. It should be a positive integer, but once that previous sub ends the value is not retained. How might I allow this subsequent subroutine to access that value?

This might help you

In VBA there are three levels of scope.

Local: the variable is declared inside a Sub or Function, using the Dim or Static keyword and is only availible inside that procedure.


Code:

Sub myRtn()
Dim myVariable as Variant

...
Module-wide: the variable is declared at the beginning of the module with the Dim keyword. it is available ot all procedures in that module, but not to procedures in other modules


Code:

Dim myModVariable as String

Sub myFirstProceedure

...
Public - the variable is declared at the beginning of a normal module with the Public key word. It is avaliable to all procedures is all modules of that project. (Variables declared with Public in Class, Userform and Object code modules have specialized meanings.)


Code:

Public myPublicVariable as String

Sub myFirstProceedure

...
Global is not a VBA reserved word. There are no (uppercase) Global variables in VBA. "global" is a term in the meta-language of programming, not in the programming language VBA

If you trying to access a variable from another sub, you need to declare that variable as global

Wow, exactly what I needed. Thanks a ton AB33