Command "Cells(Rows.Count, A).End(3)(2) = B" means

**macrolearnerkk** · 10-01-2015, 05:49 AM

In excel-macro-vba,

command

Command
"Sheet1.Cells(Sheet1.Rows.Count, A).End(3)(2) = B"
means

**jason.b75** · 10-01-2015, 07:32 AM

Means nothing, looks broken.

**pike** · 10-01-2015, 07:44 AM

it just one of those extras in the synatx
two parts
.End(Direction)
Enumeration
xlToLeft = 1
xlToRight = 2
xlUp = 3
xlDown = 4
and last is the cells.offset( )
(nRows)

Command "Cells(Rows.Count, A).End(3)(2) = B" means

LinkBack

Thread Tools

Rate This Thread

Display

Command "Cells(Rows.Count, A).End(3)(2) = B" means

Re: Command "Cells(Rows.Count, A).End(3)(2) = B" means

Re: Command "Cells(Rows.Count, A).End(3)(2) = B" means

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Count number of rows in a range that contain less than 5 cells with the string "VAC"

[SOLVED] VBA "& Cells(Rows.Count)" problem - copying outside of range

range("e1" & cells(rows.Count,5).end(xlup)).Select

[SOLVED] How to USE """"" cells count """"" change font color

[SOLVED] Count the number of cells over 35 days excluding rows/cells that have a "yes" value

Count Number of Rows with cells that contain "Yes".

Cells(Rows.Count, "b").End(xlUp).Row

Bookmarks

Bookmarks

Posting Permissions