I am using the following code to tidy a spreadsheet in the automation of a dashboard, adjusting the row height.
where addMe and n are changing variables that move down the sheet as new information is pasted.
Essentially what I want is to do an autofit on the value in the cell that the offset is finding, but it is currently doing the entire row which I don't particularly want it to do. Specifically the text in column A. I really would prefer a method that would enable me to only autofit the row height if the value in the offset cell calls for it, right now it is also autofitting the values in column A that are sometimes larger when I don't want it to.
Thanks.
VBA Code:
addMe.Offset(n, 6).Rows.AutoFit
where addMe and n are changing variables that move down the sheet as new information is pasted.
Essentially what I want is to do an autofit on the value in the cell that the offset is finding, but it is currently doing the entire row which I don't particularly want it to do. Specifically the text in column A. I really would prefer a method that would enable me to only autofit the row height if the value in the offset cell calls for it, right now it is also autofitting the values in column A that are sometimes larger when I don't want it to.
Thanks.