Sub ABCFoundCell()
Dim x As Range
Set x = Cells.Find(What:="ABC", _
After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, _
SearchDirection:=xlNext, MatchCase:=False, _
SearchFormat:=False)
MsgBox "the cell address is : " & x.Address
End Sub
Dear Excel Experts,
Can you please suggest me the code for following task.
My sheet is password protected and Column B is locked. When user try
to enter the data in any cell of column B, I want to open one user
form.
I am comfortable with build the user form. In my user form I have six
TaxtBox, I
I think this is much simple.
after you find the cell write below stement.
a = ActiveCell.Address
if you wanna use that cell u can use like below example.
Range(a).Offset(1, 3).Select
>
>From: ashish koul
>To: excel-macros@googlegroups.com
>Sent: Mon, 24 January, 2011 8:40:37 PM
>Subject: Re: $
Sub Bang()
Dim Rng As Range
Set Rng = Cells(1).CurrentRegion
Rng.Copy
Rng(1).Offset(Rng.Rows.Count + 2, 0).PasteSpecial _
Paste:=xlPasteAll, Transpose:=True
End Sub
On Tue, Jan 25, 2011 at 10:12 AM, Manoj b wrote:
> Hello All,
>
> Please can somebody advise me macros for paste special
can u pls attach a sample file...
Regards,
Manoj Kumar
On Tue, Jan 25, 2011 at 9:05 AM, Susan wrote:
> Hi,
> I’m trying to copy a list from column A2 to A30 (which was created
> using Data Validation), on sheet 2 to column C2 to C30 on sheet 1.
> I’ve tried everything, but error keeps coming b
try this...
Sub Transpose()
'
' Macro Transpose
'
'
Range("A1").Select
Selection.CurrentRegion.Select
Selection.Copy
Selection.End(xlDown).Select
Selection.End(xlDown).Select
Selection.End(xlDown).Select
Range("G1").Select
Selection.PasteSpecial Paste:=xlPasteValu
Hi,
I’m trying to copy a list from column A2 to A30 (which was created
using Data Validation), on sheet 2 to column C2 to C30 on sheet 1.
I’ve tried everything, but error keeps coming back that I ‘can only
copy filtered data to the active sheet’.
Thanks.
Susan
--
---
Hello All,
Please can somebody advise me macros for paste special-transpose wherein i
can just copy the data in horizontal format and paste them in vertical with
a shortcut key.
My data looks something like below in different sheets of same workbook
2009 2008 2007
1.2 0.84 0
Hi Umesh,
I need one more help regarding macro enabled sheets.
As this DAT sheet is uploaded on daily basis and we need to do this activity
daily.
Kindly advice how to add this macro to daily files so that we can run this
macro created by you.
Please provide steps to avoid any error
Hi Umesh,
Thanks for your help.
On 1/23/11, Umesh Dev wrote:
> Hi Vikram,
>
> I hope this would solve your query.
>
> Regards
> Umesh
>
>
> On Sun, Jan 23, 2011 at 11:33 AM, vikram wrote:
>
>> Hi,
>>
>>
>>
>> I need regarding enclosed excel sheet for Duplicate audit for vendors.
>>
>>
>>
>>
Hi you can use the date function with offsset function in your reference
formula for this. For exact formula tell me what's your current cell address
having reference and whats the reference.
On 23-Jan-2011 2:01 PM, "kush sharma" wrote:
> Dear All,
>
> I have a query in which i need your help. Le
Dear Group,
Thanks for all your wonderful contribution. Here are some group facts
consolidated for you :
- Launch date : 19th March 2007
- Group Owner : Ayush Jain - jainayus...@gmail.com
- Total members : 7615+ (as on 24th January)
- Banned members : 695+
- Active MVPs : Dilip P
check the attachement
Function extractdate(x As String)
Dim i, j, k, s, t As Integer
x = x & " "
i = Len(x)
j = InStr(x, "%")
For k = j To i
If IsNumeric(Mid(x, k, 1)) Then
s = k
Exit For
End If
Next k
For k = s + 1 To i
If Mid(x, k, 1) = " " Then
t = k
Exit For
End If
Next k
ex
Select the Column and From Formula tab there is the name manager. [ ] kind
of things are not allowed in naming
On Mon, Jan 24, 2011 at 1:46 PM, airen wrote:
> How do i name a column in Excel 2003. For eg in excel 2007, i have a
> table named table1 having column Item...now i could name use
> tab
Hope this may help you...
Regards,
Manoj Kumar
On Mon, Jan 24, 2011 at 1:04 PM, Chidurala, Shrinivas <
shrinivas.chidur...@citi.com> wrote:
> Dear All,
>
> Please can any one help me to extract date in given securities by way of
> VBA code and formula.
>
> *Security* *Date* REC 07.60% *22
Dear Dharmesh Shah,
find the attachment. it will fulfill your requirement
Regards
Thamu
On Sat, Jan 22, 2011 at 3:06 PM, Rohan Young wrote:
> Hi,
>
> i think it will more helpful to you,
>
> thanks & regards
>
> ROHAN
>
>
> On Sat, Jan 22, 2011 at 2:57 PM, Rohan Young wrote:
>
>> Hi,
>>
>>
How do i name a column in Excel 2003. For eg in excel 2007, i have a
table named table1 having column Item...now i could name use
table1[Item] as name...but unfortunately this convention is not
applicable in Excel 2003...So is there any solution??
--
--
Dear All,
Please can any one help me to extract date in given securities by way of VBA
code and formula.
SecurityDate
REC 07.60% 22JAN13 22-Jan-2013
08.80% STATE BKOF BK&JAIPUR 05SEP11 FD
GAIL INDIA LIMITED
HDFC 0.00% 24AUG12
LIC HOUSING FINANCE 07.50% 10JUN13
Regards,
Shrinivas
-
Hi David,
let me know the fields and how would you want it to be created.
Umesh
On Mon, Jan 24, 2011 at 12:32 AM, DavidG wrote:
> how do i add a file?
>
> On Jan 21, 8:57 pm, DavidG wrote:
> > Hi
> >
> > I am trying to build a system for a hairdressers to manage their
> > contacts and activit
Dear Prakash
Thanks for your solution. but 1 thing is pending if u can solve (i want hide
row number 15 if I select bank of baroda)
Dear Rohan
Thanks to you also, but your solution is giving me the box for only to the
digit 7,8,and 9 but I want box on every number, the same is solved by
prakash
20 matches
Mail list logo
