How to refer a cell of another sheet mentioned in a cell through VBA

Hi,

I think you are looking for code like:
Worksheets("Sheet2").Range("A1")
See:
http://www.quepublishing.com/article...21718&seqNum=5

Hi,

It is*much easier for us to understand your question if you supply a sample workbook. If you could attach a sample, we could get you a much better answer.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi,

Do it like this instead:

Please Login or Register  to view this content.

One small issue, which was not covered earlier by me..sorry for that. If I modify code line as below, it throws an error.

Code Line used by me is : Selection.Copy Destination:=Range(Range("Cells(x,1)"))
Instead of Code Line provided by you : Selection.Copy Destination:=Range(Range("A1"))

I need to do this as I am running a For Loop for column A, which gives me copy destination cells... I have defined x as 1 to N (where N is last row used)..

Any solution???

Try:

Selection.Copy Destination:=Range(Range(Cells(x,1)))

As you*get better at writing VBA, you will stop using the ".Select" and "Selection" statements. Keep learning and practicing.
Read sites like:
http://www.spreadsheet1.com/vba-deve...practices.html
http://dailydoseofexcel.com/archives...-ill-never-do/

Hi,

The equivalent of

Please Login or Register  to view this content.

is actually this

Please Login or Register  to view this content.

and not

Please Login or Register  to view this content.