View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_23_] Rick Rothstein \(MVP - VB\)[_23_] is offline
external usenet poster
 
Posts: 1
Default Display feet inches and fraction

See inline comments...

When I add the following ........)-1)+((-1)*(MID...... the formula
works.
It was subtracting the fraction from the whole number.


I'm glad you got it sorted out.

Two things I have encountered and cannot find the solution is in the VBA.
If I put text into a cell and erase the text or clear contents, an inch
mark
is left. This cannot be removed unless I am in design mode.


Can you give us an example? Show us what is in the cell and the code you are
using to erase or clear it.

When I try to copy one cell to another I get a popup with Run-time error
'13': Type mismatch. When I click on Debug the line that is highlighted
is
TargetPattern = Target.Value.


Can you show us your code?

Rick