Excel VBA: Selecting Different Ranges in Loop -

Excel VBA: Selecting Different Ranges in Loop -

i'm trying select 2 different ranges in loop (i.e. first iteration selects 1 range, sec iteration selects range). here's seek @ seeing if simple task selecting 2 ranges 1 after another:

sub selectingtworanges() dim integer dim m integer dim n integer = 1 2 m = * 50 - 48 n = * 50 + 1 range(cells(m, 1), cells(n, 2)).select next end sub

this gives error: "method 'cells' of object '_global' failed"

i've tried before as:

sub selectingtworanges() dim integer dim m integer dim n integer = 1 2 m = * 50 - 48 n = * 50 + 1 range("am:bn").select next end sub

or:

sub selectingtworanges() dim integer dim m integer dim n integer = 1 2 m = * 50 - 48 n = * 50 + 1 range("a$n:b:m").select next end sub

and none of above worked. think problem using loop-dependent variable within strings (which tried avoid using "cells(#, #)..." formation within "range()". i'm stuck.

is possible?

it's you're getting "method 'cells' of object '_global' failed" error because your's cells() method isn't attached object. according post (on method 'range' of object '_global' failed. error in excel-vba), can avoid using "activesheet".

sub selectingtworanges2() dim integer dim m integer dim n integer = 1 2 m = * 50 - 48 n = * 50 + 1 activesheet .range(.cells(m, 1), .cells(n, 2)).select end next end sub

as other examples; you're right. including variable name in string doesn't reference variable @ all. can utilize next format concatenate strings (vba automatically seek convert variable values strings in concatenation)

range("a" & m & ":b" & n).select

personally using cstr() create sure vba converts value string

range("a" & cstr(m) & ":b" & cstr(n)).select

excel vba excel-vba