$$Excel-Macros$$ Regarding Code

ot;E", "T", "TBR/F", "="), Operator:=xlFilterValues Rows("2:2").Select Range(Selection, Selection.End(xlDown)).Select Selection.Delete Shift:=xlUp Selection.AutoFilter Regards Vebhav Jain -- --

Re: $$Excel-Macros$$ Split the column into four columns ** URGENT **

Guru, In the menu bar, Click on *Data - Text to columns - Next, *where you can adjust according to your needs by moving the bar. For further clarifications please get back to me. Regards, Vebhav Jain On Mon, Dec 20, 2010 at 11:52 AM, gurumurthy sastry Kondury < gurumurthy.sas...@gmail.

$$Excel-Macros$$ MACRO's

Hi All, Whats wrong in this code.. Dim Z as long Range("A1").select Z=activecell.row+3 where i need to select the third row from the current row. Thanks, Vebhav Jain -- -- Some important links for e

$$Excel-Macros$$ Missing Entries

Hi All, Please help me in finding the missing entries from the below data. ListAListB 1 1 2 3 3 5 4 5 Regards Vebhav Jain -- -- Some

$$Excel-Macros$$ Rectify this Error

;, Version:=xlPivotTableVersion10). _ CreatePivotTable TableDestination:="Sheet1!R3C1", TableName:="PivotTable1" _ , DefaultVersion:=xlPivotTableVersion10 Thanks, Vebhav Jain -- -- Some i

Re: $$Excel-Macros$$ Error

Dave, Before that i used the concatenate function, so i want to autofill upto the adjacent column. Thanks, Vebhav Jain On Mon, Dec 13, 2010 at 8:32 AM, Dave Bonallack wrote: > Hi Vebhav, > You seem to be trying to autofill a range based on where the range > currently ends. Are you

$$Excel-Macros$$ Error

Hi All, Please help me out in rectifying the below error. Selection.AutoFill Destination:=Range(Cells(2, 8), Cells(Rows.Count, 8).End(xlUp)) Regards Vebhav Jain -- -- Some important links for excel users: 1

Re: $$Excel-Macros$$ Error in Macro Code

.Select > Selection.Cut > Range("B1").Select > ActiveSheet.Paste > Range("E1").Select > Range(Selection, Selection.End(xlDown)).Select > Selection.Cut > Range

Re: $$Excel-Macros$$ Error in Macro Code

Can someone look into this and suggest me. On Tue, Dec 7, 2010 at 10:33 PM, vebhav jain wrote: > Hello, > > Can you please help me in making this code in a standard format, instead of > changing the code daily manually of the highlighted text. Thanks in Advance. > > Sub macro

$$Excel-Macros$$ Error in Macro Code

quot;).Select ActiveSheet.Paste Selection.NumberFormat = "#,##0.00" Range("D25").Select Selection.End(xlDown).Select Range("B2").Select Selection.End(xlDown).Select Z = ActiveCell.Row + 0 Range("B" & Z).Val

$$Excel-Macros$$ Error in Code

Hi All, I am facing error when the range data changes from (B334) and i need to adjust manually the total number, so can you suggest any better way. Thanks, Vebhav -- -- Some important links for excel users: 1.

$$Excel-Macros$$ Attention Please

-- Forwarded message -- From: vebhav jain Date: Thu, Nov 4, 2010 at 2:01 PM Subject: $$Excel-Macros$$ Data Keep Varies To: excel-macros@googlegroups.com Hi All, With the help of macros, i recorded the whole data. The problem is that data keep varying every day and i have to

$$Excel-Macros$$ Data Keep Varies

data on 1st november Next day Column A has 456 data..so i dont want to change the macros data everyday manually. I hope you understood my query. Thanks Vebhav Jain -- -- Some important links for excel users

$$Excel-Macros$$ IF Function

Hi All, Please find the attachment, where i finding the difficulty to get the right solution.I have narrated the problem clearly in the excel file. Thankyou, Vebhav Jain -- -- Some important links for excel users

$$Excel-Macros$$ Need Mentor's Tips

Hi All, I am interested to learn VBA Macros and i know only basics as of now (i.e) Recording. Please can you suggest any books or site which will help me to learn better. Thanks & Regards, Vebhav

$$Excel-Macros$$ Macros

Hiii ... I want to learn the macro functions, so if u have any files regarding basics of macro then plz mail to me. Thanks in Avance Regards vebhav jain