Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro's
I want to create a macro that will carry out actions on cells below each
other or side by side automatically. I think it is called creating a loop macro but not to sure. At present i have a spread sheet which i input data (copy and paste) from another application. The data is numeric, but when i paste it into excel is thinks its a text entry. I have done all the normal stuff but i have to place the cursor at the end of the data in the cell, press F2 and then backspace. This is the action i would like to run the macro on as i have to do this in every cell. I have create a macro to do this action but it will not allow me to highlight an area and run it for every cell. Can anyone help please??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro's
For Each cell In selection
'do your stuff Next cell -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "148steve" wrote in message ... I want to create a macro that will carry out actions on cells below each other or side by side automatically. I think it is called creating a loop macro but not to sure. At present i have a spread sheet which i input data (copy and paste) from another application. The data is numeric, but when i paste it into excel is thinks its a text entry. I have done all the normal stuff but i have to place the cursor at the end of the data in the cell, press F2 and then backspace. This is the action i would like to run the macro on as i have to do this in every cell. I have create a macro to do this action but it will not allow me to highlight an area and run it for every cell. Can anyone help please??? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro's
Thanks Bob, but i'm a bit of a thicky when it comes to this, can you explain
a bit more simply how i would do this.... Thanks again "Bob Phillips" wrote: For Each cell In selection 'do your stuff Next cell -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "148steve" wrote in message ... I want to create a macro that will carry out actions on cells below each other or side by side automatically. I think it is called creating a loop macro but not to sure. At present i have a spread sheet which i input data (copy and paste) from another application. The data is numeric, but when i paste it into excel is thinks its a text entry. I have done all the normal stuff but i have to place the cursor at the end of the data in the cell, press F2 and then backspace. This is the action i would like to run the macro on as i have to do this in every cell. I have create a macro to do this action but it will not allow me to highlight an area and run it for every cell. Can anyone help please??? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro's
You said that you already had code to do the F2 stuff. Wrap your code in
those two lines, and change references to specific cells/ranges to the cell object variable. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "148steve" wrote in message ... Thanks Bob, but i'm a bit of a thicky when it comes to this, can you explain a bit more simply how i would do this.... Thanks again "Bob Phillips" wrote: For Each cell In selection 'do your stuff Next cell -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "148steve" wrote in message ... I want to create a macro that will carry out actions on cells below each other or side by side automatically. I think it is called creating a loop macro but not to sure. At present i have a spread sheet which i input data (copy and paste) from another application. The data is numeric, but when i paste it into excel is thinks its a text entry. I have done all the normal stuff but i have to place the cursor at the end of the data in the cell, press F2 and then backspace. This is the action i would like to run the macro on as i have to do this in every cell. I have create a macro to do this action but it will not allow me to highlight an area and run it for every cell. Can anyone help please??? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro's
I would Format all to General then copy an empty cell.
Select the data range and EditPaste Special(in place)AddOKEsc That will chnage the text to numbers. No need to F2 and Enter in each cell. BTW.....macros won't record steps or run while you're in Edit mode. Gord Dibben MS Excel MVP On Tue, 14 Nov 2006 07:40:02 -0800, 148steve wrote: I want to create a macro that will carry out actions on cells below each other or side by side automatically. I think it is called creating a loop macro but not to sure. At present i have a spread sheet which i input data (copy and paste) from another application. The data is numeric, but when i paste it into excel is thinks its a text entry. I have done all the normal stuff but i have to place the cursor at the end of the data in the cell, press F2 and then backspace. This is the action i would like to run the macro on as i have to do this in every cell. I have create a macro to do this action but it will not allow me to highlight an area and run it for every cell. Can anyone help please??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting phantom macros | Setting up and Configuration of Excel | |||
Strip workbook of macros, VBA, MS Query, etc. | Excel Discussion (Misc queries) | |||
Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
how do I run excel 4.0 macros on excel 2000 | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Discussion (Misc queries) |