Define Excel Range from Access VBA

Hello Experts,

How can I define an Excel range from Access module, also  using Cells(introw, inCol)?
APD TorontoAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
with xlobj
       .range("a2:d10").select
       
end with

or this

with xlobj
       .range("a2:" & chr(64 + intCol) & intRow).select
       
end with
0
 
Rey Obrero (Capricorn1)Commented:
what exactly do you mean?
0
 
APD TorontoAuthor Commented:
Well. I need to change the enterior color of a range and I worry if I do it cell by cell t will take too long to process.
0
All Courses

From novice to tech pro — start learning today.