Click here to Skip to main content
11,482,039 members (64,824 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB 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
balkha7326
Comments
balkha7 at 20-Mar-13 4:21am
   
its Like R1C1 , but Iam new in vba
CHill60 at 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
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  
Comments
CHill60 at 21-Mar-13 20:13pm
   
guess what ... that's my 5 :-)
Maciej Los at 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)



Advertise | Privacy | Mobile
Web04 | 2.8.150520.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