UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Insert A Blank Row Into A Spreadsheet, Access 2016    
 
   
EllenMarie
post Jun 2 2020, 08:38 AM
Post#1



Posts: 234
Joined: 4-August 10



Hello

I have a button on a form which opens an Excel spreadsheet and inserts a few values into the first 3 cells under the first column. I am trying to insert a blank row in between one of the rows containing data. In my example database I have my script writing the values “Line 1”, “Line 2” and “Line 3” into the first 3 cells under the first column. How could I insert a blank row between Line 2 and Line 3?


Thanks

Attached File(s)
Attached File  insert_row.zip ( 22.62K )Number of downloads: 3
 
Go to the top of the page
 
theDBguy
post Jun 2 2020, 09:38 AM
Post#2


UA Moderator
Posts: 78,438
Joined: 19-June 07
From: SunnySandyEggo


Hi. Looking around, I found this syntax:

Range().Row().EntireRow.Insert

Maybe you could give it a try.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
EllenMarie
post Jun 2 2020, 12:54 PM
Post#3



Posts: 234
Joined: 4-August 10



thanks, DB Guy. We'll try it.
Ellen :-)
Go to the top of the page
 
theDBguy
post Jun 2 2020, 01:52 PM
Post#4


UA Moderator
Posts: 78,438
Joined: 19-June 07
From: SunnySandyEggo


Hope it works!

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    2nd July 2020 - 03:58 AM