hi all,
i m very new in Macro Programming.. So anyone can tell me how i can calculate and get the current active cell number ???
thankx in advance
Khurram
hi all,
i m very new in Macro Programming.. So anyone can tell me how i can calculate and get the current active cell number ???
thankx in advance
Khurram
Last edited by mkmirza92; 07-10-2010 at 05:52 AM.
i have some values in A Colum and i want to loop through all the values... Copy all the values one by one and paste these on Sheet3 's A Colum. Sorry this question is not relevant to first one. but my basic question is this one... Sorry for last..... .!
Hi welcome to the forum
Returns the active cell address e.g. $A$2Please Login or Register to view this content.
Returns the active cell value e.g. "Test" or 123Please Login or Register to view this content.
This can also be
Please Login or Register to view this content.
When you Type ActiveCell. in the VBa editor a popup list will appear(after you type "." i.e. dot ) giving you other options
Hope this helps
[EDIT]
This was only intended as a reply to Post #1
Last edited by Marcol; 07-10-2010 at 05:18 AM. Reason: OPs' question has changed.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Hi mkmirza92,
No need to be sorry were here to help; where we can.
Do you need to copy all the values in column A
into the rows of sheet3 column A
ya i need to copy all the values in column A of Sheet3 from Colum A of Sheet1
something like this, maybe?
Please Login or Register to view this content.
or even
Please Login or Register to view this content.
Last edited by pike; 07-10-2010 at 05:26 AM.
As you seem to be doing nothing with your envisaged loop, this code should suffice
Please Login or Register to view this content.
Hope this helps
[EDIT]
Where did all these replies appear from ....
Last edited by Marcol; 07-10-2010 at 05:31 AM. Reason: Browser not refreshing until Post is submitted.
Thankx all for replying...
Last edited by mkmirza92; 07-10-2010 at 05:45 AM.
Hmmm... this is a bit like a fishing trip!
What is your actual problem?
It seems to have deviated a bit from the title of the thread.
mkmirza,
to avoid wasting our time, please state exactly what you need. Don't tag more and more changes on to the same question.
If the value is found in A4 on Sheet 1, where in Sheet3 do you want it to go? The next empty cell or A4 on Sheet3?
i have to search some value like ("2134245 Stream Started") and then copy these values in another sheet and then separate these value(means Separate Numbers 2134245 and String) then Add then add 1000 to this Number.... thats it........ !!!!!!
Numerical Values may be different in each and every time..... !!!!!!
Last edited by mkmirza92; 07-10-2010 at 06:00 AM.
mkmirza92,
I think you're posting in the wrong thread now. You have already started a new one about this issue. Posting clarification here is not helpful.
Why don't you calm down and get a feel for how the forum works? At the moment, you're causing more administrative trouble than it's worth.
Closing this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks