4
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Change all the destination cell
Dear All,
Suppose I have column of data which is linked with column d of another sheet.
Like
'Sheet1!D5
'Sheet1!D6
'Sheet1!D7
'Sheet1!D8
'Sheet1!D9so on.
Now I wan
Hi
Use indirect function.
Rgds//vabs
Sent on my BlackBerry® from Vodafone
-Original Message-
From: chhajersand...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sat, 20 Oct 2012 11:12:54
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Change all the
Dear All,
Suppose I have column of data which is linked with column d of another sheet.
Like
'Sheet1!D5
'Sheet1!D6
'Sheet1!D7
'Sheet1!D8
'Sheet1!D9so on.
Now I want the destination column of entire linked column to be changed to e
like
'Sheet1!e5
'Sheet1!e6
'Sheet1!e7
'Sheet1!e8
'Sheet1!e9...
