CODEWITHSUNDEEP
excelvbacount
K17
K17

Reputation: 697

Finding columns count of a range

Below is some Excel VBA code that is supposed to print the column count of the range that is specified in the string. I am getting an error in the Debug.Print section. What am I doing wrong?

Dim val1a As String
val1a = "A1:D1"

Dim Rng1 As Range

Debug.Print Rng1(var1a).Columns.Count  ' error here

Upvotes: 8

Views: 40086

Answers (2)

chris neilsen
chris neilsen

Reputation: 53136

Use

Range(var1a).Columns.Count

Upvotes: 15

Christopher
Christopher

Reputation: 21

The mistake you did was,

you declared 'val1a' but calling 'var1a'.

correct the typo and you'll be able to get that.

Upvotes: 2

Related Questions