Thank you Paul, I've got a huge mental block on this type of expression. I
appreciate the help!
On Friday, June 2, 2017 at 11:56:24 AM UTC-4, Paul Schreiner wrote:
>
> Let's say that you have 100 rows of data.
>
> "bottom" ends up being 100.
> so your Rows statement results in:
> Rows(R:100).in
Let's say that you have 100 rows of data. "bottom" ends up being 100.so your
Rows statement results in:Rows(R:100).insert shift:=xldown
I think it needs to beRows(100:100).insert shift:=xldown
so you'd use:Rows(r & ":" & r).Insert Shift:=xlDown
Paul-
“Do all
Hello Partner,
Hope you’re doing great.
Please let me know if you have any suitable profile for the below position.
Position: *Data Architect*
Location: Harrisburg, PA *(LOCALS ONLY)*
Duration: 6-12+ Months Contract
Rate: DOE
*In-Person Interview...!*
*Required Skills:*
12+ years of relevant exp
Trying to insert a blank row between each line. The line starting with:
Rows is getting a type mismatch error.
-
Dim bottom As Integer
Dim r As Integer
bottom = Cells(Rows.Count, "A").End(xlUp).Row
For r = bottom To 2 S
PFA Solved question..
On Thu, Jun 1, 2017 at 7:50 PM, Secret Shot wrote:
> Dear Team,
>
> I have one very large excel table which i made from Raw data, accidentally
> raw data has been deleted and the only option i have is that table to
> convert back in raw data.
>
> Its about my job so pls hel
On Fri, 6/2/17, 'Yu Spain' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.
To: excel-macros@googlegroups.com
Date: Friday, June 2, 2017, 4:22 AM
-
