My New Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

To Bernie Deitrick
From JulianB

If I changed Range("J34") to Range("J32") do I need to change the myCell
Values?
What does myCell Value refer to? For example myCell(1,13)?

Julian
 
Julian,

No, you should not change the myCell(1, 13) part of the code.

The myCell(1,13).Value means to pick up the value from the same row as the
name currently being processed, out of the 13th column (M)

There are many ways to address ranges or cells in Excel. I could have
referred to that cell by using:

myCell.Item(1,13).Value (myCell(1,13) is a shortcut for the Item property)
Worksheets("Balances").Cells(myCell.Row,13).Value
Worksheets("Balances").Range("M" & myCell.Row).Value
myCell.Offset(0,12).Value

The advantage of using myCell is that defined range objects don't require
the worksheet to be identified since they are associated with a specfic
worksheet.

But that's too much for a beginning coder to learn or need to know - just be
happy if you get the code to work.

HTH,
Bernie
MS Excel MVP
 
Julian,

I should also have mentioned that it would have been best to have posted
this latest message in your last thread. Your question doesn't have much
meaning outside of that thread, and I might have missed it where you did
post it.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My New Macro from Bernie 1
Bernie My New Macro 1
Dave My New Macro 8
Auto Record Transfer (2) 7
HELP - coding on Macro! 3
Exclude a range from "0" 4
Changing VBA code to paste values 0
Repeat keystrokes to delete character in column 5

Back
Top