update range in For loop

Z

Zack Barresse

Select a cell, press Ctrl + 1, select the Number tab, it will be highlighted
in the left listbox.
 
G

Guest

what is highlighted is general not text.
so, I guess the format of the cells is not set to Text.

Thanks
 
Z

Zack Barresse

You might then try ..

If Clng(Cells(row, col).Value) <> 0 Then
Cells(row, col).Value = 1

... making use of the coerce/long function.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
conditional format based on column statistics and loop over columns 1
count cells with diagonal borders 3
For Next loop 2
Loop from left to the right 5
Remove cell from range 2
Reduce Numbers Down To A Specific Value 1
Code to name numerous ranges 11

Top