Hi All,
I have a formula that I need to write in VBA in order to put into an already existing macro. The formula starts in column "AO" on row 3. and it will go until the last row.. right now its row 105.. but it will be longer.
The formula is as follows :
=K3&" "&L3&" "&M3&CHAR(10)&N3&" "&O3&" "&P3&CHAR(10)&Q3&" "&R3&" "&S3&CHAR(10)&T3&" "&U3&" "&V3&CHAR(10)&W3&" "&X3&" "&Y3&CHAR(10)&Z3&" "&AA3&" "&AB3&CHAR(10)&AC3&" "&AD3&" "&AE3&CHAR(10)&AF3&" "&AG3&" "&AH3&CHAR(10)&AI3&" "&AJ3&" "&AK3&CHAR(10)&AL3&" "&AM3&" "&AN3&" "
Basically what the formulat does is it combines system names (text) and their hours spent on a project (numbers). Some of the cells contain "None" as a name or 0s if there is no numbers. The names start at colum K then it has development hours and testing hours for each. colum L and M. then the next application name is in column N.. and its hours are in column O and P.. etc. it goes on until column "AN".
Any help will be appreciated.
Thank you
I have a formula that I need to write in VBA in order to put into an already existing macro. The formula starts in column "AO" on row 3. and it will go until the last row.. right now its row 105.. but it will be longer.
The formula is as follows :
=K3&" "&L3&" "&M3&CHAR(10)&N3&" "&O3&" "&P3&CHAR(10)&Q3&" "&R3&" "&S3&CHAR(10)&T3&" "&U3&" "&V3&CHAR(10)&W3&" "&X3&" "&Y3&CHAR(10)&Z3&" "&AA3&" "&AB3&CHAR(10)&AC3&" "&AD3&" "&AE3&CHAR(10)&AF3&" "&AG3&" "&AH3&CHAR(10)&AI3&" "&AJ3&" "&AK3&CHAR(10)&AL3&" "&AM3&" "&AN3&" "
Basically what the formulat does is it combines system names (text) and their hours spent on a project (numbers). Some of the cells contain "None" as a name or 0s if there is no numbers. The names start at colum K then it has development hours and testing hours for each. colum L and M. then the next application name is in column N.. and its hours are in column O and P.. etc. it goes on until column "AN".
Any help will be appreciated.
Thank you
