Trying to make a dynamic range in a row

**shoaibaligwl** · 03-02-2018, 06:20 AM

Hi, Happy holi to all of you, I am trying to make a dynamic range for the values in a row. but some how range is not selecting.
Please suggest what i am doing wrong.please refer the attach.....
I AM NEW to VBA

.

Capture.PNG

**Kaper** · 03-02-2018, 06:34 AM

But how do you try to do a dynamic range - in screenshotyou 've shown only some figures. Toi have it all in na range you could do for instance:

Please Login or Register  to view this content.

**shoaibaligwl** · 03-02-2018, 08:46 AM

thanks kaper,
this working perfect
Range(Cells(1, 1), Cells(1, lastrow)).Select

Trying to make a dynamic range in a row

LinkBack

Thread Tools

Rate This Thread

Display

Trying to make a dynamic range in a row

Re: Trying to make a dynamic range in a row

Re: Trying to make a dynamic range in a row

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] assistance to make a vba code run on a dynamic range

Make a range dynamic for edition!

[SOLVED] HOw to make a chart range dynamic

How to make a dynamic range with multiple tables on sheet?

How to make a Chart using a dynamic range?? (Need Macro?)

How should I make a SUMIF w/ dynamic range?

How do you make an open-ended/dynamic range?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions