Hello,
I am beginner in programing in VBA EXCEL and I am looking for a
function which selects only filled cells (not all cells in columns with
empty cells). Or function which doing something like combination of
SHIFT+END+"arrow down".
I can do this by using FOR and ISEmpty function and select cells until
first empty.
But is there easiest way to do something like this.
Thanks for response
Marcin
Hello,
I am beginner in programing in VBA EXCEL and I am looking for a
function which selects only filled cells (not all cells in columns with
empty cells). Or function which doing something like combination of
SHIFT+END+"arrow down".
I can do this by using FOR and ISEmpty function and select cells until
first empty.
But is there easiest way to do something like this.
Thanks for response
Marcin
Hello,
I am beginner in programing in VBA EXCEL and I am looking for a
function which selects only filled cells (not all cells in columns with
empty cells). Or function which doing something like combination of
SHIFT+END+"arrow down".
I can do this by using FOR and ISEmpty function and select cells until
first empty.
But is there easiest way to do something like this.
Thanks for response
Marcin
Hello,
I think undestand you want to know the last cell empty in a column ?
in VBA you can use this :
End_Row_In_Column_A=range("A65536").End(xlup).row+1
But, perhaps in don't undestand well your question ????
My school level is 6th ;o(((((
For French : suis preneur sur tout commentaire, même désobligeant, sur mon
niveau d'Anglais ;o)))))))
surtout pour vérifier si j'ai bien compris la question !
--
Pounet95
on trouve tout ( ou presque ) http://www.excelabo.net/
Conseillé :
http://dj.joss.free.fr/netiquet.htm
(charte, nétiquette, conseils, abréviations, souriettes...)
http://www.excelabo.net/mpfe/connexion.php
(connexion, conseils...)
a écrit dans le message de news:Hello,
I am beginner in programing in VBA EXCEL and I am looking for a
function which selects only filled cells (not all cells in columns with
empty cells). Or function which doing something like combination of
SHIFT+END+"arrow down".
I can do this by using FOR and ISEmpty function and select cells until
first empty.
But is there easiest way to do something like this.
Thanks for response
Marcin
Hello,
I think undestand you want to know the last cell empty in a column ?
in VBA you can use this :
End_Row_In_Column_A=range("A65536").End(xlup).row+1
But, perhaps in don't undestand well your question ????
My school level is 6th ;o(((((
For French : suis preneur sur tout commentaire, même désobligeant, sur mon
niveau d'Anglais ;o)))))))
surtout pour vérifier si j'ai bien compris la question !
--
Pounet95
on trouve tout ( ou presque ) http://www.excelabo.net/
Conseillé :
http://dj.joss.free.fr/netiquet.htm
(charte, nétiquette, conseils, abréviations, souriettes...)
http://www.excelabo.net/mpfe/connexion.php
(connexion, conseils...)
<mar_male@wp.pl> a écrit dans le message de news:
1131443841.066872.216930@o13g2000cwo.googlegroups.com...
Hello,
I am beginner in programing in VBA EXCEL and I am looking for a
function which selects only filled cells (not all cells in columns with
empty cells). Or function which doing something like combination of
SHIFT+END+"arrow down".
I can do this by using FOR and ISEmpty function and select cells until
first empty.
But is there easiest way to do something like this.
Thanks for response
Marcin
Hello,
I think undestand you want to know the last cell empty in a column ?
in VBA you can use this :
End_Row_In_Column_A=range("A65536").End(xlup).row+1
But, perhaps in don't undestand well your question ????
My school level is 6th ;o(((((
For French : suis preneur sur tout commentaire, même désobligeant, sur mon
niveau d'Anglais ;o)))))))
surtout pour vérifier si j'ai bien compris la question !
--
Pounet95
on trouve tout ( ou presque ) http://www.excelabo.net/
Conseillé :
http://dj.joss.free.fr/netiquet.htm
(charte, nétiquette, conseils, abréviations, souriettes...)
http://www.excelabo.net/mpfe/connexion.php
(connexion, conseils...)
a écrit dans le message de news:Hello,
I am beginner in programing in VBA EXCEL and I am looking for a
function which selects only filled cells (not all cells in columns with
empty cells). Or function which doing something like combination of
SHIFT+END+"arrow down".
I can do this by using FOR and ISEmpty function and select cells until
first empty.
But is there easiest way to do something like this.
Thanks for response
Marcin
Hello,
I think undestand you want to know the last cell empty in a column ?
in VBA you can use this :
End_Row_In_Column_A=range("A65536").End(xlup).row+1
But, perhaps in don't undestand well your question ????
My school level is 6th ;o(((((
For French : suis preneur sur tout commentaire, même désobligeant, sur mon
niveau d'Anglais ;o)))))))
surtout pour vérifier si j'ai bien compris la question !
--
Pounet95
on trouve tout ( ou presque ) http://www.excelabo.net/
Conseillé :
http://dj.joss.free.fr/netiquet.htm
(charte, nétiquette, conseils, abréviations, souriettes...)
http://www.excelabo.net/mpfe/connexion.php
(connexion, conseils...)
a écrit dans le message de news:Hello,
I am beginner in programing in VBA EXCEL and I am looking for a
function which selects only filled cells (not all cells in columns with
empty cells). Or function which doing something like combination of
SHIFT+END+"arrow down".
I can do this by using FOR and ISEmpty function and select cells until
first empty.
But is there easiest way to do something like this.
Thanks for response
Marcin
Hello,
I think undestand you want to know the last cell empty in a column ?
in VBA you can use this :
End_Row_In_Column_A=range("A65536").End(xlup).row+1
But, perhaps in don't undestand well your question ????
My school level is 6th ;o(((((
For French : suis preneur sur tout commentaire, même désobligeant, sur mon
niveau d'Anglais ;o)))))))
surtout pour vérifier si j'ai bien compris la question !
--
Pounet95
on trouve tout ( ou presque ) http://www.excelabo.net/
Conseillé :
http://dj.joss.free.fr/netiquet.htm
(charte, nétiquette, conseils, abréviations, souriettes...)
http://www.excelabo.net/mpfe/connexion.php
(connexion, conseils...)
<mar_male@wp.pl> a écrit dans le message de news:
1131443841.066872.216930@o13g2000cwo.googlegroups.com...
Hello,
I am beginner in programing in VBA EXCEL and I am looking for a
function which selects only filled cells (not all cells in columns with
empty cells). Or function which doing something like combination of
SHIFT+END+"arrow down".
I can do this by using FOR and ISEmpty function and select cells until
first empty.
But is there easiest way to do something like this.
Thanks for response
Marcin
Hello,
I think undestand you want to know the last cell empty in a column ?
in VBA you can use this :
End_Row_In_Column_A=range("A65536").End(xlup).row+1
But, perhaps in don't undestand well your question ????
My school level is 6th ;o(((((
For French : suis preneur sur tout commentaire, même désobligeant, sur mon
niveau d'Anglais ;o)))))))
surtout pour vérifier si j'ai bien compris la question !
--
Pounet95
on trouve tout ( ou presque ) http://www.excelabo.net/
Conseillé :
http://dj.joss.free.fr/netiquet.htm
(charte, nétiquette, conseils, abréviations, souriettes...)
http://www.excelabo.net/mpfe/connexion.php
(connexion, conseils...)
a écrit dans le message de news:Hello,
I am beginner in programing in VBA EXCEL and I am looking for a
function which selects only filled cells (not all cells in columns with
empty cells). Or function which doing something like combination of
SHIFT+END+"arrow down".
I can do this by using FOR and ISEmpty function and select cells until
first empty.
But is there easiest way to do something like this.
Thanks for response
Marcin
Hello,
I think undestand you want to know the last cell empty in a column ?
in VBA you can use this :
End_Row_In_Column_A=range("A65536").End(xlup).row+1
But, perhaps in don't undestand well your question ????
My school level is 6th ;o(((((
For French : suis preneur sur tout commentaire, même désobligeant, sur
mon
niveau d'Anglais ;o)))))))
surtout pour vérifier si j'ai bien compris la question !
--
Pounet95
on trouve tout ( ou presque ) http://www.excelabo.net/
Conseillé :
http://dj.joss.free.fr/netiquet.htm
(charte, nétiquette, conseils, abréviations, souriettes...)
http://www.excelabo.net/mpfe/connexion.php
(connexion, conseils...)
a écrit dans le message de news:Hello,
I am beginner in programing in VBA EXCEL and I am looking for a
function which selects only filled cells (not all cells in columns with
empty cells). Or function which doing something like combination of
SHIFT+END+"arrow down".
I can do this by using FOR and ISEmpty function and select cells until
first empty.
But is there easiest way to do something like this.
Thanks for response
Marcin
Hello,
I think undestand you want to know the last cell empty in a column ?
in VBA you can use this :
End_Row_In_Column_A=range("A65536").End(xlup).row+1
But, perhaps in don't undestand well your question ????
My school level is 6th ;o(((((
For French : suis preneur sur tout commentaire, même désobligeant, sur
mon
niveau d'Anglais ;o)))))))
surtout pour vérifier si j'ai bien compris la question !
--
Pounet95
on trouve tout ( ou presque ) http://www.excelabo.net/
Conseillé :
http://dj.joss.free.fr/netiquet.htm
(charte, nétiquette, conseils, abréviations, souriettes...)
http://www.excelabo.net/mpfe/connexion.php
(connexion, conseils...)
<mar_male@wp.pl> a écrit dans le message de news:
1131443841.066872.216930@o13g2000cwo.googlegroups.com...
Hello,
I am beginner in programing in VBA EXCEL and I am looking for a
function which selects only filled cells (not all cells in columns with
empty cells). Or function which doing something like combination of
SHIFT+END+"arrow down".
I can do this by using FOR and ISEmpty function and select cells until
first empty.
But is there easiest way to do something like this.
Thanks for response
Marcin
Hello,
I think undestand you want to know the last cell empty in a column ?
in VBA you can use this :
End_Row_In_Column_A=range("A65536").End(xlup).row+1
But, perhaps in don't undestand well your question ????
My school level is 6th ;o(((((
For French : suis preneur sur tout commentaire, même désobligeant, sur
mon
niveau d'Anglais ;o)))))))
surtout pour vérifier si j'ai bien compris la question !
--
Pounet95
on trouve tout ( ou presque ) http://www.excelabo.net/
Conseillé :
http://dj.joss.free.fr/netiquet.htm
(charte, nétiquette, conseils, abréviations, souriettes...)
http://www.excelabo.net/mpfe/connexion.php
(connexion, conseils...)
a écrit dans le message de news:Hello,
I am beginner in programing in VBA EXCEL and I am looking for a
function which selects only filled cells (not all cells in columns with
empty cells). Or function which doing something like combination of
SHIFT+END+"arrow down".
I can do this by using FOR and ISEmpty function and select cells until
first empty.
But is there easiest way to do something like this.
Thanks for response
Marcin
