Range of specific cell

[asilocyra]

Hi guys,

Hope you can help me with this.

What i wanted to do is add data to a specific cell, i.e. I want to start inputting data to cell A5 until the last row.

Help me modify this code.

Please Login or Register  to view this content.

[MarvinP]

Hi asilocyra,

It sounds like you want to enter things into a cell and when you press enter the cursor goes to the next cell on the right instead of down. There is a setting in File -> Options -> Advanced -> Edit Options where you can change the direction of the cursor after pressing enter. If this isn't what you want, then keep asking. No VBA needed for this setting.

[asilocyra]

Hi MarvinP,

I've uploaded my workbook, please take a look to see what I mean.
Thank you.

[:) Sixthsense :)]

What i wanted to do is add data to a specific cell, i.e. I want to start inputting data to cell A5 until the last row.

Please make it more descriptive. Unable to understand your requirement from attached file

[asilocyra]

Sorry about that.

From my attached file, after the row count with filled color it puts the Total Count in cell E to last row.
But what I wanted to happen is put the RowCount in Cell A5 until the last row. Does this explains it?
Sorry, I'm not good in explaining.

[bakerman2]

It needs to be

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

[asilocyra]

Tried that but it has an error.
Run time error 1004
Application defined or object defined error

[bakerman2]

Test your own example file.

[MarvinP]

Hi asilocyra,

Color isn't data. If you want to count the number of cells that are colored in each column, you need to have some number or letter in those cells that ARE data that excel can count.

I think I've found a VBA answer for you at:
https://www.ablebits.com/office-addi...y-color-excel/

See if that is the code you are looking for.

[asilocyra]

Test your own example file.

Awww, my bad.
Gonna reupload my work.

[asilocyra]

Test your own example file.

Reuploaded my file.
The "Column Name" shouldn't be in the A4 cell, my bad. Sorry.

[asilocyra]

Hi asilocyra,

Color isn't data. If you want to count the number of cells that are colored in each column, you need to have some number or letter in those cells that ARE data that excel can count.

I think I've found a VBA answer for you at:
https://www.ablebits.com/office-addi...y-color-excel/

See if that is the code you are looking for.

Thanks, appreciated it.
But after reading it not what I wanted to happen.

[bakerman2]

Like this then.

Please Login or Register  to view this content.

[asilocyra]

Wow! Thank you! This saved me!
Added rep already.

[bakerman2]

You're welcome and thanks for rep+.

[AliGW]

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below.

[FDibbins]

double-posted by me