How to assign offset for a variable

[shailaja_prasad]

Hi

I need to count the last row in a col and take that as reference & use offset function, i have done programming like this.
Sub calculation

Please Login or Register  to view this content.

Here it stops at set rng1 command as E count is a number and not cell number. now i dont know how to take the last row & use offset.

Moderators note: code tags added for you - this time

[HaHoBe]

Hi, shailaja_prasad,

welcome to ExcelForums.

Is it by default that both rng1 and rng2 show the same range?

Please Login or Register  to view this content.

The following line of code is showing two faults:

Please Login or Register  to view this content.

A Range-Object should always contain the column identifier and a row number if you do not refer to a column.

Please Login or Register  to view this content.

ECount hasnīt been dimmed nor filled in your code.

Please use Code-Tags for displaying your code as requested by the Forum Rules.

Ciao,
Holger

[WasWodge]

Basic example of how to use LastRow with offset

Please Login or Register  to view this content.

or seeing as you are trying to use WorksheetFunction

Please Login or Register  to view this content.

Edit: Please read the previous post by Holger (posted as I was typing)

[shailaja_prasad]

No rng1 & rng2 are 2 different ranges.

[FDibbins]

shailaja, welcome to the forum

however, Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[HaHoBe]

Hi, shailaja_prasad,

maybe you should ask a Moderator to rework the code in the opening post - thereīs only one opening [ code ] Tag and one closing [ /code ] and not a Code Tag for each and every line of code.

Please Login or Register  to view this content.

looks very much the same to me.

If the range has an even number of entries you can simplify the code to get the last filled line with data. Otherwise this may give a hint on how to solve the issue (only for Column E):

Please Login or Register  to view this content.

I think you defined way too much variables that may be omitted and the code may be simplified and straightened.

Ciao,
Holger