Click here to Skip to main content
11,922,641 members (56,534 online)
Rate this:
Please Sign up or sign in to vote.
See more: VB MS-Excel
I have a worbook name 'student' it has 1 to 60 sheets. I have selected cell No.B2 of all sheets. I want to change formula in B2 cells of all 1-60 sheets.
The formula in sheet1 cell B2 is =[sub.xlsx]Sheet1!$B$2

in sheet2 the formula should change =[sub.xlsx]Sheet1!$B$3

in sheet3 cell B2 the formula should change =[sub.xlsx]Sheet1!$B$4
in sheet4 cell B2 the formula should change =[sub.xlsx]Sheet1!$B$5
in sheet5 cell B2 the formula should change =[sub.xlsx]Sheet1!$B$6

do this how many sheets in this workbook
its like as link cells i.e press = then enter , but its a boresome work.

a code frovided for this but it was not worked
So plese provide a code or formula

Very Very thanks in Advance
Posted 19-Mar-13 23:19pm
balkha7 20-Mar-13 4:21am
its Like R1C1 , but Iam new in vba
CHill60 20-Mar-13 11:32am
As per my comment to your earlier post - what is the error - what do you mean by it doesn't work???
STOP reposting your question over and over - if someone supplies a solution and there is a problem with it then reply to their comment or solution on your original post

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

CHill60 21-Mar-13 20:13pm
guess what ... that's my 5 :-)
Maciej Los 22-Mar-13 2:35am
Thank you, CHill60 ;)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web04 | 2.8.151125.1 | Last Updated 21 Mar 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100