In Excel, you can check if a range is an integer.

Question

The name basically says it all.

I want to know if there is an instruction like

if (Range1 contains all columns) then do stuff

I want to know this because I need the routine to execute when cutting and pasting strings, and I have other code that works when it is not a whole string.

Answer 1

BruceWayne's suggestions seem logical. You can also check if your Range.EntireRow.Address matches the entire address of the string:

yourRange.EntireRow.Address = Range(yourRange.Cells(1, 1), yourRange.Cells(1, yourRange.Columns.Count)).Address