View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patti Patti is offline
external usenet poster
 
Posts: 45
Default vba newbie - explanation

Thanks Bob & Dave for getting me started off on the right foot!

"patti" wrote:

I am just starting to use vba w/ excel. Could someone perhaps please explain
the following code:

sFilename = Right(Me.Cells(i, "A").Value, Len(Me.Cells(i, "A").Value) -
InStrRev(Me.Cells(i, "A").Value, "_"))


i know that the functions "Right", "Len", "In Str Rev" will become the
sFilename which is called elsewhere; i am befuddled by the (Me.Cells(i,
"A").Value).

thanks for helping me get jumpstarted.

patti