Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 312
  • Last Modified:

Define Excel Range from Access VBA

Hello Experts,

How can I define an Excel range from Access module, also  using Cells(introw, inCol)?
0
APD_Toronto
Asked:
APD_Toronto
  • 2
1 Solution
 
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
 
Rey Obrero (Capricorn1)Commented:
with xlobj
       .range("a2:d10").select
       
end with

or this

with xlobj
       .range("a2:" & chr(64 + intCol) & intRow).select
       
end with
0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now