Hi George,
Can't quite understand your request.
column F down untill we reach two empty cells in columns F and J
But your sample data doesn't have 2 empty cells in both F and J.
Perhaps you could attach a sample workbook with a bit more data - say 20 rows.
Regards - Dave.
Date: Fri, 29 May 2009
Hi TAlgo,
Have a look at the attached. I've included 2 different macros because I wasn't
sure of what you really need.
Hope this points you in the right direction.
Regards - Dave
Guys,
trying to create a macro which will copy column A to column B. This is
simple but only exception I m
Try rhis formula to get the 16 digit number.
CELL B2 :- =TEXT(A2,REPT(0,16))
Then these to get the 4-digit and 12 digit parts.
=LEFT(B2, 4)
=RIGHT(B2, 12)
--~--~-~--~~~---~--~~
hi friends, i am looking for a macro which will read my file name
(saved file where i will run macro) and print a code in given range of
a column, for an example if my file name is test (saved in desktop) is
carring some data in column A, B, and C, i want that my macto add a
column D and reads my
Hi Bala,
Thanks for your help and efforts provided for the below task.
Regards,
Sharma
On Fri, May 29, 2009 at 3:26 PM, bala bal...@gmail.com wrote:
Hi
find the code below
Sub test()
Dim strAddress As String
strAddress = Range(B65536).End(xlUp).Address
Range(B3).Select
While
Hi Harmeet,
This is what i am exactly looking for.
Thanks a lot. Keep rocking.
Regards,
Sharma
On Fri, May 29, 2009 at 8:53 PM, Harmeet Singh harmeet.hew...@gmail.comwrote:
On Fri, May 29, 2009 at 1:23 PM, amrahs k amrahs...@gmail.com wrote:
Hi Harmeet,
I just want a macro for
Hi Dev
Thank you very much.
Regards
Ramesh
On Fri, May 29, 2009 at 11:35 AM, Dev nvdev.i...@gmail.com wrote:
Ramesh - There are multiple ways to accomplish this. But since your
request is to just sum the numbers for the given column, here is the
snippet which is not production ready.
Hi Robin,
I have tried to understand your needs, but cannot.
1. a macro which will read my file name
This we can do.
2. i want that my macto add a
column D and reads my saved file name and put a digit 25 in that D
coulmn in range d1 to d last (till column A, B, C, carries data) ??
This I
Dave is correct,
The wording No Sales in month .. (thus I chose no sales) is part
of the body of the sheet. I can't rely on the person to put the data
in the same spot so I want to search each sheet for that type of
wording somewhere on the sheet itself. Also the values for each sheet
tab
Hi All,
First of all i would do the thanks to all the member those are associated
with this group.
My query is that can we use vlookup, hlookup and lookup function with array
function of EXCEL. if any one now this please send me the excel file with
and example.
i want to learn array function in
Dear All,
Please advise me how to implement user form in excel via VBA.
Please assist me with sample fundamentals of the code.
Regards,
Abdul Hakim Khan
--~--~-~--~~~---~--~~
http://www.contextures.com/xlUserForm01.html
_
There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we know we don't know.
12 matches
Mail list logo
