| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
fill a cell with this..
hi all i have to fill cell A20 with ]Sheet1'!$B$999
where 999 is the value of cell A20. if u can describe the right syntax, that will help me a lot !! ty Sub A22() Dim aWB As Workbook Dim aWS As Worksheet Set aWB = ThisWorkbook Set aWS = aWB.Worksheets("Sheet1") aWS.Range("A22") = ]Sheet1'!$B$" & aWS.Range("A20").Value End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Fill Cell Based on Data in a different cell | Excel Discussion (Misc queries) | |||
| remove fill in text from a cell from an unpopulated fill-in cell | Excel Worksheet Functions | |||
| Code to copy cell borders and fill color from one cell to another | Excel Programming | |||
| Cell fill color. Row to match specific cell. | Excel Programming | |||
| Auto-fill cell based on adjacent cell information.. | Excel Worksheet Functions | |||
Threaded Mode
