If it’s not a number, it will return False.If IsNumeric thinks your expression is a number, it will return a value of True.This isn’t the first time you’ve seen me use IsNumeric in my VBA macros, but in this tutorial I’ll explain how it’s used and what it’s good for. The IsNumeric VBA function is a counterpart to the Excel ISNUMBER function, but the expressions don’t always produce the same results. The formula will calculate the sum of the values in cells A3 to A5.The IsNumeric VBA function checks if a cell is a number and expresses the answer as a Logical Boolean ( True or False). This code writes the formula =SUM(A3:A5) to cell A6 in the active worksheet. Instead of the range, you are using cells (row no, column no) where row no = 1 for the first row, column no = 1 for column A. Writing to a cell using cells ThisWorkbook.Sheets(1).Cells(1, 1).Value = 'hello' You are directly using sheet1 which is the sheet name here. Writing to a cell using code name Sheet1.Range('A1').Value = 'hello' You can also check the total count of sheets in a workbook using unt Here you are referencing the sheet using the index, which is 1 for sheet1. Writing to a cell using index number of sheet ThisWorkbook.Sheets(1).Range('A1').Value = 'hello' Here 'Sheet1' is the name of the sheet that you have used. Here are following way you can update value in cell: Writing to a cell using worksheet ThisWorkbook.Sheets('Sheet1').Range('A1').Value = 'hello' Now under this module, you can learn how to write any information to a cell say cell A1 of sheet1. It will open the recorded macro as macro1 already created: In this Excel tutorial lesson, I will guide you through the basics of Excel VBA and how you can use Excel VBA to write to a cell in an Excel sheet. How to Write to a Cell in Excel Vba Details

Visual basic for excel cells function