Hi, I need to use the Range method for CurrentWorkSheet object to get the NumberFormat property for a specific cell but worksheet object returns null value for some reason. Did anyone else come across this scenario?
Any help/lead is appreciated. Thanks.
PS: in the screenshot, wbJournal variable is a WorkbookApplication object obtained as output from Excel Application Scope activity.