PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 [106] 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163

  1. Using Share Drive/Point to access Macros
  2. Solved: range
  3. Opening files simultaneously
  4. Autofill Macro from EXCEL to WORD
  5. Renaming the files in all the folders
  6. I need a macro file that could recognize the same rows With similar data and remove t
  7. data from all the html files in an excel
  8. Prefix with "-" sign
  9. Solved: Fully clearing the used range of a worksheet
  10. code error going from xls 2000 to 2007
  11. Solved: Formula For based on blanks
  12. Solved: Count highlighted rows
  13. Change Tracking - possible without custom views?
  14. Need to reference multiple workbooks
  15. Get Key
  16. save as
  17. Solved: combobox populate
  18. VBA codes for skipping cells
  19. Solved: Compile Error of Duplicate Decleration in Current Scope
  20. find duplicates with different data and extract it
  21. Create New Workbook from existing Tab
  22. Solved: Find value, input into a different column
  23. VBA-PERL via .bat
  24. Solved: Importing a .txt file without a user prompt
  25. Multiple Page Print Form
  26. Lots of small queries in a small database - performance problems
  27. Remove string before a certain character
  28. HTML save not working
  29. Help with VBA Excel project please!
  30. Solved: Remember Hidden State
  31. Change font for part of a cell
  32. Combining Multiple Workbooks / Worksheets
  33. Button Image
  34. Solved: save problem
  35. Controlling the number formats in a file
  36. VBA Forms Module Help please.
  37. EnableOutlining problem - It is driving me mad!!
  38. Solved: show very hidden
  39. application not visible flashes
  40. Help with small project for work please
  41. Looking for VBA algorithm for circular references
  42. VBA Excel macros
  43. Create PDF Stopped Working.... Help!
  44. User Form /COMBO BOX 1
  45. Solved: Workbook_Open loop??
  46. Solved: VBA Reference Protected Workbook
  47. Solved: go to vb studio?
  48. Solved: textbox line under the text
  49. Solved: Auto Unique List
  50. Userform to edit records in different sheets
  51. I would like code to show active workbook
  52. Solved: Specifying file location in a cell and referencing to that cell in VBA, ASCII of 0 to
  53. Solved: help with the first program
  54. Avoiding Variants
  55. Excel exported reports have problem
  56. Adding a column to highlight the changes while comparing two version of excel sheet
  57. Solved: Sum if or sumproduct help?!
  58. Solved: values in range
  59. Copying Autofiltered data, pasting all data when autofilter shows no data
  60. Solved: Create dynamic range to use in formula
  61. Hide rows with bold text
  62. Perform action only if mutiple criteria is met
  63. Solved: call windows printers
  64. Sending Email in Excel
  65. VLOOKUP in VBA
  66. Combining mutiple excel files
  67. Copying certain cell on condition
  68. Searching many sheets for data
  69. Using name manager
  70. Solved: displaying certain line of text from notepad
  71. displaying certain line of text from notepad
  72. Trouble with Grouping
  73. Solved: ListBox1.RowSource for visible Rows.
  74. copy cells from one sheet to another
  75. moving folders based on a criteria
  76. Text To Columns VBA
  77. Solved: Form run time
  78. Creating Text Files from excel each row
  79. HOW TO OPEN EXCEL ADD-INS IN TO VIEW CODES
  80. VBA Coding: Font Change
  81. export worksheet to a txt file
  82. Copy rows to new tabs based on value in 1st column
  83. Solved: Cut and Paste cell value between 2columns based on criteria
  84. VBA code for comparing a worksheet with a column and show the result with a color
  85. QR Codes for Excel 2003 XP
  86. insert range of cells if data in column doesn't match
  87. Copy and Paste Problem
  88. Workbook_BeforeSave
  89. Solved: VBA to auto email report
  90. run macro automatically based on criteria in other spreadsheet
  91. Fixed/non volatile date function
  92. Copy between sheets
  93. Solved: average offset rows in a column
  94. Macro to update Sheet2 based on Sheet1
  95. Indentify column references for cells that meet criteria and assign them to variable
  96. Solver VBA reference in non-english Excel
  97. Solved: textbox focus
  98. combobox one last push
  99. create log for entire file
  100. Solved: I have exceeded Excel’s limit of 1048576 rows while importing data from a file
  101. Timeformat Sum Up and Separation Based on Conditions
  102. Cell reference copy in another cell without link and formula
  103. Object required error with VBA rows deleting
  104. Formula solution for repeated search in column
  105. Solved: Copy selected range in autofilter
  106. Insert the name of the worksheet in cell and than link the cell to another worksheet
  107. Count If
  108. Update powerpoint from excel macro
  109. Excel VBA Macro Crashing
  110. Solved: if & vlookup formula : help requried
  111. Disable alert message
  112. pulling data from multiple worksheets
  113. Select Case Function
  114. problem inserting formula with R1C1
  115. Run Time Error 7
  116. UserForm_Terminate
  117. Sub / Function recorder
  118. New project
  119. Spreadsheet data management
  120. Solved: Find and Replace for Time
  121. Do Loop with InputBox and ActiveCell Ref HELP!!
  122. Solved: AutoFill TextBox in UserForm
  123. Highlighting Cell in Variant
  124. Solved: web navigation
  125. looking for an Event that fires when an existing Workbook is opened
  126. Opening Excel file and running macro
  127. How to save filename with -v2 -v3 and so on at the end if file name already exists
  128. Solved: Turning multiple quantities into singles
  129. Referring to excel application
  130. Solved: Trouble looping through ranges with non-adjacent cells
  131. Automating calculations between values on 2 separate worksheets
  132. VBA knowing which cells it has filled?
  133. Combine "if" formula : help required
  134. Bulk Copy / Pasting
  135. Automatically fill cell when data entered in another sheet
  136. Macro crashing excel
  137. Please help me find out the data link of the website
  138. Subtracting Values of Range Variants
  139. Status Bar or Progress Bar
  140. Solved: Concatenation of many cells from another workbook as a “block text”?
  141. Filtering the values and removing the duplicates
  142. Solved: OLECMDID_SAVE or SAVEAS pvain pvaout
  143. Parsing an RFP Word Documnet to Excel
  144. help with code please for arrays
  145. Reset MOST of Worksheet with Macro
  146. Graph in VBA
  147. auto save workbook upon close
  148. Solved: filter bloks
  149. Solved: ChangePivotCache - PivotCaches.Create Problems
  150. How to Loop through columns in an Array and write to a range
  151. Add additional data to word document's bookmark in excel
  152. Solved: Subtotal() generates extra lines
  153. File Copying From/to different Folders
  154. Solved: Downloading File issues - Buffer Length invalid or not enough memory
  155. Text to Excel VBA
  156. How to show save as dailog box
  157. Solved: macro to read a cell and subtract a number?
  158. How can I display a list of folders and files in window?
  159. error when puting more than 1 string
  160. Help on Extract portion of string in the right way
  161. need to help: mid function
  162. Move data from Excel 2007 to Access 2007 using VBA
  163. Copying last value of a column
  164. Impoting excel sheet to new workbook
  165. date help
  166. Solved: If values in row cut/paste
  167. If the selected cell does not have a comment, then insert a comment.
  168. Ways of declaring arrays
  169. Changing Multiple For Each Statements Together with Next - VBA
  170. Solved: leave the ActiveX text box, pressing 'Enter'
  171. Data Feed to Excel using XML from a website
  172. Formating prob
  173. Select dates by current month
  174. first post....
  175. Unable to get the Vlookup property of the WorksheetFunction class
  176. VBA Nested Lookup as a UDF
  177. Solved: VBA count files funtion
  178. Solved: How to repeat a procedure/code a number of times
  179. Solved: Return which control triggered an AfterUpdate event
  180. Autonumbering invoice then saved to another worksheet in the same workbook
  181. HTML Source Code from Safari/Mozilla on mac
  182. Build a tree of called functions / procedures
  183. Adjusting array of values for filtering for actual values in sheet
  184. Saving file
  185. VBA for Updating Pivot Table report filters from a OLAP Cube
  186. Form Display stops at FormName.Show - Why
  187. Solved: Whenever cell is added will be recorded on another sheet with date and time and value
  188. Copy a cell from excel to word and aligning center using VBA
  189. how to make add-in load before workbook
  190. HTML Source from IE
  191. Solved: Delete Rows with Condition
  192. excel 2007 cell context menu question
  193. Solved: Array Not Working
  194. Solved: Get Textbox Value
  195. Help with macro to update text on shapes
  196. Solved: Select the cell with the click of a mouse, and have the result of calculation
  197. Solved: How to get Last Key or Key-Combo Pressed (Not Event)
  198. Solved: Moving files from different source folder to different destination folders
  199. Solved: Parsing Addresses
  200. Help with Macro and Object Variable
  201. Pull info from one Active Workbook and Save in Another
  202. Solved: If wb is open give message
  203. exe
  204. UK National Insurance Number Validation
  205. data conversion
  206. Solved: VBA to create a separate sheet for each month
  207. Right click option menu...specific items
  208. Invoice Processing
  209. Input difference words run difference macro in one textbox
  210. Open XML file in Notepad and delete all "-"es
  211. Solved: Hiding columns
  212. VBA Code to export Excel to OVERWRITE an EXISTING PowerPoint
  213. display worksheet data in user form
  214. Convert sub to function - prompt not appearing in formula bar
  215. Solved: Print pages that contain data
  216. Solved: Increment Formula With If Statement
  217. Boost Macro running speed
  218. group data
  219. Solved: Removing Duplicates for Multiple Columns independently
  220. Solved: Report to collect filtered data from multiple sheets and consolidate
  221. Hide columns based on cell value
  222. Copy from one worksheet and save to another
  223. Solved: Lastrow +
  224. Validating more than one textbox for Null values
  225. Solved: Sum particular data
  226. Solved: Simple VB? Take one file and make many
  227. HTTPS GET REQUEST ***HELP***
  228. Passing variables
  229. VBA code to send excel sheet as PDF
  230. Combining MsgBoxes into one box
  231. Userform limit?
  232. Solved: how to make shipping label with picture
  233. Find 1st Empty Cell in Range
  234. Formating (pivot)
  235. Want to create a variable that references a cell
  236. How to copy and paste the date
  237. Force ontime Macros to run one after another instead of simultaneously
  238. Solved: Move to Next Record
  239. Solved: Moving cell values based on specific criteria
  240. VBA code for Cursor to stay Stationary in one cell
  241. Automatic Calculation when sheet tab clicked
  242. SaveCopyAs not working.
  243. Urgent VBA Debugging help
  244. Concatenate string with itself in a "while" loop
  245. MultiPage in UserForm
  246. How can I change part of my title by referencing a value in a cell?
  247. Create Desktop Shortcut - Change Icon
  248. Flag on birthday calendar
  249. Solved: Macro request: Copy rows that match values in a column of names
  250. excel 2010 windows 7 64 bit hangs fooooorever