Excel VBA Tutorial - Intro To Cells
Grab the Free VBA Quick Reference Guide
https://chrisjterrell.com/p/getting-s...
Cells are essential if you are looking to learn how to master VBA. In this VBA Tutorial, we look at what Cells are for and what you can do with them.
We also go over some best practices and pitfalls when using Cells
CODE
======================================
Sub WhatTheCell()
Sheets(1).Cells(6, 8).Select
Cells(9, 4).Select
s1 = Cells(9, 4)
MsgBox s1
Cells(10, 5).Select
Cells(10, 5).Font.Bold = True
Sheets("Sheet2").Cells(1, 1) = Sheets("Sheet1").Cells(10, 4)
End Sub
