VBA: Range with variable references. Solved

Question

Hello everyone,I'm having trouble finding a way to use the Range function with variables for rows and columns on the forum. Let me explain: I have Range("A40:A500") in my code, and I want to replace A40 and A500 with variables that I've defined earlier. Let's say my previously defined variables are ColL and LigneL, I want to replace Range(A40:A500) with something like: Range(ColL & LigneL ":" ColL & 500) I’ve tried this in every possible way and different manners but I can’t get it to work! Thanks in advance for your help!! Antoine      Configuration: Windows XP / Internet Explorer 6.0

Migou76 · Accepted Answer

Hello,  Try this:  l1=1 c2=40 l2=1 c2=500  range(cells(l1,c1),cells(l2,c2)).select  Best regards, Migou

Antoine · Answer

Oh not stupid! Thank you very much, I'll give that a try.

Polux31 · Answer

Hello,  Otherwise  Range(ColL & LigneL & ":" & ColL & "500")  ;o) -- "What is well conceived is clearly stated, And the words to say it come easily." Nicolas Boileau

VBA: Range with variable references.

3 answers

The black swift flies for 10 months in a row without interruption

My pc won’t charge anymore and runs super slowly

Laptop: password forgotten

My second pc monitor

My computer stays connected for very little time

Unable to open xsl and xslx files

Pixma ts printer is broken

No internet connection possible

Print a page in the right orientation under windows 11

Change a contact’s ringtone