Restricting Characters in a cell.
 

How would I restrict a column to show only 90 characters; even though you may
have 200 characters downloaded from another dbase?

Restricting Characters in a cell.
 

the first step would be

columns(6).ColumnWidth = 90

Then you would need something in each cell in the adjacent column on the
right.

--
Regards,
Tom Ogilvy



"R Bitterman" <R wrote in message
...
How would I restrict a column to show only 90 characters; even though you
may
have 200 characters downloaded from another dbase?

Restricting Characters in a cell.
 

Thanks Tom, but I can only show a maximum of 90 characters of data regardless
of how many characters are downloaded. Our customer then takes the file &
downloads the information into their system. An error message comes back if
their are more than 90 characters.
Ramona

"Tom Ogilvy" wrote:

the first step would be

columns(6).ColumnWidth = 90

Then you would need something in each cell in the adjacent column on the
right.

--
Regards,
Tom Ogilvy



"R Bitterman" <R wrote in message
...
How would I restrict a column to show only 90 characters; even though you
may
have 200 characters downloaded from another dbase?

Restricting Characters in a cell.
 

Then you would have to write a macro to remove the excess characters

for each cell in selection
if len(cell) 90 then
cell.Value = left(cell,90)
end if
Next

--
Regards,
Tom Ogilvy
"R Bitterman" wrote in message
...
Thanks Tom, but I can only show a maximum of 90 characters of data
regardless
of how many characters are downloaded. Our customer then takes the file &
downloads the information into their system. An error message comes back
if
their are more than 90 characters.
Ramona

"Tom Ogilvy" wrote:

the first step would be

columns(6).ColumnWidth = 90

Then you would need something in each cell in the adjacent column on
the
right.

--
Regards,
Tom Ogilvy



"R Bitterman" <R wrote in message
...
How would I restrict a column to show only 90 characters; even though
you
may
have 200 characters downloaded from another dbase?