tell application "Microsoft Excel"
set x to string value of range "D19:D29"
end tell
set range to text returned of (display dialog "Enter range" default answer "D19:D29")
tell application "Microsoft Excel"
set x to string value of range "\"" & range & "\""
end tell
Cheers,
Craig
once again saved the day!