| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieve cell value & format at the same time
Im looping thru a range using two variables that will transfer the outcome
to another sheet. I want to retrieve the cell value and the font format so it carries any bolds. (No paste special...) Variables-loop 1 NameLEG = Sheet1.Cells(RowLEG, 2) & " " & Sheet1.Cells(RowLEG, 3) StreetLEG = Sheet1.Cells(RowLEG, 4) Outcome-loop2 Worksheets("Labels").Cells(LastRowLabel, LastColLabel).Value = NameLEG Worksheets("Labels").Cells(LastRowLabel + 1, LastColLabel).Value = StreetLEG Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
| cell format for date/time in same cell excel 2003 | Excel Worksheet Functions | |||
| Can I retrieve a value and its format using the minimum function? | Excel Worksheet Functions | |||
| Retrieve and update 1 record at a time | Excel Programming | |||
| Test a file to retrieve format | Excel Programming | |||
Threaded Mode
