• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 326
  • Last Modified:

Excel 2007 VBA - Entering same value into a range without using a Loop routine

How can I enter the same string "=f_Increment" into all the cells of range "R_Range" without using a loop routine?

Thanks, --Andres
0
AndresHernando
Asked:
AndresHernando
1 Solution
 
jppintoCommented:
Range("R_Range").Select
Selection.FormulaR1C1 = "=""f_Increment"""
0
 
AndresHernandoAuthor Commented:
Perfect!!!  THANKS jppinto!  --Andres
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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