Selection Offset Help

I have a spreadsheet where I need to enter man new formulas. I have written a code to help me in the process to speed things up just a little bit. I think there could be a way to speed things up significantly with a better code.
The code takes the active cell and makes it equal to a formula based on the number written a few columns to the left. Those columns are just numbers that are related to the tab names in my workbook. All the tab names are numbers ranging from 1 to 150. Here is my code:

PHP Code: 

Sub Task()
'ctrl+d
ActiveCell.Value = "='" & ActiveCell.Offset(0, -3) & "'!$B$11"
End Sub 


I want to do the same action but instead of going cell by cell, I want to select a column range and run the macro for many cells at once.

Perhaps you should look at using INDIRECT?

Hi,

Something like this should get you started.

Please Login or Register  to view this content.