explainations on a bit of code

[gav_69]

Hey Guys,

Can somebody help with some explainations on a bit of code.

Please Login or Register  to view this content.

- what does As long mean

Please Login or Register  to view this content.

Please Login or Register  to view this content.

- can some explain what this mean, i understand the basics of it but not the overall idea of it.

Thanks in advance for any help.
Gav.

[mudraker]

q1
declare a variable named DataEnd as a Long type variable

Please Login or Register  to view this content.

Variables hold information/data that used later within the macro

q2
places a sum furmula in a cell that sums column e from row 6 to 2 rows above the row where the formula is placed

Please Login or Register  to view this content.

e.g
if activecell is e31 the following comand

Please Login or Register  to view this content.

places this formula =SUM($E$6:$E29) in e31

q3

the 2 lines of commands uses 2 different viarables
TotalsRow & DataEnd

finds the last used cell in column k
puts the row number into a variable for later use

Please Login or Register  to view this content.

In the following command DataEnd should hold a row number
e.g If DataEnd has row value 20
Places lookup formula in f6 to f20

Please Login or Register  to view this content.

lookup formula. e.g
if last used row in column K is row 50 then the lookup formula

Please Login or Register  to view this content.

is the same as saying

Please Login or Register  to view this content.