I want to select particular cells . Its like got to select every consecutive
3rd cell of a particular column.
Eg: Say column F, I have to select F3, F6, F9...and so on.
I am not sure if we can use macros and range to program this or how to do,
Is it possible to get this way.Pls let me know
Thanks
Vijaya
Hi,
you can try something like:
'---------------------------------------------------
Sub test()
Dim strCol As String, rowStart As Long, rowOffset As Long
Dim rg As Range
Dim lastRow As Long, i As Long
strCol = "F" 'COLUMN
rowStart = 3 'START SELECTION IN tHIS ROW
rowOffset = 3 'SELECT EVERY x ROW
With ActiveSheet
Set rg = .UsedRange.Columns(1) 'determine last row
lastRow = rg.Cells(rg.Cells.Count).Row
Set rg = .Range(strCol & rowStart) 'set initial range
For i = rowStart + rowOffset To lastRow Step rowOffset 'loop
Set rg = Application.Union(rg, .Range(strCol & i))
Next
End With
If rg Is Nothing Then 'no cell
MsgBox "No cell"
Else
rg.Select
End If
End Sub
'-------------------------------------------------------------------
--
Regards,
Sébastien
<http://www.ondemandanalysis.com>
"vijaya" wrote:
> I want to select particular cells . Its like got to select every consecutive
> 3rd cell of a particular column.
>
> Eg: Say column F, I have to select F3, F6, F9...and so on.
>
> I am not sure if we can use macros and range to program this or how to do,
> Is it possible to get this way.Pls let me know
>
> Thanks
> Vijaya
I thought I could copy and paste a formula on to the selected cells, but once
i run the macro, the cells get selected but I could not copy paste it, ihow
can i do this
"vijaya" wrote:
> I want to select particular cells . Its like got to select every consecutive
> 3rd cell of a particular column.
>
> Eg: Say column F, I have to select F3, F6, F9...and so on.
>
> I am not sure if we can use macros and range to program this or how to do,
> Is it possible to get this way.Pls let me know
>
> Thanks
> Vijaya
Not sure what you are trying to accomplish.
If you want to Copy/Paste the cells, you can use the syntax:
RangeOrigin.Copy RangeDestination
eg: copy rg to cells starting in Z10
Rg.Copy ActiveSheet.Range("$Z$10")
--
Regards,
Sébastien
<http://www.ondemandanalysis.com>
"vijaya" wrote:
> I thought I could copy and paste a formula on to the selected cells, but once
> i run the macro, the cells get selected but I could not copy paste it, ihow
> can i do this
>
> "vijaya" wrote:
>
> > I want to select particular cells . Its like got to select every consecutive
> > 3rd cell of a particular column.
> >
> > Eg: Say column F, I have to select F3, F6, F9...and so on.
> >
> > I am not sure if we can use macros and range to program this or how to do,
> > Is it possible to get this way.Pls let me know
> >
> > Thanks
> > Vijaya
Ok, Actually I have a formula which i wanted to paste in every alternate
cell like F3, F5, F7... uptil the data is filled in the rows.
I am not sure how to do this at one step, as I dont want to select all these
non-contiguous cells using ctrl key and then paste the formula. I thought
selecting the cells at once by running a macro and then pasting it could be
done, but it didnt.
"sebastienm" wrote:
> Not sure what you are trying to accomplish.
>
> If you want to Copy/Paste the cells, you can use the syntax:
> RangeOrigin.Copy RangeDestination
> eg: copy rg to cells starting in Z10
> Rg.Copy ActiveSheet.Range("$Z$10")
> --
> Regards,
> Sébastien
> <http://www.ondemandanalysis.com>
>
>
> "vijaya" wrote:
>
> > I thought I could copy and paste a formula on to the selected cells, but once
> > i run the macro, the cells get selected but I could not copy paste it, ihow
> > can i do this
> >
> > "vijaya" wrote:
> >
> > > I want to select particular cells . Its like got to select every consecutive
> > > 3rd cell of a particular column.
> > >
> > > Eg: Say column F, I have to select F3, F6, F9...and so on.
> > >
> > > I am not sure if we can use macros and range to program this or how to do,
> > > Is it possible to get this way.Pls let me know
> > >
> > > Thanks
> > > Vijaya
Hi
I got it I could copy it to multiple selected non contiguous cells
Thanks a lot!!
I appreciate your time and help
"sebastienm" wrote:
> Not sure what you are trying to accomplish.
>
> If you want to Copy/Paste the cells, you can use the syntax:
> RangeOrigin.Copy RangeDestination
> eg: copy rg to cells starting in Z10
> Rg.Copy ActiveSheet.Range("$Z$10")
> --
> Regards,
> Sébastien
> <http://www.ondemandanalysis.com>
>
>
> "vijaya" wrote:
>
> > I thought I could copy and paste a formula on to the selected cells, but once
> > i run the macro, the cells get selected but I could not copy paste it, ihow
> > can i do this
> >
> > "vijaya" wrote:
> >
> > > I want to select particular cells . Its like got to select every consecutive
> > > 3rd cell of a particular column.
> > >
> > > Eg: Say column F, I have to select F3, F6, F9...and so on.
> > >
> > > I am not sure if we can use macros and range to program this or how to do,
> > > Is it possible to get this way.Pls let me know
> > >
> > > Thanks
> > > Vijaya
Just a small Information.
I am a beginner in Excel VBA programming.I want to learn Excel VBA, and
write programs efficiently by myself, Cud u please let me know which book I
can follow .
Thanks
"sebastienm" wrote:
> Not sure what you are trying to accomplish.
>
> If you want to Copy/Paste the cells, you can use the syntax:
> RangeOrigin.Copy RangeDestination
> eg: copy rg to cells starting in Z10
> Rg.Copy ActiveSheet.Range("$Z$10")
> --
> Regards,
> Sébastien
> <http://www.ondemandanalysis.com>
>
>
> "vijaya" wrote:
>
> > I thought I could copy and paste a formula on to the selected cells, but once
> > i run the macro, the cells get selected but I could not copy paste it, ihow
> > can i do this
> >
> > "vijaya" wrote:
> >
> > > I want to select particular cells . Its like got to select every consecutive
> > > 3rd cell of a particular column.
> > >
> > > Eg: Say column F, I have to select F3, F6, F9...and so on.
> > >
> > > I am not sure if we can use macros and range to program this or how to do,
> > > Is it possible to get this way.Pls let me know
> > >
> > > Thanks
> > > Vijaya
There's a book that is very easy to read: John Walkenbach "Excel 2003 Power
Programming With VBA" (http://j-walk.com/ss/books/index.htm). I started with
the xl97 version of this book, then bought the 2k version. I think it's a
good book for both beginers and intermediates, and focused on Excel.
I mostly learn by trying solving people's probelems in newsgroups.
There are also some good advanced book, but i wouldn't start with these ones
(Stephen Bullen "Professional Excel Development.", ...)
I hope this helps
--
Regards,
Sébastien
<http://www.ondemandanalysis.com>
"vijaya" wrote:
> Just a small Information.
>
> I am a beginner in Excel VBA programming.I want to learn Excel VBA, and
> write programs efficiently by myself, Cud u please let me know which book I
> can follow .
>
> Thanks
>
> "sebastienm" wrote:
>
> > Not sure what you are trying to accomplish.
> >
> > If you want to Copy/Paste the cells, you can use the syntax:
> > RangeOrigin.Copy RangeDestination
> > eg: copy rg to cells starting in Z10
> > Rg.Copy ActiveSheet.Range("$Z$10")
> > --
> > Regards,
> > Sébastien
> > <http://www.ondemandanalysis.com>
> >
> >
> > "vijaya" wrote:
> >
> > > I thought I could copy and paste a formula on to the selected cells, but once
> > > i run the macro, the cells get selected but I could not copy paste it, ihow
> > > can i do this
> > >
> > > "vijaya" wrote:
> > >
> > > > I want to select particular cells . Its like got to select every consecutive
> > > > 3rd cell of a particular column.
> > > >
> > > > Eg: Say column F, I have to select F3, F6, F9...and so on.
> > > >
> > > > I am not sure if we can use macros and range to program this or how to do,
> > > > Is it possible to get this way.Pls let me know
> > > >
> > > > Thanks
> > > > Vijaya
Hi,
Iam just wondering if data arranged as in the original list can be shown as
in the result list:
Original List:
A B
In the diamond In the diamond
In the diamond The City
In the diamond Trench
The City
The City
Trench
Result :
A B
In the diamond In the diamond
In the diamond
In the diamond
The City The City
The City
Trench Trench
Is it possible to get like this:
I am just wondering if a logic like this works out, and how can a code be
written, is there any other way to do if not like this
If B=A
B=B (remain the data in B)
Else
Lookup (lookup for that item)
Match (I think only match is fine; it looks for the item returns the
row number)
Next place it in that row, same column B
If no match found: Place it in column B, but last row of A where the item
list is over
Thankyou
"sebastienm" wrote:
> There's a book that is very easy to read: John Walkenbach "Excel 2003 Power
> Programming With VBA" (http://j-walk.com/ss/books/index.htm). I started with
> the xl97 version of this book, then bought the 2k version. I think it's a
> good book for both beginers and intermediates, and focused on Excel.
> I mostly learn by trying solving people's probelems in newsgroups.
> There are also some good advanced book, but i wouldn't start with these ones
> (Stephen Bullen "Professional Excel Development.", ...)
>
> I hope this helps
> --
> Regards,
> Sébastien
> <http://www.ondemandanalysis.com>
>
>
> "vijaya" wrote:
>
> > Just a small Information.
> >
> > I am a beginner in Excel VBA programming.I want to learn Excel VBA, and
> > write programs efficiently by myself, Cud u please let me know which book I
> > can follow .
> >
> > Thanks
> >
> > "sebastienm" wrote:
> >
> > > Not sure what you are trying to accomplish.
> > >
> > > If you want to Copy/Paste the cells, you can use the syntax:
> > > RangeOrigin.Copy RangeDestination
> > > eg: copy rg to cells starting in Z10
> > > Rg.Copy ActiveSheet.Range("$Z$10")
> > > --
> > > Regards,
> > > Sébastien
> > > <http://www.ondemandanalysis.com>
> > >
> > >
> > > "vijaya" wrote:
> > >
> > > > I thought I could copy and paste a formula on to the selected cells, but once
> > > > i run the macro, the cells get selected but I could not copy paste it, ihow
> > > > can i do this
> > > >
> > > > "vijaya" wrote:
> > > >
> > > > > I want to select particular cells . Its like got to select every consecutive
> > > > > 3rd cell of a particular column.
> > > > >
> > > > > Eg: Say column F, I have to select F3, F6, F9...and so on.
> > > > >
> > > > > I am not sure if we can use macros and range to program this or how to do,
> > > > > Is it possible to get this way.Pls let me know
> > > > >
> > > > > Thanks
> > > > > Vijaya
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks