Kashmira

program done. It was nice.

seen entire video.

Hi I could do the assignment for this tutorial. Converting celsius to Fahrenheit. I tried to add With Range and it gives me error, object require. Pls advise where my code is wrong. Sub celcius() Dim celcius As Integer Dim Farenhiet As Integer celcius = InputBox("Give me temperature in Celcius") Range("B3").Value = celcius Farenhiet = (celcius * 1.8) + 32 With Range("B4").Value = Farenhiet .Font.Size = 11 .Font.Color = "2367" MsgBox "Farenhiet is" & " " & Farenhiet End With End Sub Without using "With" it works. Do I need to use the Worksheets object. ?

fantastic. looking forward to learn more.

Done filling names in highlighted cell. It was interesting.

The output cell is I10

Done my assignment.

Excited to learn more and implement in my work. You are teaching it very well.

labtop.color="silver" labtop.processor="ryzen"

How can we do combining data from different worksheet in new worksheet within one file ? Is it possible.? I have attached the file. I want only coloured cells from worksheet - call , miss into follow up worksheet. combining data from differennt worksheet.xlsx

This is excellent tool for files in one folder. How can we do combining data from different worksheet in new worksheet within one file ? Is it possible.? I have attached the file. I want only coloured cells from worksheet - call , miss into follow up worksheet. combining data from differennt worksheet.xlsx

hello, I was practicing scenario one - where change cell is unit price. Had a question. If I change the value in one of the unit price, doesnt it change the summary table by itself?

Thanks. Inused this and it worked very welll. Thanks Kashmira