gvilbis
asked on
i have an excel spreadsheet which i made specail paste and when i selecting cell from columns DC or DD or DE the selected cell showing the number but the header toolbar is empty
see print screen attach
why header is empty without value or Formula? what i can do in order to see the formula or value in Toolbar header?
i can tell that those columns DC, DD and DE are copy with paste speicail from other SS with the following VB command line:
Workbooks(wbResult.Name).W orksheets( "Sheet1"). Range("A1: LU" & Workbooks(wbResult.Name).W orksheets( "Sheet1"). Cells(1, 2).CurrentRegion.Rows.Coun t).Copy
ThisWorkbook.Worksheets("S heet1").Ra nge("A1"). PasteSpeci al Paste:=xlPasteAll
ThisWorkbook.Worksheets("S heet1").Ra nge("A1"). PasteSpeci al xlPasteComments
please advice
Thanks
Gvilbis
Master-book-2014-02-17-07.52.11.png
why header is empty without value or Formula? what i can do in order to see the formula or value in Toolbar header?
i can tell that those columns DC, DD and DE are copy with paste speicail from other SS with the following VB command line:
Workbooks(wbResult.Name).W
ThisWorkbook.Worksheets("S
ThisWorkbook.Worksheets("S
please advice
Thanks
Gvilbis
Master-book-2014-02-17-07.52.11.png
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.