Macro to Active Cells Excel

[amecari]

Hi,
I have a column "D" with numbers that I've captured from another program. I need to sum this numbers but for this is necessary active the range.
I try this way using a VBA:

Worksheets("Plan1&quot.activate
For Z = 5 To 88
Range("d5:d88&quot.Select
Range("D" & Z).Activate
but isn't work.
Help me please.
Thanks

 

[GlennUK]

I'm sorry but your posting doesn't make sense to me.

Can you explain what you are trying to do?

Why do you think it is necessary to activate cells to be able to sum them?

Guess: if the cells contain numbers, but are actually text, and summing is not working, then type a 1 into an empty cell, do Edit/Copy of that cell, then select range D588 and do Edit/PasteSpecial/Multiply which will convert text numbers into numeric entries.

Glenn.

 

[amecari]

ok.
Is something like this: I'm using a macro to capture screens from another program and to load into excel . The numbers in the screens is 1.230,45 in the cell is 1230,45. I'd try to format but only works if I active the cell before. Like to click twice or F2. I have a range d5:d88 in 36 worksheets. How I can active the range into worksheets????

 

[GlennUK]

As I said in my previous post ...

"type a 1 into an empty cell, do Edit/Copy of that cell, then select range D588 and do Edit/PasteSpecial/Multiply which will convert text numbers into numeric entries."

Glenn.

 

[Hasit]

I think I understand what you are trying to do. The first thing is that you can name the range prior to loading the data into the range and call it something like "loadeddata". You can then reference "loadeddata" in the code and it would reference d5:d88.

The other option is to do a find/replace manually. If you do not want to do it manually, then you could set up a command such as REPLACE to find and replace the "." after the "1" in your example above with nothing.

Does this help?

 

[amecari]

Thanks a lot GlennUK and Hasit it works very well.