Object variable

[Raju Kumar Singh]

Hi all,

I am bit new to VBA world. I am having one doubt. Is it possible to edit or manipulate a cell data if it consist in a range that is defined as object variable? What I am thinking is if we have a range of cell defined as object variable then we can make changes to that full range of cell not to a particular cell. Please clarify.

 

[footoo]

Provide details of exactly what you want to do.

 

[MrIfOnly]

If I understood your question correctly, the following code should give you the answer you are looking for:

Sub test()
Dim myRange As Range
Set myRange = Worksheets(1).Range("A2:C5")
myRange.Cells(2, 3).Value = "Hello"
myRange.Range("B3").Value = "Goodbye"
End Sub

Regards,

CJ

 

[Raju Kumar Singh]

I am having a range of cell from A1 to D50, in that few of the cells are empty. I want to find out those empty cells and fill in 1>color or 2>any user defined character. These option 1 or 2 should be selected by user. Hoping, this clarify my question.

 

[Raju Kumar Singh]

Thank you!!!! Your code will help me....

 

[MARK858]

Possibly (if your cells are truly empty/blank and not for example "" as a result of formula)...

Sub test1()
    Dim x As String
    If MsgBox("Do you want to insert color?", vbYesNo + vbQuestion) = vbYes Then
        Range("a1:d50").SpecialCells(4).Interior.ColorIndex = 6
        Exit Sub
    Else
        x = InputBox("Please enter a value")
        Range("a1:d50").SpecialCells(4).Value = x
    End If
End Sub