Jump to content
Business Intelligence & Analytics for Digital Transformation

Kashmira

Members
  • Posts

    22
  • Joined

  • Last visited

  • Days Won

    1

Kashmira last won the day on September 10 2020

Kashmira had the most liked content!

Recent Profile Visitors

442 profile views

Kashmira's Achievements

Newbie

Newbie (1/14)

1

Reputation

  1. 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. ?
  2. Done filling names in highlighted cell. It was interesting.
  3. Excited to learn more and implement in my work. You are teaching it very well.
  4. 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
  5. 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
  6. 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?
  7. Thanks. Inused this and it worked very welll. Thanks Kashmira
×
×
  • Create New...