Hi
depends on your selection as you use offset for this. try
replacing the line
cell.offset(0,13).Value="EA"
with
cells(cell.row,"N").value = "EA"
-----Original Message-----
Hi, i am using the following code to place the letters EA
in column N
for some reason it places it in colum n o p q r s? Can so
one help
the code am using is
set myrange = Application.Selection
for each cell in myrange
cell.offset(0,13).Value="EA"
Next
---
Message posted from http://www.ExcelForum.com/
.