What does .Range(.Cells(1, 16), .Cells(LR, LC)) mean?

[fang603]

Hi,

I have the following code

Please Login or Register  to view this content.

The macro will automatically perform the following actions in “Sheet2” tab:-
i. Sort the full data set by column R in alphabetical order.
ii. Autofill the formulas from column A to column P.
iii. Total up columns N (Taxable), O (Non Taxable), P (Tax and NIC) and Q (Charged Amount (Home Cur)).
iv. Include 2 control checks:-
- Check 1: Total column N (Taxable) + Total column O (Non Taxable) = Total column Q [Charged Amount (Home Cur)]
- Check 2: Total column Q (Charged Amount (Home Cur)) = Total as per E-Expense Report
If the values in “Check 1” and “Check 2” rows (amounts in column Q) do not equal to zero, the font will turn red to remind the preparer the amounts do not tie.


Could anyone please explain to me what does ".Range(.Cells(1, 16)" in row 8 of the above code mean?

I try to change the "16" to other number but it seems like it does not have any effect.

Thanks.

[patel45]

.Range(.Cells(1, 16) is the same of .range("P1")
P is column 16

[fang603]

Hi Patel45,

Great. Thanks for explaining to me.