Posts by luarbiasa

Re: How to find color index from conditional formatting with vba?

rory
I have tried and it works well. thank you very much. :thanx:

Re: How to find color index from conditional formatting with vba?

I can find the color that filled manually not from CF and it works, but if the cell colored by conditional formatting it doesn't work. here is the code:

Sub CCVALUES()


	Range("G1:AK500").Select
	For Each Cell In Selection
	If Cell.Interior.ColorIndex = 15 Then
	Cell.ClearContents
	End If
	Next


End Sub

Re: How to find color index from conditional formatting with vba?

@ rory
would you like to show me how to use it, please?

I want to clear all of the content on the cell that has color index 15 from VBA, I have tried but it can't be found. But if the cell filled color manually (not from conditional formatting) the vba can find it and clear the content from the cells. Please, help me how to find the color index from CF after that clear content automatically.

Re: Auto Fill Down Number List

thanks so much pike and Grimes0332

Re: Auto Fill Down Number List

ok, thanks so much. it works.
=ROW(A1)&"......"

Re: Auto Fill Down Number List

thanks so much

Re: Auto Fill Down Number List

Please, help me. My cell contain number and text.
[TABLE="width: 64"]

[TD="width: 64"]1.…………[/TD]

2.…………

1.…………

2.…………

1.…………

2.…………

1.…………

2.…………

1.…………

2.…………

[/TABLE]

Re: Auto Fill Down Number List

How to fill down my cell contains A1 =1&". …………" or 1. …………?
if just contains 1 it's ok.

Please, help me to get list from range A1 = 1. ........... to range A10 = 10. ................, the result like list number 1 to 10.